search

geological-survey-of-queensland / borehole-database

Borehole database specification for Geological Survey of Queensland
Creative Commons Attribution 4.0 International
4 stars 0 forks source link

origin_elevation and depth_datum #7

Open ajtroup opened 4 years ago

ajtroup commented 4 years ago

@DavidCrosswellGSQ @KellyVance

As per discussion and agreement in the Borehole Reference Group meetings, there needs to be a fix for the origin_elevation and depth_datum:

REQUIREMENT: Capture and display the elevation of the origin (i.e. the point at which the well meets the surface) and capture the elevation of the depth datum. Alternatively, depth_datum could be captured as a measurement above the origin point.

The origin is the point at which the well meets the ground. The “depth datum” is the rotary table or other point (sometimes at GL, but most often above it) as is the noted reference datum point. This is stored in MERLIN Borehole and currently reported:

origin elevation ground level

KellyVance commented 4 years ago

To keep language consistent, to make field names descriptive of what they are, and to avoid confusion or ambiguity i suggest the following we rename/repurpose Origin Elevation and add a field to result in:

Obviously they can (and must) be the same if the depth datum lookup selected for the well is Ground Level

ajtroup commented 4 years ago

@KellyVance I think this is a good idea