Importing Additional Tables

Once you have created a drilling data set in a project, you can add more tables to the data set. Types of tables you can add are:

• Additional interval tables. See Importing Additional Interval Tables.
• Downhole points. See Importing Downhole Points.
• LAS points. See Importing LAS Points.
• Downhole planar data. See Importing Downhole Planar Structural Data.
• Downhole lineations. See Importing Downhole Lineations.

Importing Additional Interval Tables

Interval tables that have not been imported during the drilling data import process can be added to the project at any time. To add an interval table, right-click on the drilling data set in the project tree and select from the options available:

• If the interval table is stored in a file on your computer or a network location, select Import From File > Interval Values. Leapfrog Works will ask you to specify the file location, and then will display the data in the file in the Import Interval window.
• If the interval table is stored in an ODBC database, select Import From ODBC > Interval Values. You will be prompted to select the data source. See Connecting to an ODBC Data Source in the Importing Drilling Data topic.

Columns required are:

• A borehole identifier
• Start/from and end/to depths
• A column of measurements

Select the required columns and assign the data type for each column. Click Finish to import the file, which will appear as a table in the drilling data set.

Importing Downhole Points

To import a set of points on boreholes, right-click on the drilling data set and select Import From File > Point Values or Import From ODBC > Point Values.

When importing from a file, Leapfrog Works will ask you to specify the file location and then will display the data in the file in the Import Depth Points window.

When importing from ODBC, you will first be prompted to select the data source. See Connecting to an ODBC Data Source in the Importing Drilling Data.

Columns required are:

• A borehole identifier
• Depth

Select the required columns and assign the data type for each column. Click Finish to import the file, which will appear as a table in the drilling data set.

Importing LAS Points

LAS points need to be imported separately from other drilling data.

Leapfrog Works imports LAS points down boreholes in LAS 1.2 and LAS 2.0 formats. An imported set of LAS files appears as one object with its associated data columns plus a LAS Boreholes folder that contains a filter for each borehole. Importing the data preserves the metadata from the LAS files, which can be viewed in the Properties window for the LAS points object and in the Properties window for each borehole.

To import LAS points down boreholes, right-click on the drilling data set and select Import From File > LAS Data. Select the files you wish to import and click Open.

Next, the Import LAS Data window will appear. The data displayed in this window is combined from the selected files, with blank and invalid values indicated by “nan”. For example, if a borehole file does not contain columns that are included in other borehole files, those missing columns will be marked as “nan”.

Leapfrog Works expects borehole ID and Depth columns and will attempt to match the data in the files with the expected format. Select the columns to import, then click Finish. The files will be added to the project tree as part of the drilling data set, as described above.

To view LAS points, add the LAS points object to the scene. You can also display individual boreholes by adding their filters to the scene.

LAS File Mapping

The Properties window for LAS Boreholes includes a LAS Mapping tab that shows what data files have been used for the selected borehole:

This is useful when data for a borehole originates in different files.

LAS File Inconsistencies

When importing LAS files, inconsistencies in the files are handled as follows:

• If there are two files with the same curve values at the same depth, the duplicate values will be added to the existing column and flagged as overlapping segments. See Correcting Data Errors in Leapfrog Works for more information about correcting drilling data errors.
• If there are more than two files with the same curve values at the same depth, Leapfrog Works will not be able to import the files. Note the conflicting files shown in the error message and reimport the files, leaving the conflicting files out.
• If there are multiple logs of the same name in the files, Leapfrog Works will not be able to import the data. Edit the LAS file header outside of Leapfrog Works to change the names.

Importing Downhole Planar Structural Data

Downhole structural data needs to be imported separately from other drilling data. To import downhole structural data, right-click on the drilling data set in the project tree and select Import From File > Planar Structural Data or Import From ODBC > Planar Structural Data.

• When importing from a file, Leapfrog Works will ask you to specify the file location and then will display the data in the file in the Import Planar Structural Data window.
• When importing from ODBC, you will first be prompted to select the data source. See Connecting to an ODBC Data Source in the Importing Drilling Data topic.

Leapfrog Works expects columns describing the borehole identifier, the depth and the structural orientation. Structural orientation can be specified using either dip and dip azimuth or alpha and beta.

Match the values in the file to the required column headers, then click Finish to import the file. The table will appear in the drilling data set.

If the structural orientation is specified using alpha and beta, the reference line from which the beta is measured can be the bottom or top of the borehole. When the table is imported, the default setting is Bottom of core. To change this, double-click on the structural data table in the project tree. Next, click on Compatibility to change the Beta reference mark setting to Top of core:

Importing Downhole Lineations

Downhole lineations need to be imported separately from other drilling data. To import downhole lineations, right-click on the drilling data set in the project tree and select Import From File > Lineations or Import From ODBC > Lineations.

• When importing from a file, Leapfrog Works will ask you to specify the file location and then will display the data in the file in the Import Planar Structural Data window.
• When importing from ODBC, you will first be prompted to select the data source. See Connecting to an ODBC Data Source in the Importing Drilling Data topic.

Leapfrog Works expects columns describing the borehole identifier, the depth and the lineation measurements. Both plunge/trend and alpha/beta/gamma measurements are supported.

Match the values in the file to the required column headers, then click Finish to import the file. The table will appear in the drilling data set.