Predicting lead water service lateral locations: Geospatial data science in support of municipal programming

Seyedsaeed Hajiseyedjavadi, Hassan A. Karimi and Michael Blackhurst

Socio-Economic Planning Sciences, 2022, vol. 82, issue PB

Abstract: We present and discuss machine learning predictions of customers' service line materials in Pittsburgh, PA and demonstrate the degree to which these predictions and the supporting data can and cannot improve municipal lead programming. Like previous work, predictive features reflect a combination of property characteristics, administrative spatial data, and tap water quality samples. Our work also includes labels of service line materials diagnosed by photographs taken at the curb box, which prove to boost predictions but are imperfect exclusive diagnostic methods. We use sample weighting and spatial cross validation in an effort to overcome the oversampling of lead service line characteristics of data collected for regulatory compliance. Cross-validation demonstrates precise predictions (precision >90%) for only 13% of customers, suggesting that predictions could improve short-term replacement decisions in avoiding unnecessary excavations. However, model precision declines when expanding predictions to more customers, limiting the degree to which predictions can estimate system-wide inventories and inform the regulatory decisions requiring complete inventories. We discuss the necessary trade-offs between biased sampling for regulatory compliance, which favors finding and replacing lead, and predictive modeling, which improves with unbiased sampling. We present a flow diagram that can help municipalities balance biased and unbiased sampling when integrating predictive modeling into compliance with federal regulations.

Keywords: Lead contamination; Drinking water; Machine learning (search for similar items in EconPapers)
Date: 2022
References: View references in EconPapers View complete reference list from CitEc
Citations:

Downloads: (external link)
http://www.sciencedirect.com/science/article/pii/S0038012122000556
Full text for ScienceDirect subscribers only

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:eee:soceps:v:82:y:2022:i:pb:s0038012122000556

DOI: 10.1016/j.seps.2022.101277

Access Statistics for this article

Socio-Economic Planning Sciences is currently edited by Barnett R. Parker

More articles in Socio-Economic Planning Sciences from Elsevier
Bibliographic data for series maintained by Catherine Liu ().