Artifacts

{
  "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": "expression",
        "expression": "Convert single mine name to array format, exclude if 'Unnamed' or same as primary name"
      },
      "confidence": 0.75,
      "mappingType": "computed",
      "sourceField": "minename",
      "justification": "Mine name can serve as an alternate name when different from occurrence name, needs array transformation",
      "targetAttribute": "alternate_names"
    },
    {
      "transform": {
        "type": "lookup",
        "lookupTable": "occurrence_type_to_status"
      },
      "confidence": 0.7,
      "mappingType": "lookup",
      "sourceField": "mineraloccurrencetype_uri",
      "justification": "URI contains occurrence type classification that can be mapped to operational status through lookup table",
      "targetAttribute": "status"
    },
    {
      "transform": {
        "type": "expression",
        "expression": "Split by comma, trim whitespace, map commodity names to element symbols (e.g., 'gold' -> 'AU', 'copper' -> 'CU')"
      },
      "confidence": 0.85,
      "mappingType": "computed",
      "sourceField": "commodity",
      "justification": "Commodity field contains comma-separated values that need parsing into array and standardization to element symbols",
      "targetAttribute": "commodities"
    },
    {
      "transform": {
        "type": "expression",
        "expression": "Extract first commodity from comma-separated list and standardize to element symbol"
      },
      "confidence": 0.8,
      "mappingType": "computed",
      "sourceField": "commodity",
      "justification": "First commodity in the list typically represents the primary commodity of interest",
      "targetAttribute": "primary_commodity"
    },
    {
      "confidence": 0.95,
      "mappingType": "direct",
      "sourceField": "_id",
      "justification": "Primary identifier from source system maps directly to source_id field",
      "targetAttribute": "source_id"
    }
  ],
  "featureType": "mineral_occurrence",
  "unmappedFields": [
    "_geom",
    "_featuretype",
    "identifier",
    "mine_uri",
    "mineraloccurrencetype",
    "observationmethod",
    "positionalaccuracy",
    "representativecommodity_uri",
    "source",
    "specification_uri",
    "_mirrored_at",
    "geom"
  ],
  "overallConfidence": 0.75,
  "suggestedAttributes": [
    {
      "name": "geometry",
      "dataType": "GEOMETRY",
      "description": "Point geometry representing the spatial location of the mineral occurrence"
    },
    {
      "name": "external_identifiers",
      "dataType": "OBJECT",
      "description": "Collection of external system identifiers and URIs"
    },
    {
      "name": "data_quality",
      "dataType": "OBJECT",
      "description": "Data quality metrics including positional accuracy and observation method"
    },
    {
      "name": "last_updated",
      "dataType": "TIMESTAMP",
      "description": "Timestamp of last data update or synchronization"
    }
  ]
}

{
  "isValid": false,
  "warnings": [
    "geometry: 100% of values don't match expected type GEOMETRY"
  ],
  "sourceSlug": "au_nsw_minocc",
  "featureType": "mineral_occurrence",
  "suggestions": [],
  "validatedAt": "2026-02-09T21:49:55.389Z",
  "criticalIssues": [
    "jurisdiction: No matching field found for patterns: ",
    "country: No matching field found for patterns: "
  ],
  "totalAttributes": 15,
  "validAttributes": 12,
  "validationScore": 80,
  "fieldValidations": [
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 30710
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "name",
      "totalRecords": 30710,
      "attributeName": "name",
      "distinctCount": 20782,
      "sourcePatterns": [
        "name",
        "minename"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 30710
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "minename",
      "totalRecords": 30710,
      "attributeName": "mine_name",
      "distinctCount": 10620,
      "sourcePatterns": [
        "minename"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 3548,
      "actualTypes": {
        "string": 27162
      },
      "nullPercent": 12,
      "expectedType": "TEXT",
      "matchedField": "commodity",
      "totalRecords": 30710,
      "attributeName": "primary_commodity",
      "distinctCount": 202,
      "sourcePatterns": [
        "commodity"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 30710,
      "actualEnums": [],
      "actualTypes": {},
      "nullPercent": 100,
      "expectedType": "TEXT",
      "matchedField": "mineraloccurrencetype",
      "missingEnums": [
        "occurrence",
        "deposit"
      ],
      "totalRecords": 30710,
      "attributeName": "occurrence_type",
      "distinctCount": 0,
      "expectedEnums": [
        "occurrence",
        "deposit"
      ],
      "sourcePatterns": [
        "mineraloccurrencetype"
      ],
      "unexpectedValues": [],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 30710
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "mineraloccurrencetype_uri",
      "totalRecords": 30710,
      "attributeName": "occurrence_type_uri",
      "distinctCount": 2,
      "sourcePatterns": [
        "mineraloccurrencetype_uri"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 3044,
      "actualTypes": {
        "string": 27666
      },
      "nullPercent": 10,
      "expectedType": "TEXT",
      "matchedField": "representativecommodity_uri",
      "totalRecords": 30710,
      "attributeName": "commodity_uri",
      "distinctCount": 28,
      "sourcePatterns": [
        "representativecommodity_uri"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 212,
      "actualTypes": {
        "string": 30498
      },
      "nullPercent": 1,
      "expectedType": "TEXT",
      "matchedField": "observationmethod",
      "totalRecords": 30710,
      "attributeName": "observation_method",
      "distinctCount": 15,
      "sourcePatterns": [
        "observationmethod"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 188,
      "actualTypes": {
        "string": 30522
      },
      "nullPercent": 1,
      "expectedType": "TEXT",
      "matchedField": "positionalaccuracy",
      "totalRecords": 30710,
      "attributeName": "positional_accuracy",
      "distinctCount": 39,
      "sourcePatterns": [
        "positionalaccuracy"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 14141,
      "actualTypes": {
        "string": 16569
      },
      "nullPercent": 46,
      "expectedType": "TEXT",
      "matchedField": "source",
      "totalRecords": 30710,
      "attributeName": "data_source",
      "distinctCount": 6,
      "sourcePatterns": [
        "source"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 30710
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "identifier",
      "totalRecords": 30710,
      "attributeName": "source_id",
      "distinctCount": 30710,
      "sourcePatterns": [
        "identifier",
        "_id"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 16902,
      "actualTypes": {
        "string": 13808
      },
      "nullPercent": 55,
      "expectedType": "TEXT",
      "matchedField": "mine_uri",
      "totalRecords": 30710,
      "attributeName": "mine_uri",
      "distinctCount": 13808,
      "sourcePatterns": [
        "mine_uri"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 30710
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "specification_uri",
      "totalRecords": 30710,
      "attributeName": "specification_uri",
      "distinctCount": 30710,
      "sourcePatterns": [
        "specification_uri"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [
        "No matching field found for patterns: "
      ],
      "isValid": false,
      "nullCount": 30710,
      "actualTypes": {},
      "nullPercent": 100,
      "expectedType": "TEXT",
      "matchedField": null,
      "totalRecords": 30710,
      "attributeName": "jurisdiction",
      "distinctCount": 0,
      "sourcePatterns": [],
      "typeMismatchPercent": 100
    },
    {
      "issues": [
        "No matching field found for patterns: "
      ],
      "isValid": false,
      "nullCount": 30710,
      "actualTypes": {},
      "nullPercent": 100,
      "expectedType": "TEXT",
      "matchedField": null,
      "totalRecords": 30710,
      "attributeName": "country",
      "distinctCount": 0,
      "sourcePatterns": [],
      "typeMismatchPercent": 100
    },
    {
      "issues": [
        "100% of values don't match expected type GEOMETRY"
      ],
      "isValid": false,
      "nullCount": 0,
      "actualTypes": {
        "string": 30710
      },
      "nullPercent": 0,
      "expectedType": "GEOMETRY",
      "matchedField": "_geom",
      "sampleIssues": [
        "POINT(147.311 -33.9189)",
        "POINT(141.593 -32.0504)",
        "POINT(141.517 -31.7577)",
        "POINT(151.6 -32.89)",
        "POINT(141.398 -31.6755)"
      ],
      "totalRecords": 30710,
      "attributeName": "geometry",
      "distinctCount": 30371,
      "sourcePatterns": [
        "_geom",
        "geom"
      ],
      "typeMismatchPercent": 100
    }
  ],
  "recordsValidated": 30710,
  "attributesWithIssues": 3
}

{
  "domain": "mining",
  "qualityNotes": [
    "Many records have null commodity values, limiting the usefulness for commodity-based analysis",
    "Mine names often show 'Unnamed' or 'UNKNOWN', indicating incomplete naming data",
    "Positional accuracy varies significantly (50m to 500m), affecting spatial precision",
    "Some records lack mine_uri associations, suggesting not all occurrences are linked to mine records",
    "The _featuretype field is consistently null across all samples",
    "Data source quality varies from 'field checked' (highest confidence) to 'company report' (variable confidence)",
    "Observation methods are limited to mapping scales (25K, 50K), no detailed field surveys evident in sample"
  ],
  "commonPatterns": {
    "dateFields": [
      "_mirrored_at"
    ],
    "statusFields": [
      "mineraloccurrencetype",
      "mineraloccurrencetype_uri"
    ],
    "geometryFields": [
      "_geom",
      "geom"
    ],
    "commodityFields": [
      "commodity",
      "representativecommodity_uri"
    ],
    "identifierFields": [
      "_id",
      "identifier",
      "mine_uri",
      "specification_uri"
    ],
    "measurementFields": [
      "positionalaccuracy"
    ]
  },
  "alternativeTypes": [],
  "primaryFeatureType": {
    "name": "Mineral Occurrence",
    "slug": "mineral_occurrence",
    "reasoning": "This data clearly represents mineral occurrences as indicated by the source name 'NSW Mineral Occurrences' and the presence of fields like 'mineraloccurrencetype_uri', 'commodity', and 'minename'. The data includes both simple occurrences and deposits, which aligns with the existing mineral_occurrence feature type.",
    "attributes": [
      {
        "name": "name",
        "dataType": "TEXT",
        "examples": [
          "Kate",
          "Arrow Park Clay",
          "Unnamed"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Primary name of the mineral occurrence",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "name",
          "minename"
        ]
      },
      {
        "name": "mine_name",
        "dataType": "TEXT",
        "examples": [
          "Kate",
          "UNKNOWN",
          "Unnamed"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Associated mine name if different from occurrence name",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "minename"
        ]
      },
      {
        "name": "primary_commodity",
        "dataType": "TEXT",
        "examples": [
          "silver",
          "aggregate",
          "brick-clay"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Primary commodity or mineral found at this occurrence",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "commodity"
        ]
      },
      {
        "name": "occurrence_type",
        "dataType": "TEXT",
        "required": false,
        "enumValues": [
          "occurrence",
          "deposit"
        ],
        "isGeometry": false,
        "description": "Type of mineral occurrence (occurrence, deposit, etc.)",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "mineraloccurrencetype"
        ]
      },
      {
        "name": "occurrence_type_uri",
        "dataType": "TEXT",
        "examples": [
          "http://resource.geosciml.org/classifier/cgi/mineral-occurrence-type/deposit"
        ],
        "required": false,
        "isGeometry": false,
        "description": "URI reference for the occurrence type classification",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "mineraloccurrencetype_uri"
        ]
      },
      {
        "name": "commodity_uri",
        "dataType": "TEXT",
        "examples": [
          "http://resource.geosciml.org/classifier/cgi/commodity-code/precious-metal"
        ],
        "required": false,
        "isGeometry": false,
        "description": "URI reference for the representative commodity classification",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "representativecommodity_uri"
        ]
      },
      {
        "name": "observation_method",
        "dataType": "TEXT",
        "examples": [
          "50K mapping",
          "25K mapping"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Method used to identify or map the occurrence",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "observationmethod"
        ]
      },
      {
        "name": "positional_accuracy",
        "dataType": "TEXT",
        "examples": [
          "50 metres",
          "200 metres",
          "500 metres"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Accuracy of the spatial location",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "positionalaccuracy"
        ]
      },
      {
        "name": "data_source",
        "dataType": "TEXT",
        "examples": [
          "field checked",
          "company report",
          "documented"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Source of the occurrence information",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "source"
        ]
      },
      {
        "name": "source_id",
        "dataType": "TEXT",
        "examples": [
          "nsw_occ_xe0ndn"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Original identifier from the source system",
        "isIdentifier": true,
        "sourceFieldPatterns": [
          "identifier",
          "_id"
        ]
      },
      {
        "name": "mine_uri",
        "dataType": "TEXT",
        "examples": [
          "http://gs.geoscience.nsw.gov.au/resource/feature/gsnsw/mine/181830"
        ],
        "required": false,
        "isGeometry": false,
        "description": "URI reference to associated mine record",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "mine_uri"
        ]
      },
      {
        "name": "specification_uri",
        "dataType": "TEXT",
        "examples": [
          "http://gs.geoscience.nsw.gov.au/resource/feature/gsnsw/mineraloccurrence/181830"
        ],
        "required": false,
        "isGeometry": false,
        "description": "URI reference to the detailed occurrence specification",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "specification_uri"
        ]
      },
      {
        "name": "jurisdiction",
        "dataType": "TEXT",
        "examples": [
          "NSW"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Administrative jurisdiction (NSW in this case)",
        "isIdentifier": false,
        "sourceFieldPatterns": []
      },
      {
        "name": "country",
        "dataType": "TEXT",
        "examples": [
          "AU"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Country code",
        "isIdentifier": false,
        "sourceFieldPatterns": []
      },
      {
        "name": "geometry",
        "dataType": "GEOMETRY",
        "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 identified, ranging from simple occurrences to developed deposits and mines",
    "geometryType": "POINT"
  }
}

{
  "fields": [
    {
      "name": "_id",
      "type": "string",
      "pattern": "nsw_occ_[a-z0-9]+",
      "nullable": false,
      "description": "Unique identifier for each mineral occurrence record",
      "sampleValues": [
        "nsw_occ_2yrnlx",
        "nsw_occ_w1s6fm",
        "nsw_occ_d54nif"
      ]
    },
    {
      "name": "_geom",
      "type": "geometry",
      "pattern": "POINT\\([0-9.-]+ [0-9.-]+\\)",
      "nullable": false,
      "description": "Point geometry in WKT format representing the location of the mineral occurrence",
      "sampleValues": [
        "POINT(149.965 -32.7983)",
        "POINT(152.5 -29.2408)",
        "POINT(149.737 -33.117)"
      ]
    },
    {
      "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": [
        "silica-gemstone",
        "gold",
        "copper, lead, zinc"
      ],
      "description": "Primary commodity or mineral type found at the occurrence",
      "sampleValues": [
        "silica-gemstone",
        "gold",
        "copper, lead, zinc"
      ]
    },
    {
      "name": "identifier",
      "type": "string",
      "pattern": "http://gs\\.geoscience\\.nsw\\.gov\\.au/resource/feature/gsnsw/erl/mineraloccurrenceview/[0-9]+",
      "nullable": false,
      "description": "HTTP URI identifier for the mineral occurrence in the NSW geological survey system",
      "sampleValues": [
        "http://gs.geoscience.nsw.gov.au/resource/feature/gsnsw/erl/mineraloccurrenceview/103561"
      ]
    },
    {
      "name": "minename",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "Unnamed",
        "Nuggetty Hill Mine"
      ],
      "description": "Name of the mine associated with the occurrence, often 'Unnamed' for prospects",
      "sampleValues": [
        "Unnamed",
        "Nuggetty Hill Mine"
      ]
    },
    {
      "name": "mine_uri",
      "type": "string",
      "pattern": "http://gs\\.geoscience\\.nsw\\.gov\\.au/resource/feature/gsnsw/mine/[0-9]+",
      "nullable": true,
      "description": "HTTP URI identifier for the associated mine, if applicable",
      "sampleValues": [
        null,
        "http://gs.geoscience.nsw.gov.au/resource/feature/gsnsw/mine/104101"
      ]
    },
    {
      "name": "mineraloccurrencetype",
      "type": "string",
      "nullable": true,
      "description": "Type classification of the mineral occurrence (appears to be null in samples)",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "mineraloccurrencetype_uri",
      "type": "string",
      "pattern": "http://resource\\.geosciml\\.org/classifier/cgi/mineral-occurrence-type/(occurrence|deposit)",
      "nullable": false,
      "enumValues": [
        "http://resource.geosciml.org/classifier/cgi/mineral-occurrence-type/occurrence",
        "http://resource.geosciml.org/classifier/cgi/mineral-occurrence-type/deposit"
      ],
      "description": "URI reference to the mineral occurrence type classification",
      "sampleValues": [
        "http://resource.geosciml.org/classifier/cgi/mineral-occurrence-type/occurrence",
        "http://resource.geosciml.org/classifier/cgi/mineral-occurrence-type/deposit"
      ]
    },
    {
      "name": "name",
      "type": "string",
      "nullable": false,
      "description": "Descriptive name of the mineral occurrence or prospect",
      "sampleValues": [
        "Rylstone Amethyst",
        "Taminis gold mine",
        "Nuggetty Hill Mine",
        "Westmead Park Prospect Zone B",
        "Primrose Valley Prospect"
      ]
    },
    {
      "name": "observationmethod",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "250K mapping",
        "25K mapping",
        "GISLYR"
      ],
      "description": "Method used to observe or map the mineral occurrence",
      "sampleValues": [
        "250K mapping",
        "25K mapping",
        "GISLYR"
      ]
    },
    {
      "name": "positionalaccuracy",
      "type": "string",
      "pattern": "[0-9]+ metres",
      "nullable": false,
      "description": "Accuracy of the positional data in metres",
      "sampleValues": [
        "1000 metres",
        "100 metres",
        "250 metres",
        "200 metres"
      ]
    },
    {
      "name": "representativecommodity_uri",
      "type": "string",
      "pattern": "http://resource\\.geosciml\\.org/classifier/cgi/commodity-code/[a-z-]+",
      "nullable": false,
      "description": "URI reference to the representative commodity classification",
      "sampleValues": [
        "http://resource.geosciml.org/classifier/cgi/commodity-code/gemstones",
        "http://resource.geosciml.org/classifier/cgi/commodity-code/precious-metal",
        "http://resource.geosciml.org/classifier/cgi/commodity-code/base-metal"
      ]
    },
    {
      "name": "source",
      "type": "string",
      "nullable": true,
      "enumValues": [
        "publication",
        "company report"
      ],
      "description": "Source of the information about the mineral occurrence",
      "sampleValues": [
        null,
        "publication",
        "company report"
      ]
    },
    {
      "name": "specification_uri",
      "type": "string",
      "pattern": "http://gs\\.geoscience\\.nsw\\.gov\\.au/resource/feature/gsnsw/mineraloccurrence/[0-9]+",
      "nullable": false,
      "description": "URI specification for the mineral occurrence in the NSW geological survey system",
      "sampleValues": [
        "http://gs.geoscience.nsw.gov.au/resource/feature/gsnsw/mineraloccurrence/103561"
      ]
    },
    {
      "name": "_mirrored_at",
      "type": "date",
      "pattern": "YYYY-MM-DD HH:MM:SS.ssssss+TZ",
      "nullable": false,
      "description": "Timestamp when the record was mirrored or last updated",
      "sampleValues": [
        "2026-02-09 19:05:24.693133+00"
      ]
    },
    {
      "name": "geom",
      "type": "geometry",
      "nullable": false,
      "description": "Binary geometry data in PostGIS format (WKB)",
      "sampleValues": [
        "0101000020E61000007B14AE47E1BE6240CA32C4B12E6640C0",
        "0101000020E6100000000000000010634076E09C11A53D3DC0"
      ]
    }
  ],
  "semantics": {
    "idFields": [
      "_id",
      "identifier",
      "mine_uri",
      "specification_uri"
    ],
    "nameFields": [
      "name",
      "minename"
    ],
    "primaryKey": "_id",
    "statusFields": [
      "mineraloccurrencetype",
      "mineraloccurrencetype_uri"
    ],
    "fieldMeanings": {
      "_id": "Primary key identifier",
      "geom": "Binary geometry data",
      "name": "Descriptive occurrence name",
      "_geom": "Human-readable point geometry",
      "source": "Information source type",
      "mine_uri": "Associated mine URI reference",
      "minename": "Associated mine name",
      "commodity": "Primary mineral/commodity type",
      "identifier": "External system identifier URI",
      "_featuretype": "Feature type classification",
      "_mirrored_at": "Data synchronization timestamp",
      "observationmethod": "Data collection method",
      "specification_uri": "Specification URI reference",
      "positionalaccuracy": "Spatial accuracy measurement",
      "mineraloccurrencetype": "Occurrence type classification",
      "mineraloccurrencetype_uri": "Occurrence type URI reference",
      "representativecommodity_uri": "Commodity classification URI"
    },
    "relationships": [
      {
        "field": "mine_uri",
        "relatedTo": "minename",
        "relationshipType": "reference"
      },
      {
        "field": "identifier",
        "relatedTo": "specification_uri",
        "relationshipType": "alternate_identifier"
      },
      {
        "field": "commodity",
        "relatedTo": "representativecommodity_uri",
        "relationshipType": "classification"
      },
      {
        "field": "_geom",
        "relatedTo": "geom",
        "relationshipType": "alternate_format"
      }
    ],
    "geometryFields": [
      "_geom",
      "geom"
    ],
    "commodityFields": [
      "commodity",
      "representativecommodity_uri"
    ]
  },
  "confidence": 0.95,
  "entityType": "mineral_occurrence",
  "recordCount": 100
}

{
  "domain": "mining",
  "qualityNotes": [
    "Many records have null values for mineraloccurrencetype field despite having mineraloccurrencetype_uri",
    "Mine names are often 'Unnamed' or 'Unnamed Pit', indicating incomplete naming data",
    "Source field has many null values, reducing data provenance quality",
    "Positional accuracy varies widely from 25m to 400m, indicating mixed data quality",
    "Duplicate geometry fields (_geom and geom) suggest data processing artifacts",
    "URI fields provide good linkage to external vocabularies and related entities",
    "All records appear to be point locations, consistent with occurrence mapping"
  ],
  "commonPatterns": {
    "dateFields": [
      "_mirrored_at"
    ],
    "statusFields": [
      "mineraloccurrencetype"
    ],
    "geometryFields": [
      "_geom",
      "geom"
    ],
    "commodityFields": [
      "commodity",
      "representativecommodity_uri"
    ],
    "identifierFields": [
      "_id",
      "identifier",
      "mine_uri",
      "specification_uri"
    ],
    "measurementFields": [
      "positionalaccuracy"
    ]
  },
  "alternativeTypes": [],
  "primaryFeatureType": {
    "name": "Mineral Occurrence",
    "slug": "mineral_occurrence",
    "reasoning": "This data clearly represents mineral occurrences as indicated by the source name 'NSW Mineral Occurrences' and the presence of fields like 'mineraloccurrencetype_uri', 'commodity', and 'name'. The data includes both simple occurrences and deposits, with some having associated mine information.",
    "attributes": [
      {
        "name": "name",
        "dataType": "TEXT",
        "examples": [
          "Vorias' Prospect",
          "Crystal shaft",
          "Mundongo Magnesite Deposit"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Primary name of the mineral occurrence",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "name"
        ]
      },
      {
        "name": "mine_name",
        "dataType": "TEXT",
        "examples": [
          "Unnamed Pit",
          "Unnamed"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Associated mine name if applicable",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "minename"
        ]
      },
      {
        "name": "primary_commodity",
        "dataType": "TEXT",
        "examples": [
          "aggregate",
          "gold",
          "tin",
          "magnesite"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Primary commodity or mineral found at this occurrence",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "commodity"
        ]
      },
      {
        "name": "occurrence_type",
        "dataType": "TEXT",
        "required": false,
        "enumValues": [
          "occurrence",
          "deposit"
        ],
        "isGeometry": false,
        "description": "Type of mineral occurrence (occurrence, deposit, etc.)",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "mineraloccurrencetype"
        ]
      },
      {
        "name": "observation_method",
        "dataType": "TEXT",
        "examples": [
          "25K mapping",
          "50K mapping",
          "GISLYR"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Method used to identify/map the occurrence",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "observationmethod"
        ]
      },
      {
        "name": "positional_accuracy",
        "dataType": "TEXT",
        "examples": [
          "25 metres",
          "50 metres",
          "100 metres",
          "200 metres",
          "400 metres"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Accuracy of the spatial location",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "positionalaccuracy"
        ]
      },
      {
        "name": "data_source",
        "dataType": "TEXT",
        "examples": [
          "documented",
          "company report",
          "field checked"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Source of the occurrence information",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "source"
        ]
      },
      {
        "name": "source_id",
        "dataType": "TEXT",
        "required": true,
        "isGeometry": false,
        "description": "Unique identifier from the source system",
        "isIdentifier": true,
        "sourceFieldPatterns": [
          "identifier",
          "_id"
        ]
      },
      {
        "name": "specification_uri",
        "dataType": "TEXT",
        "required": false,
        "isGeometry": false,
        "description": "URI reference to detailed specification",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "specification_uri"
        ]
      },
      {
        "name": "mine_uri",
        "dataType": "TEXT",
        "required": false,
        "isGeometry": false,
        "description": "URI reference to associated mine if applicable",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "mine_uri"
        ]
      },
      {
        "name": "commodity_category_uri",
        "dataType": "TEXT",
        "required": false,
        "isGeometry": false,
        "description": "URI reference to commodity classification",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "representativecommodity_uri"
        ]
      },
      {
        "name": "occurrence_type_uri",
        "dataType": "TEXT",
        "required": false,
        "isGeometry": false,
        "description": "URI reference to occurrence type classification",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "mineraloccurrencetype_uri"
        ]
      },
      {
        "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": [
          "NSW"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Administrative jurisdiction (NSW for this source)",
        "isIdentifier": false,
        "sourceFieldPatterns": []
      },
      {
        "name": "country",
        "dataType": "TEXT",
        "examples": [
          "AU"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Country code",
        "isIdentifier": false,
        "sourceFieldPatterns": []
      }
    ],
    "confidence": 0.95,
    "description": "A documented location where minerals have been identified, ranging from simple occurrences to developed deposits and mines",
    "geometryType": "POINT"
  }
}

{
  "fields": [
    {
      "name": "_id",
      "type": "string",
      "pattern": "nsw_occ_[a-z0-9]+",
      "nullable": false,
      "description": "Unique identifier for each mineral occurrence record",
      "sampleValues": [
        "nsw_occ_fvwt7d",
        "nsw_occ_ccdy6m",
        "nsw_occ_5xt8g1"
      ]
    },
    {
      "name": "_geom",
      "type": "geometry",
      "pattern": "POINT\\([0-9.-]+ [0-9.-]+\\)",
      "nullable": false,
      "description": "Point geometry representing the location of the mineral occurrence",
      "sampleValues": [
        "POINT(152.128 -32.7286)",
        "POINT(148.834 -34.1888)",
        "POINT(152.839 -30.6066)"
      ]
    },
    {
      "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,
      "description": "Primary commodity or mineral type found at the occurrence",
      "sampleValues": [
        "aggregate",
        "copper",
        "aggregate, aggregate, sand",
        "tin",
        "antimony"
      ]
    },
    {
      "name": "identifier",
      "type": "string",
      "pattern": "http://gs\\.geoscience\\.nsw\\.gov\\.au/resource/feature/gsnsw/erl/mineraloccurrenceview/[0-9]+",
      "nullable": false,
      "description": "HTTP URI identifier for the mineral occurrence view resource",
      "sampleValues": [
        "http://gs.geoscience.nsw.gov.au/resource/feature/gsnsw/erl/mineraloccurrenceview/214048"
      ]
    },
    {
      "name": "minename",
      "type": "string",
      "nullable": false,
      "description": "Name of the mine associated with the occurrence",
      "sampleValues": [
        "Unnamed",
        "Wia Ora Crossing, Missabotti"
      ]
    },
    {
      "name": "mine_uri",
      "type": "string",
      "pattern": "http://gs\\.geoscience\\.nsw\\.gov\\.au/resource/feature/gsnsw/mine/[0-9]+",
      "nullable": true,
      "description": "HTTP URI identifier for the associated mine resource",
      "sampleValues": [
        null,
        "http://gs.geoscience.nsw.gov.au/resource/feature/gsnsw/mine/201397"
      ]
    },
    {
      "name": "mineraloccurrencetype",
      "type": "string",
      "nullable": true,
      "description": "Type classification of the mineral occurrence (appears to be null in samples)",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "mineraloccurrencetype_uri",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "http://resource.geosciml.org/classifier/cgi/mineral-occurrence-type/occurrence",
        "http://resource.geosciml.org/classifier/cgi/mineral-occurrence-type/deposit"
      ],
      "description": "HTTP URI for the mineral occurrence type classification",
      "sampleValues": [
        "http://resource.geosciml.org/classifier/cgi/mineral-occurrence-type/occurrence",
        "http://resource.geosciml.org/classifier/cgi/mineral-occurrence-type/deposit"
      ]
    },
    {
      "name": "name",
      "type": "string",
      "nullable": false,
      "description": "Display name of the mineral occurrence or mine",
      "sampleValues": [
        "Unnamed",
        "Federal Copper Mine",
        "Wia Ora Crossing, Missabotti",
        "Woodleys Antimony Mine"
      ]
    },
    {
      "name": "observationmethod",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "25K mapping",
        "GPSA66",
        "250K mapping"
      ],
      "description": "Method used to observe or map the mineral occurrence",
      "sampleValues": [
        "25K mapping",
        "GPSA66",
        "250K mapping"
      ]
    },
    {
      "name": "positionalaccuracy",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "250 metres",
        "50 metres",
        "100 metres"
      ],
      "description": "Accuracy of the positional coordinates",
      "sampleValues": [
        "250 metres",
        "50 metres",
        "100 metres"
      ]
    },
    {
      "name": "representativecommodity_uri",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "http://resource.geosciml.org/classifier/cgi/commodity-code/industrial-material",
        "http://resource.geosciml.org/classifier/cgi/commodity-code/base-metal",
        "http://resource.geosciml.org/classifier/cgi/commodity-code/metal",
        "http://resource.geosciml.org/classifier/cgi/commodity-code/metalloid"
      ],
      "description": "HTTP URI for the representative commodity classification",
      "sampleValues": [
        "http://resource.geosciml.org/classifier/cgi/commodity-code/industrial-material",
        "http://resource.geosciml.org/classifier/cgi/commodity-code/base-metal"
      ]
    },
    {
      "name": "source",
      "type": "string",
      "nullable": true,
      "enumValues": [
        "publication"
      ],
      "description": "Source of the mineral occurrence information",
      "sampleValues": [
        null,
        "publication"
      ]
    },
    {
      "name": "specification_uri",
      "type": "string",
      "pattern": "http://gs\\.geoscience\\.nsw\\.gov\\.au/resource/feature/gsnsw/mineraloccurrence/[0-9]+",
      "nullable": false,
      "description": "HTTP URI identifier for the mineral occurrence specification",
      "sampleValues": [
        "http://gs.geoscience.nsw.gov.au/resource/feature/gsnsw/mineraloccurrence/214048"
      ]
    },
    {
      "name": "_mirrored_at",
      "type": "date",
      "pattern": "YYYY-MM-DD HH:MM:SS.ssssss+TZ",
      "nullable": false,
      "description": "Timestamp when the record was mirrored or last updated",
      "sampleValues": [
        "2026-02-09 19:05:24.693133+00"
      ]
    },
    {
      "name": "geom",
      "type": "geometry",
      "nullable": false,
      "description": "Binary geometry data in hexadecimal format (PostGIS format)",
      "sampleValues": [
        "0101000020E61000006ABC749318046340CCEEC9C3425D40C0",
        "0101000020E6100000A69BC420B09A62400EBE30992A1841C0"
      ]
    }
  ],
  "semantics": {
    "idFields": [
      "_id",
      "identifier",
      "mine_uri",
      "specification_uri"
    ],
    "nameFields": [
      "minename",
      "name"
    ],
    "primaryKey": "_id",
    "statusFields": [
      "observationmethod",
      "source"
    ],
    "fieldMeanings": {
      "_id": "Primary key identifier",
      "geom": "Binary geometry data",
      "name": "Display name",
      "_geom": "Human-readable point geometry",
      "source": "Data source type",
      "mine_uri": "Related mine resource URI",
      "minename": "Mine name",
      "commodity": "Primary mineral/commodity type",
      "identifier": "External system identifier URI",
      "_featuretype": "Feature type classification",
      "_mirrored_at": "Data synchronization timestamp",
      "observationmethod": "Data collection method",
      "specification_uri": "Detailed specification URI",
      "positionalaccuracy": "Coordinate precision",
      "mineraloccurrencetype": "Occurrence type description",
      "mineraloccurrencetype_uri": "Occurrence type classification URI",
      "representativecommodity_uri": "Commodity classification URI"
    },
    "relationships": [
      {
        "field": "mine_uri",
        "relatedTo": "minename",
        "relationshipType": "references"
      },
      {
        "field": "identifier",
        "relatedTo": "specification_uri",
        "relationshipType": "related_resource"
      },
      {
        "field": "commodity",
        "relatedTo": "representativecommodity_uri",
        "relationshipType": "classified_by"
      },
      {
        "field": "_geom",
        "relatedTo": "geom",
        "relationshipType": "duplicate_representation"
      }
    ],
    "geometryFields": [
      "_geom",
      "geom"
    ],
    "commodityFields": [
      "commodity",
      "representativecommodity_uri"
    ]
  },
  "confidence": 0.95,
  "entityType": "mineral_occurrence",
  "recordCount": 100
}