Projects - This article is part of a series.
An old project from my days at the USGS. One of the many roles that the USGS does is provide real-time water constituent data for scientists and businesses. In order to do this, the river gage stations must be operational and uploading data. Part of the office’s job was to physically go to river gage stations that were reporting bad data, and fix the equipment and or get data that was no longer being updated via satellite (flooding, ice, etc can cause this). This was usually done by looking at tables of groundwater data and looking for missing and / or bad data. Our office was approached by the individuals who make these updates with the request if they could have a simple graphic on the website to see at a glance what sites were operational. This graphic was then enhanced further to show what groundwater sites were expected to be reporting bad data as they operated on a seasonal basis where winter data was discarded. This turned out to be popular as it saved time browsing through (admittedly somewhat dated) NWIS data tables. Users also enjoyed being able to quickly pull up a specific site by clicking on the colored dot on the plot.
Eventually the success of this groundwater plot was duplicated into a new plot but this time tracking real time Nitrate data. Given Iowa’s location as an agricultural state monitoring the impact of fertilizer runoff was of great interest and a number of the Scientists worked on the subject. I enjoyed that my little code contribution could help in this work.