Harmonized discrete and continuous water quality data in support of modeling harmful algal blooms in the Illinois River Basin, 2005 - 2020

Description

Harmful algal blooms (HABs) are overgrowths of algae or cyanobacteria in water and can be harmful to humans and animals directly via toxin exposure or indirectly via changes in water quality and related impacts to ecosystems services, drinking water characteristics, and recreation. While HABs occur frequently throughout the United States, the driving conditions behind them are not well understood, especially in flowing waters. In order to facilitate future model development and characterization of HABs in the Illinois River Basin, this data release publishes a synthesized and cleaned collection of HABs-related water quality and quantity data for river and stream sites in the basin. It includes nutrients, major ions, sediment, physical properties, streamflow, chlorophyll and other types of water data. This data release contains files of harmonized data from the USGS National Water Information System (NWIS), the U.S. Army Corps of Engineers (USACE), the Illinois Environmental Protection Agency (IEPA), and a USGS Open File Report (OFR) containing toxin data in Illinois (Terrio and others, 2013: https://pubs.usgs.gov/of/2013/1019/pdf/ofr2013-1019.pdf). Both discrete data and continuous sensor data for 142 parameters (44 of which returned data) between October 1, 2015 and December 31, 2022 were downloaded from NWIS programmatically. All data were harmonized into a shared format (see files named data_{parameter_group}_combined.csv). The USGS NWIS data went through additional cleaning and were also grouped by generic parameters (see pcode_group_xwalk.csv to see what parameter codes are mapped to which generic parameters). Any data not from USGS NWIS were kept outside of the parameter grouping files. Additional streamflow data for select locations was retrieved from the USACE and are available in data_usace_00060_combined.csv. Additional algal toxin data provided by the IEPA and in a USGS OFR report (Terrio and others, 2013), which include some lake sites, are available in data_algaltoxins_combined.csv. We also provide collapsed datasets of daily metrics for each water quality (“generic parameter”) group of USGS NWIS data (files named daily_metrics_{parameter_group}.csv). Lastly, we include a site_metadata.csv containing site identification and location information for all sites with water quality and quantity data, and mappings to the National Hydrography Dataset flowlines where available. This work was completed as part of the USGS Proxies Project, an effort supported by the Water Mission Area (WMA) Water Quality Processes program to develop estimation methods for PFAS, harmful algal blooms, and metals, at multiple spatial and temporal scales.

Resources

Name Format Description Link
55 Landing page for access to the data https://doi.org/10.5066/P9RISQGE
55 The metadata original format https://data.usgs.gov/datacatalog/metadata/USGS.62abf202d34e74f0d80eb611.xml

Tags

  • environment
  • indiana
  • water-quality
  • illinois-river-basin
  • data-integration
  • inlandwaters
  • algal-blooms
  • water-resources
  • wisconsin
  • health
  • illinois
  • usgs-62abf202d34e74f0d80eb611

Topics

Categories