USGS

USGS provides two endpoints, one for real-time data every 15 minutes, and one that provides daily averages of those measurements. However, the daily average endpoint does not provide averages for Nitrates, and does not go back as far as the endpoint for 15 minute data.

15 Minute Data:

http://waterservices.usgs.gov/nwis/iv/?format=rdb&sites=03374100&startDT=2014-10-21&endDT=2014-10-31

Daily Averages:

http://waterservices.usgs.gov/nwis/dv/?format=rdb&sites=03374100&startDT=2014-10-21&endDT=2014-10-31

The NCSA team has been in touch with Michael Brennan about how to handle this, and we have agreed that the end result is that we want to be able to "bin" all of these values into daily averages on the interface. With that in mind, we are proceeding as follows:

Discharge

• Endpoint: Daily Average
• Data modifications: none
• Qualification Code: we will use the QC code provided by USGS and store this internally as an additional parameter: "discharge-qc". Development to the geodashboard code will need to be done before any of these are visible on the site.

Nitrate

• Endpoint: 15 Minute Data
• Modifications: we will average the values for each day before ingesting into our API.
• Qualification code: Development and discussion will need to be done within NCSA regarding how we will store these QC codes. For days where all nitrate values have the same QC code, this is not an issue, but the likelihood of multiple QC codes in a day is an issue we are planning to address.

Nitrate Load

• Endpoint: NA - this is a calculated value based on data from Nitrate and Discharge data.
• Modifications: we will only create a Nitrate Load value when both Discharge and Nitrate values are available.
• Qualification code: NCSA will be working on language to explain how this is calculated. It will indicate that it is estimated data, generated by NCSA, based on any calculations performed for Nitrate, and using the USGS-provided averages for Discharge.

Marcus Slavenas is working on a cron job that will update this in the API.