Resource metadata

Field Value
Data last updated December 6, 2023
Metadata last updated February 17, 2024
Created January 10, 2022
Format CSV
License CC-BY-NC-SA-4.0
Data collection infoCKISS follows the British Columbia Dreissenid Mussel Lake Monitoring Field Protocol which is provided by the BC Ministry of Environment and Climate Change Strategy.
Data processingData validation to check if values within expected ranges, outliers flagged. The Water Hub has performed a preliminary QA/QC protocol on this data but the individual user must still confirm the accuracy of the data and whether it will be appropriate for their purpose.
Data typenon-lab
Datastore activeTrue
Datastore contains all records of source fileFalse
Datastore statuspending
Has viewsTrue
Hash89ca4cd19149777269dc86ff45f44d92
Header row1
Id7db1a843-8533-42d6-b53c-11009058497e
Load statusTable was successfully loaded: 89 rows
Mimetypetext/csv
Package id46399f01-e2f4-4738-a415-1ba81c2efcea
Parameter[{'accuracy': '0.5', 'calibration': 'Calibrated weekly as per manufacturer specification', 'instrument_manufacturer': 'Oaktron', 'instrument_model': 'pHTestr 5 Pocket Tester', 'instrument_type': 'Portable Multiparameter Meter', 'notes_method': 'As per British Columbia Dreissenid Mussel Lake\r\nMonitoring Field Protocol\r\nprior to 2022', 'parameter': 'Water Temperature', 'parameter_unit': 'degrees celsius', 'range': '0-50', 'resolution': '0.1', 'time_zone': 'PT'}, {'accuracy': '0.01 pH unit ±1 digit (automatic temperature compensation)', 'calibration': 'Calibrated weekly as per manufacturer specification', 'instrument_manufacturer': 'Oakton', 'instrument_model': 'pHTestr 5 Pocket Tester', 'instrument_type': 'Portable Multiparameter Meter', 'notes_method': 'As per British Columbia Dreissenid Mussel Lake\r\nMonitoring Field Protocol\r\nprior to 2022 hannah isntrument', 'parameter': 'pH', 'parameter_unit': 'ph units', 'range': "'-2.00-16.00", 'resolution': '0.1 pH unit', 'time_zone': 'PT'}, {'accuracy': 'N/A', 'calibration': 'N/A', 'instrument_manufacturer': 'LaMotte', 'instrument_model': 'LaMotte secchi disc', 'instrument_type': 'Secchi Disk', 'notes_method': 'As per British Columbia Dreissenid Mussel Lake Monitoring Field Protocol\r\n', 'parameter': 'water_clarity_secchi', 'parameter_unit': 'metres', 'range': 'N/A', 'resolution': 'N/A', 'time_zone': 'N/A'}, {'accuracy': 'N/A', 'calibration': 'N/A', 'instrument_manufacturer': 'LaMotte', 'instrument_model': 'LaMotte secchi disc', 'instrument_type': 'Secchi Disk', 'notes_method': 'Trophic status is determined by Secchi Depth as per British Columbia Dreissenid Mussel Lake\r\nMonitoring Field Protocol\r\n', 'parameter': 'trophic status', 'parameter_unit': 'n/a', 'range': 'N/A', 'resolution': 'N/A', 'time_zone': 'N/A'}, {'accuracy': '±10 mg/L ±5% of reading', 'calibration': 'Calibrated weekly as per manufacturer specification', 'instrument_manufacturer': 'Hanna Instruments', 'instrument_model': 'HI 96752', 'instrument_type': 'Other', 'instrument_type_other': 'Portable Photometer', 'notes_method': 'Total Calcium was measured only in 2018, as Dissolved Calcium is the parameter required to inform ZQM habitat suitability. \r\n', 'parameter': 'Calcium Total', 'parameter_unit': 'milligrams per litre', 'range': '0 to 400 mg/L (ppm)', 'resolution': '1 mg/L (ppm)', 'time_zone': 'N/A'}]
Position0
Recent qa date2023-07-31
Resource citationCentral Kootenay Invasive Species Society. (2022). Field Water Quality (2018-06-14 to 2022-10-24) Columbia River [Resource]. Columbia Basin Water Hub. https://doi.org/10.48511/4509-7036
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 locationMeasurements are taken at the Gyro Park boat launch in Trail, the Robson boat launch and Beaver Creek Provincial Park launch. See metadata in download for site coordinates.
Site[{'datum': 'WGS84', 'elevation': 408, 'latitude': 49.1028357, 'longitude': -117.7079311, 'site_id': 'columbia_gyro', 'site_name': 'Gyro Park boat launch', 'waterbody': 'Columbia River', 'waterbody_type': 'stream/river'}, {'datum': 'WGS84', 'elevation': 423, 'latitude': 49.33416038, 'longitude': -117.6991763, 'site_id': 'columbia_robson', 'site_name': 'Robson boat launch', 'waterbody': 'Columbia River', 'waterbody_type': 'stream/river'}, {'datum': 'WGS84', 'elevation': 402, 'latitude': 49.066504, 'longitude': -117.611684, 'site_id': 'columbia_beaver_creek', 'site_name': 'Boat launch at Beaver Creek Provincial Park', 'waterbody': 'Columbia River', 'waterbody_type': 'stream/river'}]
Size17.8 KiB
Stateactive
Url typeupload
Waterhub gradeCommunity Research Grade
Citation (Required) Central Kootenay Invasive Species Society. (2022). Field Water Quality (2018-06-14 to 2022-10-24) Columbia River [Resource]. Columbia Basin Water Hub. https://doi.org/10.48511/4509-7036
Resource Location Measurements are taken at the Gyro Park boat launch in Trail, the Robson boat launch and Beaver Creek Provincial Park launch. See metadata in download for site coordinates.
Data Collection Information CKISS follows the British Columbia Dreissenid Mussel Lake Monitoring Field Protocol which is provided by the BC Ministry of Environment and Climate Change Strategy.
Data Processing Data validation to check if values within expected ranges, outliers flagged. The Water Hub has performed a preliminary QA/QC protocol on this data but the individual user must still confirm the accuracy of the data and whether it will be appropriate for their purpose.
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 2023-07-31
Loading Status Table was successfully loaded: 89 rows
Datastore Status pending
Data type General

Data Dictionary

Column Type Label Description BODC ID
date_time timestamp
site_id text
latitude float8
longitude float8
notes text
water_temperature float8
water_temperature_units text
pH float8
pH_units text
water_clarity_secchi float8
water_clarity_secchi_units text
trophic_status text
trophic_status_units float8
calcium_total float8
calcium_total_units text
water_hub_qa_qc float8

Site

columbia_gyro
Field Value
Site ID columbia_gyro
Site Name Gyro Park boat launch
Waterbody Type Stream/River
Waterbody Columbia River
Site Latitude 49.1028357
Site Longitude -117.7079311
Location Coordinate System WGS84
Site Elevation (masl) 408
columbia_robson
Field Value
Site ID columbia_robson
Site Name Robson boat launch
Waterbody Type Stream/River
Waterbody Columbia River
Site Latitude 49.33416038
Site Longitude -117.6991763
Location Coordinate System WGS84
Site Elevation (masl) 423
columbia_beaver_creek
Field Value
Site ID columbia_beaver_creek
Site Name Boat launch at Beaver Creek Provincial Park
Waterbody Type Stream/River
Waterbody Columbia River
Site Latitude 49.066504
Site Longitude -117.611684
Location Coordinate System WGS84
Site Elevation (masl) 402

Parameter

Water Temperature
Field Value
Parameter Water Temperature
Time Zone PT
Unit of Measurement degrees Celsius
Instrument Type Portable Multiparameter Meter
Instrument Manufacturer Oaktron
Instrument Model pHTestr 5 Pocket Tester
Instrument Accuracy 0.5
Range 0-50
Resolution 0.1
Calibration Notes Calibrated weekly as per manufacturer specification
Notes on Method As per British Columbia Dreissenid Mussel Lake Monitoring Field Protocol prior to 2022
pH
Field Value
Parameter pH
Time Zone PT
Unit of Measurement pH units
Instrument Type Portable Multiparameter Meter
Instrument Manufacturer Oakton
Instrument Model pHTestr 5 Pocket Tester
Instrument Accuracy 0.01 pH unit ±1 digit (automatic temperature compensation)
Range '-2.00-16.00
Resolution 0.1 pH unit
Calibration Notes Calibrated weekly as per manufacturer specification
Notes on Method As per British Columbia Dreissenid Mussel Lake Monitoring Field Protocol prior to 2022 hannah isntrument
water_clarity_secchi
Field Value
Parameter water_clarity_secchi
Time Zone N/A
Unit of Measurement metres
Instrument Type Secchi Disk
Instrument Manufacturer LaMotte
Instrument Model LaMotte secchi disc
Instrument Accuracy N/A
Range N/A
Resolution N/A
Calibration Notes N/A
Notes on Method As per British Columbia Dreissenid Mussel Lake Monitoring Field Protocol
trophic status
Field Value
Parameter trophic status
Time Zone N/A
Unit of Measurement N/A
Instrument Type Secchi Disk
Instrument Manufacturer LaMotte
Instrument Model LaMotte secchi disc
Instrument Accuracy N/A
Range N/A
Resolution N/A
Calibration Notes N/A
Notes on Method Trophic status is determined by Secchi Depth as per British Columbia Dreissenid Mussel Lake Monitoring Field Protocol
Calcium Total
Field Value
Parameter Calcium Total
Time Zone N/A
Unit of Measurement milligrams per litre
Instrument Type Other
Other Portable Photometer
Instrument Manufacturer Hanna Instruments
Instrument Model HI 96752
Instrument Accuracy ±10 mg/L ±5% of reading
Range 0 to 400 mg/L (ppm)
Resolution 1 mg/L (ppm)
Calibration Notes Calibrated weekly as per manufacturer specification
Notes on Method Total Calcium was measured only in 2018, as Dissolved Calcium is the parameter required to inform ZQM habitat suitability.