MTA - Mineral Reserve Sites Business View

2342 views (8 recent)

Published by the Ministry of Energy, Mines and Low Carbon Innovation - 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


The mineral/placer site spatial information is made available for public viewing (Mineral Titles Online, and for download (BC Geographic Distribution Service).

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 2013-11-14
Record Last Modified 2021-05-17
Resource Status onGoing

Object Description


Short Name: MTSTSP
Comments: MTA_SITE_SP is a replication of MTA_SPATIAL.MTA_SITE_SVW (MEMPRD/Operational) that defines areas within the province of British Columbia where mineral, placer and coal claims are restricted. This feature class contains a detailed set of attributes.

Column Name Short Name Data Type Data Precision Comments
SITE_NUMBER_ID SITE_NO_ID NUMBER 10 SITE_NUMBER_ID: The unique number that identifies the reserve site as supplied by the business area which is used as the primary key.
SITE_NAME SITE_NAME VARCHAR2 50 SITE_NAME: The name associated with the reserve site.
MTA_SITE_ORDER_RESTR_CODE RESTR_CODE VARCHAR2 1 MTA_SITE_ORDER_RESTR_CODE: Site order restriction codes for a reserve site. Possible values include: 1 Post Recreation Area (1), Administrative (A), Conditional (C), Heritage (H), Designated Lease (L), No Registration (N), Other (O), Release Required (R), Surface Restriction (S), Designated Claim (T).
MTA_SITE_ORDER_RESTR_DESC RSTRCTN VARCHAR2 500 MTA_SITE_ORDER_RESTR_DESC: Describes site order restriction, e.g., Conditional, No Registration.
MTA_SITE_REASON_CODE RSN_CODE VARCHAR2 4 MTA_SITE_REASON_CODE: Contains the reason code for the current restriction reason, e.g., 1 Post Recreation Area (1POS), Access Road (ACCE), Administrative (ADM), Agriculture (AGRI), Air Strip (AIRS).
MTA_SITE_REASON_DESCRIPTION REASON VARCHAR2 500 MTA_SITE_REASON_DESCRIPTION: Describes the current restriction reason for the site, e.g., 1 Post Recreation Area, Access Road, Administrative, Agriculture, Air Strip.
RESERVE_TYPE RSRV_TYPE VARCHAR2 500 RESERVE_TYPE: Indicates whether a site is a Mineral Land Reserve (applies to mineral and/or placer titles) and/or a Coal Land Reserve (applies to coal titles), e.g., mineral, placer and/or coal.
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: Yes (Y), No (N).
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: Yes (Y), No (N).
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: Yes (Y), No (N).
TOTAL_AREA HECTRS NUMBER 13 TOTAL_AREA: The area of the reserve expressed in hectares.
PROJECT_NAME PRJ_NAME VARCHAR2 50 PROJECT_NAME: The descriptive project name concerning the reserve or alienation project.
REQUESTOR REQSTR VARCHAR2 150 REQUESTOR: The name of the person or organization requesting the reserve.
CLIENT_NUMBER_ID CLN_NUM_ID NUMBER 6 CLIENT_NUMBER_ID: The unique client identifier of the requestor.
EFFECTIVE_DATE EFFCTDATE DATE 7 EFFECTIVE_DATE: The date the reserve site becomes active.
DEPOSITED_DATE DPSTDATE DATE 7 DEPOSITED_DATE: The date when the BC Regulation, Order In Council, and/or Ministerial Order that establishes the reserve is deposited.
BC_REGULATION_NUMBER BC_REG_NUM VARCHAR2 6 BC_REGULATION_NUMBER: The British Columbia Regulation Number associated with the reserve, e.g., a value of 017087 denotes BC Regulation Number 170 (from the first four digits), deposited in the year 1987 (from the last two digits)
ORDER_IN_COUNCIL_NUMBER OIC_NUM VARCHAR2 6 ORDER_IN_COUNCIL_NUMBER: The Order in Council (OIC) number associated with the reserve. OIC is a decision issued under the authority of the Lieutenant Governor.
MINISTERIAL_ORDER_NUMBER MO_NUM VARCHAR2 6 MINISTERIAL_ORDER_NUMBER: The Ministry's Order number that is associated with the reserve.
FILE_ID FILE_ID VARCHAR2 15 FILE_ID: The file number of the hard copy file associated with the site.
REVIEW_DATE RVWDATE DATE 7 REVIEW_DATE: The review date is the date that the reserve might be eligible for review.
SUNSET_DATE SNSTDATE DATE 7 SUNSET_DATE: Some older reserves were given sunset dates, which indicate the date the reserve could be reviewed for cancellation.
REVISION_NUMBER REVSN_NO NUMBER 2 REVISION_NUMBER: Describes the version of the site to tracks the number of modifications.
UPDATE_TIMESTAMP UD_TIMSTMP DATE 7 UPDATE_TIMESTAMP: The date and time the record was last changed.
ENTRY_TIMESTAMP TIMESTAMP DATE 7 ENTRY_TIMESTAMP: The date and time the information was entered.
FEATURE_CODE FTRCD VARCHAR2 10 FEATURE_CODE: A feature code is most importantly a means of linking a feature to its name and definition.
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