<div>Daniel</div>
<div> </div>
<div>what type of measure returns the function length()?, my result was:0.00208418695629</div>
<div> </div>
<div id="result_box" dir="ltr" style="TEXT-ALIGN: left">I have the SPEED field, you know how I can give instructions such as turn right or left?</div>
<div> </div>
<div>RG<br><br></div>
<div class="gmail_quote">2009/2/5 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">Valeria,<br><br>This depends on your data. Distance might be your current cost already.<br>You can get the total distance with SELECT sum(length(rt.the_geom)) ... .<br>
<br>If you want to have time you might need a "speed" attribute for your<br>road link table.<br><br>Daniel<br><br><br>Valeria Muņoz schrieb:<br>
<div class="Ih2E3d">><br>> how can i get the distance,time, if you have to turn right o to turn<br>> left??<br>><br>> RG<br>><br>><br></div>> 2009/2/4 Valeria Muņoz <<a href="mailto:valemunoz@gmail.com">valemunoz@gmail.com</a> <mailto:<a href="mailto:valemunoz@gmail.com">valemunoz@gmail.com</a>>><br>
<div class="Ih2E3d">><br>> Stephen you are right i change to :<br>><br>><br>> SELECT assign_vertex_id('edges', 0.000001, 'the_geom', 'gid');<br>> and works!!! thanks!!<br>
><br>><br>><br>> 2009/2/4 Stephen Woodbridge <<a href="mailto:woodbri@swoodbridge.com">woodbri@swoodbridge.com</a><br></div>> <mailto:<a href="mailto:woodbri@swoodbridge.com">woodbri@swoodbridge.com</a>>><br>
<div class="Ih2E3d">><br>> Valeria,<br>><br>> What projection is your shapefile in? it looks like WGS84 or<br>> NAD83 from your coordinates below. So when you did:<br>><br>> SELECT assign_vertex_id('edges', 0.001, 'the_geom', 'gid');<br>
><br>> you should probably have done:<br>><br>> SELECT assign_vertex_id('edges', 0.000001, 'the_geom', 'gid');<br>><br>> The tolerance needs to be in the units of your data. This will<br>
> probably give better results.<br>><br>> You should probably drop the database and start over with a<br>> new load and use the statement above when you get to that step.<br>><br>> -Steve<br>
><br>><br>> Valeria Muņoz wrote:<br>><br>> Hi<br>> I followed a little tutorial works perfectly with the<br>> shapefile from the example, but to use mine the result is<br>
> not expected, generating lines are not continuous, I think<br>> I missing some coordinates or something to work with my<br>> shapefile.<br>> tutorial url<br>> <a href="http://www.utdallas.edu/~ama054000/rt_tutorial.html" target="_blank">http://www.utdallas.edu/~ama054000/rt_tutorial.html</a><br>
</div>> <<a href="http://www.utdallas.edu/~ama054000/rt_tutorial.html" target="_blank">http://www.utdallas.edu/%7Eama054000/rt_tutorial.html</a>><br>
<div>
<div></div>
<div class="Wj3C7c">> query:<br>> the query is optimal path between 887 y 852. :<br>> SELECT rt.gid, AsText(rt.the_geom) AS wkt,<br>> length(rt.the_geom) AS length, calle.gid<br>
> FROM calle,<br>> (SELECT gid, the_geom<br>> FROM dijkstra_sp_delta(<br>> 'calle',<br>
> 887,<br>> 852,<br>> 3000)<br>> ) as rt<br>> WHERE calle.gid=rt.gid;<br>
> result:<br>> "gid";"wkt";"length";"gid"<br>> 4389;"MULTILINESTRING((-71.1951327440651<br>> -30.5911350429583,-71.1957462426904<br>
> -30.5912128948402,-71.1957861853043<br>> -30.591219747929,-71.1958400125164<br>> -30.591211719682))";0.000713367403530106;4389<br>> 4603;"MULTILINESTRING((-71.1939954028678<br>
> -30.5921681162637,-71.1939834234752<br>> -30.5922241673576,-71.1938231446269<br>> -30.5925509466888))";0.000421286769021393;4603<br>> 4331;"MULTILINESTRING((-71.1950174992082<br>
> -30.5919506007811,-71.1950526139385<br>> -30.5916919152203))";0.000261057969957178;4331<br>> 4608;"MULTILINESTRING((-71.1938231446269<br>> -30.5925509466888,-71.1937648360013<br>
> -30.5926358138883))";0.00010296765211197;4608<br>> RG<br>> attached image.<br>> please help!!..<br>><br>> ------------------------------------------------------------------------<br>
><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></div></div>> <mailto:<a href="mailto:Pgrouting-users@lists.postlbs.org">Pgrouting-users@lists.postlbs.org</a>><br>
<div>
<div></div>
<div class="Wj3C7c">> <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">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>_______________________________________________<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>
</div></div></blockquote></div><br>