Abstract
Database Design and Process Modeling for a Drainage Utility GIS Track: Water, Wastewater, and Stormwater Author(s): Philip Campman The City of Austin's Watershed Protection and Development Review Department (WPDRD) has embarked on the development of an enterprise GIS constituting the drainage facilities that it owns and maintains. This project is directly related to a set of Capital Improvement Projects (CIP) being performed to research and collect attribute data from both hard-copy sources (construction plans, section maps, etc.) and field research. While groundwork was laid to gather a broad set of information that will be collected for the research/field projects, a comprehensive database design of the infrastructure along with a process for implementing a 'day forward' maintenance of the database had not been completed. This paper discusses the steps completed and decisions made in the development of the database design and work processes. Philip Campman City of Austin Watershed Protection and Development Review 505 Barton Springs Rd. Austin , TX 78705 US Phone: (512) 974-6314 E-mail: philip.campman@ci.austin.tx.us |