Import Mapping File Elements and Attributes

The import mapping file required by the Import REST API must have the following schema.

Root Element import-mapping
Attributes

Attribute Description
version Import mapping file schema version number.

Elements

Element Cardinality Description
borehole-collar-mapping 0-1 Mapping for the borehole collars.
borehole-survey-mapping 0-1 Mapping for the borehole surveys.
borehole-sample-mapping 0-N Mapping for the borehole samples.

Root Element borehole-collar-mapping
Attributes

Attribute Description
file-name Name of the file (including the file extension) containing the borehole collars.
delimiter Character to use as the delimiter (default is comma).
header Boolean indicating whether the file contains a header row or not (default is false).
default-horizontal-crs-id Default horizontal CRS ID to associate with borehole collars that don’t have a mapping for horizontal CRS ID. Currently, only EPSG codes are supported (e.g. EPSG:1234).
default-vertical-crs-id Default vertical CRS ID to associate with borehole collars that don’t have a mapping for vertical CRS ID. Currently, only EPSG codes are supported (e.g. EPSG:1234).

Elements

Element Cardinality Description
borehole-name 1-1 Mapping for the borehole name.
collar-x 1-1 Mapping for the borehole collar X coordinate.
collar-y 1-1 Mapping for the borehole collar Y coordinate.
collar-z 1-1 Mapping for the borehole collar Z coordinate.
collar-azimuth 0-1 Mapping for the borehole collar azimuth.
collar-dip 0-1 Mapping for the borehole collar dip.
collar-plunge 0-1 Mapping for the borehole collar plunge.
horizontal-crs-id 0-1 Mapping for the ID of an existing horizontal CRS to associate with the borehole collar. Currently, only EPSG codes are supported (e.g. EPSG:1234).
vertical-crs-id 0-1 Mapping for the ID of an existing vertical CRS to associate with the borehole collar. Currently, only EPSG codes are supported (e.g. EPSG:1234).
max-depth 1-1 Mapping for the borehole max depth.
hole-path 0-1 Mapping for the borehole path type. One of: CURVED, LINEAR.
drill-method 0-1 Mapping for the borehole drill method.
drill-date 0-1 Mapping for the borehole drill date.
drill-rig-id 0-1 Mapping for the borehole drill rig ID.
piezometric-level 0-1 Mapping for the borehole piezometric level.
ignore 0-N Mapping for columns that the importer ignores.

Element borehole-name
Attributes

Attribute Description
column CSV column number for the borehole name.

Element collar-x
Attributes

Attribute Description
column CSV column number for the borehole collar X coordinate.

Element collar-y
Attributes

Attribute Description
column CSV column number for the borehole collar Y coordinate.

Element collar-z
Attributes

Attribute Description
column CSV column number for the borehole collar Z coordinate.

Element collar-azimuth
Attributes

Attribute Description
column CSV column number for the borehole collar azimuth.

Element collar-dip
Attributes

Attribute Description
column CSV column number for the borehole collar dip.

Element collar-plunge
Attributes

Attribute Description
column CSV column number for the borehole collar plunge.

Element horizontal-crs-id
Attributes

Attribute Description
column CSV column number for the ID of an existing horizontal CRS to associate with the borehole collar.

Element vertical-crs-id
Attributes

Attribute Description
column CSV column number for the ID of an existing vertical CRS to associate with the borehole collar.

Element max-depth
Attributes

Attribute Description
column CSV column number for the borehole max depth.

Element hole-path
Attributes

Attribute Description
column CSV column number for the borehole path type.

Element drill-method
Attributes

Attribute Description
column CSV column number for the borehole drill method.

Element drill-date
Attributes

Attribute Description
column CSV column number for the borehole drill date.

Element drill-rig-id
Attributes

Attribute Description
column CSV column number for the borehole drill rig ID.

Element piezometric-level
Attributes

Attribute Description
column CSV column number for the borehole piezometric level.

Element ignore
Attributes

Attribute Description
column CSV column number for a column to be ignored.

Root Element borehole-survey-mapping
Attributes

Attribute Description
file-name Name of the file (including the file extension) containing the borehole surveys.
delimiter Character to use as the delimiter (default is comma).
header Boolean indicating whether the file contains a header row or not (default is false).

Elements

Element Cardinality Description
borehole-name 1-1 Mapping for the borehole name.
azimuth 1-1 Mapping for the borehole survey azimuth.
dip 1-1 Mapping for the borehole survey dip.
depth 1-1 Mapping for the borehole survey depth.
ignore 0-N Mapping for columns that the importer ignores.

Element borehole-name
Attributes

Attribute Description
column CSV column number for the borehole name.

Element azimuth
Attributes

Attribute Description
column CSV column number for the borehole survey azimuth.

Element dip
Attributes

Attribute Description
column CSV column number for the borehole survey dip.

Element depth
Attributes

Attribute Description
column CSV column number for the borehole survey depth.

Element ignore
Attributes

Attribute Description
column CSV column number for a column to be ignored.

Root Element borehole-sample-mapping
Attributes

Attribute Description
file-name Name of the file (including the file extension) containing the borehole samples.
delimiter Character to use as the delimiter (default is comma).
header Boolean indicating whether the file contains a header row or not (default is false).

Elements

Element Cardinality Description
borehole-name 1-1 Mapping for the borehole name.
depth-from 1-1 Mapping for the borehole sample depth from.
depth-to 1-1 Mapping for the borehole sample depth to.
sample 1-N Mapping for a borehole sample value.
ignore 0-N Mapping for columns that the importer ignores.

Element borehole-name
Attributes

Attribute Description
column CSV column number for the borehole name.

Element depth-from
Attributes

Attribute Description
column CSV column number for the borehole sample depth from.

Element depth-to
Attributes

Attribute Description
column CSV column number for the borehole sample depth to.

Element sample
Attributes

Attribute Description
column CSV column number for the borehole sample value.
data-type Data type of the sample value. One of: categorical, numerical.
attribute-name Name of an existing attribute to associate with the borehole sample value.
measurement-name Name of an existing measurement to associate with the borehole sample value.
unit Unit of the measurement. (Optional)

Element ignore
Attributes

Attribute Description
column CSV column number for a column to be ignored.