Mountain Project Logo

Mining the database for 'bonus pitches'

Original Post
Gregger Man · · Broomfield, CO · Joined Aug 2004 · Points: 1,759

How difficult would it be to mine the database for pitches of a given grade and star rating? [added feature to the advanced search function]

'Bonus pitches'?: On days where you're going for mileage, after topping out on a multi-pitch route it would be nice to have a list of the final two pitches of the nearby routes that end on the walk-off. Routes that you might not have been interested in (obscure/wickedly dangerous) might still have attractive final pitches that you can either rap in and lead back out or lower & top-rope.

I suspect that the database doesn't have the resolution for that kind of query, but if there were a unique search term ('lagniappe pitch'?) then users could add suggested pitches to the comments of nearby routes of similar grades...

Good idea/dumb idea?
Feel free to fling poo.

Gregger Man · · Broomfield, CO · Joined Aug 2004 · Points: 1,759

bump for the yo-yo mileage feature.
(No poo flinging or cryptic pseudo-threats? -What is wrong with you people?)

Nick Stayner · · Wymont Kingdom · Joined Mar 2006 · Points: 2,315

...or you could just pull up the area you're going to climb at on the database and figure it out yourself.

Buff Johnson · · Unknown Hometown · Joined Dec 2005 · Points: 1,145

Where is the magic city? I can't find it in the database

Glenn Schuler · · Monument, Co. · Joined Jun 2006 · Points: 1,330

Gregger, I can't help w/the search feature part but I got a good Bonus pitch for you. After topping out on Childhoods End, walk a couple hundred feet across the top of the rock & toprope the last pitch of Shock Treatment.

fossana · · leeds, ut · Joined Apr 2006 · Points: 13,318

Hey Greg,

It was good seeing you *again* on some permutation of Anthill.

In theory you could mine for terms like "linkup" but then you would have to develop an algorithm to parse out the linkup to what part. My guess it that it would be a lot of work for the NLP (natural language parsing) part with not much output. Then again could be an interesting machine learning project for an undergrad CS student intern.

Another potential approach going forward (if there's sufficient interest/dev resources) would be something like this:

linkup UI 1
linkup UI 2

Michelle

Gregger Man · · Broomfield, CO · Joined Aug 2004 · Points: 1,759

Michelle,
(fun day - despite our Semi-Wild detour)

Filtering tons of data can lead you to places you wouldn't find otherwise. Yes, Nick, I could RTFM (or RTFGB in this case). I sometimes comb the database filling out the todo list and a filter like this would be nice.

Glenn, I might have to go field test some of those new bolts. Looks like a nice line.

fossana · · leeds, ut · Joined Apr 2006 · Points: 13,318

Thanks, Greg. I wanted to tinker with some machine learning tools this winter so I may hit you up later for a data set.

Nick Stayner · · Wymont Kingdom · Joined Mar 2006 · Points: 2,315
Buff Johnson wrote:Where is the magic city? I can't find it in the database
Beautiful Billings, MT.
Guideline #1: Don't be a jerk.

Discuss MountainProject.com
Post a Reply to "Mining the database for 'bonus pitches'"

Log In to Reply

Join the Community

Create your FREE account today!
Already have an account? Login to close this notice.

Get Started.