Exercises organizing loading and managing point observations using hydroserver
Download
1 / 7

Exercises: Organizing , Loading, and Managing Point Observations Using HydroServer - PowerPoint PPT Presentation


  • 88 Views
  • Uploaded on

Exercises: Organizing , Loading, and Managing Point Observations Using HydroServer. http://his.cuahsi.org/. Jeffery S. Horsburgh Utah Water Research Laboratory Utah State University. CUAHSI HIS Sharing hydrologic data. Support EAR 0622374. In T hese Exercises.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Exercises: Organizing , Loading, and Managing Point Observations Using HydroServer' - mele


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Exercises organizing loading and managing point observations using hydroserver

Exercises: Organizing, Loading, and Managing Point Observations Using HydroServer

http://his.cuahsi.org/

Jeffery S. Horsburgh

Utah Water Research Laboratory

Utah State University

CUAHSI

HIS

Sharing hydrologic data

Support

EAR 0622374


In t hese exercises
In These Exercises

  • GOAL: Organize and load observational data for a continuous water quality monitoring site in the Little Bear River

  • Training Machine Software

    • Microsoft SQL Server 2008 R2 Express

    • CUAHSI HIS ODM Data Loader

    • CUAHSI HIS ODM Streaming Data Loader

    • CUAHSI HIS ODM Tools


The data you will be using
The Data You Will be Using

  • 7 water quality and streamflow monitoring sites

    • Temperature

    • Dissolved Oxygen

    • pH

    • Specific Conductance

    • Turbidity

    • Water level/discharge

  • 4 weather stations

    • Temperature

    • Relative Humidity

    • Solar radiation

    • Precipitation

    • Barometric Pressure

    • Wind speed and direction

    • Soil moisture

  • Spread spectrum radio telemetry network


Steps
Steps

Exercise 1: Create a blank ODM database

Exercise 2: Using the ODM Data Loaders

  • Load site, variable, method, and source metadata using the ODM Data Loader

  • Load sensor observations using the ODM Streaming Data Loader

    Exercise 3: Visualize and explore the data using ODM Tools


Odm data loader
ODM Data Loader

  • Loading data to any table in ODM – e.g., Sites, Variables, Methods, etc.

  • Loading Data Values in serial format

    • Multiple sites and variables in one file

    • All data values in a single column


Odm streaming data loader
ODM Streaming Data Loader

  • Focused on loading data values

  • Crosstab data

    • Single site, multiple variables

    • Date in one column, each variable in one column

    • Datalogger files from field sensors


Questions

Questions?

http://his.cuahsi.org/

CUAHSI

HIS

Sharing hydrologic data

Support

EAR 0622374


ad