MTA - Mineral & Coal Land Reserve History SP

783 views (6 recent)

Published by the Ministry of Energy, Mines and Petroleum Resources - Mineral Titles
Licensed under Open Government Licence - British Columbia

Defines areas within the province of British Columbia where mineral, placer and coal titles are restricted and placer titles are permitted. This business view contains a detailed set of attributes.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

The mineral/placer/coal site spatial information is made available for download (BC Geographic Distribution Service).

More Information

Contact Information

NameKaren Samuelson (pointOfContact)
Emailmineral.titles@gov.bc.ca
OrganizationMinistry of Energy, Mines and Petroleum Resources
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 2019-05-04
Resource Status onGoing

Object Description

Object Name: WHSE_MINERAL_TENURE.MTA_SITE_HISTORY_SP

Short Name: MTSTHSTRSP
Comments: SITE HISTORY SP is a replication of MTA_SPATIAL.MTA_SITE_HIST_POLY (MEMPRD/Operational) that defines terminated areas within the province of British Columbia where mineral, placer and coal claims are restricted. This is a multipart polygon layer.

Column Name Short Name Data Type Data Precision Comments
SITE_HISTORY_ID SITEHISTID NUMBER 10 SITE HISTORY ID is a user maintained unique identification number. This is a primary key. e.g., 86655
SITE_NUMBER_ID SITENUM_ID NUMBER 10 SITE NUMBER ID: The unique number that identifies the reserve site as supplied by the business area. e.g., 394335
SITE_STATUS_CODE SITESTATUS VARCHAR2 25 SITE STATUS CODE is a field to identify the phase of the site. Possible Values include: APPL (Application), PASS (Passed/Legislated), TERM (Terminated)
SITE_ORDER_RESTRICTION_CODE RSTRT_CODE VARCHAR2 1 SITE ORDER RESTRICTION CODE: Site order restriction codes for a reserve site. Possible values include: (1) 1 Post Recreation Area, (A) Administrative, (C) Conditional, (H) Heritage, (L) Designated Lease, (N) No Registration, (O) Other, (R) Release Required, (S) Surface Restriction, (T) Designated Claim.
SITE_ORDER_RESTRICTION_DESC RSTRT_DESC VARCHAR2 25 SITE ORDER RESTRICTION DESC: Site order restriction codes for a reserve site. Possible values include: 1 Post Recreation Area, Administrative, Conditional, Heritage, Designated Lease, No Registration, Other, Release Required, Surface Restriction, Designated Claim.
REVISION_NUMBER REV_NUM NUMBER 2 REVISION NUMBER: Describes the version of the site to tracks the number of modifications. e.g., 0,1,2,3 or 4
SITE_COAL_IND COAL_IND VARCHAR2 1 SITE COAL IND: Is a flag to indicate if the reserve site applies to coal titles. Possible values are: Y (Yes), N (No).
SITE_MINERAL_IND MIN_IND VARCHAR2 1 SITE MINERAL IND: Is a flag to indicate if the reserve site applies to mineral titles. Possible values are: Y (Yes), N (No).
SITE_PLACER_IND PLACER_IND VARCHAR2 1 SITE PLACER IND: Is a flag to indicate if the reserved site applies to placer titles. Possible values are: Y (Yes), N (No).
TERMINATION_DATE TERM_DATE DATE 7 TERMINATION DATE: Date the site is no longer in effect.
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