Borehole CSV files

You can import borehole data in .csv files into Geoscience Interpretation. You must follow these guidelines when formatting borehole data .csv files for import.

This page discusses:

General

  • The import operation will import the data types in the following order:-
    • Borehole collars
    • Borehole surveys
    • Borehole samples
  • An import-mapping file is required. See Creating the Import Mapping File for more information.
  • A file containing the borehole collar data is required.
  • Borehole survey and borehole sample files can be imported, but are optional.
  • If you import either a survey or sample data file, you must also import a collar data file. If you do not select a collar data file for import, an error appears.
  • Filenames are not case sensitive.
  • Values that can be converted to a number and have a decimal point are considered numeric values (as opposed to categorical values).
  • Commas are field/column delimiters.
  • Commas cannot be used within alphanumeric values.
  • Leading and trailing spaces and tabs are ignored.
  • Spaces are acceptable within alphanumeric values.
  • No header lines.
  • Any extra columns (not defined in the follow lists) are ignored. No warning occurs.

Parsing

An error is reported if parsing rules are not followed.

  • Any line that does not have all required columns is ignored.
  • Any optional field that is missing is assigned the default value.
    Note: No warning is reported.
  • Any optional field that cannot be read is assigned the default value.
  • Any survey or sample line that references a missing borehole ID is ignored.
  • Where a value is required to be numeric, but is not numeric, the line is ignored.

Borehole Collar Data

The following columns are required in a borehole collar file. If a line is missing a value in a required column, the line is invalid. Each value must be unique.

  • borehole-name
  • collar-x
  • collar-y
  • collar-z

The following columns are optional in a borehole collar file:

  • Azimuth: The value must be numeric. The default value is 0.0.
  • Dip: The value must be numeric. The default value is 0.0.
  • Plunge: The value must be numeric. The default value is 0.0.
  • Horizontal-crs-id
  • Vertical-crs-id
  • max_depth: The value must be numeric. The default value is 0.0.
  • hole-path: Either curved or linear.
  • drill-method
  • drill-date
  • drill-rig-id
  • piezometric-level

The import of borehole collars has the following behavior:

  • If a borehole already exists with the same borehole name, the borehole will be skipped. Otherwise, a new borehole will be created.
  • If a mandatory value is missing from a row, or any value is invalid, or conversion to single precision will result in a loss of information, the row will be skipped, and a warning message will be logged.
  • If the horizontal CRS ID or the vertical CRS ID do not refer to an existing EPSG code, the row will be skipped, and a warning message will be logged.

Borehole Survey Data

The following columns are required in a borehole survey data file:

  • borehole-name: The line of data is invalid without a borehole name. The value must be unique.
  • depth: The value must be numeric.

The following columns are optional in a borehole survey data file:

  • dip: The value must be numeric. The default value is -90.0.
  • azimuth: The value must be numeric. The default value is 0.0.
  • ignore

Import of borehole surveys will have the following behavior:

  • If there is no existing borehole with the same borehole name, the row will be skipped, and a warning message will be logged.
  • If a mandatory value is missing from a row, or any value is invalid, or conversion to single precision will result in a loss of information, the row will be skipped, and a warning message will be logged.
  • If a borehole iteration already exists for the borehole from a previous import, the row will be skipped. Otherwise, if a borehole iteration for the borehole has not been created yet for the current import operation, then a borehole iteration will be created. The survey data will be appended to the new borehole iteration.
  • If a new borehole iteration has already been created for the current import operation, the survey data will be appended to the new borehole iteration.

Borehole Sample Data

The following columns are required in a borehole sample file:

  • borehole-name: The line of data is invalid without a borehole name. The value must be unique.
  • depth-from: The value must be numeric.
  • depth-to: The value must be numeric.
  • sample
  • ignore

The import of borehole sample data has the following behavior:

  • If there is no existing borehole with the same borehole name, the row will be skipped, and a warning message will be logged.
  • If a mandatory value is missing from a row, or any value is invalid, or conversion to single precision will result in a loss of information, the row will be skipped, and a warning message will be logged.
  • If the attribute name or measurement name do not refer to an existing attribute or measurement, a new attribute or measurement will be created.
  • If a borehole iteration already exists for the borehole from a previous import, the row will be skipped. Otherwise, if a borehole iteration for the borehole has not been created yet for the current import operation, then a borehole iteration will be created. The attribute value data will be appended to the new borehole iteration.
  • If a new borehole iteration has already been created for the current import operation, the attribute value data will be appended to the new borehole iteration.

Structural data

The following datatypes are supported in a structural data file:

  • Numerical structural data
    • Depth (float)
    • Dip (float)
    • Dip direction (float)
    • Azimuth (float)
    • Alpha (float)
    • Beta (float)
    • Beta reference (float)
    • Value (float)
  • Categorical structural data
    • Depth (float)
    • Dip (float)
    • Dip direction (float)
    • Azimuth (float)
    • Alpha (float)
    • Beta (float)
    • Beta reference (float)
    • Value (string)

The following columns are required in a structural data file:

  • Borehole-name
  • Depth
  • Structure

The following columns are optional in a structural data file:

  • Dip
  • Dip-direction
  • Azimuth
  • Alpha
  • Beta
  • Beta-reference
  • Ignore

The import of structural data has the following behavior:

  • If there is no existing borehole with the same borehole name, the row will be skipped, and a warning message will be logged.
  • If a mandatory value is missing from a row, or any value is invalid, or conversion to single precision will result in a loss of information, the row will be skipped, and a warning message will be logged.
  • If the attribute name or measurement name do not refer to an existing attribute or measurement, a new attribute or measurement will be created.
  • If a borehole iteration already exists for the borehole from a previous import, the row will be skipped. Otherwise, if a borehole iteration for the borehole has not been created yet for the current import operation, then a borehole iteration will be created. The attribute value data will be appended to the new borehole iteration.
  • If a new borehole iteration has already been created for the current import operation, the attribute value data will be appended to the new borehole iteration.