Driving Distance between two points.

[gsmitchell]

Hello All, Good Morning!

I am going to have a long list ( 1000+ ) of addresses that I need to get driving distances for. I don't need a map, just the distance between two specific addresses ( not just zip codes ). I have seen some info on zip codes and some using long/lat on here, but most of it is giving an "as the bird flies" result. We can get those done, but find they are not quite granular enough for our needs. Has anyone had any luck trying to get something like this done? Any help appreciated, thanks!

George

 

[mole999]

I think you can get a Google API that will allow you 300 per day

 

[synergy16]

are you looking for the distance between your 1000+ list and one specific point? or distance between any giving 2 points in your list? also, there are a lot of ways to measure distance between 2 points. as you said, as the crow flies is one, but you also have, highway, back roads, or combination of the 2....what are you looking for exactly?

 

[gsmitchell]

I think you can get a Google API that will allow you 300 per day

Thank you mole999! We are looking at that option now since having Google tell us the distance is really what we want. Have you used it before?

 

[gsmitchell]

are you looking for the distance between your 1000+ list and one specific point? or distance between any giving 2 points in your list? also, there are a lot of ways to measure distance between 2 points. as you said, as the crow flies is one, but you also have, highway, back roads, or combination of the 2....what are you looking for exactly?

Hi synergy16 thanks for the question. What we are shooting for will be distance between location A and whatever the closest location we have to that is. This is just an example, but think "There are 3 fire stations close to my house, which is closest?" So, if we have a list of houses and a list of fire stations, we will use this to find the closest fire station to each of the houses. Once we have that, it will just go in a database and be updated from time to time. *** BTW, this does not involve any fire department or residential development. I just thought that would make a good example ***

 

[synergy16]

ok, so the user would input a some location, what ever it might be and you would want to return the closest place on your list?

 

[synergy16]

you might want to give this site a look and see if its what you are looking for as well

https://www.freemaptools.com/how-far-is-it-between.htm

 

[AhoyNC]

There is a commercial program used by transportation firms called PC Miler, which does have an interface for Excel.
PC*MILER

Or another free option is Rand McNally.
Rand McNally Driving Directions and Maps

 

[gsmitchell]

you might want to give this site a look and see if its what you are looking for as well

https://www.freemaptools.com/how-far-is-it-between.htm

Thanks Synergy16! That looks like a great tool for showing the comparison of direct and diving miles.

 

[gsmitchell]

There is a commercial program used by transportation firms called PC Miler, which does have an interface for Excel.
PC*MILER

Or another free option is Rand McNally.
Rand McNally Driving Directions and Maps

Hi AhoyNC, thanks! Never heard of either of those so I will have to take a look.