Freezing Saddles Pointless Prizes

[hozn]

@KayakCyndi 43212 wrote:

I will provide a prize for the person with the most lunch time rides. These will need to be rides that take place between 11am and 2pm. I MIGHT be able to datamine Strava (thanks to a very techi-SO) but if you THINK you are a candidate for this pointless prize please PM me so I have fewer records to sort through.

All that said, I think I know who is winning this one already (acl)!

Hi — I’ve got the data for this in my database. If you’d like access, just PM me.

In the meantime, I think this is the right query — and the current top X results:

select A.id athlete_id, A.name as athlete_name, count(R.id) as lunch_rides
from rides R join athletes A on A.id = R.athlete_id
WHERE HOUR(R.start_date) < 14 and HOUR(R.start_date) > 11
and (HOUR(R.start_date + sec_to_time(R.elapsed_time)) < 14)
GROUP BY A.id, A.name
ORDER BY lunch_rides desc;

[TABLE=”class: data”]
[TR]
[/TR]
[TR]
athlete_idathlete_namelunch_rides[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]661772[/TD]
[TD]Trish Newberg[/TD]
[TD=”class: nowrap, align: right”]12[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]1404871[/TD]
[TD]Michael Essig[/TD]
[TD=”class: nowrap, align: right”]8[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]1410917[/TD]
[TD]Karen Smith[/TD]
[TD=”class: nowrap, align: right”]6[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]1546879[/TD]
[TD]Robert O.[/TD]
[TD=”class: nowrap, align: right”]4[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]163744[/TD]
[TD]Elizabeth W.[/TD]
[TD=”class: nowrap, align: right”]3[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]1224809[/TD]
[TD]Ken Buja[/TD]
[TD=”class: nowrap, align: right”]3[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[/TR]
[/TABLE]

(Note: this only includes rides that also finish before 2pm.)

[hozn]

@acl 45561 wrote:

The list: pick anything that appeals to you.
(SNIP)

Also, please use the current reports on the http://freezing.hozn.net site as simply examples of the types of things that are possible; I’m happy to help with other queries if people have more original ideas, etc.

[KayakCyndi]

@hozn 45595 wrote:

Hi — I’ve got the data for this in my database. If you’d like access, just PM me.

In the meantime, I think this is the right query — and the current top X results:

select A.id athlete_id, A.name as athlete_name, count(R.id) as lunch_rides
from rides R join athletes A on A.id = R.athlete_id
WHERE HOUR(R.start_date) < 14 and HOUR(R.start_date) > 11
and (HOUR(R.start_date + sec_to_time(R.elapsed_time)) < 14)
GROUP BY A.id, A.name
ORDER BY lunch_rides desc;

[TABLE=”class: data”]
[TR]
[/TR]
[TR]
athlete_idathlete_namelunch_rides[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]661772[/TD]
[TD]Trish Newberg[/TD]
[TD=”class: nowrap, align: right”]12[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]1404871[/TD]
[TD]Michael Essig[/TD]
[TD=”class: nowrap, align: right”]8[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]1410917[/TD]
[TD]Karen Smith[/TD]
[TD=”class: nowrap, align: right”]6[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]1546879[/TD]
[TD]Robert O.[/TD]
[TD=”class: nowrap, align: right”]4[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]163744[/TD]
[TD]Elizabeth W.[/TD]
[TD=”class: nowrap, align: right”]3[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]1224809[/TD]
[TD]Ken Buja[/TD]
[TD=”class: nowrap, align: right”]3[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[/TR]
[/TABLE]

(Note: this only includes rides that also finish before 2pm.)

Just PMed you. But hmmm … something seems wacky with that data. Karen Smith (ACL) has WAY more lunchtime rides than that. I think she averages something like 4 a week!

[hozn]

@KayakCyndi 45598 wrote:

Just PMed you. But hmmm … something seems wacky with that data. Karen Smith (ACL) has WAY more lunchtime rides than that. I think she averages something like 4 a week!

Very possible my query is bad! — I will dig a little deeper and see what’s up.

[hozn]

Yeah, apologies, you can’t just add dates together in MySQL using the “+” operator, apparently (horrid database!) And I was only getting rides between noon and 2pm due to use of “>” instead of “>=”; that one was my fault

Here is the correct query (as a note-to-self) and the top X:

select A.id athlete_id, A.name as athlete_name, count(R.id) as lunch_rides
from ride_start_end R join athletes A on A.id = R.athlete_id
where hour(R.ride_start) >= 11 and hour(R.ride_start) < 14 and hour(R.ride_end) < 14
group by A.id, A.name
order by lunch_rides desc;

[TABLE=”class: data”]
[TR]
[/TR]
[TR]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]661772[/TD]
[TD]Trish Newberg[/TD]
[TD=”class: nowrap, align: right”]43[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]1410917[/TD]
[TD]Karen Smith[/TD]
[TD=”class: nowrap, align: right”]39[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]120192[/TD]
[TD]Will Lynn[/TD]
[TD=”class: nowrap, align: right”]13[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]265671[/TD]
[TD]Ron Alford[/TD]
[TD=”class: nowrap, align: right”]13[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]1404871[/TD]
[TD]Michael Essig[/TD]
[TD=”class: nowrap, align: right”]12[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]784659[/TD]
[TD]Christopher N.[/TD]
[TD=”class: nowrap, align: right”]11[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]302448[/TD]
[TD]Laurie Lemieux[/TD]
[TD=”class: nowrap, align: right”]11[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]488016[/TD]
[TD]jeff lemieux[/TD]
[TD=”class: nowrap, align: right”]8[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]866699[/TD]
[TD]Lena Varuolo[/TD]
[TD=”class: nowrap, align: right”]8[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]126281[/TD]
[TD]Shawn Gallagher[/TD]
[TD=”class: nowrap, align: right”]7[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]136274[/TD]
[TD]Mark Blacknell[/TD]
[TD=”class: nowrap, align: right”]7[/TD]
[/TR]
[TR=”class: even, bgcolor: #CCFFCC”]
[TD=”class: nowrap, align: right”][/TD]
[TD][/TD]
[TD=”class: nowrap, align: right”][/TD]
[/TR]
[/TABLE]

[Amalitza]

@hozn 45603 wrote:

[TABLE=”class: data”]
[TR]
[/TR]
[TR]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]661772[/TD]
[TD]Trish Newberg[/TD]
[TD=”class: nowrap, align: right”]43[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]1410917[/TD]
[TD]Karen Smith[/TD]
[TD=”class: nowrap, align: right”]39[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]120192[/TD]
[TD]Will Lynn[/TD]
[TD=”class: nowrap, align: right”]13[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]265671[/TD]
[TD]Ron Alford[/TD]
[TD=”class: nowrap, align: right”]13[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]1404871[/TD]
[TD]Michael Essig[/TD]
[TD=”class: nowrap, align: right”]12[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]784659[/TD]
[TD]Christopher N.[/TD]
[TD=”class: nowrap, align: right”]11[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]302448[/TD]
[TD]Laurie Lemieux[/TD]
[TD=”class: nowrap, align: right”]11[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]488016[/TD]
[TD]jeff lemieux[/TD]
[TD=”class: nowrap, align: right”]8[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]866699[/TD]
[TD]Lena Varuolo[/TD]
[TD=”class: nowrap, align: right”]8[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]126281[/TD]
[TD]Shawn Gallagher[/TD]
[TD=”class: nowrap, align: right”]7[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]136274[/TD]
[TD]Mark Blacknell[/TD]
[TD=”class: nowrap, align: right”]7[/TD]
[/TR]
[TR=”class: even, bgcolor: #CCFFCC”]
[TD=”class: nowrap, align: right”][/TD]
[TD][/TD]
[TD=”class: nowrap, align: right”][/TD]
[/TR]
[/TABLE]

Oh no!:eek:

I thought it would be close (I have seen all those rides being posted around the same time as mine), but with a lead of 4 and less than two weeks left, I will have to hope Trish inexplicably decides it’s just time to quit the competition, or I have no hope of catching her!

[DismalScientist]

@acl 45607 wrote:

Oh no!:eek:

I thought it would be close (I have seen all those rides being posted around the same time as mine), but with a lead of 4 and less than two weeks left, I will have to hope Trish inexplicably decides it’s just time to quit the competition, or I have no hope of catching her!

Just manually upload you lunch rides 0.1 miles at a time. You’ll win this hands down.

[vvill]

Ok since I suggested these two award categories in the first place, I’ll award them

1) Person with most interesting shape made from a ride’s GPS map
2) Person with most rides manually entered

For 1) you have to send me nominations to be eligible (link to the Strava activity, please). You can nominate yourself, or anyone else. You can nominate more than one ride. Just PM me.

[Amalitza]

@mllwhnp 45554 wrote:

Is there a “Joe Ordinary” award? That is, the person who came closest to their pre BAFS handicap?

ahh, I see why you suggested this prize.

Joe Ordinary leaderboard, as of sometime this morning when I grabbed people’s scores.

Columns are points per week +/- handicap, total points +/- (where they should be as of today according to) handicap, and % off handicap. (The winner will be determined by percentage, but I’m putting the points out there too, so people can see how close they are in absolute terms). Greenbelt is in the lead, but this is absolutely still up for grabs. Positive points means you are beating your handicap and better back off a bit (except Rod. You shouldn’t back off at all. You don’t want to be **ordinary**, do you?). Negative points mean you’re a bit behind your handicap.

jeff lemieux: 6.9 /70.7/ 3%
Mark Blacknell: -6.7 / -68.7 /5%
Rod Smith: 17.6 /180.7/ 6%
Robert Cannon: -5.5 /-56.1 /6%
Kathy Lizotte: 5.5 /56.7/ 6%
Sean Chisham: -11.9/ -122 /8%
Mega Beth: -10.4 /-107.4 /9%
Shawn Gallagher: 10.5 /107.7/ 10%

[vvill]

@vvill 45874 wrote:

Ok since I suggested these two award categories in the first place, I’ll award them

1) Person with most interesting shape made from a ride’s GPS map
2) Person with most rides manually entered

For 1) you have to send me nominations to be eligible (link to the Strava activity, please). You can nominate yourself, or anyone else. You can nominate more than one ride. Just PM me.

Bumping 1). I haven’t had any nominations sent to me yet.

That said I will troll through some random rides to see if I can find some, so it won’t go unawarded.

Or someone go out and ride a fun shape and send it to me.

[Amalitza]

Have you ridden your bicycle in non-freezing conditions? Gotten lost on your way home from work? If so, you may be the winner of a Pointless Prize.

1) vvill, Robert O, TwoWheelsDC, and anyone else who thinks they may be a candidate for Non Freezing Riding, would you mind PMing me with approximate mileage and weather conditions. Winner will be an arbitrary and totally non-scientific combination of how far you rode and how warm and sunny it was. No need to be too precise.

2) Anyone who thinks they are a candidate for most circuitous ride home, please send me the link to the ride on Strava. Third party nominations are accepted– you may send me the link to someone else’s ride if you’d like to nominate them.

[jopamora]

@acl 46504 wrote:

Have you ridden your bicycle in non-freezing conditions? Gotten lost on your way home from work? If so, you may be the winner of a Pointless Prize.

2) Anyone who thinks they are a candidate for most circuitous ride home, please send me the link to the ride on Strava. Third party nominations are accepted– you may send me the link to someone else’s ride if you’d like to nominate them.

This one is easy – Mark Williams

[Greenbelt]

@jopamora 46512 wrote:

This one is easy – Mark Williams

Mark just threw down some serious miles!

Freezing Saddles – Team V (is for Victory): 12164 points (9387 miles)
Mark Williams: 5375 points (75 days, 4625 miles)
Will Lynn: 2872 points (74 days, 2132 miles)
Christopher N.: 2338 points (74 days, 1598 miles)
Kevin Ulrich: 1410 points (44 days, 970 miles)
Ben Hsu: 169 points (11 days, 59 miles)
Team 9 Bollard Busters: 9143 points (6334 miles)
Justin Antos: 2858 points (74 days, 2118 miles)
jeff lemieux: 2826 points (74 days, 2086 miles)
Peter Kong: 1831 points (65 days, 1181 miles)
Steve Offutt: 1628 points (68 days, 948 miles)

[rcannon100]

(Team V and Team 9 members: Please RSVP to me whether you are coming to the Phoenix Bike Show)

[jopamora]

Shenanigans?

[Author]

Posts