Introduction to PostGIS

Getting Started

• This workshop uses a data bundle. Download it and extract to a convenient location.

Workshop Materials

Inside the data bundle, you will find:

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

• 1. Welcome
• 2. Introduction
• 3. Installation
• 4. Creating a Spatial Database
• 5. Loading spatial data
• 6. About our data
• 7. Simple SQL
• 8. Simple SQL Exercises
• 9. Geometries
• 10. Geometry Exercises
• 11. Spatial Relationships
• 12. Spatial Relationships Exercises
• 13. Spatial Joins
• 14. Spatial Joins Exercises
• 15. Spatial Indexing
• 16. Projecting Data
• 17. Projection Exercises
• 18. Geography
• 19. Geometry Constructing Functions
• 20. More Spatial Joins
• 21. Validity
• 22. Equality
• 23. Linear Referencing
• 24. Dimensionally Extended 9-Intersection Model
• 25. Clustering on Indices
• 26. Nearest-Neighbour Searching
• 27. Tracking Edit History using Triggers
• 28. Advanced Geometry Constructions
• 29. Tuning PostgreSQL for Spatial
• 30. PostgreSQL Security
• 31. PostgreSQL Schemas
• 32. PostgreSQL Backup and Restore
• 33. Software Upgrades
• 34. Appendix A: PostGIS Functions
• 35. Appendix B: Glossary
• 36. Appendix C: License

Links to have on hand

• PostGIS - http://postgis.net/

  • Docs - http://postgis.net/docs/

• PostgreSQL - http://www.postgresql.org/

  • Docs - http://www.postgresql.org/docs/

  • Downloads - http://www.postgresql.org/download/

  • JDBC Driver - http://jdbc.postgresql.org/

  • .Net Driver - http://npgsql.projects.postgresql.org/

  • Python Driver - http://www.pygresql.org/

  • C/C++ Driver - http://www.postgresql.org/docs/current/static/libpq.html

• PgAdmin III - http://www.pgadmin.org/

• Open Source Desktop Clients

  • QGIS - http://qgis.org/

  • OpenJUMP - http://openjump.org/

  • uDig - http://udig.github.io/