You are here:
Data Management for Effective Condition Assessment of Collection Systems
Citation:
Martel, K., DENNIS LAI, K. Enfinger, AND R. Rowe. Data Management for Effective Condition Assessment of Collection Systems. Presented at NASTT 2010 No-Dig Show, Chicago, IL, May 02 - 07, 2010.
Impact/Purpose:
To inform the public.
Description:
Condition assessment provides critical information for assessment of an asset’s physical condition, remaining useful service life, and long-term performance. This paper will describe data management issues integral to a successful condition assessment program. Key points will be illustrated using examples from seven utility case studies in the USEPA-funded research project, Condition Assessment of Collection Systems. One of the initial steps is to collect historical system data such as pipe diameter, length, and installation dates; system map; flow data; and inspection and maintenance records for the collection system. Data are stored in an asset management database. It is important to evaluate the content and form of the data, and identify data gaps and data quality issues. Various data sources can be integrated to help evaluate asset condition and determine needs for further inspection and/or maintenance. Data analysis involves the coding of asset defects observed during inspection, the conversion of defect codes to an asset condition rating, and prioritization of assets based on condition scores and/or risk-based scores. The paper will discuss the design and format of defect codes and available defect code systems. The selection of a data management system such as spreadsheets, condition assessment software, and other database software will be discussed. Decision making, the final step in the condition assessment process, to a large degree, relies on CCTV data and other available asset condition information to prioritize assets for various corrective actions including maintenance, further inspection, and total replacement. Some utilities have used a risk-based approach to supplement condition information.
URLs/Downloads:
Conference Information
Brochure
For further information (PDF, NA pp, 5 KB, about PDF)