CUAHSI Hydrologic Information System Workshop

WEDNESDAY, JULY 16 - 10:00AM TO 5:00PM

PURPOSE

This workshop introduces you to CUAHSI's Hydrologic Information Systems (HIS). In this workshop, you will learn:

• What the CUAHSI HIS is and how it works (for all – busy people, professors)
• How to use HIS to get and analyze hydrologic data (for all – actual users, students)
• How HIS can be used in modeling and analysis (for modelers – students, programmers, MATLAB users)
• How to share and publish your data using HIS (for data managers – serious users, students collecting data)
• What the future plans are for CUAHSI HIS

SESSION 1: 10:00 – 12:00

INTRODUCTION TO HIS 1.1 (10:00 – 11:00)

Objectives:

• Review CUAHSI HIS goals, capabilities and data available through HIS.

Audience:

• This review will be presented at a high level for busy people (i.e. professors) who want to quickly learn the general capabilities of HIS, at present and anticipated for the future.

Presenters: David Maidment and Tim Whiteaker

Content:

• Introduction (David Maidment – 20 mins)
• HydroExcel demo (Tim Whiteaker)
• HIS web page (Tim Whiteaker)

Materials:

• Maidment's Overview/Introduction
• Session 1A Whiteaker Demo Script [PDF; 70 KB]
• HydroExcel Demo [XLSB; 1.2 MB]
• HydroObjects Setup [ZIP; 1.7 MB]

HIS FOR ALL. HOW TO USE HIS TO GET AND ANALYZE HYDROLOGIC DATA (11:00 – 12:00)

Objectives: Following this session participants should be able to:

• Search for data from a particular web service
• Search for data from many web services at once
• Analyze data from web services
• Incorporate water data services into a modeling environment

Audience:

• Researchers and students who will actually work hands on getting and analyzing HIS data

Presenters: David Maidment, Tim Whiteaker, David Tarboton, and Jon Goodall

Content:

• HydroSeek (Tim Whiteaker)
• MATLAB (David Tarboton)
• OpenMI (Jon Goodall) demos

Materials:

• Session 1B Whiteaker Demo Script [PDF; 69 KB]
• Tarboton Matlab Presentation [PPT; 583 KB]
• Matlab Tutorial [PDF; 130 KB]
• Matlab Tutorial Code [M; 4KB]
• HydroLink Demo [ZIP; 1.1 MB]

LUNCH (12:00 – 1:00)

SESSION 2: 1:00 – 3:00

HIS FOR DATA MANAGERS. HOW TO SHARE AND PUBLISH YOUR DATA USING HIS (1:00 – 3:00)

Objectives: Following this session participants should be able to:

• Load data into ODM using the OD Loader
• Load data into ODM using the Streaming Data Loader
• Examine and edit data in ODM using ODM tools
• Know what other options there are for data loading (SSIS)
• Know how to attach and detach ODM databases using SQL Server Management Studio and SQL Server Express
• Know how CUAHSI HIS data publication system works

Audience:

• Data managers, researchers and students who are collecting data that they want to share and analyze using HIS

Presenters: David Tarboton, Jeff Horsburgh, Ilya Zaslavsky, Tom Whitenack

Content:

• CUAHSI HIS data publication system (Tarboton)
• Observations data Model (ODM) (Tarboton)
• Using ODM (Horsburgh)
  • SQL Management Studio
  • ODM Tools
  • ODM Data Loader
  • Streaming Data Loader
  • Controlled vocabulary editing
  • SSIS for data loading (Tarboton)
• HIS Central (Zaslavsky)
  • Registration of your data service
  • Contribute your ODM

Materials:

• Tarboton Sharing & Publishing Presentation [PPT; 3.1 MB]
• ODM Demo Files [ZIP; 434 KB]
• SSIS Script [PDF; 1.1 MB]
• HIS Central Presentation [PPT; 2.1 MB]
• HIS Central Demo Script [PPT; 3.6 MB]

SESSION 3: 3:30 – 5:00

FUTURE OF CUAHSI HIS

Objectives: To discuss future plans for CUAHSI and the HIS community.

• Outline of plans for further development of CUAHSI HIS
• Standardized metadata catalog and web services to access it
• Digital Watershed development
• Critical Zone Observatory needs
• General discussion about interaction of CUAHSI with other interested organizations
  • ASCE EWRI (Marian Muste)

Audience:

• Anyone interested in HIS

Moderator: David Maidment