- Created by Luigi Marini, last modified by Aaron Hoyle-Katz on Sep 13, 2019
This page tracks data sources relevant to the project.
Data Categories
Short Term
- USGS nitrate monitoring stations (superstations) in Mississippi River Watershed
- NPDES Discharge monitoring reporting loading tool (POTW point sources) (Industrial Point Sources)
- Pre-Sentinel Site Nitrate Trends - USGS Trends in Annual Water-Quality Loads to the Gulf of Mexico through 2018
Longer Term
- Municipal Water
- Drinking Water - Currently looking into intake monitoring that will be done by Illinois American Water (Ted, December '15)
- Fertilizer Data
- You would calculate the total amount by county divided by area, gives you a nitrogen load.
- You know how much fertilizer is sold in that county. We know the area of the county, and John Chick can get the percentage of the county that is cropland.
"Completed"
- NGRREC
- Greon Buoys
- USGS Water Quality (superstations)
- UMRR LTRM
- Water Quality Portal
- NOAA
Other
- NOAA National Data Buoy Center (Ted's note: I don't think this is something we need to include on GLTG; however, it may be useful for us to have our data included in their site)
MISC NOTES:
Site Metadata
Categorize Each site?:
- Active / Inactive
- Manual Collection / Continuous Stream (Circle? / Square?)
- Sources
Data Formats and Protocols
Support NOAA National Data Buoy Center protocol and requirements?
Nitrate Data
Nitrate and Nitrite As N mg/L
File | Modified | |
---|---|---|
Microsoft Excel Spreadsheet Great Lakes to Gulf major point sources 2011.xlsx | Jul 31, 2014 by Luigi Marini | |
Labels
|
||
Microsoft Excel Spreadsheet Great Lakes To gulf sites.xlsx | Jul 31, 2014 by Luigi Marini | |
Labels
|
||
Microsoft Excel Spreadsheet Wastewater treatment facilities 2011.xlsx | Jul 31, 2014 by Luigi Marini | |
Labels
|
||
ZIP Archive gltg-sample-data.zip | Jul 31, 2014 by Luigi Marini | |
Labels
|
||
Microsoft Excel Spreadsheet GLTG sites- NCSA.xlsx GLTG location data (cleaned by Jong Lee) | Aug 01, 2014 by Jong Lee | |
Labels
|
||
ZIP Archive gltg-sites-nad83.zip GLTG sites in ESRI shapefile (NAD83) | Aug 01, 2014 by Jong Lee | |
Labels
|
||
ZIP Archive gltg-sites-utm15.zip GLTG sites in ESRI shapefile (UTM 15) | Aug 01, 2014 by Jong Lee | |
Labels
|
||
PDF File TIDAS 900 User Manual V3.pdf | Aug 07, 2014 by Michael Brennan | |
Labels
|
||
Text File GREON-field-descriptions.txt these are the descriptions of GREON data headers after meeting with Michael and Marcus - | Oct 03, 2014 by Brock Angelo | |
Labels
|
||
Microsoft Excel Spreadsheet all data_Nutrients_v1.xlsx | Aug 26, 2015 by Michael Brennan | |
Labels
|
- No labels
3 Comments
Brock Angelo
Links to Live Data:
Alton Sensor Flow Data
UMESC Excel File of Nitrate Data - select all "Field Stations", then optionally select a "Location Code" or choose the Fields in the list you want, then click Submit at the bottom.
USGS Rest API for Instantaneous Data - you can select JSON as an output format. Michael and I tested with Site Code: 01646500 & HUC Code: 02070010
Michael Brennan
Two files were uploaded capturing Active Sensors (Great_Lake_To_Gulf_Active_Sites_UMESC.xlsx) and non active sites (Great_Lake_to_Gulf_Nonavtive_UMESC).
I do not see the need now or in the future to link the information in the second tab of each spreadsheet to the nitrate data, it is included for reference. The two spreadsheets distinguish sensors (monitoring locations) that are actively monitoring and that monitoring locations that are no longer being sampled. In the first tab of each spread sheet (orange tab) is the nitrogen data. The information in the orange shaded columns (Date, time, Location, Nitrate Concentration and Units) are intended for version 1 of GLTG. The additional data (ammonia concentration, Total nitrogen) is meant to accompany the nitrate data in the raw data download. When our audience is exploring nitrate data, they often want to know the concentrations of other species of nitrogen, such as ammonia, in addition to total nitrogen.
Michael Brennan
UMESC URL
http://www.umesc.usgs.gov/data_library/water_quality/water1_query.shtml