I'm trying to work out if this is feasible:
I have a database of businesses, with their postcodes
I want to find the nearest business from a post coded entered by the user.
The only way i can think of is, querying multimap.com with the user inputted postcode and retrieving the
Lat: 52:57:15N (52.9541) Lon: 1:08:23W (-1.1397) values and comparing them somehow to other lat lon values held in the database.
Any suggestions/comments?
Applications such as microsoft autoroute and mappoint store their postcode data on the hard drive, I might be able to program an addin for either of these, but I don't really want to rely on other software.
Also, is there any better reference for post code data, i will need a numerical way of comparing still, like multimaps lat-lon values?
I have a database of businesses, with their postcodes
I want to find the nearest business from a post coded entered by the user.
The only way i can think of is, querying multimap.com with the user inputted postcode and retrieving the
Lat: 52:57:15N (52.9541) Lon: 1:08:23W (-1.1397) values and comparing them somehow to other lat lon values held in the database.
Any suggestions/comments?
Applications such as microsoft autoroute and mappoint store their postcode data on the hard drive, I might be able to program an addin for either of these, but I don't really want to rely on other software.
Also, is there any better reference for post code data, i will need a numerical way of comparing still, like multimaps lat-lon values?