Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post May 08, 2012 03:06 PM by bruce (sqlwork.com)
May 08, 2012 01:36 PM|LINK
I am in a process of making a job portal for UK job market.
I can see that lot current of the job portals have search criteria "Location" (say "London").
Also user can input distance (radius) in mile (say 5 miles).
And on submit, it will return all jobs within 5 miles radius of London.
Can any one please guide me how i can achieve it.
May 08, 2012 01:56 PM|LINK
record cities and relative distances from the biggest location.
May 08, 2012 02:10 PM|LINK
To achive that , a zipcode database is used. either you can collect the data by youself, frind a free version or purchase it for a fix price. You can google/bing it by the keyword "UK zip code database"
May 08, 2012 03:06 PM|LINK
this is done with a geolocation database. you have a database of locations (city, often to street level) of the longitude and latitude o each location. then its simple math to calc the radius. most modern database have geolocation builtin now, and you can
buy the data.