Mineral Occurrence
Schema
Name | Data Type | Comments | Mandatory |
---|---|---|---|
geometry | geometry | ||
eno | NUMBER
|
Geoscience Australia's internal unique identifier for the mineral occurrence. | Y |
name | VARCHAR2
|
The name of the mineral occurrence. | N |
occurrence_type | VARCHAR2
|
The type of mineral occurrence. | N |
country | VARCHAR2
|
The country in which the mineral occurrence is located. | N |
state | VARCHAR2
|
The State, Territory or other administrative region in which the mineral occurrence is located. | N |
location_description | VARCHAR2
|
Additional information relating to the location of the mineral occurrence (e.g. 30 km SW of Halls Creek). | N |
alternate_names | VARCHAR2
|
Comma separated list of alternate names for the mineral occurrence. | N |
longitude_gda94 | NUMBER
|
Longitude in decimal degrees for GDA94 Datum, expressed as a positive value eastern hemisphere. | N |
latitude_gda94 | NUMBER
|
Latitude in decimal degrees for GDA94 Datum, expressed as a negative for southern hemisphere. | N |
commodities | VARCHAR2
|
Comma separated list of commodities associated with the mineral occurrence. | N |
associated_companies | VARCHAR2
|
Comma separated list of companies associated with the mineral occurrence. | N |
provinces | VARCHAR2
|
Comma separated list of geological provinces in which the mineral occurrence occurs. | N |
maxagename | VARCHAR2
|
Name of the zone or timescale interval for the maximum age of the mineral occurrence. | N |
minagename | VARCHAR2
|
Name of the zone or timescale interval for the minimum age of the mineral occurrence. | N |
child_occurrences | VARCHAR2
|
Y if there are data for child mineral occurrences related to this mineral occurrence. | N |
resources | VARCHAR2
|
Y if there are data for resources associated with the mineral occurrence. | N |
samples | VARCHAR2
|
Y if there are data for samples collected from the mineral occurrence. | N |
stratigraphy | VARCHAR2
|
Y if there are data for stratigraphic units associated with the mineral occurrence, either informal or identified in the Australian Stratigraphic Units Database. | N |