"Postcode" distances
Posted: Thu Jun 23, 2005 6:35 am
Not sure where to post this so I thought I'd ask for ideas here..
We have a potential requirement to have a database (postgres) full of postcodes (including Latitude/Longditude etc) so distances between 2 postcodes can be calculated using basig trig. Every user of the site would have their "position" stored.
The question is how to store data efficiently to enable a user to see all "postcodes" within a certain radius yet allow scalability as to the number of users ? The "radius" would be modifiable by the user and needs to be calculated on a real time basis.
If anyone has any ideas I would appreciate it, although I will be investigating myself... Now where is Google
We have a potential requirement to have a database (postgres) full of postcodes (including Latitude/Longditude etc) so distances between 2 postcodes can be calculated using basig trig. Every user of the site would have their "position" stored.
The question is how to store data efficiently to enable a user to see all "postcodes" within a certain radius yet allow scalability as to the number of users ? The "radius" would be modifiable by the user and needs to be calculated on a real time basis.
If anyone has any ideas I would appreciate it, although I will be investigating myself... Now where is Google