Chapter 8. Techniques to solve spatial problems


This chapter covers
  • 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 ...

Get PostGIS in Action now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.