Skip to main content
1 of 2
Jay Laura
  • 4.5k
  • 1
  • 23
  • 43

ST_RELATE - Intersect ignore shared boundary

Using postgis I am trying to find polygons that intersect, ignoring polygons that only have a shared boundary (edge).

  1. ST_Relate(g1, g2, 'T********') is a standard intersection.
  2. ST_Relate(g1, g2, 'TF*F*****') standard intersection with boundary touching false

An image of what I am trying to achieve (from: http://daniel-azuma.com/articles/georails/part-6):

enter image description here

I am confident in the underlying geometries as they are created inside of postgis by taking the overlay similar to here.

Similar to: postgis st_relate polygon inside another and sharing a boundary though I want to ignore cases where the only topological connection is the boundary.

Jay Laura
  • 4.5k
  • 1
  • 23
  • 43