Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have a list of locations (prospects I need to meet) I have to drive to, and I'd like to use either Google Maps or Open Street View to build an optimized route.

Are there tools that can take a CSV list of locations and generate a driving route?

Thank you.

share|improve this question
add comment

2 Answers

up vote 0 down vote accepted

If you are interested in the programmatic solution a rough plan of the workflow is as follows:

  1. Grab the CSV and turn it into an array
  2. Loop thru the points of the result array
  3. For each pair of points calculate the driving distance between them which will also pass back an array of points that is used to plot the polyline.
  4. Collect these arrays and then loop thru this array of arrays to plot all polylines.

If you need clarification, I am happy to help you! Of course you want to do the CSV parsing server side and then do the rest on the client side using javascript.

Alternatively, if you don't have that many points in your CSV, you can use the following route request of the google directions api.

http://maps.googleapis.com/maps/api/directions/json?origin=Adelaide,SA&destination=Adelaide,SA&waypoints=optimize:true|Barossa+Valley,SA|Clare,SA|Connawarra,SA|McLaren+Vale,SA&sensor=false

Note that the waypoints of the route are separated with the pipe characters (|). You can also modify the order of your waypoints by setting the waypoint_order field, like "waypoint_order": [ 1, 0, 2, 3 ]

I hope I helped!

share|improve this answer
    
Thanks for the infos. I'll try both solutions. –  Gulbahar May 23 '12 at 23:29
add comment

you can do this with some programmatic way adding your csv to array then for getting manuel solution.

beside this you can achieve this task with Greasemonkey. there is some information here. you should change the code to your needs.

googlemap

and the last thing you should check out POIConverter to find another solution...

i hope it helps you....

share|improve this answer
    
Thanks for the infos. I'll try both solutions. –  Gulbahar May 23 '12 at 23:29
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.