Q
Q

Quintosphere

Database implementation of Quintessence with source mappings

Quintessence
7feature types
103total attrs
20mapped
8sources
85%confidence

Ontology Schema

Exploration

Drill Hole

drill_hole
POINT

A drill hole for exploration, production, or monitoring

3 core15 attrs2 enums
collar_azimuthFLOAT
collar_dipFLOAT
collar_elevationFLOAT
companyTEXT
completion_dateDATE
countryTEXT
drill_dateDATE
hole_idTEXT
Geoscience

Geological Unit

geological_unit
POLYGON

A mapped geological formation or rock unit

1 core12 attrs3 enums
age_max_maFLOAT
age_min_maFLOAT
countryTEXT
descriptionTEXT
geological_ageENUM29v
jurisdictionTEXT
lithologyTEXT
nameTEXT
Workings

Mine Working

mine_working

A physical mining feature - shafts, adits, pits, trenches, infrastructure, etc.

2 core19 attrs4 enums
azimuth_degreesFLOAT
collar_elevationFLOAT
commoditiesTEXT[]
countryTEXT
depth_metersFLOAT
dip_degreesFLOAT
hazardsTEXT[]
height_metersFLOAT
Geoscience

Mineral Occurrence

mineral_occurrence
POINT

A location where minerals of economic interest have been identified

3 core15 attrs4 enums
alternate_namesTEXT[]
commoditiesTEXT[]
countryTEXT
deposit_typeENUM31v
discovery_yearINTEGER
geological_ageENUM29v
geological_provinceTEXT
host_rockTEXT
Exploration

Sample Point

sample_point
POINT

A location where a geological sample was collected

3 core15 attrs2 enums1 FKs
alterationTEXT
countryTEXT
depth_fromFLOAT
depth_toFLOAT
drill_hole_idTEXT
jurisdictionTEXT
lithologyTEXT
mineralizationTEXT
Geoscience

Structural Feature

structural_feature

A geological structural feature - fault, fold, shear zone, contact, etc.

2 core14 attrs2 enums
countryTEXT
dip_degreesFLOAT
dip_directionFLOAT
displacement_metersFLOAT
feature_typeENUM31v
geological_ageENUM29v
jurisdictionTEXT
length_kmFLOAT
Tenure

Tenement

tenement
POLYGON

A mining permit, lease, or exploration licence

5 core13 attrs2 enums
area_hectaresFLOAT
commoditiesTEXT[]
countryTEXT
expiry_dateDATE
grant_dateDATE
holderTEXT
holder_idTEXT
jurisdictionTEXT

Facets

12 mixins

Reusable attribute sets applied across feature types. Hover to see dependencies.

Geometry

f_feature
3 attrs
Applies to: All types
geometryGEOMETRY
geometry_typeTEXT
sridINTEGER

Shaft

f_feature_shaft_vertical
5 attrs
Applies to: 2 types
shaft_depthFLOAT
shaft_diameterFLOAT
water_depthFLOAT
shaft_levelsINTEGER[]
shaft_conditionTEXT

Incline

f_feature_shaft_inclined
5 attrs
Applies to: 2 types
shaft_lengthFLOAT
vertical_depthFLOAT
dipFLOAT
strikeFLOAT
shaft_conditionTEXT

Adit

f_feature_adit
4 attrs
Applies to: 2 types
adit_lengthFLOAT
strikeFLOAT
portal_elevationFLOAT
adit_conditionTEXT

Winze

f_feature_winze
3 attrs
Applies to: 2 types
winze_depthFLOAT
from_levelINTEGER
winze_conditionTEXT

Raise

f_feature_raise
4 attrs
Applies to: 2 types
raise_heightFLOAT
from_levelINTEGER
to_levelINTEGER
raise_purposeENUM4v

Alluvial

f_feature_alluvial
6 attrs
Applies to: 2 types
depth_to_bedrockFLOAT
gravel_thicknessFLOAT
water_sourceTEXT
alluvial_methodENUM5v
paystreak_widthFLOAT
+1 more

Mill

f_feature_mill
4 attrs
Applies to: 2 types
mill_capacityFLOAT
mill_typeENUM6v
concentration_methodENUM6v
mill_conditionTEXT

Shed

f_feature_shed
3 attrs
Applies to: 2 types
building_purposeENUM7v
building_countINTEGER
building_conditionTEXT

Context

geological_context
4 attrs
Applies to: 1 types
host_rock_extractedTEXT
geological_age_extractedENUM14v
mineralisation_styleTEXT
structural_settingTEXT

Features

mining_features
4 attrs
Applies to: 2 types
feature_countINTEGER
feature_types_presentTEXT[]
has_underground_workingsBOOLEAN
has_surface_workingsBOOLEAN

GoldenCheetah

goldencheetah
3 attrs
Applies to: 1 types
geogpt_analysis_idTEXT
geogpt_confidenceFLOAT
geogpt_analysis_dateTIMESTAMP
Occurrence Status
10 values
ACTIVEINACTIVEHISTORIC+2
Deposit Type
31 values
VEINSTOCKWORKEPITHERMAL+2
Mining Method
22 values
OPEN_PITOPEN_CUTSTRIP+2
Working Category
9 values
UNDERGROUND_ACCESSUNDERGROUND_DEVELOPMENTUNDERGROUND_EXTRACTION+2
Working Type
84 values
SHAFTPRODUCTION_SHAFTSERVICE_SHAFT+2
Working Status
16 values
ACTIVEINACTIVEABANDONED+2
Tenement Type
15 values
EXPLORATION_LICENCEEXPLORATION_PERMITPROSPECTING_LICENCE+2
Tenement Status
14 values
GRANTEDACTIVEPENDING+2
Drill Hole Type
19 values
DDRCRAB+2
Drill Hole Status
12 values
PLANNEDIN_PROGRESSCOMPLETED+2
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.
Legend
Core field
Foreign key
Enum type
Required
Facet mixin

Connected Sources8

SourceSlugMappingsActions
Geoscience Australia OZMINau_ga_ozmin18View mappings
Northern Territory GEMISau_nt_gemis16View mappings
NSW Mineral Occurrencesau_nsw_minocc12View mappings
Queensland Mineral Occurrencesau_qld_minocc14View mappings
South Australia Tenements

Coverage by Feature Type

Exploration

Drill Hole

0%
0/15 mapped3 core2 enums
Geoscience

Geological Unit

0%
0/12 mapped1 core3 enums
Workings

Mine Working

11%
2/19 mapped2 core4 enums
Victoria Mine Shafts
Geoscience

Mineral Occurrence

80%
au_sa_tenements
20
View mappings
Tasmania Mineral Occurrencesau_tas_minocc22View mappings
Victoria Mine Shaftsau_vic_shafts12View mappings
Western Australia Minedexau_wa_minedex14View mappings
12/15 mapped3 core4 enums
Tasmania Mineral OccurrencesNSW Mineral OccurrencesWestern Australia Minedex+5
Exploration

Sample Point

0%
0/15 mapped3 core2 enums1 FKs
Geoscience

Structural Feature

0%
0/14 mapped2 core2 enums
Tenure

Tenement

46%
6/13 mapped5 core2 enums
South Australia Tenements