Skip to content
EESC 301 data library

Data library

Every dataset for the term project, where to find it, and which stage it helps. Use the ID when you cite a dataset in a gate memo or the assumptions register.

Some datasets arrive messy. Cleaning them up is part of the work.

This whole list, as a spreadsheet:CSVExcel

Start here

  • Stage 1, find it: L2, L17, L5, L7, L10 — then L3 for Skaha; L13 if you are the opportunistic team
  • Stage 2, move it: L6, L7, L9 — then L8 for what a real river temperature record looks like
  • Stage 3, test it: L11, L12, L4 — then L14 for when the fish arrive; L9 for the river now
  • Stage 4, prove it: L8, and the Lab 7 field trip — then L16; what Stage 4 mostly needs is what the other stages assumed

A starting point, not a fence. Any stage may use any row.

The library (17 rows)

Also available (19)

Public sources beyond the handout list, checked the same way. If you assume something, it should be because nobody has measured it, not because nobody looked.

Held here, ready to download

  • EX7Okanagan watershed group boundary

    The Okanagan River watershed group polygon from the BC Freshwater Atlas: the provincial definition of the basin boundary, 7,954 square kilometres. Held here as GeoJSON.

    DownloadJSON

    Held here, so you can download it directly. It is the hydrological watershed group, not the OBWB service area and not a regional district boundary. Projected in BC Albers, EPSG:3005.

  • EX12Okanagan Lake temperature and oxygen profiles, 2008 to 2009

    Temperature and dissolved oxygen against depth for the North, Center and South sub-basins of Okanagan Lake, on five dates between June 2008 and May 2009. Twelve casts, most of them 28 to 31 depths from the surface to 30 m, digitised from the Deep Okanagan Lake Biology Report (Larratt, 2009).

    DownloadCSVExcel

    The only multi-date, multi-basin, full-depth record with MEASURED dissolved oxygen in this library. It sits between the 1972 to 1974 profiles and the single July 2026 cast,. Four limits: the values are digitised from a printed appendix, five dates is a season and one spring rather than a time series, it stops at 30 m in a lake 232 m deep, and the three sub-basins differ so do not average them without saying so. Cite Larratt (2009), not this file.

    first plot EDDIE Lake Mixing (a)

  • EX131974 Basin Study Appendix C, water chemistry 1971

    Water chemistry against depth from the 1971 sampling behind the 1974 Basin Study: five lakes, 12 stations, four seasons, depths from 1 to 220 m, nine characteristics including nitrate, ortho-phosphate, chloride and silica. 3,991 rows, digitised from Appendix C with the printed value preserved alongside the cleaned one.

    DownloadCSVExcel

    This is CHEMISTRY, not the temperature and oxygen profiles: those are L2, L3 and L4. Two traps. Phosphorus is reported as PO4 in places and as P in others, and the conversion factor is about 3.066, so use value_as_P and say you did. And below_detection and not_determined are real flags: a blank is not a zero, so filter on them before computing any mean.

  • EX14Secchi and turbidity during the 2021 lidar survey

    Water clarity measured at 37 stations while the 2021 topobathymetric lidar was flying: Secchi depth from 0.75 to 8.5 m, with turbidity replicates and coordinates. The clarity that bounded how deep the survey could see.

    DownloadCSVExcel

    Clarity is why the best bathymetry of this lake still stops in the shallows: only 53 per cent of the bed was mapped and nothing below about 16.6 m returned. Use this to explain the limit rather than to guess at it.

  • EX15Okanagan Lake depth bands from the 2021 lidar

    Ten depth-band polygons for Okanagan Lake derived from the NV5 2021 topobathymetric lidar, as GeoJSON. The shallow margin only.

    DownloadJSON

    A hard limit and a datum trap. The lidar floor is about 16.6 m in a lake that reaches about 242 m, so these bands are the shallow margin, not the shape of the lake. And full pool is 342.48 m CGVD28, which is 342.688 m CGVD2013: treating 342.48 as CGVD2013 makes every depth about 0.21 m too shallow.

  • EX17Stratification metrics from the 2008 to 2009 profiles

    Thermocline depth, metalimnion bounds, buoyancy frequency, reduced gravity and two internal seiche period estimates, computed for each of the twelve casts in EX12.

    DownloadCSVExcel

    The seiche periods here are CALCULATED, not measured: a two-layer estimate from one cast and an assumed basin length. Both 90 km and 110 km are shown because the answer moves by about a fifth between them. This does not fill NA1, which is about a measured, published period. It is a worked example.

    first plot EDDIE Lake Mixing (a)

  • EX18Monthly stratification climatology, Okanagan Lake

    Typical surface and hypolimnion temperature, thermocline depth and reduced gravity by month, with whether the lake is stratified.

    DownloadCSVExcel

    A sanity check, not a measurement. If your calculation puts the lake strongly stratified in February, this is the table that tells you to look again. thermocline_m is NA in the mixed months on purpose: there is no thermocline when the lake is isothermal, so do not fill those with zero.

    first plot EDDIE Lake Mixing (a)

Provincial data portals

  • EX1BC Data Catalogue

    The provincial open-data catalogue. Aquifer classification, dams, water rights licences and hundreds of other layers, most of them free to download. Search it before you assume something does not exist.

    The R package bcdata queries this catalogue directly, which is usually faster than the web interface.

  • EX2BC River Forecast Centre

    The provincial authority on snowpack and streamflow forecasting. Snow bulletins, seasonal water supply forecasts and the automated snow pillow network.

    The water supply bulletins refuse automated requests but open normally in a browser. Snow pillow data is at the Automated Snow Pillow page.

  • EX3BC automated snow pillow data

    Snow water equivalent from the automated snow weather stations, including nine in the Okanagan. This is how much water was sitting in the snowpack that filled the lake.

    The R package bcsnowdata wraps this. Snow is the supply side of the cold water you are arguing about in August.

  • EX4BC Drought Information Portal

    Current drought level, 0 to 5, for each water basin in the province, including the Okanagan, with the supporting narrative.

    The class wording changes between editions. Quote the level from the portal on the day you looked, not from memory.

Groundwater

  • EX5Provincial groundwater observation wells

    Daily mean water levels for every provincial observation well, full history, as one bulk CSV. Several wells sit in the Okanagan valley aquifers.

    This is the whole province in one file, about 44 MB, with columns QualifiedTime, Value and myLocation. Filter to the Okanagan wells before you do anything else.

  • EX6GWELLS groundwater wells and aquifers

    Well records, aquifer assignment and the provincial aquifer classification, including whether an aquifer is hydraulically connected to a stream.

    Hydraulic connectivity is a field in the GWELLS record. Do not infer it from the aquifer subtype code; that is the mistake that looks right.

Water quality and blooms

  • EX8OBWB water quality monitoring

    The Okanagan Basin Water Quality Database and an overview of who monitors water quality in this basin, with links to the underlying studies and reports.

    This is a directory page, not a single dataset. It links the Okanagan Basin Water Quality Database, the BC water quality guidelines tool, and a long list of agency reports. Start from the database, then follow the report links for context.

  • EX9ECCC national long-term water quality monitoring

    Environment and Climate Change Canada long-term freshwater quality monitoring, including its British Columbia stations. Federal counterpart to the provincial EMS record.

    The dataset page carries the bulk CSVs. Filter to the British Columbia stations; the file is national. Check which Okanagan stations are actually in it before you build an argument on it, because federal coverage here is thinner than the provincial record.

  • EX11BC Algae Watch

    Provincial observation map for algae blooms, including cyanobacteria, where the public and agencies log blooms as they are seen. Where reported Okanagan blooms actually appear.

    Interior Health publishes advisories and beach guidance rather than data; if you want the observation records rather than the warning, this is the provincial map behind them. Observations are reports, not measurements: presence of a bloom, not a toxin concentration.

Local instruments and pointers

  • EX10Kelowna Yacht Club weather station, Okanagan Lake

    A Davis Vantage Pro weather station on the Kelowna Yacht Club dock, on the lake itself: air temperature, humidity, dew point, wind, rain and ET from 2 July 2014 to 19 August 2026, 733,714 records at 5 or 10 minutes. The only long over-water met record this project has.

    DownloadCSVExcel

    Provided by the Kelowna Yacht Club and posted with their agreement. The download here is hourly (89,946 hours, with n_obs saying how many readings went into each hour). The full 5 to 10 minute record is linked below as CSV and Excel. Three things govern how you may use it. The station owner asks that it not be treated as research grade, in their words: "we use basic level systems. So for scientific purposes, please do not use our numbers as extremely scientifically accurate." Wind is recorded in KNOTS, not metres per second. Timestamps are local clock time as logged and the daylight-saving convention is not documented, so do not convert to UTC as if it were known. There is no data from 26 November 2020 to 29 August 2022.

  • EX16Where the bathymetry of Okanagan Lake actually is

    The best bathymetry that exists for Okanagan Lake is the NV5 2021 topobathymetric lidar: 0.108 m vertical accuracy at 95 per cent, but it mapped only 53 per cent of the bed and returned nothing below about 16.6 m. The only measurement below that is the 1966 BC Fish and Wildlife sounding survey, six sheets showing a maximum depth of 794 ft, 242.0 m. All six sheets are posted here, with a map of where the lidar did and did not reach.

    DownloadPDF

    Six PDFs, one per 1966 sheet; sheet 1 covers the Penticton end. They are scanned paper maps: not georeferenced, contours in FEET, vertical datum not stated, and the province says they are not for navigation. The lidar itself is 174 GB and is held by OBWB; what is posted is its coverage, as GeoJSON, splitting Okanagan and Osoyoos lakes into the 52.5 per cent the lidar mapped and the 47.5 per cent it did not. The gap between 16.6 m and 242 m is itself a finding: the productive depth band of this lake has no modern survey.

Also here

  • EX19Okanagan stream temperature, 2002 to present (master record)

    Daily mean, minimum and maximum water temperature at the Water Survey of Canada gauges, 2002 to the present, with a quality grade on every day.

    The long version of L9. One row per gauge per day (UTC days): tw_mean_c, tw_min_c and tw_max_c in degrees C, a qc_grade (A best, D not representative of the day, U a real-time daily mean with no grade) and the source it came from. Read the README and Data_Dictionary sheets first. Okanagan gauges start with 08NM; the 08NL (Similkameen) and 08NN (Kettle) gauges are outside the Okanagan watershed and are labelled that way in the basin column. Mission Creek is 08NM116 (from December 2015; the first year is graded D). This is Water Survey of Canada output that WSC has not quality-assured; the grades are the Okanagan Basin Water Board's. The files are rebuilt every few hours, so note the date you downloaded them.

Not available, and that is the point

If your work needs one of these, assume it. Say where you used the assumption. Carry its uncertainty through to your recommendation. In stage 4, treat these gaps as findings, not as roadblocks.

  • The period, size or frequency of the internal seiche in Okanagan, Skaha or Osoyoos Lake. Nobody has published it; consultants hold unpublished measurements.
  • The depth and shape of the intakes at Penticton, Okanagan Falls, McIntyre or Zosel.
  • Depth-area curves for Skaha and Vaseux.
  • Recent deep-water dissolved oxygen profiles for Skaha. Not yet confirmed either way. If it turns up, it joins the library.