Home PageFacebookRSS News Feed
PocketGPS
Web
SatNav,GPS,Navigation
Pocket GPS World - SatNavs | GPS | Speed Cameras: Forums

Pocket GPS World :: View topic - overlaying data onto google maps
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Log in for private messagesLog in for private messages   Log inLog in 

overlaying data onto google maps
Goto page 1, 2  Next
 
Post new topic   Reply to topic    Pocket GPS World Forum Index -> Beginners GPS Lounge
View previous topic :: View next topic  
Author Message
kblackburn
Occasional Visitor


Joined: Nov 20, 2004
Posts: 39

PostPosted: Sat Nov 19, 2011 7:34 pm    Post subject: overlaying data onto google maps Reply with quote

Hi Guy's

I don't know where to post this, so if the mods think it's in the wrong area, please move it.

I have an inforad motorcycle gps based speed camera system, which records trips, you can then download, i am told that yo can then overlay this onto maps,ie google, bing and alike, the only problem is i'm a complete numpty with the laptop, but would like to be able to plot my rides, i understand it produces info in .cvs format what ever that is, all i know is it puts them ino exel files, can anyone help,

regards

kev
Back to top
View user's profile Send private message Send e-mail
Oldboy
Pocket GPS Moderator
Pocket GPS Moderator


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

PostPosted: Sat Nov 19, 2011 9:16 pm    Post subject: Reply with quote

POIEdit can open .csv Files and save them in Google KML Format.
_________________
Richard

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


Joined: Nov 20, 2004
Posts: 39

PostPosted: Sat Nov 19, 2011 10:15 pm    Post subject: Reply with quote

Thanks Richard,

but i can not get that to work either, i said i was a computer numpty. I have the exel file in .cvs form, but i can not get it to convert to kml, all i want to do is plot the route.

kev Embarassed
Back to top
View user's profile Send private message Send e-mail
AliOnHols
Pocket GPS Verifier
Pocket GPS Verifier


Joined: Oct 15, 2008
Posts: 1940

PostPosted: Sat Nov 19, 2011 10:37 pm    Post subject: Reply with quote

upload your .csv file to here

http://www.gpsvisualizer.com/

and it should show you your track on google.
_________________
Garmin Nuvi 2599
Android with CamerAlert, OsmAnd+, Waze & TT Europe.
TomTom GO 730, GO 930, GO 940 & Rider2.
SatMap Active 10 & 20.
Back to top
View user's profile Send private message
kblackburn
Occasional Visitor


Joined: Nov 20, 2004
Posts: 39

PostPosted: Sun Nov 20, 2011 12:29 am    Post subject: Reply with quote

AliOnHols,

thanks tried that aswell, still no joy, that site is asking for headers, whats that and how would i install them.this is a sample of the data which the inforad downloads to my laptop,how do i get this a s a mapped ride ?
thanks

kev

54.47796 -2.35005 13/11/11 11:49:02 1
54.47703 -2.34985 13/11/11 11:50:03 53
54.4722 -2.34861 13/11/11 11:51:04 11
54.46986 -2.3504 13/11/11 11:52:05 47
54.46352 -2.35507 13/11/11 11:53:05 61
54.45583 -2.36631 13/11/11 11:54:06 97
54.44709 -2.37358 13/11/11 11:55:07 88
54.43111 -2.37353 13/11/11 11:56:08 82
54.42443 -2.39134 13/11/11 11:57:09 84
54.41486 -2.403 13/11/11 11:58:10 79
54.40049 -2.41253 13/11/11 11:59:11 104
54.38925 -2.42681 13/11/11 12:00:12 66
54.37921 -2.43714 13/11/11 12:01:13 88
54.37413 -2.4533 13/11/11 12:02:14 63
54.36645 -2.46643 13/11/11 12:03:15 78
54.35515 -2.47187 13/11/11 12:04:16 65
54.34488 -2.47717 13/11/11 12:05:17 78
54.33433 -2.48624 13/11/11 12:06:18 97
54.32574 -2.4978 13/11/11 12:07:19 43
54.32359 -2.51678 13/11/11 12:08:20 54
54.32298 -2.5272 13/11/11 12:09:21 23
54.31976 -2.52939 13/11/11 12:10:22 45
54.32158 -2.53708 13/11/11 12:11:22 16
54.31821 -2.54736 13/11/11 12:12:23 63
54.31496 -2.5629 13/11/11 12:13:24 63
54.30885 -2.57263 13/11/11 12:14:25 89
54.30002 -2.5703 13/11/11 12:15:26 78
54.28925 -2.57303 13/11/11 12:16:27 96
54.27762 -2.57979 13/11/11 12:17:28 96
54.2656 -2.58008 13/11/11 12:18:29 63
54.25501 -2.58268 13/11/11 12:19:30 92
54.24427 -2.58307 13/11/11 12:20:31 76
54.23498 -2.5808 13/11/11 12:21:32 83
54.22475 -2.58198 13/11/11 12:22:33 72
54.21445 -2.57712 13/11/11 12:23:34 53
54.20741 -2.58141 13/11/11 12:24:35 70
54.19942 -2.58881 13/11/11 12:25:36 49
54.19836 -2.58982 13/11/11 12:26:37 3
Back to top
View user's profile Send private message Send e-mail
pcaouolte
Frequent Visitor


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

PostPosted: Sun Nov 20, 2011 9:40 am    Post subject: Reply with quote

Hi Kev,

Looking at your data above you haven't got a csv (comma separated variable) file as there are no commas within the data.

To convert your data to a csv file you could use csved which is a free editor available here.

csved can open your file and resave it with the required commas included, you want to end up with a file that begins something like:

54.47796,-2.35005,13/11/11 11:49:02 1
54.47703,-2.34985,13/11/11 11:50:03 53
54.4722,-2.34861,13/11/11 11:51:04 11
54.46986,-2.3504,13/11/11 11:52:05 47
54.46352,-2.35507,13/11/11 11:53:05 61

note the commas after the first and second columns. I also combined the remaining date time and number columns into a single column using csved.

Then you need to add a header so that gpsvisualizer knows what order the data appears in your file. You can add the header using a simple text editor like notepad. When this is done you should end up with a file which begins:

Lattitude,Longitude,Name
54.47796,-2.35005,13/11/11 11:49:02 1
54.47703,-2.34985,13/11/11 11:50:03 53
54.4722,-2.34861,13/11/11 11:51:04 11
54.46986,-2.3504,13/11/11 11:52:05 47

Save this file as something.csv and gpsvisualizer will be able to open it.

It's a good ride from Kirkby Stephen to Kirkby Lonsdale Very Happy
_________________
Paul
Back to top
View user's profile Send private message
M8TJT
The Other Tired Old Man
The Other Tired Old Man


Joined: Apr 04, 2006
Posts: 10118
Location: Bexhill, South Sussex, UK

PostPosted: Sun Nov 20, 2011 10:31 am    Post subject: Reply with quote

Why on earth do they call it a CSV when it's not?
Back to top
View user's profile Send private message
kblackburn
Occasional Visitor


Joined: Nov 20, 2004
Posts: 39

PostPosted: Sun Nov 20, 2011 4:29 pm    Post subject: Reply with quote

inforad says it downloads as a.csv file, me i have know idea what the difference is, although i know now, but do you have to change each line,or is there some way of doing the file in one go.
Back to top
View user's profile Send private message Send e-mail
pcaouolte
Frequent Visitor


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

PostPosted: Sun Nov 20, 2011 5:35 pm    Post subject: Reply with quote

csved (see my post above) will edit every line in the file in one go. It takes a little while to learn how the program works but once learned it is quick to use.

I've just had another thought. Did you open the file in excel and then copy and paste the list that you posted above? If so then it could actually be a csv file as excel would not display the commas.

If you open the file with notepad can you see commas between the items of data? If so copy a few lines from the notepad listing here and we can tell you what the header line should be.
_________________
Paul
Back to top
View user's profile Send private message
AliOnHols
Pocket GPS Verifier
Pocket GPS Verifier


Joined: Oct 15, 2008
Posts: 1940

PostPosted: Sun Nov 20, 2011 8:00 pm    Post subject: Reply with quote

An alternative solution may be to open the file and copy the data without the commas, then try to paste it all into a cell (cell A2 would be good) on a new Excel spreadsheet.

I don't use Excel so I'm not sure if the following will work; I use Gnumeric spreadsheets (free download) http://projects.gnome.org/gnumeric/downloads.shtml which is also suitable for Windows. I've just tried the following, with Gnumeric, and it works.

As mentioned above, try to paste all of your data into cell A2 of the spreadsheet, the spreadsheet should question this action because it can't detect any commas and ask you to select an alternative separator. Select *space* and proceed to import the data. You may need to "merge cells" where the date and time have also been separated due to selecting *space*.

Once the data is safely in the spreadsheet, add the headers (latitude, longitude, name01, etc.) in Row 1 above the columns of data.


Then save the file "Save as" a .csv file called rideout01.csv and close.

Then upload this new file to GpsVisualizer as before.
_________________
Garmin Nuvi 2599
Android with CamerAlert, OsmAnd+, Waze & TT Europe.
TomTom GO 730, GO 930, GO 940 & Rider2.
SatMap Active 10 & 20.
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 Nov 20, 2011 8:06 pm    Post subject: Reply with quote

AliOnHols wrote:
I don't use Excel so I'm not sure if the following will work...

Unfortunately it doesn't work in Excel. Excel applies it's own logic and pastes the data into cells A2,A3,A4 etc without asking any questions. Sad
_________________
Paul
Back to top
View user's profile Send private message
AliOnHols
Pocket GPS Verifier
Pocket GPS Verifier


Joined: Oct 15, 2008
Posts: 1940

PostPosted: Sun Nov 20, 2011 8:16 pm    Post subject: Reply with quote

pcaouolte wrote:

Unfortunately it doesn't work in Excel. .......

That's a pity, It certainly works in Gnumeric. The Windows version can be downloaded here
http://people.gnome.org/~mortenw/gnumeric/gnumeric-1.10.14-20110324.exe

It's a very small, powerful spreadsheet so it may be worth downloading even if it's just for solving this problem.

BTW, nice find on the csved program. Very Happy
_________________
Garmin Nuvi 2599
Android with CamerAlert, OsmAnd+, Waze & TT Europe.
TomTom GO 730, GO 930, GO 940 & Rider2.
SatMap Active 10 & 20.
Back to top
View user's profile Send private message
kblackburn
Occasional Visitor


Joined: Nov 20, 2004
Posts: 39

PostPosted: Sun Nov 20, 2011 9:27 pm    Post subject: Reply with quote

Thanks for all the help, i'll give it a go and see how i get on

regards

kev
Back to top
View user's profile Send private message Send e-mail
Andy_P
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Jun 04, 2005
Posts: 19991
Location: West and Southwest London

PostPosted: Mon Nov 21, 2011 11:33 am    Post subject: Reply with quote

kblackburn....Ignore the last couple of posts as they are just going to confuse and distract. Just let us know how you get on with this bit from the post before those:


pcaouolte wrote:

If you open the file with notepad can you see commas between the items of data? If so copy a few lines from the notepad listing here and we can tell you what the header line should be.

_________________
"Settling in nicely" ;-)
Back to top
View user's profile Send private message
kblackburn
Occasional Visitor


Joined: Nov 20, 2004
Posts: 39

PostPosted: Mon Nov 21, 2011 7:24 pm    Post subject: Reply with quote

Andy_P

I have taken your advise and changed the semi colons to coma's in note pad, it works fine, although changing 60 lines was a pain.

thanks

kev
Back to top
View user's profile Send private message Send e-mail







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 -> Beginners GPS Lounge All times are GMT + 1 Hour
Goto page 1, 2  Next
Page 1 of 2

 
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
22.105 (30 Oct 24)



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