Resource metadata

Field Value
Data last updated December 6, 2023
Metadata last updated January 29, 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 are 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
Hash773d4b74b504025c6cc24515d7c79916
Header row1
Id2224af84-feac-4be8-9a10-41dffa7174e9
Load statusTable was successfully loaded: 243 rows
Mimetypetext/csv
Package id4d9f3dba-3985-4865-90c6-9220c616e691
Parameter[{'accuracy': '0.5', '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, prior to 2022 analog thermometer\r\n', 'parameter': 'Water Temperature', 'parameter_unit': 'degrees celsius', 'range': '0-50', 'resolution': '0.1', 'serial_number': 'N/A', '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': 'Hydrion pH test paper; VWR Chemicals BDH pH test strips, prior to 2022 hanna instruments', 'parameter': 'pH', 'parameter_unit': 'ph units', 'range': "'-2.00-16.00", 'resolution': '0.1 pH unit', 'serial_number': 'N/A', 'time_zone': 'PT'}, {'accuracy': 'N/A', 'calibration': 'N/A', 'instrument_manufacturer': 'LaMotte', 'instrument_model': 'LaMotte secchi disc', 'instrument_type': 'Secchi Disk', 'notes_method': 'N/A', 'parameter': 'water_clarity_secchi', 'parameter_unit': 'metres', 'range': 'N/A', 'resolution': 'N/A', 'serial_number': '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', 'serial_number': '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)', 'serial_number': 'N/A', 'time_zone': 'N/A'}]
Position0
Recent qa date2023-07-31
Resource citationCentral Kootenay Invasive Species Society. (2022). Field Water Quality (2018-06-07 to 2022-10-24) Lower Arrow Lake [Resource]. Columbia Basin Water Hub. 10.48511/3e11-3v66
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 up to six locations on Lower Arrow Lake. See metadata in download for site coordinates.
Site[{'datum': 'WGS84', 'elevation': 441, 'latitude': 49.342202, 'longitude': -117.829697, 'site_id': 'arrow_scotties', 'site_name': 'Lower Arrow Lake at Scotties Marina', 'waterbody': 'Lower Arrow Lake', 'waterbody_type': 'lake'}, {'datum': 'WGS84', 'elevation': 441, 'latitude': 49.99388028, 'longitude': -117.8869576, 'site_id': 'arrow_burton', 'site_name': 'Lower Arrow Lake at Burton Campground Launch', 'waterbody': 'Lower Arrow Lake', 'waterbody_type': 'lake'}, {'datum': 'WGS84', 'elevation': 441, 'latitude': 49.341014, 'longitude': -117.871423, 'site_id': 'arrow_syringa', 'site_name': 'Lower Arrow Lake at Syringa Creek Provincial Park Boat Launch', 'waterbody': 'Lower Arrow Lake', 'waterbody_type': 'lake'}, {'datum': 'WGS84', 'elevation': 441, 'latitude': 49.964921, 'longitude': -117.918957, 'site_id': 'arrow_bchydro_burton', 'site_name': 'Lower Arrow Lake at BC Hydro Burton Launch', 'waterbody': 'Lower Arrow Lake', 'waterbody_type': 'lake'}, {'datum': 'WGS84', 'elevation': 441, 'latitude': 49.877857, 'longitude': -118.070579, 'site_id': 'arrow_fauquier', 'site_name': 'Lower Arrow Lake at Fauquier Launch', 'waterbody': 'Lower Arrow Lake', 'waterbody_type': 'lake'}, {'datum': 'WGS84', 'elevation': 441, 'latitude': 49.773417, 'longitude': -118.137283, 'site_id': 'arrow_edgewood', 'site_name': 'Lower Arrow Lake at Edgewood Launch', 'waterbody': 'Lower Arrow Lake', 'waterbody_type': 'lake'}]
Size48.1 KiB
Stateactive
Url typeupload
Waterhub gradeCommunity Research Grade
Citation (Required) Central Kootenay Invasive Species Society. (2022). Field Water Quality (2018-06-07 to 2022-10-24) Lower Arrow Lake [Resource]. Columbia Basin Water Hub. 10.48511/3e11-3v66
Resource Location Measurements are taken at up to six locations on Lower Arrow Lake. 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 are 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: 243 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

arrow_scotties
Field Value
Site ID arrow_scotties
Site Name Lower Arrow Lake at Scotties Marina
Waterbody Type Lake
Waterbody Lower Arrow Lake
Site Latitude 49.342202
Site Longitude -117.829697
Location Coordinate System WGS84
Site Elevation (masl) 441
arrow_burton
Field Value
Site ID arrow_burton
Site Name Lower Arrow Lake at Burton Campground Launch
Waterbody Type Lake
Waterbody Lower Arrow Lake
Site Latitude 49.99388028
Site Longitude -117.8869576
Location Coordinate System WGS84
Site Elevation (masl) 441
arrow_syringa
Field Value
Site ID arrow_syringa
Site Name Lower Arrow Lake at Syringa Creek Provincial Park Boat Launch
Waterbody Type Lake
Waterbody Lower Arrow Lake
Site Latitude 49.341014
Site Longitude -117.871423
Location Coordinate System WGS84
Site Elevation (masl) 441
arrow_bchydro_burton
Field Value
Site ID arrow_bchydro_burton
Site Name Lower Arrow Lake at BC Hydro Burton Launch
Waterbody Type Lake
Waterbody Lower Arrow Lake
Site Latitude 49.964921
Site Longitude -117.918957
Location Coordinate System WGS84
Site Elevation (masl) 441
arrow_fauquier
Field Value
Site ID arrow_fauquier
Site Name Lower Arrow Lake at Fauquier Launch
Waterbody Type Lake
Waterbody Lower Arrow Lake
Site Latitude 49.877857
Site Longitude -118.070579
Location Coordinate System WGS84
Site Elevation (masl) 441
arrow_edgewood
Field Value
Site ID arrow_edgewood
Site Name Lower Arrow Lake at Edgewood Launch
Waterbody Type Lake
Waterbody Lower Arrow Lake
Site Latitude 49.773417
Site Longitude -118.137283
Location Coordinate System WGS84
Site Elevation (masl) 441

Parameter

Water Temperature
Field Value
Parameter Water Temperature
Time Zone PT
Unit of Measurement degrees Celsius
Instrument Type Portable Multiparameter Meter
Instrument Manufacturer Oakton
Instrument Model pHTestr 5 Pocket Tester
Serial Number N/A
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 analog thermometer
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
Serial Number N/A
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 Hydrion pH test paper; VWR Chemicals BDH pH test strips, prior to 2022 hanna instruments
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
Serial Number N/A
Instrument Accuracy N/A
Range N/A
Resolution N/A
Calibration Notes N/A
Notes on Method N/A
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
Serial Number N/A
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
Serial Number N/A
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.