Find the closest locations to a given address

Posted by xtine on Stack Overflow See other posts from Stack Overflow or by xtine
Published on 2010-04-29T09:59:55Z Indexed on 2010/04/29 10:37 UTC
Read the original article Hit count: 197

Filed under:

geolocation

|

distance

|

cakephp

|

mysql

|

php

I have built an application in CakePHP that lists businesses. There are about 2000 entries, and the latitude and longitude coordinates for each business is in the DB.
I now am trying to tackle the search function.

There will be an input box where the user can put a street address, city, or zipcode, and then I would like it to return the 11 closest businesses as found from the database.

How would I go about doing this?

© Stack Overflow or respective owner

Related posts about geolocation

Which Devices Support Javascript Geolocation via navigator.geolocation ?

as seen on Stack Overflow - Search for 'Stack Overflow'
The iPhone supports geolocation in mobile Safari via the following call: navigator.geolocation.getCurrentPosition( function(pos){ var lat = pos.coords.latitude; var long = pos.coords.longitude; }, function(){ /* Handler if location could not be found */ } ); I'd like to build… >>> More
iPhone - Native App GeoLocation VS Web App GeoLocation

as seen on Stack Overflow - Search for 'Stack Overflow'
Here's my situation; I've built a very simple web app that looks up a users location and plots it on a Google map. Here's my code: http://pastebin.com/d3a185efd When I test it, my location is detected as being = 500 meters from where I actually stand. BUT When I open up Google Maps or Gowalla… >>> More
user disallowed geolocation - notify user second time

as seen on Stack Overflow - Search for 'Stack Overflow'
When trying to get geolocation on iPhone the first time - I declined. Every other time I want to get the location (before another reload of the page) I get no response (no error and no success): navigator.geolocation.getCurrentPosition( function (location) { ig_location.lat = location… >>> More
How to get my geolocation in bash

as seen on Stack Overflow - Search for 'Stack Overflow'
I am looking for a good geolocation api to use from bash. I want this call to return at the very minimum the name of the city I am in, and the state. I imagine that there must be some site I can curl, or some scripting language that has a package that works. The machine does not have a GPS, but it… >>> More
Geolocation Firefox accurate than iPhone Safari?

as seen on Stack Overflow - Search for 'Stack Overflow'
I just tested Geolocation on Firefox 3.6 and iPhone Safari (os 3.1.3), the result is interesting, firefox is more accurate than safari. any one got idea how to make iPhone Safari result more accurate. this is the code for testing: navigator.geolocation.getCurrentPosition(handler, {enableHighAccuracy:… >>> More

Related posts about distance

Basic Spatial Data with SQL Server and Entity Framework 5.0

as seen on West-Wind - Search for 'West-Wind'
In my most recent project we needed to do a bit of geo-spatial referencing. While spatial features have been in SQL Server for a while using those features inside of .NET applications hasn't been as straight forward as could be, because .NET natively doesn't support spatial types. There are workarounds… >>> More
WPF drag distance threshold

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a program with two WPF treeviews that allow dragging and dropping between the two. The problem is, it can be annoying to open / close items on the treeviews because moving the mouse just one pixel while holding the left mouse button triggers the drag / drop functionality. Is there some way… >>> More
Distance Algorithm used in SQL2008 for Geography Data Types

as seen on Stack Overflow - Search for 'Stack Overflow'
I am wanting to know what Algorithm SQL2008 uses when computing distance on Geography Data Types. There are several such Algorithms as the Haversine and Vincenty, however I have found no references for what SQL2008 is actaully using. >>> More
Optimising SQL distance query

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm running an MySQL query that returns results based on location. However I have noticed recently that its really slowing down my PHP app. I used CodeIgniter and the profiler shows the query taking 4.2seconds. The geoname table has 500,000 rows. I have some indexes on the key columns, how else can… >>> More
Google Maps distance to sea coast

as seen on Stack Overflow - Search for 'Stack Overflow'
Given just one point in Google Maps, is there anyway to know the distance to the nearest point in the coast (that is the minimun distance to the sea), and which point in the coast it is? Thanks in advance. >>> More