<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=721273704-24012006>I figured it out shortly after I sent this.
Somewhere in the statement a function was performed on an empty
geometry.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=721273704-24012006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=721273704-24012006>Randy</SPAN></FONT></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Randy
How<BR><B>Sent:</B> Monday, January 23, 2006 5:16 PM<BR><B>To:</B> 'PostGIS
Users Discussion'<BR><B>Subject:</B> [postgis-users] SQL ERROR: Relate Operation
called withLWGEOMCOLLECTION type<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=360455823-23012006><FONT face=Arial size=2>I'm encountering an
error when executing a SQL statement (against <SPAN
class=360455823-23012006><FONT face=Arial size=2>Postgres 8.1.0, PostGIS
1.1.0)</FONT></SPAN>. Unfortunately I'm not the original author of the SQL
statement. I'm also assuming that it originally worked on on version
<SPAN class=360455823-23012006><FONT face=Arial size=2>Postgres 7.4.6,
PostGIS 0.9. </FONT></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=360455823-23012006><FONT face=Arial size=2><SPAN
class=360455823-23012006><FONT face=Arial
size=2></FONT></SPAN></FONT></SPAN> </DIV>
<DIV><SPAN class=360455823-23012006><FONT face=Arial size=2><SPAN
class=360455823-23012006><FONT face=Arial size=2>Any direction why I'm
encountering this error would be greatly
appreciated,</FONT></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=360455823-23012006><FONT face=Arial size=2><SPAN
class=360455823-23012006><FONT face=Arial size=2>Thanks,
Randy</FONT></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=360455823-23012006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=360455823-23012006><FONT face=Arial size=2>Error Message -
</FONT></SPAN></DIV>
<DIV><SPAN class=360455823-23012006><FONT face=Arial size=2>Title - SQL
ERROR</FONT></SPAN></DIV>
<DIV><SPAN class=360455823-23012006><FONT face=Arial size=2>PostGISQL Error
Code: (1)</FONT></SPAN></DIV>
<DIV><SPAN class=360455823-23012006><FONT face=Arial size=2>Error: Relate
Operation called with LWGEOMCOLLECTION type. This is
unsupported.</FONT></SPAN></DIV>
<DIV><SPAN class=360455823-23012006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=360455823-23012006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=360455823-23012006></SPAN><SPAN class=360455823-23012006><FONT
color=#0000ff size=2>string</FONT><FONT size=2> sql = "select srid,
coord_sys_id, xmin(sridGeometry) as MinX, ymin(sridGeometry) as MinY, " +</DIV>
<DIV>
<P>" xmax(sridGeometry) as MaxX, ymax(sridGeometry) as MaxY " +</P>
<P>"from " +</P>
<P>"( " +</P>
<P>" select srid, coord_sys_id, box3d(transform(Map.coverage_geometry, srid)) as
sridGeometry " +</P>
<P>" from spatial_ref_sys, " +</P>
<P>" (select (setsrid(multi(difference(geometry('SRID=4326;MULTIPOLYGON(((-180
-90,-180 90,180 90,180 -90, -180 -90)))'), " +</P>
<P>" constraint_geometry)), 4326)) as coverage_geometry " +</P>
<P>" from map " +</P>
<P>" where map_id=" + mapId.ToString() + ") as Map " +</P>
<P>" where " +</P>
<P>" is_available = true and " +</P>
<P>" coord_sys_id < 3 and " +</P>
<P>" intersects(cov_geometry, Map.coverage_geometry) = true " +</P>
<P>") " +</P>
<P>"as resultTable " +</P>
<P>"order by coord_sys_id, srid ";</P></FONT></SPAN></DIV>
<DIV> </DIV>
<DIV align=left>
<DIV align=left>
<MARQUEE id=Marquee1 style="WIDTH: 240px; HEIGHT: 40px" trueSpeed scrollAmount=1
scrollDelay=14 direction=down behavior=slide loop=1 border="2">
<DIV><!--****** SEPARATION LINE****--><FONT
size=1>________________________________________________</FONT> <BR><!--****** NAME ****--><B><FONT
face="Verdana, Arial, Helvetica, sans-serif" color=black size=2><!--****** Change your name here ****-->Randy
How</FONT></B> </DIV></MARQUEE></DIV><BR><!--****** JOB TITLE ****-->
<MARQUEE id=Marquee2 style="WIDTH: 240px; HEIGHT: 17px" trueSpeed scrollAmount=1
scrollDelay=3 direction=down behavior=slide loop=1 border="0"><B><FONT
face=Arial color=black size=1>Geospatial Applications
Developer</FONT></B></MARQUEE><BR><!--****** MAIL ****-->
<MARQUEE id=Marquee3 style="FONT-SIZE: 10pt; WIDTH: 240px; HEIGHT: 17px"
trueSpeed scrollAmount=4 scrollDelay=5 direction=up behavior=slide loop=1
border="0"><FONT face=Verdana color=black size=1><!--****** Change your mail here ****--><A class=type1
href="mailto:rhow@i3.com">rhow@i3.com </A></FONT></MARQUEE><BR><!--****** TEL & MOBILE ****--><FONT
face="Verdana, Arial, Helvetica, sans-serif">
<MARQUEE id=Marquee3 style="FONT-SIZE: 10pt; WIDTH: 240px; HEIGHT: 17px"
trueSpeed scrollAmount=1 scrollDelay=3 direction=right behavior=slide loop=1
border="0"><FONT color=black
size=1><!--****** Change your Tel here ****-->Voice:
+1-970-482-4400</FONT></MARQUEE><BR>
<MARQUEE id=Marquee3 style="FONT-SIZE: 10pt; WIDTH: 240px; HEIGHT: 17px"
trueSpeed scrollAmount=1 scrollDelay=3 direction=right behavior=slide loop=1
border="0"><FONT color=black size=1><!--****** Change your Fax here ****-->Fax:
+1-970-482-4499</FONT></MARQUEE><BR>
<MARQUEE id=Marquee3 style="FONT-SIZE: 10pt; WIDTH: 240px; HEIGHT: 21px"
trueSpeed scrollAmount=1 scrollDelay=3 direction=right behavior=slide loop=1
border="0"><FONT color=black
size=1><!--****** Change your website here ****-->Web: <A
href="http://www.i3.com/">www.i3.com </A></FONT></MARQUEE><BR></FONT><!--****** ADDRESS ****-->
<MARQUEE id=Marquee4 style="FONT-SIZE: 10pt; WIDTH: 240px; HEIGHT: 100px"
trueSpeed scrollAmount=1 scrollDelay=8 direction=up behavior=slide loop=1
border="0">
<TABLE cellSpacing=0 cellPadding=0 width=250 bgColor=#ffffff>
<TBODY>
<TR bgColor=#00008b>
<TD vAlign=right noWrap align=right bgColor=#00008b size="2"><FONT
face="Verdana, Arial, Helvetica, sans-serif" color=#ffffff
size=2><B>i-cubed </B></FONT> </TD></TR>
<TR bgColor=#00008b>
<TD vAlign=right noWrap align=right bgColor=#00008b size="2"><FONT
face="Verdana, Arial, Helvetica, sans-serif" color=#ffffff size=2>201
Linden, Third Floor </FONT> </TD></TR>
<TR bgColor=#00008b>
<TD vAlign=right noWrap align=right bgColor=#00008b size="2"><FONT
face="Verdana, Arial, Helvetica, sans-serif" color=#ffffff size=2>Fort
Collins, CO 80524 </FONT> </TD></TR></TBODY></TABLE></MARQUEE></DIV>
<DIV> </DIV></BODY></HTML>