rom foo
>> WHERE st_geometrytype(geom) LIKE 'ST_Polygon'
>> GROUP BY a.gid, b.gid
>>
>> HTH
>>
>> Hugues
>>
>> De : postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-bounces@
>> lists.osgeo.org] De la part de Willy-Bas Loos
>>
(geom) LIKE 'ST_Polygon'
GROUP BY a.gid, b.gid
HTH
Hugues
De : postgis-users-boun...@lists.osgeo.org [mailto:
postgis-users-boun...@lists.osgeo.org] De la part de Willy-Bas Loos
Envoyé : jeudi 27 février 2014 20:01
À : PostGIS Users Discussion
Objet : Re: [postgis-users] st_intersection
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
so this kinda works, but:
* it now returns NULL as a geometry where it should return no record at all
* it is about a factor 20 (!) slower than st_intersection
Besides that it can only be used for multipolygons.
And i would need a better name for it :)
Here's the code, i would really appreciate
It's not so slow, my coleage changed the testdata.
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Users Discussion
Objet : Re: [postgis-users] st_intersection polygons only
so this kinda works, but:
* it now returns NULL as a geometry where it should return no record at all
* it is about a factor 20 (!) slower than st_intersection
Besides that it can only be used for multipolygons.
And i would