2017 Excellence in GIS Award Winner – Large Community

Excellence in GIS – Large Community (population over 50,000) – Utilities

Major Asset Data Collection & Update for Carmel’s Cityworks Asset Management and Work Order System.

The City of Carmel Utilities, with the help of the City of Carmel GIS, decided to move forward with an asset management and automated work order system utilizing Cityworks software.  The project challenge initially involved purchasing, installing and configuring new GIS software, ESRI’s ArcGIS, enterprise-wide.  The existing Carmel Utilities data had to be migrated from simple file geodatabases to ArcSDE (Spatial Database Engine.)  The database schema for every utility asset had to be updated and modified and the location and validity of every asset needed to be examined.  Additionally all missing assets needed to be located and added to the database.

The City of Carmel Utilities, Sewer Collections, was the first department to utilize the asset management and automated work order system. Responsible for the maintenance and repair of the sanitary sewer system containing 5532 manholes and 242.6 miles of gravity mains when field workers only had incomplete and inaccurate paper maps was quite a task.

The City of Carmel Utilities, Water Distribution is the second department to utilize the asset management and automated work order system.  Water Distribution is responsible for the maintenance and repair of the water system containing 5164 valves, 5326 hydrants and 529.6 miles of pipe.

The everyday use of the City of Carmel’s GIS data is growing rapidly. In the Sewer Collections department alone, the use of the GIS asset data has grown from one GIS technician to two and from 2 or 3 users in the field to over 25.  As shown in the figure below, the number of map requests from the Sewer Department via Cityworks on the utility map service through Portal for ArcGIS has now exceeded 20,000 hits or requests per day.

Dave McCoy, GIS Technician, City of Carmel GIS

Kurt Shanayda, GIS Technician, City of Carmel GIS

Pat Rigdon, Sewer Collection Operations Foreman/Inspector, City of Carmel Utilities

Micah Beck, Sewer Collection Operations, City of Carmel Utilities

 

Speak Your Mind

*

*