View All Pages

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.    

Course Introduction

Aug. 23 - University of Utah Only (USU and BYU no class) - Burian

Aug. 25 - University of Utah Only (USU and BYU no class) - Burian

 

Aug. 30 - Course Introduction - Horsburgh, Ames, Burian
Course introduction, review of syllabus, introductions of instructors and students
PowerPoint Slides:  Download Class1_Intro_to_Hydroinformatics.pptx

Sept. 1 - Introduction to HydroShare and Semester Projects - Ames
PowerPoint Slides: See https://www.hydroshare.org/resource/5ec2617d7dc84c90a7e596d67846a40a/ Links to an external site.

 

Data and the Data Life Cycle

Sept. 6 - iUTAH GAMUT Monitoring Site Visit - Local Instructor

Sept. 8 - Data Management and the Data Life Cycle - Horsburgh
PowerPoint Slides:  Download Class4_DataLifeCycleDataManagement.pptx


Assigned Reading: Download Some simple guidelines for effective data management
Assigned Reading: Download A data management and publication workflow for a large-scale, heterogeneous sensor network

 

Sept. 13 - Datalogger Programming and Data Collection - Horsburgh
PowerPoint Slides:  Download Class5_DataCollection.pptx

Sept. 15 - Datalogger Programming Using Arduino Part 1 - Horsburgh
PowerPoint Slides:  Download Class6_DataloggerProgrammingArduino.pptx


Example Arduino Sketches: Class6_ExampleSketches.zip Download Class6_ExampleSketches.zip
Suggested Reading:  Download Class6_Kirchner_et_al-2004-Hydrological_Processes.pdf

 

Sept. 20 - Datalogger Programming Using Arduino Part 2 - Horsburgh
PowerPoint Slides:  Download Class7_DataloggerProgrammingArduino.pptx


Example Arduino Sketches: Class7_ExampleSketches.zip Download Class7_ExampleSketches.zip
Suggested Reading:  Download Class7_HYDRO-D-14-00092.pdf

Sept. 22 - Datalogger Programming Using Arduino Part 3 - Horsburgh
PowerPoint Slides:  Download Class8_Bringing_it_Together.pptx

 

Databases and Data Models

Sept. 27 - Data Models and Data Model Design - Horsburgh
PowerPoint Slides:  Download Class9_DataModels.pptx

Sept. 29 - Data Model Design - Horsburgh
PowerPoint Slides:  Download Class10_DataModelDesign.pptx


Installing MySQL Workbench on Windows:  Download Class10_Install_MySQL_and_MySQL_Workbench_on_Windows.pdf
Installing MySQL Workbench on Mac:  Download Class10_Install_MySQL_and_MySQL_Workbench_on_Mac_OSX.pdf
Creating Entity Relationship Diagrams Using MySQL Workbench:  Download Class10_CreatingDataModelDiagramsinMySQLWorkbench.pdf

 

Oct. 4 - Database Implementation Part 1 - Horsburgh
PowerPoint Slides:  Download Class11_DataModelImplementation.pptx

Oct. 6 - Database Implementation Part 2 - Horsburgh
PowerPoint Slides:  Download Class12_DataModelImplementation.pptx


Required Reading:  Download Class12_Horsburghetal_2007_ODM_WRR.pdf
Reference Material:  Download Class12_ODM1.1.1DesignSpecifications.pdf

 

Oct. 11 - UofU Fall Break - Using SQL to Query a Relational Database Part 1 - Horsburgh
PowerPoint Slides:  Download Class13_UsingSQL.pptx


Video Recording
NOTE:  Audio and class begins at about minute 13 in the video
Low Resolution Video in Canvas Download Low Resolution Video in CanvasPlay media comment. (~80 MB file)
High Resolution Video in Canvas Download High Resolution Video in CanvasPlay media comment. (~1 GB file)

Oct. 13 - UofU Fall Break - Using SQL to Query a Relational Database Part 2 - Horsburgh 
PowerPoint Slides:  Download Class14_UsingSQL.pptx


Video Recording

NOTE: Audio and class begins at about minute 29 in the video
Low Resolution Video in Canvas Download Low Resolution Video in CanvasPlay media comment. (~110 MB)
High Resolution Video in Canvas Download High Resolution Video in CanvasPlay media comment. (~1.1 GB)

 

Oct. 18 - UofU watches SQL Lecture 1, Offline Programming Challenge at BYU and USU - Ames, Horsburgh 
USU PowerPoint Slides: Download Class14.5_Python_Coding_Challenge.pptx


Python Script:  Download usgsdataretrieval.py

Oct. 20 - UofU watches SQL Lecture 2, Offline Python Programming Challenge at BYU - Ames, USU Fall Break - BYU to join Weidman Leadership Lecture 214 Crabtree 1:00 PM Angelica Gutierrez. 

 

Oct. 25 - Publishing Data Using WaterOneFlow Web Services - Ames
PowerPoint Presentation:  Download Class 15 HydroServer.pptx


Instructions for setting up your server: Download Instructions for setting up your server on worldwater.docx

Oct. 27 - Discover Data Using the HIS Central Catalog and the CUAHSI Data Client - Ames
PowerPoint Presentation:  Download Class 16 HydroClient.pptx

 

Visualization, Transformation, and Analysis

Nov. 1 - Introduction to Python Programming Part 1 - Ames
PowerPoint Presentation:  Download Intro to Python and PyCharm Part I.pptx

Nov. 3 - Introduction to Python Programming Part 2 - Ames
PowerPoint Presentation:  Download Intro to Python and PyCharm Part II.pptx

 

Nov. 8 - Using Python to Retrieve and Visualize Data Part 1 - Ames
PowerPoint Presentation:  Download Intro to Python Part III.pptx


Sample Python Script:  Download ODMFunctions.py

Nov. 10 - Using Python to Retrieve and Visualize Data Part 2 - Ames
PowerPoint Presentation:  Download Intro to Python Part IV.pptx

 

Nov. 15 - Accessing Data from Web Services Using Python Part 1 - Horsburgh
PowerPoint Presentation:  Download Class21_PythonWebServices.pptx


Sample Scripts: Class21_ExampleScripts.zip Download Class21_ExampleScripts.zip

Nov. 17 - Accessing Data from Web Services Using Python Part 2 - Horsburgh
PowerPoint Presentation:  Download Class22_PythonWebServices.pptx

 

Nov. 22 - Accessing Data from Web Services Using R - Hansen/Burian
PreClass:  Download PreClass Exercise R.pdf


PowerPoint Presentation:  Download Class23_Intro_to_R-1.pptx
In-class Google Doc: https://goo.gl/1420T2 Links to an external site.
Sample Water Quality Data File: Sample_WQ_Files.zip Download Sample_WQ_Files.zip

Nov. 24 - Thanksgiving (No Class!!)

 

Nov. 29 - Data Visualization and Analysis Using R Part 1 - Hansen/Burian
PowerPoint Presentation:  Download Class24_R_Packages_Data_Retrieval.pptx


WaterML Tutorial: https://www.cuahsi.org/Files/Posts/documents/WDC_Handout.pdf Links to an external site.
WaterML Activity GoogleDoc: https://goo.gl/Fy0Zjc Links to an external site.

Example R Code:

Class24_USGSRetrievalDemo.R Download Class24_USGSRetrievalDemo.R

Class24_WaterMLDemo.R Download Class24_WaterMLDemo.R

RMySQL_Example.R Download RMySQL_Example.R

Dec. 1 - Creating Packages in R - Hansen/Burian
PreClass Exercise:  Download PreClassInstallationPackages.pdf

. If you had any errors, try these fixes:  Download errorRtoolsFix.docx

PowerPoint Presentation:  Download Class25_R_CreatePackageActivity-1.pptx

Useful links for developing and publishing packages:

Open source explanation Links to an external site.; Licenses Links to an external site.

Demo video (working through the steps of creating a package): https://drive.google.com/open?id=0Bx_z0Ix7lhw5QmR0RmdLU0NNT3M Links to an external site. 

*Note that the video did not show some of the drop downs (e.g. Build>Build and Reload). 

R Hydrologic In-Class Exercise:  Download Class25_Creating an R Hydrologic Toolbox Package Tutorial.docx

Example completed Hydrologic Toolbox Package: Hydrotlbx.zip Download Hydrotlbx.zip

 

Dec. 6 - Final Project Presentations - Students

Dec. 8 - Student Lightning Talks and Course Wrap-up - All

 

Dec. 13 - Finals Week

Dec. 15 - Finals Week