Getting Started¶

• This workshop uses a software/data bundle
• Download the bundle and unzip it in a convenient location.

Workshop Materials¶

Inside the workshop bundle, you will find:

workshop/

a directory containing this HTML workshop

software/

a directory containing all the software we will be installing and a couple extras

data/

a directory containing the shapefiles we will be loading

All the data in the package is public domain and freely redistributable. All the software in the package is open source, and freely redistributable. This workshop is licensed as Creative Commons “share alike with attribution“, and is freely redistributable under the terms of that license.

Workshop Modules¶

• Welcome
• Section 1: Introduction
• Section 2: Installation
• Section 3: Creating a Spatial Database
• Section 4: Loading spatial data
• Section 5: About our data
• Section 6: Simple SQL
• Section 7: Simple SQL Exercises
• Section 8: Geometries
• Section 9: Geometry Exercises
• Section 10: Spatial Relationships
• Section 11: Spatial Relationships Exercises
• Section 12: Spatial Joins
• Section 13: Spatial Joins Exercises
• Section 14: Spatial Indexing
• Section 15: Projecting Data
• Section 16: Projection Exercises
• Section 17: Geography
• Section 18: Geometry Constructing Functions
• Section 19: More Spatial Joins
• Section 20: Validity
• Section 21: Tuning PostgreSQL for Spatial
• Section 22: Equality
• Appendix A: PostGIS Functions
• Appendix B: Glossary
• Appendix C: License