MTA - Mineral, Placer and Coal History Tenure SP
2693 views (20 recent)Published by the Ministry of Energy, Mines and Petroleum Resources - Mineral Titles
Licensed under Open Government Licence - British Columbia
Data and Resources
BC Geographic Warehouse Custom Downloadother
WMS getCapabilities requestwms
For use in viewers such as ESRI tools use this truncated link:...
KML Network Linkkml
For use in viewers such as Google Earth Click here for information on how to...
The historical mineral, placer and coal tenure spatial information is made available for public viewing. Up-to-date tenures are available for download for FMC holders, basic/business BCeID users, contractors and government.
|Name||Karen Samuelson (pointOfContact)|
|Organization||Ministry of Energy, Mines and Petroleum Resources|
Access & Security
|Who can view this dataset?||Public|
|Who can download this dataset?||Public|
|Record Last Modified||2019-08-01|
Object Name: WHSE_MINERAL_TENURE.MTA_ACQUIRED_TENURE_HISTORY_SP
Short Name: MTCQRDTNRH
Comments: ACQUIRED TENURE HISTORY SP is a replication of the tenure history table from the operational production enviornment (MTA_SPATIAL.MTA_ACQUIRED_TENURE_HIST_POLY) which defines the spatial location of terminated mineral, placer and coal tenures. This is a multipart polygon layer.
|Column Name||Short Name||Data Type||Data Precision||Comments|
|TENURE_HISTORY_ID||TENHIST_ID||NUMBER||10||TENURE HISTORY ID is a user maintained unique identification number. This is a primary key. e.g., 128948|
|TENURE_NUMBER_ID||TENNUM_ID||NUMBER||10||TENURE NUMBER ID�: The unique number that identifies a mineral tenure as supplied by the business area. e.g., 358746|
|TENURE_TYPE_CODE||TYPE_CODE||VARCHAR2||1||TENURE TYPE CODE: Tenure type codes for a tenure. Possible values include C, M, P.|
|TENURE_TYPE_DESCRIPTION||TYPE_DESC||VARCHAR2||10||TENURE TYPE DESCRIPTION: Tenure type description for a tenure. Possible values include Coal, Mineral, Placer.|
|REVISION_NUMBER||REV_NUM||NUMBER||2||REVISION NUMBER: Describes the version of the tenure to track modifications. Previous revisions are moved to the tenure history layer. e.g., 0,1,2,3|
|GEOMETRY||GEOMETRY||SDO_GEOMETRY||1||GEOMETRY is the column used to reference the spatial coordinates defining the feature.|
|OBJECTID||OBJECTID||NUMBER||38||OBJECTID is a required attribute of feature classes and object classes in a geodatabase.|
|SE_ANNO_CAD_DATA||BLOB||4000||SE_ANNO_CAD_DATA is a binary column used by spatial tools to store annotation, curve features and CAD data when using the SDO_GEOMETRY storage data type.|
|FEATURE_AREA_SQM||NUMBER||19||FEATURE_AREA_SQM is the system calculated area of a two-dimensional polygon in square meters|
|FEATURE_LENGTH_M||NUMBER||19||FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters|