Abstract

Developing an ArcGIS Extension for Stormwater Utility Information Management
Track: Water, Wastewater, and Stormwater
Authors: Derek Mair, Todd Pulsifer

City of Columbus,Ohio has a stormwater utility that uses impervious area as its basis for billing. AutoCAD was used to manage the impervious areas with the original development of the utility in 1993. In 2007, the City sought an upgrade that would improve the following: 1) handling of orthophotography; 2) handling of polygon holes; 3) database integration; 4) multi-user editing. The City selected EMH&T to develop an ArcGIS solution with those features that could also manage associated documents and tracking information. EMH&T created an ArcGIS extension called the Stormwater Utility Management System (SUMS). This paper discusses the design and development of the data model and application extension (.NET C##). We will also present the details of the extension that make it user-customizable and how it has been integrated with the City's utility billing system. The steps to transition from an AutoCAD solution to the ArcGIS solution will also be outlined.