Home PageFacebookRSS News Feed
PocketGPS
Web
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 Previous  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
NickG
Frequent Visitor


Joined: Nov 09, 2003
Posts: 357
Location: UK

PostPosted: Fri Sep 18, 2009 10:50 am    Post subject: Reply with quote

OK I give up. Please post the link where I can download the latest TomTom map data and the source code of pocketgpsworld.com as I want to set up backpocketgpsworld.com but I don't want to have to pay for it. Smile
Back to top
View user's profile Send private message Visit poster's website
bill99jt
Occasional Visitor


Joined: Sep 11, 2006
Posts: 7

PostPosted: Fri Sep 18, 2009 12:07 pm    Post subject: Reply with quote

I would certainly like a copy, as I cant download directly, not allowed to download torrents at work!!

Bill
Back to top
View user's profile Send private message
pcaouolte
Frequent Visitor


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

PostPosted: Sat Sep 19, 2009 8:00 am    Post subject: Reply with quote

Eddiejen wrote:
If you want to play around with the file try CSVed it loaded the file without any problems and allows you to split and manipulate the file easier
http://csved.sjfrancke.nl/index.html

Thank you for the link, it does seem to be a good utility. I used it to delete the unwanted columns and the rows with no lat or long coordinates, then changed the layout of the columns. Now the file is down to 58Mb as a CSV file in a format:
Longitude,Latitude,Name(Postcode),Details(blank)
Next step is to convert it to a Tomtom ov2 file.
_________________
Paul
Back to top
View user's profile Send private message
Oldboy
Pocket GPS Moderator
Pocket GPS Moderator


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

PostPosted: Sat Sep 19, 2009 11:06 am    Post subject: Reply with quote

pcaouolte wrote:
Now the file is down to 58Mb as a CSV file in a format:
Longitude,Latitude,Name(Postcode),Details(blank)
Next step is to convert it to a Tomtom ov2 file.
You could leave the Details column out, but the OV2 file will be about 56+MB and the "GOs" will take quite a time to search it.

Even with it split into approx 6MB chunks it takes several seconds to get a "hit".
_________________
Richard

TT 910 V7.903: Europe Map v1045
TT Via 135 App 12.075: Europe Map v1120
Back to top
View user's profile Send private message Visit poster's website
BarnOwl5
Occasional Visitor


Joined: Aug 28, 2007
Posts: 8

PostPosted: Sat Sep 19, 2009 12:04 pm    Post subject: Post code files Reply with quote

Hi All
Where I think this would be usefull is withing autoroute & Google earth
manys the time you know where your going! but dont know how to put a postcode too it and lets face it it's the easiest way of inputing to satnav's
just be nice if you point to the spot you need to go and up pops nearest post code for you.

Anyway throw it up in the air and lets see what you think?
Back to top
View user's profile Send private message
Oldboy
Pocket GPS Moderator
Pocket GPS Moderator


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

PostPosted: Sat Sep 19, 2009 7:01 pm    Post subject: Re: Post code files Reply with quote

BarnOwl5 wrote:
Where I think this would be usefull is withing autoroute & Google earth
Both programs already have this built-in. Wink
_________________
Richard

TT 910 V7.903: Europe Map v1045
TT Via 135 App 12.075: Europe Map v1120
Back to top
View user's profile Send private message Visit poster's website
gazphone
Lifetime Member


Joined: Feb 26, 2006
Posts: 24
Location: Northern monkey, living in Kent

PostPosted: Sat Sep 19, 2009 7:56 pm    Post subject: Reply with quote

pcaouolte wrote:
Eddiejen wrote:
If you want to play around with the file try CSVed it loaded the file without any problems and allows you to split and manipulate the file easier
http://csved.sjfrancke.nl/index.html

Thank you for the link, it does seem to be a good utility. I used it to delete the unwanted columns and the rows with no lat or long coordinates, then changed the layout of the columns. Now the file is down to 58Mb as a CSV file in a format:
Longitude,Latitude,Name(Postcode),Details(blank)
Next step is to convert it to a Tomtom ov2 file.


any chance of uploading a tomtom ov2 file so others could use it too
Back to top
View user's profile Send private message
pcaouolte
Frequent Visitor


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

PostPosted: Sun Sep 20, 2009 7:24 am    Post subject: Reply with quote

gazphone wrote:
any chance of uploading a tomtom ov2 file so others could use it too

I don't have the data converted to an ov2 file yet. My computer is busy compiling openstreetmap maps for use with we-travel software on my mobile phone.

I have been following the comments about this postcode data on the wikileaks web site. I am now almost certain that it is the Royal Mail's Postzon database, see here. If it does prove to be this data then the Royal Mail hold the copyright and I will delete it from my system.

I make my living from writing software and am entirely opposed to copyright theft.

Edit: It appears that PocketGPSWorld have removed the link to the wikileaks web site from the opening post in this thread. Does this indicate that Darren is also concerned about the copyright of the data now?
_________________
Paul
Back to top
View user's profile Send private message
Darren
Pocket GPS Staff
Pocket GPS Staff


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

PostPosted: Sun Sep 20, 2009 9:55 am    Post subject: Reply with quote

I have taken on-board some of the comments made here by NickG. Whilst reporting the 'leak' is something I think was justified, posting the direct link was on reflection unwise.

If it transpires that the database is indeed RM's then we will treat it as we would any other pirated data/software subject.

Regardless, any requests in the forums for a converted file from the original data or offers of a converted file are not acceptable and we would have to take action against any such posts.

So if you have the file, consider the copyright implications and if you don't, please don't ask for it or converted versions of it in these forums.
_________________
Darren Griffin - Editor
Back to top
View user's profile Send private message Send e-mail Visit poster's website
BarnOwl5
Occasional Visitor


Joined: Aug 28, 2007
Posts: 8

PostPosted: Sun Sep 20, 2009 10:16 pm    Post subject: Re: Post code files Reply with quote

[/quote]
Quote:
Both programs already have this built-in
. [/quote]
They have built in search but thats not my point, if you want the post code of where you are say looking at, then it only shows the first 4 digits by pointing at the road side,I have sorted a cvs file for my area and imported it into Autoroute, and if you pick the nearest icon to where you want the postcode it displays the full postcode only col. 1,14,15 required. useful if you are organising a walk for others attending to give them a postcode close to start.(Not found a way to get it into Google Earth)
Back to top
View user's profile Send private message
Oldboy
Pocket GPS Moderator
Pocket GPS Moderator


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

PostPosted: Mon Sep 21, 2009 8:48 am    Post subject: Re: Post code files Reply with quote

BarnOwl5 wrote:
They have built in search but thats not my point, ....
My apologies for misunderstanding. Embarassed
BarnOwl5 wrote:
(Not found a way to get it into Google Earth)
Use PoiEdit to Open the CSV File, then Save as ..., and select Google Earth (*.kml).

In Windows Explorer Double Click the kml File and Google Earth will open with the Locations in place, and listed under Temporary Places.

When you Exit Google you have the option to Save these new locations under My Places, for use in the future.
_________________
Richard

TT 910 V7.903: Europe Map v1045
TT Via 135 App 12.075: Europe Map v1120
Back to top
View user's profile Send private message Visit poster's website
BarnOwl5
Occasional Visitor


Joined: Aug 28, 2007
Posts: 8

PostPosted: Mon Sep 21, 2009 10:15 pm    Post subject: Reply with quote

Thank you for your advice on adding to Google earth I now understand how to get them in there,But I seem to have some problem with the file conversion program PoiEDIT, As I get the message as follow everytime I try to open a csv file..
'latitude' is not a valid floating point value
any help please. My Headings are Postcode longitude latitude
Back to top
View user's profile Send private message
MaFt
Pocket GPS Staff
Pocket GPS Staff


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

PostPosted: Mon Sep 21, 2009 11:05 pm    Post subject: Reply with quote

try a semi-colon on the header row to 'hide' that row? eg: ;latitude,longitude,details

a 'floating point value' means, essentially, a number with a decimal point maybe it is reading the text thinking it is a number and failing. so by adding the semi-colon you will tell the software to ignore that line

MaFt
Back to top
View user's profile Send private message Visit poster's website
BarnOwl5
Occasional Visitor


Joined: Aug 28, 2007
Posts: 8

PostPosted: Tue Sep 22, 2009 7:31 pm    Post subject: Reply with quote

o/k and thanks for taking the trouble to try and solve My problem of the floating point. I have tried the method as you say of placing a semicolon in front of the line but its still complaining that its not a valid point. could there be some hidden chars. on the line I cannot see?
Back to top
View user's profile Send private message
Oldboy
Pocket GPS Moderator
Pocket GPS Moderator


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

PostPosted: Tue Sep 22, 2009 8:37 pm    Post subject: Reply with quote

In the File Open Error Pop Up, can you see, at the bottom, "Try with following format: Navman Comma Seperated?

If you can, what happens when you Click OK?
_________________
Richard

TT 910 V7.903: Europe Map v1045
TT Via 135 App 12.075: Europe Map v1120
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 Previous  1, 2, 3, 4  Next
Page 3 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

Make a Donation



CamerAlert Database

Click here for the PocketGPSWorld.com Speed Camera Database

Download Speed Camera Database
21.115 (29 Nov 23)



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