Advertisement
Guest User

Untitled

a guest
Apr 18th, 2015
228
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. SELECT DISTINCT a.geom
  2. FROM polygon_table a, polygon_table t1, polygon_table t2, polygon_table t3
  3. WHERE a.id <> t1.id
  4. AND a.id <> t2.id
  5. AND a.id <> t3.id
  6. AND t1.id <> t2.id
  7. AND t1.id <> t3.id
  8. AND t2.id <> t3.id
  9. AND ST_TOUCHES(a.geom, t1.geom) = 't'
  10. AND ST_TOUCHES(a.geom, t2.geom) = 't'
  11. AND ST_TOUCHES(a.geom, t3.geom) = 't'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement