[postgis-users] st_intersection polygons only

Willy-Bas Loos willybas at gmail.com
Thu Feb 27 08:01:29 PST 2014


Hi,

When overlaying 2 tables that have polygons with st_intersection, i
sometimes get linestrings or points back, or a geometrycollection with a
combination of types.
What i actually want, is that i only get the overlapping parts (that is,
overlapping interiors in DE9IM speak) in the geometrytype of the combined
geometries.
Mostly multipolygon will do fine, so that would make that function a lot
simpler.

Now i could make a function that does that, filtering results by their
geometrytype.
I just wanted to check if something similar already exists?

Cheers,

WBL

-- 
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140227/1dd48fa7/attachment.html>


More information about the postgis-users mailing list