Data mining to improve management and reduce costs of environmental remediation

• Published in: Journal of hydroinformatics 2007-04, Vol.9 (2), p.107-121
• Main Authors: Farrell, Dara M, Minsker, Barbara S, Tcheng, David, Searsmith, Duane, Bohn, Jane, Beckman, Dennis
• Format: Article
• Language: English
• Subjects: Cost control; Costs; Data; Data mining; Data processing; Decision trees; Dredging; Environmental cleanup; Environmental impact; Environmental monitoring; Excavation; Gasoline; Groundwater; Groundwater treatment; Predictions; Regression analysis; Remediation; Service stations; Soil; Soil remediation; Water monitoring
• ISSN: 1464-7141; 1465-1734
• DOI: 10.2166/hydro.2007.004

In this paper, data from 105 soil and groundwater remediation projects at BP gasoline service stations located in the state of Illinois were mined for lessons to reduce cost and improve management of remediation sites. Data mining software called D2K was used to train decision tree, stepwise linear regression and instance-based weighting models that relate hydrogeologic, sociopolitical, temporal and remedial factors in the site closure reports to remediation cost. The most important factors influencing cost were found to be the amount of soil excavated and the number of groundwater monitoring wells installed, suggesting that better management of excavation and well placement could result in significant cost savings. The best model for predicting cost classes (low, medium and high cost) was the decision tree, which had a prediction accuracy of approximately 73%. The misclassification of approximately 27% of the sites by even the best model suggests that remediation costs at service stations are influenced by other site-specific factors that may be difficult to accurately predict in advance.