Advertisement
Guest User

Untitled

a guest
Dec 19th, 2014
167
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. SELECT ST_Difference(
  2. A.the_geom,
  3. B.the_geom
  4. )
  5. From A, B
  6.  
  7. SELECT A.id,
  8. ST_Union(
  9. COALESCE(
  10. ST_Difference(
  11. A.the_geom,
  12. B.the_geom
  13. ),
  14. A.the_geom
  15. )
  16. ) As the_geom
  17. FROM A
  18. LEFT JOIN b ON ST_Intersects(A.the_geom, B.the_geom)
  19. GROUP BY A.id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement