| Name |
Data Type |
Comments |
Mandatory |
| geometry |
geometry |
|
|
| eno |
NUMBER
|
GA internal unique borehole identifier, the number or code assigned to the borehole. |
Y |
| borehole_name |
VARCHAR2
|
Geoscience Australia preferred name for the borehole. |
N |
| alternate_names |
VARCHAR2
|
Comma separated list of alternate names for the borehole. |
N |
| purpose |
VARCHAR2
|
The purpose or intention for which the borehole was drilled. eg, exploration, development or production, geotechnical. |
N |
| operator |
VARCHAR2
|
Organisation responsible for commissioning the borehole as opposed to drilling the borehole eg, the titleholder of the permit area in which the well was drilled. |
N |
| driller |
VARCHAR2
|
The contractor or company who drilled the borehole, eg contracted to drill the borehole by the borehole Operator. |
N |
| drill_start_date |
DATE
|
The date drilling commenced. |
N |
| drill_end_date |
DATE
|
The date on which the borehole reached total depth. |
N |
| rig_release_date |
DATE
|
The date the rig was released from contract on the borehole. |
N |
| borehole_status |
VARCHAR2
|
The condition of the borehole at any particular point in time. |
N |
| inclination_type |
VARCHAR2
|
Indication of the approximate inclination of the borehole. Appropriate terms would include vertical, inclined up, inclined down, horizontal. |
N |
| borehole_length_metres |
NUMBER
|
Total length of the borehole in meters. |
N |
| kickoff_depth_metres |
VARCHAR2
|
The depth at which the borehole was side tracked from its parent hole. |
N |
| parent_borehole |
VARCHAR2
|
Persistent identifier (PID) referring to a parent borehole (e.g., a parent well of a sidetrack wellbore). |
N |
| country |
VARCHAR2
|
The country / jurisdiction in which the borehole was drilled. |
N |
| jurisdiction |
VARCHAR2
|
The State, Territory or other administrative region in which the borehole was drilled. |
N |
| start_point |
VARCHAR2
|
Term to describe the type of the Earth location where the borehole commenced eg onshore, offshore, quarry floor. |
N |
| geological_provinces |
VARCHAR2
|
Comma separated list of geological provinces intersected by the borehole. |
N |
| tenement |
VARCHAR2
|
The identifier of the permit area (eg EL2845) in which the borehole was drilled at time of drilling (eg title, lease or licence). |
N |
| collar_longitude_gda94 |
NUMBER
|
The GDA94 longitude of the point at which the borehole enters the solid Earth. This point can be onshore (ie, the ground) or offshore (ie, the seafloor). |
N |
| collar_latitude_gda94 |
NUMBER
|
The GDA94 latitude of the point at which the borehole enters the solid Earth. This point can be onshore (ie, the ground) or offshore (ie, the seafloor). |
N |
| earth_materials_observations |
VARCHAR2
|
A flag (Y) to indicate whether or not (null) there are earth material observations for the borehole, held in Geoscience Australia's observation and analytical databases. |
N |
| stratigraphy_observations |
VARCHAR2
|
A flag (Y) to indicate whether or not (null) there are stratigraphic observations for the borehole, held in Geoscience Australia's observation and analytical databases. |
N |
| structures_observations |
VARCHAR2
|
A flag (Y) to indicate whether or not (null) there are structural observations for the borehole, held in Geoscience Australia's observation and analytical databases. |
N |
| inorganic_geochem_analyses |
VARCHAR2
|
A flag (Y) to indicate whether or not (null) there are inorganic geochemistry analyses for the borehole, held in Geoscience Australia's observation and analytical databases. |
N |
| organic_geochem_analyses |
VARCHAR2
|
A flag (Y) to indicate whether or not (null) there are organic geochemistry analyses for the borehole, held in Geoscience Australia's observation and analytical databases. |
N |
| geochronology_analyses |
VARCHAR2
|
A flag (Y) to indicate whether or not (null) there are geochronology analyses for the borehole, held in Geoscience Australia's observation and analytical databases. |
N |
| isotope_groups |
VARCHAR2
|
A flag (Y) to indicate whether or not (null) there are isotope analyses for the borehole, held in Geoscience Australia's observation and analytical databases. |
N |
| hydrochemistry_analyses |
VARCHAR2
|
A flag (Y) to indicate whether or not (null) there are hydrochemistry analyses for the borehole, held in Geoscience Australia's observation and analytical databases. |
N |
| rock_property_measurements |
VARCHAR2
|
A flag (Y) to indicate whether or not (null) there are rock property measurements for the borehole, held in Geoscience Australia's observation and analytical databases. |
N |
| mineralogy_analyses |
VARCHAR2
|
A flag (Y) to indicate whether or not (null) there are mineralogy analyses for the borehole in Geoscience Australia's observation and analytical databases. |
N |
| stored_specimens |
VARCHAR2
|
A flag (Y) to indicate whether or not (null) there are stored specimens collected from the borehole, stored by Geoscience Australia. |
N |
| thin_sections |
VARCHAR2
|
A flag (Y) to indicate whether or not (null) there are thin sections taken from borehole specimens for which data exists in Geoscience Australia's observation and analytical databases. |
N |
| mineral_deposit_samples |
VARCHAR2
|
A flag (Y) to indicate whether or not (null) there are mineral deposit sample records for the borehole in Geoscience Australia's observation and analytical databases. |
N |
| mineral_deposit_waste_samples |
VARCHAR2
|
A flag (Y) to indicate whether or not (null) there are mineral deposit waste samples for the borehole in Geoscience Australia's observation and analytical databases. |
N |
| other_sample_data |
VARCHAR2
|
A flag (Y) to indicate whether or not (null) there are records in Geoscience Australia's observation and analytical databases for other borehole sample data. |
N |
| linked_files |
VARCHAR2
|
Links to associated files (eg, images, videos, documents). |
N |
| borehole_report |
VARCHAR2
|
The URL or other URI for the Borehole Completion Report. |
N |
