AWWA ACE59954

In a recently completed project, a comprehensive geographic information system (GIS) database, or geodatabase, was developed for the Cleveland Water Division (CWD) to manage data related to its water distribution system and related facilities. The primary function of this geodatabase is to store data for use in hydraulic and water quality models of the system. In addition, the geodatabase stores information related to the operations and maintenance of the distribution system. This GIS serves many diverse functions within CWD including plan review, maintenance records, work order management and advanced planning and engineering. Execution of the project involved developing a number of applications for inputting and managing field data within the geodatabase. Specific examples include linking data from CWD's supervisory control and data acquisition (SCADA) system with either the GIS or hydraulic models, developing custom forms for input of customer complaints into the GIS, and integrating chlorine residual field data collected for calibration of the water quality model with data collected by CWD for compliance with the state and federal reporting requirements. Includes figures.