By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,435 Members | 2,036 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,435 IT Pros & Developers. It's quick & easy.

Postcode Distance System

P: n/a
Hi

I want to add functionality to my site so that customers can type in a
postcode and we can tell them the "nearest store" in our database.

I have noticed there are loads of sites on the net that offer this
service but some of the them are small back bedroom sites. Do they
really pay for the expensive postcode data or is there an alternative
method you can use with some additional coding??

Any suggestions would be great.

Thanks

Jul 28 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
I wonder if they just put in ranges of codes that apply to a particular
store. Or, maybe even for each one, what the closest store is (that's a lot
of work though). If they only have a few locations, then it might even be
more of identifying the right state for the code.

"Dave" <bu****@wizardbuy.comwrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...
Hi

I want to add functionality to my site so that customers can type in a
postcode and we can tell them the "nearest store" in our database.

I have noticed there are loads of sites on the net that offer this
service but some of the them are small back bedroom sites. Do they
really pay for the expensive postcode data or is there an alternative
method you can use with some additional coding??

Any suggestions would be great.

Thanks

Jul 28 '06 #2

P: n/a
Dave,
With US zip codes, usually this is done with a zip code database that holds
the approximate longitude and latitude coordinates for each zip code. Then a
distance computation is made to get a radius, and all "Stores" within this
radius are searched for in the store database. The process would be similar
with postcodes from Canada, UK, etc.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Dave" wrote:
Hi

I want to add functionality to my site so that customers can type in a
postcode and we can tell them the "nearest store" in our database.

I have noticed there are loads of sites on the net that offer this
service but some of the them are small back bedroom sites. Do they
really pay for the expensive postcode data or is there an alternative
method you can use with some additional coding??

Any suggestions would be great.

Thanks

Jul 28 '06 #3

P: n/a

"Dave" <bu****@wizardbuy.comwrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...
Hi

I want to add functionality to my site so that customers can type in a
postcode and we can tell them the "nearest store" in our database.

I have noticed there are loads of sites on the net that offer this
service but some of the them are small back bedroom sites. Do they
really pay for the expensive postcode data or is there an alternative
method you can use with some additional coding??
The trick is to get your hands on one of the postal codes databases.

Containing the langtitudes and the longtitudes for the postalcode then the
implementation of which store is closest is quite trivial ,for Holland we
have a postal service which has a monopoly so it's easy to get the data.
Not sure where to get the data for other countries I can even imagine that
for some countries this information can be found on the internet.
Jul 28 '06 #4

P: n/a
Mischa Kroon schreef:
for Holland we
have a postal service which has a monopoly so it's easy to get the data.
Not sure where to get the data for other countries I can even imagine that
for some countries this information can be found on the internet.
Mischa, could you help me out with this one ? I'm also looking for a
database with long/lat/zip/city of holland, belgium, luxemburg, france
and germany. Allready found one of belgium and france.
A link to the holland database perhaps ??

Jul 31 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.