<br><br><div class="gmail_quote">On Sun, Jun 12, 2011 at 1:32 PM, Anton Patrushev <span dir="ltr"><<a href="mailto:anton.patrushev@georepublic.de">anton.patrushev@georepublic.de</a>></span> wrote:<br><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>
No, there was no specific meaning, just king of cyphering - first<br>
digit for road class and then two last digits for road type.<br>
<br></blockquote><div><br>Hi Anton,<br><br>So, as you said last 2 digits are for road type. I can see they are mainly 00, 01, 02, 06, 08, 09, 10, 11, 12 ,14, 17. <br><br>Road class is just 1 or 4. <br><br>Can I differentiate major highways, minor highways, streets etc using this info?<br>
</div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Anton.<br>
<div><div></div><div class="h5"><br>
On 6/12/11, Jay Mahadeokar <<a href="mailto:jai.mahadeokar@gmail.com">jai.mahadeokar@gmail.com</a>> wrote:<br>
>> Hi Jay,<br>
>><br>
>> I think that instead of just random times, I would take a different<br>
>> approach to generate this data. If we think about "rush hour" around a<br>
>> major<br>
>> city, the highways (based on road class) flowing into the city in the<br>
>> morning would get reduced average speeds you could apply curve like<br>
>> average<br>
>> speed*percent based on 6am (90%), 7am(75%), 8am(45%), 9am(50%), 10am(85%)<br>
>> and do something similar in the evening rush. It might be too hard to<br>
>> figure<br>
>> on direction of flow in/out bound so apply the curve to all traffic. The<br>
>> assumption is that the highways are congested which will force traffic<br>
>> onto<br>
>> side streets. You might want to also reduce the lower class speeds by say<br>
>> a<br>
>> constant 80% during rush hour.<br>
>><br>
>> If we can get OSM data then it should be easy to populate the table with<br>
>> that data.<br>
>><br>
>> -Steve<br>
>><br>
><br>
> I am trying to write plpgsql query to generate time-dependent data<br>
> corresponding to the ways table in pgrouting workshop. As suggested by Steve<br>
> above, instead of generating random data, I will follow patterns (see above<br>
> 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<br>
> attribute class_id in ways table. It has 14 distinct values:<br>
> class_id<br>
><br>
> ----------<br>
><br>
><br>
> 102<br>
><br>
><br>
> 122<br>
><br>
><br>
> 106<br>
><br>
><br>
> 111<br>
><br>
><br>
> 108<br>
><br>
><br>
> 100<br>
><br>
><br>
> 109<br>
><br>
><br>
> 112<br>
><br>
><br>
> 101<br>
><br>
><br>
> 110<br>
><br>
><br>
> 401<br>
><br>
><br>
> 119<br>
><br>
><br>
> 117<br>
><br>
> 114<br>
><br>
> Any specific meaning attached to these values? I did not find any<br>
> 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" target="_blank">http://workshop.pgrouting.org/chapters/topology.html</a><br>
><br>
> --<br>
> Regards,<br>
> -Jay Mahadeokar<br>
><br>
<br>
<br>
</div></div>--<br>
Georepublic UG (haftungsbeschränkt)<br>
Salzmannstraße 44,<br>
81739 München, Germany<br>
<br>
Anton Patrushev<br>
CTO<br>
<br>
eMail: <a href="mailto:anton.patrushev@georepublic.de">anton.patrushev@georepublic.de</a><br>
Web: <a href="http://georepublic.de" target="_blank">http://georepublic.de</a><br>
<br>
Tel: +49 (089) 420 959 519<br>
Sip: <a href="mailto:1959519@sipgate.de">1959519@sipgate.de</a><br>
<br>
Commercial register: Amtsgericht München, HRB 181428<br>
CEO: Daniel Kastl<br>
<div><div></div><div class="h5">_______________________________________________<br>
pgrouting-dev mailing list<br>
<a href="mailto:pgrouting-dev@lists.osgeo.org">pgrouting-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-dev</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Regards,<br>-Jay Mahadeokar<br><br>