Water Utilities

Implementing a Spatially Enabled Approach to Operational Efficiency Using ArcGIS Enterprise

By Mark Rees, GISP, GIS Analyst, City of Wentzville—Public Works

The city of Wentzville—also known as the Crossroads of the Nation—has a rich history that’s woven into the fabric of this thriving community. As the fastest-growing city in the state of Missouri, with a population of around 48,000, Wentzville embodies a unique blend of heritage and innovation. Wentzville’s journey has been shaped by a commitment to five critical success factors established by the board of aldermen: becoming a regional destination, fostering economic vitality, delivering exceptional city services, enhancing infrastructure connectivity, and cultivating a safe and welcoming community. This commitment drives the city to continuously educate and inform its residents and stakeholders about the factors that make Wentzville a place where history meets the future, ensuring responsible stewardship and fostering a sense of community pride.

The public works department is dedicated to maintaining and improving the quality of life in the community by planning for future needs, promoting environmental quality, building and maintaining municipal infrastructure, managing public capital improvement projects, and protecting the health and safety of the community. In addition, the department provides the design, construction, operation, and maintenance of public works and related services within the community in a manner consistent with the city’s vision.

I am the geographic information system (GIS) analyst within the water department. Over the past 25 years, I have used Esri technology to provide solutions to a myriad of challenges. My responsibilities have ranged from being a technician to a programmer analyst. I most enjoy using Python to automate tasks wherever possible. In August 2022, I had the opportunity to work for the City of Wentzville’s water department to help it grow its GIS presence within the utilities arena. Since then, I have developed various applications using both ArcGIS Online and ArcGIS Enterprise to aid in the transition from mostly a paper or spreadsheet documentation method to a spatially focused one.

Prior to implementing a spatially enabled solution, our method of notification for main breaks and/or boil advisories was time-consuming. We would receive a call from a water operator who would draw a static map to outline the area involved in the event. An email was constructed to be sent out with this map embedded as a JPEG image. During this time, our customer service staff would be inundated with phone calls requesting updates on the current event. We would also distribute door hangers for events that involved fewer than 30 residents.

Now, the use of an ArcGIS Online dashboard provides residents with the extent of the outage or event and reduces the number of phone calls received by residents. This dashboard and a custom email notification using Python provide up-to-the-minute updates on the status of any outages in our system.

The Public Outage dashboard is used to notify the public on water-related events in real time.

With the implementation of [the ArcGIS Online Outage Dashboard], our field utility technicians are now empowered to instantly publish communications and maps that depict and update the duration and location of system-outage, reduced-pressure, or boil-advisory conditions. This application saves valuable time during emergency repairs and dramatically improves our ability to communicate effectively and quickly with our customers.

Susan Spiegel, Public Works DirectorCity of Wentzville

To better manage the city’s utility infrastructure, the water department began collecting data on new water infrastructure as it was installed. ArcGIS Online was used to collect this information via a hosted feature layer. Initially, a Trimble DA2 device and ArcGIS Field Maps were used to collect fire hydrant locations citywide. Along with the location of each fire hydrant, information such as brand and size and a photo of the hydrant were collected. This was providing about one-foot accuracy for data collection. To better improve our accuracy, we have since implemented a Vivax-Metrotech locating wand, connected to an ArcGIS Online hosted feature layer. This technology provides from two- to six-inch accuracy. Due to the success of using ArcGIS Field Maps within the hydrant program, it was quickly expanded to collect the location of city-owned new construction including water mains, valves, and meter pits.

A dashboard is used to track all GPS data collection activities.

The implementation of the [GIS] in the water department has been a game changer. It has not only enhanced our operational efficiency by being able to easily and quickly add new sections of main to the utility map but has also empowered us to be able to update our current utility map with accurate information.

Tyler Schaefer, Water Supply SupervisorCity of Wentzville

Better Maintenance Management

Prior to ArcGIS Enterprise, the documentation of our various asset programs was handled using spreadsheets with no spatial component. Using ArcGIS Enterprise, we were able to utilize ArcGIS Field Maps and various mapping applications to better track progress on most of our annual and biannual programs. This allowed us to keep track of important information in a table tied to a specific asset. With a click of the mouse, we can identify what work has been performed on an asset, allowing for compliance with Missouri Department of Natural Resources regulations.

Water Valve Operations: An application shows green where a valve was successfully exercised or orange if a maintenance issue was identified on the valve.

In terms of maintenance tracking, we use ArcGIS Field Maps to enter maintenance issues as they are identified, so we can ensure that these issues are resolved in a timely manner. A future benefit of maintenance issue tracking is that we can better plan for tools and equipment to have on hand, which could help save money in reducing inventory holding costs.

Fire Hydrant Operations: The Hydrant Flushing application shows green where hydrants have been flushed, and orange where there was a maintenance issue identified during flushing.
Leak-Detection Operations: ArcGIS Field Maps and ArcGIS Enterprise were used to manage the placement and retrieval of leak-detection listening devices.

Report Automation Using Python

After creating various applications using ArcGIS Enterprise and ArcGIS Online, we needed a way to keep track of what work has been performed. We were able to achieve this by writing custom Python scripts to generate emails with pertinent information.

This Python script was written to determine current unresolved maintenance issues.

The following types of reports are generated nightly to ensure that we keep up-to-date on program progress:

Daily Program Progress Report

This email provides progress metrics for all the water programs currently used within ArcGIS Enterprise. These metrics include the work that’s been completed within the last 24 hours and the last seven days. This allows our supervisors to ensure that progress is being made so that we complete the scheduled work within a given work cycle.

Email reports list the current status of the work performed across all water programs, including work performed within the last 24 hours and over the past seven days.

Daily Maintenance Reports

This email provides a list of all discovered maintenance issues for hydrants, valves, and air release valves. The report organizes the list by subdivision to better organize the work and reduce time to resolving issues, by concentrating efforts spatially. The report lists each maintenance issue and the associated asset ID, closest address, and associated subdivision (if applicable). Once issues are resolved, they fall off the list since the report is generated daily.

Above is an example email notification from the maintenance issue report, which is generated by a Python script. The report identifies the asset with the issue, along with the closest address for geographic reference.

The use of ArcGIS Online and ArcGIS Enterprise has allowed the department to significantly increase efficiency of operations. Future goals include further automation of the public outage map using Esri’s ArcGIS Utility Network to specifically notify affected customers during outage or advisory events. I am excited to be part of what the future holds for the Wentzville Public Works Department in its use of GIS technology.

As the superintendent of Wentzville’s Water Division, I’m always seeking ways to enhance our operations. We decided to incorporate GIS into our operations and sought the right person to establish a system. With the addition of our GIS analyst, we’ve transitioned from paper to a digital system, making our operations more streamlined and efficient. This has significantly improved our water management and service delivery, positively impacting the residents of Wentzville.

Gary Spence, Water Division SuperintendentCity of Wentzville

Stay Connected with Esri’s Water Team

ArcGIS is an extensive information system that enables modernization of workflows with easy-to-use applications for the field and office. Strengthen your organization with smart water solutions that will increase efficiency and provide insight for decision-makers. Visit the Esri Water Utilities web site for more information.

Join the Water Utilities Community

Follow #EsriWater on social media: Twitter | LinkedIn

Subscribe to the Water Industry newsletter “Esri News for Water Utilities and Water Resources

Learn more about how Esri supports rural and small water.

About the author

Esri Water

Esri's Water Team focuses on all things water: water utilities (water distribution, wastewater, stormwater), water resources and everything in between. The team works with colleagues across Esri (solutions, professional services, product and more) to provide the best support for our customers and partners.


Next Article

Guadalupe Valley Electric Cooperative Streamlines the Pole Joint Use Process

Read this article