<br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hi Jay,<br>
<br>
I think that instead of just random times, I would take a different approach to generate this data. If we think about "rush hour" around a major city, the highways (based on road class) flowing into the city in the morning would get reduced average speeds you could apply curve like average speed*percent based on 6am (90%), 7am(75%), 8am(45%), 9am(50%), 10am(85%) and do something similar in the evening rush. It might be too hard to figure on direction of flow in/out bound so apply the curve to all traffic. The assumption is that the highways are congested which will force traffic onto side streets. You might want to also reduce the lower class speeds by say a constant 80% during rush hour.<br>
<br>
If we can get OSM data then it should be easy to populate the table with that data.<br>
<br>
-Steve<br></blockquote></div><br>I am trying to write plpgsql query to generate time-dependent data corresponding to the ways table in pgrouting workshop. As suggested by Steve above, instead of generating random data, I will follow patterns (see above message) so that the data is nearer to the real worlds scenario.<br>
<br>So, now I need to make distinction between highways, streets etc. I saw the attribute class_id in ways table. It has 14 distinct values:<br> class_id <br>
---------- <br> 102 <br>
122 <br> 106 <br>
111 <br> 108 <br>
100 <br> 109 <br>
112 <br> 101 <br>
110 <br> 401 <br>
119 <br> 117 <br>
114 <br clear="all"><br>Any specific meaning attached to these values? I did not find any information on the pgRouting-workshop website [1].<br><br><br>Thanks in advance.<br><br>[1] <a href="http://workshop.pgrouting.org/chapters/topology.html">http://workshop.pgrouting.org/chapters/topology.html</a><br>
<br>-- <br>Regards,<br>-Jay Mahadeokar<br><br>