Home PageFacebookRSS News Feed
PocketGPS
Web
Read the current newsletter! Weekly
Newsletter
SatNav,GPS,Navigation
Get Speed Camera Warnings For SatNavs Get Speed Camera Warnings For Android Get Speed Camera Warnings For iPhone
Geocoded PostCode Database Leaked Online


Article by: Darren Griffin
Date: 16 Sep 2009

pocketgpsworld.comA database containing 1.8 million Post Codes with geocoded Lat/Lon locations and grid references has been leaked on-line by Wikileaks.

The source of the 240mb file is unclear but it does not contain any names or addresses unlike the full Royal Mail PostCode Address File (PAF).

There have been many calls for the PAF data to be made available by businesses and freedom of information campaigners. The Royal Mail charge a hefty licence fee for access to the database containing the full name and address information but even this cut down version could prove very useful to satnav manufacturers not that we're suggesting the would use data from a source such as this!

Wikileaks helpfully offer the database, in all it's 100,000 page glory as a compressed 20mb file and have even seeded it via Torrent Sites.

Comments
Posted by Wazza_G on Wed Sep 16, 2009 5:24 pm Reply with quote

I downloaded a copy before it's removed, so should anyone want it...


Be alert.. This country needs more lerts.

 
Posted by pcaouolte on Wed Sep 16, 2009 5:53 pm Reply with quote

Downloaded it Very Happy

Now I just need to work out how to convert 1.8million locations into a POI file that I can use with a satnav. Confused


Paul

 
Posted by 253 on Wed Sep 16, 2009 6:52 pm Reply with quote

Yep, downloaded it as well.

Have no idea what I'm going to do with it though.
Probably delete it in three months time like the rest of the stuff that seems like a good idea at the time, but just clutters up the place.


Triumph Tbird 1700. And now a Bonnie T100 as well.

 
Posted by navver on Wed Sep 16, 2009 7:32 pm Reply with quote

I guess you'd need to load it into Excel, then remove all the unwanted fields by deleting columns, then save it as a .TXT file.
Then load into POIEDIT then save in the format you want to use eg Tomtom OV2.


Tomtom Go520, App 8.010, Map UK&ROI 810.1870

 
Posted by Ray4438 on Wed Sep 16, 2009 8:01 pm Reply with quote

Can u tell me what program opens it after un zipping it.


 
Posted by Oldboy on Wed Sep 16, 2009 8:06 pm Reply with quote

I don't know if the later versions of Excel can handle 1.8 million rows but previous versions could only load 65,535 Sad

It's not only the excess columns that need removing, there's also the problem of blank cells where the lat/long has not been provided. Presumably due to that particular Postcode not being used.


Richard

TT 910 V7.903 (9183/081205) OS:2344
Europe version 975.7689

 
Posted by Ray4438 on Wed Sep 16, 2009 8:33 pm Reply with quote

And how to open it?


 
Posted by navver on Wed Sep 16, 2009 10:03 pm Reply with quote

I managed to open it with wordpad. Not sure if that will add format characters.

I had a postcode POI for my Mavman 635. That was split into many different files, broken down by area such as "Southwest" and each area was split into 2 or 3 files.

You could do the same in word pad, then load into excel, unless someone can write a utility to remove the unwanted columns.


Tomtom Go520, App 8.010, Map UK&ROI 810.1870

 
Posted by JockTamsonsBairn on Wed Sep 16, 2009 11:14 pm Reply with quote

Oldboy Wrote:
I don't know if the later versions of Excel can handle 1.8 million rows but previous versions could only load 65,535 Sad

It's not only the excess columns that need removing, there's also the problem of blank cells where the lat/long has not been provided. Presumably due to that particular Postcode not being used.
I'm sure Dennis will be along shortly to recommend Lotus 123 Laughing


Jock

TomTom Go 940 LIVE (9.510, Europe v915.5074 on SD & 8.371, WCE v875.3613 on board)

 
Posted by BigPerk on Wed Sep 16, 2009 11:35 pm Reply with quote

navver - interested in your comment about txt files and POIEdit. Unfortunately I'm not very clued up on POIEdit, so I (thought I) had a problem when I was trying to use a txt file output from OpenOffice because POIEdit didn't show txt as an input file type option, so I assumed I couldn't use it. (I wanted to convert to asc).

Can you enlighten me please Sad ?


David
(Navigon 70 Live, Nuvi 360)

 
Posted by Oldboy on Thu Sep 17, 2009 5:40 am Reply with quote

BigPerk Wrote:
..... (I wanted to convert to asc).

Can you enlighten me please Sad ?
Just change the 3 letter extension from .txt to .asc


Richard

TT 910 V7.903 (9183/081205) OS:2344
Europe version 975.7689

 
Click here to view more comments...
Reply to topic

CamerAlert Apps



iOS QR Code






Android QR Code







Terms & Privacy

GPS Shopping