Chapter 8. Techniques to solve spatial problems
- Using joins with spatial functions
- SQL aggregates and spatial aggregates
- Proximity analysis
- Common geometric processing
In prior chapters we looked at spatial functions separately and didn’t focus too much on how these functions could be combined to solve real-world problems. In this chapter we’ll combine several spatial and PostgreSQL functions and SQL join constructs to accomplish real-world objectives. No single chapter, let alone an entire book, can catalog all the different spatial challenges faced by the GIS analyst. Instead, we want you to focus on the techniques. The same technique can usually solve a whole range of problems.
We’ll tackle this chapter using ...