In the following list “PiA” refers to the textbook, PostGIS in Action, 2e. “Boundless” refers to the Introduction to PostGIS Workshop.

Week 1 (Jan 12) – Introduction

• Reading: PiA 1, 4, 5; Note, these do not have to be read straight through, but you should be familiar with the content, as you will refer back to it later in the course when you need to import or export data, or configure connections from desktop GIS applications
• Exercise 1: Entity-Relationship Diagrams
  • Due Date: Wed, Jan 20

Week 2 (Jan 19) – Basic SQL

• Reading: PiA Appendix C
• Exercise 2: SQL Querying
  • Due Date: Wed, Jan 27

Week 3 (Jan 26) – SQL (Continued), Keys

• Exercise 3: SQL Joins
  • Due Date: Feb 3

Week 4 (Feb 2) – Normalization

• Reading: http://www.1keydata.com/database-normalization/ – Follow links to 1st, 2nd, and 3rd Normal Form
• Exercise 4: Normalization and Keys
  • Due Date: Feb 10

Week 5 (Feb 9) – Spatial Data Types

• Reading: PiA 2
• Exercise 5: Boundless 1-10
  • Due Date: Feb 17

Week 6 (Feb 16) – Spatial Relationships

• Reading: PiA 9.1-9.2
• Exercise 6: Boundless 11-14
  • Due Date: Feb 24

Week 7 (Feb 23) – Spatial Reference Systems

• Reading: PiA 3
• Exercise 7: Boundless 16-18

TEMPLE SPRING BREAK – NO CLASS (Mar 1)

Week 8 (Mar 8) – More Spatial Relationships

• Reading: PiA 9.3-9.4, 10
• Exercise 8: Boundless 19-22, 24

Week 9 (Mar 15) – Proximity Analysis

• Reading: PiA 10
• Exercise 9: Boundless 27

Week 10 (Mar 22) – Indexing and Query Optimizations

• Reading: PiA 14-15
• Exercise 10: 15, 25

Week 11 (Mar 29) – NO CLASS (Indexing and Query Optimizations, cont.)

The professor will be attending the American Association of Geographers Conference

• Exercise: Continued from previous week

Week 12 (Apr 5) – Advanced Design Considerations

• Versioning, Spatiotemporal Data, Hierarchical Data, Key-Value Stores
• Boundless 28
• QGIS Time Manager
• GeoGig?

Week 13 (Apr 12) – PostGIS Procedural Languages or TBD

• Reading: PiA 16
• Exercise: TBD

Week 14 (Apr 19) – TBD