<br><br><div class="gmail_quote">2011/1/14 Emre Koc <span dir="ltr"><<a href="mailto:emrekoch@gmail.com">emrekoch@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<font size="2"><font face="tahoma,sans-serif">Sure</font></font><div><font size="2"><font face="tahoma,sans-serif"><br></font></font></div><div><font size="2"><font face="tahoma,sans-serif">Here is my sql query for that image.</font></font></div>
<div><font size="2"><font face="tahoma,sans-serif"><br></font></font></div><div><font size="2"><font face="tahoma,sans-serif"><div>SELECT edges.gid, ST_AsText(edges.the_geom) AS geotext, </div><div> edges.ft_minutes,</div>
<div><span style="white-space:pre-wrap"> </span>edges.meters</div><div><span style="white-space:pre-wrap"> </span>FROM edges,</div><div><span style="white-space:pre-wrap"> </span>(SELECT edge_id, cost FROM driving_distance('SELECT gid as id,</div>
<div><span style="white-space:pre-wrap"> </span> source::integer,</div><div><span style="white-space:pre-wrap"> </span> target::integer,</div><div><span style="white-space:pre-wrap"> </span> meters::double precision as cost</div>
<div><span style="white-space:pre-wrap"> </span>FROM edges', $startVertexID, $cost,false,false)</div><div><span style="white-space:pre-wrap"> </span>) as rt </div><div><span style="white-space:pre-wrap"> </span>WHERE edges.gid=rt.edge_id;";</div>
<div><br></div><div>I just give a sample vertex id and a cost value in meters and got resulting edges. Normally when I find shortest paths all roads are connected so the graph is ok. But this driving directions does not output connected roads, thats the thing I do not understand. </div>
</font></font></div></blockquote><div><br></div><div>Driving distance returns you all the vertices you can reach from a start point to within what you have defined as the maximum costs.</div><div>I think you're looking for another query (Dijkstra, A-Star, Shooting Star).</div>
<div><br></div><div>The edge column in driving distance doesn't return a "useful" result as I just answered the day before in this message:</div><div><meta http-equiv="content-type" content="text/html; charset=utf-8"><a href="http://lists.osgeo.org/pipermail/pgrouting-users/2011-January/000474.html">http://lists.osgeo.org/pipermail/pgrouting-users/2011-January/000474.html</a></div>
<div><br></div><div>Daniel</div><div><br></div><div><br></div><div><br></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><font size="2"><font face="tahoma,sans-serif">
<div><br></div></font></font><font color="#888888">/emre<br>
<br><br></font><div class="gmail_quote"><div><div></div><div class="h5">On Fri, Jan 14, 2011 at 5:26 AM, Daniel Kastl <span dir="ltr"><<a href="mailto:daniel@georepublic.de" target="_blank">daniel@georepublic.de</a>></span> wrote:<br>
</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><div class="gmail_quote"><div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="gmail_quote"><div><div><br></div></div><div>I checked driving directions functionality and seems like the feature that I was looking for. But It returns non connected edges which are close by a cost. Do you know how does this function really work ? Here is my screenshot <a href="http://db.tt/0bb62XB" target="_blank">http://db.tt/0bb62XB</a>. Shouldn't the output be connected ? </div>
</div></blockquote><div><br></div></div><div>Could you tell us what you did exactly? The query for example.</div><div><br></div><font color="#888888"><div>Daniel </div><div><br></div><div><br></div></font></div><div><div>
</div><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>
</div></div><br></div></div><div class="im">_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">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>
<br></div></blockquote></div><br></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>
<br></blockquote></div><br><br clear="all"><br>-- <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>