<div><span style>Hi,</span></div><span style>Robustness issues?</span><br style><span style>You can try reducing the precision of your input (ST_SnapToGrid)</span><div><font color="#222222" face="arial, sans-serif"><br></font></div>
<div><font color="#222222" face="arial, sans-serif">Fred</font></div><div><font color="#222222" face="arial, sans-serif"><br></font><div><br></div><div><br><br><div class="gmail_quote">On Wed, Jun 20, 2012 at 12:54 PM, Denis Rouzaud <span dir="ltr"><<a href="mailto:denis.rouzaud@gmail.com" target="_blank">denis.rouzaud@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi all,<br>
<br>
I have a table of line and a table of polygons. For a given line, I would like to get the polygon which has the biggest intersection with the line.<br>
I tried something like this:<br>
<br>
CREATE OR REPLACE FUNCTION distribution.get_zone_id(<u></u>geometry) RETURNS integer AS '<br>
DECLARE<br>
inputgeom ALIAS FOR $1;<br>
id_poly integer;<br>
BEGIN<br>
SELECT id INTO id_poly<br>
FROM polygons<br>
WHERE ST_Intersects(inputgeom,<u></u>geometry) IS TRUE<br>
ORDER BY ST_Length(ST_Intersection(<u></u>inputgeom,geometry)) DESC<br>
LIMIT 1;<br>
RETURN id_poly;<br>
END<br>
' LANGUAGE 'plpgsql';<br>
<br>
But I have the following error:<br>
ERROR: Error performing intersection: TopologyException: side location conflict at 553524.92178241001 147945.03792368001<br>
<br>
If anyone has any idea, tip or whatever, it is very welcome!<br>
<br>
Greetings,<br>
<br>
Denis<br>
______________________________<u></u>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.<u></u>refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.<u></u>net/mailman/listinfo/postgis-<u></u>users</a><br>
</blockquote></div><br></div></div>