From first glance at google drive historic ECCC data it appears the TW_UnitValues_* files (ts_* spreadsheet in screenshot) have easier to interpret hourly temp values where as the QR_Provisional_* values (ts2_* spreadsheet in screenshot) are some sort of amalgamation of the hourly data by day that does not seem to compare rationally (at first glance) to the hourly values. In screenshot the value 85.91 is the sum of all hourly values for the ts_* data 2016-03-22 compared to the daily values for that day (and the day before) which are between 23 and 24....
Quality assurance procedures for ECCC data recorded in Summary_Quality Assured WSC Water Temperature Data by INRS_20220318.pdf on google drive with Quality/Interpolation/Approval code definitions available elsewhere (perhaps accessible through tidyhydat - not sure)
See general background detail here https://github.com/NewGraphEnvironment/restoration_framework/issues/6
Looks like we have real-time water temp datasets for the Bulkley at gov hydrometric stations
Details of how to retrieve the data is here https://gist.github.com/NewGraphEnvironment/0dbc6f6d184cfeb149501b58d2c91d21
Retrieved data is stored locally in sqlite
Location of google drive data returned from ECCC resulting from request recorded in issue https://github.com/poissonconsulting/fish-passage-22/issues/12 is documented there in that issue (backed up locally too).
From first glance at google drive historic ECCC data it appears the
TW_UnitValues_*
files (ts_*
spreadsheet in screenshot) have easier to interpret hourly temp values where as theQR_Provisional_*
values (ts2_*
spreadsheet in screenshot) are some sort of amalgamation of the hourly data by day that does not seem to compare rationally (at first glance) to the hourly values. In screenshot the value85.91
is the sum of all hourly values for thets_*
data2016-03-22
compared to the daily values for that day (and the day before) which are between 23 and 24....Quality assurance procedures for ECCC data recorded in
Summary_Quality Assured WSC Water Temperature Data by INRS_20220318.pdf
on google drive withQuality/Interpolation/Approval
code definitions available elsewhere (perhaps accessible throughtidyhydat
- not sure)