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 |
|||
« Next Oldest | Next Newest »
|
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 |