Greater Cincinnati Water Works Uses Sedaru for Water Quality Analytics and Operational Awareness

Posted by whitefrog

ARCADIA, CALIFORNIA, December 22, 2014 – Greater Cincinnati Water Works (GCWW) uses Sedaru to enhance its water quality sampling program and increase operational awareness. The industry’s real-time solution to connect organizational data, systems, and people across the water enterprise, Sedaru leverages proven hydraulic, asset and operational management analytics so utilities can anticipate water operations, understand impacts and solve problems for energy, quality, water resource, and asset management initiatives. 

GCWW serves over one million customers, with 3,100 miles of piping. GCWW identified a need to integrate its water quality data, systems and workflows to minimize data loss, to reduce time spent by staff receiving and interpreting data from static, different, and disconnected data sources, and to improve data reporting, trending and presentation.  The goal was for staff to be automatically prompted by alerts or notifications and be presented with the information that they need to take action readily. To address these issues, GCWW uses Sedaru to optimize water quality sampling, notification, and reporting procedures, as well as to enhance the interconnectedness and communication of the sampling group. 

Sedaru Helps Transform Water Quality Data Handling at GCWW

GCWW routinely collects more than 400 water quality samples per month from close to 100 locations in its distribution system to comply with the Total Coliform Rule. Historically, this process involved manual, spreadsheet-driven data entry without map interaction, which then required staff to again upload the data into a separate, disconnected database that was used for data validation, archiving and compliance reports.

GCWW needed to transform its water quality sampling process to become aware of potential quality compliance breaches in a more proactive manner, while gaining greater benefits from the time and resources invested in this critical operational workflow. GCWW also needed real-time data entry using lightweight mobile devices in the field, GIS-based mapping, and an office-based operating platform to record data within a centralized database for monitoring, detection, response, and analytics against water quality events and trends, while being correlated with results from a computer model of its water distribution system.

GCWW worked with IDModeling to deploy Sedaru , utilizing the latest secure, cloud-based technology to automate the water quality data collection process, while leveraging scalable mobile devices to capture data. These data now all reside in a central, secure, and shared database with other engineering and O&M data for collaborative mapping for operations and maintenance decision-making. GCWW now inputs information one time in the field, and that information is integrated with SCADA, GIS, hydraulics, and real-time alerts for a dynamic operational display in the office, where real-time communications can be initiated. 

With Sedaru deployed, GCWW now experiences more accurate data collection, with less time spent in the field. Real-time updating of collected data in Sedaru enables tracking of work, real-time information on systemwide water quality, and automatic alerts.

“We are very pleased to partner with GCWW to help streamline their water quality data handling, increase awareness, and deliver actionable insights throughout the utility on this mission critical workflow,” said Mr. Paul Hauffen, IDModeling’s CEO. “GCWW is a recognized industry leader in deploying forward-thinking technology to optimize the management of their system.” 

A Summary of Enhancements to GCWW’s Work Process with Sedaru In Place

Work Task

Before Sedaru

Improved Process With Sedaru…

Assigning sampling tasks

Supervisor creates a  spreadsheet of sample sites for the day. Samplers come into office to pick up the spreadsheet, then perform sampling in the field.

Spreadsheet is automatically created and delivered to a supervisor, who fills in  assignments. Sedaru  creates the tasks automatically. Assignments show up on samplers’ iPads at the start of each day.

Entering sample data

Samplers record data in
spreadsheet in the field.

Samplers enter data on iPads once, they are collected in Sedaru,  and no more data entry is needed.

Submitting data to WQ DB

Samplers upload the
spreadsheet to the water
quality DB manually at the end of the day.

Sedaru automatically runs scheduled data collection processes, and submits updates to the water quality DB.

Data validation

Data is checked at the end of each day when summary spreadsheets are submitted to the water quality DB.

Data is validated in real time as users enter data in the field.

Receiving water quality alerts

Samplers call from the field,
or supervisors are alerted about an issue from the water quality DB report later in the day.

Real-time alerts are provided in Sedaru for proactive event response and planning.



About Sedaru: Sedaru is the industry’s smart water enterprise software, preparing water/wastewater utilities for their mission critical tasks to understand and take control of What Happens NextTM. Sedaru saves failing infrastructure, reduces water loss and energy costs, enables compliance, and powers informed decisions across the utility enterprise.

To learn more, please call (626) 244-0700, email:, or visit:

Leave a Reply