Resource metadata

Field Value
Data last updated November 14, 2024
Metadata last updated November 14, 2024
Created April 21, 2022
Format CSV
License CC-BY-NC-SA-4.0
Ckan urlhttps://data.cbwaterhub.ca
Data collection infoWater samples were collected using sterile bottles and preservatives provided by the laboratory and returned to them for assessment. One duplicate and one field blank are collected for every 10 samples.
Data processingThis dataset contains direct laboratory results.
Data typelab
Datastore activeTrue
Datastore contains all records of source fileTrue
Datastore statuspending
Has viewsTrue
Hash29f55f1a1e6e0bd5e495fb2fdecbce9a
Header row1
Id25d28c27-e0d3-41a2-82f8-e60a43e626a4
Ignore hashFalse
Load statusTable was successfully loaded: 381 rows
Mimetypetext/csv
Original urlhttps://data.cbwaterhub.ca/dataset/ae0c23c0-1fe2-4502-ada7-35b86a8ae990/resource/25d28c27-e0d3-41a2-82f8-e60a43e626a4/download/era_waterquality_col001_20191017-20240909.csv
Package idae0c23c0-1fe2-4502-ada7-35b86a8ae990
Parameter[{'lab_name': 'CARO Analytical Services', 'sample_date_time': '2019-10-15', 'sample_details': 'Samples collected using bottles and preservatives provided by the lab\r\n', 'sample_id': 'COL001_20191015', 'sample_site_id': 'COL001', 'time_zone': 'MT'}, {'lab_name': 'CARO Analytical Services', 'sample_date_time': '2020-09-08 13:30', 'sample_details': 'Samples collected using bottles and preservatives provided by the lab\r\n', 'sample_id': 'COL001_20200908_1330', 'sample_site_id': 'COL001', 'time_zone': 'MT'}, {'lab_name': 'CARO Analytical Services', 'sample_date_time': '2021-10-06 11:00', 'sample_details': 'Samples collected using bottles and preservatives provided by the lab\r\n', 'sample_id': 'C0L001_20211006_1100', 'sample_site_id': 'C0L001', 'time_zone': 'MT'}, {'lab_name': 'CARO Analytical Services', 'sample_date_time': '2022-09-18 15:45', 'sample_details': 'Samples collected using bottles and preservatives provided by the lab\r\n', 'sample_id': 'COL001_20220918_1545', 'sample_site_id': 'COL001', 'time_zone': 'MT'}, {'lab_name': 'CARO Analytical Services', 'sample_date_time': '2023-10-03 09:10', 'sample_details': 'Samples collected using bottles and preservatives provided by the lab\r\n', 'sample_id': 'COL001_20231003_0910', 'sample_site_id': 'COL001', 'time_zone': 'MT'}, {'lab_name': 'CARO Analytical Services', 'sample_date_time': '2024-09-09 14:32', 'sample_details': 'Samples collected using bottles and preservatives provided by the lab', 'sample_id': 'COL001_20240909_1432', 'sample_site_id': 'COL001', 'time_zone': 'MT'}]
Position0
Recent qa date2024-01-23
Resource citationElk River Watershed Alliance. (2022). Water Quality (2019-10-15 to 2024-09-09) Coal Creek (COL001) [Resource]. Columbia Basin Water Hub. https://doi.org/10.48511/P2AA-T207
Resource data disclaimerNo warranty or guarantee exists that the information is accurate, complete, current, or suitable for any purpose. The individual user must confirm the accuracy of the data and whether it will be appropriate for their purpose.
Resource id25d28c27-e0d3-41a2-82f8-e60a43e626a4
Resource locationCoal Creek, Elk River Watershed
Set url typeFalse
Site[{'datum': 'NAD83', 'elevation': 999, 'latitude': 49.49556, 'longitude': -115.06644, 'site_id': 'COL001', 'site_name': 'Coal Creek', 'waterbody': 'Coal Creek', 'waterbody_type': 'stream/river'}]
Size86.7 KiB
Stateactive
Task created2024-11-14 17:13:57.700241
Url typeupload
Waterhub gradeCommunity Research Grade
Citation (Required) Elk River Watershed Alliance. (2022). Water Quality (2019-10-15 to 2024-09-09) Coal Creek (COL001) [Resource]. Columbia Basin Water Hub. https://doi.org/10.48511/P2AA-T207
Resource Location Coal Creek, Elk River Watershed
Data Collection Information Water samples were collected using sterile bottles and preservatives provided by the laboratory and returned to them for assessment. One duplicate and one field blank are collected for every 10 samples.
Data Processing This dataset contains direct laboratory results.
Data Disclaimer No warranty or guarantee exists that the information is accurate, complete, current, or suitable for any purpose. The individual user must confirm the accuracy of the data and whether it will be appropriate for their purpose.
Water Hub Data Grade Community Research Grade
Date of Most Recent Water Hub QA/QC 2024-01-23
Loading Status Table was successfully loaded: 381 rows
Datastore Status pending
Data type Laboratory Results

Data Dictionary

Column Type Label Description BODC ID
date_time_sampled text
date_analysed text
sample_id text
site_ID text
latitude text
longitude text
analyte text
method text
unit_of_measurement text
value_type text
matrix text
detection_limit text
values text
notes text
water_hub_qa_qc text

Site

COL001
Field Value
Site ID COL001
Site Name Coal Creek
Waterbody Type Stream/River
Waterbody Coal Creek
Site Latitude 49.49556
Site Longitude -115.06644
Location Coordinate System NAD83
Site Elevation (masl) 999

Parameter

COL001
Field Value
Time Zone MT
Sample ID COL001_20191015
Site ID COL001
Lab Name CARO Analytical Services
Date and Time of Sampling 2019-10-15
Sampling Details Samples collected using bottles and preservatives provided by the lab
COL001
Field Value
Time Zone MT
Sample ID COL001_20200908_1330
Site ID COL001
Lab Name CARO Analytical Services
Date and Time of Sampling 2020-09-08 13:30
Sampling Details Samples collected using bottles and preservatives provided by the lab
C0L001
Field Value
Time Zone MT
Sample ID C0L001_20211006_1100
Site ID C0L001
Lab Name CARO Analytical Services
Date and Time of Sampling 2021-10-06 11:00
Sampling Details Samples collected using bottles and preservatives provided by the lab
COL001
Field Value
Time Zone MT
Sample ID COL001_20220918_1545
Site ID COL001
Lab Name CARO Analytical Services
Date and Time of Sampling 2022-09-18 15:45
Sampling Details Samples collected using bottles and preservatives provided by the lab
COL001
Field Value
Time Zone MT
Sample ID COL001_20231003_0910
Site ID COL001
Lab Name CARO Analytical Services
Date and Time of Sampling 2023-10-03 09:10
Sampling Details Samples collected using bottles and preservatives provided by the lab
COL001
Field Value
Time Zone MT
Sample ID COL001_20240909_1432
Site ID COL001
Lab Name CARO Analytical Services
Date and Time of Sampling 2024-09-09 14:32
Sampling Details Samples collected using bottles and preservatives provided by the lab