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
jetj said
08:43 PM Feb 20, 2013
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.
-- Edited by jetj on Wednesday 20th of February 2013 09:03:28 PM
Jack Mac said
06:33 AM Feb 21, 2013
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
beiffe said
05:56 PM Feb 22, 2013
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
dorian said
09:58 AM Jul 1, 2013
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)
-- Edited by dorian on Monday 1st of July 2013 10:16:47 AM
Ellimay said
04:00 PM Jul 1, 2013
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.
dorian said
04:39 PM Jul 1, 2013
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.
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.
Ellimay said
05:14 PM Jul 1, 2013
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.
03_troopy said
07:14 PM Jul 1, 2013
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
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
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
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
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
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
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
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.
Great! Thanks.
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.
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