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. 27 |
Course Introduction for USU and UofU USU and UofU will hold a brief introductory class offline. BYU will not start until the following week. |
Horsburgh |
|
Aug. 29 |
Guest Lecture USU and UofU will be online. No class for BYU students. PowerPoint Slides: ResearchOpportunitiesinHydroinformatics_8-29-2013.pptx Download ResearchOpportunitiesinHydroinformatics_8-29-2013.pptx |
Horsburgh |
|
|
|
|
|
Sep. 3 |
Water Data Opportunities in the Information Age Course introduction, review of syllabus, introductions of instructors and students. PowerPoint Slides: Lecture1_Intro_9-3-2013.pptx Download Lecture1_Intro_9-3-2013.pptx Video Recording: UEN Kaltura Server Links to an external site. |
Horsburgh, Ames, Burian |
|
Sep. 5 |
Data Management and the Data Life Cycle PowerPoint Slides: Lecture2_DataLifeCycleDataManagement - 2013.pptx Download Lecture2_DataLifeCycleDataManagement - 2013.pptx Assigned Readings: White, E.P, Baldridge, E., Brym, Z.T., Locey, K.J., McGlinn, D.J., and S.R. Supp (2013). Nine simple ways to make it easier to (re)use your data, PeerJ PrePrints, http://dx.doi.org/10.7287/peerj.preprints.7v2 Links to an external site.. [PDF Download PDF] Borer, E.T., E.W. Seabloom, M.B. Jones, and M. Schildhauer (2009). Some simple guidelines for effective data management, ESA Bulletin, 90(2):205-214, http://dx.doi.org/10.1890/0012-9623-90.2.205 Links to an external site.. [PDF Download PDF] Suggested Readings: CI-WATER DMP Download CI-WATER DMP, iUTAH DMP Download iUTAH DMP, WSC DMP Download WSC DMP Video Recording: UEN Kaltura Server Links to an external site. |
Burian |
|
|
|
|
|
Sep. 10 |
Metadata PowerPoint Slides: Lecture3_Metadata_Fall2013.pptx Download Lecture3_Metadata_Fall2013.pptx Suggested readings: Michener, W.K., J.W. Brunt, J.J. Helly, T.B. Kirchner, and S.G. Stafford (1997). Nongeospatial metadata for the ecological sciences, Ecological Applications, 7(1), 330-342, http://dx.doi.org/10.1890/1051-0761(1997)007[0330:NMFTES]2.0.CO;2 Links to an external site.. [PDF Download PDF] Michener, W.K. (2006). Meta-information concepts for ecological data management, Ecological Informatics, 1(1), 3-7, http://dx.doi.org/10.1016/j.ecoinf.2005.08.004
Links to an external site.. [PDF
Download PDF]
Geospatial Multistate Archive and Preservation Partnership - FGDC and Dublin Core Metadata Comparison: http://www.geomapp.net/docs/MetadataComparison_200903.pdf
Links to an external site.
Summary of Metadata Examples: Good and Bad Metadata Examples.pdf
Download Good and Bad Metadata Examples.pdf
Video Recording: UEN Kaltura Server
Links to an external site.
|
Burian |
|
Sep. 12 |
Data Models PowerPoint Slides: Lecture4_DataModels.pptx Download Lecture4_DataModels.pptx Video Recording: UEN Kaltura Server Links to an external site. |
Horsburgh |
|
|
|
|
|
Sep. 17 |
Data Model Design PowerPoint Slides: Lecture5_DataModelDesign.pptx Download Lecture5_DataModelDesign.pptx Suggested Reading: Creating data model design diagrams using MySQL Workbench. Download Creating data model design diagrams using MySQL Workbench. Creating data model design diagrams using Microsoft Visio. Download Creating data model design diagrams using Microsoft Visio. Video Recording: UEN Kaltura Server Links to an external site. |
Horsburgh |
|
Sep. 19 |
Data Model Design PowerPoint Slides: Lecture6_DataModelDesign.pptx Download Lecture6_DataModelDesign.pptx Video Recording: UEN Kaltura Server Links to an external site. |
Horsburgh |
|
|
|
|
|
Sep. 24 |
Database Implementation PowerPoint Slides: Lecture7_DataModelImplementation.pptx Download Lecture7_DataModelImplementation.pptx Suggested Readings: Horsburgh, J. S., D. G. Tarboton, D. R. Maidment, and I. Zaslavsky (2008), A relational model for environmental and water resources data, Water Resources Research, 44, W05406, http://dx.doi.org/10.1029/2007WR006392 Links to an external site., [PDF Download PDF]. Horsburgh, J.S., D.G. Tarboton (2012). CUAHSI Community Observations Data Model (ODM) Version 1.1.1 Design Specifications, Consortium of Universities for the Advancement of Hydrologic Science, Inc., Washington, D.C., http://www.codeplex.com/Download?ProjectName=HydroServer&DownloadId=349176 Links to an external site., [PDF Download PDF]. Video Recording: UEN Kaltura Server Links to an external site. |
Ames |
|
Sep. 26 |
Database Implementation PowerPoint Slides: None. Video Recording: UEN Kaltura Server Links to an external site. |
Ames |
|
|
|
|
|
Oct. 1 |
Using SQL to Query a Relational Database PowerPoint Slides: Lecture9_UsingSQL.pptx Download Lecture9_UsingSQL.pptx Additional Reference Materials: ODM1.1.1SchemaDiagram.pdf Download ODM1.1.1SchemaDiagram.pdf Video Recording: UEN Kaltura Server Links to an external site. |
Horsburgh |
|
Oct. 3 |
Using SQL to Aggregate and Pivot Data PowerPoint Slides: Lecture10_UsingSQL.pptx Download Lecture10_UsingSQL.pptx Video Recording: UEN Kaltura Server Links to an external site. |
Horsburgh |
|
|
|
|
|
Oct. 8 |
Introduction to R and Using the USGS Data Retrieval Tool PowerPoint Slides: Lecture11_IntrotoR.pptx Download Lecture11_IntrotoR.pptx Suggested Readings: Venables, W.N., D.M. Smith, and the R Core Team (2013). An Introduction to R, Version 3.0.2, http://cran.r-project.org/doc/manuals/R-intro.pdf Links to an external site.. USGS R dataRetrieval package documentation: USGS_dataRetrieval.pdf Download USGS_dataRetrieval.pdf Sample R Script: USGS_R_Data_Retrieval.r Download USGS_R_Data_Retrieval.r Video Recording: UEN Kaltura Server Links to an external site. |
Horsburgh |
|
Oct. 10 |
Moving Data Across Platforms – Database to R and Analyzing Data PowerPoint Slides: Lecture12_DatabasetoR.pptx Download Lecture12_DatabasetoR.pptx Suggested Readings: Instructions for Assignment 5 Download Instructions for Assignment 5 Video Recording: UEN Kaltura Server Links to an external site. |
Horsburgh |
|
|
|
|
|
Oct. 15 |
Sensors, Cyberinfrastructure, and Water Quality in the Little Bear River: Adventures in Continuous Monitoring PowerPoint Slides: Lecture13_LBRDataCollection.pptx
Download Lecture13_LBRDataCollection.pptx Video Recording: UEN Kaltura Server Links to an external site. UofU Fall Break (no class for UofU students) USU and BYU will meet on this day |
Horsburgh |
|
Oct. 17 |
Fall Break UofU Fall Break (no class) USU Friday Class Schedule (no class) BYU Students will meet on this day |
Ames |
|
|
|
|
|
Oct. 22 |
Programming for Automation of Common Data Management Tasks, Part 1 PowerPoint Slides: Lecture14_Python.pptx Download Lecture14_Python.pptx Sample Code: PyOBDC.py Download PyOBDC.py Suggested Readings: Python in Hydrology, pages (tbd). Download from http://www.greenteapress.com/pythonhydro/pythonhydro.html Links to an external site. Video Recording: UEN Kaltura Server Links to an external site. |
Ames |
|
Oct. 24 |
Programming for Automation of Common Data Management Tasks, Part 2 PowerPoint Slides: No slides. Class discussion on sample code. Video Recording: UEN Kaltura Server Links to an external site. |
Ames |
|
|
|
|
|
Oct. 29 |
Service Oriented Architecture for Sharing Hydrologic Data: The CUAHSI HIS PowerPoint Slides: Lecture15_HydroDesktop and HIS.pptx Download Lecture15_HydroDesktop and HIS.pptx Video Recording: UEN Kaltura Server Links to an external site. |
Ames |
|
Oct. 31 |
Using HydroDesktop to Search, Discover, View, and Analyze Data in the HIS Network PowerPoint Slides: See lecture 15 Video Recording: UEN Kaltura Server Links to an external site. |
Ames |
|
|
|
|
|
Nov. 5 |
HydroServer Lite: A Quick Way to Get Data Online and Join the CUAHSI HIS PowerPoint Slides: Lecture16_HydroServer and HydroServerLite.pptx Download Lecture16_HydroServer and HydroServerLite.pptx Web hosting URL for Thursday: Create a user account on http://www.000webhost.com Links to an external site. Video Recording: UEN Kaltura Server Links to an external site. |
Ames |
|
Nov. 7 |
Customizing HydroServer Lite to Meet the Needs of Your Organization PowerPoint Slides: No slides. Video Recording: UEN Kaltura Server Links to an external site. |
Ames |
|
|
|
|
|
Nov. 12 |
Database and Climate Projection Data Analysis Pre-class Preparation (REQUIRED): Lecture 20 - Preclass Instructions.pdf
Download Lecture 20 - Preclass Instructions.pdf PowerPoint Slides: Lecture20_MySQLClimateData.pptx Download Lecture20_MySQLClimateData.pptx Class Materials: CMIP5 Analyzer - Example.xls Download CMIP5 Analyzer - Example.xls Class 20 Post-Class Handout - Climate projection data analysis.pdf Download Class 20 Post-Class Handout - Climate projection data analysis.pdf Class 20 Post-Class Handout - Create a desktop database.pdf Download Class 20 Post-Class Handout - Create a desktop database.pdf Video Recording: UEN Kaltura Server Links to an external site. |
Burian |
|
Nov. 14 |
Hydrologic and Water Management Modeling PowerPoint Slides: Lecture21_WEAP.pptx Download Lecture21_WEAP.pptx Class Materials: Class 21 Post-Class Handout - Create a WEAP Model vFINAL.pdf
Download Class 21 Post-Class Handout - Create a WEAP Model vFINAL.pdf bc_pr_his.csv Download bc_pr_his.csv pc_pr_his.csv Download pc_pr_his.csv
cc_pr_his.csv Download cc_pr_his.csv Video Recording: UEN Kaltura Server
Links to an external site. |
Burian |
|
|
|
|
|
Nov. 19 |
Automating WEAP and Climate Impact Analysis Pre-Class Materials: Class 22 WEAP Automation - Pre-Class handout.pdf Download Class 22 WEAP Automation - Pre-Class handout.pdf PowerPoint Slides: Class 22 WEAP Automation and Scenario Analysis.pptx Download Class 22 WEAP Automation and Scenario Analysis.pptx Class Materials: Class 22 WEAP Automation and Scenario Analysis - In-Class Exercise.docx Download Class 22 WEAP Automation and Scenario Analysis - In-Class Exercise.docx
Video Recording: UEN Kaltura Server
Links to an external site. |
Burian |
|
Nov. 21 |
Climate Impacts on Water Management Analysis PowerPoint Slides: Video Recording: |
Burian |
|
|
|
|
|
Nov. 26 |
Guest Lecture - Water and Energy Conservation through High-Efficiency Automatic Faucets PowerPoint Slides: Abdallah Guest Lecture Download Abdallah Guest Lecture Video Recording: |
Abdallah |
|
Nov. 28 |
Thanksgiving Holiday (No Class) |
|
|
|
|
|
|
Dec. 3 |
Final Project Oral Presentations Each University will do final project oral presentations in class, but offline. |
Students |
|
Dec. 5 |
Course wrap-up and review PowerPoint Slides: CourseWrapUp.pptx Download CourseWrapUp.pptx Video Recording: USU last day of class. |
Horsburgh, Ames, Burian |
|
|
|
|
|
Dec. 10 |
USU Finals Week |
|
|
Dec. 12 |
UofU last day of class. |
|
|
|
|
|
|
Dec. 17 |
UofU Finals Week, BYU finals week |
|
| Dec. 19 |
|
|