[postgis-users] SQL ERROR: Relate Operation called with LWGEOMCOLLECTION type

[Randy How]

I'm encountering an error when executing a SQL statement (against Postgres
8.1.0, PostGIS 1.1.0).  Unfortunately I'm not the original author of the SQL
statement.  I'm also assuming that it originally worked on on version
Postgres  7.4.6, PostGIS 0.9.  
 
Any direction why I'm encountering this error would be greatly appreciated,
Thanks, Randy
 
Error Message - 
Title - SQL ERROR
PostGISQL Error Code: (1)
Error: Relate Operation called with LWGEOMCOLLECTION type. This is
unsupported.
 
 
string sql = "select srid, coord_sys_id, xmin(sridGeometry) as MinX,
ymin(sridGeometry) as MinY, " +

" xmax(sridGeometry) as MaxX, ymax(sridGeometry) as MaxY " +

"from " +

"( " +

" select srid, coord_sys_id, box3d(transform(Map.coverage_geometry, srid))
as sridGeometry " +

" from spatial_ref_sys, " +

" (select (setsrid(multi(difference(geometry('SRID=4326;MULTIPOLYGON(((-180
-90,-180 90,180 90,180 -90, -180 -90)))'), " +

" constraint_geometry)), 4326)) as coverage_geometry " +

" from map " +

" where map_id=" + mapId.ToString() + ") as Map " +

" where " +

" is_available = true and " +

" coord_sys_id < 3 and " +

" intersects(cov_geometry, Map.coverage_geometry) = true " +

") " +

"as resultTable " +

"order by coord_sys_id, srid ";

 
________________________________________________ 
Randy How 

Geospatial Applications Developer
rhow at i3.com  <mailto:rhow at i3.com> 
Voice: +1-970-482-4400
Fax: +1-970-482-4499
Web: www.i3.com  <http://www.i3.com/> 

i-cubed    	
201 Linden, Third Floor    	
Fort Collins, CO 80524    	
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060123/c18ee6c2/attachment.html>