Skip to main content
Log in

Huron-to-Erie Water Quality Data Platform

  • Original Article
  • Published:
Environmental Processes Aims and scope Submit manuscript

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.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6
Fig. 7
Fig. 8
Fig. 9
Fig. 10
Fig. 11
Fig. 12
Fig. 13

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

    Article  Google Scholar 

  • 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

    Article  Google Scholar 

  • 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

    Google Scholar 

  • 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

    Article  Google Scholar 

  • 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

    Article  Google Scholar 

  • 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

    Article  Google Scholar 

  • 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

    Google Scholar 

  • 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

    Article  Google Scholar 

  • McLellan SL (2004) Genetic diversity of Escherichia coli isolated from urban rivers and beach water. Appl Environ Microbiol 70(8):4658–4665

    Article  Google Scholar 

  • 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

    Article  Google Scholar 

  • 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

    Article  Google Scholar 

  • 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

    Article  Google Scholar 

  • 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

    Article  Google Scholar 

  • 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

    Article  Google Scholar 

  • USEPA (2000) Improved enumeration methods for recreational water quality indicators: enterococci and Escherichia coli. US Environmental Protection Agency Office of Water, Washington DC

    Google Scholar 

Download references

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

Authors

Corresponding author

Correspondence to Lanyu Xu.

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:

$$ \mathrm{y}=2838.3\mathrm{x}+2.8356 $$

Using this formula, the BGA values for Monroe are successfully represented by RFU (Appendix Fig. 14).

Fig. 14
figure 14

The relationship between cell/ml and RFU of BGA

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

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

Download citation

  • Received:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s40710-018-0322-7

Keywords

Navigation