Discussion Topic |
|
This thread has been locked |
the Fet
Knackered climber
A bivy sack in the secret campground
|
|
Thanks Ed and everyone who helped!
That's a lot of climbs!
|
|
bluering
Trad climber
Santa Clara, Ca.
|
|
I just saw this too, Ed. Kick ass!!!!
Thanks for doing it.
|
|
Tarbuster
climber
right here, right now
|
|
Hey Ed,
Here's a thought for a B list project.
We've from time to time touched on the need for a TR repository.
Would it be practical to run a spider that could feret out all the threads with titles including the letters TR?
If so, and if the URL's could be easily compiled, we could maybe index them by year, put each yearly compilation in a separate thread, then vote on a winner at each year's end once they are all in.
In your spare time???
|
|
steelmnkey
climber
Vision man...ya gotta have vision...
|
|
Hey Ed, question for ya... what is the column called "Meyers Noted" ??? Yosemite Climber?
|
|
Clint Cummins
Trad climber
SF Bay area, CA
|
|
> when you sent it I was thoroughly burned out on the project. I'm getting renergized now...
I think I know what you mean! I flamed out with my highly similar project, and I didn't even have to type in those 2200+ routes and all the data that goes with them! In the past I had briefly toyed with making such a database, but after a few hours and not even finishing the Cookie, it just seemed too tough!
With your latest efforts, I got inspired to finish my version, which I had started in February or so. I managed to get it finished over the weekend.
I prefer a view of the data which is more like a guidebook, so I can use it like a guidebook. I can use it to keep track of new routes by inserting them between old ones, so it's fairly clear where they are located. To do this, I had to reorder all the routes into the guidebook order (clockwise around the Valley and left-to-right on each crag). I also reduced the width of the spreadsheet so I can see all the info for a given route on my screen (except for the occasional long FA/FFA entry). To do this, I dropped many of the columns like the page number references to guidebooks. However, besides the spreadsheet view, there are also a couple of web pages generated from the database, which include references to guidebooks and AAJs for routes not in Reid(1994). Along the way, I inserted all the new routes that I know of, so the route total is up to 2500+. The main route list also includes links to a few topos and overlays for some of the new routes. The database also generates a tick list of "routes by type", like that found in Meyers(1982) and Meyers&Reid(1987) but since discontinued. So if you want to tick off all the thin cracks or ows, it's a fun way to select climbs to do. There are still a lot of such types to be added, but it's good enough for a first draft at present.
http://www.stanford.edu/~clint/yos/update.htm
To summarize:
 list of all Yosemite Valley routes I know of (OK, I left out a few secret crags!)
plain text web page of all routes, with links to a few new topos/photo overlays
screen-width spreadsheet, sortable by location, rating, stars, crux type, name, or year. Includes crag/area name headings in bold, on separate rows between the climbs.
routes by type/rating (tick list). Types used: slab, face, arete, lieback, stem, roof, thin/finger, thin hand, hand, fist, ow, chimney. (Plain text web page)
routes by rating (separate section for aid routes)
routes and crags/areas by name (index)
FA/FFA/FCA info (plain text web page)
|
|
steelmnkey
climber
Vision man...ya gotta have vision...
|
|
I'm seeing yet another column to add Ed... type of route (fingers, hands, face, OW, chimney, etc.) That would be awesome to be able to search the db for... difficult, of course because of the multipitch and a lot of them ending up being "all" or something.
Figure if I sit down to dig up the journal references, I'll be burned out about 15 issues of Climbing into the job... :-)
|
|
Ed Hartouni
Trad climber
Livermore, CA
|
|
|
Topic Author's Reply - Sep 9, 2008 - 04:41pm PT
|
in the back of the Yellow Guide Meyers put in an expanded list of Bridwell's Mountain article "defining" climbs... I often generate lists off of the Yellow Guide to work on stuff like: Chimneys...
"Meyers Noted" is just a tick mark...
...it wouldn't be too hard, now that the references are there to the guides, to go and mark the type of climbing, but you always run into the problem on multipitch climbs as to what pitch defines the route, or the possibility that there are several different climbing techniques that are notable on a single climb, even on a single pitch...
e.c. recommended that we put gear recommendations in too...
Now I invite any and all to take the list and generate what ever it is you desire from it! But I'm really just focused on recording the basic info... that is challenging enough.
|
|
Roger Breedlove
climber
Cleveland Heights, Ohio
|
|
Hi Ed,
As you know, I have been using your data base for several years to support my posts on Valley history. The ability to search and to sort makes those sorts of tasks relatively easy. With some of the recent interest in filling in data from more recent ascents, your data base will be both a spur and enabler--great work.
From all of us, thanks.
Best, Roger
PS: When I try to down load your latest from the link in the first post, I get a corrupted file warning--I am sure that it is only referring to the actual data and the not the activity. My Excel program repairs it, but the error message says that there were so many errors that it couldn't keep track of them. I deleted it and tried again and the same thing happened. Got any ideas?
|
|
Ed Hartouni
Trad climber
Livermore, CA
|
|
|
Topic Author's Reply - Sep 9, 2008 - 06:22pm PT
|
Roger, I'll upload it when I get home, it is always possible that something was lost in the process that I didn't see...
...I just downloaded it from the site and opened it in my MSExcel and got no error messages.
Could possibly be a difficulty between the Mac OX version of MSExcel and the variety you are running on your box...
|
|
Splater
climber
Grey Matter
|
|
clint,
great work!
You said you hand numbered all the routes.
Hopefully you are now using a pointer formula that will auto-calculate route numbers whenever you add/subtract a route.
Basically, say you had 3 crags each with 10 routes, ordered from left to right, and then later you want to add a route in the middle. Say that originally route 15 was cookie left, and route 16 was cookie right. Now you want to add cookie middle. If you hard number them, you'd have to hand renumber routes 16-30. But if each route number is just a formula saying take the number of the route to the left and add one, it's much easier. All you have to do is make the index of cookie middle = cookie left + 1. And change the index of cookie right from that to cookie Middle + 1.
|
|
Clint Cummins
Trad climber
SF Bay area, CA
|
|
Splater,
Thanks.
> You said you hand numbered all the routes.
Oops, sorry, I didn't mean to imply that.
Actually what I said is that I "reordered" them - I moved them around in a file by hand. I have software which automatically renumbers the routes when I add or subtract routes from the list. I have a plain text file which is almost the same as yos.htm, but includes the FA info and route types. I edit that text file, then generate the other files from it automatically. (Well, there is one part I do by hand - I have to tweak yos.xls slightly, to make the crag names and heading bold, and freeze the panes).
Way back in the day, I used to renumber stuff by hand, on a VAX minicomputer! Think 1982 or so, for the Connecticut Traprock guidebook. It's so much better to have that numbering automated.....
|
|
Ed Hartouni
Trad climber
Livermore, CA
|
|
|
Topic Author's Reply - Dec 2, 2008 - 12:41am PT
|
ok, I haven't looked at Clint's list, but I have generated a new data base with some additional routes after combing through the American Alpine Journal, having searched for all articles containing the word "Yosemite". That generated ~500 hits, which I has looked at for additional information.
This also generated a lot of the posts I've been doing lately... on AAJ articles and the like.
I'm done now, and the data is entered. steelmnky got me energized to look at references... I think he's doing Climbing and others... so sometime this winter we'll have most of the climbs cross referenced with the climbing literature too. This should make it easy for anyone to look up what was written on any of the routes that have been written about...
http://home.comcast.net/~e.hartouni/eph-climbing.html
|
|
Ed Hartouni
Trad climber
Livermore, CA
|
|
|
Topic Author's Reply - Dec 2, 2008 - 12:42am PT
|
...and Pat Ament, I'm still interested in anything you have... so please shoot me an email, or just post up here...
thanks
|
|
ß Î Ø T Ç H
climber
O a k t o w n
|
|
The google-docs version is nice . Clint's lists priceless too .
|
|
Wade Icey
Trad climber
www.alohashirtrescue.com
|
|
|
Mar 19, 2009 - 06:29pm PT
|
"Bottom line is if people demand more climbing sh#t, they'll bump it."
bump
|
|
Jaybro
Social climber
wuz real!
|
|
|
Mar 19, 2009 - 06:31pm PT
|
If I forget to mention it later, nice work, Wade!
|
|
the Fet
Knackered climber
A bivy sack in the secret campground
|
|
|
Mar 19, 2009 - 06:47pm PT
|
One of the best threads/projects ever.
|
|
Jaybro
Social climber
wuz real!
|
|
|
Mar 19, 2009 - 10:12pm PT
|
He's got a million of them.
|
|
squishy
Mountain climber
sacramento
|
|
|
Mar 20, 2009 - 02:04am PT
|
bump for being awesome...
|
|
scuffy b
climber
just below the San Andreas
|
|
|
Mar 20, 2009 - 12:11pm PT
|
An idea for new lists, Ed.
You've got your Blue List (5.10a offwidth)
and the Pink List (5.10b offwidth)
and I presume more in that series
How about a Right Side In list and a
Left Side In list.
Yosemite climbers seem to think most everything is
Left Side In (you think I'm exaggerating, readers?)
I'll toss out a few Right Side In candidates, even including
perhaps a few guesses.
The Bin
Extra Credit
Chingando
Edge of Night
Secret Storm
Mental Block
|
|
|
SuperTopo on the Web
|
Let us know!