check out the new remote control Jockey Wheel SmartBar rearview170 Beam Communications SatPhone Shop Topargee products
Members Login
Username 
 
Password 
    Remember Me  
Post Info TOPIC: Converting Lat and Longitude for GPS


Guru

Status: Offline
Posts: 930
Date:
Converting Lat and Longitude for GPS


I have often seen requests for a means to convert the latitude and longitudes that are aopften given so they can be used by the gps software etc.

I use a spreadsheet so I will try and explain how I have set it up as others may wish to try it as well I will describe how to convert 32.24.29.000

Create a new one spreadsheet and then in cell a3 place the 32 in cell b3 put the 25 and in c3 put the 29 and then in other cell eg d2 type in =A3+(B3/60)+(C3/3600)

This should give you 23.3902778 .

I do a copy and then a paste special and use "values" into where you want the latitude. This should give you the results of D2 in the other spreadsheet

I don't worry about the last set.

I usually run the two spreadsheet when copying rest stop etc that I find and after a while it is quite easy and quick. I use the CTRL C for the copy but you have to use the menu for the rest unless you want to create a macro.

I have the reverse formula as well but most need the one described.

Hope this may help someone

Regards

Brian



__________________

11 Mtr house Boat based at Mannum hoping to travel up the Murray as far as I can get then drift back again



Guru

Status: Offline
Posts: 1619
Date:

The link below looks like it will do the conversion online. The RFS use the GDA I think and the choppers use the lat and longs so been meaning to look for a conversion tool. I believe there are some.

http://scims.lpi.nsw.gov.au/transform.html

 





-- Edited by jetj on Wednesday 20th of February 2013 08:58:40 PM

__________________

Janette



Guru

Status: Offline
Posts: 1619
Date:

There seems to be android apps as well not sure they are what is needed though.

https://play.google.com/store/apps/details?id=net.nfet.llc&hl=en



-- Edited by jetj on Wednesday 20th of February 2013 09:03:28 PM

__________________

Janette



Senior Member

Status: Offline
Posts: 379
Date:

beiffe wrote:

I have often seen requests for a means to convert the latitude and longitudes that are aopften given so they can be used by the gps software etc.

I use a spreadsheet so I will try and explain how I have set it up as others may wish to try it as well I will describe how to convert 32.24.29.000

Create a new one spreadsheet and then in cell a3 place the 32 in cell b3 put the 25 and in c3 put the 29 and then in other cell eg d2 type in =A3+(B3/60)+(C3/3600)

This should give you 23.3902778 .

I do a copy and then a paste special and use "values" into where you want the latitude. This should give you the results of D2 in the other spreadsheet

I don't worry about the last set.

I usually run the two spreadsheet when copying rest stop etc that I find and after a while it is quite easy and quick. I use the CTRL C for the copy but you have to use the menu for the rest unless you want to create a macro.

I have the reverse formula as well but most need the one described.

Hope this may help someone

Regards

Brian


 Lt James Cook's worst nightmare.

How did I ever navigate my way up the Qld coast without Satnav(in those days) Gps etc?

To each his own but if I ever have to resort to that I'll just book myself into the nursing home now.

To each his own but if I can't get there on land with a map/chart compass and dead reckoning and a few skills, I don't think I'll go. If I really have to I'll throw in a sextant. lol

 



__________________

N.O.M.A.D.  Normally only me and dog.



Guru

Status: Offline
Posts: 930
Date:

There is not to many that can use a sextant anymore.

Even when i did my ticket we played with one so we knew how it worked etc but even by then radar was the norm for coastal navigation and GPS was just coming in and I found it invaluable as we were expected to navigate to very close tolerances and radar was unpredictable due to changes in atmospheric changes such as mist and temp changes etc so hard to work of a coast or mountains when the you had mist or rain etc.

Given that it was interesting during the wars over the other side when they kept changing the satellites.

Spent some hairy trips sailing across the Nulabour etc at 2000Ks whilst tied to the whalf or trawling down the gulf at 2 knots LOL. We had to wait till their attack was over and then it returned to normal.

Dead reckoning is OK when your are not working to 1/10 of a mile and 28 miles from shore.

Regards
Brian

__________________

11 Mtr house Boat based at Mannum hoping to travel up the Murray as far as I can get then drift back again



Guru

Status: Offline
Posts: 4136
Date:

beiffe wrote:

I use a spreadsheet so I will try and explain how I have set it up as others may wish to try it as well I will describe how to convert 32.24.29.000

Create a new one spreadsheet and then in cell a3 place the 32 in cell b3 put the 25 and in c3 put the 29 and then in other cell eg d2 type in =A3+(B3/60)+(C3/3600)

This should give you 23.3902778 .


23.3902778 degrees = 23 degrees 23 arcminutes 25 arcseconds

32 + (24 / 60) + (29 / 3600) = 32.4080556

32 + (25 / 60) + (29 / 3600) = 32.4247222

You could also use Google's calculator:

http://www.google.com.au/search?q=32+%2B+%2824+%2F+60%29+%2B+%2829+%2F+3600%29
http://www.google.com.au/search?q=32+degrees+24+minutes+29.000+seconds+in+degrees




-- Edited by dorian on Monday 1st of July 2013 10:16:47 AM

__________________

"No friend ever served me, and no enemy ever wronged me, whom I have not repaid in full."

Lucius Cornelius Sulla - died 78 BC 

 



Member

Status: Offline
Posts: 9
Date:

Hey everyone

I found this handy little URL to help me as I don't have a GPS tracker or nav/sat. I do have a Samsung Tablet with internet which we have found very useful for looking up random places and things.

http://itouchmap.com/latlong.html
All you have to do is find the place on a map of the world, double click at the exact place and the website gives the lat and long below the map.
I will test this out at Xmas time so will get back as to how handy it is 'on the road'.

Cheers, Ellimay.


__________________


Guru

Status: Offline
Posts: 4136
Date:

Ellimay wrote:

I found this handy little URL to help me as I don't have a GPS tracker or nav/sat. I do have a Samsung Tablet with internet which we have found very useful for looking up random places and things.

http://itouchmap.com/latlong.html


All you have to do is find the place on a map of the world, double click at the exact place and the website gives the lat and long below the map.


 Great! Thanks.



__________________

"No friend ever served me, and no enemy ever wronged me, whom I have not repaid in full."

Lucius Cornelius Sulla - died 78 BC 

 



Member

Status: Offline
Posts: 9
Date:

Another easier website for finding gps is http://locates.com.au/gps.html. This one I just type in the address and click.

I admit the first one, http://itouchmap.com/latlong.html is great with a mouse but lousy with a touchpad but I still use it.

Cheers, Ellimay.

__________________


Guru

Status: Offline
Posts: 1531
Date:

Charts and maps with the aid of a compass and using dead reckoning is fine for getting from A to B out in the open, or in the bush, but you'd be busier than a one armed wall paper hanger with fleas, using that method to traverse one of our capitol cities in peak hour. And yes, they do sometimes try to send you up the garden path, or the wrong way down a one way street, but like everything (including paper maps) they are only as good as the currency of the data. A GPS (in car navigator type) can be an invaluable tool when planning routes where you need to arrange to be at a camp site and set up by a certain time of day (many work off historical trip times for certain routes), especially if you have one of the camp site databases loaded into it. Or if you want to get from A to B across a city and avoid toll roads because you don't have an E tag and there aren't toll booths to take your money. Or if your other half simply can't read a road map and you need to make a quick decision to turn left or right in peak hour traffic. And if you do take the wrong turn they'll usually get you back on track pretty quickly. Also some of them will give you up to date Traffic Alerts in Capitol cities (not many cities have this function yet though) and allow you to change your route to avoid them. But like any sort of electronic nav aid you do need a backup, which is where the paper maps are good.

Edit: Another handy feature for a lot of them is you can search out local business in an unfamiliar city by way of keyword searching, or dedicated buttons for servos, ATM's, restaurants, medical assistance or even a closeby public loo if you had a dodgy vindaloo at the Indian restaurant it pointed you to.



-- Edited by 03_troopy on Monday 1st of July 2013 07:18:42 PM

__________________
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Purchase Grey Nomad bumper stickers Read our daily column, the Nomad News The Grey Nomad's Guidebook