Transcript Document

Managing Data with the CUAHSI Hydrologic Information System
for the Santa Fe River Basin Research Projects in Florida
Water Institute
NSF projects and a Hydrologic Observatory
K.A. McKee, M.S. - University of Florida Water Institute
Since 2007, the UF Water Institute has been testing the hydrologic information system (HIS) and
web services. The Santa Fe River Basin (SFRB) Test Bed group is currently hosting rainfall,
groundwater levels and streamflow data from other agencies as well as the investigator-collected
TESTING HIS with Project #1. Chemical Sensing to Understand Source Water Mixing
data from a watershed modeling project. We envision a hydrologic observatory for this subwatershed of the Suwannee River basin in North Central Florida (Fig. 1) so that stakeholders and
researchers can explore relationships among multiple hydrologic factors over space and time.
Monthly data importation and maintenance is performed for one project (#1) as a test of the
The Santa Fe River Basin (SFRB) Florida, investigators are collecting high resolution (every hour) specific conductivity (SpC) at
12 river locations using deployed CTD Sondes. The basin overlies the limestone Floridan aquifer and is comprised of three
hydrogeological units: upper confined region where the Hawthorne formation separates the aquifer from the surface system,
the lower un-confined region where the Hawthorne formation is missing and the Floridan is at ground surface, and middle
semi-confined region (Fig. 1).
.
database structure, data visualization tools and download capabilities that the CUAHSI group is
developing. Data from other projects are imported to HIS on an annual basis for organization and
storage, and to provide access to data for the scientific community.
SpC reflects the sources and residence time of water before it reaches the steam; increased residence time in the subsurface
results in an increase in ionic concentration, and therefore higher SpC values, due to dissolution of the limestone matrix.
Rainfall and surface water reaching the stream show low SpC values. Historic water quality data obtained from the
Environmental Protection Agency (EPA) legacy database along with the SpC data we have collected since February 2009
showed a distinctive contrast in SpC values measured in the upper confined and the lower unconfined region of the basin.
Data from regional datasets are uploaded quarterly to support data exploration with other datasets
These data are imported into HIS using Streaming Data Loader as they are downloaded every month.
and test HIS.
(A)
In the upper parts of the basin (eastern end), surface runoff and surficial storage dominates the hydrology resulting in low SpC
values of the river water. In the lower unconfined region of the basin there is minimal runoff with virtually no stream network
feeding the river; excess rainfall in this region infiltrates through the vadose zone to the aquifer, which subsequently feeds the
river through a series of springs and diffuse groundwater inflow. This results in higher SpC values of the river water in the
lower unconfined region of the basin. Our objective is to exploit this hypothesized strong end-member separation between
riverine source water geochemistry to further improve our understanding of the riverine mixing and delivery dynamics and
finally use this understanding to refine the PARFLOW.CLM predictions under varying hydrological conditions.
Using HIS
The two most important tools for managing data from project #1 have been the
Streaming Data Loader – to get data in
(B)
Figure 2. Two example locations of CTD Sonde instruments that are measuring specific conductivity.
(A) a clear spring tributary to the Santa Fe river (source is mainly groundwater)
(B) a dark-water tannic part of the Santa Fe river (source is mainly surface runnoff)
Figure 1. The Santa Fe River basin in North Central Florida and CTD sonde
locations. The Hawthorn formation confines the Floridan aquifer from
surfacewater in the eastern end whereas in the western end of the basin that
confining unit is not present allowing much surface/groundwater interaction.
Hydrologic Observatory
HydroExcel – to get data out
Steps for data Management:
1. download CTD Sonde instruments to laptop, QA data and save CSV file
Web services :
1. Investigator Datasets:
• River nitrate data for 2 sensors
• Network of 14 CTD sondes in rivers and wells
• Estevelle study in 3 springs
• Hyporheic zone study in Ichetucknee River
• Dissolved organic Carbon sensor
2. Regional Datasets:
• Daily rainfall from regional Florida water agency (SRWMD)
• Groundwater levels from SRWMD
• Streamflow and levels from SRWMD
2. Copy to FTP site
3. Use Streaming data loader to import data for particular sites and variables
4. View data in Hydroexcel to check against previously loaded data etc.
Steps for data Viewing:
1. Use Hydroexcel Time Series and Statistics/Charts tabs to visualize single data series
2. Now experimenting with HydroDesktop to view and graph multiple data series;
documenting issues in Codeplex issue tracker.
(A)
Figure 3. The Santa Fe River basin in North Central Florida and two regional datasets that are
uploaded every quarter or annually. Rainfall is also uploaded every month.
Figure 4. Before HydroDesktop, we imported HydroExcel data to Matlab to make stacked plots A). Now we
are experimenting with HydroDesktop to create graphs (B) of 3 variables from 3 data networks to show
relationship among rain, specific conductivity and streamflow over time. SpC is orange, Rain is lavender,
Flow is purple. Note lag for flow after rain, and note inverse rel. between SpC and flow.
Projects with Datasets to be loaded into HIS this year
#2. Diurnal patterns of water chemistry in
a spring run
#3. Groundwater chemistry in the formation
of Estevelles
#4. Hyporheic flow in a spring run
In this project we work to understand hyporheic flow and work has focused on sampling and automated
sensing of conductivity, temperature and pressure of the sediment pore water in a springfed tributary of
In the SFRB, a spring run tributary called the
Madison Blue and Peacock Springs in Florida behave as
the Santa Fe River, the Ichetucknee. Five mini-piezometers installed at various depths within the
Ichetucknee River is a place of study for nitrogen
estevelles, recharging the aquifer during high river stages.
sediment containing CTD sondes have results showing minor variations in SpC that reflect variations in
metabolism. High rates of nitrogen cycling are
Potential effects of spring reversals during floods lead to
the sources of the water. Diel variations in temperature in the river that propagate to depth in the
observed in the rice marsh area of the river where
questions including: (1) what is the relationship between
sediment reflect conductive and possibly convective flow of heat into and out of the sediment.
high productivity and carbon are found in the
hydraulic head in the aquifer, discharge, diffuse recharge,
system. Figure shows that DO and pH exhibit
(B)
and aquifer confinement? (2) What are residence times of
HIS Benefits
•
Structured data storage and backup with associated metadata
•
Available tools for visualization
•
Available over the web
Recommendations
•
Ensure National Data sets are maintained and available (NWIS, ASOS, STORET)
•
Improve Data Access interfaces for easier use by Investigators
peaks between 15:00 and 16:00 daily, and broad
backflooded water in the aquifer and rate that it is
troughs between 2:00 and 6:00; NO3-N and SC
returned? (3) What are the solid-fluid reactions controlling
exhibit the inverse diel pattern,with broad peaks
backflooded water compositions? These springs are
Faster response time
occurring pre-dawn, and spiked troughs coinciding
connected to large cave and conduit systems. Temp,
Data harvesting in HIS Central could be hourly?
with DO peaks. Solid lines in NO3 and SC panels
pressure, turbidity, oxidation reduction potential, pH, DOC,
indicate flow-weighted mean concentration of
DO, and C13 are collected at the entrance as well as deeper
contributing springs, suggesting removal of N and
production of ions within the river.
Figure 5. Hourly DO, NO3-N, pH, and SpC.
inside each cave to learn about dissolution and water
chemistry changes over space and time.
Option to combine multiple series for same variable and date range for faster simpler data access.
Figure 6. Divers going into Peacock
Spring, FL.
Provide metadata during data exploration (before download)
Add feature that was in DASH of being able to post geographic layers (geology, land use etc) to
Figure 7. Conceptual model of pore-water zones and flow within river sediments. The
reaction zone has high carbon remineralization of org C , decreasing pH and
undersaturation of calcite where the limestone is being dissolved.
better inform user of spatial data components.
Structured user testing and feedback program to make more usable by busy hectic researchers who
are not intimate with ODM structure
The Investigators of the Santa Fe projects are:
W.D. Graham, J.B. Martin, M.J. Cohen, K.C. Slatton, J.J. Delfino
June 2011
Author contact information: Kathleen McKee
(352) 392-5893 x2114 • [email protected]