<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>RE: [postgis-users] good way to collect</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>> > psql:q.sql:7: NOTICE: TopologyException: side location conflict</FONT>
<BR><FONT SIZE=2>> > (-80.8945,32.0422)</FONT>
<BR><FONT SIZE=2>> > psql:q.sql:7: ERROR: GEOS contains() threw an error!</FONT>
</P>
<P><FONT SIZE=2>Thought I'd share w/ the group a solution. Turns out that doing a collect() on some geoms produces an invalid geom.. So when I was going a contains() on a bad geom row, it would throw the above error.</FONT></P>
<P><FONT SIZE=2>Doing a GeomUnion() instead of contains() in step #1 made everything golden.</FONT>
</P>
<P><FONT SIZE=2>Charlton</FONT>
</P>
</BODY>
</HTML>