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