<br><br><div class="gmail_quote">On Thu, Oct 13, 2011 at 12:18 AM, Florian Hackenberger <span dir="ltr"><<a href="mailto:f.hackenberger@chello.at">f.hackenberger@chello.at</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im">On Wednesday 12 October 2011, Daniel Kastl wrote:<br>
> Thank you for you offer to look into the problem.<br>
> On GIS StackExchange someone mentions wrong order due to a JOIN. I<br>
> haven't seen this post before.<br>
<br>
</div>That was me :-). It's definitely not the issue with the flipped edges (I<br>
read about that), but an unrelated problem.<br>
<br>
Can you reproduce it?<br></blockquote><div><br></div><div>Hi Florian,</div><div><br></div><div>Sorry, I don't have much time right now to try to reproduce it.</div><div>But I think I remember now there is an attribute returned by at least some wrapper functions that adds another ID column with the order of the edges. So you could sort by this attribute afterwards.</div>
<div><br></div><div>I think the "Shooting Star Smart" wrapper function has this "id", see:</div><div><a href="https://github.com/pgRouting/pgrouting-contrib/blob/master/wrapper/routing_core_smart.sql#L465">https://github.com/pgRouting/pgrouting-contrib/blob/master/wrapper/routing_core_smart.sql#L465</a></div>
<div>... and then ORDER BY id:</div><div><a href="https://github.com/pgRouting/pgrouting-contrib/blob/master/wrapper/routing_core_smart.sql#L766">https://github.com/pgRouting/pgrouting-contrib/blob/master/wrapper/routing_core_smart.sql#L766</a></div>
<div><br></div><div>If you can read the pl/pgsql functions you should be able to see if the function you use contain this id attribute as well.</div><div><br></div><div>Daniel</div><div><br></div><div><br></div><div> </div>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div><div></div><div class="h5"><br>
Yours, Florian<br>
<br>
--<br>
DI Florian Hackenberger<br>
<a href="mailto:florian@hackenberger.at">florian@hackenberger.at</a><br>
<a href="http://www.hackenberger.at" target="_blank">www.hackenberger.at</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><span style="font-family:arial, sans-serif;font-size:13px;border-collapse:collapse">Georepublic UG & Georepublic Japan<br>eMail: <a href="mailto:daniel.kastl@georepublic.de" style="color:rgb(66, 99, 171)" target="_blank">daniel.kastl@georepublic.de</a><br>
Web: <a href="http://georepublic.de/" style="color:rgb(66, 99, 171)" target="_blank">http://georepublic.de</a></span><br>