Solved

Obtaining Driving Distance Between Cities

Posted on 2006-10-31
5
1,117 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

In this post we will learn different types of Android Layout and some basics of an Android App.
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

726 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