<table cellspacing="0" cellpadding="0" border="0"><tr><td valign="top" style="font: inherit;"><p>Well, omitting hundreds or thousands from the source of over 11 million isn't something i can do. The procedure should run in batch, otherwise i would use Qgis which does the same job in an hour.</p>
<p>So, i am still looking for a sql solution.......<br><br><br></p>
<p>Sent from Yahoo! Mail on Android</p>
</td></tr></table> <div id="_origMsg_">
<div style="font-family:arial, helvetica, sans-serif:font-size:10pt">
<br />
<div style="font-family:times new roman, new york, times, serif;font-size:12pt">
<font size="2" face="Tahoma">
<hr size="1">
<b>
<span style="font-weight:bold;">From:</span>
</b>
Sandro Santilli <strk@keybit.net>; <br>
<b>
<span style="font-weight:bold:">To:</span>
</b>
G. van Es <gves2000@yahoo.com>; PostGIS Users Discussion <postgis-users@postgis.refractions.net>; <br>
<b>
<span style="font-weight:bold:">Subject:</span>
</b>
Re: [postgis-users] ST_Insersection problem <br>
<b>
<span style="font-weight:bold;">Sent:</span>
</b>
Wed, Sep 21, 2011 2:38:19 PM <br>
</font>
<br>
<table cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td valign="top" style="font:inherit;">On Wed, Sep 21, 2011 at 06:38:02AM -0700, G. van Es wrote:<BR>> Sandro, thanks for your reply. You're right about "folding postgis 7 times" :-)<BR>> <BR>> I'm having difficulties in isolating the offending geometries, which is mainly due to my lack of knowledge.<BR>> <BR>> When I look at the location at 59647.5 392932 there is no intersection. Only when I use buffer(geom,1) there are two objects, one of them being a funny line of three points but still identified by PG as polygon. <BR><BR>Does sound like a culprit. Must be the 7th folding of a polygon :)<BR>Try omitting it from the input set.<BR><BR>--strk;<BR><BR> () Free GIS & Flash consultant/developer<BR> /\ <a href="http://strk.keybit.net/services.html" target=_blank >http://strk.keybit.net/services.html</a><BR></td>
</tr>
</tbody>
</table>
</div>
</div>
</div>