Re: Q: Nearest Post Office Problem - Any leads?????
Date: 1995/12/08
Message-ID: <4a9ge1$svc_at_maverick.tad.eds.com>#1/1
In article <49mq2r$fd2_at_gaia.cc.gatech.edu>, badri_at_cc.gatech.edu says...
>Given a zipcode, I should show the nearest postoffice. Assume that
>some zipcodes do not have post offices and so I will have to calcualate
>the distance between a zipcode and all postoffices nearby to get the
>closest. One way I think is to get the geographical distance using the
>earth's radius of curvature, latitude and longitude, etc. This seems
>to be accurate, but I thought I would save some time if I asked the
>pros out here whether I have some skeleton program that I can use to
>start from. I have to eventually implement it in Oracle, but I would
>start with what I get!
>
I know that there are quite a few tables/databases/whatever out there with zip code and city references. possibly instead of calculating out by distance where the closest post office is you just start with one of these tables and add another column with the address (or whatever) of the closest post office. since the post office or the zip code areas usually don't change on a day to day basis it should remain accurate. Received on Fri Dec 08 1995 - 00:00:00 CET