The CSV file format does not have any hierarchy, but the exported data is hierarchical on three levels (Field, Borehole, Measurement). This means that the data of upper levels will be duplicated. For example, if a borehole has five measurements, each measurement will be on its own line, and the borehole’s information will be repeated on all the lines. In the same way the field’s information will be the same on every line of the exported file.
Azimuth and inclination define the borehole’s direction at the given position. Only the directions of the holes at measured positions are known, not the actual shapes. The shape is estimated from the directions using numerical integration. The Sense system assumes that between the measurement positions the hole curves smoothly and uniformly from the previous measured direction to the next.
GNSS positions in the same export are always given in the same UTM projection, but the exact projection is not known. This means that the hole's position on Earth cannot be known from the file alone.
GNSS position and local collar position data might conflict, if both are available.
| Field data | |
|---|---|
| UUID | Globally unique id in the UUID format. |
| Name | Name of the pattern. |
| Heading | Geodetic heading of the pattern, in degrees. |
| Hole data | |
|---|---|
| UUID | Globally unique id in UUID format. |
| Name | Name of the hole. |
| Note | Note attached to the hole. |
| Planned Hole Geodetic Azimuth | The geodetic azimuth of the possible imported planned hole. |
| Collar Geodetic Azimuth | The geodetic azimuth at the hole’s collar. |
| Local collar X | Hole’s left-right starting position in the field’s local coordinates, in meters. Values increase from left to right. |
| Local collar Y | Hole’s front-back starting position in the field’s local coordinates, in meters. Values increase from back to front. |
| Local collar Z | Hole’s up-down starting position in the field’s local coordinates, in meters. Values increase from down to up. May be unknow. |
| GNSS northing | Hole’s starting position northing in a UTM projection. May be unknow. |
| GNSS easting | Hole’s starting position easting in a UTM projection. May be unknow. |
| GNSS elevation | Hole’s starting position elevation in a UTM projection. May be unknow. |
| Measurement data | |
|---|---|
| Geodetic Azimuth | The geodetic azimuth of the measurement point. |
| Magnetic Azimuth | The magnetic azimuth of the measurement point. |
| Inclination | The amount of tilt of the hole towards azimuth at the measurement point, in degrees. 0° is straight down, 90° is along the azimuth. |
| Position | The position of the measurement point, in meters. Measured along the hole from its starting point. |