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

Pocket GPS World :: View topic - Converting ov2 to csv
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Log in for private messagesLog in for private messages   Log inLog in 

Converting ov2 to csv
Goto page 1, 2  Next
 
Post new topic   Reply to topic    Pocket GPS World Forum Index -> Points Of Interest (POIs)
View previous topic :: View next topic  
Author Message
marksfish
Pocket GPS Verifier
Pocket GPS Verifier


Joined: Jun 25, 2005
Posts: 791
Location: Sandy, Bedfordshire

PostPosted: Sat May 09, 2015 10:00 am    Post subject: Converting ov2 to csv Reply with quote

I have some custom POI's which I made on my TomTom. I have now gone to Garmin and have converted them to csv files, using a online converter. I am coming up against some issues though and am not sure if it is corruption or added by the converter. I am seeing the following entries when opening in Notepad:

1.70118,57.472,"A"
-6.73973 , 50.41807,"A"
-1.57843 , 53.40815,"A"
-6.73973 , 50.41807,"A"
-2.71438 , 53.40815,"A"
-6.73973 , 50.41807,"A"
-3.3722 , 53.40815,"A"
-6.73973 , 50.41807,"A"
-3.013 , 53.40769,"A"
-3.3722 , 50.41807,"A"

There are quite a few of these similar entries throughout the file. Putting the co- ordinates into Google Maps shows the locations to all be around the Seychelles/ Mogadishu area. So I know these files aren't put there by me, am I right to think I can just delete all of these? Would love to know where the entries have all come from!!

Thanks

Mark
_________________
Garmin Drivesmart 51 LMT-D Europe
Back to top
View user's profile Send private message
dhn
Frequent Visitor


Joined: Oct 08, 2007
Posts: 2544
Location: Toronto CANADA

PostPosted: Sat May 09, 2015 10:07 am    Post subject: Reply with quote

Might the lat/long be reversed?
_________________
David
Back to top
View user's profile Send private message
marksfish
Pocket GPS Verifier
Pocket GPS Verifier


Joined: Jun 25, 2005
Posts: 791
Location: Sandy, Bedfordshire

PostPosted: Sat May 09, 2015 10:13 am    Post subject: Reply with quote

Could be, but i'm not very techie when it comes to things like this Embarassed . I was just trying that when your reply came in, but I have still found locations in the North Sea and the middle of the English Channel!! Very confusing as I know I have never had my satnav in those areas to mark the location. Am also trying to use Streetview to locate these places, some very strange places coming up!!

Mark
_________________
Garmin Drivesmart 51 LMT-D Europe
Back to top
View user's profile Send private message
marksfish
Pocket GPS Verifier
Pocket GPS Verifier


Joined: Jun 25, 2005
Posts: 791
Location: Sandy, Bedfordshire

PostPosted: Sat May 09, 2015 10:55 am    Post subject: Reply with quote

I believe it was the online converter that was causing the issues. I have found that POIEditor will convert from ov2 to csv, despite being really old software Very Happy

So, one last question, how do I translate the co- ordinates N 5230.802' W 00152.343 into the format in the post above please?

Is it as simple as 52.30802, 1.52343?

Thanks

Mark
_________________
Garmin Drivesmart 51 LMT-D Europe
Back to top
View user's profile Send private message
marksfish
Pocket GPS Verifier
Pocket GPS Verifier


Joined: Jun 25, 2005
Posts: 791
Location: Sandy, Bedfordshire

PostPosted: Sat May 09, 2015 11:08 am    Post subject: Reply with quote

Sorry to keep going on, but I am getting confused now. The co- ordinates I gave above were saved in my Garmin as a My Favourite. I saved them whilst on site, with full satellite reception. My Garmin reports the saved location as N 5230.802' W 00152.343. If I put those on Google Maps and change lat/ long +/- around, the location varies between Leamington Spa and Lowestoft.

If I go to Google Maps and look for the place the actual destination is, it is shown as 52.512635, -1.872051. Vey confused as to why my Garmin and Google fail to agree. Confused

Mark
_________________
Garmin Drivesmart 51 LMT-D Europe
Back to top
View user's profile Send private message
Kremmen
Pocket GPS Verifier
Pocket GPS Verifier


Joined: Mar 03, 2006
Posts: 6816
Location: West London & Reading

PostPosted: Sat May 09, 2015 1:15 pm    Post subject: Reply with quote

They do agree but in a different way. I can't remember which does which but one of them uses the -1 whereas the other uses +1 west as opposed to +1 east taken from the Greenwich starting point.

I fell foul of that recently and sussamb told me off

Laughing
_________________
Satnav:
Garmin DS61 LMT-D (In the car)
Garmin 2599 LMT-D (Indoor test rig)
DashCam:
Viofo A119 V3
Back to top
View user's profile Send private message
dales
Frequent Visitor


Joined: May 04, 2008
Posts: 745
Location: Knaresborough, North Yorkshire.

PostPosted: Sat May 09, 2015 1:59 pm    Post subject: Reply with quote

There are 60 minutes in a degree.

So take the minutes element (eg 30.802) and divide by 60 to get the decimal degrees component (0.513367). Add back the units of degrees (52) and the conversion is done (52.513367 degrees North).

Repeat for the West component. 52.343 minutes, divided by 60 is 0.872383 degrees. Add back the units gives the answer (1.872383 degrees West).
If there isn't a letter for E or W, then a Minus sign is used to denote West ie -1.872383.

Dales.
_________________
nuvi 2599LMT-D, oregon 700, basecamp, memory-map.
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: Sat May 09, 2015 2:06 pm    Post subject: Reply with quote

Surely + is East and - is West. As per the time zones and internationally agreed co-ordinate system
The Garmin indicated N 5230.802' W 00152.343. If I . Which is West of the Greenwich meridian so is a negative number if the W is left off. That location is a shed just off the M6 just north of Birmingham. The other value ( E 00152.343) is in the North Sea off Lowestoft.

52.512635, -1.872051 is pretty much the same as N 5230.802' W 00152.343 expressed as decimal degrees rather than DMS and is still a shed just off the M6 north of Birmingham.
Back to top
View user's profile Send private message
dales
Frequent Visitor


Joined: May 04, 2008
Posts: 745
Location: Knaresborough, North Yorkshire.

PostPosted: Sat May 09, 2015 2:15 pm    Post subject: Reply with quote

Yes indeed, + is East and - is West.
Just as I said above.

Dales.
_________________
nuvi 2599LMT-D, oregon 700, basecamp, memory-map.
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: Sat May 09, 2015 3:18 pm    Post subject: Reply with quote

Yep. That's what you said while I was typing Very Happy
Back to top
View user's profile Send private message
marksfish
Pocket GPS Verifier
Pocket GPS Verifier


Joined: Jun 25, 2005
Posts: 791
Location: Sandy, Bedfordshire

PostPosted: Sat May 09, 2015 3:21 pm    Post subject: Reply with quote

M8TJT wrote:
52.512635, -1.872051 is pretty much the same as N 5230.802' W 00152.343 expressed as decimal degrees rather than DMS and is still a shed just off the M6 north of Birmingham.


Hopefully a "shed" in an industrial estate Smile
_________________
Garmin Drivesmart 51 LMT-D Europe
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: Sat May 09, 2015 3:44 pm    Post subject: Reply with quote

That's what it looks like to me.
Ah. I see what you mean. Google is your friend Very Happy
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: Sat May 09, 2015 3:48 pm    Post subject: Reply with quote

dhn wrote:
Might the lat/long be reversed?
They must be to get the right locations in Google maps. Lat comes first.
Back to top
View user's profile Send private message
Anita
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Mar 15, 2006
Posts: 3219
Location: Windlesham, Surrey

PostPosted: Sat May 09, 2015 4:03 pm    Post subject: Reply with quote

dales wrote:
There are 60 minutes in a degree.

So take the minutes element (eg 30.802) and divide by 60 to get the decimal degrees component (0.513367). Add back the units of degrees (52) and the conversion is done (52.513367 degrees North).

Repeat for the West component. 52.343 minutes, divided by 60 is 0.872383 degrees. Add back the units gives the answer (1.872383 degrees West).
If there isn't a letter for E or W, then a Minus sign is used to denote West ie -1.872383.

Much easier to use this site's DMS to Decimal Coordinates Convertor. Very Happy
_________________
Anita
TomTom VIA 135 - App 12.075,
UK map 1100.11689
Samsung Galaxy S8
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: Sat May 09, 2015 4:35 pm    Post subject: Reply with quote

Yes, but it doesn't explain the technique used Twisted Evil
Back to top
View user's profile Send private message







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 -> Points Of Interest (POIs) 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
21.021 (01 Feb 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