WHY NOT ADD A RELATIONAL DATABASE/GIS TO YOUR COLLECTION SYSTEMS MANAGEMENT TOOLBOX?
Authors: Trypus, John; Drews, Paul; Mattingly, John; Witwer, Michael
Source: Proceedings of the Water Environment Federation, WEF/CWEA Collection Systems 2002 , pp. 494-503(10)
Publisher: Water Environment Federation
Abstract:Relational database management systems and geographical information systems (GIS) are useful tools for managing voluminous amounts of data for more effective utility management. Developing a computerized maintenance management system (CMMS) can be accomplished with off-the-shelf software and an understanding of relational database systems. The District of Columbia Water and Sewer Authority's (DCWASA) Potomac Interceptor (PI) Branch did just that with the creation of the Potomac Interceptor Relational Database and GIS Management System. Implementation of the database allows for tracking the periodic maintenance of the interceptor, as well as assisting with regional planning and capital improvements to the sewer. The project has resulted in targeting areas of concern for possible rehabilitation or replacement of pipe segments, verification of structure and invert elevations as compared to the floodplain and regional groundwater elevations, assessment and tracking of odors and odor complaints from specific areas along the sewer, and a repair schedule for the damaged or defective structures identified in the condition assessments.
Document Type: Research article
Publication date: 2002-01-01
- Proceedings of the Water Environment Federation is an archive of papers published in the proceedings of the annual Water Environment Federation® Technical Exhibition and Conference (WEFTEC® ) and specialty conferences held since the year 2000. These proceedings are not peer reviewed. WEF Members: Sign in (right panel) with your IngentaConnect user name and password to receive complimentary access.
- Subscribe to this Title
- Membership Information
- About WEF Proceedings
- WEFTEC Conference Information
- ingentaconnect is not responsible for the content or availability of external websites