Yes, I'm already doing that, but the problem is: let's go from node A to node C, assume the travel lasts three hours, if I use a join using my_cost and my_edges with the time '10:00' it will travel from A to C as every path is traversed at 10:00, it will ignore the fact that when you get midway A - C it is 11:30 and the traverse costs (i.e. time used to travel the nodes) has changed, so it will not be the shortest path, instead it will be the shortest path assuming we are frozen in time...<br>
<br>Hard, isn't it? Some idea?<br><br>Regards, Roberto. <br><br><br><div class="gmail_quote">El 30 de enero de 2012 17:04, Jorge Eliécer Osorio Caro <span dir="ltr"><<a href="mailto:jorgeliecer.osorio@gmail.com">jorgeliecer.osorio@gmail.com</a>></span> escribió:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">I think that you need to make a inner joint into my_cost according the time and pass the cost and reverse_cost, where match that time with and edge id.<br>
<br><div class="gmail_quote"><div><div class="h5">2012/1/30 Roberto Oropeza Gamarra <span dir="ltr"><<a href="mailto:oropezaroberto@gmail.com" target="_blank">oropezaroberto@gmail.com</a>></span><br>
</div></div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div class="h5">Hello, <br><br>I need to calculate the shortest path, taking into account that the cost of traveling beetween edges varies according to the time of day. I have a table of edges [my_edges(id, source, target, ...)] and other table for cost and reverse_cost with columns especifying the time of day in which that cost is applicable [my_costs(cost, reverse_cost, start_time, end_time,...)], the cost is the number of minutes it takes to traverse from source to target.<br>
<br>Is there a way pgRouting can help me to calculate this special shortest path? <br><br>Thanks, Roberto.<br>
<br></div></div>_______________________________________________<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></blockquote></div><br>
<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>