Artifacts

{
  "domain": "tenements",
  "qualityNotes": [
    "Date fields are stored as Unix timestamps in milliseconds and need conversion",
    "Multiple holder fields (holder1-holder9) but most records only use holder1",
    "Multiple address fields (addr1-addr9) but most records only use addr1",
    "Some records have very large enddate values (32503593600000) indicating no expiry or perpetual licenses",
    "Area units vary between hectares (HA.) and blocks (BL.) - blocks need conversion to hectares",
    "Survey status is consistently 'UNSURVEYED' across all samples",
    "Commodity information is not present in this dataset",
    "Special conditions field (special_in) is mostly null with occasional 'S' values",
    "Geometry is provided in both _geom (WKT) and geom (WKB) formats"
  ],
  "commonPatterns": {
    "dateFields": [
      "startdate",
      "enddate",
      "grantdate",
      "extract_da",
      "_mirrored_at"
    ],
    "statusFields": [
      "tenstatus",
      "survstatus"
    ],
    "geometryFields": [
      "_geom",
      "geom"
    ],
    "commodityFields": [],
    "identifierFields": [
      "_id",
      "tenid",
      "fmt_tenid",
      "gid",
      "oid"
    ],
    "measurementFields": [
      "legal_area",
      "st_area_the_geom_",
      "st_perimeter_the_geom_"
    ]
  },
  "alternativeTypes": [],
  "primaryFeatureType": {
    "name": "Mining Tenement",
    "slug": "tenement",
    "reasoning": "This data clearly represents mining tenements/permits in Western Australia. The records contain permit IDs (fmt_tenid, tenid), permit types (EXPLORATION LICENCE, PROSPECTING LICENCE, MISCELLANEOUS LICENCE), holders, grant/expiry dates, legal areas, and polygon geometries defining the permit boundaries. This matches the existing tenement feature type perfectly.",
    "attributes": [
      {
        "name": "permit_id",
        "dataType": "TEXT",
        "examples": [
          "E 51/2248",
          "P 28/1395",
          "L 45/852"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Formatted tenement identifier (e.g., E 51/2248, P 28/1395)",
        "isIdentifier": true,
        "sourceFieldPatterns": [
          "fmt_tenid",
          "tenid"
        ]
      },
      {
        "name": "name",
        "dataType": "TEXT",
        "examples": [],
        "required": false,
        "isGeometry": false,
        "description": "Tenement name or description",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "name",
          "title"
        ]
      },
      {
        "name": "type",
        "dataType": "TEXT",
        "examples": [
          "EXPLORATION LICENCE",
          "PROSPECTING LICENCE",
          "MISCELLANEOUS LICENCE"
        ],
        "required": true,
        "enumValues": [
          "EXPLORATION LICENCE",
          "PROSPECTING LICENCE",
          "MISCELLANEOUS LICENCE"
        ],
        "isGeometry": false,
        "description": "Type of mining permit or license",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "type",
          "permit_type",
          "licence_type"
        ]
      },
      {
        "name": "status",
        "dataType": "TEXT",
        "examples": [
          "LIVE",
          "PENDING"
        ],
        "required": true,
        "enumValues": [
          "LIVE",
          "PENDING",
          "EXPIRED",
          "CANCELLED"
        ],
        "isGeometry": false,
        "description": "Current status of the tenement",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "tenstatus",
          "status",
          "permit_status"
        ]
      },
      {
        "name": "holder",
        "dataType": "TEXT",
        "examples": [
          "ANTIPA RESOURCES PTY LTD",
          "NORTHERN STAR (CAROSUE DAM) PTY LTD",
          "RIDGEBACK GOLD MINING PTY LTD"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Primary holder/owner of the tenement",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "holder1",
          "holder",
          "owner",
          "company"
        ]
      },
      {
        "name": "holder_id",
        "dataType": "TEXT",
        "examples": [],
        "required": false,
        "isGeometry": false,
        "description": "Unique identifier for the holder",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "holder_id",
          "company_id"
        ]
      },
      {
        "name": "grant_date",
        "dataType": "DATE",
        "examples": [
          "1653868800000",
          "1579651200000"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Date when the tenement was granted",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "grantdate",
          "grant_date",
          "issue_date"
        ]
      },
      {
        "name": "expiry_date",
        "dataType": "DATE",
        "examples": [
          "1780012800000",
          "1832025600000"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Date when the tenement expires",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "enddate",
          "expiry_date",
          "end_date"
        ]
      },
      {
        "name": "start_date",
        "dataType": "DATE",
        "examples": [
          "1607472000000",
          "1518912000000"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Date when the tenement became active",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "startdate",
          "start_date",
          "commencement_date"
        ]
      },
      {
        "name": "area_hectares",
        "dataType": "FLOAT",
        "examples": [
          "3517.37",
          "3.66568",
          "8.54029"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Legal area of the tenement in hectares",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "legal_area",
          "area",
          "area_ha"
        ]
      },
      {
        "name": "area_units",
        "dataType": "TEXT",
        "examples": [
          "HA.",
          "BL."
        ],
        "required": false,
        "enumValues": [
          "HA.",
          "BL."
        ],
        "isGeometry": false,
        "description": "Units of measurement for the area",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "unit_of_me",
          "area_units"
        ]
      },
      {
        "name": "survey_status",
        "dataType": "TEXT",
        "examples": [
          "UNSURVEYED"
        ],
        "required": false,
        "enumValues": [
          "UNSURVEYED",
          "SURVEYED"
        ],
        "isGeometry": false,
        "description": "Survey status of the tenement boundaries",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "survstatus",
          "survey_status"
        ]
      },
      {
        "name": "special_conditions",
        "dataType": "TEXT",
        "examples": [
          "S"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Special conditions or indicators for the tenement",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "special_in",
          "special_conditions"
        ]
      },
      {
        "name": "holder_address",
        "dataType": "TEXT",
        "examples": [
          "C/- AUSTWIDE MINING TITLE MANAGEMENT PTY LTD,PO BOX 1434,WANGARA,WA,6947,AUSTRALIA"
        ],
        "required": false,
        "isGeometry": false,
        "description": "Address of the primary holder",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "addr1",
          "address",
          "holder_address"
        ]
      },
      {
        "name": "commodities",
        "dataType": "TEXT",
        "examples": [],
        "required": false,
        "isGeometry": false,
        "description": "Target commodities for the tenement",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "commodities",
          "minerals",
          "target_commodities"
        ]
      },
      {
        "name": "country",
        "dataType": "TEXT",
        "examples": [
          "Australia"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Country where the tenement is located",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "country"
        ]
      },
      {
        "name": "jurisdiction",
        "dataType": "TEXT",
        "examples": [
          "Western Australia"
        ],
        "required": true,
        "isGeometry": false,
        "description": "State or territory jurisdiction",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "jurisdiction",
          "state"
        ]
      },
      {
        "name": "source_id",
        "dataType": "TEXT",
        "examples": [
          "wa_ten_1gvkkk",
          "2677905",
          "13874"
        ],
        "required": true,
        "isGeometry": false,
        "description": "Original identifier from the source system",
        "isIdentifier": true,
        "sourceFieldPatterns": [
          "_id",
          "gid",
          "oid"
        ]
      },
      {
        "name": "geometry",
        "dataType": "GEOMETRY",
        "examples": [],
        "required": true,
        "isGeometry": true,
        "description": "Polygon geometry defining the tenement boundaries",
        "isIdentifier": false,
        "sourceFieldPatterns": [
          "_geom",
          "geom",
          "geometry",
          "the_geom"
        ]
      }
    ],
    "confidence": 0.95,
    "description": "Legal mining permits, licenses, and leases granted by government authorities for mineral exploration and extraction activities",
    "geometryType": "POLYGON"
  }
}

{
  "fields": [
    {
      "name": "_id",
      "type": "string",
      "pattern": "wa_ten_[a-z0-9]+",
      "nullable": false,
      "description": "Unique identifier for the tenement record",
      "sampleValues": [
        "wa_ten_7yuscs",
        "wa_ten_20eu1s",
        "wa_ten_ybzedn"
      ]
    },
    {
      "name": "_geom",
      "type": "geometry",
      "nullable": false,
      "description": "WKT geometry representation of the tenement boundary",
      "sampleValues": [
        "POLYGON((121.48813128164811 -28.924844700039515, ...))",
        "MULTIPOLYGON(((118.8833333328579 -28.58333333309061, ...)))"
      ]
    },
    {
      "name": "addr1",
      "type": "string",
      "nullable": true,
      "description": "Primary address of the tenement holder",
      "sampleValues": [
        "60 CAPONI ROAD,BARRAGUP,WA,6209,AUSTRALIA",
        "C/- MCMAHON MINING TITLE SERVICES PTY LTD,PO BOX 6301,EAST PERTH,WA,6892,AUSTRALIA"
      ]
    },
    {
      "name": "addr2",
      "type": "string",
      "nullable": true,
      "description": "Secondary address of the tenement holder",
      "sampleValues": [
        null,
        "C/- TG MINING TITLE SERVICES PTY LTD,PO BOX Z5025 ST GEORGES TERRACE,PERTH,WA,6831,AUSTRALIA"
      ]
    },
    {
      "name": "addr3",
      "type": "string",
      "nullable": true,
      "description": "Tertiary address of the tenement holder",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "addr4",
      "type": "string",
      "nullable": true,
      "description": "Fourth address of the tenement holder",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "addr5",
      "type": "string",
      "nullable": true,
      "description": "Fifth address of the tenement holder",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "addr6",
      "type": "string",
      "nullable": true,
      "description": "Sixth address of the tenement holder",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "addr7",
      "type": "string",
      "nullable": true,
      "description": "Seventh address of the tenement holder",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "addr8",
      "type": "string",
      "nullable": true,
      "description": "Eighth address of the tenement holder",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "addr9",
      "type": "string",
      "nullable": true,
      "description": "Ninth address of the tenement holder",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "enddate",
      "type": "string",
      "pattern": "\\d{13}",
      "nullable": false,
      "description": "End date of the tenement in Unix timestamp milliseconds",
      "sampleValues": [
        "1859587200000",
        "1793318400000",
        "1774828800000"
      ]
    },
    {
      "name": "endtime",
      "type": "string",
      "pattern": "\\d{2}:\\d{2}:\\d{2}",
      "nullable": false,
      "description": "End time of the tenement",
      "sampleValues": [
        "23:59:59"
      ]
    },
    {
      "name": "extract_da",
      "type": "string",
      "pattern": "\\d{13}",
      "nullable": false,
      "description": "Data extraction date in Unix timestamp milliseconds",
      "sampleValues": [
        "1770351515000",
        "1770351535000",
        "1770351489000"
      ]
    },
    {
      "name": "fmt_tenid",
      "type": "string",
      "pattern": "[A-Z] \\d+/\\d+",
      "nullable": false,
      "description": "Formatted tenement identifier",
      "sampleValues": [
        "M 37/708",
        "P 39/5861",
        "E 57/985"
      ]
    },
    {
      "name": "gid",
      "type": "string",
      "nullable": false,
      "description": "Geographic identifier",
      "sampleValues": [
        "2656020",
        "2664910",
        "2661559"
      ]
    },
    {
      "name": "grantdate",
      "type": "string",
      "pattern": "\\d{13}",
      "nullable": false,
      "description": "Grant date of the tenement in Unix timestamp milliseconds",
      "sampleValues": [
        "1196380800000",
        "1540944000000",
        "1459382400000"
      ]
    },
    {
      "name": "granttime",
      "type": "string",
      "pattern": "\\d{2}:\\d{2}:\\d{2}",
      "nullable": false,
      "description": "Grant time of the tenement",
      "sampleValues": [
        "00:00:00",
        "12:30:00",
        "15:25:44"
      ]
    },
    {
      "name": "holder1",
      "type": "string",
      "nullable": true,
      "description": "Primary tenement holder name",
      "sampleValues": [
        "AHLDEN, MANFRED",
        "KIN EAST PTY LTD",
        "LEGENDRE, BRUCE ROBERT"
      ]
    },
    {
      "name": "holder2",
      "type": "string",
      "nullable": true,
      "description": "Secondary tenement holder name",
      "sampleValues": [
        null,
        "ROX (MURCHISON) PTY LTD"
      ]
    },
    {
      "name": "holder3",
      "type": "string",
      "nullable": true,
      "description": "Third tenement holder name",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "holder4",
      "type": "string",
      "nullable": true,
      "description": "Fourth tenement holder name",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "holder5",
      "type": "string",
      "nullable": true,
      "description": "Fifth tenement holder name",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "holder6",
      "type": "string",
      "nullable": true,
      "description": "Sixth tenement holder name",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "holder7",
      "type": "string",
      "nullable": true,
      "description": "Seventh tenement holder name",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "holder8",
      "type": "string",
      "nullable": true,
      "description": "Eighth tenement holder name",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "holder9",
      "type": "string",
      "nullable": true,
      "description": "Ninth tenement holder name",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "holdercnt",
      "type": "string",
      "nullable": false,
      "description": "Count of tenement holders",
      "sampleValues": [
        "1",
        "2"
      ]
    },
    {
      "name": "legal_area",
      "type": "string",
      "nullable": false,
      "description": "Legal area of the tenement",
      "sampleValues": [
        "29.063",
        "200",
        "14",
        "120.6",
        "44.87"
      ]
    },
    {
      "name": "oid",
      "type": "string",
      "nullable": false,
      "description": "Object identifier",
      "sampleValues": [
        "19010",
        "27515",
        "7270",
        "16503",
        "29692"
      ]
    },
    {
      "name": "special_in",
      "type": "string",
      "nullable": true,
      "description": "Special instructions or conditions",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "st_area_the_geom_",
      "type": "string",
      "nullable": true,
      "description": "Calculated area of the geometry",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "st_perimeter_the_geom_",
      "type": "string",
      "nullable": true,
      "description": "Calculated perimeter of the geometry",
      "sampleValues": [
        null
      ]
    },
    {
      "name": "startdate",
      "type": "string",
      "pattern": "\\d{13}",
      "nullable": false,
      "description": "Start date of the tenement in Unix timestamp milliseconds",
      "sampleValues": [
        "854582400000",
        "1509062400000",
        "1403654400000"
      ]
    },
    {
      "name": "starttime",
      "type": "string",
      "pattern": "\\d{2}:\\d{2}:\\d{2}",
      "nullable": false,
      "description": "Start time of the tenement",
      "sampleValues": [
        "10:00:00",
        "12:30:00",
        "15:25:44"
      ]
    },
    {
      "name": "survstatus",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "SURVEYED",
        "UNSURVEYED"
      ],
      "description": "Survey status of the tenement",
      "sampleValues": [
        "SURVEYED",
        "UNSURVEYED"
      ]
    },
    {
      "name": "tenid",
      "type": "string",
      "pattern": "[A-Z]  \\d+",
      "nullable": false,
      "description": "Tenement identifier with spaces",
      "sampleValues": [
        "M  3700708",
        "P  3905861",
        "E  5700985"
      ]
    },
    {
      "name": "tenstatus",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "LIVE",
        "PENDING"
      ],
      "description": "Status of the tenement",
      "sampleValues": [
        "LIVE",
        "PENDING"
      ]
    },
    {
      "name": "type",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "MINING LEASE",
        "PROSPECTING LICENCE",
        "EXPLORATION LICENCE"
      ],
      "description": "Type of mining tenement",
      "sampleValues": [
        "MINING LEASE",
        "PROSPECTING LICENCE",
        "EXPLORATION LICENCE"
      ]
    },
    {
      "name": "unit_of_me",
      "type": "string",
      "nullable": false,
      "enumValues": [
        "HA.",
        "BL."
      ],
      "description": "Unit of measurement for the area",
      "sampleValues": [
        "HA.",
        "BL."
      ]
    },
    {
      "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 the record was mirrored/synchronized",
      "sampleValues": [
        "2026-02-09 19:18:10.247404+00"
      ]
    },
    {
      "name": "geom",
      "type": "geometry",
      "nullable": false,
      "description": "Binary geometry representation (WKB hex encoded)",
      "sampleValues": [
        "0103000020E6100000010000000900000053B5FC8A3D5F5E40748C4C9FC2EC3CC0..."
      ]
    }
  ],
  "semantics": {
    "idFields": [
      "_id",
      "fmt_tenid",
      "tenid",
      "gid",
      "oid"
    ],
    "nameFields": [
      "holder1",
      "holder2",
      "holder3",
      "holder4",
      "holder5",
      "holder6",
      "holder7",
      "holder8",
      "holder9"
    ],
    "statusFields": [
      "tenstatus",
      "survstatus"
    ],
    "fieldMeanings": {
      "_id": "Unique record identifier",
      "gid": "Geographic identifier",
      "oid": "Object identifier",
      "geom": "Binary geometry data",
      "type": "Tenement type classification",
      "_geom": "WKT geometry boundary",
      "addr1": "Primary holder address",
      "addr2": "Secondary holder address",
      "tenid": "Raw tenement identifier",
      "enddate": "Tenement expiry date",
      "endtime": "Tenement expiry time",
      "holder1": "Primary tenement holder",
      "holder2": "Secondary tenement holder",
      "fmt_tenid": "Formatted tenement ID",
      "grantdate": "Date tenement was granted",
      "granttime": "Time tenement was granted",
      "holdercnt": "Number of holders",
      "startdate": "Tenement start date",
      "starttime": "Tenement start time",
      "tenstatus": "Current tenement status",
      "extract_da": "Data extraction timestamp",
      "legal_area": "Legal area measurement",
      "special_in": "Special conditions",
      "survstatus": "Survey completion status",
      "unit_of_me": "Area measurement unit",
      "_mirrored_at": "Data synchronization timestamp"
    },
    "geometryFields": [
      "_geom",
      "geom"
    ],
    "commodityFields": []
  },
  "confidence": 0.95,
  "entityType": "tenement",
  "recordCount": 100
}