Resource metadata

Field Value
Data last updated November 14, 2024
Metadata last updated November 14, 2024
Created June 23, 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
Hash1acc959c30b36e7a50df36992483efe1
Header row1
Ida5a0c6dd-fb21-4af1-8035-b6bddd7462c4
Ignore hashFalse
Load statusTable was successfully loaded: 482 rows
Mimetypetext/csv
Original urlhttps://data.cbwaterhub.ca/dataset/2c3d4407-1b61-4d6d-ae72-fef356c44481/resource/a5a0c6dd-fb21-4af1-8035-b6bddd7462c4/download/era_waterquality_col003_20191015_20240909.csv
Package id2c3d4407-1b61-4d6d-ae72-fef356c44481
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': 'COL003_20191015', 'sample_site_id': 'COL003', 'time_zone': 'MT'}, {'lab_name': 'CARO Analytical Services', 'sample_date_time': '2020-09-08 10:30', 'sample_details': 'Samples collected using bottles and preservatives provided by the lab\r\n', 'sample_id': 'COL003_20200908_1030', 'sample_site_id': 'COL003', 'time_zone': 'MT'}, {'lab_name': 'CARO Analytical Services', 'sample_date_time': '2021-10-06 09:00', 'sample_details': 'Samples collected using bottles and preservatives provided by the lab\r\n', 'sample_id': 'C0L003_20211006_0900', 'sample_site_id': 'C0L003', 'time_zone': 'MT'}, {'lab_name': 'CARO Analytical Services', 'sample_date_time': '2022-09-18 11:20', 'sample_details': 'Samples collected using bottles and preservatives provided by the lab\r\n', 'sample_id': 'COL003_20220918_1120', 'sample_site_id': 'COL003', 'time_zone': 'MT'}, {'lab_name': 'CARO Analytical Services', 'sample_date_time': '2022-09-18 11:20', 'sample_details': 'Samples collected using bottles and preservatives provided by the lab; Duplicate sample taken alongside COL003_20220918_1120\r\n\r\n', 'sample_id': 'DUP001_20220918_1120', 'sample_site_id': 'COL003', 'time_zone': 'MT'}, {'lab_name': 'CARO Analytical Services', 'sample_date_time': '2023-10-03 13:57', 'sample_details': 'Samples collected using bottles and preservatives provided by the lab\r\n', 'sample_id': 'COL003_20231003_1357', 'sample_site_id': 'COL003', 'time_zone': 'MT'}, {'lab_name': 'CARO Analytical Services', 'sample_date_time': '2024-09-09 09:28', 'sample_details': 'Samples collected using bottles and preservatives provided by the lab', 'sample_id': 'COL003_20240909_0928', 'sample_site_id': 'COL003', 'time_zone': 'MT'}]
Position1
Recent qa date2023-10-06
Resource citationElk River Alliance. (2022). Water Quality (2019-10-15 to 2024-09-09) Coal Creek (COL003) [Resource]. Columbia Basin Water Hub. 10.48511/5kth-k298
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 ida5a0c6dd-fb21-4af1-8035-b6bddd7462c4
Resource locationCoal Creek, Elk River Watershed
Set url typeFalse
Site[{'datum': 'NAD83', 'elevation': 1728, 'latitude': 49.45387, 'longitude': -114.88066, 'site_id': 'COL003', 'site_name': 'Coal Creek', 'waterbody': 'Coal Creek', 'waterbody_type': 'stream/river'}]
Size105.3 KiB
Stateactive
Task created2024-11-14 17:16:40.045503
Url typeupload
Waterhub gradeTechnical Research Grade
Citation (Required) Elk River Alliance. (2022). Water Quality (2019-10-15 to 2024-09-09) Coal Creek (COL003) [Resource]. Columbia Basin Water Hub. 10.48511/5kth-k298
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 Technical Research Grade
Date of Most Recent Water Hub QA/QC 2023-10-06
Loading Status Table was successfully loaded: 482 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

COL003
Field Value
Site ID COL003
Site Name Coal Creek
Waterbody Type Stream/River
Waterbody Coal Creek
Site Latitude 49.45387
Site Longitude -114.88066
Location Coordinate System NAD83
Site Elevation (masl) 1728

Parameter

COL003
Field Value
Time Zone MT
Sample ID COL003_20191015
Site ID COL003
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
COL003
Field Value
Time Zone MT
Sample ID COL003_20200908_1030
Site ID COL003
Lab Name CARO Analytical Services
Date and Time of Sampling 2020-09-08 10:30
Sampling Details Samples collected using bottles and preservatives provided by the lab
C0L003
Field Value
Time Zone MT
Sample ID C0L003_20211006_0900
Site ID C0L003
Lab Name CARO Analytical Services
Date and Time of Sampling 2021-10-06 09:00
Sampling Details Samples collected using bottles and preservatives provided by the lab
COL003
Field Value
Time Zone MT
Sample ID COL003_20220918_1120
Site ID COL003
Lab Name CARO Analytical Services
Date and Time of Sampling 2022-09-18 11:20
Sampling Details Samples collected using bottles and preservatives provided by the lab
COL003
Field Value
Time Zone MT
Sample ID DUP001_20220918_1120
Site ID COL003
Lab Name CARO Analytical Services
Date and Time of Sampling 2022-09-18 11:20
Sampling Details Samples collected using bottles and preservatives provided by the lab; Duplicate sample taken alongside COL003_20220918_1120
COL003
Field Value
Time Zone MT
Sample ID COL003_20231003_1357
Site ID COL003
Lab Name CARO Analytical Services
Date and Time of Sampling 2023-10-03 13:57
Sampling Details Samples collected using bottles and preservatives provided by the lab
COL003
Field Value
Time Zone MT
Sample ID COL003_20240909_0928
Site ID COL003
Lab Name CARO Analytical Services
Date and Time of Sampling 2024-09-09 09:28
Sampling Details Samples collected using bottles and preservatives provided by the lab