Introduction to PostGIS

• 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. 3-D

• 27. Nearest-Neighbour Searching

• 28. Tracking Edit History using Triggers

• 29. Advanced Geometry Constructions

• 30. Tuning PostgreSQL for Spatial

• 31. PostgreSQL Security

• 32. PostgreSQL Schemas

• 33. PostgreSQL Backup and Restore

• 34. Software Upgrades

• 35. Appendix A: PostGIS Functions

• 36. Appendix B: Glossary

• 37. Appendix C: License