Hike-NH.com
http://forum.hike-nh.com/

twist on an old game
http://forum.hike-nh.com/viewtopic.php?f=3&t=8242
Page 2 of 4

Author:  Grindboy [ Wed Dec 10, 2014 8:20 pm ]
Post subject:  Re: twist on an old game

Loop over Carter Dome to S and M Carter?

Author:  kpmmbm [ Wed Dec 10, 2014 8:40 pm ]
Post subject:  Re: twist on an old game

Eisenhower & Pierce?

Author:  kpmmbm [ Wed Dec 10, 2014 8:43 pm ]
Post subject:  Re: twist on an old game

including the elevation and mileage should make it easier (you may have noticed I didn't) but, it doesn't

Author:  bikehikeskifish [ Wed Dec 10, 2014 8:49 pm ]
Post subject:  Re: twist on an old game

kpmmbm wrote:
including the elevation and mileage should make it easier (you may have noticed I didn't) but, it doesn't


Sure it does. First, find all the peaks that are +/- 100 feet from the approximate elevation on Joe's profile:

Code:
SELECT NAME, Elevation 
  FROM peaks
 WHERE peaks.st='NH'
   AND ((peaks.elevation > 4400 AND peaks.elevation < 4700)
    OR (peaks.elevation > 4800 AND peaks.elevation < 5000))
ORDER BY elevation


results in a limited set of peaks:

Code:
Name                    Elevation 
Hancock                 4420       
Wildcat                 4422       
South Carter            4430       
Liberty                 4459       
Garfield                4500       
North Carter            4520       
Moosilauke, South Peak  4523       
Blue                    4529       
West Bond               4540       
Adams 4                 4580       
Guyot                   4580       
Lethe                   4584       
Middle Carter           4610       
Hight                   4675       
Bond                    4698       
Moosilauke              4802       
Carter Dome             4832       
South Twin              4902       
Franklin                4904       


Now find the highest ones - the tall one is pretty much Moosilauke, Carter Dome or South Twin. Then, what has three peaks that are close together and have approximately matching elevations? Pretty much only can be the Carters. Load up a Carters profile and voila! It was a kind of crappy day so I didn't bother with Hight, which is unusual, since I love that view.

Tim

Author:  kpmmbm [ Wed Dec 10, 2014 8:53 pm ]
Post subject:  Re: twist on an old game

good one

Author:  JustJoe [ Wed Dec 10, 2014 9:03 pm ]
Post subject:  Re: twist on an old game

Yes. It's the Carter's. Tim's profile shows.

Author:  bikehikeskifish [ Wed Dec 10, 2014 9:17 pm ]
Post subject:  Re: twist on an old game

Can also look at like this...

What hike is about 12.5 miles (more than 12, less than 13) and has 3 or more peaks?

Code:
SELECT COUNT(peaks.name) AS PeakCount, hikes.name AS HikeName, distance
  FROM hikes
  JOIN hikepeaks ON hikes.id = hikepeaks.hikeid
  JOIN peaks ON peaks.id = hikepeaks.peakid
WHERE distance > 12 AND distance < 13
GROUP BY (hikes.name)
HAVING COUNT(peaks.name) >= 3
ORDER BY distance


gives us:

Code:
PeakCount  HikeName                               distance 
3          Carters W2014                          12.2     
4          Washington's Birthday 2013             12.3     
4          Cabot-FOT48-12                         12.4     
3          Carters W48                            12.5     
4          Carters W2012                          12.6     
4          Carters Nov-2012                       12.6     
3          Bigelows Horn, West and Avery          12.7     
6          Lafayette-Lincoln-Liberty-Flume W2014  12.8     


Carters (+Hight in most cases) comes up pretty often :)

Tim

Author:  Granite Guy [ Wed Dec 10, 2014 10:03 pm ]
Post subject:  Re: twist on an old game

Tims reasoning is what was going through my head but I've never made a GPS track in my life so has nothing to go on. May explain why I am worse at this game than the picture guessing one if that's possible. :?

Author:  kpmmbm [ Thu Dec 11, 2014 6:15 am ]
Post subject:  Re: twist on an old game

how 'bout this one
Image

Author:  Granite Guy [ Thu Dec 11, 2014 8:36 am ]
Post subject:  Re: twist on an old game

If each of those bars is three hundred feet like it seems to be in the others this one appears to just top 4000, so based on the profile I'll say Tecumseh from ski area.

Author:  JustJoe [ Thu Dec 11, 2014 9:02 am ]
Post subject:  Re: twist on an old game

I'll go with Moriah for that one.

Author:  madmattd [ Thu Dec 11, 2014 9:15 am ]
Post subject:  Re: twist on an old game

If it wasn't for the starting elevation (assuming GG is right that is), I'd go with Isolation via the Engine Hill 'whack actually. But based off a ~600ft TH elevation, I agree with Joe on Moriah from Bangor Road. EDIT: the bottom appears to have been cropped. I'm going with Isolation via Engine Hill. I have a track that is eerily similar, and the differences are easily explained by different tracks in the BW:

Image

Author:  kpmmbm [ Thu Dec 11, 2014 6:56 pm ]
Post subject:  Re: twist on an old game

Matt is correct, its Isolation and he was in fact on this hike :D

Author:  Granite Guy [ Thu Dec 11, 2014 8:59 pm ]
Post subject:  Re: twist on an old game

madmattd wrote:
If it wasn't for the starting elevation (assuming GG is right that is)......


That generally is a terrible assumption to make. :D

Author:  madmattd [ Thu Dec 11, 2014 10:02 pm ]
Post subject:  Re: twist on an old game

kpmmbm wrote:
Matt is correct, its Isolation and he was in fact on this hike :D


I was wondering if it was that one. I didn't have as good an elevation plot handy on that one :)

Page 2 of 4 All times are UTC - 5 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/