Abstract
To address the challenges of environmental degradation, creation of a sustainable urban environment, and increased public engagement and awareness, a mass-oriented, user-friendly and cloud-based data platform has been developed and deployed to provide integrative water quality data in one of the most critical urban corridors of the Laurentian Great Lakes system. In this paper, we describe the data platform developed for the watershed and connecting channels between Lake Huron and Lake Erie, including the St. Clair River, Lake St. Chair, and the Detroit River. This data platform greatly facilitates the access of data across data providers and agencies. Several example applications are provided of platform use for temporal and spatial characterization of intake water source quality and urban beach health through consideration of Escherichia coli, Dissolved Oxygen, pH, and blue-green algae detections along the Huron-to-Erie corridor. Although data collection for each of these parameters was designed for unique purposes and supported through varied agencies, this paper shows the collective advantages of applying the data beyond the original scope of collection.
Similar content being viewed by others
References
Benesty J et al (2009) Pearson correlation coefficient. Noise reduction in speech processing. Springer, p 1–4
Boto KG, Bunt JS (1981) Dissolved oxygen and pH relationships in northern Australian mangrove waterways. Limnol Oceanogr 26(6):1176–1178
Cai W-J, Hu X, Huang WJ, Murrell MC, Lehrter JC, Lohrenz SE, Chou WC, Zhai W, Hollibaugh JT, Wang Y, Zhao P, Guo X, Gundersen K, Dai M, Gong GC (2011) Acidification of subsurface coastal waters enhanced by eutrophication. Nat Geosci 4(11):766–770
Doney SC et al (2009) Ocean acidification: the other CO2 problem
Dorfman MH et al (2007) Testing the waters: a guide to water quality at vacation beaches. Natural resources defense council, New York
Fraternali P, Castelletti A, Soncini-Sessa R, Vaca Ruiz C, Rizzoli AE (2012) Putting humans in the loop: social computing for water resources management. Environ Model Softw 37:68–77
Frieder CA, Nam SH, Martz TR, Levin LA (2012) High temporal and spatial variability of dissolved oxygen and pH in a nearshore California kelp forest. Biogeosciences 9(10):3917–3930
Gouveia C, Fonseca A (2008) New approaches to environmental monitoring: the use of ICT to explore volunteered geographic information. GeoJournal 72(3–4):185–197
Hernández-Mora N, Cabello V, De Stefano L, del Moral L (2015) Networked water citizen organizations in Spain: potential for transformation of existing power structures in water management. Water Alternatives 8(2):99–124
Hofmann AF, Peltzer ET, Walz PM, Brewer PG (2011) Hypoxia by degrees: establishing definitions for a changing ocean. Deep-Sea Res I Oceanogr Res Pap 58(12):1212–1226
McLellan SL (2004) Genetic diversity of Escherichia coli isolated from urban rivers and beach water. Appl Environ Microbiol 70(8):4658–4665
Mongi H, Meinhardt M (2016) Integrated ICTs for water basins management in Southern Africa: systematic review and meta-analyses for perceived relevance criteria. AGRIS on-line Papers in Economics and Informatics 8(2):103–110
Oliver DM, Porter KDH, Louise Heathwaite A, Zhang T, Quilliam RS (2015) Impact of low intensity summer rainfall on E. coli-discharge event dynamics with reference to sample acquisition and storage. Environ Monit Assess 187(7):426
Pahl-Wostl C, Craps M, Dewulf A, Mostert E, Tabara D, Taillieu T (2007) Social learning and water resources management. Ecol Soc 12(2):5
Pratt B, Chang H (2012) Effects of land cover, topography, and built structure on seasonal water quality at multiple spatial scales. J Hazard Mater 209:48–58
Smith DR, King KW, Johnson L, Francesconi W, Richards P, Baker D, Sharpley AN (2015) Surface runoff and tile drainage transport of phosphorus in the midwestern United States. J Environ Qual 44(2):495–502
USEPA (2000) Improved enumeration methods for recreational water quality indicators: enterococci and Escherichia coli. US Environmental Protection Agency Office of Water, Washington DC
Acknowledgements
This work was supported by the Erb Family Foundation and Wayne State University. We acknowledge the contributions of Kelly Karl, Bill Parkus, and Amy Mangus of SEMCOG. In addition, we appreciate the input of Fondriest Environmental and the water utilities along the Huron to Erie corridor.
Author information
Authors and Affiliations
Corresponding author
Appendix
Appendix
Given the difference of both data source platform and the sonde model, BGA data associated with two units, cell/ml and RFU. Marysville, fortunately, provides both units at the same time. To make the comparison consistency, the quantitative relationship between the two units is set up according to the BGA information provided by Marysville. Let x represent the BGA value in RFU units, and y represent the BGA value in cell/ml units:
Using this formula, the BGA values for Monroe are successfully represented by RFU (Appendix Fig. 14).
Rights and permissions
About this article
Cite this article
Xu, L., Miller, C.J., Olson, J. et al. Huron-to-Erie Water Quality Data Platform. Environ. Process. 5, 465–481 (2018). https://doi.org/10.1007/s40710-018-0322-7
Received:
Accepted:
Published:
Issue Date:
DOI: https://doi.org/10.1007/s40710-018-0322-7