exercises organizing loading and managing point observations using hydroserver
Download
Skip this Video
Download Presentation
Exercises: Organizing , Loading, and Managing Point Observations Using HydroServer

Loading in 2 Seconds...

play fullscreen
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