> 1. You are in Illinois and your location is XYZ (longitudes and latitudes);
> 2. Our database has a list of businesses in Illinois, with different
> longitudes and latitudes;
> 3. You want to look up OUR database for all the locations that are near YOU
> within a radius of 5 Kilometers;
> 4. The results will be returned to another database on the fly.
>
> Is it possible to do this? If it is, then how can we do this and what is the
> most efficient method of doing this?
Yes, it's possible. There are at least two different tasks, now that
the question is growing.
Capturing lat/longs at entry into your database - as already suggested
and exampled, provide a geocoding tool so that your data enterers can
enter an address, get an automatic best-guess, offer some did-you-mean
choices if appropriate, adjust if needed and finally submit to your
database.
http://econym.org.uk/gmap/didyoumean.htm
If you haven't seen the rest of that tutorial, give it a look.
End-user searching, based on an address they type - geocode that, use
some did-you-mean if the results aren't clear, and use it to search
your db by radius or bounds.
The classic example -
http://code.google.com/support/bin/answer.py?answer=87134&topic=11364
All the parts are well known, you just have to tailor them to your
needs.
cheers, Ross K
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Maps API" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Google-Maps-API?hl=en
-~----------~----~----~----~------~----~------~--~---