<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:224685174;
mso-list-type:hybrid;
mso-list-template-ids:-319111304 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1
{mso-list-id:731586102;
mso-list-type:hybrid;
mso-list-template-ids:1428079996 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.25in;
text-indent:-.25in;
font-family:Symbol;}
@list l2
{mso-list-id:1545219693;
mso-list-type:hybrid;
mso-list-template-ids:-2009197618 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l2:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.25in;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Hi Uazu,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>There is a quick/easy way to do what you require, if you do not have a specialist Transportation GIS System such as TransCAD GIS, Or you do not want to get involved in routing.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>What you require is:<o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><span style='mso-list:Ignore'>1.<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>A road network that has a field that indicates the length of each road link (from node to node)<o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><span style='mso-list:Ignore'>2.<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>A field that indicates the posted road speed (this is the most easily available to source)<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.75in'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I am going to ramble on here a bit but just bear with me – presume that the road links are in km and speed is km/h. <o:p></o:p></span></p><p class=MsoNormal style='margin-left:.75in'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I Presume that you also do not have a morning peak hour/off peak hour and evening peak hour journey time for each road link.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.75in'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I also have no idea as to the road environment i.e. are they urban or rural roads?<o:p></o:p></span></p><p class=MsoListParagraph style='margin-left:1.25in;text-indent:-.25in;mso-list:l1 level1 lfo3'><![if !supportLists]><span style='font-size:11.0pt;font-family:Symbol;color:#1F497D'><span style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>If travel time is distance/speed you need to do the following<o:p></o:p></span></p><p class=MsoListParagraph style='margin-left:1.25in;text-indent:-.25in;mso-list:l1 level1 lfo3'><![if !supportLists]><span style='font-size:11.0pt;font-family:Symbol;color:#1F497D'><span style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Create a new field in your table (called travel time – presume hours) I will ignore for simplicity the fact that roads have traffic signals, stops (you need to normally factor in these time penalties , right turn penalties etc.)<o:p></o:p></span></p><p class=MsoListParagraph style='margin-left:1.25in;text-indent:-.25in;mso-list:l1 level1 lfo3'><![if !supportLists]><span style='font-size:11.0pt;font-family:Symbol;color:#1F497D'><span style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Populate the field with a travel time using – Travel Time = D/S (D= distance - km, S= speed –km/h) you should have a field populated for each road link – you should have a very small number – you may want to change your road units length to meters and your time to minutes<o:p></o:p></span></p><p class=MsoListParagraph style='margin-left:1.25in;text-indent:-.25in;mso-list:l1 level1 lfo3'><![if !supportLists]><span style='font-size:11.0pt;font-family:Symbol;color:#1F497D'><span style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Test your results against some known travel times and adjust your travel times by taking 30-40% of the posted speed for peak periods and say 60% for off peak periods. Just keep creating new fields with different factors and keep populating different % fields.<o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><span style='mso-list:Ignore'>3.<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I would create a selection set of the road links that make up your route, Origin to Destination, export to a dbf or similar, manipulate your data and start testing your inputs/outputs, preferably against some know data.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I hope this assists with what you are required to do, given that you appear not to be familiar with routing etc.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Regards<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#365F91'>Rodney Steinhofel </span></b><b><span style='font-size:8.0pt;font-family:"Calibri","sans-serif";color:gray'>(GISc T, Pr S Arch T)<o:p></o:p></span></b></p><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#365F91'>PBS Consulting</span></b><b><span style='font-size:9.0pt;font-family:"Calibri","sans-serif";color:#365F91'><br></span></b><span style='font-size:8.0pt;font-family:"Calibri","sans-serif";color:#999999'><br></span><b><span style='font-size:9.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>E-Mail:</span></b><span style='font-size:9.0pt;font-family:"Calibri","sans-serif";color:#999999'> <a href="mailto:trudieu@stbb.co.za">rodney@pbs-sa.co.za</a><o:p></o:p></span></p><p class=MsoNormal><b><span style='font-size:9.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Cell:</span></b><span style='font-size:9.0pt;font-family:"Calibri","sans-serif";color:#999999'> +27 (0) 83 435 3192<br></span><b><span style='font-size:9.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Phone:</span></b><span style='font-size:9.0pt;font-family:"Calibri","sans-serif";color:#999999'> +27 (0) 21 843 3456<br><br><br></span><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#A6002F'><o:p></o:p></span></b></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> africa-bounces@lists.osgeo.org [mailto:africa-bounces@lists.osgeo.org] <b>On Behalf Of </b>Uazukuani<br><b>Sent:</b> Tuesday, January 15, 2013 3:31 PM<br><b>To:</b> Rainer@krugs.de; Africa local chapter discussions<br><b>Subject:</b> Re: [OSGeo Africa] Travel Time Calculation<o:p></o:p></span></p></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Hi Rainer <o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I have worked with GRASS before and will check that out too. <o:p></o:p></p></div><div><p class=MsoNormal>I don't think I will manage R on my own so I will pass. <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>rgds,<o:p></o:p></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'>Uazu<o:p></o:p></p><div><p class=MsoNormal>On Tue, Jan 15, 2013 at 11:04 AM, Rainer M Krug <<a href="mailto:r.m.krug@gmail.com" target="_blank">r.m.krug@gmail.com</a>> wrote:<o:p></o:p></p><p class=MsoNormal>-----BEGIN PGP SIGNED MESSAGE-----<br>Hash: SHA1<o:p></o:p></p><div><div><p class=MsoNormal style='margin-bottom:12.0pt'><br>On 15/01/13 08:24, Paul Scott wrote:<br>> On 15/01/2013 08:53, S Coetzer wrote:<br>>> Hi<br>>><br>>> If I can suggest a quick an easy way to get estimated time travel.<br>>><br>>> Get your x,y coordinates from point A to point B and plot it on Google maps. Use the GET<br>>> DIRECTIONS facility, this would give you an estimated travel time and distance along with<br>>> several possible alternative routes.<br>>><br>>><br>><br>> For a group of GI professionals, I am bitterly disappointed in these types of answers. Has<br>> anyone heard of Djikstra's algorithm (<a href="http://en.wikipedia.org/wiki/Dijkstra%27s_algorithm" target="_blank">http://en.wikipedia.org/wiki/Dijkstra%27s_algorithm</a>) or<br>> a* or Shooting-Star distance algorithms?<br>> (<a href="http://www.policyalmanac.org/games/aStarTutorial.htm" target="_blank">http://www.policyalmanac.org/games/aStarTutorial.htm</a>)<br>><br>> From that, we can infer that distance * average speed = time right?<br>><br>> Come on ladies and gents! Let us foster an environment for new thinking and innovation, not a<br>> forum for consumption of predefined OTS products.<br>><br>> OSGeo = Open Source = hack and pick and modify = change = new = better = share.<o:p></o:p></p></div></div><p class=MsoNormal>Well - if there are "out of the box" solutions, why not mention them so that they can be used?<br>Easier in many regards (although not that satisfying and challenging...)<br><br>But here are two ideas:<br><br>1) You could use R. I wouldn't wonder if there is a package for that.<br><br>2) Use GRASS:<br>a) Rasterize your road network (NULL values for "not on road")<br>b) use r.cost or r.walk to calculate the least cost paths along the road network (see<br><a href="http://casoilresource.lawr.ucdavis.edu/drupal/book/export/html/96" target="_blank">http://casoilresource.lawr.ucdavis.edu/drupal/book/export/html/96</a> "Simple Comparision of Two<br>Least-Cost Path Approaches" for a comparison of the two)<br><br>Warning: I haven't used this approach yet, these are just ideas, but they could work. To get motre<br>info, I would suggest to google and ask on the GRASS user mailing list.<br><br>Cheers,<br><br>Rainer<o:p></o:p></p><div><p class=MsoNormal style='margin-bottom:12.0pt'><br><br><br>><br>><br>><br>> _______________________________________________ Africa mailing list <a href="mailto:Africa@lists.osgeo.org">Africa@lists.osgeo.org</a><br>> <a href="http://lists.osgeo.org/mailman/listinfo/africa" target="_blank">http://lists.osgeo.org/mailman/listinfo/africa</a><br>><br><br><o:p></o:p></p></div><p class=MsoNormal>- --<br>Rainer M. Krug, PhD (Conservation Ecology, SUN), MSc (Conservation Biology, UCT), Dipl. Phys.<br>(Germany)<br><br>Centre of Excellence for Invasion Biology<br>Stellenbosch University<br>South Africa<br><br>Tel : <a href="tel:%2B33%20-%20%280%299%2053%2010%2027%2044">+33 - (0)9 53 10 27 44</a><br>Cell: <a href="tel:%2B33%20-%20%280%296%2085%2062%2059%2098">+33 - (0)6 85 62 59 98</a><br>Fax : <a href="tel:%2B33%20-%20%280%299%2058%2010%2027%2044">+33 - (0)9 58 10 27 44</a><br><br>Fax (D): <a href="tel:%2B49%20-%20%280%293%2021%2021%2025%2022%2044">+49 - (0)3 21 21 25 22 44</a><br><br>email: <a href="mailto:Rainer@krugs.de">Rainer@krugs.de</a><br><br>Skype: RMkrug<br><br>-----BEGIN PGP SIGNATURE-----<br>Version: GnuPG v1.4.11 (GNU/Linux)<br>Comment: Using GnuPG with Thunderbird - <a href="http://www.enigmail.net/" target="_blank">http://www.enigmail.net/</a><br><br>iEYEARECAAYFAlD1G4QACgkQoYgNqgF2egpkogCdFAZXc3AH/ExUdqQAEv+betyz<br>aA0An0FL8UC/WMO6UxJFoGAZJpZNqcn2<br>=OVuX<br>-----END PGP SIGNATURE-----<o:p></o:p></p><div><div><p class=MsoNormal>_______________________________________________<br>Africa mailing list<br><a href="mailto:Africa@lists.osgeo.org">Africa@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/africa" target="_blank">http://lists.osgeo.org/mailman/listinfo/africa</a><o:p></o:p></p></div></div></div><p class=MsoNormal><o:p> </o:p></p></div></div></body></html>