Home PageFacebookRSS News Feed
PocketGPS
Web
Read the current newsletter! Weekly
Newsletter
SatNav,GPS,Navigation
Pocket GPS World - SatNavs | GPS | Speed Cameras: Forums

Pocket GPS World :: View topic - Geocoded PostCode Database Leaked Online
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Log in for private messagesLog in for private messages   Log inLog in 

Geocoded PostCode Database Leaked Online
Goto page 1, 2, 3, 4  Next
 
Post new topic   Reply to topic    Pocket GPS World Forum Index -> News And Latest Information
View previous topic :: View next topic  
Author Message
Darren
Pocket GPS Staff
Pocket GPS Staff


Joined: 11/07/2002 14:36:40
Posts: 23846
Location: Hampshire, UK

PostPosted: Wed Sep 16, 2009 5:19 pm    Post subject: Geocoded PostCode Database Leaked Online Reply with quote

pocketgpsworld.comA database containing 1.8 million Post Codes with geocoded Lat/Lon locations and grid references has been leaked by Wikileaks, the whistleblower website.

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 might prove very useful to satnav manufacturers not that we're suggesting they would use data from an unknown source such as this!

Wikileaks are even offering the database, in all it's 100,000 page glory as a compressed 20mb file and have even seeded it via Torrent Sites. Given the dubious nature of the data and the unknown source this may be a step too far for the whistle blower premise of the web site?
_________________
Darren Griffin - Editor


Last edited by Darren on Sat Sep 19, 2009 1:52 pm; edited 1 time in total
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Wazza_G
Lifetime Member


Joined: Jan 10, 2006
Posts: 581
Location: Guildford (Regrettibly)

PostPosted: Wed Sep 16, 2009 6:24 pm    Post subject: Reply with quote

I downloaded a copy before it's removed, so should anyone want it...
Back to top
View user's profile Send private message
pcaouolte
Frequent Visitor


Joined: Dec 27, 2006
Posts: 987
Location: South Lincs, UK.

PostPosted: Wed Sep 16, 2009 6:53 pm    Post subject: 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
Back to top
View user's profile Send private message
253
Lifetime Member


Joined: Mar 05, 2007
Posts: 1054
Location: The green bit between the M40, M4 and M25.

PostPosted: Wed Sep 16, 2009 7:52 pm    Post subject: 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.
Back to top
View user's profile Send private message
navver
Regular Visitor


Joined: Dec 12, 2005
Posts: 111
Location: Chipping Sodbury

PostPosted: Wed Sep 16, 2009 8:32 pm    Post subject: 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
Back to top
View user's profile Send private message
Ray4438
Occasional Visitor


Joined: Nov 08, 2005
Posts: 3

PostPosted: Wed Sep 16, 2009 9:01 pm    Post subject: Reply with quote

Can u tell me what program opens it after un zipping it.
Back to top
View user's profile Send private message
Oldboy
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Dec 08, 2004
Posts: 10603
Location: Suffolk, UK

PostPosted: Wed Sep 16, 2009 9:06 pm    Post subject: 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 1045.10005
Back to top
View user's profile Send private message Visit poster's website
Ray4438
Occasional Visitor


Joined: Nov 08, 2005
Posts: 3

PostPosted: Wed Sep 16, 2009 9:33 pm    Post subject: Reply with quote

And how to open it?
Back to top
View user's profile Send private message
navver
Regular Visitor


Joined: Dec 12, 2005
Posts: 111
Location: Chipping Sodbury

PostPosted: Wed Sep 16, 2009 11:03 pm    Post subject: 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
Back to top
View user's profile Send private message
JockTamsonsBairn
Lifetime Member


Joined: Jan 10, 2004
Posts: 2777
Location: Bonnie Scotland (West Central)

PostPosted: Thu Sep 17, 2009 12:14 am    Post subject: 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)
Back to top
View user's profile Send private message
BigPerk
Frequent Visitor


Joined: Sep 06, 2006
Posts: 1618
Location: East Hertfordshire

PostPosted: Thu Sep 17, 2009 12:35 am    Post subject: 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)
Back to top
View user's profile Send private message
Oldboy
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Dec 08, 2004
Posts: 10603
Location: Suffolk, UK

PostPosted: Thu Sep 17, 2009 6:40 am    Post subject: 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 1045.10005
Back to top
View user's profile Send private message Visit poster's website
253
Lifetime Member


Joined: Mar 05, 2007
Posts: 1054
Location: The green bit between the M40, M4 and M25.

PostPosted: Thu Sep 17, 2009 7:24 am    Post subject: Reply with quote

I'm on a Mac, opened the file using Text Edit no problem.
Have Microsoft Excel (Office 2008), but no way could I copy across, not even when I chopped it up into what I thought were smal lumps.

Didn't have a lot of time last night, but will spend a bit longer tonight.
_________________
Triumph Tbird 1700. And now a Bonnie T100 as well.
Back to top
View user's profile Send private message
mikealder
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Jan 14, 2005
Posts: 19638
Location: Blackpool , Lancs

PostPosted: Thu Sep 17, 2009 8:36 am    Post subject: Reply with quote

I might run it through some software I have on the PC later and break it down into each County which should make the size more managable, I can also filter out those unused/ blank codes at the same time - Mike
Back to top
View user's profile Send private message Send e-mail MSN Messenger
MaFt
Pocket GPS Staff
Pocket GPS Staff


Joined: Aug 31, 2005
Posts: 14364
Location: Bradford, West Yorkshire

PostPosted: Thu Sep 17, 2009 8:53 am    Post subject: Reply with quote

mikealder wrote:
I might run it through some software I have on the PC later and break it down into each County which should make the size more managable, I can also filter out those unused/ blank codes at the same time - Mike


yay! you've finally found something of use to use that program on!!!
Back to top
View user's profile Send private message Visit poster's website







Posted: Today    Post subject: Pocket GPS Advertising

Back to top
Display posts from previous:   
Post new topic   Reply to topic    Pocket GPS World Forum Index -> News And Latest Information All times are GMT + 1 Hour
Goto page 1, 2, 3, 4  Next
Page 1 of 4

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB 2.0.11 © 2001 phpBB Group
phpBB port v2.1 based on Tom Nitzschner's phpbb2.0.6 upgraded to phpBB 2.0.4 standalone was developed and tested by:
ArtificialIntel, ChatServ, mikem,
sixonetonoffun and Paul Laudanski (aka Zhen-Xjell).

Version 2.1 by Nuke Cops 2003 http://www.nukecops.com

Make a Donation



CamerAlert Database

Click here for the PocketGPSWorld.com Speed Camera Database

Download Speed Camera Database
18.041 (01 Apr 20)



WORLDWIDE SPEED CAMERA SPOTTERS WANTED!

Click here to submit camera positions to the PocketGPSWorld.com Speed Camera Database


12mth Subscriber memberships awarded every week for verified new camera reports!

Submit Speed Camera Locations Now


CamerAlert Apps



iOS QR Code






Android QR Code







Terms & Privacy


GPS Shopping