City of Iowa City, Iowa
The City of Iowa City Water Division wanted to create a GIS-based tool to help prioritize distribution infrastructure. The city completed a water distribution study that included a water distribution model; however, the city lacked a cohesive way to interpret the data and move toward data-driven decision making.
Since several variables needed to be examined and ranked, the city wanted a tool to automate the data analysis and make decisions in a prescribed way. Bolton & Menk developed an objective matrix to prioritize water main replacements. By using the Python programming language, we developed a custom tool within the city’s existing GIS framework. We helped identify methods in which the available data could be queried, mapped, and reported. The outcome is based on a configurable search engine that ranks many parameters including critical customer service, pipe diameter, age, break history, and available pressure. The water main segments that meet these pre-determined criteria are flagged, displayed, and exported into several city-defined formats.
Implementing a GIS-based tool provides the city confidence in identifying replacement priorities. This custom prioritization tool provides a common platform and standardization across multiple data sets.
Named one of the very best workplaces in the State of Minnesota! We’re proud to rank in the Top 50 on the list, and even prouder that we were voted in by our own employees.