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

Buy & download fulltext article:

OR

Price: $17.50 plus tax (Refund Policy)

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

More about this publication?
  • 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

Tools

Key

Free Content
Free content
New Content
New content
Open Access Content
Open access content
Subscribed Content
Subscribed content
Free Trial Content
Free trial content

Text size:

A | A | A | A
Share this item with others: These icons link to social bookmarking sites where readers can share and discover new web pages. print icon Print this page