DB Searches - Nearby CotunriesJust to mention that is also a nice idea for managing geographical infos!
Thanks Gauthier ----- Original Message ----- From: Anthony M. Humphreys To: Multiple recipients of list witango-talk Sent: Tuesday, May 21, 2002 7:50 PM Subject: RE: Witango-Talk: DB Searches - Nearby Countries 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 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 ______________________________________________________________________________ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
