Automation of TV Inspection Sewer Data

Figure 1 - CCTV document management system diagram
Centralized Inspection Report Order Management
The next step in the developing the system was to streamline the report administration and management process by eliminating the potential for duplicate ordering, determine order status, and process invoices by different groups within the department. By centralizing and streamlining the above functions, Halton was able to:
- Reduce administration time;
- Eliminate duplicate requests;
- Data quality checks for CCTV contract adherence; and
- Ensure all new data is imported into the system; and,
- Monitor CCTV order status.
Data Collection Standardization
Due to the non-standardized methods used for the inspection of pipe conditions by previous contractors, past inspection reports varied in content. This resulted in interpretation problems and the subsequent ranking of the inspection details was not consistent. An investigation into a standard method of interpreting and collecting CCTV pipe condition was undertaken.
In 1999, Halton started to acquire sewer inspection data conforming to the Manual of Sewer Condition Classification from the United Kingdom Water Industry Engineering and Operations Committee. The UK WRc (Water Resource Centre) standardized methods provide an internationally accepted inspection-coding system. This allowed Halton to collect survey data that is consistent in data collection methodologies and urvey interpretation.