Overview

This offering integrates GIS data, SCADA data, and meter information for an entire system and/or smaller subsets that are contained in the system. The integration is done through database views or via nightly Python scripts depending on the client's environment and preferred workflows. Once the data is integrated, the client can analyze the amount of water going into a selected area along with the water usages for that area. Water usage may include flushing data (both manual and automated), bulk water sales, leaks, and customer usage. The delta between the water in and the water used is the water being lost or non-revenue water usage. When filtered on smaller contained areas, this information can provide guidance to the client about where further investigation is needed to identify potential leaks, theft, or broken meters. Additionally, showing a list of active customers with 0 water usages for a given time period can help to identify broken meters that are causing water losses. 

Services/Deliverables

• Configuration of a dashboard to display known water usage and potential non-revenue water losses
• Integration between SCADA, billing database information, and GIS through database views and/or nightly scripts
• Configuration of automated monthly and/or annual reports that summarize water usages and water losses

Key Benefits

• A better understanding of water usage throughout your system
• Use of existing GIS investment to proactively identify water losses
• A central location to track all water usage information
• Enhanced filtering and summarization of water usage data by area to assist with monthly and annual reporting needs
• Automated reports generation of compiling source data