MINFILE Mineral Occurrence Database

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

Mineral_occurrence - This feature depicts a body of rock containing, or thought to contain, ore minerals or potential ore minerals. A geographic location depicts the most significant physical reference point to the mineralization. MINFILE contains geological, location and economic information on over 14,600 metallic, industrial mineral and coal occurrences in B.C. The database is used by government, industry and academia for resource management, land-use planning, exploration and research

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.
Data Quality
Lineage StatementMINFILE contains over 14,600 metallic, industrial mineral and coal occurrences for B.C. 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 (www.MapPlace.ca).

More Information

Contact Information

NameLarry Jones (pointOfContact)
EmailLarry.Jones@gov.bc.ca
OrganizationMinistry of Energy and Mines
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 2017-02-17
Resource Status onGoing

Object Description

Object Name: WHSE_MINERAL_TENURE.MINFIL_MINERAL_FILE

Short Name: MINFILE
Comments: MINFIL MINERAL FILE contains geological, location and economic information on over 13,900 metallic, industrial mineral and coal occurrences in B.C. A mineral occurrence depicts a body of rock containing, or thought to contain, ore minerals or potential ore minerals. A geographic location depicts the most significant physical reference point to the mineralization. The database is used by government, industry and academia for resource management, land-use planning, exploration and research.

Column Name Short Name Data Type Data Precision Comments
MINFILE_NUMBER MNFL_NMBR VARCHAR2 9 MINFILE NUMBER is the user maintained unique identification number. This is a primary key for this dataset. Each mineral occurrence has a unique 9-character MINFILE number used to identify it within the computer database, in printouts and on maps. The MINFILE number begins with a three-digit NTS (National Topographic System) location number used to identify the appropriate 1:1 000 000 map sheet (from 082 to 114), followed by a single alphabetic character (A to P) used to identify the appropriate 1:250 000 map sheet. Due to a high density of occurrences, NTS map sheets 082E, F, K, L, 92H and I are plotted at a 1:100 000 scale. In these cases, a two-character (NE, NW, SE, SW) designation identifies the appropriate quadrant on the map sheet. The other map areas are plotted at a 1:250 000 scale and two blank spaces must be input in place of the two-character quadrant designation. An exception is 092IW. The final three-character segment of the MINFILE number is a sequential three-digit number from 001 to 999, identifying the unique number on the map sheet. For example, 082FSW100 is the 100th occurrence documented in the 082FSW 1:100 000 scale NTS area, e.g. 082ESE003.
MINFILE_NAME1 MNFL_NM1 VARCHAR2 30 MINFILE NAME1 is the most common or historically relevant name for an occurrence. Names in current use may or may not be the most appropriate for an occurrence in a historical context. The most important name is listed first followed by all aliases, in order of importance. Each occurrence can have up to sixteen names, e.g. KINGCOME GLACIER.
MINFILE_NAME2 MNFL_NM2 VARCHAR2 30 MINFILE NAME2 is the second most common or historically relevant name for an occurrence, e.g. TRUDEL GLACIER.
STATUS_CODE STATUS_CD VARCHAR2 4 STATUS CODE is the code which describes the state of development of the occurrence as of the date of coding. Each occurrence has only one status. See "Code-values-for-MINERAL FILE-status.doc", e.g. 3.
STATUS_DESCRIPTION STATUS_DS VARCHAR2 20 STATUS DESCRIPTION is the description of the status code of the occurrence as of the date of coding. Showing hosts minor in-situ mineralization. Prospect is an occurrences documented as containing mineralization which warrants further exploration. Developed Prospect is an occurrence on which exploration and development have progressed to a stage that allows a reasonable estimate of the amount(s) of one or more of the potentially mineable commodities. Producer is a currently producing open pit or underground mine from which ore containing one or more commodities is being mined for commercial gain or benefit. Past Producer is a mine that is not currently being mined and have recorded production in the past, e.g. Active.
ELEVATION_METRES ELEVATN_M NUMBER 4 ELEVATION METRES is the elevation measured in meters from sea level where this deposit is located, e.g. 6000.
COMMODITY_CODE1 COMDTY_CD1 VARCHAR2 2 COMMODITY CODE1 is the primary ranked code of a commodity found in this mineral occurrence as listed within the reference file "Code-values-for-MINERAL FILE-commodity codes&descriptions.doc", e.g. WO.
COMMODITY_CODE2 COMDTY_CD2 VARCHAR2 2 COMMODITY CODE2 is the secondary ranked code of a commodity found in this mineral occurrence as listed within the reference file "Code-values-for-MINERAL FILE-commodity codes&descriptions.doc", e.g. SB.
COMMODITY_CODE3 COMDTY_CD3 VARCHAR2 2 COMMODITY CODE3 is the tertiary ranked code of a commodity found in this mineral occurrence as listed within the reference file "Code-values-for-MINERAL FILE-commodity codes&descriptions.doc”, e.g. PB.
COMMODITY_CODE4 COMDTY_CD4 VARCHAR2 2 COMMODITY CODE4 is the code of a commodity ranked fourth found in this mineral occurrence as listed within the reference file "Code-values-for-MINERAL FILE-commodity codes&descriptions.doc", e.g. ZN.
COMMODITY_CODE5 COMDTY_CD5 VARCHAR2 2 COMMODITY CODE5 is the code of a commodity ranked fifth found in this mineral occurrence as listed within the reference file "Code-values-for-MINERAL FILE-commodity codes&descriptions.doc", e.g. AG.
COMMODITY_CODE6 COMDTY_CD6 VARCHAR2 2 COMMODITY CODE6 is the code of a commodity ranked sixth found in this mineral occurrence as listed within the reference file "Code-values-for-MINERAL FILE-commodity codes&descriptions.doc", e.g. CU.
COMMODITY_CODE7 COMDTY_CD7 VARCHAR2 2 COMMODITY CODE7 is the code of a commodity ranked seventh found in this mineral occurrence as listed within the reference file "Code-values-for-MINERAL FILE-commodity codes&descriptions.doc", e.g. GS.
COMMODITY_CODE8 COMDTY_CD8 VARCHAR2 2 COMMODITY CODE8 is the code of a commodity ranked eighth found in this mineral occurrence as listed within the reference file "Code-values-for-MINERAL FILE-commodity codes&descriptions.doc", e.g. DI.
COMMODITY_DESCRIPTION1 COMDTY_DS1 VARCHAR2 30 COMMODITY DESCRIPTION1 is the description of the same numbered commodity code, e.g. Tungsten.
COMMODITY_DESCRIPTION2 COMDTY_DS2 VARCHAR2 30 COMMODITY DESCRIPTION2 is the description of the same numbered commodity code, e.g. Antimony.
COMMODITY_DESCRIPTION3 COMDTY_DS3 VARCHAR2 30 COMMODITY DESCRIPTION3 is the description of the same numbered commodity code, e.g. Lead.
COMMODITY_DESCRIPTION4 COMDTY_DS4 VARCHAR2 30 COMMODITY DESCRIPTION4 is the description of the same numbered commodity code, e.g. Zinc.
COMMODITY_DESCRIPTION5 COMDTY_DS5 VARCHAR2 30 COMMODITY DESCRIPTION5 is the description of the same numbered commodity code, e.g. Silver.
COMMODITY_DESCRIPTION6 COMDTY_DS6 VARCHAR2 30 COMMODITY DESCRIPTION6 is the description of the same numbered commodity code, e.g. Copper.
COMMODITY_DESCRIPTION7 COMDTY_DS7 VARCHAR2 30 COMMODITY DESCRIPTION7 is the description of the same numbered commodity code, e.g. Gemstones.
COMMODITY_DESCRIPTION8 COMDTY_DS8 VARCHAR2 30 COMMODITY DESCRIPTION8 is the description of the same numbered commodity code, e.g. Diamond.
DEPOSIT_TYPE_CODE1 DTYPE_CD1 VARCHAR2 5 DEPOSIT TYPE CODE1 is the primary deposit type code which attempts to define a deposit based on its characteristics and includes/implies an explanation of these characteristics in terms of geological processes. This field is optional since there is often not enough information to define many occurrences as a specific deposit type. The coding of deposit type is ranked, using the most important type as the first ranked. The ranked order will be reflected in the printout. A thorough deposit description will be incorporated in the Capsule Geology and should indicate the geological evidence for any and all interpretations. See "Code-values-for-MINERAL FILE-deposit type codes&descriptions.doc" for the list of code values, e.g. E12.
DEPOSIT_TYPE_CODE2 DTYPE_CD2 VARCHAR2 5 DEPOSIT TYPE CODE2 is the secondary deposit type code which attempts to define a deposit based on its characteristics and includes/implies an explanation of these characteristics in terms of geological processes. This field is optional since there is often not enough information to define many occurrences as a specific deposit type. The coding of deposit type is ranked, using the most important type as the first ranked. The ranked order will be reflected in the printout. A thorough deposit description will be incorporated in the Capsule Geology and should indicate the geological evidence for any and all interpretations. See "Code-values-for MINERAL FILE-deposit type codes&descriptions.doc" for the list of code values, e.g. I05.
DEPOSIT_TYPE_DESCRIPTION1 DTYPE_DS1 VARCHAR2 60 DEPOSIT TYPE DESCRIPTION1 is the primary deposit type code description which describes the meaning of the corresponding Deposit Type Code and is an attempt to define a deposit based on its characteristics and includes/implies an explanation of these characteristics in terms of geological processes, e.g. Mississippi Valley-type Pb-Zn.
DEPOSIT_TYPE_DESCRIPTION2 DTTYPE_DS2 VARCHAR2 60 DEPOSIT TYPE DESCRIPTION2 is the secondary deposit type code description which describes the meaning of the corresponding Deposit Type Code and is an attempt to define a deposit based on its characteristics and includes/implies an explanation of these characteristics in terms of geological processes, e.g. Polymetallic veins Ag-Pb-Zn+/-Au.
DEPOSIT_CHARACTER_CODE1 DCHAR_CD1 VARCHAR2 4 DEPOSIT CHARACTER CODE1 is the primary deposit type code which describes the style of the mineralization or the significant geological features) associated with the mineralized host rocks. The database will accept up to four Deposit Characters for each occurrence and these are ranked in order of importance. This field is mandatory and at least one characteristic must be identified. A complete description of the characteristics of an occurrence will be incorporated in the Capsule Geology. See "Code-values-for-MINERAL FILE-deposit character codes&descriptions.doc" for a full list of deposit character codes, e.g. 79.
DEPOSIT_CHARACTER_CODE2 DCHAR_CD2 VARCHAR2 4 DEPOSIT CHARACTER CODE2 is the secondary deposit type code which describes the style of the mineralization or the significant geological features) associated with the mineralized host rocks. The database will accept up to four Deposit Characters for each occurrence and these are ranked in order of importance. This field is mandatory and at least one characteristic must be identified. A complete description of the characteristics of an occurrence will be incorporated in the Capsule Geology. See "Code-values-for-MINERAL FILE-deposit character codes&descriptions.doc" for a full list of deposit character codes, e.g. 76.
DEPOSIT_CHARACTER_DESCRIPTION1 DCHAR_DS1 VARCHAR2 20 DEPOSIT CHARACTER DESCRIPTION1 is the primary deposit character description which describes the meaning of the corresponding Deposit Character Code and describes the style of the mineralization or the significant geological features, e.g. Vein.
DEPOSIT_CHARACTER_DESCRIPTION2 DCHAR_DS2 VARCHAR2 20 DEPOSIT CHARACTER DESCRIPTION2 is the secondary deposit character description which describes the meaning of the corresponding Deposit Character Code and describes the style of the mineralization or the significant geological features, e.g. Shear.
DEPOSIT_CLASS_CODE1 DCLASS_CD1 VARCHAR2 3 DEPOSIT CLASS CODE1 is the primary deposit class code which is a general interpretation of the origin of an occurrence based on the best available geological data. The database will accept up to four classifications for any given occurrence. This field is mandatory and at least one classification must be assigned. The coding of deposit classification is ranked, that is, provide the order in which the classifications are to be entered. A genetic description will be incorporated in the Capsule Geology and should indicate the geological evidence for the interpretations. For a full list of codes see "Code-values-for-MINERAL FILE-deposit class codes&descriptions.doc", e.g. 112.
DEPOSIT_CLASS_CODE2 DCLASS_CD2 VARCHAR2 3 DEPOSIT CLASS CODE2 is the secondary deposit class code which is a general interpretation of the origin of an occurrence based on the best available geological data. The database will accept up to four classifications for any given occurrence. This field is mandatory and at least one classification must be assigned. The coding of deposit classification is ranked, that is, provide the order in which the classifications are to be entered. A genetic description will be incorporated in the Capsule Geology and should indicate the geological evidence for the interpretations. For a full list of codes see "Code-values-for-MINERAL FILE-deposit class codes&descriptions.doc", e.g. 129.
DEPOSIT_CLASS_DESCRIPTION1 DCLASS_DS1 VARCHAR2 15 DEPOSIT CLASS DESCRIPTION1 is the primary deposit class description which describes the meaning of the corresponding deposit class code and is a general interpretation of the origin of an occurrence based on the best available geological data, e.g. Hydrothermal.
DEPOSIT_CLASS_DESCRIPTION2 DCLASS_DS2 VARCHAR2 15 DEPOSIT CLASS DESCRIPTION2 is the secondary deposit class description which describes the meaning of the corresponding deposit class code and is a general interpretation of the origin of an occurrence based on the best available geological data, e.g. Epigenetic.
TECTONIC_BELT_CODE TCTNC_B_CD VARCHAR2 2 TECTONIC BELT CODE is the code of one of five tectonic belts that the area of this mineral occurrence lies within. EA - FORELAND BELT, OM - OMINECA BELT, IM - INTERMONTANE BELT, CC - COAST CRYSTALLINE, IN - INSULAR BELT, e.g. EA.
TECTONIC_BELT_DESCRIPTION TCTNC_B_DS VARCHAR2 18 TECTONIC BELT DESCRIPTION is the description of the tectonic belt code and describes one of the five tectonic belts that the area of this mineral occurrence lies within. EA - FORELAND BELT, OM - OMINECA BELT, IM - INTERMONTANE BELT, CC - COAST CRYSTALLINE, IN - INSULAR BELT, e.g. Foreland.
TERRANE_CODE TERRANE_CD VARCHAR2 3 TERRANE CODE is the code of the terrane that this mineral occurrence lies within as listed within the referenced file "Code-values-for-MINERAL FILE-terrane code.pdf", e.g. CPC.
TERRANE_DESCRIPTION TERRANE_DS VARCHAR2 30 TERRANE DESCRIPTION is the description of the terrane code and describes the terrane that this mineral occurrence lies within as listed within the referenced file "Code-values-for-MINERAL FILE-terrane code.pdf", e.g. Plutonic Rocks.
NTS_MAPSHEET1 NTS_1 VARCHAR2 10 NTS MAPSHEET1 is a National Topographic System map sheet referencing the area where the mineral occurrence is located, e.g. 082E02E.
NTS_MAPSHEET2 NTS_2 VARCHAR2 10 NTS MAPSHEET2 is a National Topographic System map sheet referencing the area where the mineral occurrence is located, e.g. 092I04W.
BCGS_MAPSHEET1 BCGS_1 VARCHAR2 10 BCGS MAPSHEET1 is a BC Geographic System map sheet referencing the area where the mineral occurrence is located, e.g. 092I011.
BCGS_MAPSHEET2 BCGS_2 VARCHAR2 10 BCGS MAPSHEET2 is a BC Geographic System map sheet referencing the area where the mineral occurrence is located, e.g. 082F099.
PRODUCTION_IND PROD_IND VARCHAR2 1 PRODUCTION IND is an indicator which represents whether mineral production exists in the referenced mine for this MINFILE or not, e.g. Y or N.
RESERVES_IND RESRV_IND VARCHAR2 1 RESERVES IND is an indicator which represents whether mineral reserves or resources exist for the referenced deposit for this MINFILE or not, e.g. Y or N.
REGION_CODE1 REG_CD1 VARCHAR2 4 REGION CODE1 is the primary code representing the region in which this mineral occurrence resides. See "Code-values-for-MINERAL FILE-region-codes&descriptions.doc", e.g. BC.
REGION_CODE2 REG_CD2 VARCHAR2 4 REGION CODE2 is the secondary code representing the region in which this mineral occurrence resides. See "Code-values-for-MINERAL FILE-region-codes&descriptions.doc", e.g. BC.
REGION_CODE1_DESCRIPTION REG_CD1_DS VARCHAR2 50 REGION CODE1 DESCRIPTION is the description of the primary region code representing the region in which this mineral occurrence resides, e.g. British Columbia.
REGION_CODE2_DESCRIPTION REG_CD2_DS VARCHAR2 50 REGION CODE2 DESCRIPTION is the description of the secondary code representing the region in which this mineral occurrence resides, e.g. British Columbia.
LATITUDE_DECIMAL LAT_DCML NUMBER 8 LATITUDE DECIMAL is the latitude position of this report measured in decimal degrees, e.g. 49.095.
LATITUDE_DEGREES LAT_DEG 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 LAT_MIN 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 LAT_SEC 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 LAT_HEMI VARCHAR2 1 LATITUDE HEMISPHERE is the latitude hemisphere of the aforementioned latitude position. N- Northern hemisphere, S - Southern hemisphere, e.g. N.
LONGITUDE_DECIMAL LONG_DCML NUMBER 9 LONGITUDE DECIMAL is the negative-signed longitude position of this report measured in decimal degrees, e.g. -118.651667.
LONGITUDE_DEGREES LONG_DEG 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 LONG_MIN 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 LONG_SEC 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 LONG_HEMI 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 in which this mineral occurrence resides, 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 DATUM VARCHAR2 6 DATUM REFERENCE is the reference geodetic datum for defining the location of this mineral occurrence, e.g. NAD 83.
MINFILE_SUMMARY_URL MNFL_URL VARCHAR2 500 MINFILE SUMMARY URL is a universal resource locator for referencing complete reported information on the mineral occurrence, including detail on location; mineralogy and alteration; geology and host rocks; assay data, reserves and production records; and further references and information. Included as part of each report is a text description of the geology and setting of each occurrence, e.g. http://minfile.gov.bc.ca/Summary.aspx?minfilno=082ENE012.
FEATURE_CODE FCODE 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.

Comments

No comments have been posted yet.