Opelika Utilities Geodatabase design and Pilot Project
Track: Water, Wastewater, and Stormwater
Author(s): Dan Hilyer, Denise Martin
In 2007, Opelika Utilities initiated a geodatabase design and pilot project to improve the efficiency and effectiveness of their workflow. The project involved the development of a customized water distribution data model based on the Esri ArcGIS Water Utilities Data Model, a geodatabase implementation of the data model, and an automated ETL tool to populate the geodatabase. In addition, attribute and domain lists based on the standard data model were installed on GPS equipment. A section of the water utilities point features were collected, ETL tools were applied to populate the geodatabase and a geometric network was created to support the evaluation of service interruptions. Connections to other departmental data sources, such as the Billing System, Hydraulic Model database, hydrant flow data, and water quality data, were created. This presentation will describe the process and lessons learned in developing the data model and integrating GPS and ArcGIS technology.
502 Geneva St
Opelika , Alabama 36803
Phone: (334) 705-5500
Geographic Information Services, Inc.
216 Aquarius Drive
Birmingham , Alabama 35209
Phone: (205) 941-0442
Fax: (205) 941-0443