Water Utility Improves Water Quality Management by Integrating Four Software into One
Riverside Public Utilities
Riverside, CA
Riverside Public Utilities (RPU) was using several software programs to manage their data, leaving it siloed and isolated. Using a new integration tool, RPU was able to centralize thousands of data points on a customizable dashboard that helps the operations team quickly analyze and implement solutions.
Topics Covered
Funding
General Fund/Existing Public Funds
Project Status
Operational since 1996
Gov Champion
Water Quality Administrator
Problem Addressed
Riverside Public Utilities was using four different software programs for water quality and data management.
The utility used WaterTrax for water quality management, OSISoft PI System to centralize data sourced from other business systems including SCADA, Esri GIS, and Asset Management/Work Order System (UWAM).
This left information compartmentalized and decentralized, making it hard for Riverside’s Water Quality Administrator to make decisions despite having access to real-time data.
Upper management had to manually extract data from each of the four software and create reports in order to understand it. This ate up precious resources and required users to have high expertise while utilizing these platforms.
Ultimately, the staff had access to robust data, but its segmentation made it difficult to organize and determine overall water system health. This hindered water administrators' ability to make effective, informed decisions, creating inefficiencies in the water system at large.
Solutions Used
Riverside Public Utilities integrated their four software programs into one, giving water quality administrators a holistic view of their water system samples.
Housing the data in one system provides a comprehensive overview of Riverside Public Utilities' distribution system samples, treatment plant process control samples, and groundwater well samples. The data automatically funnels into a centralized system has made the process of data compilation and report generation significantly more efficient.
Riverside Public Utilities used Aquatic Informatics' WaterTrax API to seamlessly and securely integrate its previous systems with it's 3rd party systems -- BI tools, CMMS, GIS and more.
The integration creates visual displays from the PI System that automatically updates when new data becomes available, allowing management to view the dashboards in real-time. The dashboard contains combined information from SCADA and UWAM, centralizing all data in one place.
Riverside Public Utilities' groundwater wells and treatment facility effluents blend prior to entering the distribution system. Real time data from SCADA is integrated in a Blend Model dashboard, where over 500 calculations run real time and show operators the blend at each transmission main, as well as when entering the distribution system. If there is a change to the blend that exceeds the established set points, the water quality team gets an email or text message alert. The operational team can quickly provide corrective action before endangering public health.
Water quality data from WaterTrax and service requests from UWAM are plotted on a map in ESRI GIS and displayed on a dashboard, allowing staff to quickly prioritize actions. With the visual representation of data, administrators can see the location of service calls alongside chlorine residuals and compare historical and real-time data for trend analysis and forecasting. With greater system visibility, management can better allocate personnel for quicker response times.
“The API integration has really improved our ability to quickly make decisions based on real time data”, said Robin Glenney, Water Quality Administrator at Riverside Public Utilities. “The advantage of combining information from SCADA, UWAM, and WaterTrax gives us the big picture in one place and allows us to improve performance and operational efficiency,” Glenney concluded.
Outcomes
1
Automatic, seamless integration of data coming from multiple software systems into one platform providing a holistic view on the health of the water system.
2
Custom dashboards providing visual representation of data, enabling quick analysis and insight for more effective operations through greater system visibility to better allocate personnel
3
Streamlined regulatory compliance by defining which data to include using a set of criteria or filters such as collection date range, sampling locations, or analytes.
4
Faster Decision-making and responses as a result of real-time, auto generated alerts triggered when water quality falls outside of set parameters.
5
An elimination of duplicate data, improved data accuracy and greater confidence in the data at large, allowing for more effective decision-making
Lessons Learned
1
Utilizing connections with trusted vendors can streamline new capability integration
Something Unique
As an innovative public utility serving 70,000 customers, RPU has developed an initiative - Utility 2.0 - which is essentially a strategic plan that addresses big challenges that all utilities are facing today. As a result of this commitment, RPU has successfully fostered a culture of innovation that resulted in a speedy integration with a stringent quality assurance testing process, ensuring the accuracy of their data.
Who Should Consider
Water utilities that are looking to streamline regulatory compliance practices, improve data integrity and accessibility.
Last Updated
May 11th, 2022More resources about this case study
Keywords