The Regional Municipality of Waterloo (RMOW) provides water to a combined population of more than half a million people in three urban municipalities and four rural townships. It covers an area of 1,369 km2 (528 square miles). More than 100 groundwater wells supply approximately 80% of the Region’s needs, with the remainder drawn from the Grand River. RMOW operates five (5) separate water service areas that provide treated water to one or more communities. The Region maintains a complex water infrastructure comprised of numerous supply sources, pressure zones, reservoirs, and pumping stations.
With access to over 6,300 SCADA tags across four (4) historians and a water quality database with more than 6,600 unique tags, Waterloo Region is truly leveraging the power of the Eramosa Reporting and Information System (e.RIS) to centralize data from many different sources.
Every morning e.RIS emails a series of daily flow check reports to RMOW supervisors and compliance experts. Delivering the previous 30 days’ worth of data in charts and tables for over 40 sites, e.RIS presents a robust overview of the entire Regional network. A multi-coloured palette of highlights immediately notifies the recipients of a variety of conditions, including discrepancies between well flow and discharge volumes, values outside normal operating ranges, and any quality issues requiring attention.
Harnessing e.RIS Web Data
Waterloo Region is the first to use e.RIS data connections beyond the scope of conventional SCADA. Thanks to the expansive flexibility of e.RIS to hook into almost any data source, RMOW can retrieve not only operational data, but also meteorological, hydrological, electrical, environmental, and laboratory data all within one intuitive interface. An infinite sea of analytical possibilities stretches ahead with instantly accessible e.RIS Web Data from Environment Canada, the Grand River Conservation Authority, the Independent Electricity System Operator (IESO), the Ontario Energy Board, the Southern Ontario Water Consortium, the University of Waterloo, and many others.
Combining Disparate Data
With hourly energy prices now available on demand within e.RIS, Waterloo Region has embarked on a bold new strategy to predict energy consumption costs. e.RIS tracks key performance indicators such as kilowatt hours consumed and cost per cubic meter of water treated. Combining electricity rates from the IESO with data from SCADA-linked power monitors, the complex billing formulas of local hydro distributors are replicated within e.RIS to automatically predict energy costs.
Reducing Workload Through Validation
With a view to conquering annual reports in just a few clicks, RMOW has unleashed the power of the e.RIS data validation engine to rapidly flag, annotate, correct, and verify mountains of data within minutes. Launching into new territory with automatic review, millions of data points are assessed for compliance thresholds, static values, no flow conditions, and critical control limits. The small collection of remaining values are thrust front and centre for manual review, reducing the workload to a tiny fraction of its previous expanse.
Validated data sets can be used in conjunction with the new e.RIS Blueprints and Mappings feature. Drastically reducing the time required for report creation, Blueprints and Mappings will allow a single report design to serve up validated data for dozens of distinct sites. The compliance team will be able to instantly display verified annual maximums and minimums for any site simply by choosing it from a menu.
To find out more about e.RIS, contact: