<div>hi Daniel, thanks for the link..</div>
<div> </div>
<div id="result_box" dir="ltr" style="TEXT-ALIGN: left">I did the following:</div>
<div dir="ltr" style="TEXT-ALIGN: left"> </div>
<div class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><b><span lang="EN" style="mso-ansi-language: EN"><font size="3"><font face="Times New Roman">UPDATE calle SET to_cost=length(the_geom), reverse_cost=length(the_geom);</font></font></span></b></div>
<div class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><b><span lang="EN" style="mso-ansi-language: EN"><font size="3"><font face="Times New Roman"></font></font></span></b> </div>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><b><span lang="EN" style="mso-ansi-language: EN"><font size="3"><font face="Times New Roman">UPDATE calle SET reverse_cost=reverse_cost + 1000000 WHERE oneway!=0 , oneway!=0 are one way streets.</font></font></span></b></p>
<div>my query:</div>
<div> </div>
<div>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN" style="mso-ansi-language: EN"><font size="3"><font face="Times New Roman">SELECT edge_id as gid,cost as length FROM shortest_path_astar('SELECT gid AS id,source::int4, target::int4, to_cost::double precision as cost, reverse_cost::double precision, x1,y1,x2,y2 FROM calle',3412,3411,false,true)<b></b></font></font></span></p>
</div>
<div> </div>
<div>this do not works 100%, with some street works with others no... </div>
<div> </div>
<div>
<div id="result_box" dir="ltr" style="TEXT-ALIGN: left">I am missing something?</div></div>
<div> </div>
<div>RG<br><br></div>
<div class="gmail_quote">2009/2/11 Daniel Kastl <span dir="ltr"><<a href="mailto:kastl@orkney.co.jp">kastl@orkney.co.jp</a>></span><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">So I guess pgRouting doesn't know that there is a one way street.<br>You might want to read this: <a href="http://pgrouting.postlbs.org/wiki/OneWayStreets" target="_blank">http://pgrouting.postlbs.org/wiki/OneWayStreets</a><br>
<br>Daniel<br><br><br>Valeria Muņoz schrieb:<br>
<div>
<div></div>
<div class="Wj3C7c">> HI!!<br>><br>> I have a little problem with my routing, the best path from A to<br>> B do not respect the traffic direction.<br>> attached image.<br>><br>> please check in the example vicente perez rosales street<br>
><br>> Query<br>><br>> rt.gid,rt.the_geom AS tg, AsText(rt.the_geom) AS wkt,<br>> length(rt.the_geom) AS length, calle.gid FROM calle, (SELECT gid,<br>> the_geom FROM dijkstra_sp_delta( 'calle', 3414, 3406, 3000) ) as rt<br>
> WHERE calle.gid=rt.gid;<br>><br>><br>> RG<br>><br></div></div>> ------------------------------------------------------------------------<br>><br>> ------------------------------------------------------------------------<br>
><br>> _______________________________________________<br>> Pgrouting-users mailing list<br>> <a href="mailto:Pgrouting-users@lists.postlbs.org">Pgrouting-users@lists.postlbs.org</a><br>> <a href="http://lists.postlbs.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.postlbs.org/mailman/listinfo/pgrouting-users</a><br>
><br><br></blockquote></div><br>