Rainy Lake Hydrology

Computational notebooks analyzing the hydrology of the Rainy River watershed on the Minnesota/Ontario border.

View project on GitHub

Rainy Lake Hydrology

This repository holds a collection of computational notebooks analyzing the hydrology of the Rainy River watershed on the Minnesota/Ontario border.

Rainy River discharges of over 50,000 square kilometers, which is greater than the area of Switzerland and slightly less than than the area of the state of West Virginia in the U.S. The Rainy River Basin is part of the Canadian Shield which is the largest freshwater surface are in the world. Fully 25% of the world’s wetlands are in Canada, and 7% of the world’s renewable water supply.

Usage

The code, data, and descriptive materials are available as public github repository. The notebooks were developed and can be executed in the open source Anaconda python distribution available at no cost from Continuum Analytics.

Presentations

A summary of presentations based on the data and calculations in this repository.

Data Sources

The following notebooks provide tools to access relevant level, flow, and precipitation data for an analysis of the hydrology of Rainy Lake. These notebooks ‘pickle’ relevant data series as Pandas series and dataframes for import into other notebooks.

  • Water Survey of Canada - HYDAT. Reads data from the HYDAT data tables extracted from HYDAT.mdb. Creates data caches data/WSC_FLOWS.csv, data/WSC_LEVELS.csv, and data/WSC_STATIONS.csv for use in other notebooks. This is a time-consuming operation that only needs to be done on updates to HYDAT.
  • Water Survery of Canada - Usage Includes mapping functions, and several use cases including flow distributions on state-of-nature streams in the Rainy River watershed.
  • Namakan Lake Water Levels. Reads the WSC data cache to create a time series data/NL.pkl of historical levels for Namakan Lake. Level data from stations located at Namakan Lake above Kettle Falls and at Squirrel Island and are concatenated, with means used for overlapping dates.
  • Rainy Lake Water Levels. Reads the WSC data cache to create a reconciled time series data/RL.pkl of historical levels for Rainy Lake. The difference in reconciled measurements at Bear’s Pass and Fort Frances is used to estimate a standard error for lake level measurement.
  • Rainy River Flows. Reads the WSC data cache to create a time series data/RR.pkl of historical flows for Rainy River.
  • Global Historical Climatology Network. Reads historical temperature and preciptation records for station KINL located at International Falls, Minnesota.
  • Ice Out Dates. Creation of time series for historical ice-out dates on Rainy Lake using data from the Minnesota DNR.
  • Rule Curves for Rainy and Namakan Lakes. Creates dataframes NL1970, NL2000, RL1970, and RL2000 representing the rule curves for Namakan and Rainy Lakes. The notebook also contains data for the rule curve orders for 1949 and 1957.
  • Stage-Volume Relationships for Rainy and Namakan Lakes. Regression of Stage-Volume data from the International Joint Commission for Rainy and Namakan Lakes.

Analysis of Lake Level Behavior 1970-2010

Mitigation through Advanced Control and Optimization