GEOTECH_CONVERT

Use this to import structural data into a structural database. Unlike the Database Import option (in Geotech > Utilities > Database Import), which uses a drillhole database, this executable uses a collection of comma separated text files.

Prerequisites

In order to use this option, you need to have the following three files:

A collar file containing the HoleID, Easting, Northing and Elevation fields.
A survey file containing the 'HoleID', 'Dip', 'Azimuth' and 'Intercept_Depth' fields.
A structural file containing the HOLEID, Depth, Angle, Beta, Dip and Dip Direction fields. If the Dip and Dip Direction fields are not present, then they will be added to the output file. The structural file may also contain additional fields, such as Date, Comment, etc.

Note: The HOLEID field in the structural file must be in uppercase and cannot contain any spaces.

The outputted text file, which is also comma separated, contains the same fields in the same order as the structural file. It will also contain the X, Y and Z co-ordinates of the structures as well as updated Dip and Dip Direction fields.

Usage

geotech_convert [-nrci] [-a alpha] [-b beta][-d depth] {collar file} {survey file} {structural file} {output file}

<> indicates a mandatory switch.
[ ] indicates an optional switch

Where:

Option	Description
-n	Do not convert alpha and beta. Use this flag if you have measured alpha and beta angles for each structure and you want the program to calculate the dip and dip-direction of the structure from these angles.
-r	Alpha angle relative to core axis. Use this flag if you want the alpha value to be the angle between the core axis and the structure. Therefore, for a vertical hole, an alpha value of 0 (zero) indicates a horizontal structure (dip = 0° ) and an alpha value of 90 indicates a vertical structure (dip = 90°). Not using this flag will result in the alpha angles being measured relative to the plane perpendicular to the core axis.
-c	Beta angle clockwise from core axis. Use this flag if the beta value corresponds to the angle between the reference line and the bottom of the structure. This is measured in a clockwise direction when looking along the core in the direction of drilling, from a reference line on the top of the hole/core. Therefore, for a vertical hole, a beta value of 0 (zero) indicates a dip direction of 0 (zero) degrees and a beta value of 90° indicates a dip direction value of 90° (refer to Diagrams 2 and 3 under the Geotech > Utilities > Database Import option). Not using this flag will result in the beta angle being measured in an anticlockwise direction.
-i	Put hole ID in comment field. Use this flag to place the drillhole name into the comment field.
-a alpha	Alpha field name (defaults to ALPHA).
-b beta	Beta field name (defaults to BETA).
-d depth	Depth field name (defaults to DEPTH)