<div dir="ltr">Hi Eyad,<div><br></div><div>It's difficult to give an answer based on your query and problem description only. I guess, that (still) your network topology is not correct. It looks like a data problem.</div><div><br></div><div>There are 2 things you could do for now:</div><div>(1) Show us some image of your "weird de-attached “little” pieces"</div><div>(2) Try a simple shortest path query with one start and one end point and see if it works with pgr_dijkstra function for example.</div><div><br></div><div>Daniel</div><div><br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Dec 18, 2014 at 7:37 AM, AUS - Eyad <span dir="ltr"><<a href="mailto:b00038807@aus.edu" target="_blank">b00038807@aus.edu</a>></span> wrote:<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal">Hello pgr_Experts,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I’m trying to get all the routes from a source point (i.e.
336) to a group of target/destination points (located at different edges/ends
of linestrings’ network) using the below code:<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">SELECT seq, id1 as path, id2 as node, id3 as edge, (b.geom)
as geom, cost FROM pgr_kdijkstraPath(<u></u><u></u></p>
<p class="MsoNormal"> 'SELECT id, source, target,
(st_length(geom) * 0.001) as cost FROM schema.network_noded',<u></u><u></u></p>
<p class="MsoNormal"> 336, (SELECT array_agg(id) FROM schema.l1_pv1),
false, false<u></u><u></u></p>
<p class="MsoNormal"> ) a, schema.network_noded b <u></u><u></u></p>
<p class="MsoNormal">WHERE a.id1=<a href="http://b.id" target="_blank">b.id</a><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">It’s resulting a weird de-attached “little”
pieces of my original nodded_network! However, the number of resulted paths is
equal to the target/destination points. Please advise:<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p><u></u><span>1)<span style="font:7.0pt "Times New Roman"">
</span></span><u></u><span dir="LTR"></span>What potential mistake I may have
committed?<u></u><u></u></p>
<p><u></u><span>2)<span style="font:7.0pt "Times New Roman"">
</span></span><u></u><span dir="LTR"></span>Does it mean that all the
calculated travel_cost(s) are wrong (as they are reflected/represented by wrong
linestrings)?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I'm using QGIS 2.4.0 and pgRouting pg93-binaries-2.4.0<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I found similar question on this list of pgRouting users,
asked by Antonio last October (<a href="http://lists.osgeo.org/pipermail/pgrouting-users/2014-October/001992.html" target="_blank">http://lists.osgeo.org/pipermail/pgrouting-users/2014-October/001992.html</a>
), but obviously the question is not answered yet?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Regards..<span class="HOEnZb"><font color="#888888"><u></u><u></u></font></span></p><span class="HOEnZb"><font color="#888888">
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Eyad<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
</font></span></div>
</div>
<br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br></blockquote></div><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><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.info" style="color:rgb(66,99,171)" target="_blank">http://georepublic.info</a></span><div><br></div><div><br></div><div><br></div></div></div>
</div>