UKC

Is there a trivial way to generate lists of the most popular routes at a given grade?

I want to end up with a list of the 50 most popular Mods, the 50 most popular Diffs, and so on, up to VS.  I can't see an obvious way to do this from the logbook stats page but perhaps I'm missing something.

Or is there a way to download the number of ascents and manipulate it in Excel?  That would be fairly straightforward.

Optimistic weekday bump..?

Pretty sure there isn't a way to do this without someone from UKC/Rockfax querying the database directly.

Yeah, I have convinced myself that it's not possible for a normal user to get at it (I had hope it might be).

I wonder if one of the UKC elves might pick up on this?  It's not critical but it would be helpful for a project I'm working on.  And it would be interesting in general, I think.  I'm sure I can guess quite a few of the top 50 at each grade but I bet there'll be some surprises as well.

Last hopeful bump and then I'll drop it.  If anyone who has database access can help, that would be great - I would simply need an excel file containing route name / grade / number of logged ascents and I could do the rest.

Sorry Jamie, missed this.

Have emailed you the results.

cheers

Ah - got it - thank you very much!  Really appreciated.

I'm having a quick play with the data now.  Anyone fancy a shot at guessing the top ten routes?

More than 50% on grit I expect?

Christmas Crack at S

Flying buttress at VD

Inverted V at (grudgingly) VS 

Sunset Slab or TPS at HVS or, just possibly, DoWH

Long Tall Sally at E1

Wuthering at E2?

Actually, change my bet to 90% drawn from Classic/Hard rock

Good Game:

Easy: High Neb Gully, Stanage (not in top 10)

Mod: Overhanging Buttress Arete, Burb N,  or Martello Cracks, Stanage (No Mod will be in the Top 10)

Diff: Black Slab Right, Stanage (No Diff will be in the top 10)

VD: Flying Buttress Stanage (HVD in Rockfax) or Little Chamonix

HVD: Heather Wall (Froggatt...or Flying Buttress as above)

S: Black Hawk Hell Crack (Stanage)

HS: Christmas Crack (Stanage) or Sunset Crack (Froggatt) 

VS: Hargreaves Original (Stanage)

..others from:  Hollybush Crack, VD, Stanage; Heaven Crack, VD, Stanage; Manchester Buttress, HS, Stanage; Heather Wall, VS, Stanage; Inverted V, VS,  Stanage,

I thought it might be fun!  I shan't say anything for a little while to avoid spoilers.

Tricky if you leave the Grit because the best easier routes off-grit are mostly multi-pitch. That means fewer of these routes per person in a lifetime (because they take longer), which I think translates to fewer ascents, everything else being equal. 

But I'd suggest Little Chamonix (with Offwidth), Middlefell Buttress, Flying Buttress (Cromlech) and Hope as possibles. If they had trad grades I think some of the popular southern sandstone routes might qualify. Likewise some sport routes at Horseshoe, although they may not have been around long enough.

Martin

Absolutely none of those. I’d suspect the list is 100% grit because condition, ease of access, single pitch and proximity to two big cities. 

So, thus far no-one has mentioned the second most popular multipitch in the UK.  It caught me out, too.

But yes, it's massively dominated by grit, and frankly by Stanage.  21 of the top 30 are Stanage, and five of the remainder are grit.  It becomes a bit more varied after the top 30. 

I didn't include sport, but it looks like they are quite a long way down the list (there's an element of reporting bias here, I suspect).  I've just looked up a couple of popular sport routes: Fallen Slab Arete would come in at #74, Reptile Smile #110, Pale Rider #117.

Troutdale Pinnacle?

Or something on Idwal Slabs.

It's Welsh, but not on Idwal... or Tryfan for that matter.

Spiral stairs or Milestone Buttress ordinary?

One step in the clouds? 

Amphitheatre Buttress? 

Winner.  I was surprised to see it quite so high!

I was surprised it was above Christmas Curry, but see that was a split vote with the Micah Finish 

Ah - good point.  If you combine the two then it jumps right to #5 in the list!

For those who wanted to see it - the most logged 100 mod to VS routes in the UK:

• Flying Buttress (HVD 4a) 7249
• Christmas Crack (HS 4a) 6720
• Little Chamonix (VD) 6549
• Hollybush Crack (VD) 6091
• Hargreaves' Original (VS 4c) 5881
• Heather Wall (HVD 3b) 5618
• Black Hawk Hell Crack (S 4a) 5532
• Heather Wall (VS 4c) 4968
• Heaven Crack (VD) 4961
• Sunset Crack (HS 4b) 4950
• Manchester Buttress (HS 4b) 4922
• April Crack (HS 4b) 4744
• Inverted V (VS 4b) 4621
• Mississippi Buttress Direct (VS 4c) 4525
• Central Trinity (VS 4c) 4496
• Crack and Corner (S 4b) 4311
• One Step in the Clouds (VS 4c) 4211
• Via Media (VS 4c) 4034
• Paradise Wall (HS 4b) 4011
• Green Gut (HS 4a) 3976
• High Neb Buttress (VS 4c) 3930
• Hope (VD) 3897
• Robin Hood's Right-hand Buttress Direct (HS 4a) 3845
• Right-hand Trinity (S 4b) 3807
• Bishop's Route (S 4a) 3681
• Black Hawk Traverse Left (VD) 3657
• Topsail (VS 4c) 3596
• Gargoyle Buttress (VS 4b) 3588
• Grooved Arête (HVD 4a) 3567
• Fluted Columns (HVD 3c) 3532
• Trafalgar Crack (VD 4a) 3529
• Middlefell Buttress (D) 3442
• Leaning Buttress Crack (VD) 3441
• Seamstress (VS 4c) 3389
• Alison Rib (D) 3349
• High Buttress Arête (D) 3275
• Doorpost (HS 4b) 3260
• Demo Route (HS 4b) 3185
• Trapeze Direct (VS 4c) 3184
• 20 Foot Crack (S 4b) 3183
• Christmas Curry (S 4a) 3155
• Right Route (VD) 3146
• Trafalgar Wall (S 4b) 3127
• Crackstone Rib (S 4a) 3123
• Troutdale Pinnacle (S) 3121
• Maud's Garden (HVD 3c) 3117
• The Ordinary Route (D) 3029
• Direct Route (HVD) 3026
• Valkyrie (VS 4c) 3022
• Central Groove (HS 4b) 2978
• Embankment 2 (VS 4c) 2977
• Tennis Shoe (HS 4b) 2950
• Cneifion Arete (D) 2935
• Bosigran Ridge a.k.a Commando Ridge (VD) 2930
• Christmas Curry / Micah Eliminate (HS 4b) 2917
• Three Tree Climb (HS 4b) 2868
• Mississippi Crack (S 4a) 2861
• Castle Crack (HS 4b) 2853
• Route 2 (S 4a) 2816
• Black and Tans (S 4a) 2808
• Slab Recess Direct (HS 4c) 2806
• Tango Crack (VD) 2773
• Sail Buttress (HS 4b) 2770
• Prow Cracks (VD) 2760
• Balcony Buttress (S 4a) 2747
• Route 3 (VD 4a) 2736
• Equinox (VS 4c) 2734
• Gargoyle Flake (VS 4c) 2687
• Mutiny Crack (HS 4b) 2680
• Flying Buttress (VD) 2676
• Bird's Nest Crack (HS 4b) 2672
• Brown Slabs Direct (VD) 2667
• The Mall (VS 4c) 2663
• Narrow Buttress (VS 4c) 2660
• Grotto Slab (M) 2638
• Snail Crack (VD) 2636
• Slab Recess (D) 2622
• Prow Corner (VD) 2599
• Bamford Wall (S 4a) 2579
• Camperdown Crawl (HS 4c) 2576
• Ash Tree Wall (S 4a) 2529
• Diamond Crack (HS 4b) 2481
• Martello Buttress (VS 4c) 2468
• Brown's Crack (HS 4b) 2468
• Cranberry Crack (VD) 2426
• Gamma (VD) 2423
• Rob's Crack (VS 4c) 2405
• Tango Buttress (HS 5a) 2398
• Terrace Crack (HS 4b) 2397
• Inaccessible Crack (VS 4c) 2387
• Great Harry (VS 4c) 2379
• Trapeze (VD) 2366
• Allen's Slab (S 4a) 2357
• Low Man Easy Way (D) 2333
• Amazon Crack (HS 4b) 2330
• Inverted Staircase (D) 2329
• Physiology (VD) 2304
• Powder Monkey Parade (S 4b) 2300
• Black Hawk (HS 4c) 2295
• Ash Tree Crack (VD) 2280

There is already a tip 20 of most logged routes both grit and other rock types in all user stats

https://www.ukclimbing.com/logbook/graphs.php

Not much from Scotland !

With that walk in?? People are, on average, lazy, and the stats will reflect that.

Really? Classic, near the road, pretty much always in good condition, and soft for the grade. Perfect way to boost the numbers. 

Yeah, I just thought that popular routes on Ogwen venues like Idwal, Tryfan East face, Milestone, would be ahead of it.  Perhaps I have underestimated the magical climate of Tremadog!

I was intrigued as to whether the top pitch of Troutdale Pinnacle has seen more ascents than any other pitch It seems to fall just short of Little Cham. even if I assume no one abs off the pinnacle. 

Cheers Jamie. So I was wrong on the Mod and Diff.... what about the Easy?

I'm afraid I didn't ask Andy for Easy routes... I'd be interested to know though!