Creating the Import Mapping File

Before your borehole CSV files can be imported into Geoscience Interpretation the data needs to be mapped.

Before you begin:
  1. Create an XML file in a text editor. <?xml version="1.0" encoding="UTF-8"?>
  2. Add the import-mapping root element and the current version. <import-mapping version="1.0">
  3. Define the required borehole collar mapping using the borehole-collar-mapping element. Add the filename of the borehole collar data file, default horizontal and vertical CRS ID. Only ESPG codes are supported. <borehole-collar-mapping file-name="collar.csv" default-horizontal-crs-id="EPSG:1234" default-vertical-crs-id="EPSG:4321">
    1. Define the mapping for the borehole name. <borehole-name column="1"/>
    2. Define the mapping for the borehole collar x, y, and z coordinates. <collar-x column="2"/> <collar-y column="3"/> <collar-z column="4"/>
    3. Define the mapping for the borehole collar azimuth. <collar-azimuth column="5"/>
    4. Define the mapping for the borehole collar dip and plunge. <collar-dip column="6"/> <collar-plunge column="7"/>
    5. Define the mapping for the ID of an existing horizontal or vertical CRS to associate with the borehole collar. <horizontal-crs-id column="8"/> <vertical-crs-id column="9"/>
    6. Define the mapping for the borehole maximum depth. <max-depth column="10"/>
    7. Define the mapping for the borehole path type. <hole-path column="11"/>
    8. Define the mapping for the borehole drill method, drill date, and drill rig ID. <drill-method column="12"/> <drill-date column="13"/> <drill-rig-id column="14"/>
    9. Define the mapping for the borehole piezometric level. <piezometric-level column="15"/>
  4. Define the required borehole survey mapping using the borehole-survey-mapping element. Add the filename of the borehole survey data file. <borehole-survey-mapping file-name="survey.csv">
    1. Define the mapping for the filename. <borehole-name column="1"/>
    2. Define the mapping for the borehole survey depth. <depth column="2"/>
    3. Define the mapping for the borehole survey dip. <dip column="3"/>
    4. Define the mapping for the borehole survey azimuth. <azimuth column="4"/>
  5. Define the required borehole sample mapping using the borehole-sample-mapping element. Add the filename of the borehole sample data file. <borehole-sample-mapping file-name="lithology.csv">
    1. Define the mapping for the filename. <borehole-name column="1"/>
    2. Define the mapping for the borehole sample from. <depth-from column="2"/>
    3. Define the mapping for the borehole sample to. <depth-to column="3"/>
    4. Define the mapping for the borehole sample, including the sample column number; the sample data type, which can be either categorical or numerical; the name of an existing attribute to associate with the borehole sample data; the name of an existing measurement to associate with the borehole sample data; and, optionally, define the unit of measurement. <sample column="4" data-type="categorical" attribute-name="a4" measurement-name="m4"/>
  6. Save the XML file.

Import your import mapping file into Geoscience Interpretation along with your borehole CSV files.