Complete UK Postcode Database on Wikileaks

[BlackenedBiker]

Excellent - now if somebody here could just pop that into a MapInfo table for me it would be much appreciated...Ta!

Nice helmet...Astro/J?????

[Moscow Mule]

I've plotted all 1.8 million postcodes in that file on a map. Very pretty.

http://img21.imageshack.us/img21/2605/postcodes.jpg

Spot the national parks - cool...

[TimberWolf]

Out of interest, what are the ones that are in the sea (1 off SW coast of Ireland, one SW of Scilly)?

Bugs in the database by the looks of it. The one off Scilly corresponds to a dozen postcodes near BD985YA in the file with a latitude and longitude of 49.766731, -7.55729. I haven't checked the other one, as I haven't created a reverse search yet and I'm laboriously binary chopping the data manually to find them. There also appear to be something like 200,000 postcodes on the file with no (i.e. 0,0) latitude and longitude at all. Still, it is free

[Spacecadet]

There also appear to be something like 200,000 postcodes on the file with no (i.e. 0,0) latitude and longitude at all. Still, it is free

Those will be the non-geographically tied postcodes
Try reading the thread

[TimberWolf]

Those will be the non-geographically tied postcodes
Try reading the thread

Based on small a random sample, the postcodes appear to be 'geographically tied' in Google maps no problem.

[Spacecadet]

Based on small a random sample, the postcodes appear to be 'geographically tied' in Google maps no problem.

Look closely, you'll see why assigning them geographical values in the PZONE file is nonsense

[TimberWolf]

Look closely, you'll see why assigning them geographical values in the PZONE file is nonsense

Do you recall how many were geographically untied in your paid for version?

[Spacecadet]

Do you recall how many were geographically untied in your paid for version?

about the same as in the version you have

The PZONE file is used for mapping postcodes to statistical regions. It is NOT an address file.
There are plenty of postcodes which one one reason or another need to be excluded from these statistical regions. Most commonly it's because the postcode relates to a postbox.

Like I said, look closely. Take one of your postcodes which google maps finds but is listed without a lat/long. Stick it in google maps, switch on the satelite view and zoom in.
Then tell me what is common amongst the vast majority of those postcodes

[Muttley08]

I work in this area - and guessing if there are statistical boundaries on there, I know where this has come from...if I'm right they re-sell this data for quite a lot of money..

Update - Just opened it...looks like too many NHS identifiers to be who I thought it was - and most UK mainland orgs don't use Lat / Long

[TimberWolf]

about the same as in the version you have

The PZONE file is used for mapping postcodes to statistical regions. It is NOT an address file.
There are plenty of postcodes which one one reason or another need to be excluded from these statistical regions. Most commonly it's because the postcode relates to a postbox.

Like I said, look closely. Take one of your postcodes which google maps finds but is listed without a lat/long. Stick it in google maps, switch on the satelite view and zoom in.
Then tell me what is common amongst the vast majority of those postcodes

Based on a small sample size, big buildings by the looks of it.