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.
The Village of Northbrook has recently launched the MapOffice Web Access tool called Business Intelligence. Business Intelligence is a tool that allows users to filter and display live data from community or custom databases.
Three attributes of Business Intelligence, filtering, visualization, and live data, make it a very powerful tool. Business Intelligence allows users to visualize data on a map by plotting that data by address or XY coordinates. Many times, community databases or software do not have great ways to display the wealth of data they hold. Business Intelligence helps solve this problem by connecting to those databases and displaying the data on MapOffice so users can gain further incite about the data or look for trends.
When looking for trends it is sometimes necessary to manipulate how you view the data. Business Intelligence permits the user to filter the data by date and/or a field within the data. For example, Northbrook has set up a connection to a custom home foreclosure database that allows users to filter foreclosures by date and the foreclosure status. Now the user can narrow the data that is displayed to show only what they are interested in.
Finally, Business Intelligence offers live connections to the databases. This can be extremely powerful as users can view and analyze data held in the database as it is updated without having to wait for data to be uploaded to MapOffice.
The Village of Northbrook looks forward to taking advantage of this useful and powerful tool by connecting to community databases and software such as FireHouse, an ERP system, and many others to come.