Hi,
I am working on location optimization and using drive times and distances from Google maps. I got lots of useful info from the oft quoted Mike Zdeb at http://www.sascommunity.org/wiki/Driving_Distances_and_Drive_Times_using_SAS_and_Google_Maps. Very helpful and works well!
Part of process involves taking the Google Maps output for a search between the 2 addresses. You then use the scan function to parse out the driving distance and time. Straight forward enough. I am curious, however, about the results and hoping some community folks have some additional Google Maps experience. The results from the searches typically have multiple times and distances. Most examples use just the first time and distance... but does anyone know what the second (or third, forth, etc) times represent? Sometimes it looks like the first time/distance is an average... but other times the math doesn't work for it be an average.
There are couple examples below..
1) [35574,"22.1 miles",1],[1800,"30 min"],0,null,null,[[1712,"29 min"],1,3,[1620,"27 min"],[1563,2162,"26 - 36 min"]
2) [101519,"63.1 miles",1],[4650,"1 h 18 min"],0,null,null,[[5136,"1 h 26 min"],2,2,[4269,"1 h 11 min"],[4308,5797,"1 h 12 min - 1 h 37 min"]
Additionally, most the time, the distance isn't exactly what is listed when you just run the search in Google Maps. It is usually close, but using the address in example 2, I get a distance distances of 58.3 miles and 63.7 with times of 1H39M and 1H20M.
I recognize that drive times are educated guesses and I am not overly reliant on them. Just trying to understand the data and differences between direct searches and SAS grabbing it . Any Google Maps experts out there they have any insights? Any good resources on the topic? Thanks!
... View more