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

Citation

Platt, L.R.C., Chen, Y.R., Murphy, J., Nystrom, E., Schmadel, N., Stackpoole, S., Stouder, M., and Zwart, J., 2022, Harmonized discrete and continuous water quality data in support of modeling harmful algal blooms in the Illinois River Basin, 2005 - 2020: U.S. Geological Survey data release, https://doi.org/10.5066/P9RISQGE.

Summary

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.

Contacts

Attached Files

Click on title to download individual files attached to this item.

HABs_metadata.xml Original FGDC Metadata	View	46.36 KB	application/fgdc+xml
pcode_group_xwalk.csv		1.84 KB	text/csv
site_metadata.csv		26.05 KB	text/csv
daily_metrics_uv_254.csv		19.98 KB	text/csv
daily_metrics_turb.csv		3.86 MB	text/csv
daily_metrics_temp_water.csv		8.42 MB	text/csv
daily_metrics_temp_air.csv		209.62 KB	text/csv
daily_metrics_sediment.csv		780.49 KB	text/csv
daily_metrics_SC.csv		4.56 MB	text/csv
daily_metrics_q.csv		180.76 KB	text/csv
daily_metrics_phyto_biomass.csv		288 Bytes	text/csv
daily_metrics_pheo.csv		16.28 KB	text/csv
daily_metrics_pH.csv		2.77 MB	text/csv
daily_metrics_OP.csv		665.11 KB	text/csv
daily_metrics_NO3_NO2.csv		3.06 MB	text/csv
daily_metrics_NO3.csv		84.74 KB	text/csv
daily_metrics_mats.csv		45.17 KB	text/csv
daily_metrics_fPC.csv		588.08 KB	text/csv
daily_metrics_fDOM.csv		220.63 KB	text/csv
daily_metrics_fchl.csv		1.1 MB	text/csv
daily_metrics_DO.csv		3.1 MB	text/csv
daily_metrics_chl_a.csv		31.64 KB	text/csv
data_usace_00060_combined.csv		643.25 KB	text/csv
data_algaltoxins_combined.csv		489.6 KB	text/csv
data_vel_combined.zip		69.61 MB	application/zip
data_uv_254_combined.csv		18.56 KB	text/csv
data_turb_combined.csv		327.52 MB	text/csv
data_temp_water_combined.csv		779.36 MB	text/csv
data_temp_air_combined.csv		219.22 KB	text/csv
data_sediment_combined.csv		1.05 MB	text/csv
data_SC_combined.csv		533.52 MB	text/csv
data_Q_continuous_combined.zip		196.06 MB	application/zip
data_Q_combined.csv		288.27 KB	text/csv
data_phyto_biomass_combined.csv		239 Bytes	text/csv
data_pheo_combined.csv		17.91 KB	text/csv
data_pH_combined.csv		188.16 MB	text/csv
data_OP_combined.csv		11.72 MB	text/csv
data_NO3_NO2_combined.csv		252.59 MB	text/csv
data_NO3_combined.csv		93.28 KB	text/csv
data_mats_combined.csv		49.12 KB	text/csv
data_gage_height_combined.zip		169.83 MB	application/zip
data_fPC_combined.csv		33.26 MB	text/csv
data_fDOM_combined.csv		15.82 MB	text/csv
data_fchl_combined.csv		75.01 MB	text/csv
data_DO_combined.csv		204.37 MB	text/csv
data_chl_a_combined.csv		32.83 KB	text/csv

Purpose

Provide a robust dataset of USGS National Water Information System (NWIS), US Army Corps of Engineers, Illinois Environmental Protection Agency, and other USGS Illinois data related to harmful algal blooms (HABs) that have been cleaned and formatted for use in future HABs modeling efforts with ease.

Identifiers

Type	Scheme	Key
DOI	https://www.sciencebase.gov/vocab/category/item/identifier	doi:10.5066/P9RISQGE

Item Actions

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

Dates

Citation

Summary

Summary

Contacts

Attached Files

sorting

Metadata First

Recent First

Alphabetical

Purpose

Map

Communities

Tags

Provenance

Additional Information

Identifiers

Item Actions

View Item as ...

Save Item as ...

View Item...

Dates

Citation

Summary

Summary

Contacts

Attached Files sorting Metadata First Recent First Alphabetical

Purpose

Map

Communities

Tags

Provenance

Additional Information

Identifiers

Item Actions

View Item as ...

Save Item as ...

View Item...

Attached Files

sorting

Metadata First

Recent First

Alphabetical