View All Pages

Lecture Materials

Lecture Materials

The calendar events for the course are not available to the public, so we have created this page for posting lecture materials.

Key to course reading material:
Assigned readings:  Read and come to class prepared to discuss the details of these readings.
Suggested readings: Read to get more insight and background on the lecture topic.    

Date

Topic

Lecturer
Aug. 25

University of Utah Only (USU and BYU no class)

Burian

Aug. 27

University of Utah Only (USU and BYU no class)

Burian
 
Sep. 1

Course Introduction

Course introduction, review of syllabus, introductions of instructors and students.

PowerPoint Slides: Download Class1_Intro_to_Hydroinformatics.pptx

Horsburgh, Ames, Burian

Sept. 3

iUTAH Hydrologic Data Collection Site Visit

Acquiring Hydrologic Data (Offline - each University field trip)

Horsburgh, Ames, Burian
 
Data and the Data Life Cycle

Sep. 8

Data Management and the Data Life Cycle

Assigned Readings:

Download iUTAH GAMUT Data Management Workflow

Download Guidelines for Effective Data Management

PowerPoint Slides:  Download Class3_DataLifeCycleDataManagement.pptx

 Horsburgh

Sep. 10

Introduction to HydroShare              

PowerPoint Slides:  Download HydroShareAWRA5min.pptx


Reading: http://www.iemss.org/sites/iemss2014/papers/iemss2014_submission_243.pdf Links to an external site. 

Metadata video: https://www.youtube.com/watch?v=N2zK3sAtr-4 Links to an external site. 

Class Activity: Use the Google Doc to fill in all the types of meta data associated with a YouTube video. Which of these are relevant to digital water data? What kinds of digital water data are there? https://goo.gl/J5kKSG Links to an external site. 

Class Activity: Go to: http://www.hydroshare.org Links to an external site. and create a user account. Upload file(s) of digital water data. Supply all required metadata including some searchable keywords. Discuss.

Ames
 
Databases and Data Models

Sep. 15

Data Models and Data Model Design

2014 Data Models Lecture:  http://www.kaltura.com/tiny/f9a6h Links to an external site.

2014 PowerPoint Slides:   Download 2014_Class5_DataModels.pptx

PowerPoint Slides:   Download Class5_DataModels.pptx

 Horsburgh

Sep. 17

Data Model Design (Continued)

MySQL Installation Instructions for Windows: Download Class6_Install_MySQL_and_MySQL_Workbench_on_Windows.pdf

MySQL Installation Instructions for Mac:  Download Class6_Install_MySQL_and_MySQL_Workbench_on_Mac_OSX.pdf

Instructions for Creating ER Diagrams in MySQL:  Download Class6_CreatingDataModelDiagramsinMySQLWorkbench.pdf

PowerPoint Slides:  Download Class6_DataModelDesign.pptx

 Horsburgh
 

Sep. 22

Database Implementation

PowerPoint Slides: Download Class7_DataModelImplementation.pptx


 Horsburgh

Sep. 24

Database Implementation (Continued)

Assigned Reading:

Suggested Reading:

PowerPoint Slides:  Download Class8_DataModelImplementation.pptx


 Horsburgh
 

Sep. 29

Using SQL to Query a Relational Database

PowerPoint Slides: Download Class9_UsingSQL.pptx

 Horsburgh

Oct. 1

Using SQL to Query a Relational Database (Continued)

PowerPoint Slides: Download Class10_UsingSQL.pptx

 Horsburgh
 

Oct. 6

Introduction to Python Programming - Part 1

PowerPoint Slides:  Download Intro to Python Part 1.pptx

Sample Code: 

Other Resources:

 

 Ames

Oct. 8

Introduction to Python Programming - Part 2

PowerPoint Slides:   Download Intro to Python Part 2.pptx


Sample Code:

 Ames
 
Visualizations, Transformations, Analysis, and Modeling

Oct. 13

Offline Python Programming Challenge (UofU Fall Break)

University of Utah is on Fall Break, but USU students will be doing the following:

PowerPoint Slides:   Download Class13_Python_Coding_Challenge.pptx

Python Coding Challenge: Download Class13_PythonCodingChallenge.pdf


 Local Instructor

Oct. 15

Offline Python Programming Challenge (UofU and USU Fall Break)

USU and University of Utah on Fall Break. BYU students - check with Dr. Ames for instructions!

PowerPoint Slides: - None

 Ames
 

Oct. 20

Using Python to Retrieve and Visualize Data - Part 1

PowerPoint Slides: Download Plotting with MatPlotLib.pptx


Debugging discussion:

  • Generic Tips at http://stackoverflow.com/questions/1623039/python-debugging-tips Links to an external site.
  • Consider using print and debug.print statements to write out intermediate values
  • Comment out code until you get a part that works and then gradually reintroduce your code
  • Use the PyCharm Run/Debug mode with Breakpoints to step through your code
  • Search for errors on StackOverflow.com
  • If your error says there is something wrong inside a core module that you didn't write, chances are the module is fine and you just passed it a bad value. 
  Ames

Oct. 22

Using Python to Retrieve and Visualize Data - Part 2

PowerPoint Slides:  none

Sample code for retrieving data, computing values, and making a graph of exceedance: 

SampleCode-Python.zip Download SampleCode-Python.zip

  Ames
 

Oct. 27

CUAHSI HIS and HydroDesktop

Pre-class: Install HydroDesktop (requires Windows Operating System). Download from http://hydrodesktop.codeplex.com Links to an external site.. 

PowerPoint Slides:  Download CUAHSI HIS and HydroDesktop.pptx

In Class Google Doc: http://goo.gl/mR6uwb Links to an external site.

 Ames

Oct. 29

CUAHSI HIS and HydroServer

PowerPoint Slides:  Download 2015 HydroServer.pptx

In Class Google Doc:  http://goo.gl/mR6uwb Links to an external site. Links to an external site.

In Class Sample Data: HydroServer_Sample_Data.zip Download HydroServer_Sample_Data.zip

 Ames
 

Nov. 3

Accessing Data from Web Services Using Python

PowerPoint Slides:  Download Class17_PythonWebServices.pptx

Example Python Scripts: Class17_ExamplePythonScripts.zip Download Class17_ExamplePythonScripts.zip

Horsburgh

Nov. 5

Accessing Data from Web Services using Python - Programming Challenge

PowerPoint Slides:  Download Class18_PythonWebServices.pptx

 Horsburgh
 

Nov. 10

Introduction to R

Pre-class Installation and Exercise (You will need to complete the exercise in order to answer a quiz on Tuesday):

Download PreClass Exercise R.pdf

Suggested Reading:

  Download R-intro.pdf

In class Activity:

Google Doc Links to an external site.

Sample_WQ_Files.zip Download Sample_WQ_Files.zip

Class19_TeamExercise1.R Download Class19_TeamExercise1.R

Class19_TeamExercises2_3_4_modified.R Download Class19_TeamExercises2_3_4_modified.R

PowerPoint Slides:  Download Class19_Intro_to_R.pptx

 Burian-Carly

Nov. 12

Accessing Data from Web Services using R, the USGS R DataRetrieval Package, and WaterML R Package

Pre-class (Look over and find 3 packages that you find particularly useful in your research/work): Useful Packages Links to an external site., Other Useful Packages Links to an external site.

Paste the packages in this Google Doc Links to an external site.

In class Activity:

USGS dataRetrieval GitHub Page Links to an external site.

Download WaterML Tutorial.pdf

PowerPoint Slides:  Download Class20_R_Packages_Data_Retrieval.pptx

 Burian-Carly
 

Nov. 17

Using R and Databases (RMySQL Package)

Pre-class: Be able to retrieve SNOTEL precipitation data using the WaterML package

In class Activity:

RMySQL_Example_Modified Download RMySQL_Example_Modified

SaltLakeAirport.csv Download SaltLakeAirport.csv

Google Doc Links to an external site.

PowerPoint Slides:  Download Class21_R_Databases.pptx

 Burian-Carly

Nov. 19

Creating R Packages

Pre-class: Complete Download PreClassInstallationPackages.docx

, and be able to load tables from R into your MySQL database.

In class Activity:

Free vs.Open Source Software Article Links to an external site.

Download Class22_Creating an R Hydrologic Toolbox Package Tutorial.pdf

SaltLakeAirport_Formatted.csv Download SaltLakeAirport_Formatted.csv

Google Doc Links to an external site. for discussion and sharing results

For future reference:

R Cheat Sheet Links to an external site.

PowerPoint Slides: Download Class22_R_CreatePackageActivity.pptx

 Burian-Carly
 

Nov. 24

Database to Modeling - Application with WEAP

Pre-class Installation of WEAP, TOAD, and downloading climate change projections from CMIP5:

Download Hydroinformatics Preclass Assignment for Class 23 (Nov. 24).pdf

Post-class (during) class assignment to Create and Manage MySQL Databases with TOAD and Create the change factor module in R:

Download Class 23 - Post Class Assignment part 1.docx

PowerPoint Slides:  Download Class 23_Impact of climate change on water resources.pptx

 Burian-Erfan

Nov. 26

 Thanksgiving day. No class.
 

Dec. 1

Database to Modeling - Application with WEAP (continued)

Historical precipitation CSVs for WEAP modeling: SaltLakeAirport.csv Download SaltLakeAirport.csv and Parleys.csv Download Parleys.csv

Class handout: Download Class 24 Class Handout - Create a WEAP Model.docx

Suggested Reading:

  Download WEAP_Tutorial.pdf

Download WEAP_User_Guide.pdf

PowerPoint Slides:  Download Class 24 (Dec. 1) - Modelling in WEAP.pptx

 Burian-Erfan

Dec. 3

Database to Modeling - Application with WEAP (continued)

Pre-class assignments: Loading future precipitation tables to database & download and install MySQL connector ODBC: Download Class 25 Preclass handout.docx


Future (2010-2039) precipitation CSVs for WEAP modeling (based on change factor approach): Future Precipitation airport.csv Download Future Precipitation airport.csv and Future Precipitation Parleys.csv Download Future Precipitation Parleys.csv


Post-class assignments: Scenario Analysis and Automation of WEAP: Download Class 25 Post class Handout - Scenario Analysis and Automation of WEAP.docx

PowerPoint Slides:  Download Lecture 25 - Automation and scenario WEAP.pptx

  Burian-Erfan
 

Dec. 8

Final Project Presentations

 Students

Dec. 10

Student Lightning Talks, Course Wrap Up, and Review

PowerPoint Slides:  Download Class27_CourseWrapup_12-9-2015.pptx

 All
 

Dec. 15

 USU Finals Week All

Dec. 17

 USU Finals Week All