MagpieBatchawanaWaterChem (English, CSV)
MagpieBatchawanaWaterChem: English CSV file you can open as a table, filter, chart and export up to 10,000 rows. From Fisheries and Oceans Canada, updated Mar 2026.
- Format
- CSV
- Access
- Table on demand (prepared when opened)
- Publisher-reported update
- 2026-03-24
The Magpie River ramping rate study (2000–2017) investigated the ecological effects of hydroelectric flow regulation on fish, invertebrates, and water quality in the Magpie and Batchawana rivers in the Algoma Region of Ontario. Conducted under a Fisheries and Oceans Canada–Brookfield Renewable partnership, the study employed a Before-After-Control-Impact (BACI) design to assess whether ramping rate restrictions at the Steephill Falls Waterpower Facility improved downstream conditions. Initial restrictions (2002–2005) were later removed, allowing unrestricted flow changes until 2017. In this dataset, monthly sampling from spring to fall included chlorophyll a and water chemistry at multiple sites to monitor productivity and detect irregularities. Analyses followed APHA standard methods, with chlorophyll a, pH, alkalinity, and conductivity processed at Fisheries and Oceans Canada, and major ions and nutrients at the Great Lakes Forestry Centre in Sault Ste. Marie, Ontario. Findings contribute to understanding flow management impacts on river ecosystems.
Data overview
- Formats
- CSV
- File languages
- English
- Available actions
- Explore table (prepared automatically) · Access original file
Sample rows
The first 10 rows, as CanQuery read them from the start of the publisher's file on 2026-11-04. Showing 20 of 55 columns.
| waterbody_name | station_id | latitude | longitude | date | year | pH | alk_meqL | conductivity_uScm | Ca_mgL | Ca_flag | Mg_mgL | Mg_flag | Na_mgL | Na_flag | K_mgL | K_flag | Cl_mgL | Cl_flag | SO4_mgL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Batchawana River | 2 | 47.060591 | -84.449091 | 2002-08-19 | 2002 | 7.57 | 0.41465 | 50 | 7.376 | NA | 1.339 | NA | 0.985 | NA | 0.445 | NA | 0.337084 | NA | 3.777143 |
| Batchawana River | 3 | 47.052639 | -84.458724 | 2002-08-19 | 2002 | 7.42 | 0.42026 | 50 | 7.361 | NA | 1.337 | NA | 0.976 | NA | 0.445 | NA | 0.310322 | NA | 3.906221 |
| Batchawana River | 4 | 47.048641 | -84.462085 | 2002-08-19 | 2002 | 7.4 | 0.39319 | 53 | 7.412 | NA | 1.344 | NA | 0.982 | NA | 0.452 | NA | 0.331259 | NA | 3.932243 |
| Batchawana River | 5 | 47.03362 | -84.481276 | 2002-08-19 | 2002 | 7.43 | 0.40808 | 49 | 7.606 | NA | 1.339 | NA | 0.996 | NA | 0.449 | NA | 0.315114 | NA | 3.832537 |
| Batchawana River | 8 | 47.165873 | -84.319847 | 2002-08-19 | 2002 | 7.47 | 0.41161 | 50 | 7.736 | NA | 1.344 | NA | 1.004 | NA | 0.449 | NA | 0.338951 | NA | 4.018081 |
| Batchawana River | 8 | 47.165873 | -84.319847 | 2002-09-26 | 2002 | 7.22 | 0.2811236 | 35.4 | 5.775 | NA | 0.875 | NA | 0.734 | NA | 0.3 | NA | 0.336808 | NA | 3.227646 |
| Batchawana River | 8 | 47.165873 | -84.319847 | 2003-05-08 | 2003 | 7.14 | 160 | 25.5 | 3.795 | NA | 0.591 | NA | 0.565 | NA | 0.241 | NA | 0.188186 | Below detection limit | 3.614947 |
| Batchawana River | 8 | 47.165873 | -84.319847 | 2003-06-18 | 2003 | 7.39 | 338.355 | 44 | 6.263 | NA | 1.02 | NA | 0.789 | NA | 0.26 | NA | 0.398832 | NA | 3.798592 |
| Batchawana River | 8 | 47.165873 | -84.319847 | 2003-07-10 | 2003 | 7.67 | 404.5874 | 49 | 8.291 | NA | 1.398 | NA | 0.969 | NA | 0.364 | NA | 0.569688 | NA | 4.007967 |
| Batchawana River | 8 | 47.165873 | -84.319847 | 2003-08-13 | 2003 | 7.34 | 345.3156 | 46 | 7.312 | NA | 1.027 | NA | 0.702 | NA | 0.238 | NA | 0.30575 | NA | 2.93453 |