<div>hi Stephen</div>
<div> </div>
<div>i got</div>
<div> </div>
<div>"oneway";"count"<br>-1;1451<br>0;21403<br>1;2640<br></div>
<div> </div>
<div> </div>
<div>0=both ways</div>
<div>-1=B->A</div>
<div>1= A->B</div>
<div> </div>
<div>RG.<br><br></div>
<div class="gmail_quote">2009/2/12 Stephen Woodbridge <span dir="ltr"><<a href="mailto:woodbri@swoodbridge.com">woodbri@swoodbridge.com</a>></span><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Valeria,<br><br>What do you get for this query:<br><br>select distinct oneway, count(*) as count from calle group by oneway, order by oneway;<br>
<br>If you have a street A------->B then the oneway flag probable needs 3 values. 0 for both ways, 1? for A to B, and maybe 2? for B to A. You need to figure out which values are which.<br><br>Then you need cost or reverse cost based on the value of oneway.<br>
<br>-Steve<br><br>Valeria Muņoz wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div class="Ih2E3d">hi Daniel, thanks for the link..<br> I did the following:<br> * UPDATE calle SET to_cost=length(the_geom), reverse_cost=length(the_geom); *<br>* * <br>* UPDATE calle SET reverse_cost=reverse_cost + 1000000 WHERE oneway!=0 , oneway!=0 are one way streets. *<br>
<br>my query:<br> <br>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)**<br>
<br> this do not works 100%, with some street works with others no...<br> I am missing something?<br> RG<br><br></div>2009/2/11 Daniel Kastl <<a href="mailto:kastl@orkney.co.jp" target="_blank">kastl@orkney.co.jp</a> <mailto:<a href="mailto:kastl@orkney.co.jp" target="_blank">kastl@orkney.co.jp</a>>>
<div class="Ih2E3d"><br><br> So I guess pgRouting doesn't know that there is a one way street.<br> You might want to read this:<br> <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> > HI!!<br> ><br> > I have a little problem with my routing, the best path from<br> 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> ><br> ------------------------------------------------------------------------<br>
><br> ><br> ------------------------------------------------------------------------<br> ><br> > _______________________________________________<br> > Pgrouting-users mailing list<br> > <a href="mailto:Pgrouting-users@lists.postlbs.org" target="_blank">Pgrouting-users@lists.postlbs.org</a><br>
</div> <mailto:<a href="mailto:Pgrouting-users@lists.postlbs.org" target="_blank">Pgrouting-users@lists.postlbs.org</a>>
<div class="Ih2E3d"><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><br><br>------------------------------------------------------------------------<br>
<br>_______________________________________________<br>Pgrouting-users mailing list<br><a href="mailto:Pgrouting-users@lists.postlbs.org" target="_blank">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>
</div></blockquote><br></blockquote></div><br>