PostGIS is an open source spatial database extender for PostgreSQL. It equals or surpasses proprietary alternatives, allowing you to create location-aware queries with just a few lines of SQL code, and provides a back-end for mapping applications with minimal effort.
PostGIS in Action teaches readers of all levels to write spatial queries that solve real-world problems. It first gives you a background in vector-based GIS and then quickly moves into analyzing, viewing, and mapping data. You'll learn how to optimize queries for maximum speed, simplify geometries for greater efficiency, and create custom functions for your own applications. The book covers PostgreSQL 8.4, 9.0, and 9.1 features and shows you how to integrate with other GIS tools.
Part 1 Learning PostGIS
1 What is a spatial database?
2 Geometry types
3 Organizing spatial data
4 Geometry functions
5 Relationships between geometries
6 Spatial reference system considerations
7 Working with real data
Part 2 Putting PostGIS to work
8 Techniques to solve spatial problems
9 Performance tuning
Part 3 Using PostGIS with other tools
10 Enhancing SQL with add-ons
11 Using PostGIS in web applications
12 Using PostGIS in a desktop environment
appendix A Additional resources
appendix B Installing, compiling, and upgrading
appendix C SQL primer
appendix D PostgreSQL features