MySQL ODBC Connector - UK Postcodes

Author

UK Postcodes

Mike Blezien

2006-01-07, 1:23 pm

Hello,

we are working with a database that stores UK postcodes, which are different
then US zipcodes. I've found alot of information for working with zipcodes,
locating closed distances within a zipcode range, but haven't found anything
regarding working with UK type postcodes.

Was hoping someone on the list may have worked with UK postcodes and may have
some info on the best way to query these postcodes for locating closed location,
distances,.etc?

thx's

--
Mike(mickalo)Blezien

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://thunder-rain.com/
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

sheeri kritzer

2006-01-24, 8:23 pm

Hi Mike,

Sorry for the late reply. The company I work for has this very same
problem -- we are a multi-national personal ad site, where members can
search for other members close to them.

The answer is, unfortunately, you have to acquire one database with
postcodes, and another with longitudes and latitudes, and merge them
together. We spent a lot of time finding that answer, and when we
did, it wasn't cheap.

Sorry for the bad news.

-Sheeri Kritzer

On 1/7/06, Mike Blezien <mickalo@frontiernet.net> wrote:
> Hello,
>
> we are working with a database that stores UK postcodes, which are differ=
ent
> then US zipcodes. I've found alot of information for working with zipcode=
s,
> locating closed distances within a zipcode range, but haven't found anyth=
ing
> regarding working with UK type postcodes.
>
> Was hoping someone on the list may have worked with UK postcodes and may =
have
> some info on the best way to query these postcodes for locating closed lo=
cation,
> distances,.etc?
>
> thx's
>
> --
> Mike(mickalo)Blezien

> =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=
=3D-=3D
> Thunder Rain Internet Publishing
> Providing Internet Solutions that work!
> http://thunder-rain.com/
> =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=
=3D-=3D
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql? unsub...mail
.com
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Rhino

2006-01-24, 8:23 pm

You'd think that the people who run the post office in the UK - British
Telecom?? - would have had a number of enquiries from people who wanted to
match postal codes with latitude and longitude. That would tend to give them
a natural incentive to provide such information, all nicely integrated,
possibly for a fairly affordable price.

Any idea what would prevent the post office from doing that?

Rhino

----- Original Message -----
From: "sheeri kritzer" <awfief@gmail.com>
To: <mickalo@frontiernet.net>
Cc: "MySQL List" <mysql@lists.mysql.com>
Sent: Tuesday, January 24, 2006 3:31 PM
Subject: Re: UK Postcodes

Hi Mike,

Sorry for the late reply. The company I work for has this very same
problem -- we are a multi-national personal ad site, where members can
search for other members close to them.

The answer is, unfortunately, you have to acquire one database with
postcodes, and another with longitudes and latitudes, and merge them
together. We spent a lot of time finding that answer, and when we
did, it wasn't cheap.

Sorry for the bad news.

-Sheeri Kritzer

On 1/7/06, Mike Blezien <mickalo@frontiernet.net> wrote:
> Hello,
>
> we are working with a database that stores UK postcodes, which are
> different
> then US zipcodes. I've found alot of information for working with
> zipcodes,
> locating closed distances within a zipcode range, but haven't found
> anything
> regarding working with UK type postcodes.
>
> Was hoping someone on the list may have worked with UK postcodes and may
> have
> some info on the best way to query these postcodes for locating closed
> location,
> distances,.etc?
>
> thx's
>
> --
> Mike(mickalo)Blezien

> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Thunder Rain Internet Publishing
> Providing Internet Solutions that work!
> http://thunder-rain.com/
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=awfief@gmail.com
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...ati
co.ca

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.14.22/238 - Release Date: 23/01/2006

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.14.22/238 - Release Date: 23/01/2006

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

James Harvard

2006-01-24, 8:23 pm

It's the Royal Mail. Ordnance Survey, the government mapping agency for the UK, are in on it too.

To read their web site (as I have done a couple of years ago, and just now too) you would think it had never occurred to them that people might want to deploy the data as part of a web site. It's all about licensing the data by the number of 'terminals'.
Extraordinary.

Their prices are fairly extraordinary too.

I've always meant to write and complain to Royal Mail, Ordnance Survey, the RM's independent regulator and anyone else I could think of about this inflated, monopoly pricing which can only be hindering UK businesses from developing localised on-line servi
ces.

</rant>

James Harvard

At 4:00 pm -0500 24/1/06, Rhino wrote:
>You'd think that the people who run the post office in the UK - British Telecom?? - would have had a number of enquiries from people who wanted to match postal codes with latitude and longitude. That would tend to give them a natural incentive to provide
such information, all nicely integrated, possibly for a fairly affordable price.
>
>Any idea what would prevent the post office from doing that?
>
>Rhino

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Michael Stearne

2006-01-25, 3:26 am

On 1/24/06, James Harvard <james.lists.tech@harvard-digital.co.uk> wrote:
> It's the Royal Mail. Ordnance Survey, the government mapping agency for t=
he UK, are in on it too.
>
> To read their web site (as I have done a couple of years ago, and just no=
w too) you would think it had never occurred to them that people might want=
to deploy the data as part of a web site. It's all about licensing the dat=
a by the number of 'terminals'. Extraordinary.
>
> Their prices are fairly extraordinary too.
>
> I've always meant to write and complain to Royal Mail, Ordnance Survey, t=
he RM's independent regulator and anyone else I could think of about this i=
nflated, monopoly pricing which can only be hindering UK businesses from de=
veloping localised on-line services.
>

I guess we'll wait until Google or Yahoo gets them online. :-) We
only need to do 1 lookup for the address for each listing and store it
in our database so hopefull they'll offer it in the UK like Yahoo
Local does for the U.S.

Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links