Hi, I'm an error. x

Development and Implementation of Database and Analyses for High Frequency Data


Authors: Hyrum Tennant · Amber Spackman Jones
Owners: Amber Jones · Hyrum Tennant
Resource type:Composite Resource
Created:Dec 02, 2018 at 3:27 a.m.
Last updated: Dec 11, 2018 at 6:28 a.m. by Hyrum Tennant

Abstract

For environmental data measured by a variety of sensors and compiled from various sources, practitioners need tools that facilitate data access and data analysis. Data are often organized in formats that are incompatible with each other and that prevent full data integration. Furthermore, analyses of these data are hampered by the inadequate mechanisms for storage and organization. Ideally, data should be centrally housed and organized in an intuitive structure with established patterns for analyses. However, in reality, the data are often scattered in multiple files without uniform structure that must be transferred between users and called individually and manually for each analysis. This effort describes a process for compiling environmental data into a single, central database that can be accessed for analyses. We use the Logan River watershed and observed water level, discharge, specific conductance, and temperature as a test case. Of interest is analysis of flow partitioning. We formatted data files and organized them into a hierarchy, and we developed scripts that import the data to a database with structure designed for hydrologic time series data. Scripts access the populated database to determine baseflow separation, flow balance, and mass balance and visualize the results. The analyses were compiled into a package of scripts in Python, which can be modified and run by scientists and researchers to determine gains and losses in reaches of interest. To facilitate reproducibility, the database and associated scripts were shared to HydroShare as Jupyter Notebooks so that any user can access the data and perform the analyses, which facilitates standardization of these operations.

Subject Keywords

Mass Balance,Hydrologic Time Series,Database,Flow Balance,Baseflow Analysis,High Frequency Data,Cyberinfrastructure,Water Quality,Sensors,Water Quantity

How to cite

Tennant, H., A. S. Jones (2018). Development and Implementation of Database and Analyses for High Frequency Data, HydroShare, http://www.hydroshare.org/resource/bf57045c30054383a6df9bb8cab381d3

This resource is shared under the Creative Commons Attribution CC BY.

 http://creativecommons.org/licenses/by/4.0/
CC-BY

Sharing status:

  • Public Resource  Public
  • Non Sharable Resource  Not Shareable

Coverage

Spatial:

 Coordinate System/Geographic Projection:  WGS 84 EPSG:4326
 Coordinate Units:  Decimal degrees
Place/Area Name: Logan River Watershed

North Latitude
41.9903°
East Longitude
-111.4388°
South Latitude
41.7356°
West Longitude
-111.7711°

Temporal:

 Start Date:
 End Date:

Content

Download All Content as Zipped BagIt Archive
Learn more about the Bagit archive format

Authors

The people or organizations that created the intellectual content of the resource.

Name Organization Address Phone Author Identifiers
Hyrum Tennant Utah State University
Amber Spackman Jones Utah State University

Ratings

Be the first one to  +1 this.  (You need to be logged in to rate this.)

Comments

There are currently no comments

New Comment

required