Q
Q

Artifacts

6 total|2 schema|2 ontology|1 validation
Northern Territory GEMIS

By Type

field mappings1
validation report1
ontology derived2
schema profile2

Recent Artifacts

Mappings: au_nt_gemis → mineral_occurrence

Harmonize au_nt_gemis → Generate mappings

field mappingsau_nt_gemis
9 FebConfidence: 84%
Show data
{
  "mappings": [
    {
      "confidence": 0.95,
      "mappingType": "direct",
      "sourceField": "name",
      "justification": "Direct semantic match - both represent the primary name of the mineral occurrence",
      "targetAttribute": "name"
    },
    {
      "transform": {
        "type": "lookup",
        "lookupTable": "occurrence_type_to_status"
      },
      "confidence": 0.7,
      "mappingType": "lookup",
      "sourceField": "mineraloccurrencetype",
      "justification": "Occurrence type may indicate operational status, but needs value mapping from 'occurrence' to appropriate status enum",
      "targetAttribute": "status"
    },
    {
      "confidence": 0.9,
      "mappingType": "direct",
      "sourceField": "commodity",
      "justification": "Direct match - commodity field contains the main mineral of economic interest",
      "targetAttribute": "primary_commodity"
    },
    {
      "transform": {
        "type": "expression",
        "expression": "convert_commodity_to_symbol_array(commodity)"
      },
      "confidence": 0.8,
      "mappingType": "computed",
      "sourceField": "commodity",
      "justification": "Single commodity value needs to be converted to array format and potentially mapped to element symbols",
      "targetAttribute": "commodities"
    },
    {
      "transform": {
        "type": "lookup",
        "lookupTable": "deposit_model_to_type"
      },
      "confidence": 0.8,
      "mappingType": "lookup",
      "sourceField": "mineraldepositmodel",
      "justification": "Deposit model describes geological classification, needs mapping to standard deposit type enum",
      "targetAttribute": "deposit_type"
    },
    {
      "confidence": 0.85,
      "mappingType": "direct",
      "sourceField": "hostgeologicunit",
      "justification": "Host geological unit describes the primary host rock lithology",
      "targetAttribute": "host_rock"
    },
    {
      "transform": {
        "type": "lookup",
        "lookupTable": "geological_period_to_age"
      },
      "confidence": 0.8,
      "mappingType": "lookup",
      "sourceField": "geologichistory",
      "justification": "Geological history indicates age of formation, needs mapping to standard age enum",
      "targetAttribute": "geological_age"
    },
    {
      "confidence": 0.95,
      "mappingType": "direct",
      "sourceField": "_id",
      "justification": "Primary identifier from the source dataset maps directly to source_id",
      "targetAttribute": "source_id"
    }
  ],
  "featureType": "mineral_occurrence",
  "unmappedFields": [
    "_geom",
    "_featuretype",
    "explorationactivitytype",
    "hostgeologicunit_uri",
    "identifier",
    "mineraloccurrenceshape",
    "mineraloccurrencetype_uri",
    "positionalaccuracy",
    "representativeage_uri",
    "representativecommodity_uri",
    "specification_uri",
    "_mirrored_at",
    "geom"
  ],
  "overallConfidence": 0.82,
  "suggestedAttributes": [
    {
      "name": "exploration_activities",
      "dataType": "ARRAY",
      "description": "Types of exploration activities conducted (drilling, mapping, geophysics, etc.)"
    },
    {
      "name": "occurrence_shape",
      "dataType": "TEXT",
      "description": "Physical morphology of the mineral occurrence (sheet, vein, disseminated, etc.)"
    },
    {
      "name": "positional_accuracy",
      "dataType": "INTEGER",
      "description": "Accuracy of geographical coordinates in meters"
    },
    {
      "name": "external_uris",
      "dataType": "OBJECT",
      "description": "Collection of external URI references for linked data"
    },
    {
      "name": "geometry",
      "dataType": "GEOMETRY",
      "description": "Point geometry representing the occurrence location"
    }
  ]
}
Validation: au_nt_gemis

Harmonize au_nt_gemis → Validate ontology

validation reportau_nt_gemis
9 FebValidation: 73%4 issues
Show data
{
  "isValid": false,
  "warnings": [
    "positional_accuracy: 100% of values don't match expected type INTEGER",
    "geometry: 100% of values don't match expected type GEOMETRY"
  ],
  "sourceSlug": "au_nt_gemis",
  "featureType": "mineral_occurrence",
  "suggestions": [],
  "validatedAt": "2026-02-09T21:49:51.736Z",
  "criticalIssues": [
    "country: No matching field found for patterns: ",
    "jurisdiction: No matching field found for patterns: "
  ],
  "totalAttributes": 15,
  "validAttributes": 11,
  "validationScore": 73,
  "fieldValidations": [
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 2105
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "name",
      "totalRecords": 2105,
      "attributeName": "name",
      "distinctCount": 2101,
      "sourcePatterns": [
        "name"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 2105
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "commodity",
      "totalRecords": 2105,
      "attributeName": "commodities",
      "distinctCount": 154,
      "sourcePatterns": [
        "commodity"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 2105
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "representativecommodity_uri",
      "totalRecords": 2105,
      "attributeName": "primary_commodity",
      "distinctCount": 47,
      "sourcePatterns": [
        "representativecommodity_uri"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 327,
      "actualTypes": {
        "string": 1778
      },
      "nullPercent": 16,
      "expectedType": "TEXT",
      "matchedField": "mineraldepositmodel",
      "totalRecords": 2105,
      "attributeName": "deposit_type",
      "distinctCount": 42,
      "sourcePatterns": [
        "mineraldepositmodel"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 2105
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "mineraloccurrencetype",
      "totalRecords": 2105,
      "attributeName": "occurrence_type",
      "distinctCount": 2,
      "sourcePatterns": [
        "mineraloccurrencetype"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 32,
      "actualTypes": {
        "string": 2073
      },
      "nullPercent": 2,
      "expectedType": "TEXT",
      "matchedField": "mineraloccurrenceshape",
      "totalRecords": 2105,
      "attributeName": "occurrence_shape",
      "distinctCount": 8,
      "sourcePatterns": [
        "mineraloccurrenceshape"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 691,
      "actualTypes": {
        "string": 1414
      },
      "nullPercent": 33,
      "expectedType": "TEXT",
      "matchedField": "hostgeologicunit",
      "totalRecords": 2105,
      "attributeName": "host_rock",
      "distinctCount": 230,
      "sourcePatterns": [
        "hostgeologicunit"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 91,
      "actualTypes": {
        "string": 2014
      },
      "nullPercent": 4,
      "expectedType": "TEXT",
      "matchedField": "geologichistory",
      "totalRecords": 2105,
      "attributeName": "geological_age",
      "distinctCount": 24,
      "sourcePatterns": [
        "geologichistory",
        "representativeage_uri"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 381,
      "actualTypes": {
        "string": 1724
      },
      "nullPercent": 18,
      "expectedType": "TEXT",
      "matchedField": "explorationactivitytype",
      "totalRecords": 2105,
      "attributeName": "exploration_activities",
      "distinctCount": 75,
      "sourcePatterns": [
        "explorationactivitytype"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [
        "100% of values don't match expected type INTEGER"
      ],
      "isValid": false,
      "nullCount": 123,
      "actualTypes": {
        "string": 1982
      },
      "nullPercent": 6,
      "expectedType": "INTEGER",
      "matchedField": "positionalaccuracy",
      "sampleIssues": [
        "100",
        "100",
        "100",
        "100",
        "100"
      ],
      "totalRecords": 2105,
      "attributeName": "positional_accuracy",
      "distinctCount": 8,
      "sourcePatterns": [
        "positionalaccuracy"
      ],
      "typeMismatchPercent": 100
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 2105
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "identifier",
      "totalRecords": 2105,
      "attributeName": "source_id",
      "distinctCount": 2105,
      "sourcePatterns": [
        "identifier",
        "_id"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 2105
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "specification_uri",
      "totalRecords": 2105,
      "attributeName": "source_url",
      "distinctCount": 2105,
      "sourcePatterns": [
        "specification_uri"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [
        "100% of values don't match expected type GEOMETRY"
      ],
      "isValid": false,
      "nullCount": 0,
      "actualTypes": {
        "string": 2105
      },
      "nullPercent": 0,
      "expectedType": "GEOMETRY",
      "matchedField": "_geom",
      "sampleIssues": [
        "POINT(131.14923558 -14.38692179)",
        "POINT(137.52076688 -18.64032765)",
        "POINT(135.54401382 -21.67817649)",
        "POINT(129.65741839 -23.10509143)",
        "POINT(136.17725114 -13.28031475)"
      ],
      "totalRecords": 2105,
      "attributeName": "geometry",
      "distinctCount": 2103,
      "sourcePatterns": [
        "_geom",
        "geom"
      ],
      "typeMismatchPercent": 100
    },
    {
      "issues": [
        "No matching field found for patterns: "
      ],
      "isValid": false,
      "nullCount": 2105,
      "actualTypes": {},
      "nullPercent": 100,
      "expectedType": "TEXT",
      "matchedField": null,
      "totalRecords": 2105,
      "attributeName": "country",
      "distinctCount": 0,
      "sourcePatterns": [],
      "typeMismatchPercent": 100
    },
    {
      "issues": [
        "No matching field found for patterns: "
      ],
      "isValid": false,
      "nullCount": 2105,
      "actualTypes": {},
      "nullPercent": 100,
      "expectedType": "TEXT",
      "matchedField": null,
      "totalRecords": 2105,
      "attributeName": "jurisdiction",
      "distinctCount": 0,
      "sourcePatterns": [],
      "typeMismatchPercent": 100
    }
  ],
  "recordsValidated": 2105,
  "attributesWithIssues": 4
}
Ontology: mineral_occurrence

Harmonize au_nt_gemis → Derive ontology

ontology derivedau_nt_gemis
9 FebConfidence: 95%
Show data
{
  "domain": "mining",
  "qualityNotes": [
    "Some records have null values for hostgeologicunit and positionalaccuracy",
    "Geological history shows 'Unknown' for some records indicating incomplete geological context",
    "Commodity field contains comma-separated values that may need parsing for individual commodities",
    "URI fields provide good linkage to external vocabularies and standards",
    "Duplicate geometry fields (_geom and geom) suggest data processing artifacts",
    "All records consistently show 'occurrence' type, indicating homogeneous dataset",
    "Positional accuracy is provided as string but should be numeric for analysis"
  ],
  "commonPatterns": {
    "dateFields": [
      "_mirrored_at"
    ],
    "statusFields": [
      "mineraloccurrencetype"
    ],
    "geometryFields": [
      "_geom",
      "geom"
    ],
    "commodityFields": [
      "commodity",
      "representativecommodity_uri"
    ],
    "identifierFields": [
      "_id",
      "identifier"
    ],
    "measurementFields": [
      "positionalaccuracy"
    ]
  },
  "alternativeTypes": [],
  "primaryFeatureType": {
    "name": "Mineral Occurrence",
    "slug": "mineral_occurrence",
    "reasoning": "This data clearly represents mineral occurrences based on the 'mineraloccurrencetype' field consistently showing 'occurrence', the presence of commodity information, geological context, and point geometries. The field names and URI references to mineral occurrence classifiers confirm this is geological survey data about mineral occurrences.",
    "attributes": [
      {
        "name": "name",
        "dataType": "TEXT",
        "examples": [
          "Disputed Creek 1",
          "Trackrider",
          "Plum Tree Point"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Name of the mineral occurrence",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "name"
        ]
      },
      {
        "name": "commodities",
        "dataType": "TEXT",
        "examples": [
          "Asbestos",
          "Barite,Fluorite,Lead,Zinc",
          "Gold"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Comma-separated list of commodities present at this occurrence",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "commodity"
        ]
      },
      {
        "name": "primary_commodity",
        "dataType": "TEXT",
        "examples": [
          "Asbestos",
          "Lead",
          "Copper",
          "Gold"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Primary commodity of interest at this occurrence",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "representativecommodity_uri"
        ]
      },
      {
        "name": "deposit_type",
        "dataType": "TEXT",
        "examples": [
          "ophiolite related",
          "carbonate Pb-Zn-Cu",
          "vein"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Mineral deposit model or type",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "mineraldepositmodel"
        ]
      },
      {
        "name": "occurrence_type",
        "dataType": "TEXT",
        "examples": [
          "occurrence"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Type of mineral occurrence",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "mineraloccurrencetype"
        ]
      },
      {
        "name": "occurrence_shape",
        "dataType": "TEXT",
        "examples": [
          "Sheet",
          "Irregular",
          "Stratiform"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Morphological shape of the mineral occurrence",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "mineraloccurrenceshape"
        ]
      },
      {
        "name": "host_rock",
        "dataType": "TEXT",
        "examples": [
          "Harts Range Metamorphic Complex,Irindina Gneiss",
          "Hatches Creek Group,Kurinelli Sandstone"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Host geological unit or rock type",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "hostgeologicunit"
        ]
      },
      {
        "name": "geological_age",
        "dataType": "TEXT",
        "examples": [
          "PALAEOPROTEROZOIC",
          "Unknown"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Geological age or period",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "geologichistory",
          "representativeage_uri"
        ]
      },
      {
        "name": "exploration_activities",
        "dataType": "TEXT",
        "examples": [
          "Costeaning,General prospecting,Shallow pit",
          "Drilling,Geochemistry,Geological mapping,Geophysics"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Types of exploration activities conducted",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "explorationactivitytype"
        ]
      },
      {
        "name": "positional_accuracy",
        "dataType": "INTEGER",
        "examples": [
          "100"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Positional accuracy in meters",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "positionalaccuracy"
        ]
      },
      {
        "name": "source_id",
        "dataType": "TEXT",
        "examples": [
          "http://geology.data.nt.gov.au/resource/feature/ntgs/mineraloccurrence/341",
          "nt_occ_woncz9"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Original identifier from source system",
        "isIdentifier": true,
        "sourceFieldPatterns": [
          "identifier",
          "_id"
        ]
      },
      {
        "name": "source_url",
        "dataType": "TEXT",
        "examples": [
          "http://geology.data.nt.gov.au/resource/feature/ntgs/mineraloccurrence/341"
        ],
        "required": false,
        "isGeometry": false,
        "description": "URL to detailed specification or source record",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "specification_uri"
        ]
      },
      {
        "name": "geometry",
        "dataType": "GEOMETRY",
        "examples": [
          "POINT(134.94756401 -23.04342614)"
        ],
        "required": true,
        "isGeometry": true,
        "description": "Point location of the mineral occurrence",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "_geom",
          "geom"
        ]
      },
      {
        "name": "country",
        "dataType": "TEXT",
        "examples": [
          "AU"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Country code",
        "isIdentifier": false,
        "sourceFieldPatterns": []
      },
      {
        "name": "jurisdiction",
        "dataType": "TEXT",
        "examples": [
          "NT"
        ],
        "required": true,
        "isGeometry": false,
        "description": "State or territory jurisdiction",
        "isIdentifier": false,
        "sourceFieldPatterns": []
      }
    ],
    "confidence": 0.95,
    "description": "A location where minerals have been found, including prospects, deposits, and mineral occurrences with documented commodities and geological context",
    "geometryType": "POINT"
  }
}
Schema: au_nt_gemis

Harmonize au_nt_gemis → Analyze schema

schema profileau_nt_gemis
9 Feb
Show data
{
  "fields": [
    {
      "name": "_id",
      "type": "string",
      "pattern": "nt_occ_[a-z0-9]+",
      "nullable": false,
      "description": "Unique identifier for each mineral occurrence record",
      "sampleValues": [
        "nt_occ_v6i9cl",
        "nt_occ_6f79t4",
        "nt_occ_nqtucv"
      ]
    },
    {
      "name": "_geom",
      "type": "geometry",
      "pattern": "POINT\\([0-9.-]+ [0-9.-]+\\)",
      "nullable": false,
      "description": "Point geometry representing the location of the mineral occurrence",
      "sampleValues": [
        "POINT(137.03872701 -17.782815)",
        "POINT(132.12093731 -14.11577024)"
      ]
    },
    {
      "name": "_featuretype",
      "type": "string",
      "nullable": true,
      "description": "Feature type classification (appears to be null in all samples)",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "commodity",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "Uranium",
        "Gold",
        "Copper"
      ],
      "description": "Primary mineral commodity or resource type",
      "sampleValues": [
        "Uranium",
        "Gold",
        "Copper"
      ]
    },
    {
      "name": "explorationactivitytype",
      "type": "string",
      "nullable": false,
      "description": "Types of exploration activities conducted at the site",
      "sampleValues": [
        "Drilling,Geological mapping,Geophysics",
        "Drilling",
        "Geochemistry,Geological mapping,Geophysics"
      ]
    },
    {
      "name": "geologichistory",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "Unknown",
        "PALAEOPROTEROZOIC"
      ],
      "description": "Geological age or time period of formation",
      "sampleValues": [
        "Unknown",
        "PALAEOPROTEROZOIC"
      ]
    },
    {
      "name": "hostgeologicunit",
      "type": "string",
      "nullable": true,
      "description": "Geological formation or unit hosting the mineral occurrence",
      "sampleValues": [
        "El Sherana Group,Tollis Formation",
        "Strangways Metamorphic Complex,Bungitina Metamorphics",
        null
      ]
    },
    {
      "name": "hostgeologicunit_uri",
      "type": "string",
      "nullable": true,
      "description": "URI reference to the host geological unit in external database",
      "sampleValues": [
        "http://dbforms.ga.gov.au/pls/www/geodx.strat_units.sch?...",
        null
      ]
    },
    {
      "name": "identifier",
      "type": "string",
      "pattern": "http://geology\\.data\\.nt\\.gov\\.au/resource/feature/ntgs/mineraloccurrence/[0-9]+",
      "nullable": false,
      "description": "Persistent URI identifier for the mineral occurrence",
      "sampleValues": [
        "http://geology.data.nt.gov.au/resource/feature/ntgs/mineraloccurrence/1556"
      ]
    },
    {
      "name": "mineraldepositmodel",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "Hydrothermal",
        "vein"
      ],
      "description": "Geological model describing how the mineral deposit formed",
      "sampleValues": [
        "Hydrothermal",
        "vein"
      ]
    },
    {
      "name": "mineraloccurrenceshape",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "Sheet"
      ],
      "description": "Physical shape or form of the mineral occurrence",
      "sampleValues": [
        "Sheet"
      ]
    },
    {
      "name": "mineraloccurrencetype",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "occurrence"
      ],
      "description": "Classification type of the mineral occurrence",
      "sampleValues": [
        "occurrence"
      ]
    },
    {
      "name": "mineraloccurrencetype_uri",
      "type": "string",
      "nullable": false,
      "description": "URI reference to the mineral occurrence type classification",
      "sampleValues": [
        "http://resource.geosciml.org/classifier/cgi/mineral-occurrence-type/Mineral occurrence"
      ]
    },
    {
      "name": "name",
      "type": "string",
      "nullable": false,
      "description": "Common name or designation of the mineral occurrence",
      "sampleValues": [
        "Anomaly 1",
        "Penguin",
        "Brumby U",
        "Linda Jane",
        "Low Chinese"
      ]
    },
    {
      "name": "positionalaccuracy",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "100"
      ],
      "description": "Accuracy of the geographical position in meters",
      "sampleValues": [
        "100"
      ]
    },
    {
      "name": "representativeage_uri",
      "type": "string",
      "nullable": false,
      "description": "URI reference to the representative geological age",
      "sampleValues": [
        "http://resource.geosciml.org/classifier/ics/ischart/Unknown",
        "http://resource.geosciml.org/classifier/ics/ischart/PALAEOPROTEROZOIC"
      ]
    },
    {
      "name": "representativecommodity_uri",
      "type": "string",
      "nullable": false,
      "description": "URI reference to the representative commodity classification",
      "sampleValues": [
        "http://resource.geosciml.org/classifier/cgi/commodity-code/Uranium",
        "http://resource.geosciml.org/classifier/cgi/commodity-code/Gold"
      ]
    },
    {
      "name": "specification_uri",
      "type": "string",
      "nullable": false,
      "description": "URI specification reference for the mineral occurrence",
      "sampleValues": [
        "http://geology.data.nt.gov.au/resource/feature/ntgs/mineraloccurrence/1556"
      ]
    },
    {
      "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:03:55.608095+00"
      ]
    },
    {
      "name": "geom",
      "type": "geometry",
      "nullable": false,
      "description": "Binary geometry representation (Well-Known Binary format)",
      "sampleValues": [
        "0101000020E6100000802D6D403D21614078D1579066C831C0"
      ]
    }
  ],
  "semantics": {
    "idFields": [
      "_id",
      "identifier"
    ],
    "nameFields": [
      "name"
    ],
    "primaryKey": "_id",
    "statusFields": [
      "mineraloccurrencetype"
    ],
    "fieldMeanings": {
      "_id": "Primary key identifier",
      "geom": "Binary geometry representation",
      "name": "Common name of occurrence",
      "_geom": "Point geometry coordinates",
      "commodity": "Mineral commodity type",
      "identifier": "Persistent URI identifier",
      "_featuretype": "Feature classification type",
      "_mirrored_at": "Data synchronization timestamp",
      "geologichistory": "Geological time period",
      "hostgeologicunit": "Host rock formation",
      "specification_uri": "Specification URI reference",
      "positionalaccuracy": "Location accuracy in meters",
      "mineraldepositmodel": "Deposit formation model",
      "hostgeologicunit_uri": "Host rock formation URI reference",
      "mineraloccurrencetype": "Occurrence classification",
      "representativeage_uri": "Geological age URI reference",
      "mineraloccurrenceshape": "Physical shape of occurrence",
      "explorationactivitytype": "Exploration methods used",
      "mineraloccurrencetype_uri": "Occurrence type URI reference",
      "representativecommodity_uri": "Commodity URI reference"
    },
    "relationships": [
      {
        "field": "commodity",
        "relatedTo": "representativecommodity_uri",
        "relationshipType": "semantic_reference"
      },
      {
        "field": "geologichistory",
        "relatedTo": "representativeage_uri",
        "relationshipType": "semantic_reference"
      },
      {
        "field": "hostgeologicunit",
        "relatedTo": "hostgeologicunit_uri",
        "relationshipType": "semantic_reference"
      },
      {
        "field": "_geom",
        "relatedTo": "geom",
        "relationshipType": "geometry_representation"
      },
      {
        "field": "identifier",
        "relatedTo": "specification_uri",
        "relationshipType": "uri_reference"
      }
    ],
    "geometryFields": [
      "_geom",
      "geom"
    ],
    "commodityFields": [
      "commodity",
      "representativecommodity_uri"
    ]
  },
  "confidence": 0.95,
  "entityType": "mineral_occurrence",
  "recordCount": 100
}
Ontology: mineral_occurrence

Harmonize au_nt_gemis → Derive ontology

ontology derivedau_nt_gemis
9 FebConfidence: 95%
Show data
{
  "domain": "mining",
  "qualityNotes": [
    "Many fields contain null values, particularly explorationactivitytype, mineraldepositmodel, and positionalaccuracy",
    "Some records have 'Unknown' values for geological history and occurrence shape",
    "Commodity field contains both single commodities and comma-separated lists",
    "Host geological unit field contains comma-separated values that may need parsing",
    "URI fields provide good linkage to external vocabularies but may not always be populated",
    "Positional accuracy varies significantly (10m to 100m) and is sometimes null",
    "Names include both proper names and generic 'Unnamed' entries with ID numbers"
  ],
  "commonPatterns": {
    "dateFields": [
      "_mirrored_at"
    ],
    "statusFields": [
      "mineraloccurrencetype"
    ],
    "geometryFields": [
      "_geom",
      "geom"
    ],
    "commodityFields": [
      "commodity",
      "representativecommodity_uri"
    ],
    "identifierFields": [
      "_id",
      "identifier",
      "specification_uri"
    ],
    "measurementFields": [
      "positionalaccuracy"
    ]
  },
  "alternativeTypes": [],
  "primaryFeatureType": {
    "name": "Mineral Occurrence",
    "slug": "mineral_occurrence",
    "reasoning": "This data clearly represents mineral occurrences based on the 'mineraloccurrencetype' field containing values like 'occurrence' and 'prospect', the presence of commodity information, and geological context. The existing mineral_occurrence feature type is a perfect match.",
    "attributes": [
      {
        "name": "name",
        "dataType": "TEXT",
        "examples": [
          "Nabarlek South",
          "No 3",
          "Anomaly TE-1",
          "Unnamed 05615"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Name of the mineral occurrence",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "name"
        ]
      },
      {
        "name": "occurrence_type",
        "dataType": "TEXT",
        "examples": [
          "occurrence",
          "prospect"
        ],
        "required": true,
        "enumValues": [
          "occurrence",
          "prospect"
        ],
        "isGeometry": false,
        "description": "Type of mineral occurrence (occurrence, prospect, etc.)",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "mineraloccurrencetype",
          "occurrence_type"
        ]
      },
      {
        "name": "commodities",
        "dataType": "TEXT",
        "examples": [
          "Uranium",
          "Barite",
          "Nickel,Uranium,Zinc",
          "Lead"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Comma-separated list of commodities present",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "commodity",
          "commodities"
        ]
      },
      {
        "name": "primary_commodity",
        "dataType": "TEXT",
        "examples": [
          "Uranium",
          "Barite",
          "Lead"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Primary commodity of interest",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "representativecommodity_uri",
          "primary_commodity"
        ]
      },
      {
        "name": "deposit_type",
        "dataType": "TEXT",
        "examples": [
          "unconformity related",
          "vein",
          "superficial enrichment"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Mineral deposit model or type",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "mineraldepositmodel",
          "deposit_type"
        ]
      },
      {
        "name": "occurrence_shape",
        "dataType": "TEXT",
        "examples": [
          "Sheet",
          "Unknown",
          "Irregular"
        ],
        "required": false,
        "enumValues": [
          "Sheet",
          "Unknown",
          "Irregular"
        ],
        "isGeometry": false,
        "description": "Geometric shape of the mineral occurrence",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "mineraloccurrenceshape",
          "occurrence_shape"
        ]
      },
      {
        "name": "host_rock",
        "dataType": "TEXT",
        "examples": [
          "Namoona Group,Myra Falls Metamorphics",
          "Undefined,Antrim Plateau Volcanics"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Host geological unit or rock type",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "hostgeologicunit",
          "host_rock",
          "host_geology"
        ]
      },
      {
        "name": "geological_age",
        "dataType": "TEXT",
        "examples": [
          "NEOPROTEROZOIC",
          "Unknown"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Geological age or history",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "geologichistory",
          "geological_age",
          "age"
        ]
      },
      {
        "name": "exploration_activities",
        "dataType": "TEXT",
        "examples": [
          "Drilling,Geochemistry,Geological mapping,Geophysics",
          "Costeaning,Geological mapping"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Types of exploration activities conducted",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "explorationactivitytype",
          "exploration_activities"
        ]
      },
      {
        "name": "positional_accuracy",
        "dataType": "INTEGER",
        "examples": [
          "100",
          "10"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Positional accuracy in meters",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "positionalaccuracy",
          "accuracy"
        ]
      },
      {
        "name": "source_id",
        "dataType": "TEXT",
        "examples": [
          "http://geology.data.nt.gov.au/resource/feature/ntgs/mineraloccurrence/5615"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Original identifier from source system",
        "isIdentifier": true,
        "sourceFieldPatterns": [
          "identifier",
          "source_id",
          "_id"
        ]
      },
      {
        "name": "source_url",
        "dataType": "TEXT",
        "examples": [
          "http://geology.data.nt.gov.au/resource/feature/ntgs/mineraloccurrence/5615"
        ],
        "required": false,
        "isGeometry": false,
        "description": "URL to detailed specification",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "specification_uri",
          "source_url"
        ]
      },
      {
        "name": "jurisdiction",
        "dataType": "TEXT",
        "examples": [
          "Northern Territory"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Administrative jurisdiction",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "jurisdiction"
        ]
      },
      {
        "name": "country",
        "dataType": "TEXT",
        "examples": [
          "AU"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Country code",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "country"
        ]
      },
      {
        "name": "geometry",
        "dataType": "GEOMETRY",
        "required": true,
        "isGeometry": true,
        "description": "Point location of the mineral occurrence",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "_geom",
          "geom",
          "geometry"
        ]
      }
    ],
    "confidence": 0.95,
    "description": "A location where minerals have been found, including prospects, deposits, and mineral occurrences in the Northern Territory",
    "geometryType": "POINT"
  }
}
Schema: au_nt_gemis

Harmonize au_nt_gemis → Analyze schema

schema profileau_nt_gemis
9 Feb
Show data
{
  "fields": [
    {
      "name": "_id",
      "type": "string",
      "pattern": "nt_occ_[a-z0-9]+",
      "nullable": false,
      "description": "Unique identifier for each mineral occurrence record",
      "sampleValues": [
        "nt_occ_5pt1lx",
        "nt_occ_rzub17",
        "nt_occ_vvn9gx"
      ]
    },
    {
      "name": "_geom",
      "type": "geometry",
      "pattern": "POINT\\([0-9.-]+ [0-9.-]+\\)",
      "nullable": false,
      "description": "Point geometry representing the location of the mineral occurrence",
      "sampleValues": [
        "POINT(133.98166534 -21.17444043)",
        "POINT(131.3124733 -13.5842978)"
      ]
    },
    {
      "name": "_featuretype",
      "type": "string",
      "nullable": true,
      "description": "Feature type classification (appears to be null in all samples)",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "commodity",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "Gold",
        "Copper",
        "Lead,Zinc",
        "Uranium",
        "Copper,Lead"
      ],
      "description": "Primary commodity or mineral type found at the occurrence",
      "sampleValues": [
        "Gold",
        "Copper",
        "Lead,Zinc",
        "Uranium"
      ]
    },
    {
      "name": "explorationactivitytype",
      "type": "string",
      "nullable": false,
      "description": "Types of exploration activities conducted at the site",
      "sampleValues": [
        "Drilling,Geological mapping",
        "Geological mapping",
        "Drilling,Geochemistry,Geophysics"
      ]
    },
    {
      "name": "geologichistory",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "Unknown",
        "PALAEOPROTEROZOIC",
        "MESOPROTEROZOIC"
      ],
      "description": "Geological age or era of the occurrence",
      "sampleValues": [
        "Unknown",
        "PALAEOPROTEROZOIC",
        "MESOPROTEROZOIC"
      ]
    },
    {
      "name": "hostgeologicunit",
      "type": "string",
      "nullable": true,
      "description": "Geological formation or unit hosting the mineral occurrence",
      "sampleValues": [
        "South Alligator Group,Mount Bonnie Formation",
        "Mount Partridge Group,Whites Formation",
        null
      ]
    },
    {
      "name": "hostgeologicunit_uri",
      "type": "string",
      "nullable": true,
      "description": "URI reference to the host geological unit in external database",
      "sampleValues": [
        "http://dbforms.ga.gov.au/pls/www/geodx.strat_units.sch?...",
        null
      ]
    },
    {
      "name": "identifier",
      "type": "string",
      "pattern": "http://geology\\.data\\.nt\\.gov\\.au/resource/feature/ntgs/mineraloccurrence/[0-9]+",
      "nullable": false,
      "description": "Persistent URI identifier for the mineral occurrence",
      "sampleValues": [
        "http://geology.data.nt.gov.au/resource/feature/ntgs/mineraloccurrence/5573"
      ]
    },
    {
      "name": "mineraldepositmodel",
      "type": "string",
      "nullable": true,
      "enumValues": [
        "vein",
        "shear hosted",
        "unconformity related",
        "carbonate Pb-Zn-Cu"
      ],
      "description": "Type or model of mineral deposit",
      "sampleValues": [
        "vein",
        "shear hosted",
        "unconformity related",
        null
      ]
    },
    {
      "name": "mineraloccurrenceshape",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "Unknown",
        "Sheet",
        "Tabular",
        "Irregular"
      ],
      "description": "Physical shape or form of the mineral occurrence",
      "sampleValues": [
        "Unknown",
        "Sheet",
        "Tabular",
        "Irregular"
      ]
    },
    {
      "name": "mineraloccurrencetype",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "occurrence"
      ],
      "description": "Classification type of the mineral occurrence",
      "sampleValues": [
        "occurrence"
      ]
    },
    {
      "name": "mineraloccurrencetype_uri",
      "type": "string",
      "nullable": false,
      "description": "URI reference to the mineral occurrence type classification",
      "sampleValues": [
        "http://resource.geosciml.org/classifier/cgi/mineral-occurrence-type/Mineral occurrence"
      ]
    },
    {
      "name": "name",
      "type": "string",
      "nullable": false,
      "description": "Common name or designation of the mineral occurrence",
      "sampleValues": [
        "NW Petricks",
        "Whatleys Cu",
        "Acacia North",
        "Southeast Kylie"
      ]
    },
    {
      "name": "positionalaccuracy",
      "type": "string",
      "nullable": true,
      "description": "Accuracy of the positional coordinates in meters",
      "sampleValues": [
        "100",
        null
      ]
    },
    {
      "name": "representativeage_uri",
      "type": "string",
      "nullable": false,
      "description": "URI reference to the representative geological age",
      "sampleValues": [
        "http://resource.geosciml.org/classifier/ics/ischart/Unknown",
        "http://resource.geosciml.org/classifier/ics/ischart/PALAEOPROTEROZOIC"
      ]
    },
    {
      "name": "representativecommodity_uri",
      "type": "string",
      "nullable": false,
      "description": "URI reference to the representative commodity classification",
      "sampleValues": [
        "http://resource.geosciml.org/classifier/cgi/commodity-code/Gold",
        "http://resource.geosciml.org/classifier/cgi/commodity-code/Copper"
      ]
    },
    {
      "name": "specification_uri",
      "type": "string",
      "nullable": false,
      "description": "URI specification reference for the mineral occurrence",
      "sampleValues": [
        "http://geology.data.nt.gov.au/resource/feature/ntgs/mineraloccurrence/5573"
      ]
    },
    {
      "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:03:55.608095+00"
      ]
    },
    {
      "name": "geom",
      "type": "geometry",
      "nullable": false,
      "description": "Binary geometry data in Well-Known Binary format",
      "sampleValues": [
        "0101000020E6100000565D6ECD69BF60403FF3C520A82C35C0"
      ]
    }
  ],
  "semantics": {
    "idFields": [
      "_id",
      "identifier",
      "specification_uri"
    ],
    "nameFields": [
      "name"
    ],
    "primaryKey": "_id",
    "statusFields": [
      "mineraloccurrencetype",
      "explorationactivitytype"
    ],
    "fieldMeanings": {
      "_id": "Primary key identifier",
      "geom": "Binary geometry data",
      "name": "Common occurrence name",
      "_geom": "Point geometry coordinates",
      "commodity": "Primary mineral commodity",
      "identifier": "Persistent URI identifier",
      "_featuretype": "Feature type classification",
      "_mirrored_at": "Data synchronization timestamp",
      "geologichistory": "Geological age/era",
      "hostgeologicunit": "Host rock formation",
      "specification_uri": "Specification reference",
      "positionalaccuracy": "Coordinate accuracy in meters",
      "mineraldepositmodel": "Deposit type classification",
      "hostgeologicunit_uri": "Host geological unit reference",
      "mineraloccurrencetype": "Occurrence classification",
      "representativeage_uri": "Geological age reference",
      "mineraloccurrenceshape": "Physical occurrence shape",
      "explorationactivitytype": "Exploration methods used",
      "mineraloccurrencetype_uri": "Occurrence type reference",
      "representativecommodity_uri": "Commodity classification reference"
    },
    "relationships": [
      {
        "field": "identifier",
        "relatedTo": "specification_uri",
        "relationshipType": "equivalent"
      },
      {
        "field": "commodity",
        "relatedTo": "representativecommodity_uri",
        "relationshipType": "classification"
      },
      {
        "field": "geologichistory",
        "relatedTo": "representativeage_uri",
        "relationshipType": "classification"
      },
      {
        "field": "_geom",
        "relatedTo": "geom",
        "relationshipType": "equivalent"
      }
    ],
    "geometryFields": [
      "_geom",
      "geom"
    ],
    "commodityFields": [
      "commodity",
      "representativecommodity_uri"
    ]
  },
  "confidence": 0.95,
  "entityType": "mineral_occurrence",
  "recordCount": 100
}