Post Reply 
 
Thread Rating:
  • 1 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Grand Tour Locations "How-to"
01-17-2014, 11:20 AM (This post was last modified: 01-17-2014 11:44 AM by StarWolve.)
Post: #6
RE: Grand Tour Locations "How-to"
I just finished updating the data files for the Double Down GT - I have GPX and KMZ files ready to go. However, there are a lot more points than in previous years. If you're planning on loading these points into a GPS, I would definitely sort the excel file by state first.

I took a little time to review the points in my area, and I think there's going to be a lot more false positives from these files than in previous years. The USGS updates their files regularly, and it looks like a lot of "communities" (read as: Suburbia Housing Developments with crazy HOA's) are showing up in the list... and most of them like to use a "Nature Name" (Briar CrEEk, Whispering WOOds, Bramble BrOOk, etc.) that has a double letter - usually to impart some natural feel to a completely jam packed development. (Can you tell I dislike housing developments?!) So I would definitely recommend a solid map reconnaissance before riding out for points unknown.

I'll upload the files this weekend - my company blocks dropbox so I can't do it now. If anyone needs help or has any specific requests, let me know and I can help out with creating some customized data sets.

By the way - I could have done something really slick in Visual Basic or a Macro, but the statement I ended up using to determine if a town had double letters was this formula, after converting the names to all uppercase: =IF(COUNT(SEARCH({"AA","BB","CC","DD","EE","FF","GG","HH","II","JJ","KK","MM","NN","OO","PP","QQ","RR","SS","TT","UU","VV","WW","XX","YY","ZZ"},CELL_ADDRESS_HERE)),"TRUE","FALSE")

I was able to upload the files from my phone (sad that I have more functionality on my phone than my work laptop) so try this link. Let me know if it doesn't work and I'll fix it tonight.

https://www.dropbox.com/sh/zhptnxmedmeh5k4/QN1WjO6cXt

IBA #41635

"Boredom is my worst enemy. It's killed a lot of my friends, but it won't get me. When I get bored, I go risk my life somewhere." - Larry Niven, Ringworld
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
Grand Tour Locations "How-to" - StarWolve - 03-19-2013, 07:19 AM
RE: Grand Tour Locations "How-to" - Frump - 03-25-2013, 01:57 PM
RE: Grand Tour Locations "How-to" - MikeH - 03-25-2013, 02:37 PM
RE: Grand Tour Locations "How-to" - Willie - 01-17-2014, 03:36 PM
RE: Grand Tour Locations "How-to" - StarWolve - 01-17-2014 11:20 AM
RE: Grand Tour Locations "How-to" - Frump - 02-04-2015, 02:40 PM

Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  2024 GLMC Grand Tour Q&A Lee_0123 133 33,975 Yesterday 06:57 AM
Last Post: BkerChuck
  Thoughts on 2025 Grand Tour Theme Willie 2 201 12-01-2024 08:37 PM
Last Post: LSGiant
  Got my Grand Compass Tour finisher shirt today! theemightyorbit 2 186 12-01-2024 08:49 AM
Last Post: Willie
  Polar Bear Grand Tour kmorris@kmm.net 6 2,283 10-18-2024 01:39 PM
Last Post: Lee_0123
  2024 Grand Tour Announcements LSGiant 3 2,353 09-19-2024 02:01 PM
Last Post: Lee_0123

Forum Jump: