The City of Barrie is located in Central Ontario and is north of Toronto. The community surrounds Kempenfelt Bay on the western side of Lake Simcoe and has a current population in excess of 136,000 residents. Barrie sits within the northern part of the Greater Golden Horseshoe, a densely populated and industrialised region of Ontario.
The wastewater treatment system has six (6) major pumping stations and one (1) Water Pollution Control Centre. This centre treats all domestic, commercial, and industrial wastewater and discharges treated water into Lake Simcoe. The plant uses ultraviolet for disinfection instead of chlorine.
The City has over 35,000 SCADA tags and 800 Lab tags. By using the Eramosa Reporting and Information System (e.RIS), it allows the City to centralise and query data from multiple platforms. The following sections highlight some of the specific projects completed for the City of Barrie.
Importing Third-Party LIMS Results
The City has an in-house lab for measuring wastewater quality from multiple processes. Results from these in- house lab tests are inputted into e.RIS via Manual Entry Forms. Data captured by these forms is used to create a daily report and is the focal point of a daily review meet- ing between Lab Technicians and Management.
Test samples are also sent to an accredited third-party lab for independent analyses with the laboratory information management system (LIMS) results returned to the city as CSV files. Before e.RIS, these values needed to be inputted by hand into Excel. To solve this problem, Eramosa created a CSV import tool that allows these values to be imported into the system and saved as tag data. These records, along with data from their SCADA systems and other sources, can be queried and reported on with- in e.RIS.
Reducing Effort with Manual Data Entry Forms
Operators need to make sure the plant is operating at peak efficiency. The way they do that is to take measurements at consistent intervals. This process used to entail the operator writing values down on a clipboard during their morning rounds. Later in the day, the values would be entered into a Microsoft Excel spreadsheet. This two- step process meant values were recorded twice by two different operators with the second step introducing the possibility of data replication errors. There was also no audit trail for when an operator entered a value and stored values on the sheet could be changed by anyone.
Eramosa introduced the concept of Manual Entry Forms that mimic the layout of the clipboard sheets. Operators can now enter daily values directly from any corporate terminal and are accountable for the values they enter and change. Excel reports have been replaced by e.RIS reporting as the entered values are now accessible by the system. Calculations previously done by Excel were moved to the PLCs and within e.RIS.
Improved Regulatory Reporting
The Municipal Utility Monitoring Program (MUMP) is a Province of Ontario requirement for all municipalities that send effluent back into the environment. Prior to e.RIS, operators would input data values into Excel from their historians and LIMS systems before exporting it as a PDF for submission to the Province. Eramosa introduced an electronic reporting option so operators can use e.RIS to populate the final MUMPs report automatically. This reduces the need for duplicate data entry work and eliminates the chance of wrongly entered or calculated values.
To find out more about e.RIS, contact: