Integration of Field Inspection Data and Automated Analysis Streamlines Sewer System O&M and Rehabilitation Work for SD1

Since 2007, the Northern Kentucky Sanitation District No. 1 (District, also referred to as SD1) has actively developed their Continuous Sewer Assessment Program (CSAP). The District's CSAP implementation objective was to expedite data handling and subsequent decisions starting from condition assessment to issuing work orders for specific maintenance, repair, rehabilitation, or replacement actions. The District documented their process logic for prioritizing and managing the data and rendering decisions. They decided to integrate the data and automate decisions using their GBA Master Series (gbaMS) computerized maintenance management system and geographic information system (GIS) combined with CH2M HILL's SCREAM™ inspection analysis tools and structured query language (SQL) database programming logic. The system logic was programmed to evaluate the field findings and to “wake-up” and generate work orders. This allowed advanced work scheduling. The iterative process has expedited and improved the quality of the data and the District's ability to accomplish considerably more work with essentially the same staff levels.