Re: locations near you?

[<Matt.Haas@xxxxxxxxxxx>]

John,

Do you have the latitude and longitude values of each of your locations?
If so, the math is explained pretty well at
http://www.darkshire.org/~jhkim/public_html/programming/zipcodes/math.ht
ml. If you need the latitude and longitude values, you can get a zip
code level list at http://www.zipcodedownload.com/. This site also has
sample code but not in RPG or SQL.

Matt

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of SirJohn
Sent: Sunday, June 03, 2007 5:05 PM
To: web400@xxxxxxxxxxxx
Subject: [WEB400] locations near you?

Greetings,
I am looking at some app that will show all the locations near a
starting
point. I mean, here is my address, find all the iSeries user groups that
are
within 50 miles of me.  I have searched, googled and it appears that I
should of paid more attention in math class.  I found that lat and lon
and
sin and cos are big in this.

Does anyone have something in RPG or SQL on the iSeries that will do
this?

Tia,
John