Harmonize au_tas_minocc → Generate mappings
{
"mappings": [
{
"confidence": 0.95,
"mappingType": "direct",
"sourceField": "deposit_name",
"justification": "deposit_name is the primary name field for the mineral occurrence, directly maps to the required name attribute",
"targetAttribute": "name"
},
{
"transform": {
"type": "expression",
"expression": "ARRAY[alias] WHERE alias IS NOT NULL"
},
"confidence": 0.85,
"mappingType": "computed",
"sourceField": "alias",
"justification": "alias field contains alternative names that need to be converted to array format",
"targetAttribute": "alternate_names"
},
{
"transform": {
"type": "lookup",
"lookupTable": "operational_status_mapping"
},
"confidence": 0.9,
"mappingType": "lookup",
"sourceField": "operational_status",
"justification": "operational_status maps to status but needs standardization through lookup table for enum values",
"targetAttribute": "status"
},
{
"transform": {
"type": "expression",
"expression": "PARSE_COMMODITIES_TO_SYMBOLS(commodities)"
},
"confidence": 0.8,
"mappingType": "computed",
"sourceField": "commodities",
"justification": "commodities field contains commodity names that need parsing and conversion to element symbols array",
"targetAttribute": "commodities"
},
{
"transform": {
"type": "expression",
"expression": "EXTRACT_PRIMARY_COMMODITY(commodities)"
},
"confidence": 0.85,
"mappingType": "computed",
"sourceField": "commodities",
"justification": "commodities field contains the primary commodity, needs extraction of first/main commodity",
"targetAttribute": "primary_commodity"
},
{
"transform": {
"type": "lookup",
"lookupTable": "deposit_type_mapping"
},
"confidence": 0.85,
"mappingType": "lookup",
"sourceField": "deposit_type",
"justification": "deposit_type maps directly but needs standardization for enum values",
"targetAttribute": "deposit_type"
},
{
"transform": {
"type": "lookup",
"lookupTable": "extractability_to_mining_method"
},
"confidence": 0.7,
"mappingType": "lookup",
"sourceField": "extractability",
"justification": "extractability field provides some indication of mining method but needs interpretation and lookup",
"targetAttribute": "mining_method"
},
{
"confidence": 0.9,
"mappingType": "direct",
"sourceField": "lithology",
"justification": "lithology field directly describes the host rock type",
"targetAttribute": "host_rock"
},
{
"transform": {
"type": "lookup",
"lookupTable": "geological_age_mapping"
},
"confidence": 0.85,
"mappingType": "lookup",
"sourceField": "mineralage",
"justification": "mineralage contains geological age information that needs standardization for enum values",
"targetAttribute": "geological_age"
},
{
"confidence": 0.8,
"mappingType": "direct",
"sourceField": "locality",
"justification": "locality field provides local geographic area information suitable for region attribute",
"targetAttribute": "region"
},
{
"confidence": 0.95,
"mappingType": "direct",
"sourceField": "_id",
"justification": "_id is the unique identifier from the source system, directly maps to source_id",
"targetAttribute": "source_id"
}
],
"featureType": "mineral_occurrence",
"unmappedFields": [
"_geom",
"commodity_category",
"data_metallogenica",
"deposit_id",
"deposit_size",
"description",
"details",
"dip",
"exploration_type",
"form",
"gangue",
"genetic",
"gid",
"host_age",
"lithostratigraphy",
"location_accuracy",
"location_method",
"ore_description",
"ore_genesis",
"outcrops",
"parent_id",
"report_references",
"resources",
"rl",
"rl_acc",
"status_date",
"strike",
"tests",
"type",
"uses",
"weathered",
"_mirrored_at",
"geom"
],
"overallConfidence": 0.83,
"suggestedAttributes": [
{
"name": "deposit_size",
"dataType": "ENUM",
"description": "Size classification of the mineral deposit"
},
{
"name": "exploration_activities",
"dataType": "ARRAY",
"description": "Types of exploration activities conducted"
},
{
"name": "geological_form",
"dataType": "TEXT",
"description": "Geological form or structure of mineralization"
},
{
"name": "gangue_minerals",
"dataType": "ARRAY",
"description": "Associated gangue minerals"
},
{
"name": "ore_genesis",
"dataType": "TEXT",
"description": "Genesis or formation process of the ore"
},
{
"name": "location_accuracy_m",
"dataType": "INTEGER",
"description": "Location accuracy in meters"
},
{
"name": "elevation_m",
"dataType": "FLOAT",
"description": "Elevation above sea level in meters"
},
{
"name": "structural_data",
"dataType": "OBJECT",
"description": "Strike and dip measurements"
},
{
"name": "resource_classification",
"dataType": "ENUM",
"description": "Resource classification status"
},
{
"name": "reference_reports",
"dataType": "ARRAY",
"description": "References to geological reports"
}
]
}Harmonize au_tas_minocc → Validate ontology
{
"isValid": false,
"warnings": [
"commodity_category: Found 3 unexpected enum values: Unknown, Fuel Minerals, Industrial Minerals/Gemstones",
"status: Found 4 unexpected enum values: Prospect, Non-operating, Occasionally Operating, Fully Operating",
"strike_degrees: 100% of values don't match expected type FLOAT",
"dip_degrees: 100% of values don't match expected type FLOAT",
"location_accuracy: 100% of values don't match expected type INTEGER",
"geometry: 100% of values don't match expected type GEOMETRY"
],
"sourceSlug": "au_tas_minocc",
"featureType": "mineral_occurrence",
"suggestions": [],
"validatedAt": "2026-02-09T20:04:32.822Z",
"criticalIssues": [
"jurisdiction: No matching field found for patterns: ",
"country: No matching field found for patterns: "
],
"totalAttributes": 31,
"validAttributes": 23,
"validationScore": 74,
"fieldValidations": [
{
"issues": [],
"isValid": true,
"nullCount": 0,
"actualTypes": {
"string": 8295
},
"nullPercent": 0,
"expectedType": "TEXT",
"matchedField": "_id",
"totalRecords": 8295,
"attributeName": "source_id",
"distinctCount": 8295,
"sourcePatterns": [
"_id",
"deposit_id",
"gid"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 0,
"actualTypes": {
"string": 8295
},
"nullPercent": 0,
"expectedType": "TEXT",
"matchedField": "deposit_name",
"totalRecords": 8295,
"attributeName": "name",
"distinctCount": 4642,
"sourcePatterns": [
"deposit_name"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 7065,
"actualTypes": {
"string": 1230
},
"nullPercent": 85,
"expectedType": "TEXT",
"matchedField": "alias",
"totalRecords": 8295,
"attributeName": "alternate_names",
"distinctCount": 1196,
"sourcePatterns": [
"alias"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 33,
"actualTypes": {
"string": 8262
},
"nullPercent": 0,
"expectedType": "TEXT",
"matchedField": "commodities",
"totalRecords": 8295,
"attributeName": "commodities",
"distinctCount": 376,
"sourcePatterns": [
"commodities"
],
"typeMismatchPercent": 0
},
{
"issues": [
"Found 3 unexpected enum values: Unknown, Fuel Minerals, Industrial Minerals/Gemstones"
],
"isValid": false,
"nullCount": 0,
"actualEnums": [
"Construction Materials",
"Construction Materials, Industrial Minerals/Gemstones",
"Fuel Minerals",
"Geothermal",
"Industrial Minerals/Gemstones",
"Industrial Minerals/Gemstones, Metals",
"Metals",
"Unknown"
],
"actualTypes": {
"string": 8295
},
"nullPercent": 0,
"expectedType": "TEXT",
"matchedField": "commodity_category",
"missingEnums": [],
"totalRecords": 8295,
"attributeName": "commodity_category",
"distinctCount": 8,
"expectedEnums": [
"Construction Materials",
"Metals"
],
"sourcePatterns": [
"commodity_category"
],
"unexpectedValues": [
"Unknown",
"Fuel Minerals",
"Industrial Minerals/Gemstones"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 0,
"actualTypes": {
"string": 8295
},
"nullPercent": 0,
"expectedType": "TEXT",
"matchedField": "deposit_type",
"totalRecords": 8295,
"attributeName": "deposit_type",
"distinctCount": 5,
"sourcePatterns": [
"deposit_type",
"type"
],
"typeMismatchPercent": 0
},
{
"issues": [
"Found 4 unexpected enum values: Prospect, Non-operating, Occasionally Operating, Fully Operating"
],
"isValid": false,
"nullCount": 92,
"actualEnums": [
"Abandoned",
"Fully Operating",
"Mineral occurrence",
"Mineralised area",
"New area",
"Non-operating",
"Occasionally Operating",
"Prospect",
"Unknown"
],
"actualTypes": {
"string": 8203
},
"nullPercent": 1,
"expectedType": "TEXT",
"matchedField": "operational_status",
"missingEnums": [],
"totalRecords": 8295,
"attributeName": "status",
"distinctCount": 9,
"expectedEnums": [
"Unknown",
"Mineralised area",
"Abandoned",
"Mineral occurrence"
],
"sourcePatterns": [
"operational_status"
],
"unexpectedValues": [
"Prospect",
"Non-operating",
"Occasionally Operating",
"Fully Operating"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 357,
"actualTypes": {
"string": 7938
},
"nullPercent": 4,
"expectedType": "TEXT",
"matchedField": "deposit_size",
"totalRecords": 8295,
"attributeName": "deposit_size",
"distinctCount": 6,
"sourcePatterns": [
"deposit_size"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 4634,
"actualTypes": {
"string": 3661
},
"nullPercent": 56,
"expectedType": "TEXT",
"matchedField": "description",
"totalRecords": 8295,
"attributeName": "description",
"distinctCount": 2937,
"sourcePatterns": [
"description"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 1373,
"actualTypes": {
"string": 6922
},
"nullPercent": 17,
"expectedType": "TEXT",
"matchedField": "locality",
"totalRecords": 8295,
"attributeName": "locality",
"distinctCount": 3374,
"sourcePatterns": [
"locality"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 2334,
"actualTypes": {
"string": 5961
},
"nullPercent": 28,
"expectedType": "TEXT",
"matchedField": "lithology",
"totalRecords": 8295,
"attributeName": "host_rock",
"distinctCount": 644,
"sourcePatterns": [
"lithology"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 4079,
"actualTypes": {
"string": 4216
},
"nullPercent": 49,
"expectedType": "TEXT",
"matchedField": "host_age",
"totalRecords": 8295,
"attributeName": "geological_age",
"distinctCount": 98,
"sourcePatterns": [
"host_age"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 4245,
"actualTypes": {
"string": 4050
},
"nullPercent": 51,
"expectedType": "TEXT",
"matchedField": "lithostratigraphy",
"totalRecords": 8295,
"attributeName": "lithostratigraphy",
"distinctCount": 332,
"sourcePatterns": [
"lithostratigraphy"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 3936,
"actualTypes": {
"string": 4359
},
"nullPercent": 47,
"expectedType": "TEXT",
"matchedField": "mineralage",
"totalRecords": 8295,
"attributeName": "mineralization_age",
"distinctCount": 35,
"sourcePatterns": [
"mineralage"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 3851,
"actualTypes": {
"string": 4444
},
"nullPercent": 46,
"expectedType": "TEXT",
"matchedField": "form",
"totalRecords": 8295,
"attributeName": "ore_form",
"distinctCount": 66,
"sourcePatterns": [
"form"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 6418,
"actualTypes": {
"string": 1877
},
"nullPercent": 77,
"expectedType": "TEXT",
"matchedField": "gangue",
"totalRecords": 8295,
"attributeName": "gangue_minerals",
"distinctCount": 622,
"sourcePatterns": [
"gangue"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 5273,
"actualTypes": {
"string": 3022
},
"nullPercent": 64,
"expectedType": "TEXT",
"matchedField": "genetic",
"totalRecords": 8295,
"attributeName": "genetic_type",
"distinctCount": 41,
"sourcePatterns": [
"genetic"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 3625,
"actualTypes": {
"string": 4670
},
"nullPercent": 44,
"expectedType": "TEXT",
"matchedField": "exploration_type",
"totalRecords": 8295,
"attributeName": "exploration_methods",
"distinctCount": 33,
"sourcePatterns": [
"exploration_type"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 5625,
"actualTypes": {
"string": 2670
},
"nullPercent": 68,
"expectedType": "TEXT",
"matchedField": "extractability",
"totalRecords": 8295,
"attributeName": "extractability",
"distinctCount": 5,
"sourcePatterns": [
"extractability"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 5510,
"actualTypes": {
"string": 2785
},
"nullPercent": 66,
"expectedType": "TEXT",
"matchedField": "uses",
"totalRecords": 8295,
"attributeName": "uses",
"distinctCount": 193,
"sourcePatterns": [
"uses"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 6840,
"actualTypes": {
"string": 1455
},
"nullPercent": 82,
"expectedType": "TEXT",
"matchedField": "tests",
"totalRecords": 8295,
"attributeName": "tests_conducted",
"distinctCount": 26,
"sourcePatterns": [
"tests"
],
"typeMismatchPercent": 0
},
{
"issues": [
"100% of values don't match expected type FLOAT"
],
"isValid": false,
"nullCount": 7346,
"actualTypes": {
"string": 949
},
"nullPercent": 89,
"expectedType": "FLOAT",
"matchedField": "strike",
"sampleIssues": [
"40",
"335",
"40",
"333",
"10"
],
"totalRecords": 8295,
"attributeName": "strike_degrees",
"distinctCount": 252,
"sourcePatterns": [
"strike"
],
"typeMismatchPercent": 100
},
{
"issues": [
"100% of values don't match expected type FLOAT"
],
"isValid": false,
"nullCount": 8137,
"actualTypes": {
"string": 158
},
"nullPercent": 98,
"expectedType": "FLOAT",
"matchedField": "dip",
"sampleIssues": [
"-50",
"-75",
"-84",
"-70",
"-60"
],
"totalRecords": 8295,
"attributeName": "dip_degrees",
"distinctCount": 34,
"sourcePatterns": [
"dip"
],
"typeMismatchPercent": 100
},
{
"issues": [
"100% of values don't match expected type INTEGER"
],
"isValid": false,
"nullCount": 84,
"actualTypes": {
"string": 8211
},
"nullPercent": 1,
"expectedType": "INTEGER",
"matchedField": "location_accuracy",
"sampleIssues": [
"50",
"50",
"-999",
"100",
"50"
],
"totalRecords": 8295,
"attributeName": "location_accuracy",
"distinctCount": 12,
"sourcePatterns": [
"location_accuracy"
],
"typeMismatchPercent": 100
},
{
"issues": [],
"isValid": true,
"nullCount": 6921,
"actualTypes": {
"string": 1374
},
"nullPercent": 83,
"expectedType": "TEXT",
"matchedField": "location_method",
"totalRecords": 8295,
"attributeName": "location_method",
"distinctCount": 8,
"sourcePatterns": [
"location_method"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 3981,
"actualTypes": {
"string": 4314
},
"nullPercent": 48,
"expectedType": "TEXT",
"matchedField": "report_references",
"totalRecords": 8295,
"attributeName": "report_references",
"distinctCount": 2592,
"sourcePatterns": [
"report_references"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 0,
"actualTypes": {
"string": 8295
},
"nullPercent": 0,
"expectedType": "TEXT",
"matchedField": "details",
"totalRecords": 8295,
"attributeName": "source_url",
"distinctCount": 8292,
"sourcePatterns": [
"details"
],
"typeMismatchPercent": 0
},
{
"issues": [],
"isValid": true,
"nullCount": 0,
"actualTypes": {
"string": 8295
},
"nullPercent": 0,
"expectedType": "BOOLEAN",
"matchedField": "resources",
"totalRecords": 8295,
"attributeName": "has_resources",
"distinctCount": 2,
"sourcePatterns": [
"resources"
],
"typeMismatchPercent": 0
},
{
"issues": [
"No matching field found for patterns: "
],
"isValid": false,
"nullCount": 8295,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": null,
"totalRecords": 8295,
"attributeName": "jurisdiction",
"distinctCount": 0,
"sourcePatterns": [],
"typeMismatchPercent": 100
},
{
"issues": [
"No matching field found for patterns: "
],
"isValid": false,
"nullCount": 8295,
"actualTypes": {},
"nullPercent": 100,
"expectedType": "TEXT",
"matchedField": null,
"totalRecords": 8295,
"attributeName": "country",
"distinctCount": 0,
"sourcePatterns": [],
"typeMismatchPercent": 100
},
{
"issues": [
"100% of values don't match expected type GEOMETRY"
],
"isValid": false,
"nullCount": 0,
"actualTypes": {
"string": 8295
},
"nullPercent": 0,
"expectedType": "GEOMETRY",
"matchedField": "_geom",
"sampleIssues": [
"POINT(145.6907239868707 -41.43445394475959)",
"POINT(146.04824055532367 -41.2003474142464)",
"POINT(147.3569108846136 -42.52755834555949)",
"POINT(147.28682767209452 -42.90959036316386)",
"POINT(147.1883746339031 -42.54189334850734)"
],
"totalRecords": 8295,
"attributeName": "geometry",
"distinctCount": 8260,
"sourcePatterns": [
"_geom",
"geom"
],
"typeMismatchPercent": 100
}
],
"recordsValidated": 8295,
"attributesWithIssues": 8
}Harmonize au_tas_minocc → Derive ontology
{
"domain": "mining",
"qualityNotes": [
"Many fields contain null values, particularly geological measurements (dip, strike, rl)",
"Deposit names are often 'Unnamed', indicating incomplete cataloging",
"Location accuracy varies (50-100m) but is generally documented",
"Some fields like 'data_metallogenica', 'ore_description', 'ore_genesis' are consistently null",
"The 'resources' field appears to be consistently 'N', suggesting limited resource definition",
"Commodity information is well-populated and appears to be the primary focus",
"Geological age information is inconsistent - some records have host_age, others don't",
"The source provides good coverage of exploration methods and geological context where available"
],
"commonPatterns": {
"dateFields": [
"status_date",
"_mirrored_at"
],
"statusFields": [
"operational_status",
"deposit_type",
"type"
],
"geometryFields": [
"_geom",
"geom"
],
"commodityFields": [
"commodities",
"commodity_category"
],
"identifierFields": [
"_id",
"deposit_id",
"gid",
"parent_id"
],
"measurementFields": [
"deposit_size",
"location_accuracy",
"strike",
"dip",
"rl",
"rl_acc"
]
},
"alternativeTypes": [],
"primaryFeatureType": {
"name": "Mineral Occurrence",
"slug": "mineral_occurrence",
"reasoning": "This data clearly represents mineral occurrences based on the deposit_type field values ('Mine or Prospect', 'Mineral Occurrence', 'Area of alluvial workings') and the presence of commodity information, geological data, and operational status. The point geometry and detailed mineral/geological attributes confirm this classification.",
"attributes": [
{
"name": "source_id",
"dataType": "TEXT",
"examples": [
"tas_minocc_ytpfkd",
"7355",
"3118"
],
"required": true,
"isGeometry": false,
"description": "Unique identifier from the source system",
"isIdentifier": true,
"sourceFieldPatterns": [
"_id",
"deposit_id",
"gid"
]
},
{
"name": "name",
"dataType": "TEXT",
"examples": [
"Unnamed",
"Leech Hill"
],
"required": false,
"isGeometry": false,
"description": "Name of the mineral occurrence or deposit",
"isIdentifier": false,
"sourceFieldPatterns": [
"deposit_name"
]
},
{
"name": "alternate_names",
"dataType": "TEXT",
"examples": [
"Basin Lake North"
],
"required": false,
"isGeometry": false,
"description": "Alternative names or aliases for the occurrence",
"isIdentifier": false,
"sourceFieldPatterns": [
"alias"
]
},
{
"name": "commodities",
"dataType": "TEXT",
"examples": [
"Gravel - aggregate",
"Zinc",
"Silver, Lead",
"Tin"
],
"required": true,
"isGeometry": false,
"description": "Primary commodities or minerals present",
"isIdentifier": false,
"sourceFieldPatterns": [
"commodities"
]
},
{
"name": "commodity_category",
"dataType": "TEXT",
"examples": [
"Construction Materials",
"Metals"
],
"required": false,
"enumValues": [
"Construction Materials",
"Metals"
],
"isGeometry": false,
"description": "Broad category classification of commodities",
"isIdentifier": false,
"sourceFieldPatterns": [
"commodity_category"
]
},
{
"name": "deposit_type",
"dataType": "TEXT",
"examples": [
"Mine or Prospect",
"Area of alluvial workings",
"Mineral Occurrence"
],
"required": true,
"isGeometry": false,
"description": "Type or classification of the mineral deposit",
"isIdentifier": false,
"sourceFieldPatterns": [
"deposit_type",
"type"
]
},
{
"name": "status",
"dataType": "TEXT",
"examples": [
"Unknown",
"Mineralised area",
"Abandoned"
],
"required": false,
"enumValues": [
"Unknown",
"Mineralised area",
"Abandoned",
"Mineral occurrence"
],
"isGeometry": false,
"description": "Current operational or development status",
"isIdentifier": false,
"sourceFieldPatterns": [
"operational_status"
]
},
{
"name": "deposit_size",
"dataType": "TEXT",
"examples": [
"Medium: 10 000 t - 1 000 000 t",
"Not determined"
],
"required": false,
"isGeometry": false,
"description": "Size classification or tonnage estimate of the deposit",
"isIdentifier": false,
"sourceFieldPatterns": [
"deposit_size"
]
},
{
"name": "description",
"dataType": "TEXT",
"examples": [
"A weak alteration system with pyrite and rare galena mineralisation",
"Four adits reported"
],
"required": false,
"isGeometry": false,
"description": "Detailed description of the occurrence",
"isIdentifier": false,
"sourceFieldPatterns": [
"description"
]
},
{
"name": "locality",
"dataType": "TEXT",
"examples": [
"Mole Creek",
"The Banca",
"a tributary of Allens Creek"
],
"required": false,
"isGeometry": false,
"description": "Geographic locality or place name",
"isIdentifier": false,
"sourceFieldPatterns": [
"locality"
]
},
{
"name": "host_rock",
"dataType": "TEXT",
"examples": [
"sandstone",
"sediments (undifferentiated)",
"lava (undifferentiated)"
],
"required": false,
"isGeometry": false,
"description": "Host rock lithology",
"isIdentifier": false,
"sourceFieldPatterns": [
"lithology"
]
},
{
"name": "geological_age",
"dataType": "TEXT",
"examples": [
"Cambrian Series 3",
"Neoproterozoic",
"Cenozoic"
],
"required": false,
"isGeometry": false,
"description": "Geological age of host rocks",
"isIdentifier": false,
"sourceFieldPatterns": [
"host_age"
]
},
{
"name": "lithostratigraphy",
"dataType": "TEXT",
"examples": [
"Yolande River Sequence",
"Oonah Formation",
"Undifferentiated Cenozoic sequences"
],
"required": false,
"isGeometry": false,
"description": "Stratigraphic unit or formation",
"isIdentifier": false,
"sourceFieldPatterns": [
"lithostratigraphy"
]
},
{
"name": "mineralization_age",
"dataType": "TEXT",
"examples": [
"Cambrian",
"Devonian",
"Cenozoic"
],
"required": false,
"isGeometry": false,
"description": "Age of mineralization event",
"isIdentifier": false,
"sourceFieldPatterns": [
"mineralage"
]
},
{
"name": "ore_form",
"dataType": "TEXT",
"examples": [
"Disseminated, Vein (single, sheet, saddle)",
"Placer",
"Replacement"
],
"required": false,
"isGeometry": false,
"description": "Form or style of mineralization",
"isIdentifier": false,
"sourceFieldPatterns": [
"form"
]
},
{
"name": "gangue_minerals",
"dataType": "TEXT",
"examples": [
"Carbonate, Pyrite, Quartz, Sericite",
"Arsenopyrite, Pyrite",
"Chlorite, Magnetite"
],
"required": false,
"isGeometry": false,
"description": "Associated gangue minerals",
"isIdentifier": false,
"sourceFieldPatterns": [
"gangue"
]
},
{
"name": "genetic_type",
"dataType": "TEXT",
"examples": [
"Colluvial, Sedimentary"
],
"required": false,
"isGeometry": false,
"description": "Genetic classification of the deposit",
"isIdentifier": false,
"sourceFieldPatterns": [
"genetic"
]
},
{
"name": "exploration_methods",
"dataType": "TEXT",
"examples": [
"Drilling, Geochemical surveys, Geological mapping, Geophysical surveys, Prospecting"
],
"required": false,
"isGeometry": false,
"description": "Exploration methods used at the site",
"isIdentifier": false,
"sourceFieldPatterns": [
"exploration_type"
]
},
{
"name": "extractability",
"dataType": "TEXT",
"examples": [
"Bulldozer"
],
"required": false,
"isGeometry": false,
"description": "Method or ease of extraction",
"isIdentifier": false,
"sourceFieldPatterns": [
"extractability"
]
},
{
"name": "uses",
"dataType": "TEXT",
"examples": [
"Road Base Course, Road Unsealed"
],
"required": false,
"isGeometry": false,
"description": "Intended or actual uses of the commodity",
"isIdentifier": false,
"sourceFieldPatterns": [
"uses"
]
},
{
"name": "tests_conducted",
"dataType": "TEXT",
"examples": [
"Atterberg Limits; Grain size analysis"
],
"required": false,
"isGeometry": false,
"description": "Testing or analysis conducted on samples",
"isIdentifier": false,
"sourceFieldPatterns": [
"tests"
]
},
{
"name": "strike_degrees",
"dataType": "FLOAT",
"examples": [
"315"
],
"required": false,
"isGeometry": false,
"description": "Strike direction in degrees",
"isIdentifier": false,
"sourceFieldPatterns": [
"strike"
]
},
{
"name": "dip_degrees",
"dataType": "FLOAT",
"examples": [],
"required": false,
"isGeometry": false,
"description": "Dip angle in degrees",
"isIdentifier": false,
"sourceFieldPatterns": [
"dip"
]
},
{
"name": "location_accuracy",
"dataType": "INTEGER",
"examples": [
"100",
"50"
],
"required": false,
"isGeometry": false,
"description": "Location accuracy in meters",
"isIdentifier": false,
"sourceFieldPatterns": [
"location_accuracy"
]
},
{
"name": "location_method",
"dataType": "TEXT",
"examples": [
"Mirloch (Deposits database)"
],
"required": false,
"isGeometry": false,
"description": "Method used to determine location",
"isIdentifier": false,
"sourceFieldPatterns": [
"location_method"
]
},
{
"name": "report_references",
"dataType": "TEXT",
"examples": [
"UR1985_54, 74_1054, 86_2566, 98_4238",
"71_0735, 85_2455"
],
"required": false,
"isGeometry": false,
"description": "References to reports or publications",
"isIdentifier": false,
"sourceFieldPatterns": [
"report_references"
]
},
{
"name": "source_url",
"dataType": "TEXT",
"examples": [
"https://www.mrt.tas.gov.au/webdoc2/app/default/deposit_detail?id=7355"
],
"required": false,
"isGeometry": false,
"description": "URL to detailed information in source system",
"isIdentifier": false,
"sourceFieldPatterns": [
"details"
]
},
{
"name": "has_resources",
"dataType": "BOOLEAN",
"examples": [
"N"
],
"required": false,
"isGeometry": false,
"description": "Whether the occurrence has defined resources",
"isIdentifier": false,
"sourceFieldPatterns": [
"resources"
]
},
{
"name": "jurisdiction",
"dataType": "TEXT",
"examples": [
"Tasmania"
],
"required": true,
"isGeometry": false,
"description": "Administrative jurisdiction",
"isIdentifier": false,
"sourceFieldPatterns": []
},
{
"name": "country",
"dataType": "TEXT",
"examples": [
"Australia"
],
"required": true,
"isGeometry": false,
"description": "Country where the occurrence is located",
"isIdentifier": false,
"sourceFieldPatterns": []
},
{
"name": "geometry",
"dataType": "GEOMETRY",
"examples": [
"POINT(146.34666020423242 -41.55084074116509)"
],
"required": true,
"isGeometry": true,
"description": "Point location of the mineral occurrence",
"isIdentifier": false,
"sourceFieldPatterns": [
"_geom",
"geom"
]
}
],
"confidence": 0.95,
"description": "A location where minerals have been found, including prospects, deposits, mines, and mineral occurrences with documented commodities and geological characteristics",
"geometryType": "POINT"
}
}Harmonize au_tas_minocc → Analyze schema
{
"fields": [
{
"name": "_id",
"type": "string",
"pattern": "tas_minocc_[a-z0-9]+",
"nullable": false,
"description": "Unique identifier for each mineral occurrence record",
"sampleValues": [
"tas_minocc_ovqpy3",
"tas_minocc_xmnq4p",
"tas_minocc_x5tmxg"
]
},
{
"name": "_geom",
"type": "geometry",
"pattern": "POINT\\([0-9.-]+ [0-9.-]+\\)",
"nullable": false,
"description": "Point geometry representing the location of the mineral occurrence",
"sampleValues": [
"POINT(146.96432860767288 -43.43402588403013)",
"POINT(147.04697438799053 -41.62474597549133)"
]
},
{
"name": "alias",
"type": "string",
"nullable": true,
"description": "Alternative name or alias for the mineral occurrence",
"sampleValues": [
"Swanstons",
null
]
},
{
"name": "commodities",
"type": "string",
"nullable": false,
"description": "Primary commodity or mineral found at this occurrence",
"sampleValues": [
"Coal -general",
"Gravel - aggregate",
"Gold"
]
},
{
"name": "commodity_category",
"type": "string",
"nullable": false,
"enumValues": [
"Fuel Minerals",
"Construction Materials",
"Metals"
],
"description": "Broad category classification of the commodity",
"sampleValues": [
"Fuel Minerals",
"Construction Materials",
"Metals"
]
},
{
"name": "data_metallogenica",
"type": "string",
"nullable": true,
"description": "Metallogenic data or classification",
"sampleValues": [
null
]
},
{
"name": "deposit_id",
"type": "string",
"nullable": false,
"description": "Unique identifier for the deposit",
"sampleValues": [
"4029",
"7509",
"484",
"633",
"1248"
]
},
{
"name": "deposit_name",
"type": "string",
"nullable": false,
"description": "Name of the mineral deposit",
"sampleValues": [
"Southport Coalfield",
"Unnamed",
"Buttons Creek",
"McIvor"
]
},
{
"name": "deposit_size",
"type": "string",
"nullable": false,
"enumValues": [
"Not determined",
"Very small: less than 100 tonnes or m^3"
],
"description": "Size classification of the deposit",
"sampleValues": [
"Not determined",
"Very small: less than 100 tonnes or m^3"
]
},
{
"name": "deposit_type",
"type": "string",
"nullable": false,
"enumValues": [
"Mineral Field",
"Mine or Prospect",
"Area of alluvial workings"
],
"description": "Type or classification of the mineral deposit",
"sampleValues": [
"Mineral Field",
"Mine or Prospect",
"Area of alluvial workings"
]
},
{
"name": "description",
"type": "string",
"nullable": true,
"description": "Detailed description of the mineral occurrence",
"sampleValues": [
null,
"gold bearing quartz reef, gold rich near surface, workings include a shaft and crosscut",
"a shaft and a hole"
]
},
{
"name": "details",
"type": "string",
"pattern": "https://www\\.mrt\\.tas\\.gov\\.au/webdoc2/app/default/deposit_detail\\?id=[0-9]+",
"nullable": false,
"description": "URL link to detailed information about the deposit",
"sampleValues": [
"https://www.mrt.tas.gov.au/webdoc2/app/default/deposit_detail?id=4029"
]
},
{
"name": "dip",
"type": "string",
"nullable": true,
"description": "Dip angle of geological structures",
"sampleValues": [
null
]
},
{
"name": "exploration_type",
"type": "string",
"nullable": true,
"description": "Type of exploration activities conducted",
"sampleValues": [
"Prospecting",
null,
"Geochemical surveys, Geological mapping, Prospecting"
]
},
{
"name": "extractability",
"type": "string",
"nullable": true,
"description": "Method or ease of extraction",
"sampleValues": [
null,
"Bulldozer"
]
},
{
"name": "form",
"type": "string",
"nullable": true,
"enumValues": [
"Stratiform",
"Placer",
"Vein (single, sheet, saddle)"
],
"description": "Geological form or structure of the mineralization",
"sampleValues": [
"Stratiform",
null,
"Placer",
"Vein (single, sheet, saddle)"
]
},
{
"name": "gangue",
"type": "string",
"nullable": true,
"description": "Gangue minerals associated with the ore",
"sampleValues": [
null,
"Quartz"
]
},
{
"name": "genetic",
"type": "string",
"nullable": true,
"description": "Genetic classification or origin of the deposit",
"sampleValues": [
null,
"Residual, Sedimentary"
]
},
{
"name": "gid",
"type": "string",
"nullable": false,
"description": "Geographic identifier or grid reference",
"sampleValues": [
"1950",
"3176",
"241",
"4966",
"5915"
]
},
{
"name": "host_age",
"type": "string",
"nullable": true,
"description": "Geological age of the host rock",
"sampleValues": [
null,
"Ordovician",
"Lower Devonian, Ordovician, Silurian"
]
},
{
"name": "lithology",
"type": "string",
"nullable": true,
"description": "Rock type or lithological description",
"sampleValues": [
null,
"ironstone",
"sandstone, siltstone",
"mudstone, sandstone, siltstone"
]
},
{
"name": "lithostratigraphy",
"type": "string",
"nullable": true,
"description": "Lithostratigraphic unit or formation name",
"sampleValues": [
null,
"Mathinna Supergroup, Tippogoree Group",
"Mathinna Supergroup"
]
},
{
"name": "locality",
"type": "string",
"nullable": true,
"description": "Local geographic area or place name",
"sampleValues": [
null,
"Toiberry",
"Lefroy",
"Warrentinna"
]
},
{
"name": "location_accuracy",
"type": "string",
"nullable": false,
"enumValues": [
"100",
"500"
],
"description": "Accuracy of the location coordinates in meters",
"sampleValues": [
"100",
"500"
]
},
{
"name": "location_method",
"type": "string",
"nullable": true,
"description": "Method used to determine the location",
"sampleValues": [
null
]
},
{
"name": "mineralage",
"type": "string",
"nullable": true,
"enumValues": [
"Permian",
"Quaternary",
"Devonian"
],
"description": "Geological age of the mineralization",
"sampleValues": [
"Permian",
null,
"Quaternary",
"Devonian"
]
},
{
"name": "operational_status",
"type": "string",
"nullable": false,
"enumValues": [
"Mineralised area",
"Abandoned",
"Prospect"
],
"description": "Current operational status of the mineral occurrence",
"sampleValues": [
"Mineralised area",
"Abandoned",
"Prospect"
]
},
{
"name": "ore_description",
"type": "string",
"nullable": true,
"description": "Description of the ore characteristics",
"sampleValues": [
null
]
},
{
"name": "ore_genesis",
"type": "string",
"nullable": true,
"description": "Genesis or formation process of the ore",
"sampleValues": [
null
]
},
{
"name": "outcrops",
"type": "string",
"nullable": true,
"description": "Information about surface outcrops",
"sampleValues": [
null
]
},
{
"name": "parent_id",
"type": "string",
"nullable": true,
"description": "Identifier of parent deposit or related occurrence",
"sampleValues": [
null,
"9297",
"11006"
]
},
{
"name": "report_references",
"type": "string",
"nullable": true,
"description": "References to geological reports",
"sampleValues": [
null,
"ER8115N0, OS_031",
"TR9_59_76, GSB42, 03_4889"
]
},
{
"name": "resources",
"type": "string",
"nullable": false,
"enumValues": [
"N"
],
"description": "Resource classification indicator",
"sampleValues": [
"N"
]
},
{
"name": "rl",
"type": "string",
"nullable": true,
"description": "Reduced level or elevation",
"sampleValues": [
null
]
},
{
"name": "rl_acc",
"type": "string",
"nullable": true,
"description": "Accuracy of the reduced level measurement",
"sampleValues": [
null
]
},
{
"name": "status_date",
"type": "string",
"nullable": true,
"description": "Date of status determination (timestamp format)",
"sampleValues": [
null,
"222876000000"
]
},
{
"name": "strike",
"type": "string",
"nullable": true,
"description": "Strike direction of geological structures",
"sampleValues": [
null
]
},
{
"name": "tests",
"type": "string",
"nullable": true,
"description": "Types of tests or analyses conducted",
"sampleValues": [
null,
"Atterberg Limits; Grain size analysis"
]
},
{
"name": "type",
"type": "string",
"nullable": false,
"enumValues": [
"Hardrock - Fuel",
"Construction",
"Alluvial",
"Hardrock - Metals"
],
"description": "Primary classification type of the mineral occurrence",
"sampleValues": [
"Hardrock - Fuel",
"Construction",
"Alluvial",
"Hardrock - Metals"
]
},
{
"name": "uses",
"type": "string",
"nullable": true,
"description": "Intended uses or applications of the mineral",
"sampleValues": [
null,
"Road Base Course, Road Wearing (Sealed)"
]
},
{
"name": "weathered",
"type": "string",
"nullable": true,
"description": "Weathering characteristics",
"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:15:22.749368+00"
]
},
{
"name": "geom",
"type": "geometry",
"nullable": false,
"description": "Binary geometry representation (WKB format)",
"sampleValues": [
"0101000020E6100000AC11ABC7DB5E624071C300298EB745C0"
]
}
],
"semantics": {
"idFields": [
"_id",
"deposit_id",
"gid",
"parent_id"
],
"nameFields": [
"alias",
"deposit_name",
"locality"
],
"statusFields": [
"operational_status",
"resources"
],
"fieldMeanings": {
"_id": "Primary key identifier",
"gid": "Geographic identifier",
"form": "Geological form",
"geom": "Binary geometry data",
"type": "Primary type classification",
"_geom": "Point geometry coordinates",
"alias": "Alternative name",
"gangue": "Associated minerals",
"details": "Reference URL",
"genetic": "Formation process",
"host_age": "Age of host rock",
"locality": "Geographic locality",
"lithology": "Rock type",
"parent_id": "Related deposit ID",
"resources": "Resource indicator",
"deposit_id": "Deposit identifier",
"mineralage": "Age of mineralization",
"commodities": "Primary mineral commodity",
"description": "Detailed description",
"_mirrored_at": "Data synchronization timestamp",
"deposit_name": "Deposit name",
"deposit_size": "Size classification",
"deposit_type": "Type classification",
"location_accuracy": "Coordinate accuracy",
"commodity_category": "Commodity classification",
"operational_status": "Current status"
},
"geometryFields": [
"_geom",
"geom"
],
"commodityFields": [
"commodities",
"commodity_category"
]
},
"confidence": 0.95,
"entityType": "mineral_occurrence",
"recordCount": 100
}Harmonize au_tas_minocc → Derive ontology
{
"domain": "mining",
"qualityNotes": [
"Many fields contain null values, particularly geological details like dip, ore_description, ore_genesis",
"Location accuracy varies from 25m to 100m, indicating mixed precision in spatial data",
"Deposit names are often 'Unnamed', suggesting incomplete cataloging",
"Status dates are stored as Unix timestamps in milliseconds and need conversion",
"Some fields like 'resources' and 'outcrops' use Y/N values that should be converted to boolean",
"The 'genetic' field has inconsistent formatting (some entries have multiple values separated by commas)",
"Construction material occurrences are mixed with metallic mineral occurrences, which may need separate handling",
"Strike values are numeric but stored as text",
"Location accuracy values are numeric but stored as text"
],
"commonPatterns": {
"dateFields": [
"status_date",
"_mirrored_at"
],
"statusFields": [
"operational_status",
"deposit_type"
],
"geometryFields": [
"_geom",
"geom"
],
"commodityFields": [
"commodities",
"commodity_category",
"type"
],
"identifierFields": [
"_id",
"deposit_id",
"gid",
"parent_id"
],
"measurementFields": [
"location_accuracy",
"strike",
"deposit_size"
]
},
"alternativeTypes": [],
"primaryFeatureType": {
"name": "Mineral Occurrence",
"slug": "mineral_occurrence",
"reasoning": "This data clearly represents mineral occurrences - locations where minerals or construction materials have been identified. The records include both metallic minerals (gold, lead, silver) and construction materials (gravel, aggregate). The presence of fields like 'deposit_name', 'commodities', 'operational_status', and 'deposit_type' strongly indicates this is mineral occurrence data.",
"attributes": [
{
"name": "source_id",
"dataType": "TEXT",
"examples": [
"tas_minocc_u010bo",
"8837",
"4211"
],
"required": true,
"isGeometry": false,
"description": "Unique identifier from the source system",
"isIdentifier": true,
"sourceFieldPatterns": [
"_id",
"deposit_id",
"gid"
]
},
{
"name": "name",
"dataType": "TEXT",
"examples": [
"Unnamed",
"Johns Link",
"Grenadier",
"New Mount Zeehan"
],
"required": false,
"isGeometry": false,
"description": "Name of the mineral occurrence or deposit",
"isIdentifier": false,
"sourceFieldPatterns": [
"deposit_name"
]
},
{
"name": "alternate_names",
"dataType": "TEXT",
"examples": [
"Gaiety Shaft, Main Shaft, Mount Zeehan, No. 1 Adit, No. 2 Adit, No. 2 Shaft, No. 3 Shaft, Zeehan"
],
"required": false,
"isGeometry": false,
"description": "Alternative names or aliases for the occurrence",
"isIdentifier": false,
"sourceFieldPatterns": [
"alias"
]
},
{
"name": "commodities",
"dataType": "TEXT",
"examples": [
"Gravel - aggregate",
"Gold",
"Lead, Silver"
],
"required": true,
"isGeometry": false,
"description": "Primary commodities or minerals present",
"isIdentifier": false,
"sourceFieldPatterns": [
"commodities"
]
},
{
"name": "commodity_category",
"dataType": "TEXT",
"examples": [
"Construction Materials",
"Metals"
],
"required": false,
"enumValues": [
"Construction Materials",
"Metals",
"Hardrock - Metals",
"Construction"
],
"isGeometry": false,
"description": "Broad category of commodity type",
"isIdentifier": false,
"sourceFieldPatterns": [
"commodity_category",
"type"
]
},
{
"name": "status",
"dataType": "TEXT",
"examples": [
"Abandoned",
"Fully Operating",
"Prospect"
],
"required": false,
"enumValues": [
"Abandoned",
"Fully Operating",
"Unknown",
"Prospect"
],
"isGeometry": false,
"description": "Current operational status of the occurrence",
"isIdentifier": false,
"sourceFieldPatterns": [
"operational_status"
]
},
{
"name": "deposit_type",
"dataType": "TEXT",
"examples": [
"Mine or Prospect"
],
"required": false,
"isGeometry": false,
"description": "Type or classification of the deposit",
"isIdentifier": false,
"sourceFieldPatterns": [
"deposit_type"
]
},
{
"name": "deposit_size",
"dataType": "TEXT",
"examples": [
"Not determined",
"Medium: 10 000 t - 1 000 000 t"
],
"required": false,
"isGeometry": false,
"description": "Size classification of the deposit",
"isIdentifier": false,
"sourceFieldPatterns": [
"deposit_size"
]
},
{
"name": "description",
"dataType": "TEXT",
"examples": [
"anomalous gold in soils, rock chips and trenching"
],
"required": false,
"isGeometry": false,
"description": "Detailed description of the occurrence",
"isIdentifier": false,
"sourceFieldPatterns": [
"description"
]
},
{
"name": "locality",
"dataType": "TEXT",
"examples": [
"Dulcot",
"Mole Creek",
"Zeehan"
],
"required": false,
"isGeometry": false,
"description": "Local geographic reference or place name",
"isIdentifier": false,
"sourceFieldPatterns": [
"locality"
]
},
{
"name": "host_rock",
"dataType": "TEXT",
"examples": [
"siltstone",
"sandstone",
"granodiorite, monzogranite (adamellite)"
],
"required": false,
"isGeometry": false,
"description": "Host rock lithology",
"isIdentifier": false,
"sourceFieldPatterns": [
"lithology"
]
},
{
"name": "geological_age",
"dataType": "TEXT",
"examples": [
"Devonian",
"Cambrian Series 3"
],
"required": false,
"isGeometry": false,
"description": "Geological age of host rocks or mineralization",
"isIdentifier": false,
"sourceFieldPatterns": [
"host_age",
"mineralage"
]
},
{
"name": "stratigraphic_unit",
"dataType": "TEXT",
"examples": [
"Haleys New Country Granite",
"Tyndall Group"
],
"required": false,
"isGeometry": false,
"description": "Stratigraphic unit or formation name",
"isIdentifier": false,
"sourceFieldPatterns": [
"lithostratigraphy"
]
},
{
"name": "ore_form",
"dataType": "TEXT",
"examples": [
"Vein (single, sheet, saddle)"
],
"required": false,
"isGeometry": false,
"description": "Form or style of mineralization",
"isIdentifier": false,
"sourceFieldPatterns": [
"form"
]
},
{
"name": "gangue_minerals",
"dataType": "TEXT",
"examples": [
"Quartz",
"Arsenopyrite, Barite, Pyrite, Pyrrhotite, Quartz, Siderite"
],
"required": false,
"isGeometry": false,
"description": "Associated gangue minerals",
"isIdentifier": false,
"sourceFieldPatterns": [
"gangue"
]
},
{
"name": "genetic_type",
"dataType": "TEXT",
"examples": [
"Sedimentary",
"Colluvial, Sedimentary"
],
"required": false,
"isGeometry": false,
"description": "Genetic classification of the deposit",
"isIdentifier": false,
"sourceFieldPatterns": [
"genetic"
]
},
{
"name": "exploration_methods",
"dataType": "TEXT",
"examples": [
"Geochemical surveys, Prospecting"
],
"required": false,
"isGeometry": false,
"description": "Exploration methods used",
"isIdentifier": false,
"sourceFieldPatterns": [
"exploration_type"
]
},
{
"name": "extractability",
"dataType": "TEXT",
"examples": [
"Bulldozer"
],
"required": false,
"isGeometry": false,
"description": "Method or ease of extraction",
"isIdentifier": false,
"sourceFieldPatterns": [
"extractability"
]
},
{
"name": "uses",
"dataType": "TEXT",
"examples": [
"Road Base Course, Road Unsealed",
"Crushed Aggregate"
],
"required": false,
"isGeometry": false,
"description": "Intended uses for the material",
"isIdentifier": false,
"sourceFieldPatterns": [
"uses"
]
},
{
"name": "location_accuracy",
"dataType": "INTEGER",
"examples": [
"50",
"100",
"25"
],
"required": false,
"isGeometry": false,
"description": "Location accuracy in meters",
"isIdentifier": false,
"sourceFieldPatterns": [
"location_accuracy"
]
},
{
"name": "location_method",
"dataType": "TEXT",
"examples": [
"Bibliographic reference"
],
"required": false,
"isGeometry": false,
"description": "Method used to determine location",
"isIdentifier": false,
"sourceFieldPatterns": [
"location_method"
]
},
{
"name": "has_resources",
"dataType": "BOOLEAN",
"examples": [
"N",
"Y"
],
"required": false,
"isGeometry": false,
"description": "Whether resource estimates are available",
"isIdentifier": false,
"sourceFieldPatterns": [
"resources"
]
},
{
"name": "has_outcrops",
"dataType": "BOOLEAN",
"examples": [
"Y"
],
"required": false,
"isGeometry": false,
"description": "Whether surface outcrops are present",
"isIdentifier": false,
"sourceFieldPatterns": [
"outcrops"
]
},
{
"name": "strike",
"dataType": "INTEGER",
"examples": [
"39"
],
"required": false,
"isGeometry": false,
"description": "Strike direction in degrees",
"isIdentifier": false,
"sourceFieldPatterns": [
"strike"
]
},
{
"name": "tests_conducted",
"dataType": "TEXT",
"examples": [
"Atterberg Limits; Grain size analysis"
],
"required": false,
"isGeometry": false,
"description": "Laboratory or field tests conducted",
"isIdentifier": false,
"sourceFieldPatterns": [
"tests"
]
},
{
"name": "parent_occurrence_id",
"dataType": "TEXT",
"examples": [
"9508"
],
"required": false,
"isGeometry": false,
"description": "ID of parent occurrence if this is a sub-occurrence",
"isIdentifier": false,
"sourceFieldPatterns": [
"parent_id"
]
},
{
"name": "report_references",
"dataType": "TEXT",
"examples": [
"ER7914S0, GSREC11, OS_121, OS_224, 71_0736, 19_8075"
],
"required": false,
"isGeometry": false,
"description": "References to related reports",
"isIdentifier": false,
"sourceFieldPatterns": [
"report_references"
]
},
{
"name": "source_url",
"dataType": "TEXT",
"examples": [
"https://www.mrt.tas.gov.au/webdoc2/app/default/deposit_detail?id=8837"
],
"required": false,
"isGeometry": false,
"description": "URL to detailed information in source system",
"isIdentifier": false,
"sourceFieldPatterns": [
"details"
]
},
{
"name": "geometry",
"dataType": "GEOMETRY",
"required": true,
"isGeometry": true,
"description": "Point location of the mineral occurrence",
"isIdentifier": false,
"sourceFieldPatterns": [
"_geom",
"geom"
]
},
{
"name": "jurisdiction",
"dataType": "TEXT",
"examples": [
"Tasmania"
],
"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, mines, and construction material sites",
"geometryType": "POINT"
}
}Harmonize au_tas_minocc → Analyze schema
{
"fields": [
{
"name": "_id",
"type": "string",
"pattern": "tas_minocc_[a-z0-9]+",
"nullable": false,
"description": "Unique identifier for each mineral occurrence record",
"sampleValues": [
"tas_minocc_mu90uf",
"tas_minocc_7qgh07",
"tas_minocc_yw62ze"
]
},
{
"name": "_geom",
"type": "geometry",
"pattern": "POINT\\([0-9.-]+ [0-9.-]+\\)",
"nullable": false,
"description": "Point geometry representing the location of the mineral occurrence",
"sampleValues": [
"POINT(146.27937035618342 -41.238777659424485)",
"POINT(146.7604581363303 -41.19304176316138)"
]
},
{
"name": "alias",
"type": "string",
"nullable": true,
"description": "Alternative names or aliases for the deposit",
"sampleValues": [
null,
"Mount Vulcan, Scotts Hill"
]
},
{
"name": "commodities",
"type": "string",
"nullable": false,
"description": "Primary commodities or minerals found at the occurrence",
"sampleValues": [
"Gravel - aggregate",
"Nickel",
"Tin",
"Pyrite",
"Unknown, Tungsten"
]
},
{
"name": "commodity_category",
"type": "string",
"nullable": false,
"enumValues": [
"Construction Materials",
"Metals"
],
"description": "Broad category classification of the commodity",
"sampleValues": [
"Construction Materials",
"Metals"
]
},
{
"name": "data_metallogenica",
"type": "string",
"nullable": true,
"description": "Metallogenic data reference or classification",
"sampleValues": [
null
]
},
{
"name": "deposit_id",
"type": "string",
"nullable": false,
"description": "Unique identifier for the deposit in the source system",
"sampleValues": [
"6410",
"9731",
"1119",
"3223",
"4015"
]
},
{
"name": "deposit_name",
"type": "string",
"nullable": false,
"description": "Official name of the mineral deposit",
"sampleValues": [
"Unnamed",
"Scotts Vulcan",
"Wellington Creek",
"Selina Eastern Pyrite Zone",
"Cox Creek"
]
},
{
"name": "deposit_size",
"type": "string",
"nullable": false,
"enumValues": [
"Small: 100 t - 10 000 t",
"Large: 1 000 000 t - 10 000 000 t",
"Not determined"
],
"description": "Size classification of the deposit based on tonnage",
"sampleValues": [
"Small: 100 t - 10 000 t",
"Large: 1 000 000 t - 10 000 000 t",
"Not determined"
]
},
{
"name": "deposit_type",
"type": "string",
"nullable": false,
"enumValues": [
"Mine or Prospect",
"Area of alluvial workings"
],
"description": "Type or classification of the mineral deposit",
"sampleValues": [
"Mine or Prospect",
"Area of alluvial workings"
]
},
{
"name": "description",
"type": "string",
"nullable": true,
"description": "Detailed description of the mineral occurrence",
"sampleValues": [
"Rock-types comment: Quartz Gravel",
"lateritic nickel",
"alluvial tin workings"
]
},
{
"name": "details",
"type": "string",
"pattern": "https://www\\.mrt\\.tas\\.gov\\.au/webdoc2/app/default/deposit_detail\\?id=[0-9]+",
"nullable": false,
"description": "URL link to detailed information about the deposit",
"sampleValues": [
"https://www.mrt.tas.gov.au/webdoc2/app/default/deposit_detail?id=6410"
]
},
{
"name": "dip",
"type": "string",
"nullable": true,
"description": "Geological dip measurement of the deposit",
"sampleValues": [
null
]
},
{
"name": "exploration_type",
"type": "string",
"nullable": true,
"description": "Types of exploration activities conducted",
"sampleValues": [
null,
"Drilling, Geochemical surveys, Geological mapping",
"Prospecting"
]
},
{
"name": "extractability",
"type": "string",
"nullable": true,
"description": "Method or ease of extraction",
"sampleValues": [
"Bulldozer",
null
]
},
{
"name": "form",
"type": "string",
"nullable": true,
"enumValues": [
"Placer",
"Disseminated"
],
"description": "Physical form or occurrence type of the mineralization",
"sampleValues": [
null,
"Placer",
"Disseminated"
]
},
{
"name": "gangue",
"type": "string",
"nullable": true,
"description": "Gangue minerals associated with the ore",
"sampleValues": [
null
]
},
{
"name": "genetic",
"type": "string",
"nullable": true,
"description": "Genetic classification or origin of the deposit",
"sampleValues": [
"Sedimentary",
null
]
},
{
"name": "gid",
"type": "string",
"nullable": false,
"description": "Geographic identifier or grid reference",
"sampleValues": [
"2378",
"4826",
"539",
"5173",
"8014"
]
},
{
"name": "host_age",
"type": "string",
"nullable": true,
"description": "Geological age of the host rock",
"sampleValues": [
null,
"Quaternary",
"Cambrian Series 3"
]
},
{
"name": "lithology",
"type": "string",
"nullable": true,
"description": "Rock type or lithological description",
"sampleValues": [
"gravel",
null,
"volcaniclastic-igneous-rock and tephra"
]
},
{
"name": "lithostratigraphy",
"type": "string",
"nullable": true,
"description": "Lithostratigraphic unit or formation name",
"sampleValues": [
null,
"Undifferentiated Cenozoic sequences",
"Eastern Quartz-Phyric Sequence, Mount Read Volcanics and correlates"
]
},
{
"name": "locality",
"type": "string",
"nullable": true,
"description": "Local geographic area or place name",
"sampleValues": [
"Melrose",
"Beaconsfield",
null,
"eastern side of Mt Selina"
]
},
{
"name": "location_accuracy",
"type": "string",
"nullable": false,
"description": "Accuracy of the location coordinates in meters",
"sampleValues": [
"50",
"25",
"100",
"-999"
]
},
{
"name": "location_method",
"type": "string",
"nullable": true,
"description": "Method used to determine the location",
"sampleValues": [
null,
"Mirloch (Deposits database)"
]
},
{
"name": "mineralage",
"type": "string",
"nullable": true,
"description": "Age of mineralization",
"sampleValues": [
null,
"Cenozoic",
"Quaternary",
"Cambrian"
]
},
{
"name": "operational_status",
"type": "string",
"nullable": false,
"enumValues": [
"Abandoned",
"Prospect",
"Mineralised area"
],
"description": "Current operational status of the deposit",
"sampleValues": [
"Abandoned",
"Prospect",
"Mineralised area"
]
},
{
"name": "ore_description",
"type": "string",
"nullable": true,
"description": "Description of the ore characteristics",
"sampleValues": [
null
]
},
{
"name": "ore_genesis",
"type": "string",
"nullable": true,
"description": "Genesis or formation process of the ore",
"sampleValues": [
null
]
},
{
"name": "outcrops",
"type": "string",
"nullable": true,
"enumValues": [
"Y"
],
"description": "Whether outcrops are present (Y/N)",
"sampleValues": [
null,
"Y"
]
},
{
"name": "parent_id",
"type": "string",
"nullable": true,
"description": "Identifier of parent deposit or related occurrence",
"sampleValues": [
null,
"9541",
"11714"
]
},
{
"name": "report_references",
"type": "string",
"nullable": true,
"description": "References to reports or publications",
"sampleValues": [
null,
"02_4658, 20_8240, 20_8373, 20_8283, 25_9093",
"GSB55"
]
},
{
"name": "resources",
"type": "string",
"nullable": false,
"enumValues": [
"N",
"Y"
],
"description": "Whether resource estimates are available (Y/N)",
"sampleValues": [
"N",
"Y"
]
},
{
"name": "rl",
"type": "string",
"nullable": true,
"description": "Reduced level or elevation",
"sampleValues": [
null,
"700"
]
},
{
"name": "rl_acc",
"type": "string",
"nullable": true,
"description": "Accuracy of the reduced level measurement",
"sampleValues": [
null,
"10"
]
},
{
"name": "status_date",
"type": "string",
"nullable": true,
"description": "Date of status determination (Unix timestamp)",
"sampleValues": [
null,
"1105884000000"
]
},
{
"name": "strike",
"type": "string",
"nullable": true,
"description": "Geological strike measurement",
"sampleValues": [
null,
"180"
]
},
{
"name": "tests",
"type": "string",
"nullable": true,
"description": "Types of tests or analyses conducted",
"sampleValues": [
"Atterberg Limits; Grain size analysis",
null
]
},
{
"name": "type",
"type": "string",
"nullable": false,
"enumValues": [
"Construction",
"Hardrock - Metals",
"Alluvial"
],
"description": "Primary classification type of the deposit",
"sampleValues": [
"Construction",
"Hardrock - Metals",
"Alluvial"
]
},
{
"name": "uses",
"type": "string",
"nullable": true,
"description": "Intended or actual uses of the mineral commodity",
"sampleValues": [
"Road Base Course, Road Sub-base, Road Wearing (Sealed)",
null
]
},
{
"name": "weathered",
"type": "string",
"nullable": true,
"enumValues": [
"Y"
],
"description": "Whether the deposit is weathered (Y/N)",
"sampleValues": [
null,
"Y"
]
},
{
"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:15:22.749368+00"
]
},
{
"name": "geom",
"type": "string",
"pattern": "[0-9A-F]+",
"nullable": false,
"description": "Well-Known Binary (WKB) representation of the geometry",
"sampleValues": [
"0101000020E6100000F3E8199AF04862402E1F2F44909E44C0"
]
}
],
"semantics": {
"idFields": [
"_id",
"deposit_id",
"gid",
"parent_id"
],
"nameFields": [
"deposit_name",
"alias",
"locality"
],
"primaryKey": "_id",
"statusFields": [
"operational_status",
"resources",
"outcrops",
"weathered"
],
"fieldMeanings": {
"rl": "Elevation",
"_id": "Primary key - unique record identifier",
"dip": "Geological dip",
"gid": "Geographic identifier",
"form": "Mineralization form",
"geom": "Binary geometry representation",
"type": "Primary deposit classification",
"_geom": "Point geometry - location coordinates",
"alias": "Alternative names",
"strike": "Geological strike",
"details": "Reference URL",
"genetic": "Genetic classification",
"host_age": "Geological age of host rock",
"locality": "Geographic locality",
"outcrops": "Outcrop presence",
"lithology": "Rock type",
"parent_id": "Parent deposit reference",
"resources": "Resource estimate availability",
"weathered": "Weathering status",
"deposit_id": "Deposit system identifier",
"mineralage": "Age of mineralization",
"commodities": "Primary mineral commodities",
"description": "Detailed description",
"_mirrored_at": "Data synchronization timestamp",
"deposit_name": "Official deposit name",
"deposit_size": "Size classification by tonnage",
"deposit_type": "Deposit type classification",
"location_accuracy": "Coordinate accuracy",
"commodity_category": "Commodity classification",
"operational_status": "Current operational state"
},
"relationships": [
{
"field": "parent_id",
"relatedTo": "deposit_id",
"relationshipType": "hierarchical"
},
{
"field": "_geom",
"relatedTo": "geom",
"relationshipType": "duplicate_representation"
},
{
"field": "commodities",
"relatedTo": "commodity_category",
"relationshipType": "classification"
},
{
"field": "deposit_type",
"relatedTo": "type",
"relationshipType": "classification"
}
],
"geometryFields": [
"_geom",
"geom"
],
"commodityFields": [
"commodities",
"commodity_category"
]
},
"confidence": 0.95,
"entityType": "mineral_occurrence",
"recordCount": 100
}