MTA - Mineral, Placer and Coal History Tenure SP

2693 views (20 recent)

Published by the Ministry of Energy, Mines and Low Carbon Innovation - Mineral Titles
Licensed under Open Government Licence - British Columbia

Holds historical data for mineral, placer claims and leases, as well as, coal license applications, licenses and leases within the Province of British Columbia. This layer is utilized by Mineral Titles Online tenure history on the mineral, placer and coal viewers, respectively.

Data and Resources

Dataset Extent

Latitude: 48.0° to 60.0°
Longitude: -139.5° to -113.5°

Additional Information


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.

More Information

Contact Information

NameKaren Samuelson (pointOfContact)
OrganizationMinistry of Energy, Mines and Low Carbon Innovation
Sub-OrganizationMineral Titles

Access & Security

Who can view this dataset? Public
Who can download this dataset?Public

Metadata Information

Record Published 2014-12-11
Record Last Modified 2021-06-12
Resource Status onGoing

Object Description


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 AREA_SQM NUMBER 19 FEATURE_AREA_SQM is the system calculated area of a two-dimensional polygon in square meters
FEATURE_LENGTH_M FEAT_LEN NUMBER 19 FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters