Premium
Constructing water main break databases for asset management
Author(s) -
Wood Andrew,
Lence Barbara J.,
Liu W.
Publication year - 2007
Publication title -
journal ‐ american water works association
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.466
H-Index - 74
eISSN - 1551-8833
pISSN - 0003-150X
DOI - 10.1002/j.1551-8833.2007.tb07846.x
Subject(s) - asset (computer security) , asset management , computer science , data warehouse , data management , database , data collection , data science , risk analysis (engineering) , business , finance , computer security , statistics , mathematics
Water main break data are essential for undertaking informed infrastructure asset management. An approach for constructing break and general network data from multiple sources and relating and linking such data is presented here. The approach incorporates data from a number of sources and augments the amount of data available while maintaining existing data warehousing practices. Although it requires effort and collaboration among a utility's information technology and engineering staff, the approach is flexible; uses commonly available software tools; anticipates the evolution of data collection, verification, and storage capabilities within the utility; and, can be applied to other infrastructure assets. With the results, utility managers can gain insight into current and future performance of their distribution networks and develop future asset management strategies. As an example, the approach is applied to a portion of the water distribution network of the District of Maple Ridge, B.C., Canada.