Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The proximity search
Message
From
23/03/2009 03:44:35
 
 
To
23/03/2009 02:51:01
General information
Forum:
ASP.NET
Category:
Other
Environment versions
Environment:
VB 9.0
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01390509
Message ID:
01390510
Views:
60
>On Web sites where the user has to enter his postal code or zip code in his profile, this is often used for the proximity search. On a Web site I am hosting, I need to provide that type of search. So, a user could search for people around him within a 50km radius. I believe this is often related to a numeric ID associated to the postal code or to the zip code. Otherwise, the only other thing I would see would be to use the IP address, but then, this is no longer valid is the user is traveling.
>
>So, basically, is there some kind of table that exists for that or how does that work exactly?

Hi,

You'll obviously need a database that maps post or zip codes to a coordinate system (probably lat/long). Available from several sources depending on the countries you are interested in. Algorithems for compuing distance between coordinate pairs are also widely documented.

Here's one possible provider:http://www.geopostcodes.com.
Pricing seems reasonable and I liked the fact that 'Vatican City' is free (but there's only one postcode).

HTH,
Viv
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform