Water Quality Portal Data sets to be ingested into Great Lakes to Gulf
Water quality monitoring data collected in the Mississippi River was downloaded from the Water Quality Portal in June 2014. Data from the Water Quality portal were divided into two separate spreadsheets and uploaded to confluence - Active sites and Non active Monitoring sites.
Critical fields in the spreadsheet have an orange background(Fields to be ingested into Great Lakes to Gulf). Minimum metadata that needs to accompany a sensor is below (i.e. when you mouse over a sensor this information needs to be displayed)
Organization Name
Monitoring Location Name
Monitoring Location ID
Analytes available (Nitrate plus Nitrite as N)
*Nice to haves (period of record for the sample i.e. 1990 - 2008)
Analyte Data (Sample data))
The nomenclature for analytes from our sources is not consistent. We hope to maintain the original nomenclature provided by the source in the metadata, Column BB in Water Quality Portal Non active. We would like to keep all of our nitrate data consistent - column BF Nitrate and Nitrite as N. The units will always be mg/L - column BH.
*Note column BG contains the actual measurement value. In some rows this column is performing a calculation, converting the measure from ug/L to mg/L
Attached is a description of all of the fields in the provided Water Quality Portal spreadsheets
Water Quality Portal Codes.xlsx
Provided below is a breakdown of the number of Monitoring Sites each agency has in the Water Quality Portal
Number of Monitoring Sites by agency Water Quality Portal.xlsx
USGS Live monitoring sites to be ingested into the Great Lakes to Gulf Virtual Observatory
Marcus Slavenas, the following file is the current list of the stations in the Mississippi river watershed (including missouri, ohio, others) that have current, continuous nitrate data, as of December 14, 2015. I would like to get these ingested and on the site.
https://uofi.box.com/s/ru7zu7rzt2m094u6o3zxab8rjf7z40ul
Ted's note: keeping the below for reference
Some of the initial USGS live monitoring sites originally listed have yet to start publishing nitrate data. Those that are are provided in the file below. Two of the sites, Mississippi River at Cape Girardeau, and Illinois, River at Florence, are not collecting discharge data. Discharge data from a nearby gauge is provided instead. Data for the nearby guage is provided in the orange shaded cells while data for the nitrate data is in the purple shaded cells.
Finally, I still have some unresolved questions regarding the Ohio River at Olmsted discharge data, please hold off on ingesting the Ohio River at Olmsted data for the time being.
GLTG USGS sites w data- NCSA.xlsx