Discover au_qld_minocc → Derive ontology
{
"domain": "mining",
"qualityNotes": [
"Most commodity fields (main_commodity, all_commodities) are null in the sample data",
"Status fields (mine_status, exploration_status) are consistently null",
"Many optional fields like mine_name, deposit_size are empty",
"Location data appears complete with both lat/long and MGA coordinates",
"Unknown field '_000_' contains no data and purpose is unclear",
"Data appears to be a comprehensive register but many records lack detailed commodity/status information",
"Coordinate precision is very high (11+ decimal places) which may be excessive",
"Field names with special characters (location_accuracy__m_) suggest data export artifacts"
],
"commonPatterns": {
"dateFields": [
"data_date",
"_mirrored_at"
],
"statusFields": [
"mine_status",
"exploration_status"
],
"geometryFields": [
"geom",
"lat94",
"long94",
"easting94",
"northing94"
],
"commodityFields": [
"main_commodity",
"all_commodities",
"main_commodity_size"
],
"identifierFields": [
"_id",
"site_no",
"field_id"
],
"measurementFields": [
"location_accuracy__m_",
"deposit_size",
"size_order"
]
},
"alternativeTypes": [],
"primaryFeatureType": {
"name": "Mineral Occurrence",
"slug": "mineral_occurrence",
"reasoning": "This data represents Queensland mineral occurrences with point locations, commodity information, and mining/exploration status fields. The presence of fields like main_commodity, all_commodities, mine_status, exploration_status, and locality descriptions clearly indicates these are mineral occurrence sites.",
"attributes": [
{
"name": "site_no",
"dataType": "TEXT",
"examples": [
"513034",
"506145",
"42767"
],
"required": true,
"isGeometry": false,
"description": "Queensland government site number identifier",
"isIdentifier": true,
"sourceFieldPatterns": [
"site_no",
"site_number",
"occurrence_id"
]
},
{
"name": "field_id",
"dataType": "TEXT",
"examples": [
"MTISA",
"FRANKFIELD_100"
],
"required": false,
"isGeometry": false,
"description": "Mining field or district identifier",
"isIdentifier": false,
"sourceFieldPatterns": [
"field_id",
"field",
"district",
"mining_field"
]
},
{
"name": "name",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Mine or occurrence name",
"isIdentifier": false,
"sourceFieldPatterns": [
"mine_name",
"name",
"occurrence_name",
"site_name"
]
},
{
"name": "locality",
"dataType": "TEXT",
"examples": [
"16.4KM WNW OF QUAMBY.",
"83KM SSE OF MT ISA, 15KM SSE OF DUCHESS"
],
"required": false,
"isGeometry": false,
"description": "Descriptive location relative to landmarks",
"isIdentifier": false,
"sourceFieldPatterns": [
"locality",
"location",
"description",
"location_desc"
]
},
{
"name": "status",
"dataType": "TEXT",
"examples": [],
"required": false,
"enumValues": [],
"isGeometry": false,
"description": "Current mining or operational status",
"isIdentifier": false,
"sourceFieldPatterns": [
"mine_status",
"status",
"operational_status"
]
},
{
"name": "exploration_status",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Current exploration status",
"isIdentifier": false,
"sourceFieldPatterns": [
"exploration_status",
"explor_status",
"exploration_stage"
]
},
{
"name": "primary_commodity",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Main commodity of interest",
"isIdentifier": false,
"sourceFieldPatterns": [
"main_commodity",
"primary_commodity",
"commodity",
"main_comm"
]
},
{
"name": "commodities",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "All commodities present at the occurrence",
"isIdentifier": false,
"sourceFieldPatterns": [
"all_commodities",
"commodities",
"all_comm",
"commodity_list"
]
},
{
"name": "commodity_size",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Size classification of main commodity",
"isIdentifier": false,
"sourceFieldPatterns": [
"main_commodity_size",
"commodity_size",
"size_class"
]
},
{
"name": "deposit_size",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Overall deposit size classification",
"isIdentifier": false,
"sourceFieldPatterns": [
"deposit_size",
"size",
"deposit_class"
]
},
{
"name": "size_order",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Numerical size order classification",
"isIdentifier": false,
"sourceFieldPatterns": [
"size_order",
"order",
"size_rank"
]
},
{
"name": "work_extent",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Extent of work undertaken at the site",
"isIdentifier": false,
"sourceFieldPatterns": [
"work_extent",
"work_type",
"development"
]
},
{
"name": "work_extent_comments",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Additional comments on work extent",
"isIdentifier": false,
"sourceFieldPatterns": [
"work_extent_comments",
"work_comments",
"development_notes"
]
},
{
"name": "data_date",
"dataType": "DATE",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Date when the data was collected or last updated",
"isIdentifier": false,
"sourceFieldPatterns": [
"data_date",
"survey_date",
"record_date"
]
},
{
"name": "location_accuracy",
"dataType": "FLOAT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Location accuracy in meters",
"isIdentifier": false,
"sourceFieldPatterns": [
"location_accuracy__m_",
"accuracy",
"positional_accuracy"
]
},
{
"name": "map_sheet",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Map sheet reference",
"isIdentifier": false,
"sourceFieldPatterns": [
"map_name__100",
"map_sheet",
"topo_sheet"
]
},
{
"name": "mga_zone",
"dataType": "TEXT",
"examples": [
"54",
"55"
],
"required": false,
"isGeometry": false,
"description": "Map Grid of Australia zone",
"isIdentifier": false,
"sourceFieldPatterns": [
"mga_zone",
"zone",
"utm_zone"
]
},
{
"name": "easting",
"dataType": "FLOAT",
"examples": [
"409691",
"378302"
],
"required": false,
"isGeometry": false,
"description": "MGA easting coordinate",
"isIdentifier": false,
"sourceFieldPatterns": [
"easting94",
"easting",
"x_coord"
]
},
{
"name": "northing",
"dataType": "FLOAT",
"examples": [
"7752366",
"7632251"
],
"required": false,
"isGeometry": false,
"description": "MGA northing coordinate",
"isIdentifier": false,
"sourceFieldPatterns": [
"northing94",
"northing",
"y_coord"
]
},
{
"name": "latitude",
"dataType": "FLOAT",
"examples": [
"-20.3244861111111111",
"-21.4078444444444444"
],
"required": false,
"isGeometry": false,
"description": "Latitude in decimal degrees (GDA94)",
"isIdentifier": false,
"sourceFieldPatterns": [
"lat94",
"latitude",
"lat"
]
},
{
"name": "longitude",
"dataType": "FLOAT",
"examples": [
"140.134905555555555",
"139.825869444444444"
],
"required": false,
"isGeometry": false,
"description": "Longitude in decimal degrees (GDA94)",
"isIdentifier": false,
"sourceFieldPatterns": [
"long94",
"longitude",
"lon",
"lng"
]
},
{
"name": "geometry",
"dataType": "GEOMETRY",
"examples": [
"POINT"
],
"required": true,
"isGeometry": true,
"description": "Point geometry of the occurrence location",
"isIdentifier": false,
"sourceFieldPatterns": [
"geom",
"geometry",
"shape",
"the_geom"
]
},
{
"name": "source_id",
"dataType": "TEXT",
"examples": [
"qld_location_513034",
"qld_location_506145"
],
"required": true,
"isGeometry": false,
"description": "Original source record identifier",
"isIdentifier": true,
"sourceFieldPatterns": [
"_id",
"id",
"source_id",
"record_id"
]
},
{
"name": "jurisdiction",
"dataType": "TEXT",
"examples": [
"Queensland"
],
"required": true,
"isGeometry": false,
"description": "Administrative jurisdiction",
"isIdentifier": false,
"sourceFieldPatterns": [
"jurisdiction",
"state",
"province"
]
},
{
"name": "country",
"dataType": "TEXT",
"examples": [
"AU"
],
"required": true,
"isGeometry": false,
"description": "Country code",
"isIdentifier": false,
"sourceFieldPatterns": [
"country",
"country_code"
]
}
],
"confidence": 0.95,
"description": "A location where minerals have been found, including prospects, deposits, and mine sites in Queensland",
"geometryType": "POINT"
}
}Discover au_qld_minocc → Analyze schema
{
"fields": [
{
"name": "_id",
"type": "string",
"pattern": "qld_location_\\d+",
"nullable": false,
"description": "Unique identifier for each mineral occurrence record",
"sampleValues": [
"qld_location_480059",
"qld_location_36151",
"qld_location_7602"
]
},
{
"name": "site_no",
"type": "string",
"nullable": false,
"description": "Site number identifier for the mineral occurrence location",
"sampleValues": [
"480059",
"36151",
"7602",
"532466",
"39879"
]
},
{
"name": "field_id",
"type": "string",
"nullable": true,
"description": "Field identifier code for mining field or area",
"sampleValues": [
null,
"M0067",
"MTISA"
]
},
{
"name": "mine_name",
"type": "string",
"nullable": true,
"description": "Name of the mine or mining operation",
"sampleValues": [
null
]
},
{
"name": "lat94",
"type": "string",
"nullable": false,
"description": "Latitude coordinate in GDA94 datum as decimal degrees",
"sampleValues": [
"-18.5494861111111111",
"-17.4236583333333333",
"-26.0286361111111111"
]
},
{
"name": "long94",
"type": "string",
"nullable": false,
"description": "Longitude coordinate in GDA94 datum as decimal degrees",
"sampleValues": [
"143.635280555555555",
"145.249438888888888",
"152.605263888888888"
]
},
{
"name": "mga_zone",
"type": "string",
"nullable": false,
"enumValues": [
"54",
"55",
"56"
],
"description": "Map Grid of Australia (MGA) zone number",
"sampleValues": [
"54",
"55",
"56"
]
},
{
"name": "easting94",
"type": "string",
"nullable": false,
"description": "Easting coordinate in MGA94 projection",
"sampleValues": [
"778181",
"314064",
"460505",
"402820",
"467045"
]
},
{
"name": "northing94",
"type": "string",
"nullable": false,
"description": "Northing coordinate in MGA94 projection",
"sampleValues": [
"7946976",
"8072719",
"7121075",
"7725465",
"7102400"
]
},
{
"name": "locality",
"type": "string",
"nullable": false,
"description": "Descriptive location of the mineral occurrence site",
"sampleValues": [
"5.4 KM NE OF FORSAYTH.",
"4.8 KM E OF IRVINEBANK.",
"SLATE QUARRY"
]
},
{
"name": "mine_status",
"type": "string",
"nullable": true,
"description": "Current operational status of the mine",
"sampleValues": [
null
]
},
{
"name": "exploration_status",
"type": "string",
"nullable": true,
"description": "Status of exploration activities at the site",
"sampleValues": [
null
]
},
{
"name": "deposit_size",
"type": "string",
"nullable": true,
"description": "Size classification of the mineral deposit",
"sampleValues": [
null
]
},
{
"name": "size_order",
"type": "string",
"nullable": true,
"description": "Numerical order or ranking of deposit size",
"sampleValues": [
null
]
},
{
"name": "data_date",
"type": "date",
"nullable": true,
"description": "Date when the data was collected or last updated",
"sampleValues": [
null
]
},
{
"name": "location_accuracy__m_",
"type": "number",
"nullable": true,
"description": "Accuracy of location coordinates in meters",
"sampleValues": [
null
]
},
{
"name": "main_commodity",
"type": "string",
"nullable": true,
"description": "Primary commodity or mineral at the occurrence",
"sampleValues": [
null
]
},
{
"name": "main_commodity_size",
"type": "string",
"nullable": true,
"description": "Size or grade of the main commodity",
"sampleValues": [
null
]
},
{
"name": "all_commodities",
"type": "string",
"nullable": true,
"description": "List of all commodities present at the occurrence",
"sampleValues": [
null
]
},
{
"name": "map_name__100",
"type": "string",
"nullable": true,
"description": "Name of the 1:100,000 scale map sheet",
"sampleValues": [
null
]
},
{
"name": "_000_",
"type": "string",
"nullable": true,
"description": "Unknown field, possibly map scale related",
"sampleValues": [
null
]
},
{
"name": "work_extent",
"type": "string",
"nullable": true,
"description": "Extent or scale of work conducted at the site",
"sampleValues": [
null
]
},
{
"name": "work_extent_comments",
"type": "string",
"nullable": true,
"description": "Additional comments about the work extent",
"sampleValues": [
null
]
},
{
"name": "_mirrored_at",
"type": "date",
"pattern": "YYYY-MM-DD HH:MM:SS.ssssss+TZ",
"nullable": false,
"description": "Timestamp when the record was mirrored or synchronized",
"sampleValues": [
"2026-02-09 19:13:17.23933+00"
]
},
{
"name": "geom",
"type": "geometry",
"nullable": false,
"description": "PostGIS geometry field containing point coordinates",
"sampleValues": [
"0101000020BB100000AB3CE33754F4614015D42C1FAB8C32C0"
]
}
],
"semantics": {
"idFields": [
"_id",
"site_no",
"field_id"
],
"nameFields": [
"mine_name",
"locality",
"map_name__100"
],
"primaryKey": "_id",
"statusFields": [
"mine_status",
"exploration_status"
],
"fieldMeanings": {
"_id": "Primary key identifier",
"geom": "PostGIS point geometry",
"_000_": "Unknown map-related field",
"lat94": "Latitude coordinate (GDA94)",
"long94": "Longitude coordinate (GDA94)",
"site_no": "Site number identifier",
"field_id": "Mining field identifier",
"locality": "Location description",
"mga_zone": "MGA zone number",
"data_date": "Data collection date",
"easting94": "Easting coordinate (MGA94)",
"mine_name": "Mine name",
"northing94": "Northing coordinate (MGA94)",
"size_order": "Size ranking",
"mine_status": "Mine operational status",
"work_extent": "Work scale/extent",
"_mirrored_at": "Data synchronization timestamp",
"deposit_size": "Deposit size classification",
"map_name__100": "Map sheet name (1:100k)",
"main_commodity": "Primary mineral commodity",
"all_commodities": "All commodities present",
"exploration_status": "Exploration activity status",
"main_commodity_size": "Main commodity size/grade",
"work_extent_comments": "Work extent notes",
"location_accuracy__m_": "Location accuracy in meters"
},
"relationships": [
{
"field": "lat94",
"relatedTo": "long94",
"relationshipType": "coordinate_pair"
},
{
"field": "easting94",
"relatedTo": "northing94",
"relationshipType": "coordinate_pair"
},
{
"field": "site_no",
"relatedTo": "_id",
"relationshipType": "identifier_variant"
},
{
"field": "main_commodity",
"relatedTo": "all_commodities",
"relationshipType": "subset_of"
}
],
"geometryFields": [
"geom",
"lat94",
"long94",
"easting94",
"northing94"
],
"commodityFields": [
"main_commodity",
"main_commodity_size",
"all_commodities"
]
},
"confidence": 0.95,
"entityType": "mineral_occurrence",
"recordCount": 100
}Harmonize au_qld_minocc → Generate mappings
{
"mappings": [
{
"confidence": 0.95,
"mappingType": "direct",
"sourceField": "mine_name",
"justification": "mine_name directly corresponds to the primary name of the mineral occurrence, though samples show null values which may require fallback logic",
"targetAttribute": "name"
},
{
"confidence": 0.9,
"mappingType": "direct",
"sourceField": "mine_status",
"justification": "mine_status directly maps to operational status, though samples show null values indicating data may be sparse",
"targetAttribute": "status"
},
{
"transform": {
"type": "parse",
"expression": "split_and_standardize_commodities"
},
"confidence": 0.8,
"mappingType": "computed",
"sourceField": "all_commodities",
"justification": "all_commodities contains list of mineral commodities but may need parsing/transformation to convert to standardized element symbols",
"targetAttribute": "commodities"
},
{
"confidence": 0.9,
"mappingType": "direct",
"sourceField": "main_commodity",
"justification": "main_commodity directly corresponds to the primary commodity of economic interest",
"targetAttribute": "primary_commodity"
},
{
"confidence": 1,
"mappingType": "direct",
"sourceField": "_id",
"justification": "Primary key identifier from source system, perfect match for source_id requirement",
"targetAttribute": "source_id"
},
{
"confidence": 0.7,
"mappingType": "inferred",
"sourceField": "locality",
"justification": "locality provides descriptive location information that can serve as regional context, though it's more detailed than typical region field",
"targetAttribute": "region"
},
{
"transform": {
"type": "parse",
"expression": "extract_year_if_discovery_date"
},
"confidence": 0.6,
"mappingType": "computed",
"sourceField": "data_date",
"justification": "data_date may contain discovery information but likely represents data collection date rather than discovery year, requires validation",
"targetAttribute": "discovery_year"
}
],
"featureType": "mineral_occurrence",
"unmappedFields": [
"site_no",
"field_id",
"lat94",
"long94",
"mga_zone",
"easting94",
"northing94",
"exploration_status",
"deposit_size",
"size_order",
"location_accuracy__m_",
"main_commodity_size",
"map_name__100",
"_000_",
"work_extent",
"work_extent_comments",
"_mirrored_at",
"geom"
],
"overallConfidence": 0.75,
"suggestedAttributes": [
{
"name": "site_number",
"dataType": "TEXT",
"description": "Official site number identifier from Queensland government records"
},
{
"name": "field_identifier",
"dataType": "TEXT",
"description": "Field or area code designation"
},
{
"name": "deposit_size_class",
"dataType": "ENUM",
"description": "Standardized deposit size classification"
},
{
"name": "exploration_status",
"dataType": "ENUM",
"description": "Current exploration activity status"
},
{
"name": "location_accuracy_meters",
"dataType": "NUMERIC",
"description": "Spatial accuracy of coordinates in meters"
},
{
"name": "mga_zone",
"dataType": "INTEGER",
"description": "Map Grid of Australia zone number for coordinate reference"
},
{
"name": "work_extent_description",
"dataType": "TEXT",
"description": "Description of work conducted at the site"
}
]
}Harmonize au_qld_minocc → Validate ontology
{
"isValid": false,
"warnings": [
"latitude: 100% of values don't match expected type FLOAT",
"longitude: 100% of values don't match expected type FLOAT",
"easting: 100% of values don't match expected type INTEGER",
"northing: 100% of values don't match expected type INTEGER",
"geometry: 100% of values don't match expected type GEOMETRY"
],
"sourceSlug": "au_qld_minocc",
"featureType": "mineral_occurrence",
"suggestions": [],
"validatedAt": "2026-02-09T19:42:43.445Z",
"criticalIssues": [
"jurisdiction: No matching field found for patterns: ",
"country: No matching field found for patterns: "
],
"totalAttributes": 24,
"validAttributes": 17,
"validationScore": 71,
"fieldValidations": [
{
"issues": [],
"isValid": true,
"nullCount": 0,
"actualTypes": {
"string": 21290
},
"nullPercent": 0,
"expectedType": "TEXT",
"matchedField": "site_no",
"totalRecords": 21290,
"attributeName": "site_no",
"distinctCount": 21290,
"sourcePatterns": [
"site_no",
"site_number",
"occurrence_id"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 13273,
"actualTypes": {
"string": 8017
},
"nullPercent": 62,
"expectedType": "TEXT",
"matchedField": "field_id",
"totalRecords": 21290,
"attributeName": "field_id",
"distinctCount": 715,
"sourcePatterns": [
"field_id",
"field_code",
"mining_field"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": "mine_name",
"totalRecords": 21290,
"attributeName": "name",
"distinctCount": 0,
"sourcePatterns": [
"mine_name",
"name",
"occurrence_name",
"site_name"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 62,
"actualTypes": {
"string": 21228
},
"nullPercent": 0,
"expectedType": "TEXT",
"matchedField": "locality",
"totalRecords": 21290,
"attributeName": "locality",
"distinctCount": 16010,
"sourcePatterns": [
"locality",
"location",
"description",
"location_desc"
],
"typeMismatchPercent": 0
},
{
"issues": [
"100% of values don't match expected type FLOAT"
],
"isValid": false,
"nullCount": 0,
"actualTypes": {
"string": 21290
},
"nullPercent": 0,
"expectedType": "FLOAT",
"matchedField": "lat94",
"sampleIssues": [
"-24.9582833333333333",
"-22.6976250000000000",
"-22.6966111111111111",
"-22.7178833333333333",
"-22.7403111111111111"
],
"totalRecords": 21290,
"attributeName": "latitude",
"distinctCount": 21028,
"sourcePatterns": [
"lat94",
"latitude",
"lat",
"y"
],
"typeMismatchPercent": 100
},
{
"issues": [
"100% of values don't match expected type FLOAT"
],
"isValid": false,
"nullCount": 0,
"actualTypes": {
"string": 21290
},
"nullPercent": 0,
"expectedType": "FLOAT",
"matchedField": "long94",
"sampleIssues": [
"152.201111111111111",
"147.499655555555555",
"147.500275000000000",
"147.494383333333333",
"147.515794444444444"
],
"totalRecords": 21290,
"attributeName": "longitude",
"distinctCount": 21056,
"sourcePatterns": [
"long94",
"longitude",
"long",
"lon",
"x"
],
"typeMismatchPercent": 100
},
{
"issues": [
"100% of values don't match expected type INTEGER"
],
"isValid": false,
"nullCount": 0,
"actualTypes": {
"string": 21290
},
"nullPercent": 0,
"expectedType": "INTEGER",
"matchedField": "easting94",
"sampleIssues": [
"419355",
"551320",
"551384",
"550771",
"552961"
],
"totalRecords": 21290,
"attributeName": "easting",
"distinctCount": 17177,
"sourcePatterns": [
"easting94",
"easting",
"x_coord"
],
"typeMismatchPercent": 100
},
{
"issues": [
"100% of values don't match expected type INTEGER"
],
"isValid": false,
"nullCount": 0,
"actualTypes": {
"string": 21290
},
"nullPercent": 0,
"expectedType": "INTEGER",
"matchedField": "northing94",
"sampleIssues": [
"7239425",
"7489857",
"7489969",
"7487617",
"7485126"
],
"totalRecords": 21290,
"attributeName": "northing",
"distinctCount": 17599,
"sourcePatterns": [
"northing94",
"northing",
"y_coord"
],
"typeMismatchPercent": 100
},
{
"issues": [],
"isValid": true,
"nullCount": 0,
"actualTypes": {
"string": 21290
},
"nullPercent": 0,
"expectedType": "TEXT",
"matchedField": "mga_zone",
"totalRecords": 21290,
"attributeName": "mga_zone",
"distinctCount": 3,
"sourcePatterns": [
"mga_zone",
"zone",
"utm_zone"
],
"typeMismatchPercent": 0
},
{
"issues": [
"100% of values don't match expected type GEOMETRY"
],
"isValid": false,
"nullCount": 0,
"actualTypes": {
"string": 21290
},
"nullPercent": 0,
"expectedType": "GEOMETRY",
"matchedField": "geom",
"sampleIssues": [
"0101000020BB100000B4A291806F066340F2F7780E52F538C0",
"0101000020BB10000007CCA52DFD6F62403BDF4F8D97B236C0",
"0101000020BB1000003480B74002706240A040141B55B236C0",
"0101000020BB100000550BFFFCD16F62409802BF33C7B736C0",
"0101000020BB1000001ECB59638170624070166B0785BD36C0"
],
"totalRecords": 21290,
"attributeName": "geometry",
"distinctCount": 21267,
"sourcePatterns": [
"geom",
"geometry",
"shape",
"the_geom"
],
"typeMismatchPercent": 100
},
{
"issues": [],
"isValid": true,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": "mine_status",
"totalRecords": 21290,
"attributeName": "mine_status",
"distinctCount": 0,
"sourcePatterns": [
"mine_status",
"status",
"mining_status"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": "exploration_status",
"totalRecords": 21290,
"attributeName": "exploration_status",
"distinctCount": 0,
"sourcePatterns": [
"exploration_status",
"explor_status",
"exp_status"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": "main_commodity",
"totalRecords": 21290,
"attributeName": "primary_commodity",
"distinctCount": 0,
"sourcePatterns": [
"main_commodity",
"primary_commodity",
"commodity",
"main_comm"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": "all_commodities",
"totalRecords": 21290,
"attributeName": "commodities",
"distinctCount": 0,
"sourcePatterns": [
"all_commodities",
"commodities",
"all_comm"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": "deposit_size",
"totalRecords": 21290,
"attributeName": "deposit_size",
"distinctCount": 0,
"sourcePatterns": [
"deposit_size",
"size",
"deposit_scale"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": "size_order",
"totalRecords": 21290,
"attributeName": "size_order",
"distinctCount": 0,
"sourcePatterns": [
"size_order",
"size_rank"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "FLOAT",
"matchedField": "location_accuracy__m_",
"totalRecords": 21290,
"attributeName": "location_accuracy_m",
"distinctCount": 0,
"sourcePatterns": [
"location_accuracy__m_",
"accuracy",
"loc_accuracy"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 20087,
"actualTypes": {
"string": 1203
},
"nullPercent": 94,
"expectedType": "TEXT",
"matchedField": "work_extent",
"totalRecords": 21290,
"attributeName": "work_extent",
"distinctCount": 1113,
"sourcePatterns": [
"work_extent",
"work_type",
"development"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": "work_extent_comments",
"totalRecords": 21290,
"attributeName": "work_extent_comments",
"distinctCount": 0,
"sourcePatterns": [
"work_extent_comments",
"work_comments",
"comments"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "DATE",
"matchedField": "data_date",
"totalRecords": 21290,
"attributeName": "data_date",
"distinctCount": 0,
"sourcePatterns": [
"data_date",
"date",
"update_date"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": "map_name__100",
"totalRecords": 21290,
"attributeName": "map_sheet",
"distinctCount": 0,
"sourcePatterns": [
"map_name__100",
"map_sheet",
"map_name"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 0,
"actualTypes": {
"string": 21290
},
"nullPercent": 0,
"expectedType": "TEXT",
"matchedField": "_id",
"totalRecords": 21290,
"attributeName": "source_id",
"distinctCount": 21290,
"sourcePatterns": [
"_id",
"id",
"source_id"
],
"typeMismatchPercent": 0
},
{
"issues": [
"No matching field found for patterns: "
],
"isValid": false,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": null,
"totalRecords": 21290,
"attributeName": "jurisdiction",
"distinctCount": 0,
"sourcePatterns": [],
"typeMismatchPercent": 100
},
{
"issues": [
"No matching field found for patterns: "
],
"isValid": false,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": null,
"totalRecords": 21290,
"attributeName": "country",
"distinctCount": 0,
"sourcePatterns": [],
"typeMismatchPercent": 100
}
],
"recordsValidated": 21290,
"attributesWithIssues": 7
}Harmonize au_qld_minocc → Derive ontology
{
"domain": "mining",
"qualityNotes": [
"Most commodity fields are null in the sample data, indicating incomplete commodity information",
"Status fields (mine_status, exploration_status) are consistently null, suggesting missing operational status data",
"Date fields are mostly null except for _mirrored_at timestamp",
"Location data appears complete with both decimal degrees and MGA coordinates",
"Some fields like '_000_' appear to be artifacts from data processing",
"Field names with special characters (location_accuracy__m_) suggest data export formatting issues",
"Mine names are consistently null, indicating these may be early-stage prospects rather than named mines"
],
"commonPatterns": {
"dateFields": [
"data_date",
"_mirrored_at"
],
"statusFields": [
"mine_status",
"exploration_status"
],
"geometryFields": [
"geom",
"lat94",
"long94",
"easting94",
"northing94"
],
"commodityFields": [
"main_commodity",
"all_commodities",
"main_commodity_size"
],
"identifierFields": [
"_id",
"site_no",
"field_id"
],
"measurementFields": [
"location_accuracy__m_",
"deposit_size",
"size_order"
]
},
"alternativeTypes": [],
"primaryFeatureType": {
"name": "Mineral Occurrence",
"slug": "mineral_occurrence",
"reasoning": "This data represents Queensland mineral occurrences with point locations, commodity information, and mining-related status fields. The presence of fields like 'main_commodity', 'all_commodities', 'mine_status', 'exploration_status', and 'deposit_size' clearly indicates these are mineral occurrence records.",
"attributes": [
{
"name": "site_no",
"dataType": "TEXT",
"examples": [
"479734",
"41029",
"506706"
],
"required": true,
"isGeometry": false,
"description": "Queensland government site number identifier",
"isIdentifier": true,
"sourceFieldPatterns": [
"site_no",
"site_number",
"occurrence_id"
]
},
{
"name": "field_id",
"dataType": "TEXT",
"examples": [
"MARYB",
"MTISA",
"NOCON"
],
"required": false,
"isGeometry": false,
"description": "Mining field identifier code",
"isIdentifier": false,
"sourceFieldPatterns": [
"field_id",
"field_code",
"mining_field"
]
},
{
"name": "name",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Mine or occurrence name",
"isIdentifier": false,
"sourceFieldPatterns": [
"mine_name",
"name",
"occurrence_name",
"site_name"
]
},
{
"name": "locality",
"dataType": "TEXT",
"examples": [
"11.3 KM E OF MOUNT OWEENEE HS.",
"31.6KM SSW OF MARYBOROUGH"
],
"required": false,
"isGeometry": false,
"description": "Descriptive location relative to landmarks",
"isIdentifier": false,
"sourceFieldPatterns": [
"locality",
"location",
"description",
"location_desc"
]
},
{
"name": "latitude",
"dataType": "FLOAT",
"examples": [
"-19.3760916666666666",
"-25.8041805555555555"
],
"required": true,
"isGeometry": false,
"description": "Latitude in decimal degrees (GDA94)",
"isIdentifier": false,
"sourceFieldPatterns": [
"lat94",
"latitude",
"lat",
"y"
]
},
{
"name": "longitude",
"dataType": "FLOAT",
"examples": [
"145.743213888888888",
"152.582069444444444"
],
"required": true,
"isGeometry": false,
"description": "Longitude in decimal degrees (GDA94)",
"isIdentifier": false,
"sourceFieldPatterns": [
"long94",
"longitude",
"long",
"lon",
"x"
]
},
{
"name": "easting",
"dataType": "INTEGER",
"examples": [
"368015",
"458105",
"443820"
],
"required": false,
"isGeometry": false,
"description": "MGA easting coordinate",
"isIdentifier": false,
"sourceFieldPatterns": [
"easting94",
"easting",
"x_coord"
]
},
{
"name": "northing",
"dataType": "INTEGER",
"examples": [
"7857070",
"7145925",
"7630729"
],
"required": false,
"isGeometry": false,
"description": "MGA northing coordinate",
"isIdentifier": false,
"sourceFieldPatterns": [
"northing94",
"northing",
"y_coord"
]
},
{
"name": "mga_zone",
"dataType": "TEXT",
"examples": [
"55",
"56",
"54"
],
"required": false,
"isGeometry": false,
"description": "Map Grid of Australia zone number",
"isIdentifier": false,
"sourceFieldPatterns": [
"mga_zone",
"zone",
"utm_zone"
]
},
{
"name": "geometry",
"dataType": "GEOMETRY",
"examples": [],
"required": true,
"isGeometry": true,
"description": "Point geometry of the occurrence location",
"isIdentifier": false,
"sourceFieldPatterns": [
"geom",
"geometry",
"shape",
"the_geom"
]
},
{
"name": "mine_status",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Current mining status of the occurrence",
"isIdentifier": false,
"sourceFieldPatterns": [
"mine_status",
"status",
"mining_status"
]
},
{
"name": "exploration_status",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Current exploration status",
"isIdentifier": false,
"sourceFieldPatterns": [
"exploration_status",
"explor_status",
"exp_status"
]
},
{
"name": "primary_commodity",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Main commodity of economic interest",
"isIdentifier": false,
"sourceFieldPatterns": [
"main_commodity",
"primary_commodity",
"commodity",
"main_comm"
]
},
{
"name": "commodities",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "All commodities present at the occurrence",
"isIdentifier": false,
"sourceFieldPatterns": [
"all_commodities",
"commodities",
"all_comm"
]
},
{
"name": "deposit_size",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Size classification of the deposit",
"isIdentifier": false,
"sourceFieldPatterns": [
"deposit_size",
"size",
"deposit_scale"
]
},
{
"name": "size_order",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Numerical order of deposit size",
"isIdentifier": false,
"sourceFieldPatterns": [
"size_order",
"size_rank"
]
},
{
"name": "location_accuracy_m",
"dataType": "FLOAT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Location accuracy in meters",
"isIdentifier": false,
"sourceFieldPatterns": [
"location_accuracy__m_",
"accuracy",
"loc_accuracy"
]
},
{
"name": "work_extent",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Extent of work undertaken at the site",
"isIdentifier": false,
"sourceFieldPatterns": [
"work_extent",
"work_type",
"development"
]
},
{
"name": "work_extent_comments",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Additional comments on work extent",
"isIdentifier": false,
"sourceFieldPatterns": [
"work_extent_comments",
"work_comments",
"comments"
]
},
{
"name": "data_date",
"dataType": "DATE",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Date when the data was collected or updated",
"isIdentifier": false,
"sourceFieldPatterns": [
"data_date",
"date",
"update_date"
]
},
{
"name": "map_sheet",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Map sheet reference (1:100,000 scale)",
"isIdentifier": false,
"sourceFieldPatterns": [
"map_name__100",
"map_sheet",
"map_name"
]
},
{
"name": "source_id",
"dataType": "TEXT",
"examples": [
"qld_location_479734",
"qld_location_41029"
],
"required": true,
"isGeometry": false,
"description": "Original source identifier",
"isIdentifier": true,
"sourceFieldPatterns": [
"_id",
"id",
"source_id"
]
},
{
"name": "jurisdiction",
"dataType": "TEXT",
"examples": [
"Queensland"
],
"required": true,
"isGeometry": false,
"description": "Administrative jurisdiction",
"isIdentifier": false,
"sourceFieldPatterns": []
},
{
"name": "country",
"dataType": "TEXT",
"examples": [
"AU"
],
"required": true,
"isGeometry": false,
"description": "Country code",
"isIdentifier": false,
"sourceFieldPatterns": []
}
],
"confidence": 0.95,
"description": "A location where minerals have been found, including prospects, deposits, and mine sites in Queensland",
"geometryType": "POINT"
}
}Harmonize au_qld_minocc → Analyze schema
{
"fields": [
{
"name": "_id",
"type": "string",
"pattern": "qld_location_\\d+",
"nullable": false,
"description": "Unique identifier for each mineral occurrence record",
"sampleValues": [
"qld_location_505028",
"qld_location_578277",
"qld_location_38247"
]
},
{
"name": "site_no",
"type": "string",
"nullable": false,
"description": "Site number identifier for the mineral occurrence location",
"sampleValues": [
"505028",
"578277",
"38247",
"37498",
"482729"
]
},
{
"name": "field_id",
"type": "string",
"nullable": true,
"description": "Field identifier or code for the mineral occurrence area",
"sampleValues": [
"OPAL",
"NOCON",
"SQRR364A SEQ",
null
]
},
{
"name": "mine_name",
"type": "string",
"nullable": true,
"description": "Name of the mine associated with the occurrence",
"sampleValues": [
null
]
},
{
"name": "lat94",
"type": "string",
"pattern": "-?\\d+\\.\\d+",
"nullable": false,
"description": "Latitude coordinate in GDA94 datum (decimal degrees)",
"sampleValues": [
"-24.7935694444444444",
"-20.2994916666666666",
"-13.0923500000000000"
]
},
{
"name": "long94",
"type": "string",
"pattern": "-?\\d+\\.\\d+",
"nullable": false,
"description": "Longitude coordinate in GDA94 datum (decimal degrees)",
"sampleValues": [
"142.738777777777777",
"148.287061111111111",
"141.614569444444444"
]
},
{
"name": "mga_zone",
"type": "string",
"nullable": false,
"enumValues": [
"54",
"55",
"56"
],
"description": "Map Grid of Australia (MGA) zone number",
"sampleValues": [
"54",
"55",
"56"
]
},
{
"name": "easting94",
"type": "string",
"nullable": false,
"description": "Easting coordinate in MGA94 projection (meters)",
"sampleValues": [
"675770",
"634386",
"566622",
"324184",
"413075"
]
},
{
"name": "northing94",
"type": "string",
"nullable": false,
"description": "Northing coordinate in MGA94 projection (meters)",
"sampleValues": [
"7256782",
"7754845",
"8552566",
"8072549",
"7017146"
]
},
{
"name": "locality",
"type": "string",
"nullable": false,
"description": "Descriptive location of the mineral occurrence",
"sampleValues": [
"OPALVILLE FIELD, 33 KM WNW OF JUNDAH",
"32.0KM S OF BOWEN",
"31.8 KM NNW OF AURUKUN MISSION."
]
},
{
"name": "mine_status",
"type": "string",
"nullable": true,
"description": "Current operational status of the mine",
"sampleValues": [
null
]
},
{
"name": "exploration_status",
"type": "string",
"nullable": true,
"description": "Status of exploration activities at the site",
"sampleValues": [
null
]
},
{
"name": "deposit_size",
"type": "string",
"nullable": true,
"description": "Size classification of the mineral deposit",
"sampleValues": [
null
]
},
{
"name": "size_order",
"type": "string",
"nullable": true,
"description": "Order of magnitude for deposit size",
"sampleValues": [
null
]
},
{
"name": "data_date",
"type": "string",
"nullable": true,
"description": "Date when the data was collected or last updated",
"sampleValues": [
null
]
},
{
"name": "location_accuracy__m_",
"type": "string",
"nullable": true,
"description": "Accuracy of the location coordinates in meters",
"sampleValues": [
null
]
},
{
"name": "main_commodity",
"type": "string",
"nullable": true,
"description": "Primary commodity or mineral at the occurrence",
"sampleValues": [
null
]
},
{
"name": "main_commodity_size",
"type": "string",
"nullable": true,
"description": "Size or grade of the main commodity",
"sampleValues": [
null
]
},
{
"name": "all_commodities",
"type": "string",
"nullable": true,
"description": "All commodities present at the occurrence",
"sampleValues": [
null
]
},
{
"name": "map_name__100",
"type": "string",
"nullable": true,
"description": "Name of the 1:100,000 scale map sheet",
"sampleValues": [
null
]
},
{
"name": "_000_",
"type": "string",
"nullable": true,
"description": "Unknown field, possibly related to mapping scale",
"sampleValues": [
null
]
},
{
"name": "work_extent",
"type": "string",
"nullable": true,
"description": "Extent or scope of work conducted at the site",
"sampleValues": [
null
]
},
{
"name": "work_extent_comments",
"type": "string",
"nullable": true,
"description": "Additional comments about the work extent",
"sampleValues": [
null
]
},
{
"name": "_mirrored_at",
"type": "date",
"pattern": "YYYY-MM-DD HH:MM:SS.ssssss+TZ",
"nullable": false,
"description": "Timestamp when the record was mirrored or synchronized",
"sampleValues": [
"2026-02-09 19:13:17.23933+00"
]
},
{
"name": "geom",
"type": "geometry",
"nullable": false,
"description": "PostGIS geometry field containing point coordinates",
"sampleValues": [
"0101000020BB10000026524B11A4D7614068FEFA5D27CB38C0"
]
}
],
"semantics": {
"idFields": [
"_id",
"site_no",
"field_id"
],
"nameFields": [
"mine_name",
"locality",
"map_name__100"
],
"primaryKey": "_id",
"statusFields": [
"mine_status",
"exploration_status"
],
"fieldMeanings": {
"_id": "Primary key identifier",
"geom": "Spatial geometry point",
"_000_": "Unknown mapping field",
"lat94": "Latitude coordinate (GDA94)",
"long94": "Longitude coordinate (GDA94)",
"site_no": "Site number identifier",
"field_id": "Field/area identifier",
"locality": "Location description",
"mga_zone": "MGA zone number",
"data_date": "Data collection date",
"easting94": "Easting coordinate (MGA94)",
"mine_name": "Mine name",
"northing94": "Northing coordinate (MGA94)",
"size_order": "Size order magnitude",
"mine_status": "Mine operational status",
"work_extent": "Work scope description",
"_mirrored_at": "Data synchronization timestamp",
"deposit_size": "Deposit size classification",
"map_name__100": "1:100k map sheet name",
"main_commodity": "Primary mineral commodity",
"all_commodities": "All present commodities",
"exploration_status": "Exploration activity status",
"main_commodity_size": "Main commodity size/grade",
"work_extent_comments": "Work extent comments",
"location_accuracy__m_": "Location accuracy in meters"
},
"relationships": [
{
"field": "lat94",
"relatedTo": "long94",
"relationshipType": "coordinate_pair"
},
{
"field": "easting94",
"relatedTo": "northing94",
"relationshipType": "coordinate_pair"
},
{
"field": "geom",
"relatedTo": "lat94",
"relationshipType": "derived_geometry"
},
{
"field": "main_commodity",
"relatedTo": "all_commodities",
"relationshipType": "subset"
},
{
"field": "site_no",
"relatedTo": "_id",
"relationshipType": "alternate_key"
}
],
"geometryFields": [
"geom",
"lat94",
"long94",
"easting94",
"northing94"
],
"commodityFields": [
"main_commodity",
"main_commodity_size",
"all_commodities"
]
},
"confidence": 0.95,
"entityType": "mineral_occurrence",
"recordCount": 100
}Harmonize au_qld_minocc → Generate mappings
{
"mappings": [
{
"confidence": 0.1,
"mappingType": "missing",
"sourceField": "mine_name",
"justification": "mine_name field exists but all values are null in the sample data. This is a required field, so alternative mapping needed.",
"targetAttribute": "name"
},
{
"confidence": 0.7,
"mappingType": "inferred",
"sourceField": "locality",
"justification": "Since mine_name is null, locality provides descriptive location names that can serve as occurrence names, though not ideal for primary naming.",
"targetAttribute": "name"
},
{
"confidence": 0.1,
"mappingType": "missing",
"sourceField": "mine_status",
"justification": "mine_status field exists but all values are null. This is a required field with no viable alternative in the data.",
"targetAttribute": "status"
},
{
"confidence": 0.2,
"mappingType": "missing",
"sourceField": "all_commodities",
"justification": "all_commodities field exists but all values are null. Would need parsing/transformation if data were present.",
"targetAttribute": "commodities"
},
{
"confidence": 0.2,
"mappingType": "missing",
"sourceField": "main_commodity",
"justification": "main_commodity field exists but all values are null. Direct mapping would work if data were present.",
"targetAttribute": "primary_commodity"
},
{
"confidence": 0.95,
"mappingType": "direct",
"sourceField": "_id",
"justification": "Primary identifier field maps directly to source_id as the original identifier from the data source.",
"targetAttribute": "source_id"
},
{
"confidence": 0.6,
"mappingType": "inferred",
"sourceField": "field_id",
"justification": "field_id appears to represent mining field/area codes (MTISA, OPAL) which could serve as regional identifiers.",
"targetAttribute": "region"
},
{
"confidence": 0.1,
"mappingType": "missing",
"sourceField": "data_date",
"justification": "data_date is null and represents data collection date, not discovery date. No discovery year information available.",
"targetAttribute": "discovery_year"
}
],
"featureType": "mineral_occurrence",
"unmappedFields": [
"site_no",
"lat94",
"long94",
"mga_zone",
"easting94",
"northing94",
"exploration_status",
"deposit_size",
"size_order",
"location_accuracy__m_",
"main_commodity_size",
"map_name__100",
"_000_",
"work_extent",
"work_extent_comments",
"_mirrored_at",
"geom"
],
"overallConfidence": 0.4,
"suggestedAttributes": [
{
"name": "site_number",
"dataType": "TEXT",
"description": "Queensland site number identifier"
},
{
"name": "field_identifier",
"dataType": "TEXT",
"description": "Mining field or area code"
},
{
"name": "mga_zone",
"dataType": "INTEGER",
"description": "Map Grid of Australia zone number"
},
{
"name": "easting_mga94",
"dataType": "NUMERIC",
"description": "Easting coordinate in MGA94 projection"
},
{
"name": "northing_mga94",
"dataType": "NUMERIC",
"description": "Northing coordinate in MGA94 projection"
},
{
"name": "location_description",
"dataType": "TEXT",
"description": "Descriptive locality information"
},
{
"name": "exploration_status",
"dataType": "ENUM",
"description": "Status of exploration activities"
},
{
"name": "deposit_size_class",
"dataType": "ENUM",
"description": "Classification of deposit size"
},
{
"name": "location_accuracy_meters",
"dataType": "NUMERIC",
"description": "Accuracy of location coordinates in meters"
},
{
"name": "data_collection_date",
"dataType": "DATE",
"description": "Date when the occurrence data was collected"
}
]
}Harmonize au_qld_minocc → Validate ontology
{
"isValid": false,
"warnings": [
"latitude: 100% of values don't match expected type FLOAT",
"longitude: 100% of values don't match expected type FLOAT",
"easting: 100% of values don't match expected type FLOAT",
"northing: 100% of values don't match expected type FLOAT",
"geometry: 100% of values don't match expected type GEOMETRY"
],
"sourceSlug": "au_qld_minocc",
"featureType": "mineral_occurrence",
"suggestions": [],
"validatedAt": "2026-02-09T19:38:02.849Z",
"criticalIssues": [
"jurisdiction: No matching field found for patterns: state, jurisdiction, province",
"country: No matching field found for patterns: country"
],
"totalAttributes": 24,
"validAttributes": 17,
"validationScore": 71,
"fieldValidations": [
{
"issues": [],
"isValid": true,
"nullCount": 0,
"actualTypes": {
"string": 21290
},
"nullPercent": 0,
"expectedType": "TEXT",
"matchedField": "site_no",
"totalRecords": 21290,
"attributeName": "site_no",
"distinctCount": 21290,
"sourcePatterns": [
"site_no",
"site_number",
"occurrence_id"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 13273,
"actualTypes": {
"string": 8017
},
"nullPercent": 62,
"expectedType": "TEXT",
"matchedField": "field_id",
"totalRecords": 21290,
"attributeName": "field_id",
"distinctCount": 715,
"sourcePatterns": [
"field_id",
"field_code",
"district_id"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": "mine_name",
"totalRecords": 21290,
"attributeName": "name",
"distinctCount": 0,
"sourcePatterns": [
"mine_name",
"name",
"site_name",
"occurrence_name"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 62,
"actualTypes": {
"string": 21228
},
"nullPercent": 0,
"expectedType": "TEXT",
"matchedField": "locality",
"totalRecords": 21290,
"attributeName": "locality",
"distinctCount": 16010,
"sourcePatterns": [
"locality",
"location",
"description",
"location_description"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": "mine_status",
"totalRecords": 21290,
"attributeName": "status",
"distinctCount": 0,
"sourcePatterns": [
"mine_status",
"status",
"operational_status"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": "exploration_status",
"totalRecords": 21290,
"attributeName": "exploration_status",
"distinctCount": 0,
"sourcePatterns": [
"exploration_status",
"exploration_stage"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": "main_commodity",
"totalRecords": 21290,
"attributeName": "primary_commodity",
"distinctCount": 0,
"sourcePatterns": [
"main_commodity",
"primary_commodity",
"commodity"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": "all_commodities",
"totalRecords": 21290,
"attributeName": "commodities",
"distinctCount": 0,
"sourcePatterns": [
"all_commodities",
"commodities",
"minerals"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": "deposit_size",
"totalRecords": 21290,
"attributeName": "deposit_size",
"distinctCount": 0,
"sourcePatterns": [
"deposit_size",
"size_class",
"tonnage_class"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": "size_order",
"totalRecords": 21290,
"attributeName": "size_order",
"distinctCount": 0,
"sourcePatterns": [
"size_order",
"size_rank"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 20087,
"actualTypes": {
"string": 1203
},
"nullPercent": 94,
"expectedType": "TEXT",
"matchedField": "work_extent",
"totalRecords": 21290,
"attributeName": "work_extent",
"distinctCount": 1113,
"sourcePatterns": [
"work_extent",
"development_extent"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": "work_extent_comments",
"totalRecords": 21290,
"attributeName": "work_extent_comments",
"distinctCount": 0,
"sourcePatterns": [
"work_extent_comments",
"development_comments"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "FLOAT",
"matchedField": "location_accuracy__m_",
"totalRecords": 21290,
"attributeName": "location_accuracy_m",
"distinctCount": 0,
"sourcePatterns": [
"location_accuracy__m_",
"accuracy_m",
"positional_accuracy"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "DATE",
"matchedField": "data_date",
"totalRecords": 21290,
"attributeName": "data_date",
"distinctCount": 0,
"sourcePatterns": [
"data_date",
"record_date",
"survey_date"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": "map_name__100",
"totalRecords": 21290,
"attributeName": "map_sheet",
"distinctCount": 0,
"sourcePatterns": [
"map_name__100",
"map_sheet",
"topographic_map"
],
"typeMismatchPercent": 0
},
{
"issues": [
"100% of values don't match expected type FLOAT"
],
"isValid": false,
"nullCount": 0,
"actualTypes": {
"string": 21290
},
"nullPercent": 0,
"expectedType": "FLOAT",
"matchedField": "lat94",
"sampleIssues": [
"-24.9582833333333333",
"-22.6976250000000000",
"-22.6966111111111111",
"-22.7178833333333333",
"-22.7403111111111111"
],
"totalRecords": 21290,
"attributeName": "latitude",
"distinctCount": 21028,
"sourcePatterns": [
"lat94",
"latitude",
"lat"
],
"typeMismatchPercent": 100
},
{
"issues": [
"100% of values don't match expected type FLOAT"
],
"isValid": false,
"nullCount": 0,
"actualTypes": {
"string": 21290
},
"nullPercent": 0,
"expectedType": "FLOAT",
"matchedField": "long94",
"sampleIssues": [
"152.201111111111111",
"147.499655555555555",
"147.500275000000000",
"147.494383333333333",
"147.515794444444444"
],
"totalRecords": 21290,
"attributeName": "longitude",
"distinctCount": 21056,
"sourcePatterns": [
"long94",
"longitude",
"lon",
"lng"
],
"typeMismatchPercent": 100
},
{
"issues": [
"100% of values don't match expected type FLOAT"
],
"isValid": false,
"nullCount": 0,
"actualTypes": {
"string": 21290
},
"nullPercent": 0,
"expectedType": "FLOAT",
"matchedField": "easting94",
"sampleIssues": [
"419355",
"551320",
"551384",
"550771",
"552961"
],
"totalRecords": 21290,
"attributeName": "easting",
"distinctCount": 17177,
"sourcePatterns": [
"easting94",
"easting",
"x"
],
"typeMismatchPercent": 100
},
{
"issues": [
"100% of values don't match expected type FLOAT"
],
"isValid": false,
"nullCount": 0,
"actualTypes": {
"string": 21290
},
"nullPercent": 0,
"expectedType": "FLOAT",
"matchedField": "northing94",
"sampleIssues": [
"7239425",
"7489857",
"7489969",
"7487617",
"7485126"
],
"totalRecords": 21290,
"attributeName": "northing",
"distinctCount": 17599,
"sourcePatterns": [
"northing94",
"northing",
"y"
],
"typeMismatchPercent": 100
},
{
"issues": [],
"isValid": true,
"nullCount": 0,
"actualTypes": {
"string": 21290
},
"nullPercent": 0,
"expectedType": "TEXT",
"matchedField": "mga_zone",
"totalRecords": 21290,
"attributeName": "mga_zone",
"distinctCount": 3,
"sourcePatterns": [
"mga_zone",
"zone",
"utm_zone"
],
"typeMismatchPercent": 0
},
{
"issues": [
"100% of values don't match expected type GEOMETRY"
],
"isValid": false,
"nullCount": 0,
"actualTypes": {
"string": 21290
},
"nullPercent": 0,
"expectedType": "GEOMETRY",
"matchedField": "geom",
"sampleIssues": [
"0101000020BB100000B4A291806F066340F2F7780E52F538C0",
"0101000020BB10000007CCA52DFD6F62403BDF4F8D97B236C0",
"0101000020BB1000003480B74002706240A040141B55B236C0",
"0101000020BB100000550BFFFCD16F62409802BF33C7B736C0",
"0101000020BB1000001ECB59638170624070166B0785BD36C0"
],
"totalRecords": 21290,
"attributeName": "geometry",
"distinctCount": 21267,
"sourcePatterns": [
"geom",
"geometry",
"shape"
],
"typeMismatchPercent": 100
},
{
"issues": [],
"isValid": true,
"nullCount": 0,
"actualTypes": {
"string": 21290
},
"nullPercent": 0,
"expectedType": "TEXT",
"matchedField": "_id",
"totalRecords": 21290,
"attributeName": "source_id",
"distinctCount": 21290,
"sourcePatterns": [
"_id",
"id",
"source_id"
],
"typeMismatchPercent": 0
},
{
"issues": [
"No matching field found for patterns: state, jurisdiction, province"
],
"isValid": false,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": null,
"totalRecords": 21290,
"attributeName": "jurisdiction",
"distinctCount": 0,
"sourcePatterns": [
"state",
"jurisdiction",
"province"
],
"typeMismatchPercent": 100
},
{
"issues": [
"No matching field found for patterns: country"
],
"isValid": false,
"nullCount": 21290,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": null,
"totalRecords": 21290,
"attributeName": "country",
"distinctCount": 0,
"sourcePatterns": [
"country"
],
"typeMismatchPercent": 100
}
],
"recordsValidated": 21290,
"attributesWithIssues": 7
}Harmonize au_qld_minocc → Derive ontology
{
"domain": "mining",
"qualityNotes": [
"Most commodity fields are null in the sample data, indicating incomplete commodity information",
"Mine names are mostly null, suggesting many occurrences are unnamed prospects rather than developed mines",
"Status fields (mine_status, exploration_status) are consistently null, indicating missing operational status data",
"Deposit size information is missing from all sample records",
"Data appears to be primarily location-focused with limited attribute completeness",
"Coordinates are provided in both decimal degrees (GDA94) and MGA projected coordinates",
"Location accuracy field exists but is null in samples, suggesting precision metadata may be incomplete",
"The '_000_' field appears to be a data artifact and should be ignored",
"Locality descriptions provide valuable contextual location information relative to landmarks"
],
"commonPatterns": {
"dateFields": [
"data_date",
"_mirrored_at"
],
"statusFields": [
"mine_status",
"exploration_status"
],
"geometryFields": [
"geom",
"lat94",
"long94",
"easting94",
"northing94"
],
"commodityFields": [
"main_commodity",
"all_commodities",
"main_commodity_size"
],
"identifierFields": [
"_id",
"site_no",
"field_id"
],
"measurementFields": [
"location_accuracy__m_",
"deposit_size",
"size_order"
]
},
"alternativeTypes": [],
"primaryFeatureType": {
"name": "Mineral Occurrence",
"slug": "mineral_occurrence",
"reasoning": "This dataset represents Queensland mineral occurrences with point locations. The presence of fields like 'main_commodity', 'all_commodities', 'mine_name', 'mine_status', and 'exploration_status' clearly indicates these are mineral occurrence sites. The data includes both active and historical mineral sites.",
"attributes": [
{
"name": "site_no",
"dataType": "TEXT",
"examples": [
"481721",
"480587",
"493895"
],
"required": true,
"isGeometry": false,
"description": "Unique site number identifier from Queensland government",
"isIdentifier": true,
"sourceFieldPatterns": [
"site_no",
"site_number",
"occurrence_id"
]
},
{
"name": "field_id",
"dataType": "TEXT",
"examples": [
"MARYB"
],
"required": false,
"isGeometry": false,
"description": "Field identifier code for grouping related occurrences",
"isIdentifier": false,
"sourceFieldPatterns": [
"field_id",
"field_code",
"district_id"
]
},
{
"name": "name",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Name of the mine or occurrence site",
"isIdentifier": false,
"sourceFieldPatterns": [
"mine_name",
"name",
"site_name",
"occurrence_name"
]
},
{
"name": "locality",
"dataType": "TEXT",
"examples": [
"11.6 KM S OF RAVENSWOOD.",
"14.0 KM NNE OF GEORGETOWN."
],
"required": false,
"isGeometry": false,
"description": "Descriptive location relative to nearby landmarks",
"isIdentifier": false,
"sourceFieldPatterns": [
"locality",
"location",
"description",
"location_description"
]
},
{
"name": "status",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Current operational status of the mine or occurrence",
"isIdentifier": false,
"sourceFieldPatterns": [
"mine_status",
"status",
"operational_status"
]
},
{
"name": "exploration_status",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Current exploration status of the occurrence",
"isIdentifier": false,
"sourceFieldPatterns": [
"exploration_status",
"exploration_stage"
]
},
{
"name": "primary_commodity",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Primary mineral commodity at this occurrence",
"isIdentifier": false,
"sourceFieldPatterns": [
"main_commodity",
"primary_commodity",
"commodity"
]
},
{
"name": "commodities",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "All mineral commodities present at this occurrence",
"isIdentifier": false,
"sourceFieldPatterns": [
"all_commodities",
"commodities",
"minerals"
]
},
{
"name": "deposit_size",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Size classification of the mineral deposit",
"isIdentifier": false,
"sourceFieldPatterns": [
"deposit_size",
"size_class",
"tonnage_class"
]
},
{
"name": "size_order",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Numerical order of deposit size",
"isIdentifier": false,
"sourceFieldPatterns": [
"size_order",
"size_rank"
]
},
{
"name": "work_extent",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Extent of mining or exploration work conducted",
"isIdentifier": false,
"sourceFieldPatterns": [
"work_extent",
"development_extent"
]
},
{
"name": "work_extent_comments",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Additional comments about work extent",
"isIdentifier": false,
"sourceFieldPatterns": [
"work_extent_comments",
"development_comments"
]
},
{
"name": "location_accuracy_m",
"dataType": "FLOAT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Accuracy of the location coordinates in meters",
"isIdentifier": false,
"sourceFieldPatterns": [
"location_accuracy__m_",
"accuracy_m",
"positional_accuracy"
]
},
{
"name": "data_date",
"dataType": "DATE",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Date when the occurrence data was recorded or updated",
"isIdentifier": false,
"sourceFieldPatterns": [
"data_date",
"record_date",
"survey_date"
]
},
{
"name": "map_sheet",
"dataType": "TEXT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Map sheet reference (1:100,000 scale)",
"isIdentifier": false,
"sourceFieldPatterns": [
"map_name__100",
"map_sheet",
"topographic_map"
]
},
{
"name": "latitude",
"dataType": "FLOAT",
"examples": [
"-20.2050638888888888",
"-18.1770500000000000"
],
"required": true,
"isGeometry": false,
"description": "Latitude coordinate in decimal degrees (GDA94)",
"isIdentifier": false,
"sourceFieldPatterns": [
"lat94",
"latitude",
"lat"
]
},
{
"name": "longitude",
"dataType": "FLOAT",
"examples": [
"146.881113888888888",
"143.603552777777777"
],
"required": true,
"isGeometry": false,
"description": "Longitude coordinate in decimal degrees (GDA94)",
"isIdentifier": false,
"sourceFieldPatterns": [
"long94",
"longitude",
"lon",
"lng"
]
},
{
"name": "easting",
"dataType": "FLOAT",
"examples": [
"487580",
"775420"
],
"required": false,
"isGeometry": false,
"description": "Easting coordinate in Map Grid of Australia (MGA)",
"isIdentifier": false,
"sourceFieldPatterns": [
"easting94",
"easting",
"x"
]
},
{
"name": "northing",
"dataType": "FLOAT",
"examples": [
"7765814",
"7988266"
],
"required": false,
"isGeometry": false,
"description": "Northing coordinate in Map Grid of Australia (MGA)",
"isIdentifier": false,
"sourceFieldPatterns": [
"northing94",
"northing",
"y"
]
},
{
"name": "mga_zone",
"dataType": "TEXT",
"examples": [
"55",
"54",
"56"
],
"required": false,
"isGeometry": false,
"description": "Map Grid of Australia zone number",
"isIdentifier": false,
"sourceFieldPatterns": [
"mga_zone",
"zone",
"utm_zone"
]
},
{
"name": "geometry",
"dataType": "GEOMETRY",
"examples": [
"POINT"
],
"required": true,
"isGeometry": true,
"description": "Point geometry of the occurrence location",
"isIdentifier": false,
"sourceFieldPatterns": [
"geom",
"geometry",
"shape"
]
},
{
"name": "source_id",
"dataType": "TEXT",
"examples": [
"qld_location_481721",
"qld_location_480587"
],
"required": true,
"isGeometry": false,
"description": "Original source identifier",
"isIdentifier": true,
"sourceFieldPatterns": [
"_id",
"id",
"source_id"
]
},
{
"name": "jurisdiction",
"dataType": "TEXT",
"examples": [
"Queensland"
],
"required": true,
"isGeometry": false,
"description": "Administrative jurisdiction (Queensland, Australia)",
"isIdentifier": false,
"sourceFieldPatterns": [
"state",
"jurisdiction",
"province"
]
},
{
"name": "country",
"dataType": "TEXT",
"examples": [
"Australia"
],
"required": true,
"isGeometry": false,
"description": "Country where the occurrence is located",
"isIdentifier": false,
"sourceFieldPatterns": [
"country"
]
}
],
"confidence": 0.95,
"description": "A location where minerals have been found or are suspected to occur, including prospects, deposits, and mine sites",
"geometryType": "POINT"
}
}Harmonize au_qld_minocc → Analyze schema
{
"fields": [
{
"name": "_id",
"type": "string",
"pattern": "qld_location_\\d+",
"nullable": false,
"description": "Unique identifier for each Queensland mining location record",
"sampleValues": [
"qld_location_506572",
"qld_location_531877",
"qld_location_544501"
]
},
{
"name": "site_no",
"type": "string",
"nullable": false,
"description": "Site number identifier, appears to be numeric but stored as string",
"sampleValues": [
"506572",
"531877",
"544501",
"578631",
"45483"
]
},
{
"name": "field_id",
"type": "string",
"nullable": true,
"description": "Mining field identifier or area code",
"sampleValues": [
"MTISA",
"424 EXT",
"OPAL",
null
]
},
{
"name": "mine_name",
"type": "string",
"nullable": true,
"description": "Name of the mine (all null in sample)",
"sampleValues": [
null
]
},
{
"name": "lat94",
"type": "string",
"nullable": false,
"description": "Latitude coordinate in GDA94 datum, stored as string with high precision",
"sampleValues": [
"-21.2496638888888888",
"-20.8692555555555555",
"-17.0298972222222222"
]
},
{
"name": "long94",
"type": "string",
"nullable": false,
"description": "Longitude coordinate in GDA94 datum, stored as string with high precision",
"sampleValues": [
"140.330355555555555",
"139.779150000000000",
"145.309613888888888"
]
},
{
"name": "mga_zone",
"type": "string",
"nullable": false,
"enumValues": [
"54",
"55"
],
"description": "Map Grid of Australia (MGA) zone number",
"sampleValues": [
"54",
"55"
]
},
{
"name": "easting94",
"type": "string",
"nullable": false,
"description": "Easting coordinate in MGA94 projection, stored as string",
"sampleValues": [
"430520",
"373001",
"320076",
"573831",
"681471"
]
},
{
"name": "northing94",
"type": "string",
"nullable": false,
"description": "Northing coordinate in MGA94 projection, stored as string",
"sampleValues": [
"7650066",
"7691832",
"8116354",
"7405097",
"7252006"
]
},
{
"name": "locality",
"type": "string",
"nullable": false,
"description": "Descriptive location or locality name",
"sampleValues": [
"105KM ESE OF MT ISA, 20KM S OF MALBON",
"33.9KM EAST-SOUTH-EAST OF MOUNT ISA",
"BOWER RD MAREEBA"
]
},
{
"name": "mine_status",
"type": "string",
"nullable": true,
"description": "Current status of the mine (all null in sample)",
"sampleValues": [
null
]
},
{
"name": "exploration_status",
"type": "string",
"nullable": true,
"description": "Status of exploration activities (all null in sample)",
"sampleValues": [
null
]
},
{
"name": "deposit_size",
"type": "string",
"nullable": true,
"description": "Size classification of the deposit (all null in sample)",
"sampleValues": [
null
]
},
{
"name": "size_order",
"type": "string",
"nullable": true,
"description": "Ordering or ranking by size (all null in sample)",
"sampleValues": [
null
]
},
{
"name": "data_date",
"type": "date",
"nullable": true,
"description": "Date when the data was recorded (all null in sample)",
"sampleValues": [
null
]
},
{
"name": "location_accuracy__m_",
"type": "number",
"nullable": true,
"description": "Location accuracy in meters (all null in sample)",
"sampleValues": [
null
]
},
{
"name": "main_commodity",
"type": "string",
"nullable": true,
"description": "Primary commodity or mineral found at the location (all null in sample)",
"sampleValues": [
null
]
},
{
"name": "main_commodity_size",
"type": "string",
"nullable": true,
"description": "Size or quantity of the main commodity (all null in sample)",
"sampleValues": [
null
]
},
{
"name": "all_commodities",
"type": "string",
"nullable": true,
"description": "List or description of all commodities present (all null in sample)",
"sampleValues": [
null
]
},
{
"name": "map_name__100",
"type": "string",
"nullable": true,
"description": "Map name at 1:100,000 scale (all null in sample)",
"sampleValues": [
null
]
},
{
"name": "_000_",
"type": "string",
"nullable": true,
"description": "Unknown field, possibly map scale related (all null in sample)",
"sampleValues": [
null
]
},
{
"name": "work_extent",
"type": "string",
"nullable": true,
"description": "Extent or scope of mining/exploration work (all null in sample)",
"sampleValues": [
null
]
},
{
"name": "work_extent_comments",
"type": "string",
"nullable": true,
"description": "Comments about the work extent (all null in sample)",
"sampleValues": [
null
]
},
{
"name": "_mirrored_at",
"type": "date",
"pattern": "YYYY-MM-DD HH:MM:SS.ssssss+TZ",
"nullable": false,
"description": "Timestamp when the record was mirrored/synchronized",
"sampleValues": [
"2026-02-09 19:13:17.23933+00"
]
},
{
"name": "geom",
"type": "geometry",
"nullable": false,
"description": "PostGIS geometry field containing point coordinates in hexadecimal WKB format",
"sampleValues": [
"0101000020BB1000003765D045928A61401CC5FDF8E93F35C0",
"0101000020BB100000B515FBCBEE78614038FA368887DE34C0"
]
}
],
"semantics": {
"idFields": [
"_id",
"site_no",
"field_id"
],
"nameFields": [
"mine_name",
"locality",
"map_name__100"
],
"primaryKey": "_id",
"statusFields": [
"mine_status",
"exploration_status"
],
"fieldMeanings": {
"_id": "Primary key identifier",
"geom": "Point geometry",
"_000_": "Unknown map-related field",
"lat94": "Latitude coordinate (GDA94)",
"long94": "Longitude coordinate (GDA94)",
"site_no": "Site number identifier",
"field_id": "Mining field/area identifier",
"locality": "Location description",
"mga_zone": "Map Grid Australia zone",
"data_date": "Data collection date",
"easting94": "Easting coordinate (MGA94)",
"mine_name": "Mine name",
"northing94": "Northing coordinate (MGA94)",
"size_order": "Size ranking",
"mine_status": "Mine operational status",
"work_extent": "Mining/exploration work scope",
"_mirrored_at": "Data synchronization timestamp",
"deposit_size": "Deposit size classification",
"map_name__100": "1:100,000 scale map name",
"main_commodity": "Primary mineral/commodity",
"all_commodities": "All commodities present",
"exploration_status": "Exploration activity status",
"main_commodity_size": "Main commodity quantity",
"work_extent_comments": "Work extent notes",
"location_accuracy__m_": "Location accuracy in meters"
},
"relationships": [
{
"field": "lat94",
"relatedTo": "long94",
"relationshipType": "coordinate_pair"
},
{
"field": "easting94",
"relatedTo": "northing94",
"relationshipType": "coordinate_pair"
},
{
"field": "geom",
"relatedTo": "lat94,long94",
"relationshipType": "geometry_representation"
},
{
"field": "site_no",
"relatedTo": "_id",
"relationshipType": "identifier_variant"
}
],
"geometryFields": [
"geom",
"lat94",
"long94",
"easting94",
"northing94"
],
"commodityFields": [
"main_commodity",
"main_commodity_size",
"all_commodities"
]
},
"confidence": 0.95,
"entityType": "mineral_occurrence",
"recordCount": 100
}