Tracking the Cost of Maintaining Stormwater Best-Management Practice Facilities: The Role of Database Design and Data Entry Best Practices
Publication: Journal of Sustainable Water in the Built Environment
Volume 10, Issue 1
Abstract
Best-management practices (BMPs) are widely used to mitigate non-point source pollution from stormwater discharges. However, long-term operation and maintenance of stormwater BMPs have been an afterthought before the compliance requirement detailed in the Municipal Separate Storm Sewer Systems (MS4) permit. As a result, there is limited information available on the actual cost of maintaining BMPs. The objective of this research is to analyze the stormwater maintenance tracking database created by the Virginia Department of Transportation (VDOT) to (1) complete a preliminary cost analysis of routine and non-routine maintenance with respect to VDOT district or practice type and to (2) identify challenges encountered when processing the data for analysis and provide potential solutions relevant to other entities tracking BMP maintenance costs. The cost analyses presented in this study are preliminary based on the currently available data; however, they show insightful trends among the data collected by VDOT from 2018 to 2020. Namely, preventative maintenance actions appeared to greatly lower the need for non-routine or major repairs within the Virginia districts. Routine and non-routine maintenance costs were, on average, $375 per task and $812 per task, respectively. The cost of major repairs was approximately $63,000 per case. The most expensive routine maintenance tasks were basin BMPs (constructed wetlands, wet ponds, and extended detention ponds), averaging $400 per task. The most expensive non-routine maintenance tasks were infiltration BMPs (permeable pavement, infiltration practices, and bioretention), averaging $1,123 per task. Basin BMPs had the largest annual upkeep at $1,100 per year. Approaches for extending the current database design used by VDOT are discussed to address challenges identified through the analysis including data incompleteness, overloaded work orders, and the lack of controlled vocabulary. These lessons learned regarding database design can be useful to other agencies seeking to track and analyze stormwater maintenance activities and associated costs.
Practical Applications
The tracking of stormwater best-management practice (BMP) operation and maintenance (O&M) practices can help reduce the costs associated with stormwater permit compliance. A key factor in the O&M tracking process is the database design, which governs the collection, storage, accessibility, and analysis of the O&M data. However, the database design for BMP O&M tracking is not well documented. An analysis of the Virginia Department of Transportation’s (VDOT’s) O&M collection process and database design indicates that a many-to-many relationship exists between work orders and BMP assets, hindering the cost analysis of the maintenance work. Other challenges observed were a lack of controlled vocabulary when reporting the maintenance activities, assigning maintenance tasks associated with multiple BMPs to a single BMP, and the presence of incomplete work orders. Access to detailed BMP maintenance information can be used to calculate the approximate costs of routine and non-routine maintenance with respect to district or practice type, to determine estimates for BMP inspection frequencies, and to assess the level of effort needed to maintain certain BMPs. A design extension of the VDOT stormwater O&M tracking database is proposed that can inform the design for other states’ and communities’ stormwater BMP O&M tracking databases.
Get full access to this article
View all available purchase options and get full access to this article.
Data Availability Statement
Some or all data, models, or code that support the findings of this study are available from the corresponding author upon reasonable request. The following data, models, or code are available:
•
VDOT stormwater work order data created from October 2018 to September 2020.
•
VDOT stormwater BMP inventory data as of December 2020.
•
String-searching algorithm Python script.
Acknowledgments
This study was supported by funding from the Virginia Department of Transportation (VDOT). The authors would like to extend their gratitude to VDOT for providing the data for this study and Scott Crafton, John Olenik, Alex Foraste, and Hyung Jun Ahn of VDOT for their valuable insights, guidance, and feedback.
References
Barbosa, A. E., J. N. Fernandes, and L. M. David. 2012. “Key issues for sustainable urban stormwater management.” Water Res. 46 (20): 6787–6798. https://doi.org/10.1016/j.watres.2012.05.029.
Blecken, G. T., W. F. Hunt III, A. M. Al-Rubaei, M. Viklander, and W. G. Lord. 2017. “Stormwater control measure (SCM) maintenance considerations to ensure designed functionality.” Urban Water J. 14 (3): 278–290. https://doi.org/10.1080/1573062X.2015.1111913.
Clary, J., A. Earles, M. Leisenring, and D. Pankani. 2018. Recommended operation and maintenance activity and cost reporting parameters for stormwater best management practices database. Alexandria, VA: Water Research Foundation.
Clary, J., M. Quigley, A. Poresky, A. Earles, E. Strecker, M. Leisenring, and J. Jones. 2011. “Integration of low-impact development into the international stormwater bmp database.” J. Irrig. Drain. Eng. 137 (3): 190–198. https://doi.org/10.1061/(ASCE)IR.1943-4774.0000182.
Conger, S. 2011. Hands-on database: An introduction to database design and development. Hoboken, NJ: Prentice Hall.
DelGrosso, Z., C. Hodges, and R. L. Dymond. 2019. “Identifying key factors for implementation and maintenance of green stormwater infrastructure.” J. Sustainable Water Built Environ. 5 (3): 05019002. https://doi.org/10.1061/JSWBAY.0000878.
Erickson, A. J., J. S. Gulliver, J. Kang, P. T. Weiss, and C. B. Wilson. 2010. “Maintenance for stormwater treatment practices.” J. Contemp. Water Res. Educ. 146 (1): 75–82. https://doi.org/10.1111/j.1936-704X.2010.00393.x.
Flynn, K. M., B. W. Linkous, and M. T. Buechter. 2012. “Operation and maintenance assessment for structural stormwater BMPs.” In Proc., 2012 World Environmental and Water Resources Congress, 3662–3673. Reston, VA: ASCE.
Hoss, F., J. Fischbach, and E. Molina-Perez. 2016. “Effectiveness of best management practices for stormwater treatment as a function of runoff volume.” J. Water Resour. Plann. Manage. 142 (11): 05016009. https://doi.org/10.1061/(ASCE)WR.1943-5452.0000684.
Houle, J. J., R. M. Roseen, T. P. Ballestero, T. A. Puls, and J. Sherrard. 2013. “Comparison of maintenance cost, labor demands, and system performance for LID and conventional stormwater management.” J. Environ. Eng. 7 (11): 932–938. https://doi.org/10.1061/(ASCE)EE.1943-7870.0000698.
Krieger, J., and E. Grubert. 2021. “Life-cycle costing for distributed stormwater control measures on the gray-green continuum: A planning-level tool.” J. Sustainable Water Built Environ. 7 (1): 04020019. https://doi.org/10.1061/JSWBAY.0000933.
Li, H. 2015. “Green infrastructure for highway stormwater management: Field investigation for future design, maintenance, and management needs.” J. Infrastruct. Syst. 21 (4): 05015001. https://doi.org/10.1061/(ASCE)IS.1943-555X.0000248.
Nobles, A. L., J. L. Goodall, and G. M. Fitch. 2017. “Comparing costs of onsite best management practices to nutrient credits for stormwater management: A case study in Virginia.” J. Am. Water Resour. Assoc. 53 (1): 131–143. https://doi.org/10.1111/1752-1688.12487.
Qiao, X. J., A. Kristoffersson, and T. B. Randrup. 2018. “Challenges to implementing urban sustainable stormwater management from a governance perspective: A literature review.” J. Cleaner Prod. 196 (Sep): 943–952. https://doi.org/10.1016/j.jclepro.2018.06.049.
Roy, A. H., S. J. Wenger, T. D. Fletcher, C. J. Walsh, A. R. Ladson, W. D. Shuster, H. W. Thurston, and R. R. Brown. 2008. “Impediments and solutions to sustainable, watershed-scale urban stormwater management: Lessons from Australia and the United States.” Environ. Manage. 42 (2): 344–359. https://doi.org/10.1007/s00267-008-9119-1.
Smith, V. B., M. W. McGauley, M. Newman, A. Garzio-Hadzick, A. Kurzweil, B. M. Wadzuk, and R. Traver. 2023. “A relational data model for advancing stormwater infrastructure management.” J. Sustainable Water Built Environ. 9 (1): 04022023. https://doi.org/10.1061/JSWBAY.SWENG-478.
USEPA. 2009. National water quality inventory: Report to congress. Washington, DC: USEPA.
VDOT (Virginia DOT). 2021. BMP inspection and maintenance manual. Richmond, VA: VDOT, CO-Maintenance Division.
Information & Authors
Information
Published In
Copyright
© 2023 American Society of Civil Engineers.
History
Received: Nov 15, 2022
Accepted: Aug 21, 2023
Published online: Sep 20, 2023
Published in print: Feb 1, 2024
Discussion open until: Feb 20, 2024
ASCE Technical Topics:
- Architectural engineering
- Benefit cost ratios
- Best Management Practices (BMPs)
- Building management
- Business management
- Computing in civil engineering
- Data analysis
- Databases
- Detection methods
- Detention basins
- Engineering fundamentals
- Environmental engineering
- Financial management
- Information Technology (IT)
- Maintenance and operation
- Methodology (by type)
- Practice and Profession
- Research methods (by type)
- Stormwater management
- Tracking
- Water treatment
Authors
Metrics & Citations
Metrics
Citations
Download citation
If you have the appropriate software installed, you can download article citation data to the citation manager of your choice. Simply select your manager software from the list below and click Download.