Abstract

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.

Dan Hilyer
Opelika Utilities
502 Geneva St
Opelika , Alabama 36803
United States
Phone: (334) 705-5500
E-mail: dhilyer@owwb.com

Denise Martin
Geographic Information Services, Inc.
216 Aquarius Drive
Suite 312
Birmingham , Alabama 35209
United States
Phone: (205) 941-0442
Fax: (205) 941-0443
E-mail: dmartin@gis-services.com