Freezing Saddles Pointless Prizes

[Amalitza]

@hozn 44417 wrote:

BTW, I applied some updates to my data mining site.

“Individual Elevation Gain”?!?!:confused::eek::eek:

crap

[Justin Antos]

@hozn 44417 wrote:

BTW, I applied some updates to my data mining site. I will start working on weather integration next.

This is great stuff!!

[hozn]

@acl 44421 wrote:

“Individual Elevation Gain”?!?!:confused::eek::eek:

crap

That was just an example of other things we can do. I left it in since apparently I stumbled upon a category where I am in first place Avg speed of rides is another easy one I might add — in addition to the environmental ones.

[KayakCyndi]

@acl 44416 wrote:

king/queen of the world– most international kom/qom’s

nomination accepted…

Queen of the world sounds awesome to me!

[KayakCyndi]

@KayakCyndi 44424 wrote:

Queen of the world sounds awesome to me!

Can someone get me a crown?

[Steve O]

@rcannon100 44314 wrote:

And you thought vvill had a lock on the pointless prize for freezing saddle ride in the warmest climate. Well, we now have another contender

http://app.strava.com/activities/41525327

I’m curious about the 100 mph section, too. And not even on much of a hill.

[eminva]

@acl 44421 wrote:

“Individual Elevation Gain”?!?!:confused::eek::eek:

crap

A category that favors the Custis commuter!

hozn, this is amazing magic that you are performing. Is it possible to datamine (is that a word?) a particular segment? I am awarding most Hains Point loops (team and possibly individual, if a clear winner can be determined with certainty). I imagine the way to do this would be to pick one of the HP segments (e.g., gate to gate) and tally the number of times each participant has ridden it over the time period. Is this possible?

Thanks.

Liz

[KelOnWheels]

@hozn 44417 wrote:

BTW, I applied some updates to my data mining site. I will start working on weather integration next.

There should also probably be an award for most sleaze rides, if that hasn’t already been proposed.

mysql> select
-> A.id,
-> A.name,
-> count(*) as rides
-> from daily_scores DS
-> join athletes A on A.id = DS.athlete_id
-> where distance < 2.0
-> group by A.id, A.name
-> order by rides desc
-> ;
+

---

+

---

+

---

+
| id | name | rides |
+

---

+

---

+

---

+
| 136274 | Mark Blacknell | 13 |
| 645556 | Kel Moore | 13 |
| 580874 | Mark Nielsen | 11 |
| 564600 | Kathy Lewis | 10 |
| 1224809 | Ken Buja | 10 |
| 1410917 | Karen Smith | 10 |
| 126281 | Shawn Gallagher | 9 |
| 754817 | Shawn Dread | 9 |

(I might have some bugs in these queries.)

What? Tied with Blacknell?! I gotta fix that

[Justin Antos]

@hozn 44417 wrote:

There should also probably be an award for most sleaze rides, if that hasn’t already been proposed.

mysql> select
-> A.id,
-> A.name,
-> count(*) as rides
-> from daily_scores DS
-> join athletes A on A.id = DS.athlete_id
-> where distance < 2.0
-> group by A.id, A.name
-> order by rides desc
-> ;
+

---

+

---

+

---

+
| id | name | rides |
+

---

+

---

+

---

+
| 136274 | Mark Blacknell | 13 |
| 645556 | Kel Moore | 13 |
| 580874 | Mark Nielsen | 11 |
| 564600 | Kathy Lewis | 10 |
| 1224809 | Ken Buja | 10 |
| 1410917 | Karen Smith | 10 |
| 126281 | Shawn Gallagher | 9 |
| 754817 | Shawn Dread | 9 |

What makes a ride even more sleazy is when the short ride was also the only ride for that day – i.e. you just did it for the 10 point bonus. I can’t tell if that’s what the SQL statement is showing? Is there a way to make the Sleaze Leaderboard the most “days where Points < 12?"

[rcannon100]

@KelOnWheels 44431 wrote:

What? Tied with Blacknell?! I gotta fix that

Me too. I am entirely embarrassed to not be on this list!

[vvill]

Now we need elevation gain on a single speed.

just kidding! Great work hozn.

[hozn]

@Justin Antos 44439 wrote:

What makes a ride even more sleazy is when the short ride was also the only ride for that day – i.e. you just did it for the 10 point bonus. I can’t tell if that’s what the SQL statement is showing? Is there a way to make the Sleaze Leaderboard the most “days where Points < 12?"

Yes, absolutely. (That query is still similar, since it is looking at total miles for the day.) I will add this to the site and use points instead of mileage.

[hozn]

@vvill 44445 wrote:

Now we need elevation gain on a single speed.

just kidding! Great work hozn.

If everyone provides the names of their singlespeeds (according to Strava), I can do that

Probably another good leaderboard is total time in the saddle.

[rcannon100]

@hozn 44463 wrote:

Yes, absolutely. (That query is still similar, since it is looking at total miles for the day.) I will add this to the site and use points instead of mileage.

A sleaze ride must be one mile or more. So searching for total miles per day < 2 will not get you the proper answer. Looking for total points per day < 12 I believe will.

[ShawnoftheDread]

@rcannon100 44466 wrote:

A sleaze ride must be one mile or more. So searching for total miles per day < 2 will not get you the proper answer. Looking for total points per day < 12 I believe will.

No, two half-mile rides would be two sleaze rides, as you’d get the minimum daily points.

[Author]

Posts