Title: GIS, SEWERS & MOMS – The Atlanta Story

Abstract

The City of Atlanta (COA) contracted the Program Management Team (PMT) under Clean Water Atlanta (CWA) to assist them with compliance to a Consent Decree, issued by the U.S. Department of Justice in 1999, to reduce the number of overflows from their sanitary sewer collection system. PMT is comprised of a joint venture between Montgomery Watson-Harza and KHAFRA, as well as numerous sub-contractors. This paper will focus on how web-based mapping tools can dramatically change and improve the method in which cities conduct day-to-day sewer operations and hopefully, aid in compliance to the Consent Decree.Working side by side with the City's Watershed Management Engineering Information System Division, KHAFRA has assisted in the effort to improve the city's mapping system by converting their CADD based sewer drawings to a GIS format. Simple, yet vital -this transformed a purely graphical representation of the city's collection system to a multi-dimensional information based system. Having their collection system in a GIS database provides sewer operations employees with a powerful tool to perform complex spatial calculations and queries especially when combined with other layers such as topography, hydrology, soils, geology and transportation to name a few. It also serves as an extremely helpful planning tool for Maintenance Operations Management System (MOMS).KHAFRA also implemented a system, whereby this GIS information can be accessed/ distributed via an Internet Mapping interface and conventional web-based tools. This effort allows every employee access to the GIS information, through their web browser, without requiring the user to load and maintain expensive, sometimes complicated, GIS software on their personal computer system.In addition, KHAFRA was tasked with building an enterprise-wide GIS system. These data are stored in an Oracle database and accessed through ESRI's Spatial Database Engine (SDE). Enterprise-wide GIS is a term used to indicate that many different users can access and update a GIS database simultaneously without loss of information or corruption of datasets. This becomes very important in large organizations where multiple departments need access to and assist with maintaining different datasets used in the Geographic Information System.Finally, KHAFRA has built on-line tools to ingest, QA/QC, track and report weekly work performed by the sewer operations field crews. In turn, data that has been entered can be WEFTEC ® 2003 queried by group, activity and/or date all through an online interface. This gives city managers and staff alike an easy Internet-based tool to query and analyze not only their own work performed during certain periods but also the work performed by others. The system allows this query to be pulled into a spreadsheet or database. In addition, the system allows the user to plot a map based on their query. Using this type of interactive mapping, city staff and managers can view the overall fieldwork that has been performed in the city as well as look for specific work perf...