We've done this using US ZIP codes and it isn't that hard. Basically, we purchased a database off the web including columns for city, state, zip, longitude, and latitude (appx $100 USD). With this came instructions on how to use longitude and latitude to calculate the distance between locations.
I've included a stripped down version of the file with the essential
information. There were three different calculations based on how precise
the distance requirements were. I believe this is the most precise and also
the most difficult.
Two databases were used. A "locator" database and a "store" database.
Hope this helps.
Chris
> I asked:
>
>> Has anyone written a TAF to calculate distances between two UK postcodes and,
>> if so, would they like to share it?
>
> As it seems no-one has, does anyone have a TAF to calculate distance from
> Northings and Eastings? I can look these up from a table of Postcodes
>
> There are ASP and PHP apps around to do this job, but I use neither and don't
> particularly want to bolt one of these apps on - or try and revesrse engineer
> one
>
>
> How are you all doing distance calculations?
>
> ________________________________________________________________________
> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
> with unsubscribe witango-talk in the message body
>
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
zipfinder.taf
Description: application/applefile
zipfinder.taf
Description: Binary data
