The Wisconsin Geocaching Association

  Login or Register

Website Navigation

62.png Home

49.png Information Center
26.png WGA Newsletters
24.png Reviewer's Words
53.png Presentation Resources
39.png Geocaching Files
27.png Bookmarks
56.png Location Rules and Regs
49.png BOD Info Center

17.png Forums
16.png New Posts
20.png Unanswered Posts

calendar_day.png Upcoming Events
mapicon.png Map
29.png Calendar
11.png Submit Event

mapicon.png WGA State Park CachesNew content !

shield_star.png Cache of the Month
mapicon.png Past Winners Map

LonelyCache.png Lonely Cache Game
mapicon.png Current Map
26.png Scoreboard
11.png Submit Report

rescueiconsm.png Cache Rescue
11.png Submit a Mission

icon_community.gif Members
27.png Your Account
47.png Private Messages
contact_blue.png WGA Member Map
Geocaching_LIVE_poweredby_16.png GC.COM Authorization

icon_members.gif News
tree-T.gif Topics
tree-T.gif Archives
tree-L.gif Submit News

image_cultured.png Photo Gallery
tree-T.gif Updates
tree-L.gif Popular

shield.png Fun Stuff
28.png Recent Logs
TB.gif Picnic to Picnic TB Race Standings
TB.gif WGA Hauler

49.png Board of Directors
 
Contact Us

 
Facebook

Wisconsin Geocaching Association

 
Follow Us

Twitter Button

 
Subscribe to Newsletter

Subscribe to our mailing list

* indicates required
 
Geocaching.com Search
View Search Syntax
 
COTM
Winner -
June 2014 Northern Zone:
Forbidden Fruit

Winner -
June 2014 Northeast Zone:
Wildlife & Travel Bug Sanctuary

Winner -
June 2014 West Central Zone:
Pirates of the Roche-a-Cri

Winner -
June 2014 South Central Zone:
The Big "K"

Winner -
June 2014 Southeast Zone:
Whoomp! There It Is

Winner -
June 2014 Series of the Month:


More Info >>>

 
 
Wisconsin Geocaching Association: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic
Author Message
EnergySaver
WGA Member



Joined: 2004-05-28
Posts: 1440
Location: Ozaukee County

PostPosted: Tue Feb 09, 2010 9:01 am Reply with quote Back to top

Is there a formula that one could use, for example in an excel spreadsheet, to convert FROM our normal DDD MM.MMM coordinates TO Decimal coordinates.

As an example to convert FROM:
N 43° 23.361 W 087° 52.341
TO:
43.38935 -87.87235

I bought a used vehicle that has a built-in Stereo/GPS, which is a Pioneer AVIC-U310BT. Seems to be a nice unit (not a Garmin, but hey it's builti-in). You can upload coordinates/names/description to it from an excel file (saved as .CSV), but the darn file has to be in the 43.38935 -87.87235 format. Pioneer supplies some transfer software called "AVIC Feeds".

Seems to me if I new the formula for North and the formula for West I could transfer a .GPX file to excel add some columns to convert N and W coordinates and save it off to a .CSV to load into the AVIC Feeds software.

_________________
EnergySaver
John 8:12 
View user's profile Send private message
Buy_The_Tie
WGA Member



Joined: 2002-07-12
Posts: 2792
Location: New Berlin, WI

PostPosted: Tue Feb 09, 2010 9:06 am Reply with quote Back to top

If you look at any GPX file, the co-ords are listed in decimal degrees, just like you want. (view the GPX file in notepad)

Mapsource will convert if for you too.

Or, if you are a masochist, you can convert using the following formula.

Ndd mm.mmm Wdd mm.mmm

decimal degrees = dd + (mm.mmm / 60)
 
View user's profile Send private message
Averith
WGA Board Member
WGA Board Member



Joined: 2006-10-23
Posts: 927
Location: Sheboygan, WI

PostPosted: Tue Feb 09, 2010 9:07 am Reply with quote Back to top

Not sure if this will help but:

http://support.microsoft.com/kb/244951

_________________
The post above is purely the opinion of the poster and is no way connected to the opinions of the WGA Board.

Bushwhacking Unnecessarily Since 2006!! 
View user's profile Send private message Send e-mail
EnergySaver
WGA Member



Joined: 2004-05-28
Posts: 1440
Location: Ozaukee County

PostPosted: Tue Feb 09, 2010 9:14 am Reply with quote Back to top

Tie ... thanks!

I noticed that the "raw" .GPX was in the correct format ... but couldn't see an easy way to get the fields I wanted (nice and clean) into excel.

I have been poking around with preferences in MapSource. Couldn't find a format that matched. But now I see there is a Lat/Lon that is decimal. However, they've left the N and W on ... I need to remove the Ns and turn the Ws in - (negative). But that's pretty easy to do in excel.

Thanks!

_________________
EnergySaver
John 8:12 
View user's profile Send private message
EnergySaver
WGA Member



Joined: 2004-05-28
Posts: 1440
Location: Ozaukee County

PostPosted: Tue Feb 09, 2010 9:36 am Reply with quote Back to top

Actually I feel so "complete" inside ... I figured out the excel formulas ... which is an amazing thing, considering how little I use excel.

In case your wondering:

Assuming A1 contains: N43 23.361 W87 52.341
North =((MID(A1,2,2))+(MID(A1,5,6)/60))*(IF(MID(A1,1,1)="N",1,-1))
West =((MID(A1,13,2))+(MID(A1,16,6)/60))*(IF(MID(A1,12,1)="E",1,-1))

Giving you:
43.38935
and
-87.87235

This assumes that A1 is exactly in the shown format ... spaces as indicated, no degree symbol and no leading 0 before the 87 ... which is the format that my MapSource is creating.

_________________
EnergySaver
John 8:12 
View user's profile Send private message
marc_54140
WGA Member



Joined: 2004-01-28
Posts: 2631
Location: Little Chute

PostPosted: Tue Feb 09, 2010 9:54 am Reply with quote Back to top

I occasionally want / need to convert between systems.

I have a fake cache established on GC.Com, and enter one system, then look at the cache page for the others. Slightly ..... weird, but it works.
 
View user's profile Send private message
HeliDood
WGA Friend



Joined: 2010-01-08
Posts: 275

PostPosted: Tue Feb 09, 2010 10:41 am Reply with quote Back to top

This works too

http://boulter.com/gps/
 
View user's profile Send private message
lone_gunman
WGA Member



Joined: 2008-04-12
Posts: 1928
Location: The Grassy Knoll, WI

PostPosted: Tue Feb 09, 2010 10:54 am Reply with quote Back to top

this is what I use


http://www.fizzymagic.net/Geocaching/FizzyCalc/

_________________
There is no point in driving yourself mad trying to stop yourself going mad. You might just as well give in and save your sanity for later.

What\'s life? Life\'s easy. A quirk of matter. Nature\'s way of keeping meat fresh 
View user's profile Send private message
CodeJunkie
WGA Member



Joined: 2009-07-21
Posts: 8193
Location: Berlin, WI

PostPosted: Tue Feb 09, 2010 11:00 am Reply with quote Back to top

Another option to get it into Excel would be to use the GSAK Export to Excel functionality. I've done this and used similar equations to convert the format. Obviously you need GSAK to do this.
 
View user's profile Send private message
Team Black-Cat
WGA Webmaster
WGA Webmaster



Joined: 2007-09-13
Posts: 6082
Location: Somewhere in Central WI

PostPosted: Tue Feb 09, 2010 11:08 am Reply with quote Back to top

Lot's of ways to get this done... Like CodeJunkie, I usually just write something...
You'll need the latest version of GSAK for this one to work.
Copy and paste this into a new macro. Assuming the order you mentioned is correct, (and that you use GSAK) this should create a .CSV that you can use for your nav unit. The file (AVIC.CSV) will be in your GSAK directory.
On my laptop, it exports 1000 caches in about 4 seconds.
Code:
$CN=0
$OutputFile=$_Install + "\AVIC.CSV"
If FileExists($OutputFile)
 FILEERASE File=$OutputFile
endif
$SQLdatabase=$_CurrentDataPath + "\sqlite.db3"
$TMPstr=sqlite("open","$SQLdatabase")
$_SQL="Select Latitude,Longitude,Code,Name from caches where $_Where"
$status = sqlite("sql",$_Sql, "sqlget=yes")
while not($_sqleol)
 $Lat=val(sqlget("Latitude"))
 $Lon=val(sqlget("Longitude"))
 $Code=(sqlget("Code"))
 $Name=(sqlget("Name"))
 ShowStatus msg=Exporting cache $CN - $Code
 $OutString="$Lat,$Lon,$Code,$Name"
 $OutString=$OutString + $_NewLine
 SET $Data = AppendFile($OutputFile,$OutString)
 $CN=$CN+1
 SQLNext
EndWhile
SQLGETCLOSE
 
View user's profile Send private message Visit poster's website
EnergySaver
WGA Member



Joined: 2004-05-28
Posts: 1440
Location: Ozaukee County

PostPosted: Wed Feb 10, 2010 1:32 pm Reply with quote Back to top

Turns out there is a GSAK macro already made for the Pioneer units.

Could someone help me modify it?

The .GSK code is available at: http://gsak.net/board/index.php?s=d3c33c29efbc38c3fd16ea958b0eda27&showtopic=12927&st=0&#entry85903

The resulting <name> field is just the written name of the cache, like this:
That Amazing Cache

But I'd rather have the Waypoint Code followed by the written name, like this:
GC12DG3 That Amazing Cache

I thought I'd be able to figure it out, but I don't see any reference to the field containing the Waypoint in the code.

_________________
EnergySaver
John 8:12 
View user's profile Send private message
Team Black-Cat
WGA Webmaster
WGA Webmaster



Joined: 2007-09-13
Posts: 6082
Location: Somewhere in Central WI

PostPosted: Wed Feb 10, 2010 1:48 pm Reply with quote Back to top

I'll take a look and either modify it or just let you know what to change.
 
View user's profile Send private message Visit poster's website
Team Black-Cat
WGA Webmaster
WGA Webmaster



Joined: 2007-09-13
Posts: 6082
Location: Somewhere in Central WI

PostPosted: Wed Feb 10, 2010 1:57 pm Reply with quote Back to top

Try this... Change line 115 to:

Code:
$CacheName = $d_code +"-"+ $d_Name


You can change the dash to a space if you like.
 
View user's profile Send private message Visit poster's website
EnergySaver
WGA Member



Joined: 2004-05-28
Posts: 1440
Location: Ozaukee County

PostPosted: Wed Feb 10, 2010 2:31 pm Reply with quote Back to top

Thanks ... that worked great!

_________________
EnergySaver
John 8:12 
View user's profile Send private message
Display posts from previous:       
Post new topic   Reply to topic

View next topic
View previous topic
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
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2008 phpBB Group
:: Theme & Graphics by Daz :: Ported for PHP-Nuke by nukemods.com ::
All times are GMT - 6 Hours
 
Forums ©
 
Legal Notice | Privacy Policy | Terms of Use | Parental Consent Form | contact | Comments ]

All content © 2013 Wisconsin Geocaching Association, except comments and forum entries which are property of their posters.

The Groundspeak Geocaching Logo is a registered trademark of Groundspeak, Inc. Used with permission.
 


Use of this Web site constitutes acceptance of the WGA Terms of Use


Distributed by Raven PHP Scripts
New code written and maintained by the RavenNuke™ TEAM


(Original PHP-Nuke Code Copyright © 2004 by Francisco Burzi)
Page Generation: 1.24 Seconds

:: fisubice phpbb2 style by Daz :: PHP-Nuke theme by www.nukemods.com ::
:: fisubice Theme Recoded To 100% W3C CSS & HTML 4.01 Transitional & XHTML 1.0 Transitional Compliance by RavenNuke™ TEAM ::

:: W3C CSS Compliance Validation :: W3C HTML 4.01 Transitional Compliance Validation :: W3C XHTML 1.0 Transitional Compliance Validation ::