Hi,

I am creating an application with Geo Proximity Search capability
using PHP as server scripting language and MySQL as Databse.

Consider a situation:

Where we have certain set of objects having latitude and longitude
positions assosciated with respective objects. On specifying location
details like country and/or city along with range/radius in KM we are
getting objects that are lying withing that radius/range using MySQL
query for example:

"SELECT [columns] FROM [column] WHERE 1=1 AND 3963.191 * ACOS((SIN(PI
() * [latitude] / 180) * SIN(PI() * [column].latitude / 180)) + (COS
(PI
() * [latitude] /180) * cos(PI() * [column].latitude / 180) * COS(PI()
* [column].longitude / 180 - PI() * [longitude] / 180)) ) <= 10"

Above calculations will give the objects that are within the 10 KM
area from the country/city center point on earth.

For e.g. i wanna to find out all the stores which resides in Amsterdam
for instance ( without specifying any radius limit).

The application should find out all the stores that are located in
Amsterdam, also the stores which are not exactly located in Amsterdam
but nearby having service range up to Amsterdam.

I am maintaining these stores along with lat/lng position and with/
without service range.

Anybody help me find out solution?


--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to