MTA - Mineral Reserve Sites Business View

2342 views (8 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 site spatial information is made available for public viewing (Mineral Titles Online, www.mtonline.gov.bc.ca) and for download (BC Geographic Distribution Service).

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

Object Description

Object Name: WHSE_MINERAL_TENURE.MTA_SITE_SP

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).
MTA_SITE_STATUS_DESCRIPTION STATUS VARCHAR2 500 MTA_SITE_STATUS_DESCRIPTION: Describes the site status. Possible values are: APPLICATION, Cancellation, PASSED, TERMINATED.
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 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