<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.5730.13" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have a table 'municipio' with a geometric column
(the_geom). I want to get a view with the resultant of the interception between
the the_geom column and a polygon.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The query: <BR>----------<BR>SELECT
ST_Dump(ST_Intersection(the_geom, GeomFromText('MULTIPOLYGON(((177056.442675
283157.030268, 283157.030268 192559.320783, 192559.320783 293446.551137,
177056.442675 293446.551137, 177056.442675 283157.030268)))',2085)))<BR>FROM
municipio<BR>WHERE the_geom IS NOT NULL <BR> AND ST_Intersects(the_geom,
GeomFromText('MULTIPOLYGON(((177056.442675 283157.030268, 283157.030268
192559.320783, 192559.320783 293446.551137, 177056.442675 293446.551137,
177056.442675 283157.030268)))',2085)) = TRUE</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>return an error:<BR>----------------</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>NOTICE: TopologyException: found non-noded
intersection between 178970 311240, 178977 311221 and 178976 311224, 178971
311238 178972 311234</FONT></DIV>
<DIV> </DIV><FONT face=Arial size=2>
<DIV><BR>ERROR: GEOS Intersection() threw an error!</DIV>
<DIV> </DIV>
<DIV>********** Error **********</DIV>
<DIV> </DIV>
<DIV>ERROR: GEOS Intersection() threw an error!<BR>SQL state: XX000</DIV>
<DIV> </DIV>
<DIV><BR>What's the problem ????<BR>The WHERE statemente ((the_geom,
GeomFromText( ...) ) ensure the intersection</DIV>
<DIV> </DIV>
<DIV>Best regards, Salas</DIV></FONT></BODY></HTML>