Querying a perimeter around a Geocode-Location (Lat/Lon)

Posted by Tim on Stack Overflow See other posts from Stack Overflow or by Tim
Published on 2010-05-03T18:59:56Z Indexed on 2010/05/04 3:58 UTC
Read the original article Hit count: 213

Filed under:

latitude

|

longitude

|

google-maps

|

geocode

|

distance

Hi,

how can I search for geo-objects in a certain perimeter ? E.g. I have several objects with Lat/Lon coordinates stored in my DB. Now I want to retrieve all the objects which lie in a specific perimeter (10 miles or 20 miles) around a given point.

I guess what I would have to do is to form some query like:

SELECT * FROM objects o where o.lat < (myPositionLat+x) AND o.lon < (myPositionLon+y)

Is this right? How do I determine/set the values for x and y?

© Stack Overflow or respective owner

Related posts about latitude

With the New Google Latitude API, Build Latitude and Location Into Your App

as seen on Google Code - Search for 'Google Code'
Location, location, location . In case you haven’t noticed, we’re really excited about all the ways location can make mobile apps and websites more useful. With Google Latitude... >>> More
PCMCIA Does Not Work on Dell Latitude under Windows XP

as seen on Super User - Search for 'Super User'
PCMCIA cards do not work on Dell Latitude e5510 under Windows XP. Works fine on Windows 7. Cards are recognized by Device Manager but do not work correctly. For example, CF adapter does not recognize when a card is inserted and network card is unable to obtain an IP address. Other systems that… >>> More
Zoom to fit region for all annotations - ending up zooming in between annotations

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey everybody!! I have a problem with fitting all my annotations to the screen... sometimes it shows all annotations, but some other times the app is zooming in between the two annotations so that none of them are visible... I want the app to always fit the region to the annotations and not to zoom… >>> More
Bluetooth drivers for Dell Latitude D830

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
I haven’t been using Bluetooth on my D830 before but now I got myself a Bluetooth mouse in order to get rid of the receiver for a wireless mouse. And then I discovered that Bluetooth did not work anymore after I installed Win7. Browsing Dell support pages for a a driver found me one (browsing by… >>> More
Determine if a point is inside a triangle formed by 3 points with given latitude/longitude

as seen on Stack Overflow - Search for 'Stack Overflow'
I have 3 points ( lat , lon ) that form a triangle.How can i find if a point is inside this triangle? >>> More

Related posts about longitude

Zoom to fit region for all annotations - ending up zooming in between annotations

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey everybody!! I have a problem with fitting all my annotations to the screen... sometimes it shows all annotations, but some other times the app is zooming in between the two annotations so that none of them are visible... I want the app to always fit the region to the annotations and not to zoom… >>> More
Fastest distance lookup given latitude/longitude?

as seen on Stack Overflow - Search for 'Stack Overflow'
I currently have just under a million locations in a mysql database all with longitude and latitude information. With this I use another lat/lng to find the distance of certain places in the database but it's not as fast as I want it to be especially with 100+ hits a second. Is there a faster formula… >>> More
Determine if a point is inside a triangle formed by 3 points with given latitude/longitude

as seen on Stack Overflow - Search for 'Stack Overflow'
I have 3 points ( lat , lon ) that form a triangle.How can i find if a point is inside this triangle? >>> More
geo-indexing: efficiently calculating proximity based on latitude/longitude

as seen on Stack Overflow - Search for 'Stack Overflow'
My simple web app (WSGI, Python) supports text queries to find items in the database. Now I'd like to extend this to allow for queries like "find all items within 1 mile of {lat,long}". Of course that's a complex job if efficiency is a concern, so I'm thinking of a dedicated external module that… >>> More
how to find latitude longitude from the address?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using MapKit for google map?How to find latitude longitude using address? >>> More