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)
The 1974 Canada, British Columbia Okanagan Basin Study report. The physical and chemical baseline for every lake in this project. Data site
DownloadPDF
Technical Supplement V, chapter 5Technical Supplement V, chapter 6Technical Supplement V, map platesFreshChapters 5 and 6 and the map plates are hosted here, so you get a file rather than a page. The OBWB landing page for this supplement embeds every chapter in a Google Docs viewer, twenty iframes on one page, which makes a browser try to save each one; that is why the library links the PDFs directly. Appendix C, the 1971 chemistry, is already machine readable: see EX13 rather than transcribing the scan.
Temperature and dissolved oxygen with depth, several stations, through the open-water season, extracted from L1 as tables. Data site
Technical Supplement V, chapter 5Technical Supplement V, chapter 6Technical Supplement V, map platesFreshfirst plot EDDIE Lake Mixing (a)
As above, for Skaha. Thinner coverage than Okanagan. Data site
Technical Supplement V, chapter 5Technical Supplement V, chapter 6Technical Supplement V, map platesFreshfirst plot EDDIE Lake Mixing (a)
As above, for Osoyoos, including the north basin. Data site, and in your Lab Assignment 1 readings
Technical Supplement V, chapter 5Technical Supplement V, chapter 6Technical Supplement V, map platesFreshfirst plot EDDIE Lake Mixing (a)
Hypsography for Okanagan and Osoyoos Lakes. Data site; the Osoyoos map is also your Lab Assignment 1 material
Technical Supplement V, chapter 5Technical Supplement V, chapter 6Technical Supplement V, map platesFreshfirst plot Lab 4 hypsography script (b)
Water Survey of Canada. Flows and levels at Penticton, Okanagan Falls, below McIntyre Dam and near Oliver. There is no active gauge on the mainstem between Oliver and the border. A cleaned daily set is on the data site; the live portal is wateroffice.ec.gc.ca
Water Survey of Canada portalOkanagan River at Penticton, real-timeOkanagan River at Okanagan Falls, real-timeOkanagan River near Oliver, real-timeOkanagan River below McIntyre Dam, real-timeVaseux Lake near the outlet, real-timeOkanagan Lake at Kelowna, real-timeFreshEach station link gives you the last 500 readings as a CSV you can open directly: station name, timestamp, water level and discharge. The live portal holds about 30 days; for the long record use the cleaned daily set here, and say which one you used, because the two do not line up at the join. There is no active gauge on the mainstem between Oliver and the border.
first plot EDDIE Stream Discharge (c)
Daily lake level and release at Penticton, several years, with the operating rules that govern them. Data site
High-frequency water temperature, 15-minute interval, one open-water season. Used in Lab 8. Data site
The Lab 7 station: Mission Creek above Gordon Drive (provincial station 08NM0012). 1 April to 31 October 2025, 15 minutes, 20,451 readings, columns timestamp and value. timestamp is UTC, not local time; value is water temperature in degrees C. These are the province's working (unapproved) data. There are 15 short gaps (27 hours in all, longest 6 hours on 1 to 2 July); the rows are absent, not zero.
first plot Lab 8 subsampling script (d)
What the river is doing now, and what it is about to do. temp.stream
The tool has export buttons: the Fish tab downloads its counts, and each station panel exports a PDF report and a PNG. If you want the underlying daily record rather than a picture of it, use EX19, which has every day back to 2002, rather than reading numbers off a chart.
Stratification and lake condition in the current season. OBWB ok-lake-physics tool
ok-lake-physics toolFreshRead the seiche panels as an explainer, not as a source of numbers. The section view says so itself: depth is exaggerated, time is compressed, and the amplitude is not modelled.
first plot EDDIE Lake Mixing (a)
Temperature limits and life history timing for sockeye and Chinook, drawn from the literature and referenced. Data site
One table, 26 rows. kind says whether a row is a temperature or a timing. Temperature rows are the BC water quality guideline (Tables 1 and 2) and Hyatt et al. 2003; timing rows are the Okanagan Instream Flow Needs periodicity table and the observed passage dates at Wells Dam computed from L14. Every row carries its source, page and link: cite the source, not this table.
Extracts from the International Joint Commission Osoyoos Lake Drought Study on the cool-water refuge. Data site
Hourly wind speed and direction from the nearest long-running Environment and Climate Change Canada station. Data site once the station is chosen; the ECCC climate portal meanwhile
Penticton A (Climate ID 1126146), hourly, 10 May 2012 to 15 October 2026, 126,504 hours. Chosen because its wind is closest to what the over-lake buoys measured; Kelowna airport is systematically calmer. timestamp_utc is UTC (ECCC reports local standard time, UTC-8, converted here). wind_dir_deg is the direction the wind blows FROM, to the nearest 10 degrees, and is blank in calm hours. Speed is km/h: divide by 3.6 for m/s. 292 hours report direction 0 with wind blowing, which ECCC coding does not define (north is 360); they are tagged in dir_qc, so filter them out of any direction analysis.
Wells Dam adult counts, public on Columbia River DART. Counts at Wells include fish bound for other rivers, so Canadian arrivals are lower. Okanagan-specific timing is held by ONA; ask the instructor before relying on it
Columbia River DART, Wells Dam adult passageHyatt, Stiff and Stockwell (2020), DFO Can. Manuscr. Rep. Fish. Aquat. Sci. 3206Alexander, Alameddine, Machin and Alex (2024), Environmental Management 74, 1063 to 1085Ward (2018), BC FLNRO, Update to Okanagan Region Timing WindowsManualThe file is Wells Dam daily adult sockeye counts and fishway water temperature, 1977 to 2026, from DART. Wells Dam counts include fish bound for other rivers, so Canadian arrivals are lower. Say which number you are quoting. A blank count is a day with no sockeye reported. Five days carry small negative counts exactly as DART publishes them, and 27 impossible temperatures were removed; both are tagged in the qc column. The Okanagan-specific timing is in the other three files, from public DFO and peer-reviewed sources: when fish pass Zosel Dam into Osoyoos Lake, how long they hold there, when they reach the spawning grounds near Oliver, and when fry emerge and smolts leave. Half the run passes Wells about 20 July, Zosel about 2 August, and reaches the spawning grounds about 14 October. The raw daily survey records behind the tables are not public and are not on this site.
Method and context. UBC Library; DOIs are in the Background handout
Hyatt, Alexander and Stockwell (2015), Canadian Water Resources JournalStevens and Lawrence (1997), Aquatic Sciences 59, 115 to 134Islam et al. (2022), Journal of Hydrology: Regional StudiesInternational Joint Commission (2011), Osoyoos Lake Drought Study, Study 4Levy, Johnson and Hume (1991), Limnology and Oceanography 36, 187 to 192Gushulak et al. (2018), Lake and Reservoir ManagementRead et al. (2011), Environmental Modelling and Software 26, 1325 to 1336Technical Supplement V, chapter 5Technical Supplement V, chapter 6Technical Supplement V, map platesChangedWater chemistry and biology from the labs, the water sample from field trip 1, and the Mission Creek gauging from field trip 2
- L17Instructor temperature casts, Okanagan Lake, July 20261, find it; 4, for what one cast can and cannot see
Stepped downrigger casts off Kelowna with HOBO temperature and light loggers, holds at 25, 50, 75, 100 and 125 feet, one afternoon. Temperature and light only, no oxygen; depths read from the downrigger counter. The most recent measured profile you have. Data site, with the data file and a short report
Two files: the cast itself, and the thermal habitat bands computed from it. Read README_L17 before you use either. Three things govern it: it is ONE cast on one afternoon at one location, the dissolved oxygen column is estimated rather than measured, and the 50 ft hold was only 74.6 per cent equilibrated when it was read.
first plot EDDIE Lake Mixing (a); Lab 4 script (b)
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).
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.
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.
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.
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.
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.
BC Data CatalogueFreshThe 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.
BC Algae WatchFreshInterior 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.
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.
Spreadsheet, all sheets (.xlsx)Daily table only (.csv)Database with every reading 2011 to 2026 (.duckdb)Not checkedThe 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.