Abstract

Paper
Challenges in Developing a City GIS Wastewater Geo database System
Track: Water, Wastewater, and Storm Water
Authors: Linus Smith

The City of Winfield Kansas recognized the need to fully utilize the capabilities of GIS technology to support the maintenance of its aging wastewater sewer and treatment system. The City currently utilizes a SDE SQL multi-versioned database for maintaining its base map layers and to support its gas, electric, and water utilities. The wastewater GIS system was absent of a user-interface and consisted of shape files that were originally built from inaccurate CAD data and drawings. To build a more accurate and functionally GIS system, RTK GPS was utilized, the database was re-designed, a user interface was built in the .NET framework, digital video was incorporated, and existing lines, spreadsheets, and log book information was migrated into a SDE SQL multi-versioned geo database. This paper discusses the field collection, database building, and personnel challenges of building and implementing a GIS wastewater system for a city on a limited budget.

Linus Smith
City of Winfield, Kansas
200 E. Ninth Ave
P.O. Box 646
Winfield, Kansas 67156
United States
Phone: 620-221-5526
Fax: 620-221-5594
E-mail: Lsmith@winfieldks.org