O'Reilly logo

PostGIS in Action by Leo Hsu, Regina Obe

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required