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

Introduction to Python Programming

PowerPoint Slides Download Class1_Intro_to_Python.pptx

Video Recording:  http://www.kaltura.com/tiny/88l5z Links to an external site.

Horsburgh

Aug. 28

Intro to Python Programming Coding Challenge

PowerPoint Slides:  None (in class exercises)

Python Coding Challenge Download Class2_PythonCodingChallenge.pdf

Example Python Scripts:

Video Recording:  http://www.kaltura.com/tiny/csdtd Links to an external site.

Horsburgh, Goodall

 
Data and the Data Life Cycle

Sep. 2

Water Data Opportunities in the Information Age

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

PowerPoint Slides:   Download Class3_Intro_to_Hydroinformatics.pptx

Video Recording:  http://www.kaltura.com/tiny/23noz Links to an external site. 

Horsburgh,

Ames,

Burian,  

Goodall,

Ogden

Sep. 4

Data Management, the Data Life Cycle, and Metadata

Pre-Class (required):

     PowerPoint: Download Class4_DataLifeCycleDataManagement - 2014.pptx

     Videos: 2013 Lecture Recording Links to an external site. 

Metadata Cartoon "I want your data"

"I Want Your Data Cartoon" Links to an external site.

                   Metadata Video Links to an external site.

     Reading:  Download Class4_0012-9623-90.2.205.pdf

                      Download Class4_EthanWhiteShareData2013.pdf

                      Download Class4_Michener2006.pdf

     Sample Data Management Plans:   Download Class4_CI-WATER_DMP.pdf

                  

                                                                 Download Class4_iUTAH_DMP.pdf

                                           

PowerPoint Slides: Download Lecture4_DataMgmt+Metadata_Fall2014.pptx

 

Class Activity:  Download Class4_Activity1_DMP.docx

Video Recordinghttp://www.kaltura.com/tiny/1xds1 Links to an external site.

Burian

 
Databases and Data Models

Sep. 9

Data Models

PowerPoint Slides Download Class5_DataModels.pptx

Video Recording:  http://www.kaltura.com/tiny/f9a6h Links to an external site.

Horsburgh

Sep. 11

Data Model Design

PowerPoint Slides:   Download Class6_DataModelDesign.pptx

Software Installation Instructions for Mac:
Download Class6_Install_MySQL_and_MySQL_Workbench_on_Mac_OSX.pdf

Software Installation Instructions for Windows:
Download Class6_Installing_MySQL_and_MySQL_Workbench_on_Windows.pdf

Instructions:  Download Class6_CreatingDataModelDiagramsinMySQLWorkbench.pdf

Video Recording: http://www.kaltura.com/tiny/g4cqd Links to an external site.

Horsburgh
 

Sep. 16

Data Model Design

PowerPoint Slides:  Download Class7_DataModelDesign.pptx

Video Recording:  http://www.kaltura.com/tiny/2c363 Links to an external site.

Horsburgh

Sep. 18

Data Model Design

PowerPoint Slides:  None.  In class exercises and demos.

Video Recording:  http://www.kaltura.com/tiny/2m6rf Links to an external site.

Horsburgh
 

Sep. 23

Database Implementation

PowerPoint Slides:  Download Class9_DataModelImplementation.pptx

Video Recording:  http://www.kaltura.com/tiny/fuf7t Links to an external site.

Horsburgh

Sep. 25

Database Implementation

Assigned Reading:  

Suggested Reading:  

PowerPoint Slides:   Download Class10_DataModelImplementation.pptx


Video Recording:  http://www.kaltura.com/tiny/9bavn Links to an external site.

Horsburgh
 

Sep. 30

Using SQL to Query a Relational Database

Assigned Reading:

PowerPoint Slides:   Download Class11_UsingSQL.pptx

Video Recording:  http://www.kaltura.com/tiny/36et1 Links to an external site.

Horsburgh

Oct. 2

Using SQL to Query a Relational Database

PowerPoint Slides:   Download Class12_UsingSQL.pptx

Video Recording:  http://www.kaltura.com/tiny/fobj4 Links to an external site. 

Horsburgh
 
Visualizations, Transformations, Analysis, and Modeling

Oct. 7

Using Python to Retrieve and Visualize Data

Assigned Readings:

Recommended Readings:

PowerPoint Slides:  Download Class13_VizPython.pptx

Video Recording:  http://www.kaltura.com/tiny/fk6je Links to an external site.

Goodall

Oct. 9

Using Python to Retrieve and Visualize Data

Assigned Readings:

PowerPoint Slides: Download Class14_VizPython.pptx


Example Python Scripts: 

Video Recording:  http://www.kaltura.com/tiny/awz1d Links to an external site.

Goodall
 

Oct. 14

Fall break week for some sections. Check with your local instructor for plans for this week.  

Oct. 16

Fall break week for some sections. Check with your local instructor for plans for this week.  
 

Oct. 21

Introducing Service Oriented Architecture, Web Services, the CUAHSI Hydrologic Information System, and the HIS Central Catalog

PowerPoint Slides:  Download Class15-HIS.pptx

 (for this week and next week)

Video Recording:   http://www.kaltura.com/tiny/8lyy6 Links to an external site.

Ames

Oct. 23

Sharing data on the CUAHSI HIS using HydroServer PHP. Installation, configuration and entry of data into HydroServer, using the HydroServer web interface.

Video Recording:  http://www.kaltura.com/tiny/12jm6 Links to an external site.

Ames
 

Oct. 28

Retrieving Data from a HydroServer Through Web Services

Video Recording:  http://www.kaltura.com/tiny/7shdh Links to an external site.

Ames

Oct. 30

Search and Discovery of Data on the HIS Central Catalog Using HydroDesktop. 

Jacob's Well Exercise:  HydroDesktop Tutorial - Jacob's Well-2014.docx Download HydroDesktop Tutorial - Jacob's Well-2014.docx

Video Recording:   http://www.kaltura.com/tiny/gim2t Links to an external site.

Ames
 

Nov. 4

Accessing Data from Web Services using Python

PowerPoint Slides: Class19_PythonWebServices.pptx Download Class19_PythonWebServices.pptx

Video Recording:  http://www.kaltura.com/tiny/gaan4 Links to an external site.

Goodall

Nov. 6

Accessing Data from Web Services using Python - Programming Challenge

PowerPoint Slides:   Download Class20_PythonWebServices.pptx

Video Recording: http://www.kaltura.com/tiny/hcnyc Links to an external site.

Horsburgh
 

Nov. 11

Analysis Web Services: Using Python to Interact with the EPA WATERS Web Services

PowerPoint Slides: Class21_AnalysisWebServices.pptx Download Class21_AnalysisWebServices.pptx

Example Code: https://github.com/goodalljl/hydroinformatics_class/blob/master/Class21_NHDGeocoder.py Links to an external site. 

Video Recordinghttp://www.kaltura.com/tiny/frnom Links to an external site.

Goodall

Nov. 13

Analysis Web Services: Using Python to Interact with the EPA WATERS Web Services (part 2)

PowerPoint Slides: Class22_AnalysisWebServices.pptx Download Class22_AnalysisWebServices.pptx

Example Code: https://github.com/goodalljl/hydroinformatics_class/blob/master/Class22_NHDFlowlineDistanceTool.py Links to an external site. 

Video Recordinghttp://www.kaltura.com/tiny/ewl8e Links to an external site.

Goodall
 

Nov. 18

Preparing precipitation data for a model: Introduction to working with NEXRAD data stored in NetCDF format using Python

PowerPoint Slides: Class23_ModelDataPrep.pptx Download Class23_ModelDataPrep.pptx

Example NetCDF File:

Example Code:

Video Recording: Unfortunately, we had technical problems on this day and no video is available.

Goodall

Nov. 20

Preparing precipitation data for a model: Continue working with NEXRAD data stored in NetCDF format using Python; Introduce OPeNDAP/PyDAP for working with gridded data 

PowerPoint Slides: Class24_ModelDataPrep.pptx Download Class24_ModelDataPrep.pptx

Example Codes:

Video Recordinghttp://www.kaltura.com/tiny/295ht Links to an external site.

Goodall
 

Nov. 25

Drowning in Data

PowerPoint Slides:   Download Ogden_24Nov2014_Drowning_in_Data_Panama.pdf

Video Recording: http://www.kaltura.com/tiny/gmtcx Links to an external site.

Ogden

Nov. 27

Thanksgiving day. No class.  
 

Dec. 2

Final Project Oral Presentations

Video Recording: http://www.kaltura.com/tiny/7mc42 Links to an external site. (USU Student Presentations Only)

Students

Dec. 4

Course Wrap Up and Review

Video Recordinghttp://www.kaltura.com/tiny/bttid Links to an external site.

All
 

Dec. 9

USU Finals Week All

Dec. 11

USU Finals Week All