08-12-2006, 18:10 | #1 |
King
Join Date: May 2006
Location: Cajun Country.
Posts: 2,002
|
GPS question for ya
Tubby..I remember your geocaching post and I have a question. Do you know the formula for converting lat/lon to UTM.
I have some GIS maps to make and instead of typing in 100 different numbers i am trying to find a formula i can use in excel to convert the data. |
08-12-2006, 18:22 | #2 |
Moderator
Join Date: Aug 2005
Location: Middle of VA.
Posts: 3,896
|
this website has a bunch of nerd type stuff on it. I think that there are some formulas in there.. I'll peruse it and translate it to human
http://www.uwgb.edu/dutchs/UsefulData/UTMFormulas.HTM
__________________
3/2006 : Now, surely that must be because some fists might have caused internal damage to certain delicate parts? |
08-12-2006, 18:24 | #3 |
Moderator
Join Date: Aug 2005
Location: Middle of VA.
Posts: 3,896
|
there is a spreadsheet there at the bottom but you still have to type in some crap. I could try to make it easier to do a bunch if you need it.
__________________
3/2006 : Now, surely that must be because some fists might have caused internal damage to certain delicate parts? |
08-12-2006, 18:34 | #4 |
King
Join Date: May 2006
Location: Cajun Country.
Posts: 2,002
|
Thanks a bunch nerd boy...
I got about 50 to 100 site locations to type in so I will play with the spreadsheet and see what I can get. Ideally it would give me two columns of data after I put in my data. I am trying to find an easy way of doing this so I can leave work early. and still finish this crap. Also I am basically making the mean annoying fat chick in my lab obsolete so she will not get renewed next year. I cant stand her and since I am permanent and not up to renewal, I can help here find here way out of " my "lab( It will be after she leaves). I have been teaching myself GIS(mapping software) and SAS( stats package) to help her become expendable. She is the type that has 6 months total of work experience but think she knows everything. She is also an Auburn fan so that hurts her in this lab. |
08-12-2006, 19:47 | #5 |
Moderator
Join Date: Aug 2005
Location: Middle of VA.
Posts: 3,896
|
so you are going from UTM to lat/long? or vice versa?
Also are you using NAD83 or WGS84?
__________________
3/2006 : Now, surely that must be because some fists might have caused internal damage to certain delicate parts? |
08-12-2006, 19:47 | #6 | |
Customized Admin :)
Join Date: Mar 2003
Location: sailing the seas of cheese.
Posts: 5,852
|
Quote:
__________________
I fed my Dog the American Dream Well, he rolled over and he started to scream He said, I dig the taste of salt but it don't keep me alive yeah, yeah |
|
08-12-2006, 20:00 | #7 |
King
Join Date: May 2006
Location: Cajun Country.
Posts: 2,002
|
lat/long..format DD MM.mmm WGS84 to UTM
I got distracted so I havent started it yet...had to move boats to the boat building due to the extreme cold we are having overnight. |
08-12-2006, 20:07 | #8 |
Moderator
Join Date: Aug 2005
Location: Middle of VA.
Posts: 3,896
|
holy crap... it's already done for you.. Look in the second tab of the excel spreadsheet for UTM to lat-long and the 3rd tab has lat-long to UTM.
Auburn women deleted
__________________
3/2006 : Now, surely that must be because some fists might have caused internal damage to certain delicate parts? |
08-12-2006, 20:08 | #9 |
Moderator
Join Date: Aug 2005
Location: Middle of VA.
Posts: 3,896
|
I can modify the spreadsheet so that you could input DD MM.mmm instead of DD.dddd unless you already know how to do that
__________________
3/2006 : Now, surely that must be because some fists might have caused internal damage to certain delicate parts? |
08-12-2006, 20:41 | #10 |
King
Join Date: May 2006
Location: Cajun Country.
Posts: 2,002
|
I had seen that and started playing with it...making sure it matched the site that i was told to use.
I think its simply divide or multiple by 60( will test first)....I havent had time. Things work like that here... get started on one thing then another thing pops up that needs doing now. She is a typical Auburn woman...missing a tooth and chews tobacco...( joking) |