<div dir="ltr"><div>Hi everyone!</div><div><br></div><div>I'm using pgr_kdijkstraPath to find less path from vertex  A to vertex D.</div><div><br></div><div>Using st_lenght()/(road velocity) to cost/reverse_cost.</div>
<div><br></div><div>Now, I need to use the road velocity at current travel time...</div><div><br></div><div>Something like this:</div><div><br></div><div><br></div><div>VertexTable</div><div><br></div><div>target<span class="" style="white-space:pre">       </span>source<span class="" style="white-space:pre">    </span>lenght<span class="" style="white-space:pre">    </span>velocity<span class="" style="white-space:pre">  </span>velocity_at_07<span class="" style="white-space:pre">    </span>velocity_at_08<span class="" style="white-space:pre">    </span>velocity_at_09</div>
<div>A<span class="" style="white-space:pre">   </span>B<span class="" style="white-space:pre"> </span>70km<span class="" style="white-space:pre">      </span>65km/h<span class="" style="white-space:pre">    </span>50km/h<span class="" style="white-space:pre">    </span>45km/h<span class="" style="white-space:pre">    </span>60km/h</div>
<div>B<span class="" style="white-space:pre">   </span>C<span class="" style="white-space:pre"> </span>10km<span class="" style="white-space:pre">      </span>65km/h<span class="" style="white-space:pre">    </span>60km/h<span class="" style="white-space:pre">    </span>55km/h<span class="" style="white-space:pre">    </span>70km/h</div>
<div>C<span class="" style="white-space:pre">   </span>D<span class="" style="white-space:pre"> </span>2km<span class="" style="white-space:pre">       </span>65km/h<span class="" style="white-space:pre">    </span>60km/h<span class="" style="white-space:pre">    </span>60km/h<span class="" style="white-space:pre">    </span>70km/h</div>
<div><br></div><div>How can I use pgr_K/pgr_Dijkstra to get this costs?</div><div><br></div><div>Starting at 07am.</div><div>A - 07am - 70km - use velocity_at_07 to B</div><div>B - ~08am - 10km - use velocity_at_08 to C</div>
<div>C - ~08am - 2km - use velocity_at_08 to D</div><div>..<br><b><font face="'arial black', sans-serif">Omar Fernando Pessôa</font></b><br><a href="http://www.opessoa.com" target="_blank">http://www.opessoa.com</a><br>
Desenvolvedor de sistemas<br>Programador C# e C++</div>
</div>