PostGIS in Action (3rd)
Where the adventure begins

PostGIS in Action: (ed. #3) Chapter 9 - Proximity analysis

PostGIS In Action 3rd Edition Chapters    PostGIS In Action 2nd Edition Chapters    1st Edition Chapters
Download chapter code and data

  • Choice between geography and geometry
  • Nearest Neighbor
  • KNN Distance operators
  • Geotagging

When it comes to GIS, the first thing that comes to mind is where something is located. Once you can locate places using a set of coordinates, questions such as the following arise, which always involve some kind of distance calculation: How far is my house from the nearest expressway? How many pizza joints are within a mile drive? What’s the average distance that people have to commute to work? What are the 10 closest parks to me? How many people live in my city and make more than me?

In this chapter we’ll cover the key functions and operators PostGIS provides for doing proximity analysis. These functions are the foundation of most location based queries. We’ll also cover the various options limitations based on which spatial type you choose wheter it be geometry or geography.

Save 40% off on Third Edition of PostGIS In Action and other Manning published books Offer ends August 19th, 2022
PostGIS in Action,3rd edition pgRouting: a Practical Guide SQL In a Nutshell, 4th Edition