Schedule

In the schedule, ”Action” refers to our primary textbook, PostGIS in Action. Other readings are stored on the library’s E-reserve page.

Readings should be completed before the class for which they are assigned. Exercises are due at the beginning of the following class.

The schedule is subject to revision throughout the semester

Week 1 (Jan 31) – Introduction
Topics: Course overview, technology setup, interfaces, database test drive
Readings: Database Management System article (Duckham)
Exercise 1: Database installation
Week 1 Slides

Week 2 (Feb 7) – SQL DML
Topics: Database fundamentals, data manipulation language, aggregates, joins
Readings: Relational Database Principles Chap 2 (Matthew), SQL Data Manipulation Chap 5 (Connolly)
Exercise 2: Intro to SQL Part 1
Week 2 Slides

Week 3 (Feb 14) – SQL DDL
Topics: Database fundamentals, data definition language, data types, constraints
Readings: SQL Data Definition Chap 6 (Connolly): sections 6.1 to 6.4 only
Exercise 3: Intro to SQL Part 2
Week 3 Slides

Week 4 (Feb 21) – Database design
Topics: Entity relationships, normalization, keys, modeling
Readings: Database Design Chap 12 (Matthew), Database Design Chap 6 (Kreibich), Entity Relationship Model article (Song)
Exercise 4: Modeling and normalization
Week 4 Slides

Week 5 (Feb 28) – Data processing
Topics: Data formats, processing, loading (ETL)
Exercise 5: Data cleaning & SQL review
Week 5 Slides
GROUP BY Review Slides

Week 6 (Mar 7) – Spatial databases
Topics: Spatial data fundamentals, spatial data types
Readings: Action preface, Chap 1, 2, & 5
Exercise 6: Spatial data basics.
Week 6 Slides

SNOW – Class canceled on Mar 14

Week 7 (Mar 21) – Spatial reference systems
Topics: General overview, loading spatial data, coordinate transformation
Readings: Action Chap 3, 4, & 6
Exercise 7: Coordinate systems
Week 7 Slides

Week 8 (Mar 28) – Spatial relationships & analysis
MIDTERM QUIZ: At beginning of class
Topics: Geographic relationships, indexes, spatial indexes
Readings: Action Chap 9 & 11
Exercise 8: Spatial analysis
Week 8 Slides

Week 9 (Apr 4) – Organizing spatial data
FINAL PROJECT: Assigned
Topics: Spatial data design
Readings: Action Chap 14
Exercise 9: Spatial data design (Due on Thu Apr 20)
Week 9 Slides

SPRING BREAK – No class on Apr 11 and Apr 18

Week 10 (Apr 25) – Proximity analysis
Topics: Buffers, nearest neighbor, coordinate system considerations
Readings: Action Chap 10
Exercise 10: Proximity analysis
Week 10 Slides

Week 11 (May 2) – Database management, SQL DCL
Topics: Users and permissions, data control language, multi-editing, archiving
Readings: SQL Data Definition Chap 6 (Connolly): sections 6.5 to 6.6 only
Exercise 11: DB Management
Week 11 Slides

Week 12 (May 9) – Rasters / Other database formats
Topics: Rasters, SQLite / Spatialite, ArcGIS formats
Readings: Action Chap 7
Week 12 Slides

Week 13 (May 16) – Presentations / Final project prep
FINAL PROJECT: Presentations

Week 14 (May 23) – Database programming / Final project prep
ATTENDANCE IS OPTIONAL
Topics: Python for databases, final project help

(Friday May 26) – Final project submission
FINAL PROJECT: Due by 12 noon