Re: Geographic proximity determination...

In article <39C351CE.46D00FA5_at_one.net>, Ray <iguana_at_one.net> writes
>
>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

You need data that's indexed by something that correlates well with physical location. If you can't get XY coordinates then the next best thing would be Zip codes.

You should be able to get coordinates for locations but you might have to pay.

For instance here in the UK I can get a grid-reference for every UK postcode, accurate to within a few metres. If I have two postcodes I can measure the distance between them using Pythagoras' theorem.

-- 
Bernard Peek
bap_at_shrdlu.com
bap_at_shrdlu.co.uk