[postgis-users] Separate polygons based on intersection
atogle at gmail.com
Thu Jul 22 14:53:29 PDT 2010
I have a table of polygons where some intersect with one another. This is
what I'm trying to do:
* For a given polygon selected by id, give me all of the polygons that
intersect. Basically, select the_geom from the_table where
ST_Intersects(the_geom, (select the_geom from the_table where source_id =
* From these polygons, I need to create a new polygons such that
intersection becomes a new polygon. So if polygon A intersects with polygon
B, I will get 3 new polygons: A minus AB, AB, and B minus AB.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users