Re: Calculations based on zip code

["Roger Harman" <RHarman@xxxxxxxxxx>]

If you're looking for cheap.....

You can get a Zip Code database from ZipCodeWorld.com  It has latitude &
longitude among many other pieces.  From the lat/lon, you can calculate
distance.

Help Systems Sequel has a function that does this but the algorithm is
readily available.  I used Sequel with that database to get our
Marketing folks some info on customers within a N-mile radius of our
various facilities.  Worked great.

> > > dilbernator@xxxxxxxxx 11/11/2009 2:34:08 PM >>>
Alan,

Zip code does not equal a post office.  Some buildings in NYC have their
own
zip code because they have so many addresses to deliver to.

I 2nd Rob's thought.  In my former company we used WorksRight software
to
validate zip codes and addresses.  They were always good to work with. I
am
a satisfied former customer.  I would/will choose them again if the
right
requirements come up.

Jim

On Wed, Nov 11, 2009 at 2:51 PM, Alan Shore <AlanShore@xxxxxxxx> wrote:

> Hi everyone
> I have a couple of problems/challenges/situations that I hope someone
can
> point me in the right direction
>
> Challenge 1 :   Calculate the number of miles between 2 zip codes.
>                As the zip code pertains to a post office (I think),
what is
> required is the distance between each post office as the crow flies
>                Now I'm sure that I came across something to do with
this
> actual situation for the AS/400 many, many, many moons ago, but I
cannot
> find it
>
> Challenge 2.    List the zip codes within a certain radius near one
> particular zip code (The radius can change)
>
>
>
> As always, any leads MUCH appreciated
>
>
>
> Alan Shore
> Programmer/Analyst, Distribution
> E:AShore@xxxxxxxxxxx <E%3AAShore@xxxxxxxxxxx>
> P:(631) 200-5019
> C:(631) 880-8640
> "If you're going through Hell, keep going" - Winston Churchill
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.