Regional Geochemical Survey Data

663 views (27 recent)

Published by the Ministry of Energy, Mines and Petroleum Resources - BC Geological Survey
Licensed under Open Government Licence - British Columbia

2017 DATABASE (Excel): The joint federal-provincial Regional Geochemical Surveys (RGS) have been carried out in British Columbia since 1976 as part of the National Geochemical Reconnaissance (NGR) program to aid exploration and development of mineral resources. The British Columbia Geological Survey (BCGS) maintains provincial geochemical databases capturing information from multi-media surveys. This 2017 release of the most current and complete province-wide geochemical data set collected under the (RGS) program. This data set was generated by integrating RGS data previously published by the British Geological Survey and Geoscience BC. It was compiled from 111 original sources with 64,828 samples and about 5 million determinations analyzed using 18 methods in 18 laboratories. For the ease of use and consistency with previously published data, the data set was generated from the RGS database in a flat tabular format. The 2017 data set, released as BCGS GeoGile 2017-11, is presented as three MS Excel files, each of which contains multiple spreadsheets. “RGS2017_data.xlsx” contains RGS data, “RGS2017_header.xlsx” contains data column header descriptions, and “RGS2017_info.xlsx” contains additional information, such as analytical methods, survey statistics and data sources. The data tables capture locations, field observations, analytical results and laboratories, and geology underlying sample sites for stream-, lake- and moss-sediment (<0.18 mm fraction) and water samples. The analytical determinations include up to 63 analytes from sediment samples and up to 78 analytes from water samples. These samples, collected at an average density of about 1 site per 7–13 km2, provide representative geochemical data for the catchment basin upstream from the sample site. The RGS currently covers approximately 80 percent of the province.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

To aid exploration and development of mineral resources.

Data Quality
Lineage Statement

The information in the BCGW is out of date and has been updated and re-released as BC Geological Survey GeoFile 2017-11 (August 2017) which is downloadable here. In future it will be available via the BCGW.

More Information

Contact Information

NameLarry Jones (pointOfContact)
EmailLarry.Jones@gov.bc.ca
OrganizationMinistry of Energy, Mines and Petroleum Resources
Sub-OrganizationBC Geological Survey
NameAlexei Rukhlov (businessExpert)
EmailAlexei.Rukhlov@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 2011-03-09
Record Last Modified 2019-02-11
Resource Status completed

Object Description

Object Name: WHSE_MINERAL_TENURE.GEOL_REG_GEOCHMCL_SURV_PNT_SP

Short Name: RGS_S_PNT
Comments: REG GEOCHMCL SURV PNT SP is a spatial layer containing analytical determinations for up to 40 metals, field observations and sample locations for approximately 50,000 stream sediment, lake sediment, stream water and lake water sample sites covering over 70 percent of British Columbia.

Column Name Short Name Data Type Data Precision Comments
REG_GEOCHMCL_SURV_PNT_SP_ID RGS_PNT_ID NUMBER 8 Sequence generated primary key.
WHEN_CREATED WHEN_CREAT DATE 7 Identifies the date and time the record was created.
WHO_CREATED WHO_CREATE VARCHAR2 30 Identifies the ID of the person who created the record.
WHEN_UPDATED WHEN_UPDAT DATE 7 Identifies the date and time the last update was made to the record.
WHO_UPDATED WHO_UPDATE VARCHAR2 30 Identifies the ID of the person who last updated the record.
BANK_PRECIPITATE BNK_PRECIP VARCHAR2 15 Bank Precipatate is the colour of the bank material; for example black, brown, etc.
BANK_TYPE BANK_TYPE VARCHAR2 16 Bank Type is the composition of the bank material; for example alluvial, glacial outwash, bare rock.
CHANNEL_BED CHANL_BED VARCHAR2 24 Channel Bed is the dominant bed material; for example boulders, or organic material.
CHANNEL_PATTERN CHANL_PAT VARCHAR2 17 Channel pattern
COMPOSITION COMPOSITN VARCHAR2 28 Sample Composition (SFO) is an estimation of sand, fines and organic content.
CONTAMINATION CONTAMNATN VARCHAR2 22 Indicator of site contamination and/or source.
DRAINAGE_PATTERN DRAING_PAT VARCHAR2 20 The drainage pattern of the water body.
ELEVATION ELEVATION NUMBER 11 Elevation above sea level in metres
LAKE_AREA LAKE_AREA NUMBER 9 Lake area square kilometres
LAKE_CONTAMINATION LAKE_CNTAM VARCHAR2 22 Source of possible site contamination
LAKE_DEPTH LAKE_DEPTH NUMBER 9 Lake depth in metres
LAKE_PERIMETER LAKE_PERIM NUMBER 9 Lake perimeter in kilometres
LAKE_RELIEF LAKE_RELIF NUMBER 10 General relief of lake catchment basin
LAKE_SEDIMENT_COLOUR LK_SED_COL VARCHAR2 15 Lake sediment colour
LAKE_SEDIMENT_COMPOSITION LK_SED_COM VARCHAR2 35 Lake Sediment Composition is the type of lake sediment.
LAKE_WATER_COLOUR LK_WTR_COL VARCHAR2 13 Lake water colour
LATITUDE LATITUDE NUMBER 18 Latitude
LONGITUDE LONGITUDE NUMBER 17 Longitude
MASTER_ID MASTER_ID VARCHAR2 12 Master Sample Identification. This identifier is not necessarily unique and is composed of the NTS Map sheet number, the survey year and sample number.
MATERIAL MATERIAL VARCHAR2 30 Material is the sample media type. For example Stream sediment, Stream water.
MOSS_COLOUR MOSS_COLOR VARCHAR2 15 Moss mat colour
MOSS_HEALTH MOSS_HEALT VARCHAR2 15 Moss health indicator. Values are alive or dead.
MOSS_HEIGHT MOSS_HEIGH NUMBER 9 Height of moss mat in metres above stream bed
MOSS_HOST MOSS_HOST VARCHAR2 18 Moss Host is the host for Moss Mat Growth.
MOSS_THICKNESS MOSS_THICK NUMBER 9 Moss mat thickness in cm
PHYSIOGRAPHY PHYSIOGRPY VARCHAR2 20 Physiography is a description of the area.
REPLICATE_SAMPLE_STATUS REP_SAM_ST VARCHAR2 20 Replicate sample status indicates whether the sample is a routine sample, or one of 2 possible duplicates.
SEDIMENT_COLOUR SEDI_COLOR VARCHAR2 15 Sediment colour
SEDIMENT_PRECIPITATE SEDI_PRECP VARCHAR2 15 Sediment precipitate or secondary coating on boulders
STREAM_DEPTH STRM_DEPTH NUMBER 9 Stream depth in cm.
STREAM_FLOW STRM_FLOW VARCHAR2 11 The Stream Flow is a measurement of the water flow of a stream.
STREAM_ORDER STRM_ORDER VARCHAR2 40 Stream order is the category of the stream in the watershed hierarchy.
STREAM_SOURCE STRM_SOURC VARCHAR2 20 Stream source states the origin of the stream.
STREAM_TYPE STRM_TYPE VARCHAR2 25 Stream type is consistency of flow of the stream.
STREAM_WIDTH STRM_WIDTH NUMBER 9 Stream width (bank to bank) in metres
WATER_COLOUR WTR_COLOR VARCHAR2 13 Water colour
ALUMINIUM_ICPMS_PERCENTAGE ALUM_ICPMS NUMBER 12 Aluminium by aqua regia digestion-inductively coupled plasma mass spectrometry in percent
ANTIMONY_AAS_PPM ANTI_ASS NUMBER 13 Antimony by aqua regia digestion-hydride generation atomic absorption spectrometry in parts per million
ANTIMONY_ICPMS_PPM ANTI_ICPMS NUMBER 15 Antimony by aqua regia digestion-inductively coupled plasma mass spectrometry in parts per million
ANTIMONY_INAA_PPM ANTI_INAA NUMBER 13 Antimony by instrumental neutron activation analysis in parts per million
ARSENIC_AAS_PPM ARSE_AAS NUMBER 13 Arsenic by aqua regia digestion-hydride generation atomic absorption spectrometry in parts per million
ARSENIC_ICPMS_PPM ARSE_ICPMS NUMBER 15 Arsenic by aqua regia digestion-inductively coupled plasma mass spectrometry in parts per million
ARSENIC_INAA_PPM ARSE_INAA NUMBER 13 Arsenic by instrumental neutron activation analysis in parts per million
BARIUM_AAS_PPM BARI_AAS NUMBER 13 Barium by energy dispersive x-ray fluorescence in parts per million
BARIUM_ICPMS_PPM BARI_ICPMS NUMBER 15 Barium by aqua regia digestion-inductively coupled plasma mass spectrometry in parts per million
BARIUM_INAA_PPM BARI_INAA NUMBER 14 Barium by instrumental neutron activation analysis in parts per million
BISMUTH_AAS_PPM BISM_AAS NUMBER 12 Bismuth by aqua regia digestion-atomic absorption spectrometry in parts per million
BISMUTH_ICPMS_PPM BISM_ICPMS NUMBER 14 Bismuth by aqua regia digestion-inductively coupled plasma mass spectrometry in parts per million
BROMINE_INAA_PPM BISM_INAA NUMBER 13 Bromine by instrumental neutron activation analysis in parts per million
CADMIUM_AAS_PPM CADM_AAS NUMBER 13 Cadmium by aqua regia digestion-atomic absorption spectrometry in parts per million
CADMIUM_ICPMS_PPM CADM_ICPMS NUMBER 15 Cadmium by aqua regia digestion-inductively coupled plasma mass spectrometry in parts per million
CALCIUM_ICPMS_PERCENTAGE CALC_ICPMS NUMBER 13 Calcium by aqua regia digestion-inductively coupled plasma mass spectrometry in percent
CERIUM_INAA_PPM CERI_INAA NUMBER 14 Cerium by instrumental neutron activation analysis in parts per million
CESIUM_INAA_PPM CESI_INAA NUMBER 13 Cesium by instrumental neutron activation analysis in parts per million
CHROMIUM_AAS_PPM CHRO_ASS NUMBER 12 Chromium by aqua regia digestion-atomic absorption spectrometry in parts per million
CHROMIUM_ICPMS_PPM CHRO_ICPMS NUMBER 14 Chromium by aqua regia digestion-inductively coupled plasma mass spectrometry in parts per million
CHROMIUM_INAA_PPM CHRO_INAA NUMBER 13 Chromium by instrumental neutron activation analysis in parts per million
COBALT_AAS_PPM COBA_AAS NUMBER 13 Cobalt by aqua regia digestion-atomic absorption spectrometry in parts per million
COBALT_ICPMS_PPM COBA_ICPMS NUMBER 15 Cobalt by aqua regia digestion-inductively coupled plasma mass spectrometry in parts per million
COBALT_INAA_PPM COBA_INAA NUMBER 14 Cobalt by instrumental neutron activation analysis in parts per million
COPPER_AAS_PPM COPP_AAS NUMBER 13 Copper by aqua regia digestion-atomic absorption spectrometry in parts per million
COPPER_ICPMS_PPM COPP_ICPMS NUMBER 15 Copper by aqua regia digestion-inductively coupled plasma mass spectrometry in parts per million
EUROPIUM_INAA_PPM EURO_INAA NUMBER 13 Cobalt by instrumental neutron activation analysis in parts per million
FLUORINE_ION_PPM FLUO_ION NUMBER 11 Fluorine by sodium carbonate-potassium nitrate fusion-specific ion electrode in parts per million
GALLIUM_ICPMS_PPM GALL_ICPMS NUMBER 15 Gallium by aqua regia digestion-inductively coupled plasma mass spectrometry in parts per million
GOLD_FA_PPB GLD_FAPPB NUMBER 12 Gold by lead collection fire assay-atomic absorption finish in parts per billion
GOLD_FA_PPB_2 GLD_FABBB2 NUMBER 12 Gold by lead collection fire assay-atomic absorption finish in parts per billion (Duplicate analysis)
GOLD_ICPMS_PPB GOLD_ICPMS NUMBER 14 Gold by aqua regia digestion-inductively coupled plasma mass spectrometry in parts per billion
GOLD_INAA_PPB GOLD_PPB NUMBER 14 Gold by instrumental neutron activation analysis in parts per billion
GOLD_INAA_PPB_2 GOLD_PPB_2 NUMBER 14 Gold by instrumental neutron activation analysis in parts per billion (first duplicate)
GOLD_INAA_PPB_3 GOLD_PPB_3 NUMBER 14 Gold by instrumental neutron activation analysis in parts per billion (second duplicate)
GOLD_SAMPLE_WEIGHT GLD_SAM_WT NUMBER 9 Weight of sample for fire assay
GOLD_SAMPLE_WEIGHT_2 GLD_SAMWT2 NUMBER 10 Weight of sample for fire assay
HAFNIUM_INAA_PPM HAFN_INAA NUMBER 13 Hafnium by instrumental neutron activation analysis in parts per million
IRON_AAS_PERCENTAGE IRON_AAS NUMBER 11 Iron by aqua regia digestion-atomic absorption spectrometry in percent
IRON_ICPMS_PERCENTAGE IRON_ICPMS NUMBER 13 Iron by aqua regia digestion-inductively coupled plasma mass spectrometry in percent
IRON_INAA_PERCENTAGE IRON_INAA NUMBER 11 Iron by instrumental neutron activation analysis in percent
LANTHANUM_ICPMS_PPM LANT_ICPMS NUMBER 15 Lanthanum by aqua regia digestion-inductively coupled plasma mass spectrometry in parts per million
LANTHANUM_INAA_PPM LANT_INAA NUMBER 13 Lanthanum by instrumental neutron activation analysis in parts per million
LEAD_AAS_PPM LEAD_AAS NUMBER 13 Lead by aqua regia digestion-atomic absorption spectrometry in parts per million
LEAD_ICPMS_PPM LEAD_ICPMS NUMBER 15 Lead by aqua regia digestion-inductively coupled plasma mass spectometry in parts per million
LOSS_ON_IGNITION_PERCENTAGE LOS_ON_IGN NUMBER 13 Loss on ignition at 500oC in percent
LUTETIUM_INAA_PPM LUTE_INAA NUMBER 13 Lutetium by instrumental neutron activation analysis in parts per million
MAGNESIUM_ICPMS_PERCENTAGE MAGN_ICPMS NUMBER 13 Magnesium by aqua regia digestion-inductively coupled plasma mass spectometry in percent
MANGANESE_AAS_PPM MANG_AAS NUMBER 13 Manganese by aqua regia digestion-atomic absorption spectrometry in parts per million
MANGANESE_ICPMS_PPM MANG_ICPMS NUMBER 15 Manganese by aqua regia digestion-inductively coupled plasma mass spectrometry in parts per million
MERCURY_AAS_PPB MERC_AAS NUMBER 13 Mercury by aqua regia digestion - flameless atomic absorption spectrometry in parts per billion
MERCURY_ICPMS_PPB MERC_ICPMS NUMBER 15 Mercury by aqua regia digestion-inductively coupled plasma mass spectrometry in parts per billion
MOLYBDENUM_AAS_PPM MOLY_AAS NUMBER 13 Molybdenum by aqua regia digestion-atomic absorption spectrometry in parts per million
MOLYBDENUM_ICPMS_PPM MOLY_ICPMS NUMBER 15 Molybdenum by aqua regia digestion-inductively coupled plasma mass spectrometry in parts per million
MOLYBDENUM_INAA_PPM MOLY_INAA NUMBER 14 Molybdenum by instrumental neutron activation analysis in parts per million
NICKEL_AAS_PPM NICK_AAS NUMBER 12 Nickel by aqua regia digestion-atomic absorption spectrometry in parts per million
NICKEL_ICPMS_PPM NICK_ICPMS NUMBER 14 Nickel by aqua regia digestion-inductively coupled plasma mass spectrometry in parts per million
NICKEL_INAA_PPM NICK_INAA NUMBER 13 Nickel by instrumental neutron activation analysis in parts per million
PHOSPHORUS_ICPMS_PERCENTAGE PHOS_ICPMS NUMBER 12 Phosphorus by aqua regia digestion-inductively coupled plasma mass spectrometry in percent
POTASSIUM_ICPMS_PERCENTAGE POTA_ICPMS NUMBER 11 Potassium by aqua regia digestion-inductively coupled plasma mass spectrometry in percent
RUBIDIUM_INAA_PPM RUBI_INAA NUMBER 14 Rubidium by instrumental neutron activation analysis in parts per million
SAMARIUM_INAA_PPM SAMA_INAA NUMBER 14 Samarium by instrumental neutron activation analysis in parts per million
SCANDIUM_ICPMS_PPM SCAN_ICPMS NUMBER 15 Scandium by aqua regia digestion-inductively coupled plasma mass spectrometry in parts per million
SCANDIUM_INAA_PPM SCAN_INAA NUMBER 13 Scandium by instrumental neutron activation analysis in parts per million
SELENIUM_AAS_PPM SELE_AAS NUMBER 13 Selenium by aqua regia digestion-atomic absorption spectrometry in parts per million
SELENIUM_ICPMS_PPM SELE_ICPMS NUMBER 15 Selenium by aqua regia digestion-inductively coupled plasma mass spectrometry in parts per million
SILVER_AAS_PPM SILV_AAS NUMBER 13 Silver by aqua regia digestion-atomic absorption spectrometry in parts per million
SILVER_ICPMS_PPB SILV_ICPMS NUMBER 15 Silver by aqua regia digestion-inductively coupled plasma mass spectrometry in parts per billion
SODIUM_ICPMS_PERCENTAGE SODI_ICPMS NUMBER 13 Sodium by aqua regia digestion-inductively coupled plasma mass spectrometry in percent
SODIUM_INAA_PERCENTAGE SODI_INAA NUMBER 11 Sodium by instrumental neutron activation analysis in percent
STRONTIUM_ICPMS_PPM STRO_ICPMS NUMBER 14 Strontium by aqua regia digestion-inductively coupled plasma mass spectrometry in parts per million
SULPHUR_ICPMS_PERCENTAGE SULP_ICPMS NUMBER 12 Sulphur by aqua regain digestion-inductively coupled plasma mass spectrometry in percent
TANTALUM_INAA_PPM TANT_INAA NUMBER 14 Tantalum by instrumental neutron activation analysis in parts per million
TELLURIUM_ICPMS_PPM TELL_ICPMS NUMBER 15 Tellurium by aqua regia digestion-inductively coupled plasma mass spectrometry in parts per million
TERBIUM_INAA_PPM TERB_INAA NUMBER 14 Terbium by instrumental neutron activation analysis in parts per million
THALLIUM_ICPMS_PPM THAL_ICPMS NUMBER 14 Thallium by aqua regia digestion-inductively coupled plasma mass spectrometry in parts per million
THORIUM_ICPMS_PPM THOR_ICPMS NUMBER 15 Thorium by aqua regia digestion-inductively coupled plasma mass spectrometry in parts per million
THORIUM_INAA_PPM THOR_INAA NUMBER 13 Thorium by instrumental neutron activation analysis in parts per million
TIN_AAS_PPM TIN_ASS NUMBER 13 Tin by ammonium iodide fusion - atomic absorption spectrometry in parts per million
TITANIUM_ICPMS_PERCENTAGE TITA_ICPMS NUMBER 12 Titanium by aqua regain digestion-inductively coupled plasma mass spectrometry in percent
TUNGSTEN_COLOR_PPM TUNG_COLOR NUMBER 15 Tungsten by potassium bisulphate fusion-colorimetric determination in parts per million
TUNGSTEN_ICPMS_PPM TUNG_ICPMS NUMBER 14 Tungsten by aqua regain digestion-inductively coupled plasma mass spectrometry in parts per million
TUNGSTEN_INAA_PPM TUNG_INAA NUMBER 13 Tungsten by instrumental neutron activation analysis in parts per million
URANIUM_ICPMS_PPM URAN_ICPMS NUMBER 14 Uranium by aqua regain digestion-inductively coupled plasma mass spectrometry in parts per million
URANIUM_INAA_PPM URAN_INAA NUMBER 12 Uranium by instrumental neutron activation analysis in parts per million
URANIUM_NADNC_PPM URAN_NADNC NUMBER 15 Uranium by neutron activation with delayed neutron counting in parts per million
VANADIUM_AAS_PPM VANA_AAS NUMBER 12 Vanadium by aqua regia digestion-atomic absorption spectrometry in parts per million
WATER_FLUORIDE_PPB WTR_FLUOR NUMBER 9 Fluoride in water by specific ion electrode in parts per billion
WATER_PH WATER_PH NUMBER 9 Water pH by glass-reference electrode
WATER_SULPHATE_PPM WTR_SULPHA NUMBER 12 Sulphate in water by turbimetric methods in parts per million
WATER_URANIUM_PPB WTR_URANIU NUMBER 9 Uranium in water by laser induced fluorescence in parts per billion
YTTERBIUM_INAA_PPM YTTE_INAA NUMBER 9 Ytterbium by instrumental neutron activation analysis in parts per million
ZINC_AAS_PPM ZINC_AAS NUMBER 13 Zinc by aqua regia digestion-atomic absorption spectrometry in parts per million
ZIRCONIUM_INAA_PPM ZIRC_INAA NUMBER 9 Zirconium by instrumental neutron activation analysis in parts per million
NEUTRON_INAA_SAMPLE_WEIGHT NEUT_INAA NUMBER 9 Weight of sample for neutron activation
FEATURE_CODE FEAT_CODE VARCHAR2 10 A feature code is most importantly a means of linking a feature to its name and definition. For example, the code GB15300120 on a digital geographic feature links it to the name "Lake - Dry" with the definition "A lake bed from which all water has drained or evaporated."
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.

Comments

No comments have been posted yet.