Recently released, Leapfrog Geo 4.5 is all about usability and workflow enhancements. Continuing with this theme, we asked our local support teams to share their favorite tips and tricks that will save you time and further improve your experience with Leapfrog Geo.
1. Lost your slicer when editing 2D polylines? Set the slicer to the selected 2D line.
Have you drawn a 2D line that you now need to go back and edit, but you can’t remember how your slicer was positioned?
To go back to the original slicer orientation to edit the polyline without moving any of the nodes off-slice, double-click the line to select it, then click the ‘Set the slicer to the selected 2D line’ button in the toolbar. Alternatively, you could use the keyboard shortcut Shift+W. This will open up the slicer (or reposition the slicer if it was already open) so it is aligned to the polyline. You can now move the nodes or line segments without pulling them off the slicer plane.
Note: This feature only works for 2D lines that were drawn on a slicer plane. The button is greyed out for 3D lines that were drawn directly onto objects.
2. Flexible ways to update your data with the Reload, Append & Import Column tools.
Do you need to update your data with the newest version, or are you looking to add to your existing data? You can choose to either ‘Reload’, which will replace all data with the reloaded table, or to ‘Append’ or ‘Import Column’, when new data needs to be integrated into the table.
Reloading data is necessary to keep your imported data up-to-date. All drillhole data can be reloaded by right-clicking on the Drillholes object and selecting Reload Drillholes. If you only need to reload a single table, right-click on that table and select Reload Data. When you reload data, Leapfrog Geo retains the table structure and refreshes the data contained in the tables. This ensures that you do not need to reassign the data type for each column and select the columns to be imported. However, to successfully reload your data you must make sure that the reloaded table structure matches that of the original table.
Appending data will add more rows to the end of your table. This can come in the form of new HoleIDs for your drillhole data, or extra drilled length of existing drillholes, or differently drilled holes stored in other files. To do this, right-click on the Drillholes object and select Append Drillholes, or right-click in an individual table and select Append Data.
Import Column will add more columns to your data table. It is not essential to import all of the data from your tables in order to model in Leapfrog. As your project evolves, you may find it necessary to bring other columns from your imported data into Leapfrog, and this is where the Import Column functionality is very helpful. Right click on a specific drillhole table and select ‘Import Column’ to bring in extra Category, Numeric, URL, Text etc columns that you need.
The Reload, Append & Import Column processes are similar to importing drillhole data.
- If the data was loaded from a file on your computer or a network location, you will be prompted to specify the file locations. To Append Data you will need to step through the files, checking the Column Summary for each file to ensure that the correct information will be imported, then click Finish to add the new files.
- If the interval table is stored in an ODBC database or an acQuire database, you will be prompted to connect to the database.
- These options are also available for point and structural data tables.
3. Use the Drillhole Correlation Tool to view your data tables and drillholes side-by-side.
Do you have problems making correlations when data is badly integrated? It is often hard to see multiple tables at the same time. The Drillhole correlation tool allows you to view and compare many columns and drillholes in a 2D view.
Firstly, you will need to create a new Drillhole Set that contains the drillholes you are interested in comparing. You can do this by Selecting Collars individually in the scene (1), or by slicing the scene and clicking ‘Select all visible collars’ (2) (Ctrl+A).
This Drillhole set will allow you to see the drillholes you have selected in a 2D view. Drag the Drillhole columns into the Drillhole Set to see them. You can overlay downhole point data with interval data to aid your correlation. This tool is also a great way to correlate any groups/splits/interval selections with your numeric data.
4. Use the Modulo (%) operation to thin down big data tables.
Did you know the % symbol has two functions in Leapfrog Geo? The first is quite well known. You can use the % symbol as the wildcard value in the Query Filter. For example, HoleID LIKE EX19% will return any hole names that begin with EX19 and are followed by any other character.
A function that is less commonly known is the % symbol serving as an arithmetic ‘modulo’ operation. A modulo operation finds the remainder after dividing one value by another (sometimes called the ‘modulus’).
Let’s take two non-zero or non-negative values: A (the dividend), and B (the divisor). The remainder of A/B is known as N, the modulo (also referred to as ‘Mod N’). This operation will therefore produce the remainder, rather than the actual integer quotient.
This modulo operation is particularly handy when trying to thin out large datasets. For example, say you only want to keep every 5th, 10th, or even 50th (etc.,) point. Using the modulo operation ID%5=0, a Leapfrog query filter will select out only every 5th value. Each row in an object’s table has a unique ID, and this operation divides each row ID by the designated value (5, in this example) and will keep values with a remainder of 0.
Note: Don’t be tempted to use this query for topography! We recommend using a Triangulated Mesh’s Error Threshold to simplify large topographic data sets by removing points that do not significantly contribute to the shape of the surface.
5. Use the Interpretation Table to help refine your lithologies and create a flexible lithology table.
Interpretation Tables are found in the Drillhole Correlation tool. They allow you to choose between creating your own interval table from scratch and copying your table from an existing column.
Often you arrive at modelling stage and realise you have based your surface on an interval that needs some refinement. Interpretation tables give you the flexibility to move interval boundaries and even add new lithologies.
A great tip is to create an interpretation table at the very beginning and base it on the lithology column you plan on using for the Geological Model. Then when you come to modelling and you notice that a mis-logged interval has been included it is very easy to edit your table.
In the Drillhole Set (see #5 for how to create one) click to make a New Interpretation and choose a Source Column. Select for the initial data to be ‘All Intervals’ so that you can edit an existing table.
Re-define interval boundaries
Now you have your original table (cfnc) and a secondary Interpretation Table. The original table contains a break in the LOW interval, but with a click and a drag of the interval boundary you can fill this gap.
Add new lithologies
Instead of using an interval selection in the scene to assign new lithologies, why not try and use the interpretation table? By right-clicking on a segment you can Assign Interval to a lithology. If you want to use a new lithology, then simply click ‘Add’ and type your new category. The interval will then be assigned to the new category, or you can choose an existing lithology if one already exists.
Choose this Interpretation as the input to your Geological Model. Then if you need to refine any more the changes will be reflected in your model.
6. Category composites – assist in cleaning messy data.
Using a Category Composite may be helpful when trying to simplify messy logged data. The composites are already a part of the surface generation but in many cases are overlooked. By creating a Category Composite table in the Drillholes > Composites folder you gain flexibility over the settings and the composite is not tied to a specific Geological Model. Category Composites can also be used as inputs to other tasks such as Interval selection.
It is not uncommon to be working with core data of an inconsistent nature. Often in the data tables you want to simplify the data by removing shorter and/or longer segments so the functions in Leapfrog work more efficiently towards your intended results. In a modelling environment, a logged length of 10cm or less may be deemed unimportant. Category Composites allow you to quickly refine these segments before moving forward with the modelling.
In the following example, the initial values we are interested in are Magenta.
The first surface is generated using an intrusion surface:
A categorical composite is created using individual settings for internal (red) and external (blue) intervals:
A second surface is generated using the same surface resolution with the pre-composited intervals:
The next step is to create individual unit codes using the interval selection tool. From here you could continue working with interval selections and build veins, for example. This is similar, but not the same,as grouping lithologies.