Resource metadata

Field Value
Data last updated December 6, 2023
Metadata last updated February 17, 2024
Created September 13, 2021
Format CSV
License CC-BY-SA-4.0
Data collection infoTemperature and pH are measured using a Hanna Industries pen meter (HI98129) within 2-4” of the surface. Secchi depths are collected where there is sufficient depth to measure from the sampling location. Data collection is consistent with the Invasive Mussel Field Protocol prepared by the Ecosystems Branch, BC Ministry of Environment and Climate Change Strategy.
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.
Data typenon-lab
Datastore activeTrue
Datastore contains all records of source fileFalse
Datastore statusready
Has viewsTrue
Hash7f00a2210fc68139d58d9561275a621e
Header row1
Idee770ab4-0461-4d14-872f-7f59d4334a2c
Load statusERROR: Unable to find a usable engine; tried using: 'sqlalchemy'. A suitable version of sqlalchemy is required for sql I/O support. Trying to import the above resulted in these errors: - Pandas requires version '1.4.16' or newer of 'sqlalchemy' (version '1.3.5' currently installed).
Mimetypetext/csv
Package id14d38e7c-484a-4203-beb5-34d9b0979823
Parameter[{'accuracy': '±0.5°C', 'calibration': 'N/A', 'instrument_manufacturer': 'HANNA Instruments', 'instrument_model': 'HI98129', 'instrument_type': 'Portable Multiparameter Meter', 'notes_method': 'N/A', 'parameter': 'Water Temperature', 'parameter_unit': 'degrees celsius', 'range': '-5.0 to 60.0°C', 'resolution': '0.1°C', 'time_zone': 'MT'}, {'accuracy': '±0.05 pH', 'calibration': 'pH is calibrated weekly', 'instrument_manufacturer': 'HANNA Instruments', 'instrument_model': 'HI98129', 'instrument_type': 'Portable Multiparameter Meter', 'notes_method': 'N/A', 'parameter': 'pH', 'parameter_unit': 'standard atmosphere (atm)', 'range': '0.00 to 14.00 pH', 'resolution': '0.01 pH', 'time_zone': 'MT'}, {'accuracy': 'N/A', 'calibration': 'N/A', 'instrument_manufacturer': 'N/A', 'instrument_model': 'N/A', 'instrument_type': 'Secchi Disk', 'notes_method': 'Methodology consistent with Invasive Mussel Field Protocol prepared by the Ecosystems Branch, BC Ministry of Environment and Climate Change Strategy', 'parameter': 'water_clarity_secchi', 'parameter_unit': 'metres', 'range': 'N/A', 'resolution': 'N/A', 'time_zone': 'MT'}]
Position0
Recent qa date2022-11-25
Resource citationColumbia Shuswap Invasive Species Society. (2021). Water Quality (2020-07-20 to 2022-09-15) Columbia River at Donald Bridge. Columbia Basin Water Hub [Resource]. Revelstoke, BC. https://doi.org/10.48511/26M1-QB37
Resource data disclaimerNo warranty or guarantee exists that the information is accurate, complete, current, or suitable for any purpose. Instrument accuracy may be limited. The individual user must confirm the accuracy of the data and whether it will be appropriate for their purpose.
Resource locationColumbia River at Donald Bridge, samples are collected from the near shore as there is a swift current at the site.
Site[{'datum': 'WGS84', 'elevation': 775, 'latitude': 51.485053, 'longitude': -117.181349, 'site_id': 'columbia_donald', 'site_name': 'Donald Bridge', 'waterbody': 'Columbia River', 'waterbody_type': 'stream/river'}]
Size1.3 KiB
Stateactive
Url typeupload
Waterhub gradeCommunity Research Grade
Citation (Required) Columbia Shuswap Invasive Species Society. (2021). Water Quality (2020-07-20 to 2022-09-15) Columbia River at Donald Bridge. Columbia Basin Water Hub [Resource]. Revelstoke, BC. https://doi.org/10.48511/26M1-QB37
Resource Location Columbia River at Donald Bridge, samples are collected from the near shore as there is a swift current at the site.
Data Collection Information Temperature and pH are measured using a Hanna Industries pen meter (HI98129) within 2-4” of the surface. Secchi depths are collected where there is sufficient depth to measure from the sampling location. Data collection is consistent with the Invasive Mussel Field Protocol prepared by the Ecosystems Branch, BC Ministry of Environment and Climate Change Strategy.
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.
Data Disclaimer No warranty or guarantee exists that the information is accurate, complete, current, or suitable for any purpose. Instrument accuracy may be limited. 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 2022-11-25
Loading Status ERROR: Unable to find a usable engine; tried using: 'sqlalchemy'. A suitable version of sqlalchemy is required for sql I/O support. Trying to import the above resulted in these errors: - Pandas requires version '1.4.16' or newer of 'sqlalchemy' (version '1.3.5' currently installed).
Datastore Status ready
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
water_hub_qa_qc float8

Site

columbia_donald
Field Value
Site ID columbia_donald
Site Name Donald Bridge
Waterbody Type Stream/River
Waterbody Columbia River
Site Latitude 51.485053
Site Longitude -117.181349
Location Coordinate System WGS84
Site Elevation (masl) 775

Parameter

Water Temperature
Field Value
Parameter Water Temperature
Time Zone MT
Unit of Measurement degrees Celsius
Instrument Type Portable Multiparameter Meter
Instrument Manufacturer HANNA Instruments
Instrument Model HI98129
Instrument Accuracy ±0.5°C
Range -5.0 to 60.0°C
Resolution 0.1°C
Calibration Notes N/A
Notes on Method N/A
pH
Field Value
Parameter pH
Time Zone MT
Unit of Measurement standard atmosphere (atm)
Instrument Type Portable Multiparameter Meter
Instrument Manufacturer HANNA Instruments
Instrument Model HI98129
Instrument Accuracy ±0.05 pH
Range 0.00 to 14.00 pH
Resolution 0.01 pH
Calibration Notes pH is calibrated weekly
Notes on Method N/A
water_clarity_secchi
Field Value
Parameter water_clarity_secchi
Time Zone MT
Unit of Measurement metres
Instrument Type Secchi Disk
Instrument Manufacturer N/A
Instrument Model N/A
Instrument Accuracy N/A
Range N/A
Resolution N/A
Calibration Notes N/A
Notes on Method Methodology consistent with Invasive Mussel Field Protocol prepared by the Ecosystems Branch, BC Ministry of Environment and Climate Change Strategy