PostGIS in Action (3rd)
Where the adventure begins

PostGIS in Action: (ed. #1) Chapter 8 - Techniques to solve spatial problems

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

  • Using joins with spatial
  • SQL Aggregates and spatial aggregate
  • Proximity analysis
  • Common geometric processing

In this chapter we mix spatial functions with SQL with wild abandon. You'll see powerful one-liners to blow your mind. You'll see window function tricks, common table expressions, recursive table expressions, and also the basics of proximity queries. You'll learn how to mold space with SQL to accomplish common world needs that you may have thought were only possible with a desktop GIS tool.

Save 50% off on Third Edition of PostGIS In Action enter mlobe3 in the Promotional Code box when you check out. Offer ends November 25th, 2021

pgRouting: A Practical Guide is now available in Hardcopy from Hardcopy from Amazon. E-Book or Bulk discounts on Hard-copy from Locate Press.

PostGIS in Action,3rd edition MEAP    PostgreSQL: Up and Running       D3.js in Action 2nd Edition   PostGIS Cookbook 2nd edition