MTA - Mineral, Placer and Coal Tenure GOV SP

457 views (8 recent)

Published by the Ministry of Energy, Mines and Petroleum Resources - Mineral Titles
Licensed under Access Only

A restricted dataset that is replicated from the operational MEMPRD database for government staff that holds data for mineral, placer claims and leases, as well as, coal license applications, licenses and leases within the Province of British Columbia. For a dataset available for public viewing, please refer to http://catalogue.data.gov.bc.ca/dataset/mta-mineral-placer-and-coal-titles.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

Additional attributes for mineral, placer and tenure spatial information is made available for internal staff 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)
EmailMineral.Titles@gov.bc.ca
OrganizationMinistry of Energy, Mines and Petroleum Resources
Sub-OrganizationMineral Titles

Access & Security

Who can view this dataset? Government
Who can download this dataset?Government

Metadata Information

Record Published 2014-12-11
Record Last Modified 2019-05-04
Resource Status onGoing

Object Description

Object Name: WHSE_MINERAL_TENURE.MTA_ACQUIRED_TENURE_GOV_SP

Short Name: MTCQRDTNRG
Comments: MTA_ACQUIRED_TENURE_GOV_SP originates from MTA_ACQUIRED_TENURE_POLY which defines the spatial location of acquired mineral, placer and coal tenures. This feature class contains a detailed set of attributes used to revise MTA_ACQUIRED_TENURE_SVW and to create MTA_ACQUIRED_TENURE_GOV_SVW for internal government use.

Column Name Short Name Data Type Data Precision Comments
TENURE_NUMBER_ID TNRNMBRD NUMBER 10 TENURE_NUMBER_ID? The unique number (primary key) that identifies a mineral tenure as supplied by the business area.
CLAIM_NAME CLAIM_NAME VARCHAR2 25 CLAIM_NAME: The name of the claim as authored by the original tenure owner. The claim name associated with the Mineral Tenure.
TENURE_TYPE_CODE TNRTPCD VARCHAR2 1 TENURE_TYPE_CODE: Tenure type codes for a tenure. Possible values include Coal(C), Mineral (M), Placer (P).
TENURE_TYPE_DESCRIPTION TNRTPDSCRP VARCHAR2 500 TENURE_TYPE_DESCRIPTION: Describes the type of tenure, e.g., Coal, Mineral, Placer.
TENURE_SUB_TYPE_CODE TNRSBTPCD VARCHAR2 1 TENURE_SUB_TYPE_CODE: Contains the codes to describe the stage or level of the tenure. Possible values include: Application(A), Claim(C), Lease(L), License(S).
TENURE_SUB_TYPE_DESCRIPTION TNRSBTPDSC VARCHAR2 500 TENURE_SUB_TYPE_DESCRIPTION: Describes the current stage for the tenure sub type, e.g., APPLICATION, CLAIM, LEASE, LICENSE.
TITLE_TYPE_CODE TTLTPCD VARCHAR2 4 TITLE_TYPE_CODE: Title type codes to further define the tenure sub type, e.g., One Post Claim (MC1), Two Post Cliam (MC2), Four Post Claim (MC4), Mining Lease (ML), Placer Claim (PC), Placer Lease (PL).
TITLE_TYPE_DESCRIPTION TTLTPDSC VARCHAR2 500 TITLE_TYPE_DESCRIPTION: Describes the title type, e.g., One Post Claim, Two Post Claim, Four Post Claim, Mining Lease, Placer Claim, Placer Lease.
ISSUE_DATE ISSUE_DATE DATE 7 ISSUE_DATE: The date the tenure is issued.
GOOD_TO_DATE GDTDT DATE 7 GOOD_TO_DATE: The expiry date of the claim.
AREA_IN_HECTARES RNHCTRS NUMBER 13 AREA_IN_HECTARES: The registered area of the tenure, in hectares, on record. This area is used for payment calculations.
PROTECTED_IND PROTECTED VARCHAR2 1 PROTECTED_IND:?Indicates whether a title is protected from automatic forfeiture by order of the Chief Gold Commissioner.?Though a protected title may have a GOOD_TO_DATE that has passed, the title is still active (in good standing).?Values are, Yes Protected (Y) and Not Protected (N), the later being the default
REVISION_NUMBER RVSNNMBR NUMBER 2 REVISION_NUMBER: Describes the version of the tenure to track modifications. Previous revisions are moved to the tenure history layer.
TAG_NUMBER TAG_NUMBER VARCHAR2 9 TAG_NUMBER: Used for legacy (staked) claims only. The tag number refers to the serial number on a metal claim staking tag purchased at a government office.
CLIENT_NUMBER_ID CLIENTNUM NUMBER 6 CLIENT_NUMBER_ID: Unique identification number assigned to a client. In industry, this is known as the Free Miner Certificate (FMC) number (correctly, an FMC number is a certificate number that is renewed annually and is linked to this client number).
OWNER_NAME OWNER_NAME VARCHAR2 150 OWNER_NAME: The name of an owner of the title.營f there is more than one owner (reflected in NUMBER_OF_OWNERS), further investigation may be conducted in Mineral Titles Online or by using MTA_CLIENT_TENURE_XREF.
PERCENT_OWNERSHIP PRCNTOWNER NUMBER 8 PERCENT_OWNERSHIP: The percentage of a mineral tenure owned by the client (CLIENT_NUMBER).
NUMBER_OF_OWNERS NUM_OWNERS NUMBER 38 NUMBER_OF_OWNERS: The number of owners for a given title.
CASH_IN_LIEU_EVENT_COUNT CIL_EVENT NUMBER 38 CASH_IN_LIEU_EVENT_COUNT: The number of cash in lieu (CIL), also known as payment instead of exploration and development work, events registered on a title.
STATEMENT_OF_WORK_EVENT_COUNT SOW_EVENT NUMBER 38 STATEMENT_OF_WORK_EVENT_COUNT:?The number of statement of work (SOW), also known as registration of exploration and development, events registered on a title.
COMPLAINTS_EVENT_COUNT COMP_EVENT NUMBER 38 COMPLAINTS_EVENT_COUNT:?The number of complaints under the Mineral Tenure Act registered on a title.
OWNERSHIP_TRANSFER_EVENT_COUNT OTRA_EVENT NUMBER 38 OWNERSHIP_TRANSFER_EVENT_COUNT: The number of bill of sale initiation events registered on a title.
REDUCTION_EVENT_COUNT REDU_EVENT NUMBER 38 REDUCTION_EVENT_COUNT:?The number of tenure reduction events registered on a title. Reductions are only allowed on cell claims.
ENTRY_TIMESTAMP NTRTMSTMP DATE 7 ENTRY_TIMESTAMP: System generated. The date and time the information was entered.
ENTRY_USERID NTRSRD VARCHAR2 30 ENTRY_USERID: System generated. The identification of the user that created the initial record.
UPDATE_TIMESTAMP PDTTMSTMP DATE 7 UPDATE_TIMESTAMP: System generated. The date and time of the last update to the record.
UPDATE_USERID PDTSRD VARCHAR2 30 UPDATE_USERID: System generated. The identification of the user that made the last update to the record.
TERMINATION_DATE TRMNTNDT DATE 7 TERMINATION_DATE: Date of termination date for a tenure.
TERMINATION_TYPE_DESCRIPTION TRMNTNTPDS VARCHAR2 500 TERMINATION_TYPE_DESCRIPTION: When a tenure is terminated the system uses a code to define the termination. Possible values include Abandonment, Amalgamated, Conversion, Demised, Forfeiture, Subdivision.
FEATURE_CODE FCODE 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