Artifacts

{
  "mappings": [
    {
      "confidence": 0.95,
      "mappingType": "direct",
      "sourceField": "name",
      "justification": "Direct mapping from shaft name to working name. Field contains shaft names like 'Martins Engine Shaft' and identifiers.",
      "targetAttribute": "name"
    },
    {
      "confidence": 0.98,
      "mappingType": "direct",
      "sourceField": "_id",
      "justification": "Primary unique identifier from source system maps directly to source_id requirement.",
      "targetAttribute": "source_id"
    },
    {
      "transform": {
        "type": "parse",
        "expression": "CAST(depth_m AS FLOAT)"
      },
      "confidence": 0.85,
      "mappingType": "computed",
      "sourceField": "depth_m",
      "justification": "Shaft depth stored as string needs parsing to float. All samples show '0' which may indicate missing data.",
      "targetAttribute": "depth_meters"
    },
    {
      "transform": {
        "type": "parse",
        "expression": "CAST(collar_m AS FLOAT)"
      },
      "confidence": 0.8,
      "mappingType": "computed",
      "sourceField": "collar_m",
      "justification": "Collar elevation in meters maps to collar_elevation, but stored as string and samples are null.",
      "targetAttribute": "collar_elevation"
    },
    {
      "transform": {
        "type": "expression",
        "expression": "ARRAY[reef] WHERE reef IS NOT NULL"
      },
      "confidence": 0.6,
      "mappingType": "inferred",
      "sourceField": "reef",
      "justification": "Reef field may indicate geological formation associated with mineral commodities, but samples are null and relationship is indirect.",
      "targetAttribute": "commodities"
    },
    {
      "transform": {
        "type": "lookup",
        "lookupTable": "reclamation_to_status"
      },
      "confidence": 0.55,
      "mappingType": "inferred",
      "sourceField": "recl_meth",
      "justification": "Reclamation method may indicate current status of the working, but samples are null and mapping is uncertain.",
      "targetAttribute": "status"
    },
    {
      "transform": {
        "type": "expression",
        "expression": "'shaft'"
      },
      "confidence": 0.9,
      "mappingType": "computed",
      "sourceField": "working_type",
      "inferredFrom": [
        "source dataset context"
      ],
      "justification": "Since this is shaft data, working_type should be set to 'shaft' as a constant value.",
      "targetAttribute": "working_type"
    },
    {
      "transform": {
        "type": "expression",
        "expression": "'underground_access'"
      },
      "confidence": 0.85,
      "mappingType": "computed",
      "sourceField": "working_category",
      "inferredFrom": [
        "source dataset context"
      ],
      "justification": "Shafts are typically categorized as 'underground_access' in mine working taxonomy.",
      "targetAttribute": "working_category"
    },
    {
      "transform": {
        "type": "expression",
        "expression": "'Victoria'"
      },
      "confidence": 0.95,
      "mappingType": "computed",
      "sourceField": "jurisdiction",
      "inferredFrom": [
        "source dataset name"
      ],
      "justification": "Source is 'au_vic_shafts' indicating Victoria, Australia jurisdiction.",
      "targetAttribute": "jurisdiction"
    },
    {
      "transform": {
        "type": "expression",
        "expression": "'AU'"
      },
      "confidence": 0.95,
      "mappingType": "computed",
      "sourceField": "country",
      "inferredFrom": [
        "source dataset name"
      ],
      "justification": "Source is Australian data (au_vic_shafts), so country code is AU.",
      "targetAttribute": "country"
    }
  ],
  "featureType": "mine_working",
  "unmappedFields": [
    "collar_ft",
    "comments",
    "datum",
    "easting",
    "id",
    "labelstr",
    "locacc",
    "locn_desc",
    "northing",
    "shaftid",
    "siteid_ms",
    "source",
    "sourcecomm",
    "vincent_no",
    "zone",
    "_mirrored_at",
    "geom",
    "_geom"
  ],
  "overallConfidence": 0.78,
  "suggestedAttributes": [
    {
      "name": "location_accuracy_meters",
      "dataType": "FLOAT",
      "description": "Accuracy of the location measurement in meters"
    },
    {
      "name": "data_source",
      "dataType": "TEXT",
      "description": "Original data source or collection method"
    },
    {
      "name": "alternative_ids",
      "dataType": "ARRAY",
      "description": "Alternative identifiers from various numbering systems"
    },
    {
      "name": "coordinate_system",
      "dataType": "TEXT",
      "description": "Coordinate reference system used for positioning"
    }
  ]
}

{
  "isValid": false,
  "warnings": [
    "depth_meters: 100% of values don't match expected type FLOAT",
    "collar_elevation_feet: 100% of values don't match expected type FLOAT",
    "collar_elevation_meters: 100% of values don't match expected type FLOAT",
    "location_accuracy: 100% of values don't match expected type INTEGER",
    "easting: 100% of values don't match expected type FLOAT",
    "northing: 100% of values don't match expected type FLOAT",
    "geometry: 100% of values don't match expected type GEOMETRY"
  ],
  "sourceSlug": "au_vic_shafts",
  "featureType": "mine_working",
  "suggestions": [],
  "validatedAt": "2026-02-09T21:50:00.884Z",
  "criticalIssues": [
    "working_type: No matching field found for patterns: ",
    "country: No matching field found for patterns: ",
    "jurisdiction: No matching field found for patterns: "
  ],
  "totalAttributes": 23,
  "validAttributes": 13,
  "validationScore": 57,
  "fieldValidations": [
    {
      "issues": [],
      "isValid": true,
      "nullCount": 5648,
      "actualTypes": {
        "string": 23598
      },
      "nullPercent": 19,
      "expectedType": "TEXT",
      "matchedField": "name",
      "totalRecords": 29246,
      "attributeName": "name",
      "distinctCount": 13814,
      "sourcePatterns": [
        "name"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [
        "No matching field found for patterns: "
      ],
      "isValid": false,
      "nullCount": 29246,
      "actualTypes": {},
      "nullPercent": 100,
      "expectedType": "TEXT",
      "matchedField": null,
      "totalRecords": 29246,
      "attributeName": "working_type",
      "distinctCount": 0,
      "sourcePatterns": [],
      "typeMismatchPercent": 100
    },
    {
      "issues": [
        "100% of values don't match expected type FLOAT"
      ],
      "isValid": false,
      "nullCount": 0,
      "actualTypes": {
        "string": 29246
      },
      "nullPercent": 0,
      "expectedType": "FLOAT",
      "matchedField": "depth_m",
      "sampleIssues": [
        "0",
        "0",
        "0",
        "0",
        "0"
      ],
      "totalRecords": 29246,
      "attributeName": "depth_meters",
      "distinctCount": 187,
      "sourcePatterns": [
        "depth_m"
      ],
      "typeMismatchPercent": 100
    },
    {
      "issues": [
        "100% of values don't match expected type FLOAT"
      ],
      "isValid": false,
      "nullCount": 28183,
      "actualTypes": {
        "string": 1063
      },
      "nullPercent": 96,
      "expectedType": "FLOAT",
      "matchedField": "collar_ft",
      "sampleIssues": [
        "6x4",
        "5x3",
        "4x4",
        "5x3",
        "6x3"
      ],
      "totalRecords": 29246,
      "attributeName": "collar_elevation_feet",
      "distinctCount": 95,
      "sourcePatterns": [
        "collar_ft"
      ],
      "typeMismatchPercent": 100
    },
    {
      "issues": [
        "100% of values don't match expected type FLOAT"
      ],
      "isValid": false,
      "nullCount": 29243,
      "actualTypes": {
        "string": 3
      },
      "nullPercent": 100,
      "expectedType": "FLOAT",
      "matchedField": "collar_m",
      "sampleIssues": [
        "2.6x0.8m",
        "2x1.4m",
        "3x2m"
      ],
      "totalRecords": 29246,
      "attributeName": "collar_elevation_meters",
      "distinctCount": 3,
      "sourcePatterns": [
        "collar_m"
      ],
      "typeMismatchPercent": 100
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 22905,
      "actualTypes": {
        "string": 6341
      },
      "nullPercent": 78,
      "expectedType": "TEXT",
      "matchedField": "shaftid",
      "totalRecords": 29246,
      "attributeName": "shaft_id",
      "distinctCount": 6341,
      "sourcePatterns": [
        "shaftid"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 29246
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "siteid_ms",
      "totalRecords": 29246,
      "attributeName": "site_id",
      "distinctCount": 1889,
      "sourcePatterns": [
        "siteid_ms"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [
        "100% of values don't match expected type INTEGER"
      ],
      "isValid": false,
      "nullCount": 0,
      "actualTypes": {
        "string": 29246
      },
      "nullPercent": 0,
      "expectedType": "INTEGER",
      "matchedField": "locacc",
      "sampleIssues": [
        "30",
        "30",
        "30",
        "30",
        "30"
      ],
      "totalRecords": 29246,
      "attributeName": "location_accuracy",
      "distinctCount": 15,
      "sourcePatterns": [
        "locacc"
      ],
      "typeMismatchPercent": 100
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 21171,
      "actualTypes": {
        "string": 8075
      },
      "nullPercent": 72,
      "expectedType": "TEXT",
      "matchedField": "locn_desc",
      "totalRecords": 29246,
      "attributeName": "location_description",
      "distinctCount": 3549,
      "sourcePatterns": [
        "locn_desc"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 28924,
      "actualTypes": {
        "string": 322
      },
      "nullPercent": 99,
      "expectedType": "TEXT",
      "matchedField": "reef",
      "totalRecords": 29246,
      "attributeName": "reef",
      "distinctCount": 196,
      "sourcePatterns": [
        "reef"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 19221,
      "actualTypes": {
        "string": 10025
      },
      "nullPercent": 66,
      "expectedType": "TEXT",
      "matchedField": "comments",
      "totalRecords": 29246,
      "attributeName": "comments",
      "distinctCount": 5162,
      "sourcePatterns": [
        "comments"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 29246
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "source",
      "totalRecords": 29246,
      "attributeName": "data_source",
      "distinctCount": 15,
      "sourcePatterns": [
        "source"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 15493,
      "actualTypes": {
        "string": 13753
      },
      "nullPercent": 53,
      "expectedType": "TEXT",
      "matchedField": "sourcecomm",
      "totalRecords": 29246,
      "attributeName": "source_comments",
      "distinctCount": 1341,
      "sourcePatterns": [
        "sourcecomm"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 27078,
      "actualTypes": {
        "string": 2168
      },
      "nullPercent": 93,
      "expectedType": "TEXT",
      "matchedField": "recl_meth",
      "totalRecords": 29246,
      "attributeName": "reclamation_method",
      "distinctCount": 52,
      "sourcePatterns": [
        "recl_meth"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 1,
      "actualTypes": {
        "string": 29245
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "vincent_no",
      "totalRecords": 29246,
      "attributeName": "vincent_number",
      "distinctCount": 890,
      "sourcePatterns": [
        "vincent_no"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 29246
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "datum",
      "totalRecords": 29246,
      "attributeName": "coordinate_datum",
      "distinctCount": 1,
      "sourcePatterns": [
        "datum"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 29246
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "zone",
      "totalRecords": 29246,
      "attributeName": "utm_zone",
      "distinctCount": 2,
      "sourcePatterns": [
        "zone"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [
        "100% of values don't match expected type FLOAT"
      ],
      "isValid": false,
      "nullCount": 0,
      "actualTypes": {
        "string": 29246
      },
      "nullPercent": 0,
      "expectedType": "FLOAT",
      "matchedField": "easting",
      "sampleIssues": [
        "256661.80659999978",
        "253561.56950000022",
        "253743.0133999996",
        "255097.8607999999",
        "252480.23790000007"
      ],
      "totalRecords": 29246,
      "attributeName": "easting",
      "distinctCount": 28327,
      "sourcePatterns": [
        "easting"
      ],
      "typeMismatchPercent": 100
    },
    {
      "issues": [
        "100% of values don't match expected type FLOAT"
      ],
      "isValid": false,
      "nullCount": 0,
      "actualTypes": {
        "string": 29246
      },
      "nullPercent": 0,
      "expectedType": "FLOAT",
      "matchedField": "northing",
      "sampleIssues": [
        "5891054.2526",
        "5887744.9041",
        "5887754.9837",
        "5893939.8277",
        "5893017.0799"
      ],
      "totalRecords": 29246,
      "attributeName": "northing",
      "distinctCount": 28514,
      "sourcePatterns": [
        "northing"
      ],
      "typeMismatchPercent": 100
    },
    {
      "issues": [],
      "isValid": true,
      "nullCount": 0,
      "actualTypes": {
        "string": 29246
      },
      "nullPercent": 0,
      "expectedType": "TEXT",
      "matchedField": "id",
      "totalRecords": 29246,
      "attributeName": "source_id",
      "distinctCount": 29246,
      "sourcePatterns": [
        "id",
        "_id"
      ],
      "typeMismatchPercent": 0
    },
    {
      "issues": [
        "100% of values don't match expected type GEOMETRY"
      ],
      "isValid": false,
      "nullCount": 0,
      "actualTypes": {
        "string": 29246
      },
      "nullPercent": 0,
      "expectedType": "GEOMETRY",
      "matchedField": "_geom",
      "sampleIssues": [
        "POINT(144.262001 -37.095224)",
        "POINT(144.226067 -37.12421)",
        "POINT(144.228111 -37.124167)",
        "POINT(144.245363 -37.068835)",
        "POINT(144.215648 -37.076456)"
      ],
      "totalRecords": 29246,
      "attributeName": "geometry",
      "distinctCount": 29105,
      "sourcePatterns": [
        "_geom",
        "geom"
      ],
      "typeMismatchPercent": 100
    },
    {
      "issues": [
        "No matching field found for patterns: "
      ],
      "isValid": false,
      "nullCount": 29246,
      "actualTypes": {},
      "nullPercent": 100,
      "expectedType": "TEXT",
      "matchedField": null,
      "totalRecords": 29246,
      "attributeName": "country",
      "distinctCount": 0,
      "sourcePatterns": [],
      "typeMismatchPercent": 100
    },
    {
      "issues": [
        "No matching field found for patterns: "
      ],
      "isValid": false,
      "nullCount": 29246,
      "actualTypes": {},
      "nullPercent": 100,
      "expectedType": "TEXT",
      "matchedField": null,
      "totalRecords": 29246,
      "attributeName": "jurisdiction",
      "distinctCount": 0,
      "sourcePatterns": [],
      "typeMismatchPercent": 100
    }
  ],
  "recordsValidated": 29246,
  "attributesWithIssues": 10
}

{
  "domain": "mining",
  "qualityNotes": [
    "Many records have null values for depth measurements (collar_ft, collar_m, depth_m)",
    "Some records lack names and only have numeric identifiers",
    "Location accuracy varies significantly (15m to 100m)",
    "Depth values are mostly '0', suggesting surface-level or unknown depths",
    "Mixed coordinate systems with different UTM zones (54, 55)",
    "Historical data sources with varying quality and completeness",
    "Some records have detailed source provenance while others are minimal"
  ],
  "commonPatterns": {
    "dateFields": [
      "_mirrored_at"
    ],
    "statusFields": [],
    "geometryFields": [
      "_geom",
      "geom",
      "easting",
      "northing"
    ],
    "commodityFields": [],
    "identifierFields": [
      "_id",
      "id",
      "shaftid",
      "siteid_ms",
      "vincent_no"
    ],
    "measurementFields": [
      "depth_m",
      "collar_ft",
      "collar_m",
      "locacc"
    ]
  },
  "alternativeTypes": [
    {
      "name": "Mineral Occurrence",
      "slug": "mineral_occurrence",
      "reasoning": "Could be considered mineral occurrences since shafts indicate mineral extraction, but the data is specifically about the physical infrastructure (shafts) rather than the mineral deposits themselves",
      "attributes": [
        {
          "name": "name",
          "dataType": "TEXT",
          "required": false,
          "isGeometry": false,
          "description": "Name of the occurrence",
          "isIdentifier": false,
          "sourceFieldPatterns": [
            "name"
          ]
        },
        {
          "name": "status",
          "dataType": "TEXT",
          "required": false,
          "isGeometry": false,
          "description": "Status of the occurrence",
          "isIdentifier": false,
          "sourceFieldPatterns": []
        },
        {
          "name": "source_id",
          "dataType": "TEXT",
          "required": true,
          "isGeometry": false,
          "description": "Source identifier",
          "isIdentifier": true,
          "sourceFieldPatterns": [
            "id",
            "_id"
          ]
        }
      ],
      "confidence": 0.3,
      "description": "Historical mining locations where minerals were extracted",
      "geometryType": "POINT"
    }
  ],
  "primaryFeatureType": {
    "name": "Mine Working",
    "slug": "mine_working",
    "reasoning": "This data clearly represents mine shafts, which are a specific type of mine working. The presence of shaft-specific fields like depth_m, collar_ft/collar_m, and the explicit 'shafts' in the source name confirms this. The existing mine_working feature type is the best match.",
    "attributes": [
      {
        "name": "name",
        "dataType": "TEXT",
        "examples": [
          "ROB ROY CO.",
          "Haphazard Freehold G.M. Co.",
          "Chalks No. 3 North Shaft"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Name of the mine shaft or working",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "name"
        ]
      },
      {
        "name": "working_type",
        "dataType": "TEXT",
        "examples": [
          "shaft"
        ],
        "required": true,
        "enumValues": [
          "shaft"
        ],
        "isGeometry": false,
        "description": "Type of mine working",
        "isIdentifier": false,
        "sourceFieldPatterns": []
      },
      {
        "name": "depth_meters",
        "dataType": "FLOAT",
        "examples": [
          "0"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Depth of the shaft in meters",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "depth_m"
        ]
      },
      {
        "name": "collar_elevation_feet",
        "dataType": "FLOAT",
        "examples": [],
        "required": false,
        "isGeometry": false,
        "description": "Collar elevation in feet",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "collar_ft"
        ]
      },
      {
        "name": "collar_elevation_meters",
        "dataType": "FLOAT",
        "examples": [],
        "required": false,
        "isGeometry": false,
        "description": "Collar elevation in meters",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "collar_m"
        ]
      },
      {
        "name": "shaft_id",
        "dataType": "TEXT",
        "examples": [
          "645"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Specific shaft identifier",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "shaftid"
        ]
      },
      {
        "name": "site_id",
        "dataType": "TEXT",
        "examples": [
          "378413",
          "366224"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Mine site identifier",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "siteid_ms"
        ]
      },
      {
        "name": "location_accuracy",
        "dataType": "INTEGER",
        "examples": [
          "30",
          "15",
          "100"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Location accuracy in meters",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "locacc"
        ]
      },
      {
        "name": "location_description",
        "dataType": "TEXT",
        "examples": [],
        "required": false,
        "isGeometry": false,
        "description": "Description of the location",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "locn_desc"
        ]
      },
      {
        "name": "reef",
        "dataType": "TEXT",
        "examples": [],
        "required": false,
        "isGeometry": false,
        "description": "Associated reef or ore body",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "reef"
        ]
      },
      {
        "name": "comments",
        "dataType": "TEXT",
        "examples": [],
        "required": false,
        "isGeometry": false,
        "description": "Additional comments or notes",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "comments"
        ]
      },
      {
        "name": "data_source",
        "dataType": "TEXT",
        "examples": [
          "Digitized for Ginger",
          "Heritage Inventory",
          "1 5000 Plots (Frank Adams c1970s)"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Original data source",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "source"
        ]
      },
      {
        "name": "source_comments",
        "dataType": "TEXT",
        "examples": [
          "Heritage Inventory 2019 Hermes Number 7142",
          "Departmental mapping pre 1970"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Comments about the data source",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "sourcecomm"
        ]
      },
      {
        "name": "reclamation_method",
        "dataType": "TEXT",
        "examples": [],
        "required": false,
        "isGeometry": false,
        "description": "Method used for reclamation or rehabilitation",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "recl_meth"
        ]
      },
      {
        "name": "vincent_number",
        "dataType": "TEXT",
        "examples": [
          "0"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Vincent catalog number",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "vincent_no"
        ]
      },
      {
        "name": "coordinate_datum",
        "dataType": "TEXT",
        "examples": [
          "GDA94"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Coordinate reference system datum",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "datum"
        ]
      },
      {
        "name": "utm_zone",
        "dataType": "TEXT",
        "examples": [
          "54",
          "55"
        ],
        "required": false,
        "isGeometry": false,
        "description": "UTM zone for coordinates",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "zone"
        ]
      },
      {
        "name": "easting",
        "dataType": "FLOAT",
        "examples": [
          "728360.6131999996",
          "751665.6765999999"
        ],
        "required": false,
        "isGeometry": false,
        "description": "UTM easting coordinate",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "easting"
        ]
      },
      {
        "name": "northing",
        "dataType": "FLOAT",
        "examples": [
          "5833283.3685",
          "5840021.3382"
        ],
        "required": false,
        "isGeometry": false,
        "description": "UTM northing coordinate",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "northing"
        ]
      },
      {
        "name": "source_id",
        "dataType": "TEXT",
        "examples": [
          "210268",
          "212021",
          "201734"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Original source record identifier",
        "isIdentifier": true,
        "sourceFieldPatterns": [
          "id",
          "_id"
        ]
      },
      {
        "name": "geometry",
        "dataType": "GEOMETRY",
        "examples": [
          "POINT(143.587455 -37.619206)"
        ],
        "required": true,
        "isGeometry": true,
        "description": "Point geometry of the shaft location",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "_geom",
          "geom"
        ]
      },
      {
        "name": "country",
        "dataType": "TEXT",
        "examples": [
          "Australia"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Country where the shaft is located",
        "isIdentifier": false,
        "sourceFieldPatterns": []
      },
      {
        "name": "jurisdiction",
        "dataType": "TEXT",
        "examples": [
          "Victoria"
        ],
        "required": true,
        "isGeometry": false,
        "description": "State or territory jurisdiction",
        "isIdentifier": false,
        "sourceFieldPatterns": []
      }
    ],
    "confidence": 0.95,
    "description": "Historical and active mine shafts and workings in Victoria, Australia",
    "geometryType": "POINT"
  }
}

{
  "fields": [
    {
      "name": "_id",
      "type": "string",
      "pattern": "vic_shaft_\\d+",
      "nullable": false,
      "description": "Unique identifier for each shaft record",
      "sampleValues": [
        "vic_shaft_60781",
        "vic_shaft_206860",
        "vic_shaft_70011"
      ]
    },
    {
      "name": "_geom",
      "type": "geometry",
      "pattern": "POINT\\([\\d\\.-]+ [\\d\\.-]+\\)",
      "nullable": false,
      "description": "Point geometry in WGS84 coordinates (longitude, latitude)",
      "sampleValues": [
        "POINT(144.238188 -36.703859)",
        "POINT(144.266209 -36.799845)",
        "POINT(147.083491 -36.118666)"
      ]
    },
    {
      "name": "collar_ft",
      "type": "string",
      "nullable": true,
      "description": "Collar elevation in feet",
      "sampleValues": [
        null,
        null,
        null
      ]
    },
    {
      "name": "collar_m",
      "type": "string",
      "nullable": true,
      "description": "Collar elevation in meters",
      "sampleValues": [
        null,
        null,
        null
      ]
    },
    {
      "name": "comments",
      "type": "string",
      "nullable": true,
      "description": "Additional comments about the shaft",
      "sampleValues": [
        null,
        null,
        null
      ]
    },
    {
      "name": "datum",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "GDA94"
      ],
      "description": "Geodetic datum used for coordinates",
      "sampleValues": [
        "GDA94",
        "GDA94",
        "GDA94"
      ]
    },
    {
      "name": "depth_m",
      "type": "string",
      "nullable": false,
      "description": "Depth of shaft in meters (stored as string)",
      "sampleValues": [
        "0",
        "0",
        "0"
      ]
    },
    {
      "name": "easting",
      "type": "string",
      "nullable": false,
      "description": "Easting coordinate in projected coordinate system",
      "sampleValues": [
        "253287.08409999963",
        "256095.09439999983",
        "507513"
      ]
    },
    {
      "name": "id",
      "type": "string",
      "nullable": false,
      "description": "Numeric identifier for the shaft",
      "sampleValues": [
        "60781",
        "206860",
        "70011"
      ]
    },
    {
      "name": "labelstr",
      "type": "string",
      "pattern": ".+ \\(\\+/- \\d+m\\)",
      "nullable": false,
      "description": "Display label with name and location accuracy",
      "sampleValues": [
        "60781 (+/- 30m)",
        "Unknown (+/- 30m)",
        "Martins Engine Shaft (+/- 100m)"
      ]
    },
    {
      "name": "locacc",
      "type": "string",
      "nullable": false,
      "description": "Location accuracy in meters",
      "sampleValues": [
        "30",
        "30",
        "100"
      ]
    },
    {
      "name": "locn_desc",
      "type": "string",
      "nullable": true,
      "description": "Location description",
      "sampleValues": [
        null,
        null,
        null
      ]
    },
    {
      "name": "name",
      "type": "string",
      "nullable": false,
      "description": "Name of the shaft",
      "sampleValues": [
        "60781",
        "Unknown",
        "Martins Engine Shaft"
      ]
    },
    {
      "name": "northing",
      "type": "string",
      "nullable": false,
      "description": "Northing coordinate in projected coordinate system",
      "sampleValues": [
        "5934421.7853",
        "5923842.527",
        "6002885"
      ]
    },
    {
      "name": "recl_meth",
      "type": "string",
      "nullable": true,
      "description": "Reclamation method",
      "sampleValues": [
        null,
        null,
        null
      ]
    },
    {
      "name": "reef",
      "type": "string",
      "nullable": true,
      "description": "Associated reef or geological formation",
      "sampleValues": [
        null,
        null,
        null
      ]
    },
    {
      "name": "shaftid",
      "type": "string",
      "nullable": true,
      "description": "Alternative shaft identifier",
      "sampleValues": [
        null,
        null,
        null
      ]
    },
    {
      "name": "siteid_ms",
      "type": "string",
      "nullable": false,
      "description": "Site identifier for mining system",
      "sampleValues": [
        "0",
        "0",
        "0"
      ]
    },
    {
      "name": "source",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "Digitized for Ginger",
        "Heritage Inventory"
      ],
      "description": "Data source or origin",
      "sampleValues": [
        "Digitized for Ginger",
        "Digitized for Ginger",
        "Heritage Inventory"
      ]
    },
    {
      "name": "sourcecomm",
      "type": "string",
      "nullable": true,
      "description": "Source comments or additional source information",
      "sampleValues": [
        null,
        null,
        "Heritage Inventory 2019 Hermes Number 11029"
      ]
    },
    {
      "name": "vincent_no",
      "type": "string",
      "nullable": false,
      "description": "Vincent number identifier",
      "sampleValues": [
        "0",
        "0",
        "0"
      ]
    },
    {
      "name": "zone",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "54",
        "55"
      ],
      "description": "UTM zone for coordinate system",
      "sampleValues": [
        "55",
        "55",
        "55"
      ]
    },
    {
      "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:04:58.351141+00",
        "2026-02-09 19:04:58.351141+00",
        "2026-02-09 19:04:58.351141+00"
      ]
    },
    {
      "name": "geom",
      "type": "geometry",
      "nullable": false,
      "description": "Binary geometry representation (WKB format)",
      "sampleValues": [
        "0101000020E610000097C9703C9F07624065FF3C0D185A42C0",
        "0101000020E6100000D49CBCC8840862403F6F2A52616642C0",
        "0101000020E6100000555051F5AB626240D5928E72300F42C0"
      ]
    }
  ],
  "semantics": {
    "idFields": [
      "_id",
      "id",
      "shaftid",
      "siteid_ms",
      "vincent_no"
    ],
    "nameFields": [
      "name",
      "labelstr"
    ],
    "primaryKey": "_id",
    "statusFields": [
      "recl_meth"
    ],
    "fieldMeanings": {
      "id": "Numeric shaft identifier",
      "_id": "Primary unique identifier",
      "geom": "Binary geometry representation",
      "name": "Shaft name or identifier",
      "reef": "Associated geological reef",
      "zone": "UTM coordinate zone",
      "_geom": "WGS84 point geometry",
      "datum": "Coordinate reference system",
      "locacc": "Location accuracy measure",
      "source": "Data source origin",
      "depth_m": "Shaft depth measurement",
      "easting": "Projected easting coordinate",
      "shaftid": "Alternative shaft ID",
      "collar_m": "Shaft collar elevation (meters)",
      "comments": "General comments",
      "labelstr": "Display label with accuracy",
      "northing": "Projected northing coordinate",
      "collar_ft": "Shaft collar elevation (feet)",
      "locn_desc": "Location description",
      "recl_meth": "Reclamation methodology",
      "siteid_ms": "Mining system site ID",
      "sourcecomm": "Source documentation",
      "vincent_no": "Vincent classification number",
      "_mirrored_at": "Data synchronization timestamp"
    },
    "relationships": [
      {
        "field": "_geom",
        "relatedTo": "geom",
        "relationshipType": "alternative_representation"
      },
      {
        "field": "easting",
        "relatedTo": "northing",
        "relationshipType": "coordinate_pair"
      },
      {
        "field": "collar_ft",
        "relatedTo": "collar_m",
        "relationshipType": "unit_conversion"
      },
      {
        "field": "source",
        "relatedTo": "sourcecomm",
        "relationshipType": "documentation"
      },
      {
        "field": "name",
        "relatedTo": "labelstr",
        "relationshipType": "display_variant"
      }
    ],
    "geometryFields": [
      "_geom",
      "geom"
    ],
    "commodityFields": [
      "reef"
    ]
  },
  "confidence": 0.95,
  "entityType": "mine_shaft",
  "recordCount": 100
}

{
  "fields": [
    {
      "name": "_id",
      "type": "string",
      "pattern": "vic_shaft_\\d+",
      "nullable": false,
      "description": "Unique identifier for each shaft record",
      "sampleValues": [
        "vic_shaft_200164",
        "vic_shaft_82157",
        "vic_shaft_101368"
      ]
    },
    {
      "name": "_geom",
      "type": "geometry",
      "pattern": "POINT\\([\\d\\.-]+ [\\d\\.-]+\\)",
      "nullable": false,
      "description": "Point geometry in WGS84 coordinates (longitude, latitude)",
      "sampleValues": [
        "POINT(144.10134 -37.079707)",
        "POINT(144.231191 -36.719483)"
      ]
    },
    {
      "name": "collar_ft",
      "type": "string",
      "nullable": true,
      "description": "Collar dimensions in feet",
      "sampleValues": [
        "6x4'",
        null
      ]
    },
    {
      "name": "collar_m",
      "type": "string",
      "nullable": true,
      "description": "Collar dimensions in meters",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "comments",
      "type": "string",
      "nullable": true,
      "description": "Additional comments about the shaft",
      "sampleValues": [
        "Hazard: Oc,.",
        "Open stope.",
        "Adit. Collapsed. Alias Crysotile; Crystalline.",
        null
      ]
    },
    {
      "name": "datum",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "GDA94"
      ],
      "description": "Geodetic datum used for coordinates",
      "sampleValues": [
        "GDA94"
      ]
    },
    {
      "name": "depth_m",
      "type": "string",
      "nullable": false,
      "description": "Depth of shaft in meters (stored as string)",
      "sampleValues": [
        "0",
        "2",
        "21"
      ]
    },
    {
      "name": "easting",
      "type": "string",
      "nullable": false,
      "description": "Easting coordinate in projected coordinate system",
      "sampleValues": [
        "242327.35039999988",
        "252712",
        "473657.77359999996"
      ]
    },
    {
      "name": "id",
      "type": "string",
      "nullable": false,
      "description": "Numeric identifier for the shaft",
      "sampleValues": [
        "200164",
        "82157",
        "101368"
      ]
    },
    {
      "name": "labelstr",
      "type": "string",
      "nullable": false,
      "description": "Display label with name and location accuracy",
      "sampleValues": [
        "U (+/- 30m)",
        "Old Prince Of Wales (+/- 10m)",
        "My Legacy Open stope (+/- 10m)"
      ]
    },
    {
      "name": "locacc",
      "type": "string",
      "nullable": false,
      "description": "Location accuracy in meters",
      "sampleValues": [
        "30",
        "10",
        "15"
      ]
    },
    {
      "name": "locn_desc",
      "type": "string",
      "nullable": true,
      "description": "Location description with additional context",
      "sampleValues": [
        "Township: Eaglehawk. Land: PV",
        "Length: 8.0.. possible name",
        null
      ]
    },
    {
      "name": "name",
      "type": "string",
      "nullable": true,
      "description": "Name of the shaft or mine",
      "sampleValues": [
        "U",
        "Old Prince Of Wales",
        "My Legacy Open stope",
        "Chrysolite Adit",
        null
      ]
    },
    {
      "name": "northing",
      "type": "string",
      "nullable": false,
      "description": "Northing coordinate in projected coordinate system",
      "sampleValues": [
        "5892352.1265",
        "5932670",
        "5963381.4958"
      ]
    },
    {
      "name": "recl_meth",
      "type": "string",
      "nullable": true,
      "description": "Reclamation method used for the shaft",
      "sampleValues": [
        "Filled with mullock",
        null
      ]
    },
    {
      "name": "reef",
      "type": "string",
      "nullable": true,
      "description": "Associated reef information",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "shaftid",
      "type": "string",
      "nullable": true,
      "description": "Alternative shaft identifier",
      "sampleValues": [
        "1287",
        null
      ]
    },
    {
      "name": "siteid_ms",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "0"
      ],
      "description": "Site identifier for mine sites",
      "sampleValues": [
        "0"
      ]
    },
    {
      "name": "source",
      "type": "string",
      "nullable": false,
      "description": "Data source for the record",
      "sampleValues": [
        "Digitized for Ginger",
        "Private survey",
        "Lease Ozalids (Landry c1990)"
      ]
    },
    {
      "name": "sourcecomm",
      "type": "string",
      "nullable": true,
      "description": "Additional source comments",
      "sampleValues": [
        "DELWP Loddon Mallee Dangerous Mines Register 2017",
        "Supplied by Fred Sargent Bowmans Forest 2019",
        null
      ]
    },
    {
      "name": "vincent_no",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "0"
      ],
      "description": "Vincent number reference",
      "sampleValues": [
        "0"
      ]
    },
    {
      "name": "zone",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "55"
      ],
      "description": "UTM zone for coordinate system",
      "sampleValues": [
        "55"
      ]
    },
    {
      "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:04:58.351141+00"
      ]
    },
    {
      "name": "geom",
      "type": "geometry",
      "nullable": false,
      "description": "Binary geometry representation (WKB format)",
      "sampleValues": [
        "0101000020E6100000DA38622D3E0362409221C7D6338A42C0"
      ]
    }
  ],
  "semantics": {
    "idFields": [
      "_id",
      "id",
      "shaftid",
      "siteid_ms"
    ],
    "nameFields": [
      "name",
      "labelstr"
    ],
    "primaryKey": "_id",
    "statusFields": [
      "recl_meth"
    ],
    "fieldMeanings": {
      "id": "Numeric shaft identifier",
      "_id": "Primary unique identifier",
      "geom": "Binary geometry representation",
      "name": "Shaft or mine name",
      "reef": "Associated geological reef",
      "zone": "UTM coordinate zone",
      "_geom": "Point geometry in WGS84",
      "datum": "Geodetic reference datum",
      "locacc": "Location accuracy in meters",
      "source": "Data source reference",
      "depth_m": "Shaft depth measurement in meters",
      "easting": "Projected coordinate - easting",
      "shaftid": "Alternative shaft identifier",
      "collar_m": "Shaft collar dimensions in meters",
      "comments": "Descriptive comments and hazard information",
      "labelstr": "Display label with accuracy",
      "northing": "Projected coordinate - northing",
      "collar_ft": "Shaft collar dimensions in feet",
      "locn_desc": "Location description and context",
      "recl_meth": "Reclamation/rehabilitation method",
      "siteid_ms": "Mine site identifier",
      "sourcecomm": "Source comments and attribution",
      "vincent_no": "Vincent reference number",
      "_mirrored_at": "Data synchronization timestamp"
    },
    "relationships": [
      {
        "field": "_geom",
        "relatedTo": "geom",
        "relationshipType": "alternative_representation"
      },
      {
        "field": "easting",
        "relatedTo": "northing",
        "relationshipType": "coordinate_pair"
      },
      {
        "field": "collar_ft",
        "relatedTo": "collar_m",
        "relationshipType": "unit_conversion"
      },
      {
        "field": "id",
        "relatedTo": "_id",
        "relationshipType": "identifier_variant"
      }
    ],
    "geometryFields": [
      "_geom",
      "geom",
      "easting",
      "northing"
    ],
    "commodityFields": []
  },
  "confidence": 0.95,
  "entityType": "mine_shaft",
  "recordCount": 100
}