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

[Randy How]

I figured it out shortly after I sent this.  Somewhere in the statement a
function was performed on an empty geometry.
 
Randy

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Randy
How
Sent: Monday, January 23, 2006 5:16 PM
To: 'PostGIS Users Discussion'
Subject: [postgis-users] SQL ERROR: Relate Operation called
withLWGEOMCOLLECTION type


 
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/7d489752/attachment.html>