[postgis-users] GeometryCollection Intersection

[Markus Schneider]

Hello,

is it correct that geometric operations (especially intersection) are not
available if one of the geometries is a GeometryCollection?

My postgis_full_version() is:

"POSTGIS="1.3.1" GEOS="2.2.3-CAPI-1.1.1" PROJ="Rel. 4.4.9, 29 Oct 2004" USE_STATS"

When I try to execute the following statement:

SELECT X1.GEOM,X1.NAME,X1.ID FROM MULTITEST X1
WHERE X1.GEOM && SetSRID('BOX3D(174259.098 487844.529, 177282.329
484821.298)'::box3d,28992)
AND intersects (X1.GEOM, SetSRID('BOX3D(174259.098 487844.529, 177282.329
484821.298)'::box3d,28992))

I get the error message:

ERROR: Relate Operation called with a LWGEOMCOLLECTION type.  This is unsupported
SQL Status:XX000

I already digged the source code a bit and found the apparent source of the
message in lwgeom_geos_c.c. It's the check errorIfGeometryCollection(...).

Is there any chance to perform an intersection between a Box and a
GeometryCollection anyway? Or are there plans to implement this?

Thanks in advance,
-- 
Markus Schneider

l a t / l o n  GmbH
Aennchenstrasse 19               53177 Bonn, Germany
phone ++49 +228 18496-0          fax ++49 +228 18496-29
http://www.lat-lon.de            http://www.deegree.org

-------------------------------------------------------
On June 17 is deegree day - Am 17. Juni ist deegree day
              http://deegree.org/deegreeday