Put
the (x,y) co-ordinates in the DB along with the location name. Latitudes and
longitudes could work. Then show everything with a radius of N degrees, or show the M
closest entries:
If I
recall,
Distance=((x2-x1)^2 + (y2-y1)^2)^(.5)
Of
course, the actual distance will only be approximate for
longitudes...
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Henning Sittler
Sent: Tuesday, May 21, 2002 12:01 PM
To: Multiple recipients of list witango-talk
Subject: Witango-Talk: DB Searches - Nearby Cotunries
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Henning Sittler
Sent: Tuesday, May 21, 2002 12:01 PM
To: Multiple recipients of list witango-talk
Subject: Witango-Talk: DB Searches - Nearby Cotunries
Any suggestions on how I can implement a database search which returns rows for not only the requested State and/or country but also rows for geographically surrounding and nearby states or countries?
I guess I could create a manually populated table of nearby states or countries (lets call them regions to be more general) for each region.
Are there any services out there which provide this kind of info? Is there a site that can offer this raw data initially? If I can get or pull this from somewhere, it would be preferred over doing things manually.
Thanks much,
Henning Sittler
www.inscriber.com
