| Name |
Data Type |
Comments |
Mandatory |
| geometry |
geometry |
|
|
| sampleno |
NUMBER
|
Geoscience Austalia's internal unique identifier for the sample. |
Y |
| igsn |
VARCHAR2
|
International Generic Sample Number. Unique alphanumeric identifier assigned under the IGSN scheme. |
N |
| sample_id |
VARCHAR2
|
Identifying number or code assigned to the sample in the field or laboratory. |
N |
| eno |
NUMBER
|
Geoscience Australia's internal unique identifier for the entity that was sampled from. |
Y |
| sampling_feature_name |
VARCHAR2
|
The name of the entity that was sampled, as stored in the Geoscience Australia database. |
Y |
| sampling_feature_type |
VARCHAR2
|
Type of entity that was sampled (e.g. BOREHOLE, FIELDSITE, SECTION). |
N |
| sample_type |
VARCHAR2
|
Term to describe the type of sample (e.g. borehole specimen, outcrop specimen, core, water specimen). |
N |
| sampling_method |
VARCHAR2
|
Term to describe the method by which the sample was collected (e.g. outcrop sampling, drilling, grab). |
N |
| material_class |
VARCHAR2
|
The type of material that was sampled (e.g. rock, sediment, water). |
N |
| stratigraphic_unit |
VARCHAR2
|
Name of the stratigraphic unit, as appears in the Australian Stratigraphic Units database (ASUD). |
N |
| geological_province |
VARCHAR2
|
Name given to a province, as appears in the Geoscience Australia's Provinces database. |
N |
| sample_remark |
VARCHAR2
|
Any additional comments or remarks about the sample including but not limited to extra earth materials or lithology descriptiors. |
N |
| earth_materials |
VARCHAR2
|
EARTH MATERIALS: Y if there is earth material data (e.g. lithology and associated qualifers) occurs for the sample in Geoscience Australia's field geology database. |
N |
| structural_measurements |
VARCHAR2
|
STRUCTURES: Y if analysis data occurs for the sample in Geoscience Australia's field geology database. |
N |
| inorganic_geochemistry |
VARCHAR2
|
INORGANIC GEOCHEMISTRY: Y if analysis data occurs for the sample in Geoscience Australia's inorganic geochemistry database. |
N |
| organic_geochemistry |
VARCHAR2
|
ORGANIC GEOCHEMISTRY: Y if analysis data occurs for the sample in Geoscience Australia's organic geochemistry database. |
N |
| geochronology |
VARCHAR2
|
GEOCHRONOLOGY: Y if analysis data occurs for the sample in Geoscience Australia's geochronology database. |
N |
| isotope_groups |
VARCHAR2
|
ISOTOPES: Y if analysis data occurs for the sample in Geoscience Australia's isotope database. |
N |
| hydrochemistry |
VARCHAR2
|
HYDROCHEM_SAMPLE_ANALYSIS: Y if analysis data occurs for the sample in Geoscience Australia's hydrochemistry database. |
N |
| rock_properties |
VARCHAR2
|
ROCK PROPERTIES: Y if analysis data occurs for the sample in either of Geoscience Australia's rock properties database. |
N |
| mineralogy |
VARCHAR2
|
MINERALOGY: Y if analysis data occurs for the sample in Geoscience Australia's mineralogy database. |
N |
| thin_sections |
VARCHAR2
|
THIN_SECTIONS: Y if analysis data occurs for the sample in Geoscience Australia's petrography database. |
N |
| repository_samples |
VARCHAR2
|
REPOSITORY_SAMPLES: Y if analysis data occurs for the sample in Geoscience Australia's Petroleum Information Management System. |
N |
| mineral_deposit_samples |
VARCHAR2
|
MINERAL_DEPOSIT_SAMPLES: Y if the sample is linked to a deposit in Geoscience Australia's mineral resources database. |
N |
| mineral_deposit_waste_samples |
VARCHAR2
|
MINERAL_DEPOSIT_WASTE_ SAMPLES: Y if the sample is linked to a mine waste site in Geoscience Australia's mineral resources database. |
N |
| linked_files |
VARCHAR2
|
LINKED_FILES: Y if sample has links to associated files (e.g., images, videos, documents). |
N |
| other_geological_data |
VARCHAR2
|
SAMPLEDATA: Y if the analysis or ancillary data for the sample occurs in Geoscience Australia's sample data database. |
N |
| project_name |
VARCHAR2
|
The name or description of the project that the sample was collected under (if known). |
N |
| gda94_longitude |
NUMBER
|
Longitude in decimal degrees for GDA94 Datum, expressed as a positive value eastern hemisphere. |
N |
| gda94_latitude |
NUMBER
|
Latitude in decimal degrees for GDA94 Datum, expressed as a negative for southern hemisphere. |
N |
| sample_originator |
VARCHAR2
|
The person or organisation that collected or initiated the collection of the sample. |
N |
| date_acquired |
DATE
|
Date the sample was acquired. If the date is 01/01/3000 this indicates that no acquisition date is known. |
N |
