The Village of Mundelein, IL conducts annual hydrant maintenance in which the Public Works Department’s Water Division flushes each hydrant and creates a list of hydrants that need repair. After the flushing and maintenance is complete, the Water Division submits a report describing which hydrants where flushed and which hydrants were repaired. Previously, to track progress through the village, the Water Division would print out paper map pages created in CAD and highlight the streets with a maker as a way to indicate the areas they have worked on. In 2014, they asked the village’s Geographic Information Systems (GIS) office to create a simple map book, with a page created for each area that they were planning to work in, to make it easier for them to locate hydrants and track progress.
Using Esri’s ArcGIS Desktop software, the GIS office staff created this book, with each flushing area shown on 1-3 pages, with only the hydrants for each specific flushing area shown. A unique ID for each hydrant was also displayed on the individual map pages to allow staff to match a hydrant in the field to hydrant records in a corresponding Excel worksheet being updated with the information for each hydrant that was gathered during the flushing process. These cleaner looking and functional maps made locating the hydrants much easier than in the past. In addition to creating products to help locate the hydrants, the Director of Public Works requested that the GIS office also create a map once all work was completed showing which hydrants were flushed and repaired based on the final reports submitted by the Water Division flushing crews. This map was easily created using the existing map pages created for the hydrant locating map book and can be used moving forward to assist with planning future hydrant flushing work.
Using GIS, the Water Division now has a good visual tool for tracking hydrant flushing progress. They are also able to enhance their hydrant flushing reporting process by adding a graphic component that shows where the work was done and where they may need to focus their maintenance efforts in future years.