![]() |
Is there a way to calculate distance between 2 zipcodes?
I need to use some service to dynamically calcualte distance between two
zipcodes. Do you know about anything like this? |
Is there a way to calculate distance between 2 zipcodes?
You could check the USPS website for a zip code index to give you the
locations and then maybe Rand-McNally to get the mileage estimates between the cities that the zip codes apply to. As far as a single point of reference. Nope, I don't know of one. But somebody probably has one somewhere. "Serissa" wrote: I need to use some service to dynamically calcualte distance between two zipcodes. Do you know about anything like this? |
Is there a way to calculate distance between 2 zipcodes?
There are lists of zip code, town, long/lat data. As long as you can get
from zip code to long/lat, you can use trig to calculate the straight line distance, assuming you can approximate to a flat surface, although slightly more work will allow for the curvature of the Earth. This list looks pretty comprehensive: http://www.cfdynamics.com/cfdynamics/zipbase/index.cfm and sample code http://www.zipcodeworld.com/samples/distance.vbs.txt Or look into querying a suitable website. e.g. http://www.zipinfo.com/cgi-local/zip...ip=77380&Go=Go Also, accuracy may not be that high, as zipcodes are areas, but you would have to assume a single point for calculation. There a discussion of some salient points he http://www.webmasterworld.com/forum10/6530.htm NickHK "Serissa" wrote in message ... I need to use some service to dynamically calcualte distance between two zipcodes. Do you know about anything like this? |
Is there a way to calculate distance between 2 zipcodes?
You can definately do this if you have the lat/long of the zip centroid.
There are several website that will give you that. Then you just set up a Macro in Excel to plot the distance between the 2 points. If you google Excel Distance Macro, you should find it. If not let me know and I will email you the script. Jason "Serissa" wrote: I need to use some service to dynamically calcualte distance between two zipcodes. Do you know about anything like this? |
All times are GMT +1. The time now is 07:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com