Water Quality at Sawyer Mill Reservoir on Bellamy River, Dover, NH
|Authors:||Wilfred Wollheim Eliza Balch Gopala Mulukutla|
|Owners:||Eliza Balch Wilfred Wollheim Gopala Mulukutla|
|Resource type:||Composite Resource|
|Storage:||The size of this resource is 9.8 MB|
|Created:||Feb 26, 2019 at 4:40 p.m.|
|Last updated:||Mar 18, 2019 at 12:26 p.m. by Gopala Mulukutla|
|Citation:||See how to cite this resource|
|Content types:||Time Series Content|
NOTE: This data was posted to meet the requirements of the EPA Low Cost Nutrient Sensor Challenge (Phase 2). The data set includes the results of a preliminary test of one type of low cost nutrient sensor and should not be used without consultation with the authors.
Dams and their reservoirs are increasingly being removed from the landscape, often because they are aging and would need costly repairs, have no significant utility and/or to improve anadromous fish passage and connectivity with spawning areas. Understanding the role of reservoirs in nitrate removal will inform ongoing decisions regarding dam removal.Because reservoirs created by dams are potentially effective at removing nitrogen (Gold et al. 2016), such dam removals come with tradeoffs, including reduced nitrate removal. Yet we have a poor understanding of the effectiveness of the reservoirs on smaller rivers that are common in much of New England and elsewhere, as well as how their effectiveness varies during different parts of the growing season and during storm events within season.
Our overarching approach used high frequency nitrate sensors to characterize nitrate concentration patterns and fluxes in different kinds of streams and rivers that drain into and out of reservoirs to understand variability in water quality. From these measurement we can also quantify the effectiveness of reservoirs to retain nitrate across a range of flow conditions. In order to help interpret these nitrate results, we also deployed ancillary high frequency sensors that measure specific conductance and water stage/discharge.
This dataset contains quality controlled level (Level 1) data for all of the variables measured for the EPA Nutrient Sensor Action Challenge. Individual file contain specific variables from data Collected in 2018. We implemented a simple workflow to develop usable datasets (Levels 0 and Level 1, Table 2), . Data was processed using custom Matlab code (Mathworks Inc., Natick, MA), and MS Excel. Unprocessed raw data (Level 0), consisting of multiple data streams at native measurement resolution, were compiled on an ongoing basis.
Low-cost high frequency nitrate sensor outputs data every 6 seconds. While, the other high frequency nitrate sensor (SUNA) output 16 frames of data every 15 minutes. Other sensors ( stage height, conductivity, temperature) provided data at 15-minute intervals. Grab sample (nutrients and chloride), and hand-held sensor measurements ( conductance, temperature, and dissolved oxygen) data was collected weekly or biweekly, in addition to periodic flow measurement data. Level 0 data consists raw sensor files, without an processing performed. For the next level of processing, outliers (Level 1), and bad data points were identified and removed based on existing or historic data, stage height was transformed to discharge by applying site-specific rating curve equation, and temporal aggregation performed and each site’s data was compiled into one CSV file.
Each file header contains site location and an explanation of variable names.
Resource Level Coverage
Water Quality at Sawyer Mill Reservoir on Bellamy River
Developed by: Gopal Mulukutla, with input from Wil Wollheim and Eliza Balch, University of New Hampshire
Table1 – Describes the monitoring locations on the Oyster River. Station names referred here are used in aggregated level 1 files archived on Hydroshare.
Table1 – Table showing the monitoring locations on the Bellamy River
| Station Name | Station* Description *| Lat | Long | Total Area *km2* | Comment | | --- | --- | --- | --- | --- | --- | | BELUP | Bellamy River at Bellamy Rd. | 43.17850 | -70.89302 | 68.4 | Major Inflow to Reservoir | | BELDN | Bellamy River at Sawyer Mill Dam | 43.25872 | -70.02664 | 70.6 | Outflow from Reservoir |
Table 2: Sensors deployed at each site.
| Description including name of equipment: | Measurement | Location | | --- | --- | --- | | SUNA (Submersible Ultraviolet Nitrate Analyzer) | Nitrate | BELUP | | Realtech GL2000 Series Sensor | Nitrate | BELDN | | Onset Inc. Hobo water level and conductivity logger | Stage height, water temperature and specific conductivity. | BELUPBELDN |
Table3: Time frame of deployment of sensors for each site.
|Station Name|Station Description|Sensors Deployed|Time Frame of Deployment|Time Frame of Nitrate Sensor Deployment| | --- | --- | --- | --- | --- | |BELUP| Bellamy River at Bellamy Rd. | Stage height, conductivity, temperature, and nitrate | 2018-05-01 to 2018-11-19 | 2018-10-14 to 2018-11-12 | |BELDN|Bellamy River at Sawyer Mill Dam|Stage height,conductivity, temperature, and nitrate | 2018-05-10 to 2018-12-20 | 2018-09-24 to 2018-11-16 |
Table 4: Summary of variable names in headers, and their description
| Variable Name | Description | | --- | --- | | STAGE.M.HOBO | Stage height in meters | | TEMP.C.HOBO | Temperature in degrees Celsius from continuous sensor | | SPCOND.uScm.HOBO | Specific Conductance in μS/cm from continuous sensor | | NO3.MGL | Sensor based NO3-N milligram per liter | | Cl.MGL.GRAB | Chloride milligram per liter | | NO3.MGL.GRAB | Grab sample based NO3-N milligram per liter | | SO4.MGL.GRAB | Grab sample based SO4 milligram per liter | | NA.MGL.GRAB | Grab sample based Sodium milligram per liter | | K.MGL.GRAB | Grab sample based Potassium in milligram per liter | | MG.MGL.GRAB | Grab sample based Magnesium in milligram per liter | | CA.MGL.GRAB | Grab sample based Calcium in milligram per liter | | TEMP.C.HANDHELD | Temperature in degrees Celsius from handheld sensor | | SPCOND.uScm.HANDHELD | Specific Conductance in μS/cm from handheld probe | | DO.PERCENT.HANDHELD | Dissolved Oxygen Percent Saturation from handheld probe | | DO.MGL.HANDHELD | Dissolved Oxygen concentration in milligram per liter | | STAGE.CM.VISUAL | Stage height in cm from visual in-ground stream gage | | NO3_MGL_REALTECH | Sensor based NO3-N milligram per liter from Realtech sensor | | NO3_FLAG_REALTECH | Bad data flag for sensor based NO3-N milligram per liter from Realtech sensor | | NO3_MGL_MOVAVG_REALTECH | Sensor based NO3-N milligram per liter processed data by removing noise | | NO3_MGL_SUNA | Sensor based NO3-N milligram per liter from SUNA sensor |
|Wilfred Wollheim||University of New Hampshire|
|Eliza Balch||UNH Water Systems Analysis Group;University of New Hampshire|
|Margaret Phillips||University of New Hampshire|
How to Cite
This resource is shared under the Creative Commons Attribution CC BY.http://creativecommons.org/licenses/by/4.0/
Please wait for the process to complete.