Abstract

Identifying Maintenance Performance Deficiencies Using GIS and SQL Server
Track: Water, Wastewater, and Stormwater
Authors: Jeff Van Note

A problem faced by Field Operations supervisors is to identify wastewater and stormwater infrastructure where maintenance has not been done in time to meet performance standards. Tabular reports were considered, but GIS offers visualization capabilities that aid in quickly understanding the performance issue and provides access to additional information via hyperlinks to SSRS reports.
The challenge involved relating maintenance history to versioned feature classes, where the GIS model differs significantly from the CMIS. The solution employs multiversion views, the SQL Server geometry data type, and stored procedures to aggregate maintenance history and populate feature classes in GIS for visual display of maintenance history.
Supervisors may review maintenance issues with ArcMap or the ArcGIS Server web mapping application.
Since these layers have been created, a better understanding of issues has allowed us to modify preventative maintenance work orders to bring us closer to our standard of 100%.