Home -> Usenet -> comp.databases.theory -> Geographic proximity determination...

Geographic proximity determination...

From: Ray <iguana_at_one.net>
Date: Sat, 16 Sep 2000 06:56:14 -0400
Message-ID: <39C351CE.46D00FA5_at_one.net> 







Howdy all...



    I've got a design problem...



    I need to create a database of address information.  When this
database is searched for a location in, say Loveland, if the location
doesn't exist in Loveland but a similar one exists in Indian Hill it
should suggest it before it suggests a location in, say, Fort Thomas, KY



(which is further away from Loveland than is Indian Hills for all you
non-Cincinnatians...).



    Does anyone have any clue how to go about getting this information
or encoding it in a database in a reasonable fashion?



I was thinking something about begin able to use a coordinate system,
but that seems like a pain...  I'll be using a MySQL database and PERL
to design the site...  So just about any acrobatics to get the
information is do-able...



    Any insight on this problem is greatly appreciated.



        Ray.
Received on Sat Sep 16 2000 - 12:56:14 CEST












Original text of this message