The Water Utility Reporting Examples are geoprocessing models to rate and visualize the condition of the water, sewer, and stormwater network. Outlined in this workflow are four examples of using these geoprocessing models to be used with or specifically designed for the water distribution network.

Identify mains with water complaints

The Identify Mains with Water Complaints geoprocessing model uses mains and service requests to allow a utility to visualize mains closest to these water complaints. The report generated can be used to aid in the Capital Improvement Planning process.

To generate a Mains with Complains report, complete the following steps:

1. Within the Water Utility Capital Planning map, navigate to the LocalGovernment.tbx > Water Utility Reporting Examples > Identify Mains with Water Complaints.
2. Input the utility's water mains and service requests layers.
3. Define the output Mains with Water Complaints Reporting layer.
4. Check Clear Existing to remove previous results.
5. Execute the geoprocessing model.
6. The resulting layer displays the mains that have dirty water complains in red and those without in green.

Pipe criticality

The Pipe Criticality geoprocessing model uses major roads, railroads, and critical customer meters to calculate a criticality score for water mains. This criticality score also takes into account the number of valves and customers that would be affected if the main was isolated.

To generate a Pipe Criticality report, complete the following steps:

1. Within the Water Utility Capital Planning map, navigate to the LocalGovernment.tbx > Water Utility Reporting Examples > Pipe Criticality.
2. Input the utility's mains, service connection, and trace summary report. Input railroads and major roads within the service area.
3. Define the output Pipe Criticality Reporting layer.
4. Check Clear Existing to remove previous results.
5. Execute the geoprocessing model.
6. The resulting layer displays the pipe criticality on a scale of excellent to immediate attention.

Remaining water pipe life

The Remaining Water Pipe Life geoprocessing model uses the utility's main layer and install data and material attributes to generate a remaining pipe life. The report created is designed to aid in the creation of CIP Projects.

To generate a Remaining Water Pipe Life report, complete the following steps:

1. Within the Water Utility Capital planning map, navigate to the LocalGovernment.tbx > Water Utility Reporting Examples > Remaining Water Pipe Life.
2. Input the utility's mains layer and life expectancy by material table.
3. Define the output Water Mains with Life Expectancy Reporting layer.
4. Check Clear Existing to remove previous results.
5. Execute the geoprocessing model.
6. The resulting layer displays the main's life expectancy on a scale from greater than 20 years remaining to less than 2 years remaining.

Breaks-leaks per 100 miles of main

The Breaks-Leaks per 100 Miles of Main geoprocessing model uses the utility's mains and leak report layers to calculate the number of breaks to miles of mains. The resulting report can then be used to aid in the creation of CIP Projects.

To generate a Breaks-Leaks per 100 Miles of Main per Area report, complete the following steps:

1. Within the Water Utility Capital planning map, navigate to the LocalGovernment.tbx > Water Utility Reporting Examples > Breaks per Mile of Main.
2. Input the utility's mains and leaks/breaks layer.
3. Define the output Number of Breaks per Mile of Main Reporting layer.
4. Check Clear Existing to remove previous results.
5. Execute the geoprocessing model.
6. The resulting layer displays the main on a scale from excellent to immediate attention based on number of leaks.