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