Solved

Obtaining Driving Distance Between Cities

Posted on 2006-10-31
5
1,113 Views
Last Modified: 2013-11-13
I have a list of about 500 cities that I would like to be able to obtain driving distance/time between them for a research project.  It would seem I could use the API of yahoo/google or Maptech to do this but I'm not really sure how.  I generally do VB.net programming (non web based) so I was planning on writing an app to loop through the cities, I just don't know how to pass the information to one of the API's and get the results back.  I would rather use actual driving distance rather than just line distance as that is more relevant.  Can Anybody give me some direction or possibly an example.
0
Comment
Question by:jtwestmo
5 Comments
 
LVL 84

Expert Comment

by:ozo
ID: 17847225
What does the query to yahoo/google or Maptech to get a distance look like?
Do you think they will mind if you make 124750 querys?
0
 
LVL 1

Author Comment

by:jtwestmo
ID: 17847268
Well I'm just looking for options at this point, I really haven't look too far into doing this.  I could easily break it up into small sets and run it over a month or so, that way I wouldn't be hitting it over and over again.
0
 
LVL 6

Accepted Solution

by:
austinstace earned 125 total points
ID: 17847284
I found this article about using the Yahoo API through excel... http://batchgeocode.blogspot.com/2006/04/geocode-right-from-excel.html

Looks like it might be right up your alley

Good luck,

Stace

0
 
LVL 18

Expert Comment

by:JoseParrot
ID: 17847396
Hi,

You should construct a 500 nodes graph and a number of weight edges, as much as there are link between the cities.
Then you should fill a matrix with distances from all to all cities. Such matrix is build by using an algorithm to find the shortest distance from city A to city B, considering that there are many A-to-B different routes in many cases.

Which google API you are looking for?

Jose
0
 
LVL 1

Author Comment

by:jtwestmo
ID: 17850135
I am going to check out the link that austinstace sent me that looks like exactly where I want to go.

Jose
I am not exactly sure how my friend is going to use the data I provide but I am assuming she will be building a matrix for her project.  I am not sure.  As for the API I was refering to something similar to what yahoo and maptech provide, I assued Google had something similar.

Jamey
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I know it’s not a new topic to discuss and it has lots of online contents already available over the net. But Then I thought it would be useful to this site’s visitors and can have online repository on vim most commonly used commands. This post h…
This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now