<div dir="ltr"><div><div><div><div><div><div>You are welcom<br></div>It wasn't a bug, so no ticket, so nothing to do ;-)<br></div>Cheers,<br>Rémi-C<br><br></div>~~~~~~~Français~~~~~~~~~<br></div>Pas de problème, <br></div>comme il ne s'agissait pas d'un bug, je n'ai pas créé de ticket, donc il n'y a rien à faire.<br></div>Salutations,<br>Rémi-C<br></div><div class="gmail_extra"><br><div class="gmail_quote">2015-02-03 14:53 GMT+01:00 Guillaume ARNAUD <span dir="ltr"><<a href="mailto:guillaume.arnaud@cg82.fr" target="_blank">guillaume.arnaud@cg82.fr</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Thank you for your help. The example is exactly what I need.<br>
I apologize for speaking French to other users. If I again need help
or if one day I can bring my own, I will try to do it in English.<br>
Good job for this function Remi and thank you again.<br>
How can i close this topic and note that my problem is solved?<br>
Cheers,<br>
Guillaume<br>
<br>
<div>Le 03/02/2015 13:10, Rémi Cura a
écrit :<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>
<div>
<div>
<div>/*french version at the end*/<br>
</div>
<div>Ok I think I found the problem :<br>
</div>
your geometry are not simple, that is in postgis langage,
there is no selfintersection.<br>
</div>
Your lines have tone of selfintersection , which is forbiden
(because GEOS does topological computation)!<br>
<br>
</div>
So now of to fixe this : <a href="https://github.com/Remi-C/PPPP_utilities/blob/master/postgis/rc_makesimple.sql" target="_blank">use this function</a> to transform your
non-simple (multi)line into multiline where each line inside
is simple.<br>
</div>
You code becomes :<br>
<br>
SELECT objectid, nom, code<br>
, ST_OffsetCurve(dmp.geom, 25, 'quad_segs=4 join=round') as
offseted_linestring<br>
FROM web.trs_itineraire , st_Dump(rc_MakeSimple(shape)) as dmp<br>
WHERE code = '06-20B'<br>
<div>
<div>
<div>
<div class="gmail_extra"><br>
</div>
<div class="gmail_extra">It execute successfully (now does
it do what you expect, I don't know)<br>
</div>
<div class="gmail_extra">(tested on the data you shared,
no translation, no snapping)<br>
</div>
<div class="gmail_extra">Cheers,<br>
Rémi-C<br>
<br>
</div>
<div class="gmail_extra">~~~~~~~~ French version ~~~~~~~~<br>
<br>
</div>
<div class="gmail_extra">J'ai trouvé le problème je pense.<br>
En fait les géométries ne sont pas simple au sens de
PostGIS, c'est à dire "qui ne s'autointersecte pas".<br>
</div>
<div class="gmail_extra">Cela est interdit et cause les
erreurs de GEOS (qui fait du calcul topologique).<br>
<br>
</div>
<div class="gmail_extra">Maintenant la solution pour
régler simplement le problème :<br>
</div>
<div class="gmail_extra"> utiliser<a href="https://github.com/Remi-C/PPPP_utilities/blob/master/postgis/rc_makesimple.sql" target="_blank">
cette fonction</a> pour passer de (multi)lignes avec
des autointersections à des multilignes dont chaque
lignes composante ne s'autointersecte pas.<br>
<br>
</div>
<div class="gmail_extra">Du coup, <br>
</div>
<div class="gmail_extra">votre code devient :<br>
SELECT objectid, nom, code<br>
, ST_OffsetCurve(dmp.geom, 25, 'quad_segs=4
join=round') as offseted_linestring<br>
FROM web.trs_itineraire , st_Dump(rc_MakeSimple(shape))
as dmp<br>
WHERE code = '06-20B'<br>
<br>
</div>
<div class="gmail_extra">La requete s'execute sans erreurs
(après le résultat ne sera pas nécessairement ce que
vous attendez, mais c'est une autre histoire).<br>
</div>
<div class="gmail_extra">(testé sur les données que vous
avez partagées, sans translation ni snapping).<br>
<br>
</div>
<div class="gmail_extra">Salutations,<br>
Rémi-C<br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2015-02-03 9:12 GMT+01:00
Sandro Santilli <span dir="ltr"><<a href="mailto:strk@keybit.net" target="_blank">strk@keybit.net</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><span>On Sun, Feb
01, 2015 at 08:46:16PM +0100, Rémi Cura wrote:<br>
<br>
> We are coming closer to a GEOS or PostGIS
bug.<br>
<br>
</span>Please use the bug tracker for these, thanks.<br>
<div>
<div><br>
--strk;<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
postgis-users mailing list
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></pre><span class="HOEnZb"><font color="#888888">
</font></span></blockquote><span class="HOEnZb"><font color="#888888">
<br>
<div>-- <br>
Guillaume ARNAUD<br>
Cellule SIGD<br>
Direction de l'Informatique<br>
Conseil Général de Tarn-et-Garonne<br>
<br>
<br>
</div>
</font></span></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></blockquote></div><br></div>