Artifacts

{
  "mappings": [
    {
      "confidence": 0.95,
      "mappingType": "direct",
      "sourceField": "site_title",
      "justification": "site_title contains the full name of the mining site/occurrence and is the most comprehensive name field available",
      "targetAttribute": "name"
    },
    {
      "transform": {
        "type": "expression",
        "expression": "array_construct(short_name)"
      },
      "confidence": 0.8,
      "mappingType": "computed",
      "sourceField": "short_name",
      "justification": "short_name provides an alternative/abbreviated name that should be included in alternate names array",
      "targetAttribute": "alternate_names"
    },
    {
      "transform": {
        "type": "lookup",
        "lookupTable": "site_stage_status_mapping"
      },
      "confidence": 0.85,
      "mappingType": "lookup",
      "sourceField": "site_stage",
      "justification": "site_stage indicates operational status (Proposed, Shut) but needs standardization to match target enum values",
      "targetAttribute": "status"
    },
    {
      "transform": {
        "type": "parse",
        "expression": "split_and_standardize_commodities(site_commo)"
      },
      "confidence": 0.8,
      "mappingType": "computed",
      "sourceField": "site_commo",
      "justification": "site_commo contains commodity abbreviations (Au, Ag, Lst, Sd) that need parsing into standardized element symbols array",
      "targetAttribute": "commodities"
    },
    {
      "confidence": 0.75,
      "mappingType": "inferred",
      "sourceField": "target_com",
      "justification": "target_com describes the main commodity being targeted (GOLD, LIMESTONE) which represents the primary economic interest",
      "targetAttribute": "primary_commodity"
    },
    {
      "transform": {
        "type": "lookup",
        "lookupTable": "mining_method_mapping"
      },
      "confidence": 0.7,
      "mappingType": "lookup",
      "sourceField": "site_sub_t",
      "justification": "site_sub_t contains mining method information (Openpit, Unspecified) but needs standardization",
      "targetAttribute": "mining_method"
    },
    {
      "confidence": 0.95,
      "mappingType": "direct",
      "sourceField": "site_code",
      "justification": "site_code is the unique identifier from the original WA Minedx data source",
      "targetAttribute": "source_id"
    }
  ],
  "featureType": "mineral_occurrence",
  "unmappedFields": [
    "_id",
    "_geom",
    "gmlid",
    "commodity",
    "confidenti",
    "extract_da",
    "gid",
    "latitude",
    "longitude",
    "oid",
    "point_conf",
    "proj_code",
    "proj_title",
    "site_type_",
    "web_link",
    "_mirrored_at",
    "geom"
  ],
  "overallConfidence": 0.82,
  "suggestedAttributes": [
    {
      "name": "project_code",
      "dataType": "TEXT",
      "description": "Associated project identifier from source system"
    },
    {
      "name": "project_title",
      "dataType": "TEXT",
      "description": "Name of the associated exploration or mining project"
    },
    {
      "name": "site_type",
      "dataType": "ENUM",
      "description": "Classification of the site (Mine, Prospect, etc.)"
    },
    {
      "name": "data_source_url",
      "dataType": "TEXT",
      "description": "URL link to detailed information in source system"
    },
    {
      "name": "confidentiality_level",
      "dataType": "ENUM",
      "description": "Data confidentiality classification"
    }
  ]
}

{
  "isValid": false,
  "warnings": [
    "site_type: Found 4 unexpected enum values: Infrastructure, Target, Occurrence, Other",
    "status: Found 2 unexpected enum values: Care and Maintenance, Under Development",
    "commodity_category: Found 5 unexpected enum values: BASE METAL, CONSTRUCTION MATERIAL, STEEL ALLOY METAL, PRECIOUS MINERAL, IRON",
    "geometry: 100% of values don't match expected type GEOMETRY"
  ],
  "sourceSlug": "au_wa_minedex",
  "featureType": "mineral_occurrence",
  "suggestions": [],
  "validatedAt": "2026-02-09T21:50:02.080Z",
  "criticalIssues": [
    "country: No matching field found for patterns: ",
    "jurisdiction: No matching field found for patterns: "
  ],
  "totalAttributes": 19,
  "validAttributes": 13,
  "validationScore": 68,
  "fieldValidations": [
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 47982
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "site_code",
      "totalRecords": 47982,
      "attributeName": "site_code",
      "distinctCount": 47982,
      "sourcePatterns": [
        "site_code",
        "SITE_CODE"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 47982
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "site_title",
      "totalRecords": 47982,
      "attributeName": "name",
      "distinctCount": 47982,
      "sourcePatterns": [
        "site_title",
        "SITE_TITLE",
        "name",
        "title"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 47982
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "short_name",
      "totalRecords": 47982,
      "attributeName": "short_name",
      "distinctCount": 38098,
      "sourcePatterns": [
        "short_name",
        "SHORT_NAME",
        "common_name"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [
        "Found 4 unexpected enum values: Infrastructure, Target, Occurrence, Other"
      ],
      "isValid": false,
      "nullCount": 0,
      "actualEnums": [
        "Deposit",
        "Geological Observation",
        "Infrastructure",
        "Mine",
        "Occurrence",
        "Other",
        "Prospect",
        "Target",
        "Unknown"
      ],
      "actualTypes": {
        "string": 47982
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "site_type_",
      "missingEnums": [],
      "totalRecords": 47982,
      "attributeName": "site_type",
      "distinctCount": 9,
      "expectedEnums": [
        "Mine",
        "Prospect",
        "Deposit"
      ],
      "sourcePatterns": [
        "site_type_",
        "site_type",
        "SITE_TYPE",
        "type"
      ],
      "unexpectedValues": [
        "Infrastructure",
        "Target",
        "Occurrence",
        "Other"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 47982
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "site_sub_t",
      "totalRecords": 47982,
      "attributeName": "site_subtype",
      "distinctCount": 38,
      "sourcePatterns": [
        "site_sub_t",
        "site_subtype",
        "SITE_SUB_T",
        "subtype"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [
        "Found 2 unexpected enum values: Care and Maintenance, Under Development"
      ],
      "isValid": false,
      "nullCount": 0,
      "actualEnums": [
        "Care and Maintenance",
        "Operating",
        "Proposed",
        "Shut",
        "Under Development",
        "Undeveloped"
      ],
      "actualTypes": {
        "string": 47982
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "site_stage",
      "missingEnums": [],
      "totalRecords": 47982,
      "attributeName": "status",
      "distinctCount": 6,
      "expectedEnums": [
        "Operating",
        "Proposed",
        "Undeveloped",
        "Shut"
      ],
      "sourcePatterns": [
        "site_stage",
        "SITE_STAGE",
        "status",
        "stage"
      ],
      "unexpectedValues": [
        "Care and Maintenance",
        "Under Development"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 4,
      "actualTypes": {
        "string": 47978
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "target_com",
      "totalRecords": 47982,
      "attributeName": "primary_commodity",
      "distinctCount": 49,
      "sourcePatterns": [
        "target_com",
        "TARGET_COM",
        "primary_commodity",
        "main_commodity"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [
        "Found 5 unexpected enum values: BASE METAL, CONSTRUCTION MATERIAL, STEEL ALLOY METAL, PRECIOUS MINERAL, IRON"
      ],
      "isValid": false,
      "nullCount": 0,
      "actualEnums": [
        "ALUMINA",
        "BASE METAL",
        "CONSTRUCTION MATERIAL",
        "ENERGY",
        "INDUSTRIAL MINERAL",
        "IRON",
        "OTHER (MINEDEX NON-MINERALS)",
        "PRECIOUS METAL",
        "PRECIOUS MINERAL",
        "SPECIALITY METAL",
        "STEEL ALLOY METAL"
      ],
      "actualTypes": {
        "string": 47982
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "commodity",
      "missingEnums": [],
      "totalRecords": 47982,
      "attributeName": "commodity_category",
      "distinctCount": 11,
      "expectedEnums": [
        "ENERGY",
        "INDUSTRIAL MINERAL",
        "PRECIOUS METAL"
      ],
      "sourcePatterns": [
        "commodity",
        "COMMODITY",
        "commodity_type"
      ],
      "unexpectedValues": [
        "BASE METAL",
        "CONSTRUCTION MATERIAL",
        "STEEL ALLOY METAL",
        "PRECIOUS MINERAL",
        "IRON"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 4,
      "actualTypes": {
        "string": 47978
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "site_commo",
      "totalRecords": 47982,
      "attributeName": "commodities",
      "distinctCount": 1918,
      "sourcePatterns": [
        "site_commo",
        "SITE_COMMO",
        "commodities",
        "minerals"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 5774,
      "actualTypes": {
        "string": 42208
      },
      "nullPercent": 12,
      "expectedType": "TEXT",
      "matchedField": "proj_code",
      "totalRecords": 47982,
      "attributeName": "project_code",
      "distinctCount": 4795,
      "sourcePatterns": [
        "proj_code",
        "PROJ_CODE",
        "project_code"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 5774,
      "actualTypes": {
        "string": 42208
      },
      "nullPercent": 12,
      "expectedType": "TEXT",
      "matchedField": "proj_title",
      "totalRecords": 47982,
      "attributeName": "project_name",
      "distinctCount": 4795,
      "sourcePatterns": [
        "proj_title",
        "PROJ_TITLE",
        "project_name",
        "project_title"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 47982
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "web_link",
      "totalRecords": 47982,
      "attributeName": "source_url",
      "distinctCount": 47982,
      "sourcePatterns": [
        "web_link",
        "WEB_LINK",
        "url",
        "link"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 47982
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "oid",
      "totalRecords": 47982,
      "attributeName": "source_id",
      "distinctCount": 47982,
      "sourcePatterns": [
        "oid",
        "OID",
        "gid",
        "GID",
        "source_id"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 47982
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "gmlid",
      "totalRecords": 47982,
      "attributeName": "gml_id",
      "distinctCount": 47982,
      "sourcePatterns": [
        "gmlid",
        "GMLID",
        "gml_id"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualEnums": [
        "Public"
      ],
      "actualTypes": {
        "string": 47982
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "confidenti",
      "missingEnums": [],
      "totalRecords": 47982,
      "attributeName": "confidentiality",
      "distinctCount": 1,
      "expectedEnums": [
        "Public"
      ],
      "sourcePatterns": [
        "confidenti",
        "CONFIDENTI",
        "point_conf",
        "confidentiality"
      ],
      "unexpectedValues": [],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 47982
      },
      "nullPercent": 0,
      "expectedType": "DATE",
      "matchedField": "extract_da",
      "totalRecords": 47982,
      "attributeName": "extract_date",
      "distinctCount": 1,
      "sourcePatterns": [
        "extract_da",
        "EXTRACT_DA",
        "extract_date"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [
        "No matching field found for patterns: "
      ],
      "isValid": false,
      "nullCount": 47982,
      "actualTypes": {},
      "nullPercent": 100,
      "expectedType": "TEXT",
      "matchedField": null,
      "totalRecords": 47982,
      "attributeName": "country",
      "distinctCount": 0,
      "sourcePatterns": [],
      "typeMismatchPercent": 100
    },
    {
      "issues": [
        "No matching field found for patterns: "
      ],
      "isValid": false,
      "nullCount": 47982,
      "actualTypes": {},
      "nullPercent": 100,
      "expectedType": "TEXT",
      "matchedField": null,
      "totalRecords": 47982,
      "attributeName": "jurisdiction",
      "distinctCount": 0,
      "sourcePatterns": [],
      "typeMismatchPercent": 100
    },
    {
      "issues": [
        "100% of values don't match expected type GEOMETRY"
      ],
      "isValid": false,
      "nullCount": 0,
      "actualTypes": {
        "string": 47982
      },
      "nullPercent": 0,
      "expectedType": "GEOMETRY",
      "matchedField": "_geom",
      "sampleIssues": [
        "POINT(115.97855344 -32.53307547)",
        "POINT(117.80643758 -28.0872805)",
        "POINT(120.90047147 -30.85779248)",
        "POINT(119.86588048 -21.32197954)",
        "POINT(118.80763271 -28.83662667)"
      ],
      "totalRecords": 47982,
      "attributeName": "geometry",
      "distinctCount": 43032,
      "sourcePatterns": [
        "_geom",
        "geom",
        "GEOM",
        "geometry"
      ],
      "typeMismatchPercent": 100
    }
  ],
  "recordsValidated": 47982,
  "attributesWithIssues": 6
}

{
  "domain": "mining",
  "qualityNotes": [
    "Some project codes and titles are null, indicating not all sites are associated with projects",
    "Extract date format appears inconsistent (2/5/2026 format)",
    "Commodity abbreviations in site_commo field may need standardization (e.g., 'Sisd, Sd' for silica sand)",
    "Geometry is provided in both WKT (_geom) and binary (geom) formats, plus separate lat/lon fields",
    "All records show 'Public' confidentiality - may indicate filtered dataset",
    "Site subtypes include 'Unspecified' which may indicate incomplete classification"
  ],
  "commonPatterns": {
    "dateFields": [
      "extract_da",
      "_mirrored_at"
    ],
    "statusFields": [
      "site_stage",
      "confidenti",
      "point_conf"
    ],
    "geometryFields": [
      "_geom",
      "geom",
      "latitude",
      "longitude"
    ],
    "commodityFields": [
      "commodity",
      "target_com",
      "site_commo"
    ],
    "identifierFields": [
      "_id",
      "gmlid",
      "gid",
      "oid",
      "proj_code",
      "site_code"
    ],
    "measurementFields": []
  },
  "alternativeTypes": [],
  "primaryFeatureType": {
    "name": "Mineral Occurrence",
    "slug": "mineral_occurrence",
    "reasoning": "This data represents mineral sites from Western Australia's Minedex database. The records include mines, prospects, and deposits with specific commodities, stages of development, and site types. This clearly maps to the mineral_occurrence feature type.",
    "attributes": [
      {
        "name": "site_code",
        "dataType": "TEXT",
        "examples": [
          "S0226042",
          "S0231718",
          "S0016093"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Unique site identifier from Minedex database",
        "isIdentifier": true,
        "sourceFieldPatterns": [
          "site_code",
          "SITE_CODE"
        ]
      },
      {
        "name": "name",
        "dataType": "TEXT",
        "examples": [
          "Kintyre Openpit",
          "Lake Waukarlycarly (Karly) Potash",
          "Frasers South Gold Mining Company (77)"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Full name/title of the mineral site",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "site_title",
          "SITE_TITLE",
          "name",
          "title"
        ]
      },
      {
        "name": "short_name",
        "dataType": "TEXT",
        "examples": [
          "Kintyre Openpit",
          "Lake Waukarlycarly",
          "Frasers South"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Short or common name of the site",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "short_name",
          "SHORT_NAME",
          "common_name"
        ]
      },
      {
        "name": "site_type",
        "dataType": "TEXT",
        "examples": [
          "Mine",
          "Prospect",
          "Deposit"
        ],
        "required": true,
        "enumValues": [
          "Mine",
          "Prospect",
          "Deposit"
        ],
        "isGeometry": false,
        "description": "Type of mineral site (Mine, Prospect, Deposit)",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "site_type_",
          "site_type",
          "SITE_TYPE",
          "type"
        ]
      },
      {
        "name": "site_subtype",
        "dataType": "TEXT",
        "examples": [
          "Openpit",
          "Drillhole",
          "Unspecified"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Subtype or method of extraction (Openpit, Drillhole, Unspecified)",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "site_sub_t",
          "site_subtype",
          "SITE_SUB_T",
          "subtype"
        ]
      },
      {
        "name": "status",
        "dataType": "TEXT",
        "examples": [
          "Proposed",
          "Undeveloped",
          "Shut",
          "Operating"
        ],
        "required": true,
        "enumValues": [
          "Operating",
          "Proposed",
          "Undeveloped",
          "Shut"
        ],
        "isGeometry": false,
        "description": "Current operational status of the site",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "site_stage",
          "SITE_STAGE",
          "status",
          "stage"
        ]
      },
      {
        "name": "primary_commodity",
        "dataType": "TEXT",
        "examples": [
          "URANIUM",
          "POTASH",
          "GOLD",
          "SILICA - SILICA SAND"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Primary target commodity category",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "target_com",
          "TARGET_COM",
          "primary_commodity",
          "main_commodity"
        ]
      },
      {
        "name": "commodity_category",
        "dataType": "TEXT",
        "examples": [
          "ENERGY",
          "INDUSTRIAL MINERAL",
          "PRECIOUS METAL"
        ],
        "required": false,
        "enumValues": [
          "ENERGY",
          "INDUSTRIAL MINERAL",
          "PRECIOUS METAL"
        ],
        "isGeometry": false,
        "description": "Broad commodity category",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "commodity",
          "COMMODITY",
          "commodity_type"
        ]
      },
      {
        "name": "commodities",
        "dataType": "TEXT",
        "examples": [
          "U",
          "K, K2SO4, Salt",
          "Au",
          "Au, Ag",
          "Sisd, Sd"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Specific commodities present at the site",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "site_commo",
          "SITE_COMMO",
          "commodities",
          "minerals"
        ]
      },
      {
        "name": "project_code",
        "dataType": "TEXT",
        "examples": [
          "J00383",
          "J03547",
          "J04807",
          "J01107"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Associated project code",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "proj_code",
          "PROJ_CODE",
          "project_code"
        ]
      },
      {
        "name": "project_name",
        "dataType": "TEXT",
        "examples": [
          "Kintyre",
          "Historic Gold - Yilgarn (77)",
          "Bustler Well / Macdonald"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Name of the associated project",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "proj_title",
          "PROJ_TITLE",
          "project_name",
          "project_title"
        ]
      },
      {
        "name": "source_url",
        "dataType": "TEXT",
        "examples": [
          "https://minedex.dmirs.wa.gov.au/Web/common/jump.jsp?jumpType=SITE&id=S0226042"
        ],
        "required": false,
        "isGeometry": false,
        "description": "URL to detailed information in source system",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "web_link",
          "WEB_LINK",
          "url",
          "link"
        ]
      },
      {
        "name": "source_id",
        "dataType": "TEXT",
        "examples": [
          "32301",
          "34804",
          "14551",
          "2242"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Original identifier from source system",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "oid",
          "OID",
          "gid",
          "GID",
          "source_id"
        ]
      },
      {
        "name": "gml_id",
        "dataType": "TEXT",
        "examples": [
          "Minedex__DMIRS-001_.32301"
        ],
        "required": false,
        "isGeometry": false,
        "description": "GML identifier from source system",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "gmlid",
          "GMLID",
          "gml_id"
        ]
      },
      {
        "name": "confidentiality",
        "dataType": "TEXT",
        "examples": [
          "Public"
        ],
        "required": false,
        "enumValues": [
          "Public"
        ],
        "isGeometry": false,
        "description": "Data confidentiality level",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "confidenti",
          "CONFIDENTI",
          "point_conf",
          "confidentiality"
        ]
      },
      {
        "name": "extract_date",
        "dataType": "DATE",
        "examples": [
          "2/5/2026"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Date when data was extracted from source system",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "extract_da",
          "EXTRACT_DA",
          "extract_date"
        ]
      },
      {
        "name": "country",
        "dataType": "TEXT",
        "examples": [
          "Australia"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Country where the site is located",
        "isIdentifier": false,
        "sourceFieldPatterns": []
      },
      {
        "name": "jurisdiction",
        "dataType": "TEXT",
        "examples": [
          "Western Australia"
        ],
        "required": true,
        "isGeometry": false,
        "description": "State/territory jurisdiction",
        "isIdentifier": false,
        "sourceFieldPatterns": []
      },
      {
        "name": "geometry",
        "dataType": "GEOMETRY",
        "required": true,
        "isGeometry": true,
        "description": "Point location of the mineral site",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "_geom",
          "geom",
          "GEOM",
          "geometry"
        ]
      }
    ],
    "confidence": 0.95,
    "description": "A location where minerals have been found, including mines, prospects, deposits, and other mineral sites",
    "geometryType": "POINT"
  }
}

{
  "fields": [
    {
      "name": "_id",
      "type": "string",
      "pattern": "wa_minedex_[a-z0-9]+",
      "nullable": false,
      "description": "Unique identifier for each record",
      "sampleValues": [
        "wa_minedex_vkt8b0",
        "wa_minedx_xbvlzn",
        "wa_minedx_37dxjn"
      ]
    },
    {
      "name": "_geom",
      "type": "geometry",
      "pattern": "POINT\\([0-9.-]+ [0-9.-]+\\)",
      "nullable": false,
      "description": "Point geometry in WKT format",
      "sampleValues": [
        "POINT(115.80130024 -32.2220615)",
        "POINT(121.31980089 -28.62947091)"
      ]
    },
    {
      "name": "gmlid",
      "type": "string",
      "pattern": "Minedx__DMIRS-001_\\.[0-9]+",
      "nullable": false,
      "description": "GML identifier for the feature",
      "sampleValues": [
        "Minedx__DMIRS-001_.17317",
        "Minedx__DMIRS-001_.10152"
      ]
    },
    {
      "name": "commodity",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "CONSTRUCTION MATERIAL",
        "PRECIOUS METAL"
      ],
      "description": "Primary commodity category",
      "sampleValues": [
        "CONSTRUCTION MATERIAL",
        "PRECIOUS METAL"
      ]
    },
    {
      "name": "confidenti",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "Public"
      ],
      "description": "Confidentiality level of the data",
      "sampleValues": [
        "Public"
      ]
    },
    {
      "name": "extract_da",
      "type": "string",
      "pattern": "\\d{1,2}/\\d{1,2}/\\d{4}",
      "nullable": false,
      "description": "Data extraction date",
      "sampleValues": [
        "2/5/2026"
      ]
    },
    {
      "name": "gid",
      "type": "string",
      "nullable": false,
      "description": "Geographic identifier",
      "sampleValues": [
        "4180704",
        "4173595",
        "4178038"
      ]
    },
    {
      "name": "latitude",
      "type": "string",
      "nullable": false,
      "description": "Latitude coordinate as string",
      "sampleValues": [
        "-32.222048",
        "-28.629457",
        "-31.678605"
      ]
    },
    {
      "name": "longitude",
      "type": "string",
      "nullable": false,
      "description": "Longitude coordinate as string",
      "sampleValues": [
        "115.801311",
        "121.319813",
        "119.564607"
      ]
    },
    {
      "name": "oid",
      "type": "string",
      "nullable": false,
      "description": "Object identifier",
      "sampleValues": [
        "17317",
        "10152",
        "14595"
      ]
    },
    {
      "name": "point_conf",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "Public"
      ],
      "description": "Point confidence level",
      "sampleValues": [
        "Public"
      ]
    },
    {
      "name": "proj_code",
      "type": "string",
      "pattern": "J[0-9]+",
      "nullable": false,
      "description": "Project code identifier",
      "sampleValues": [
        "J01602",
        "J03532",
        "J03547"
      ]
    },
    {
      "name": "proj_title",
      "type": "string",
      "nullable": false,
      "description": "Project title or name",
      "sampleValues": [
        "Postans - Abercrombie Rd / WA Limestone",
        "Historic Gold - Mt Malcolm (37)"
      ]
    },
    {
      "name": "short_name",
      "type": "string",
      "nullable": false,
      "description": "Short name or alias for the site",
      "sampleValues": [
        "Rubbish Tip Rd",
        "Ivy",
        "Good Brothers"
      ]
    },
    {
      "name": "site_code",
      "type": "string",
      "pattern": "S[0-9]+",
      "nullable": false,
      "description": "Site code identifier",
      "sampleValues": [
        "S0019093",
        "S0011690",
        "S0016137"
      ]
    },
    {
      "name": "site_commo",
      "type": "string",
      "nullable": false,
      "description": "Site commodity abbreviations",
      "sampleValues": [
        "Lst, Sd",
        "Au",
        "Au, Ag"
      ]
    },
    {
      "name": "site_stage",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "Proposed",
        "Shut"
      ],
      "description": "Current stage or status of the site",
      "sampleValues": [
        "Proposed",
        "Shut"
      ]
    },
    {
      "name": "site_sub_t",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "Openpit",
        "Unspecified"
      ],
      "description": "Site subtype or mining method",
      "sampleValues": [
        "Openpit",
        "Unspecified"
      ]
    },
    {
      "name": "site_title",
      "type": "string",
      "nullable": false,
      "description": "Full title or name of the site",
      "sampleValues": [
        "Postans - Rubbish Tip Road",
        "Ivy (37)",
        "Good Brothers (77)"
      ]
    },
    {
      "name": "site_type_",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "Mine"
      ],
      "description": "Type of mining site",
      "sampleValues": [
        "Mine"
      ]
    },
    {
      "name": "target_com",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "LIMESTONE - LIMESAND",
        "GOLD"
      ],
      "description": "Target commodity being mined",
      "sampleValues": [
        "LIMESTONE - LIMESAND",
        "GOLD"
      ]
    },
    {
      "name": "web_link",
      "type": "string",
      "pattern": "https://minedx\\.dmirs\\.wa\\.gov\\.au/Web/common/jump\\.jsp\\?jumpType=SITE&id=S[0-9]+",
      "nullable": false,
      "description": "URL link to detailed information",
      "sampleValues": [
        "https://minedx.dmirs.wa.gov.au/Web/common/jump.jsp?jumpType=SITE&id=S0019093"
      ]
    },
    {
      "name": "_mirrored_at",
      "type": "string",
      "pattern": "\\d{4}-\\d{2}-\\d{2} \\d{2}:\\d{2}:\\d{2}\\.\\d+\\+\\d{2}",
      "nullable": false,
      "description": "Timestamp when data was mirrored",
      "sampleValues": [
        "2026-02-09 19:05:59.414658+00"
      ]
    },
    {
      "name": "geom",
      "type": "geometry",
      "nullable": false,
      "description": "Binary geometry representation (PostGIS format)",
      "sampleValues": [
        "0101000020E6100000ED44CD8048F35C40B119E0826C1C40C0"
      ]
    }
  ],
  "semantics": {
    "idFields": [
      "_id",
      "gmlid",
      "gid",
      "oid",
      "proj_code",
      "site_code"
    ],
    "nameFields": [
      "proj_title",
      "short_name",
      "site_title"
    ],
    "primaryKey": "_id",
    "statusFields": [
      "site_stage",
      "confidenti",
      "point_conf"
    ],
    "fieldMeanings": {
      "_id": "Primary key identifier",
      "gid": "Geographic identifier",
      "oid": "Object identifier",
      "geom": "Binary geometry data",
      "_geom": "Point geometry in WKT format",
      "gmlid": "GML feature identifier",
      "latitude": "Latitude coordinate",
      "web_link": "Reference URL",
      "commodity": "Primary commodity category",
      "longitude": "Longitude coordinate",
      "proj_code": "Project code",
      "site_code": "Site identifier code",
      "confidenti": "Data confidentiality level",
      "extract_da": "Data extraction date",
      "point_conf": "Point location confidence",
      "proj_title": "Project name",
      "short_name": "Site short name",
      "site_commo": "Site commodity codes",
      "site_stage": "Site operational status",
      "site_sub_t": "Mining method subtype",
      "site_title": "Full site name",
      "site_type_": "Site type classification",
      "target_com": "Target commodity description",
      "_mirrored_at": "Data synchronization timestamp"
    },
    "relationships": [
      {
        "field": "site_code",
        "relatedTo": "web_link",
        "relationshipType": "reference_link"
      },
      {
        "field": "_geom",
        "relatedTo": "geom",
        "relationshipType": "geometry_duplicate"
      },
      {
        "field": "latitude",
        "relatedTo": "_geom",
        "relationshipType": "coordinate_component"
      },
      {
        "field": "longitude",
        "relatedTo": "_geom",
        "relationshipType": "coordinate_component"
      },
      {
        "field": "commodity",
        "relatedTo": "target_com",
        "relationshipType": "commodity_hierarchy"
      }
    ],
    "geometryFields": [
      "_geom",
      "geom",
      "latitude",
      "longitude"
    ],
    "commodityFields": [
      "commodity",
      "site_commo",
      "target_com"
    ]
  },
  "confidence": 0.95,
  "entityType": "mine_site",
  "recordCount": 100
}

{
  "domain": "mining",
  "qualityNotes": [
    "Date format in extract_da field appears inconsistent (2/5/2026 suggests future dates, likely a data entry error)",
    "Some records have null values for project-related fields (proj_code, proj_title)",
    "Coordinate precision varies between latitude/longitude text fields and geometry fields",
    "Commodity information is spread across multiple fields (commodity, site_commo, target_com) with different classification schemes",
    "Site subtype field (site_sub_t) has 'Unspecified' values indicating incomplete classification",
    "Confidence/access level fields (confidenti, point_conf) appear to be consistently 'Public' but serve unclear purpose"
  ],
  "commonPatterns": {
    "dateFields": [
      "extract_da",
      "_mirrored_at"
    ],
    "statusFields": [
      "site_stage",
      "confidenti",
      "point_conf"
    ],
    "geometryFields": [
      "_geom",
      "geom",
      "latitude",
      "longitude"
    ],
    "commodityFields": [
      "commodity",
      "site_commo",
      "target_com"
    ],
    "identifierFields": [
      "_id",
      "gmlid",
      "gid",
      "oid",
      "proj_code",
      "site_code"
    ],
    "measurementFields": []
  },
  "alternativeTypes": [
    {
      "name": "Mineral Occurrence",
      "slug": "mineral_occurrence",
      "reasoning": "While the data contains commodity information, the presence of operational status, site types like 'Infrastructure' and 'Power Plant', and site stages like 'Operating' clearly indicate these are mining facilities rather than geological occurrences",
      "attributes": [
        {
          "name": "name",
          "dataType": "TEXT",
          "required": true,
          "isGeometry": false,
          "description": "Name of the occurrence",
          "isIdentifier": false,
          "sourceFieldPatterns": [
            "site_title",
            "short_name"
          ]
        },
        {
          "name": "commodities",
          "dataType": "TEXT",
          "required": false,
          "isGeometry": false,
          "description": "Commodities present",
          "isIdentifier": false,
          "sourceFieldPatterns": [
            "site_commo",
            "commodity"
          ]
        }
      ],
      "confidence": 0.3,
      "description": "Could be interpreted as mineral occurrences if focusing on the geological aspect",
      "geometryType": "POINT"
    }
  ],
  "primaryFeatureType": {
    "name": "Mine Site",
    "slug": "mine_site",
    "reasoning": "The data clearly represents mining sites and related facilities. The site_type_ field contains values like 'Mine' and 'Infrastructure', site_sub_t includes 'Openpit', 'Borrow Pit', 'Power Plant', and site_stage indicates operational status. This is distinct from mineral occurrences (which are geological features) and represents actual mining operations or facilities.",
    "attributes": [
      {
        "name": "site_code",
        "dataType": "TEXT",
        "examples": [
          "S0240764",
          "S0230775",
          "S0230783"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Official site identifier code from the mining authority",
        "isIdentifier": true,
        "sourceFieldPatterns": [
          "site_code",
          "site_id",
          "mine_code"
        ]
      },
      {
        "name": "name",
        "dataType": "TEXT",
        "examples": [
          "Pilbara Energy Generation North Star Junction Solar Farm",
          "Oldfield Borrow Pit 3",
          "Lyndon borrow pit 1"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Full official name of the mining site",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "site_title",
          "name",
          "mine_name",
          "site_name"
        ]
      },
      {
        "name": "short_name",
        "dataType": "TEXT",
        "examples": [
          "Pilbara Energy North Star Junction Solar",
          "Oldfield Pit 3",
          "Lyndon borrow pit 1"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Abbreviated or common name of the site",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "short_name",
          "common_name",
          "alias"
        ]
      },
      {
        "name": "site_type",
        "dataType": "TEXT",
        "examples": [
          "Mine",
          "Infrastructure"
        ],
        "required": true,
        "enumValues": [
          "Mine",
          "Infrastructure"
        ],
        "isGeometry": false,
        "description": "Primary classification of the site",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "site_type_",
          "site_type",
          "facility_type",
          "mine_type"
        ]
      },
      {
        "name": "site_subtype",
        "dataType": "TEXT",
        "examples": [
          "Power Plant",
          "Borrow Pit",
          "Openpit"
        ],
        "required": false,
        "enumValues": [
          "Openpit",
          "Borrow Pit",
          "Power Plant",
          "Unspecified"
        ],
        "isGeometry": false,
        "description": "Detailed subclassification of the site",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "site_sub_t",
          "site_subtype",
          "working_type",
          "facility_subtype"
        ]
      },
      {
        "name": "status",
        "dataType": "TEXT",
        "examples": [
          "Operating",
          "Care and Maintenance",
          "Shut"
        ],
        "required": true,
        "enumValues": [
          "Operating",
          "Care and Maintenance",
          "Shut"
        ],
        "isGeometry": false,
        "description": "Current operational status of the site",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "site_stage",
          "status",
          "operational_status"
        ]
      },
      {
        "name": "primary_commodity",
        "dataType": "TEXT",
        "examples": [
          "ENERGY",
          "CONSTRUCTION MATERIAL",
          "STEEL ALLOY METAL"
        ],
        "required": false,
        "enumValues": [
          "ENERGY",
          "CONSTRUCTION MATERIAL",
          "STEEL ALLOY METAL"
        ],
        "isGeometry": false,
        "description": "Primary commodity category for the site",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "commodity",
          "primary_commodity",
          "main_commodity"
        ]
      },
      {
        "name": "commodities",
        "dataType": "TEXT",
        "examples": [
          "Power, Fe, Mag",
          "Lst",
          "Agg, RoadMetal, Gran",
          "W"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Specific commodities or materials extracted/processed",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "site_commo",
          "commodities",
          "materials",
          "minerals"
        ]
      },
      {
        "name": "target_commodity",
        "dataType": "TEXT",
        "examples": [
          "OTHER",
          "LIMESTONE - LIMESAND",
          "CONSTRUCTION MATERIALS",
          "TUNGSTEN - MOLYBDENUM"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Target commodity classification",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "target_com",
          "target_commodity",
          "commodity_target"
        ]
      },
      {
        "name": "project_code",
        "dataType": "TEXT",
        "examples": [
          "J06545",
          "J02557"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Associated project identifier",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "proj_code",
          "project_code",
          "project_id"
        ]
      },
      {
        "name": "project_name",
        "dataType": "TEXT",
        "examples": [
          "Pilbara Energy Generation Project",
          "Historic Tungsten - Molybdenum and Sundry Claims(General locations only)"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Name of the associated project",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "proj_title",
          "project_name",
          "project_title"
        ]
      },
      {
        "name": "latitude",
        "dataType": "FLOAT",
        "examples": [
          "-21.241886",
          "-33.912279",
          "-23.724268"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Latitude coordinate in decimal degrees",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "latitude",
          "lat",
          "y"
        ]
      },
      {
        "name": "longitude",
        "dataType": "FLOAT",
        "examples": [
          "118.81651",
          "120.55018",
          "115.400815"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Longitude coordinate in decimal degrees",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "longitude",
          "lon",
          "lng",
          "x"
        ]
      },
      {
        "name": "geometry",
        "dataType": "GEOMETRY",
        "required": true,
        "isGeometry": true,
        "description": "Point geometry of the site location",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "_geom",
          "geom",
          "geometry",
          "the_geom"
        ]
      },
      {
        "name": "confidence_level",
        "dataType": "TEXT",
        "examples": [
          "Public"
        ],
        "required": false,
        "enumValues": [
          "Public"
        ],
        "isGeometry": false,
        "description": "Data confidence or access level",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "confidenti",
          "point_conf",
          "confidence",
          "access_level"
        ]
      },
      {
        "name": "source_url",
        "dataType": "TEXT",
        "examples": [
          "https://minedex.dmirs.wa.gov.au/Web/common/jump.jsp?jumpType=SITE&id=S0240764"
        ],
        "required": false,
        "isGeometry": false,
        "description": "URL to detailed information about the site",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "web_link",
          "url",
          "link",
          "source_url"
        ]
      },
      {
        "name": "source_id",
        "dataType": "TEXT",
        "examples": [
          "42585",
          "33913",
          "33921"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Original identifier from the source system",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "oid",
          "gid",
          "source_id",
          "original_id"
        ]
      },
      {
        "name": "gml_id",
        "dataType": "TEXT",
        "examples": [
          "Minedex__DMIRS-001_.42585"
        ],
        "required": false,
        "isGeometry": false,
        "description": "GML identifier for the feature",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "gmlid",
          "gml_id"
        ]
      },
      {
        "name": "extract_date",
        "dataType": "DATE",
        "examples": [
          "2/5/2026"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Date when the data was extracted from the source system",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "extract_da",
          "extract_date",
          "extraction_date"
        ]
      }
    ],
    "confidence": 0.95,
    "description": "A mining site or facility including operational mines, historical mines, quarries, borrow pits, and mining-related infrastructure",
    "geometryType": "POINT"
  }
}

{
  "fields": [
    {
      "name": "_id",
      "type": "string",
      "nullable": false,
      "description": "Internal unique identifier with prefix 'wa_minedex_'",
      "sampleValues": [
        "wa_minedex_qafq2w",
        "wa_minedx_b6d765",
        "wa_minedx_df2r1p"
      ]
    },
    {
      "name": "_geom",
      "type": "geometry",
      "nullable": false,
      "description": "Point geometry in WKT format with longitude/latitude coordinates",
      "sampleValues": [
        "POINT(127.69645012 -18.16553962)",
        "POINT(119.28488817 -21.54548258)"
      ]
    },
    {
      "name": "gmlid",
      "type": "string",
      "pattern": "Minedx__DMIRS-001_\\.\\d+",
      "nullable": false,
      "description": "GML identifier with pattern 'Minedx__DMIRS-001_.<number>'",
      "sampleValues": [
        "Minedx__DMIRS-001_.24401",
        "Minedx__DMIRS-001_.42286"
      ]
    },
    {
      "name": "commodity",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "BASE METAL",
        "IRON",
        "PRECIOUS METAL",
        "CONSTRUCTION MATERIAL"
      ],
      "description": "Primary commodity category",
      "sampleValues": [
        "BASE METAL",
        "IRON",
        "PRECIOUS METAL",
        "CONSTRUCTION MATERIAL"
      ]
    },
    {
      "name": "confidenti",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "Public"
      ],
      "description": "Confidentiality level of the record",
      "sampleValues": [
        "Public"
      ]
    },
    {
      "name": "extract_da",
      "type": "string",
      "pattern": "\\d{1,2}/\\d{1,2}/\\d{4}",
      "nullable": false,
      "description": "Data extraction date in M/D/YYYY format",
      "sampleValues": [
        "2/5/2026"
      ]
    },
    {
      "name": "gid",
      "type": "string",
      "nullable": false,
      "description": "Geographic identifier as string",
      "sampleValues": [
        "4187684",
        "4204557",
        "4200808"
      ]
    },
    {
      "name": "latitude",
      "type": "string",
      "nullable": false,
      "description": "Latitude coordinate as string",
      "sampleValues": [
        "-18.165526",
        "-21.545469",
        "-29.543908"
      ]
    },
    {
      "name": "longitude",
      "type": "string",
      "nullable": false,
      "description": "Longitude coordinate as string",
      "sampleValues": [
        "127.696459",
        "119.284898",
        "122.544402"
      ]
    },
    {
      "name": "oid",
      "type": "string",
      "nullable": false,
      "description": "Object identifier as string",
      "sampleValues": [
        "24401",
        "42286",
        "38353"
      ]
    },
    {
      "name": "point_conf",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "Public"
      ],
      "description": "Point confidence level",
      "sampleValues": [
        "Public"
      ]
    },
    {
      "name": "proj_code",
      "type": "string",
      "pattern": "J\\d+",
      "nullable": false,
      "description": "Project code with pattern J followed by digits",
      "sampleValues": [
        "J05584",
        "J03641",
        "J04020"
      ]
    },
    {
      "name": "proj_title",
      "type": "string",
      "nullable": false,
      "description": "Project title or name",
      "sampleValues": [
        "Halls Creek Base Metals",
        "Mt Webber",
        "Deep South - Safari Bore"
      ]
    },
    {
      "name": "short_name",
      "type": "string",
      "nullable": false,
      "description": "Short descriptive name of the site",
      "sampleValues": [
        "Elvire Gossan",
        "Processing Plant",
        "Administration and Workshop"
      ]
    },
    {
      "name": "site_code",
      "type": "string",
      "pattern": "S\\d+",
      "nullable": false,
      "description": "Site identifier code with pattern S followed by digits",
      "sampleValues": [
        "S0027632",
        "S0240417",
        "S0235821"
      ]
    },
    {
      "name": "site_commo",
      "type": "string",
      "nullable": false,
      "description": "Site commodities as comma-separated chemical symbols",
      "sampleValues": [
        "Pb, Zn, Cu, As, Au",
        "Fe",
        "Au, Ag"
      ]
    },
    {
      "name": "site_stage",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "Undeveloped",
        "Operating",
        "Shut",
        "Proposed"
      ],
      "description": "Current operational stage of the site",
      "sampleValues": [
        "Undeveloped",
        "Operating",
        "Shut",
        "Proposed"
      ]
    },
    {
      "name": "site_sub_t",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "Unspecified",
        "Processing Plant",
        "Building",
        "Scraping-Detecting area",
        "Openpit"
      ],
      "description": "Site subtype classification",
      "sampleValues": [
        "Unspecified",
        "Processing Plant",
        "Building",
        "Scraping-Detecting area",
        "Openpit"
      ]
    },
    {
      "name": "site_title",
      "type": "string",
      "nullable": false,
      "description": "Full title or name of the site",
      "sampleValues": [
        "Elvire Gossan",
        "Mt Webber Processing Plant",
        "Deep South Administration and Workshop"
      ]
    },
    {
      "name": "site_type_",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "Occurrence",
        "Infrastructure",
        "Mine"
      ],
      "description": "Primary site type classification",
      "sampleValues": [
        "Occurrence",
        "Infrastructure",
        "Mine"
      ]
    },
    {
      "name": "target_com",
      "type": "string",
      "nullable": false,
      "description": "Target commodity in uppercase format",
      "sampleValues": [
        "COPPER - LEAD - ZINC",
        "IRON ORE",
        "GOLD",
        "CONSTRUCTION MATERIALS"
      ]
    },
    {
      "name": "web_link",
      "type": "string",
      "pattern": "https://minedx\\.dmirs\\.wa\\.gov\\.au/Web/common/jump\\.jsp\\?jumpType=SITE&id=S\\d+",
      "nullable": false,
      "description": "URL link to detailed information on DMIRS website",
      "sampleValues": [
        "https://minedx.dmirs.wa.gov.au/Web/common/jump.jsp?jumpType=SITE&id=S0027632"
      ]
    },
    {
      "name": "_mirrored_at",
      "type": "date",
      "pattern": "YYYY-MM-DD HH:MM:SS.ssssss+TZ",
      "nullable": false,
      "description": "Timestamp when record was mirrored/synchronized",
      "sampleValues": [
        "2026-02-09 19:05:59.414658+00"
      ]
    },
    {
      "name": "geom",
      "type": "geometry",
      "nullable": false,
      "description": "Binary geometry representation in hexadecimal format",
      "sampleValues": [
        "0101000020E61000007F2C86A392EC5F409F17F6CD602A32C0"
      ]
    }
  ],
  "semantics": {
    "idFields": [
      "_id",
      "gmlid",
      "gid",
      "oid",
      "proj_code",
      "site_code"
    ],
    "nameFields": [
      "proj_title",
      "short_name",
      "site_title"
    ],
    "primaryKey": "_id",
    "statusFields": [
      "site_stage",
      "confidenti",
      "point_conf"
    ],
    "fieldMeanings": {
      "_id": "Internal unique identifier",
      "gid": "Geographic identifier",
      "oid": "Object identifier",
      "geom": "Binary geometry representation",
      "_geom": "Point geometry (WKT format)",
      "gmlid": "GML standard identifier",
      "latitude": "Latitude coordinate",
      "web_link": "Reference URL",
      "commodity": "Primary commodity category",
      "longitude": "Longitude coordinate",
      "proj_code": "Project code identifier",
      "site_code": "Site identifier code",
      "confidenti": "Data confidentiality level",
      "extract_da": "Data extraction date",
      "point_conf": "Point location confidence",
      "proj_title": "Project name",
      "short_name": "Site short name",
      "site_commo": "Site commodities (chemical symbols)",
      "site_stage": "Operational stage/status",
      "site_sub_t": "Site subtype classification",
      "site_title": "Full site name",
      "site_type_": "Primary site type",
      "target_com": "Target commodity description",
      "_mirrored_at": "Data synchronization timestamp"
    },
    "relationships": [
      {
        "field": "site_code",
        "relatedTo": "web_link",
        "relationshipType": "reference_link"
      },
      {
        "field": "latitude",
        "relatedTo": "longitude",
        "relationshipType": "coordinate_pair"
      },
      {
        "field": "_geom",
        "relatedTo": "geom",
        "relationshipType": "geometry_formats"
      },
      {
        "field": "commodity",
        "relatedTo": "target_com",
        "relationshipType": "commodity_hierarchy"
      },
      {
        "field": "site_type_",
        "relatedTo": "site_sub_t",
        "relationshipType": "type_subtype"
      }
    ],
    "geometryFields": [
      "_geom",
      "geom",
      "latitude",
      "longitude"
    ],
    "commodityFields": [
      "commodity",
      "site_commo",
      "target_com"
    ]
  },
  "confidence": 0.95,
  "entityType": "mining_site",
  "recordCount": 100
}