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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
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/[EMAIL PROTECTED]
