Calcaulate driving time

Hi,
I'm looking for advices for calculating driving time from
one city to other cities.
I need to get driving time from the capital city of each
Canadian provinces to other cities within the provinces.
I only have city names, province names and postal code
information in table(about 4000 cities). What other data
I need to get in order to calculate driving time between
cities? Do you happen to know from anywhere I can get the
data?
Thank you very much.
LillyIts not that qute trivial to build up a tracking system like this. I f you
wanna base your calculation on the time you spend on the road, you will need
to have the streets, the distances between the neuralgic points, the type of
streets your using (for speed) the connection between these neuralgic
points, etc. Then you need an algorithm to get the fastest, the shortest way
to get from the starting point to the destination. Kind of mathematical
problem whih would exceeds the meaning of this group.
http://www.mat.uc.pt/~eqvm/OPP/shortestpath.html
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Lilly" <anonymous@.discussions.microsoft.com> schrieb im Newsbeitrag
news:17fa01c54946$7fb58cb0$a401280a@.phx.gbl...
> Hi,
> I'm looking for advices for calculating driving time from
> one city to other cities.
> I need to get driving time from the capital city of each
> Canadian provinces to other cities within the provinces.
> I only have city names, province names and postal code
> information in table(about 4000 cities). What other data
> I need to get in order to calculate driving time between
> cities? Do you happen to know from anywhere I can get the
> data?
> Thank you very much.
> Lilly|||I always thought that this would make a great (at least a fun) SQL database.
Put every connecting city street into a database, and then do a recursive
breadth first query. It would need to be reasonably directed, so each
recursion would have to eliminate some of the paths based on distance. It
would be a heck of a lot of work though. Easier to buy mappoint and let it
do its thing I would expect!
----
Louis Davidson - drsql@.hotmail.com
SQL Server MVP
Compass Technology Management - www.compass.net
Pro SQL Server 2000 Database Design -
http://www.apress.com/book/bookDisplay.html?bID=266
Blog - http://spaces.msn.com/members/drsql/
Note: Please reply to the newsgroups only unless you are interested in
consulting services. All other replies may be ignored :)
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:Oi9BA9USFHA.1528@.TK2MSFTNGP09.phx.gbl...
> Its not that qute trivial to build up a tracking system like this. I f you
> wanna base your calculation on the time you spend on the road, you will
> need to have the streets, the distances between the neuralgic points, the
> type of streets your using (for speed) the connection between these
> neuralgic points, etc. Then you need an algorithm to get the fastest, the
> shortest way to get from the starting point to the destination. Kind of
> mathematical problem whih would exceeds the meaning of this group.
> http://www.mat.uc.pt/~eqvm/OPP/shortestpath.html
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Lilly" <anonymous@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:17fa01c54946$7fb58cb0$a401280a@.phx.gbl...
>