1 / 7

Organizing and Managing Point Observations for Water Quality Monitoring

This exercise focuses on organizing and loading observational data for a continuous water quality monitoring site in the Little Bear River. Participants will utilize Microsoft SQL Server 2008 R2 Express and CUAHSI's ODM tools, including the ODM Data Loader and Streaming Data Loader, to handle data from multiple monitoring sites. Key activities include creating an ODM database, loading metadata, and visualizing water quality and streamflow data such as temperature, pH, and turbidity, as well as weather data. This training supports better management of hydrologic data.

mele
Télécharger la présentation

Organizing and Managing Point Observations for Water Quality Monitoring

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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

  2. 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

  3. 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

  4. 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

  5. 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

  6. 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

  7. Questions? http://his.cuahsi.org/ CUAHSI HIS Sharing hydrologic data Support EAR 0622374

More Related