翻译完DDIA再来看看有没有空搞这个吧。
- 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