<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Salas,<br>
<br>
did you check if your geometries are all valid (with function
st_isvalid(geometry))?<br>
<br>
Regards,<br>
<br>
Birgit.<br>
<br>
<br>
On 24.09.2010 16:33, salas wrote:
<blockquote cite="mid:002c01cb5bf5$b69abb20$ee0110b6@software01"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta content="MSHTML 6.00.5730.13" name="GENERATOR">
<style></style>
<div><font face="Arial" size="2">Hi,</font></div>
<div> </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> </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>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
</body>
</html>