MINFILE Inventory Database

674 views (17 recent)

Published by the Ministry of Energy, Mines and Petroleum Resources - BC Geological Survey
Licensed under Access Only

Mineral Inventory describes the extent and volume of the reserve contained within a mineral deposit described by its referenced MINFILE_File record. MINFILE contains geological, location and economic information on 14,8000 metallic, industrial mineral and coal occurrences in British Columbia. The database is used by government, industry and academia for resource management, land-use planning, exploration and research.

The Inventory 'Reserve' category is used only for an inventory in an operating mine or a mine near production. Ore reserves are reported as Proven, Probable and Possible. The Resource category is used for all other inventories. Resources are reported as Measured, Indicated and Inferred. A combination of categories is reported as Combined. If the category is not known then Unclassified is used. Sample data can be entered using the Assay/Analysis category. The reserves/resources are reported in tonnes with the grade of commodities.

In general, the inventory is identified by occurrence, zone name and year. There may be an unlimited number of ore zones per occurrence. In addition, each zone name may have inventory for each category. Each ore zone can have a maximum of two inventory calculations per year, per category (e.g., Calculation A & B). This allows for changes in calculations due to grade-tonnage relationships; calculation A may be high-grade low tonnage while calculation B may reflect a low-grade tonnage. Generally, only data for the most recent year is maintained in the database. Only one calculation may be used per ore zone in the ASSAY/ANALYSIS category. The ASSAY/ANALYSIS data cannot coexist with reserves information for any given ore zone name.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

The database is used by government, industry and academia for resource management, land-use planning, exploration and research.

Lineage Statement

MINFILE contains 14,800 metallic, industrial mineral and coal occurrences for British Columbia. Each of these occurrences contain 84 data elements describing mineral deposits in terms of geography, geology and economics. Started out as a card file, then to VAX, then to a microcomputer application, and finally to a web-based searcheable database, with display on interactive maps.

More Information

Contact Information

NameLarry Jones (pointOfContact)
EmailLarry.Jones@gov.bc.ca
OrganizationMinistry of Energy, Mines and Petroleum Resources
Sub-OrganizationBC Geological Survey

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-03
Resource Status onGoing

Object Description

Object Name: WHSE_MINERAL_TENURE.MINFIL_RESERVE

Short Name: MINFIL_RSR
Comments: MINFILE RESERVE describes the extent and volume of the reserve or resource contained within a mineral deposit described by its referenced MINFILE record.

Column Name Short Name Data Type Data Precision Comments
MINFIL_RESERVE_ID MNFL_RS_ID NUMBER 10 MINFIL RESERVE ID is the system generated unique identification number. This is a primary key for this dataset, e.g. 1.
MINFILE_NUMBER MNFL_NMBR VARCHAR2 9 MINFILE NUMBER is a unique 9-character number used to identify it within the computer database, in printouts and on maps for each mineral occurrence. e.g. 082ENE003.
MINFILE_NAME MINFILE_NM VARCHAR2 30 MINFILE NAME is the most common or historically relevant name for a mineral occurrence, e.g. HIGHLAND VALLEY COPPER.
ORE_ZONE_CODE ORE_ZN_CD VARCHAR2 5 ORE ZONE CODE is a unique number for identifying the ore zone that the MINFILE reserve is located in. e.g., 96645 COPPER HEAD; 96645 is the code; Copper Head is the code description. A numeric cross-reference to the description.
ORE_ZONE_DESCRIPTION ORE_ZN_DSC VARCHAR2 30 ORE ZONE DESCRIPTION is the definition of the ORE ZONE CODE and the name of the distinct unit or ore zone of a deposit for which a reserve or resource calculation is made. Several zones may be associated with each deposit and may include categories in both the reserve and resource fields, e.g. DUMP.
CALCULATION_YEAR CLCLTN_YR NUMBER 4 CALCULATION YEAR is the year the inventory figures were published, e.g. 1899.
INVENTORY_CATEGORY_CODE INV_CAT_CD VARCHAR2 2 INVENTORY CATEGORY CODE is the code of the inventory, if any, associated with a mineral occurrence. Inventory is expressed as reserve, resource or best assay. The codes and descriptions are detailed in section 9 of the MINFILE Coding Manual: http://www.empr.gov.bc.ca/Mining/Geoscience/MINFILE/ProductsDownloads/MINFILEDocumentation/CodingManual/Pages/Inventory.aspx, e.g. BA.
INVENTORY_CATEGORY_DESCRIPTION INVNTRY_CN VARCHAR2 30 INVENTORY CATEGORY DESCRIPTION is the description of the INVENTORY CATEGORY CODE, if any, and those associated with a mineral occurrence. Inventory is expressed as reserve, resource or best assay. The Reserve category is used only for an inventory in an operating mine or a mine near production. Sufficient information is available to form the basis of a preliminary mine production plan. Factors that affect ore reserve estimates are geological, economic, mining, metallurgical, marketing, environmental, social and governmental conditions. Ore reserves are reported as Proven, Probable and Possible. The Resource category is used for all other inventories and are reported as Measured, Indicated and Inferred. Valuable or useful material is quantified on the basis of geoscientific data and expected economic merit. Mine, metallurgical, price and cost data are not necessarily available. In reporting a resource, there is an implication that there are reasonable prospects for eventual economic exploitation. A combination of categories is reported as Combined. If the category is not known then Unclassified is used. Sample data can be entered using the Assay/Analysis category. The reserves/resources are reported in tonnes with the grade of commodities. The codes and descriptions are detailed in section 9 of the MINFILE Coding Manual: http://www.empr.gov.bc.ca/Mining/Geoscience/MINFILE/ProductsDownloads/MINFILEDocumentation/CodingManual/Pages/Inventory.aspx, e.g. Assay/analysis.
A_OR_B_CALCULATION_IND A_R_B_CLCD VARCHAR2 1 A OR B CALCULATION IND is the indicator of two inventory calculations. In general, the inventory is identified by occurrence, zone name and year. There may be an unlimited number of ore zones per occurrence. In addition, each zone name may have inventory for each category. Each ore zone can have a maximum of two inventory calculations per year, per category (e.g., Calculation A & B). One calculation type ('A') must be entered for each Category. A second calculation MAY be used (labeled 'B'), EXCEPT for "Assay" data, which has only one ('A') calculation.
COMMODITY_CODE1 COMDTY_CD1 VARCHAR2 2 COMMODITY CODE1 is the code of the first commodity remaining in this mineral reserve as listed within, e.g. AG.
COMMODITY_CODE2 COMDTY_CD2 VARCHAR2 2 COMMODITY CODE2 is the code of the second commodity remaining in this mineral reserve as listed within, e.g. AS.
COMMODITY_CODE3 COMDTY_CD3 VARCHAR2 2 COMMODITY CODE3 is the code of the third commodity remaining in this mineral reserve as listed within, e.g. AU.
COMMODITY_CODE4 COMDTY_CD4 VARCHAR2 2 COMMODITY CODE4 is the code of the fourth commodity remaining in this mineral reserve as listed within, e.g. PB.
COMMODITY_CODE5 COMDTY_CD5 VARCHAR2 2 COMMODITY CODE5 is the code of the fifth commodity remaining in this mineral reserve as listed within, e.g. ZN.
COMMODITY_CODE6 COMDTY_CD6 VARCHAR2 2 COMMODITY CODE6 is the code of the sixth commodity remaining in this mineral reserve as listed within, e.g. WO.
COMMODITY_DESCRIPTION1 COMDTY_DS1 VARCHAR2 30 COMMODITY DESCRIPTION1 is the description of the same numbered commodity code as listed within, e.g. Silver.
COMMODITY_DESCRIPTION2 COMDTY_DS2 VARCHAR2 30 COMMODITY DESCRIPTION2 is the description of the same numbered commodity code as listed within, e.g. Antimony.
COMMODITY_DESCRIPTION3 COMDTY_DS3 VARCHAR2 30 COMMODITY DESCRIPTION3 is the description of the same numbered commodity code as listed within, e.g. Gold.
COMMODITY_DESCRIPTION4 COMDTY_DS4 VARCHAR2 30 COMMODITY DESCRIPTION4 is the description of the same numbered commodity code as listed within, e.g. Lead.
COMMODITY_DESCRIPTION5 COMDTY_DS5 VARCHAR2 30 COMMODITY DESCRIPTION5 is the description of the same numbered commodity code as listed within, e.g. Zinc.
COMMODITY_DESCRIPTION6 COMDTY_DS6 VARCHAR2 30 COMMODITY DESCRIPTION6 is the description of the same numbered commodity code as listed within, e.g. Tungsten.
COMMODITY_GRADE1 CMMDTY_GR1 NUMBER 15 COMMODITY GRADE1 is the amount of metallic or industrial mineral found in COMMODITY CODE1, e.g. 9587.8.
COMMODITY_GRADE2 CMMDTY_GR2 NUMBER 15 COMMODITY GRADE2 is the amount of metallic or industrial mineral found in COMMODITY CODE2, e.g. 9587.9.
COMMODITY_GRADE3 CMMDTY_GR3 NUMBER 15 COMMODITY GRADE3 is the amount of metallic or industrial mineral found in COMMODITY CODE3, e.g. 9587.10.
COMMODITY_GRADE4 CMMDTY_GR4 NUMBER 15 COMMODITY GRADE4 is the amount of metallic or industrial mineral found in COMMODITY CODE4, e.g. 9587.11.
COMMODITY_GRADE5 CMMDTY_GR5 NUMBER 15 COMMODITY GRADE5 is the amount of metallic or industrial mineral found in COMMODITY CODE5, e.g. 9587.12.
COMMODITY_GRADE6 CMMDTY_GR6 NUMBER 15 COMMODITY GRADE6 is the amount of metallic or industrial mineral found in COMMODITY CODE6, e.g. 9587.13.
COMMODITY_QUANTITY CMMDTY_QNY NUMBER 12 COMMODITY QUANTITY is the reserves or resources quoted in metric tonnes, e.g. 998000000.
RESERVE_COMMENT RSRV_CMNT VARCHAR2 600 RESERVE COMMENT is a free-format field to identify information on cut-off grades or other data pertinent to the inventory figures, e.g. Assessment Report 12815.
RESERVE_REFERENCE RSRV_REF VARCHAR2 300 RESERVE REFERENCE is the source of the inventory figures. Reserves and resources are not calculated by Ministry of Energy, Mines and Petroleum Resources personnel but are quoted from referenced industry sources and/or publications. Due to differences in identifying categories in the data sources, Ministry personnel may occasionally have to interpret which category the figures are placed into. The reader should refer to the original data for detailed information on the calculation, e.g. Western Canada Mining News, Sept.13, 1957 and CMH 1985-1986, p. 295.
REPORT_ON_IND RPRT_N_ND VARCHAR2 1 REPORT ON IND is an indicator to flag if the reserve/resource should be reported on in our publications or not. It is also useful to avoid double counting when aggregating grade and tonnage, e.g. Y or N.
LATITUDE_DECIMAL LTTD_DCML NUMBER 8 LATITUDE DECIMAL is the latitude position of this report measured in decimal degrees, e.g. 49.095.
LATITUDE_DEGREES LTTD_DGRS NUMBER 2 LATITUDE DEGREES is the unsigned latitude position of this mineral occurrence measured in degrees, as in Degrees / Minutes / Seconds, using North American Datum of 1983 (NAD83), e.g. 49.
LATITUDE_MINUTES LTTD_MNTS NUMBER 2 LATITUDE MINUTES is the latitude position of this mineral occurrence measured in minutes, as in Degrees / Minutes / Seconds, using North American Datum of 1983 (NAD83), e.g. 5.
LATITUDE_SECONDS LTTD_SCNDS NUMBER 2 LATITUDE SECONDS is the latitude position of this mineral occurrence measure in seconds, as in Degrees / Minutes / Seconds, using North American Datum of 1983 (NAD83), e.g. 42.
LATITUDE_HEMISPHERE LTTD_HMSPE VARCHAR2 1 LATITUDE HEMISPHERE is the latitude hemisphere of the aforementioned latitude position. N- Northern hemisphere, S - Southern hemisphere, e.g. N.\
LONGITUDE_DECIMAL LNGTD_DCML NUMBER 9 LONGITUDE DECIMAL is the negative-signed longitude position of this report measured in decimal degrees, e.g. -118.651667.
LONGITUDE_DEGREES LNGTD_DGRS NUMBER 3 LONGITUDE DEGREES is the unsigned longitude position of this notice of work measured in degrees, as in Degrees / Minutes / Seconds, using North American Datum of 1983 (NAD83) which is an earth-centered datum based on the Geodetic Reference System of 1980, e.g. 118.
LONGITUDE_MINUTES LNGTD_MNTS NUMBER 2 LONGITUDE MINUTES is the longitude position of this mineral occurrence measured in minutes, as in Degrees / Minutes / Seconds, using North American Datum of 1983 (NAD83), e.g. 39.
LONGITUDE_SECONDS LNGTD_SCNS NUMBER 2 LONGITUDE SECONDS is the longitude position of this mineral occurrence measured in seconds, as in Degrees / Minutes / Seconds, using North American Datum of 1983 (NAD83), e.g. 6.
LONGITUDE_HEMISPHERE LNGTD_HMSE VARCHAR2 1 LONGITUDE HEMISPHERE is the longitude hemisphere of the aforementioned longitude position. E - Eastern hemisphere, W - Western hemisphere, e.g. W.
UTM_ZONE UTM_ZONE NUMBER 2 UTM ZONE is the Universal Transverse Mercator Zone being for this mineral occurrence, e.g. 11.
UTM_NORTHING UTM_NORTH NUMBER 7 UTM NORTHING is the Universal Transverse Mercator Northing distance for this mineral occurrence measured in meters from the equator, using North American Datum of 1983 (NAD83), e.g. 5439330.
UTM_EASTING UTM_EAST NUMBER 6 UTM EASTING is the Universal Transverse Mercator Easting distance for this mineral occurrence measured in meters from the center line of the Universal Transverse Mercator zone, using North American Datum of 1983 (NAD83), e.g. 379425.
DATUM_REFERENCE DTM_RFRNCE VARCHAR2 6 DATUM REFERENCE is the reference geodetic datum for defining the location of this mineral occurrence, e.g. NAD 83.
FEATURE_CODE FEATURE_CD VARCHAR2 10 FEATURE CODE is an alphanumeric value based on the Canadian Council of Surveys and Mapping’s (CCSM) system for classification of geographic features, e.g. AR82000110.
SHAPE SHAPE SDO_GEOMETRY 1 SHAPE is the column used to reference the spatial coordinates defining the feature.
OBJECTID OBJECTID NUMBER 38 OBJECTID is a column required by spatial layers that interact with ESRI ArcSDE. It is populated with unique values automatically by SDE.
SE_ANNO_CAD_DATA ANNO_CAD 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.