PostGIS in Action (3rd)
Where the adventure begins

PostGIS in Action: (ed. #1) Chapter 5 - Relationships between geometries

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

The breathe of spatial functions that PostGIS provides is too large to be covered completely in any book. We invite you to explore the rich PostGIS manual to learn about all the functions. In this chapter we cover the main relationship and relationship output functions you will commonly find in PostGIS. Many of these functions you will also find in other spatial databases such as Oracle Spatial/Locator, SQL Server 2008, IBM DB2 Spatial Datablade, and SQLite SpatiaLite.

We describe the fundamental OGC spatial concepts that many of these functions are founded on. Some of the functions such as ST_DWithin are particular to PostGIS, but have parallels in Oracle Locator/Spatial SDO.Within_Distance, SQL Server 2008 , and IBM DB2.

We describe DE9IM intersection matrix model that many spatial relationships are founded and are fairly standard across all spatial databases. We demonstrate an example that exercises the confusing corner cases of this model. In the hopefully entertaining example of The house with a courtyard, a walkway, the front door and courtyard greeters we explore how we can determine the orientation of these objects relative to each other by using these functions.

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