473,320 Members | 1,914 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Postcode Distance System

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
4 1608
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
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

"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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Nazir | last post by:
Hi - I know this isn't really a specific SQL Server question but I can't think of a better forum. I want to implement a more sophisticated UK postcode search on a site - "LIKE 'NW%'" etc, is not...
0
by: bungle | last post by:
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...
2
by: Samuel Shulman | last post by:
Hi I need to measure the distance using 2 postcodes (UK) How can that be done? Thank you, Samuel
12
by: xhe | last post by:
I am now developing a website which needs Canadian PostCode Database. I can certainly buy one, but that will cost my hundered of $$, and my website is only for education purpose, it won't make...
5
by: billynastie2007 | last post by:
Hi i am writing a balloon race site and i am having problems with some functions to calculate the distance the balloon travels firstly i am reading my info from the database using the fetch assoc...
0
by: Pinna | last post by:
Hiya, I am trying to select based on a range on postcode on a table. The field POSTCODE is a varchar2(8). The problem is when refinng on 'where postcode between 'PE1' and 'PE29'', because this is...
1
by: tiffrobe | last post by:
I'm a little lost on my program. Everything works fine except function 3. It gives out garbage numbers. Its suppose to give the distance between two points and then the area of 2 circles. ...
3
AdamHope
by: AdamHope | last post by:
I am looking to set up some rate tables in MS Access database. I have been banging my head for a few days now. I will try and explain this as best i can. The main table is where jobs are put...
2
by: Craig Riches | last post by:
I have a database to work out delivery costs for our company. Everything is automated except the fuel costs. I am trying to work out if i could use code to work the distance bewteen each postcode...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.