Automated Acquisition of Historical Water Distribution Pipe Repair Location Data

Abstract

We report an innovative method of extracting water distribution network (WDN) historical repair location data from images of paper repair data maps, to provide usable geo-referenced digitally formatted data. For most water utilities, repair location data typically fall into two eras: pre- and post-GIS, approximately corresponding to pre- and post-2000. Automated conversion of pre-2000 paper maps to a geo-referenced digital format provides additional data to clarify trends in pipe repair causative factors, such as material defects, corrosive or creeping soils, and traffic. We applied the methodology to more than 3,000 maps of the Los Angeles Department of Water and Power WDN, thereby extending the record of repairs backward from 2000 to 1975, almost doubling the number of repair records. The methodology's value, when using the resulting data for analysis, lies in the following: (a) large volumes of hard copy data can now be acquired in an automated manner, saving significant time and effort, (b) specific repair locations are accurately captured, resulting in (c) more reliable, confident, analyses, and results, (d) ongoing problem areas, due to corrosive or creeping soils for example, can be more specifically understood.