Resource metadata

Field Value
Data last updated December 14, 2023
Metadata last updated July 15, 2024
Created November 26, 2021
Format CSV
License CC-BY-SA-4.0
Data collection infoEKISC follows the British Columbia Dreissenid Mussel Lake Monitoring Field Protocol which is updated annually and provided by the Ministry of Environment. The protocol sets provincial standards for plankton tow sample collection, preservation, ancillary data collection, and shipment of samples.
Data processingThe 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. It was not specified whether or not instruments were calibrated.
Data typenon-lab
Datastore activeTrue
Datastore contains all records of source fileFalse
Datastore statuspending
Has viewsTrue
Hashde04634d05640d3dade0d76f1eff18f0
Header row1
Idf52457c8-586e-42c4-a73d-74186b9ebb45
Load statusTable was successfully loaded: 39 rows
Mimetypetext/csv
Package id3273e999-eb4d-407e-bfb0-55099e0ea88a
Parameter[{'accuracy': '±0.5°C', 'calibration': 'Not specified', 'instrument_manufacturer': 'Hanna', 'instrument_model': 'HI98127', 'instrument_type': 'Other', 'instrument_type_other': 'pH Pen', 'notes_method': 'As per British Columbia Dreissenid Mussel Lake Monitoring Field Protocol', 'parameter': 'Water Temperature', 'parameter_unit': 'degrees celsius', 'range': '-5.0 to 60.0°C', 'resolution': '0.1°C', 'serial_number': '', 'time_zone': 'MT'}, {'accuracy': '±0.1 pH', 'calibration': 'Not specified', 'instrument_manufacturer': 'Hanna', 'instrument_model': 'HI98127', 'instrument_type': 'Other', 'instrument_type_other': 'pH Pen', 'notes_method': 'As per British Columbia Dreissenid Mussel Lake Monitoring Field Protocol', 'parameter': 'pH', 'parameter_unit': 'ph units', 'range': '-2.0 to 16.0 pH', 'resolution': '0.1 pH', 'serial_number': '', 'time_zone': 'MT'}, {'accuracy': 'N/A', 'calibration': 'N/A', 'instrument_manufacturer': 'Not specified', 'instrument_model': 'N/A', 'instrument_type': 'Secchi Disk', 'notes_method': 'As per British Columbia Dreissenid Mussel Lake Monitoring Field Protocol', 'parameter': 'water_clarity_secchi', 'parameter_unit': 'metres', 'range': 'N/A', 'resolution': 'N/A', 'serial_number': '', 'time_zone': 'MT'}]
Position0
Recent qa date2023-12-14
Resource citationEast Kootenay Invasive Species Society. (2021). Field Water Quality (2019-06-20 to 2023-09-27) Columbia Lake [Resource]. Columbia Basin Water Hub. Cranbrook, BC. https://doi.org/10.48511/HGEC-0C46
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 locationColumbia Lake at Tilley Park Boat Launch and Columere Park. Several measurements recorded at additional locations in 2019 are included.
Site[{'datum': 'UNKWN', 'elevation': 810, 'latitude': 50.17812, 'longitude': -115.82018, 'site_id': 'Tilley Park Boat Launch', 'site_name': 'Tilley Park Boat Launch', 'waterbody': 'Columbia Lake', 'waterbody_type': 'lake'}, {'datum': 'UNKWN', 'elevation': 810, 'latitude': 50.289639, 'longitude': -115.87052, 'site_id': 'Columere Park', 'site_name': 'Columere Park', 'waterbody': 'Columbia Lake', 'waterbody_type': 'lake'}, {'datum': 'UNKWN', 'elevation': 810, 'latitude': 50.257061, 'longitude': -115.853071, 'site_id': 'Columbia 2', 'site_name': 'East side of Columbia Lake', 'waterbody': 'Columbia Lake', 'waterbody_type': 'lake'}, {'datum': 'UNKWN', 'elevation': 810, 'latitude': 50.2449, 'longitude': -115.866242, 'site_id': 'Columbia 3', 'site_name': 'West side of Columbia Lake', 'waterbody': 'Columbia Lake', 'waterbody_type': 'lake'}, {'datum': 'UNKWN', 'elevation': 810, 'latitude': 50.213101, 'longitude': -115.84255, 'site_id': 'Mid East', 'site_name': 'East side of Columbia Lake', 'waterbody': 'Columbia Lake', 'waterbody_type': 'lake'}, {'datum': 'UNKWN', 'elevation': 810, 'latitude': 50.21205, 'longitude': -115.860052, 'site_id': 'Station Road', 'site_name': 'West side of Columbia Lake', 'waterbody': 'Columbia Lake', 'waterbody_type': 'lake'}, {'datum': 'UNKWN', 'elevation': 810, 'latitude': 'N/A', 'longitude': 'N/A', 'site_id': 'Pine Bay', 'site_name': 'Unknown', 'waterbody': 'Columbia Lake', 'waterbody_type': 'lake'}]
Size6.5 KiB
Stateactive
Url typeupload
Waterhub gradeCommunity Research Grade
Citation (Required) East Kootenay Invasive Species Society. (2021). Field Water Quality (2019-06-20 to 2023-09-27) Columbia Lake [Resource]. Columbia Basin Water Hub. Cranbrook, BC. https://doi.org/10.48511/HGEC-0C46
Resource Location Columbia Lake at Tilley Park Boat Launch and Columere Park. Several measurements recorded at additional locations in 2019 are included.
Data Collection Information EKISC follows the British Columbia Dreissenid Mussel Lake Monitoring Field Protocol which is updated annually and provided by the Ministry of Environment. The protocol sets provincial standards for plankton tow sample collection, preservation, ancillary data collection, and shipment of samples.
Data Processing 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. It was not specified whether or not instruments were calibrated.
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-12-14
Loading Status Table was successfully loaded: 39 rows
Datastore Status pending
Data type General

Data Dictionary

Column Type Label Description BODC ID
date_time text
site_id text
site_latitude text
site_longitude text
notes text
water_temperature text
water_temperature_units text
pH text PHXXPR01 pH per unit volume of the water body by pH electrode SDN:P01::PHXXPR01
pH_units text
water_clarity_secchi text Secchi Estimate of the transparency of the surface water based upon the distance below the ship at which a standard black and white disk becomes visible. SDN:P01::SECCSDNX
water_clarity_secchi_units text
water_hub_qa_qc text

Site

Tilley Park Boat Launch
Field Value
Site ID Tilley Park Boat Launch
Site Name Tilley Park Boat Launch
Waterbody Type Lake
Waterbody Columbia Lake
Site Latitude 50.17812
Site Longitude -115.82018
Location Coordinate System UNKWN
Site Elevation (masl) 810
Columere Park
Field Value
Site ID Columere Park
Site Name Columere Park
Waterbody Type Lake
Waterbody Columbia Lake
Site Latitude 50.289639
Site Longitude -115.87052
Location Coordinate System UNKWN
Site Elevation (masl) 810
Columbia 2
Field Value
Site ID Columbia 2
Site Name East side of Columbia Lake
Waterbody Type Lake
Waterbody Columbia Lake
Site Latitude 50.257061
Site Longitude -115.853071
Location Coordinate System UNKWN
Site Elevation (masl) 810
Columbia 3
Field Value
Site ID Columbia 3
Site Name West side of Columbia Lake
Waterbody Type Lake
Waterbody Columbia Lake
Site Latitude 50.2449
Site Longitude -115.866242
Location Coordinate System UNKWN
Site Elevation (masl) 810
Mid East
Field Value
Site ID Mid East
Site Name East side of Columbia Lake
Waterbody Type Lake
Waterbody Columbia Lake
Site Latitude 50.213101
Site Longitude -115.84255
Location Coordinate System UNKWN
Site Elevation (masl) 810
Station Road
Field Value
Site ID Station Road
Site Name West side of Columbia Lake
Waterbody Type Lake
Waterbody Columbia Lake
Site Latitude 50.21205
Site Longitude -115.860052
Location Coordinate System UNKWN
Site Elevation (masl) 810
Pine Bay
Field Value
Site ID Pine Bay
Site Name Unknown
Waterbody Type Lake
Waterbody Columbia Lake
Site Latitude N/A
Site Longitude N/A
Location Coordinate System UNKWN
Site Elevation (masl) 810

Parameter

Water Temperature
Field Value
Parameter Water Temperature
Time Zone MT
Unit of Measurement degrees Celsius
Instrument Type Other
Other pH Pen
Instrument Manufacturer Hanna
Instrument Model HI98127
Serial Number
Instrument Accuracy ±0.5°C
Range -5.0 to 60.0°C
Resolution 0.1°C
Calibration Notes Not specified
Notes on Method As per British Columbia Dreissenid Mussel Lake Monitoring Field Protocol
pH
Field Value
Parameter pH
Time Zone MT
Unit of Measurement pH units
Instrument Type Other
Other pH Pen
Instrument Manufacturer Hanna
Instrument Model HI98127
Serial Number
Instrument Accuracy ±0.1 pH
Range -2.0 to 16.0 pH
Resolution 0.1 pH
Calibration Notes Not specified
Notes on Method As per British Columbia Dreissenid Mussel Lake Monitoring Field Protocol
water_clarity_secchi
Field Value
Parameter water_clarity_secchi
Time Zone MT
Unit of Measurement metres
Instrument Type Secchi Disk
Instrument Manufacturer Not specified
Instrument Model N/A
Serial Number
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