The City of Cleveland, Ohio, Division of Water (CWD) provides potable water
service to over one million customers in the greater Cleveland area. CWD owns and
operates four water treatment plants (WTPs) with a combined capacity of about 500
million gallons per day. Faced with changing regulations and the need to upgrade
the plants, CWD embarked on a major $400 million upgrading and modernization
program of the WTPs. One of the first tasks was to thoroughly inspect the WTPs
which led to the generation of an enormous amount of data. To handle over 13,000
records containing more than 300,000 fields, it was necessary to create a
facility audit database to organize the data collection, entry, storage and
retrieval processes. This paper describes the development of a relational
database to create a simple, user-friendly and intuitive data management system.
The paper also discusses the multiple uses of the database during the facilities
planning and implementation phases of the project and beyond. Includes table, figures.
| Edition : | Vol. - No. |
| Number of Pages : | 7 |
| Published : | 01/01/1999 |
