Boreholes in AGS format may also include a Project ID column that can be used to identify boreholes that have the same hole ID but are actually from different projects. Group by category and Group by numeric item provide further options for the table organisation. Here the Group by numeric item option has been selected: When a project is first created, the only options available via the Drillhole Data folder are for importing data. See Importing Drillhole Data for more information on these options. The Show trace lines button ( ) in the shape list displays all trace lines, even if there is no data defined for some intervals. The Filter trace lines option in the shape properties panel displays only trace lines for drillholes selected by a query filter. See the Query Filters topic for more information. Displaying Drillholes as Lines or Cylinders Viewing statistical information about objects helps you to analyse your data. This is described further below.

Downhole numeric data can be displayed in the scene as a bar graph and downhole points data can be displayed as a line graph. To display downhole data in this way, add the Drillhole Graphs object ( ) to the scene. The Drillhole Graph Style Manager will be displayed, showing the data columns available: In addition to the imported drillhole tables, the Drillholes object also has two objects that help in visualising and analysing drillhole data. These are: The bottom left corner of the chart displays a table with a comprehensive set of statistical measures for the data set.The Copy button ( ) copies the selected rows to the clipboard so you can paste them into another application. The basic part of the investigation will reveal a number sequence but can you find the rule for the nth term? The investigation can be extended with unequal numbers of blue and green frogs or different numbers of lily pads. " Import the features as separate objects. Each feature will appear in the project tree as a separate object.

Once data has been added to the project, a Drillholes object will be created that serves as a container for the tables imported: Quantile-Quantile plots are useful for validating your assumptions about the nature of distributions of data. Select the data columns to show on the X Axis and Y Axis (which can optionally be set as log scales). You can also select an X filter and/or Y filter to limit the values used from the data columns. When using the spheres option ( ), the points can be displayed using the values. To do this, the Radius values list displays the columns available: The rest of this topic discusses the data format required for importing borehole data. It is divided into:

Viewing drillhole data in the scene is an important part of refining drillhole data and building a geological model. Therefore, Leapfrog Geo has a number of different tools for displaying drillhole data that can help in making drillhole data processing and modelling decisions. Display drillhole data in the scene by dragging the Drillholes object into the scene. You can also drag individual tables into the scene. By default, the limits of the chart are automatically set to range between zero and the upper limit of the variable data. You can adjust this by turning off Automatic X axis limits and/or Automatic Y axis limits and specifying preferred minimum and maximum values for each axis.

There are several different visualisation options. Histogram shows a probability density function for the values, and Cumulative Histogram shows a cumulative distribution function for the values as a line graph: At least one interval table, containing information on measurements such as lithology, date or any numeric or textual values. An interval table must also include collar IDs that correspond to those in the collar table and sample start and end depth. Scatter plots are useful for understanding relationships between two variables. An additional variable can be introduced by setting the Colouring option to a data column. The example below plots the two variables lead and zinc against each other, with gold being indicated by the colouring. You can make either axis a log scale with the Log scale in X and Log scale in Y options. A Query filter may be applied also. Select Cumulative histogram and enable Histogram of the log to see a cumulative distribution function for the values with a log scale X-axis. If a borehole ID in an interval table does not correspond to one in the collar table, the table can still be imported but the interval table will contain errors.As with drillholes, points data can be displayed as flat points or as spheres. When Make points solid button ( ) is enabled for points data, the data points are displayed as spheres. Here, the values are displayed as flat points: You can display drillholes as lines or cylinders. You can also display the data associated with each segment. Here, the drillholes are displayed as flat lines: Show conditional expectation plots a line that attempts to find the expected value of one variable given the other. The X axis is divided into a number of bins specified by Bin count, and the data in each bin is used to predict the expected Y value. When the Make lines solid button ( ) is enabled, the drillhole data is displayed as cylinders and the property that can be controlled is the Line radius: The rest of this topic describes the different statistics visualisations available in Leapfrog Geo. Statistics

With the drillhole correlation tool, you can view and compare selected drillholes in a 2D view. You can then create interpretation tables in which you can assign and adjust intervals and create new intervals. Interpretation tables are like any other interval table in a project and can be used to create models. Only one group can be selected, and typically the GEOL table contains the lithology data. However, if you need to import more groups, there are two options: Boreholes in AGS format may also include a Project ID column that can be used to identify boreholes that have the same hole ID but are actually from different projects. The Survey Table Once the data source is selected, the import process is similar to that described above. Reloading Points Data For each type of table, a summary of the relevant data in the file is presented, allowing you to select groups of data. The Collar TableSelected points can be filtered in the scene by selecting the scatter plot from the Query filter options in the shape properties panel. Drillhole data forms the basis for creating models in Leapfrog Geo. Because drillhole data often contains errors that reduce the reliability of a model, Leapfrog Geo has tools that help you to identify and correct errors and work with the data. Leapfrog Works expects a 0 for a normal hole and a 1 for a trench. If there is no trench column in the collar table, Leapfrog Works will create one. You can filter the data using any Query filter defined for the data table. Statistics for interval tables can be unweighted or weighted by interval length. Verification. It is always a good idea to verify the data using any available additional data. For example, if you’re working with drilling data, you could verify it using geophysical data. This is especially important when working with historic data, which may be less accurate and of lower quality compared to data collecting using contemporary techniques.