Freezing Saddles Pointless Prizes

[consularrider]

@eminva 43399 wrote:

I think we have more than that. We will almost certainly have many winners.

Liz

You’re absolutely right, I thought I had gone far enough down in the list, but clearly not. I get 14 with either 37 or 38 days (some with less may just not have logged yet this week). And how does someone have 42 days on the 38th day of the contest? Is there a rift in the space/time continuum?

[americancyclo]

@consularrider 43412 wrote:

And how does someone have 42 days on the 38th day of the contest? Is there a rift in the space/time continuum?

Weird, her Strava profile says only 418 miles YTD while the leader board has her at 482 miles. She’s definitely got the dedication!

[consularrider]

@americancyclo 43415 wrote:

Weird, her Strava profile says only 418 miles YTD while the leader board has her at 482 miles. She’s definitely got the dedication!

It’s the wormhole near Tim Kelley’s?

[Tim Kelley]

@consularrider 43416 wrote:

It’s the wormhole near Tim Kelley’s?

No–it’s gotta be in North Arlington!

[consularrider]

Oh yeah, that’s Old Dominion not Wilson or Fairfax.

[TrishN]

That’s me you’re talking about. I posted this to the “Freezing Saddles: Winter Bike Challenge (sign up open)” thread:

” Oopsie

I accidentally uploaded some rides recorded on my Garmin that I’d already uploaded via the Strava phone app. I deleted the duplicate rides from Strava, but the duplicate rides are still being included in the “BikeArlington Freezing Saddles Competition” page. My YTD distance s/b 418, not 482. Is there any way to fix this?

Thanks!

Trish Newberg “

[Rod Smith]

Haha, at least it got you to finally register and post on the forum! Howdy neighbor! Where do I know you from if you haven’t posted here before? Facebook, Strava, it’s a small world. We live within blocks of each other, yet never met in real life.

[ejwillis62]

I think this winter I qualify for a first place prize for having spent the most money on new stuff, new bike, new bike seat, new shoes, pedals for said shoes, winter riding pants, winter base layers, gloves, hats, lights, bar mits (they are awesome) etc… the list is huge. Cold weather and having the mount vernon trail all to myself…priceless….

[KelOnWheels]

@ejwillis62 43437 wrote:

I think this winter I qualify for a first place prize for having spent the most money on new stuff, new bike, new bike seat, new shoes, pedals for said shoes, winter riding pants, winter base layers, gloves, hats, lights, bar mits (they are awesome) etc… the list is huge. Cold weather and having the mount vernon trail all to myself…priceless….

Purple bikes should be worth extra points too! Plus you have a LONG commute. You rock!

[ejwillis62]

I was enjoying myself out there today. It was cold but really awesome and I definitely think the purple bike is worth extra. And the pure helmet, purple hat and beautiful pink jacket and new black shoes with matching pink stripes. I just need purple tassels.

[hozn]

I have gotten my freezing saddles data mining codebase to a ready enough state to post about it. It’s very preliminary (and very ugly) and doesn’t do much of anything yet, but the API is working and the data is there and there’s lots of potential and I plan to continue development on this and am open to suggestions — and Git pull requests

Here is the code in case you’d like to play with / enhance this yourself:

https://github.com/hozn/bafs.git

There are some crude setup instructions there, but feel free to post or PM me if you have problems or more questions.

Here is the web application running. Right now it’s just showing some barcharts of team & individual leaderboards (the data may be a bit stale as at this time I have not yet set up the cron jobs to sync the data).

http://freezing.hozn.net/

I will probably turn my attention to the UI for a little bit — enjoying getting a chance to play w/ Google’s charting API — but also plan to add wunderground integration to the sync script to pull down general weather data for each ride.

Also, if anyone would like read access to the MySQL database under the hood here (to run your own queries, etc.) please PM me and I’ll setup a user / send you the creds.

[Greenbelt]

All those MTB rides in Nepal definitely deserve some sort of pointless prize.

[rcannon100]

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

[Amalitza]

@hozn 44148 wrote:

am open to suggestions —

eminva is awarding a prize for team with most Hain’s point laps. She currently is requesting us to send her our numbers when we get close to the end, but it seems to me that this might be able to be pulled from strava segments?

Some other suggested awards (but which no one has yet offered to award, hint hint people), which I think would require strava data are weekend and weekday warriors, latest owl and earliest bird, most sleaze rides, and most rides manually entered. If any of those interest you, I’ll try to see about getting awards.

Oh, wait, PeteD is working on data for the weekend (but not weekday) warrior.

Speaking of, we could use someone (hint, hint) to do the award for weekend warrior and coldest ride, which Pete is working on the data.

@Greenbelt 44154 wrote:

All those MTB rides in Nepal definitely deserve some sort of pointless prize.

Are you volunteering? :p (king/queen of the world– most international kom/qom’s is on the suggested list– (i should know since I suggested it)– but “hey! mountain bike rides in Nepal!” sounds like perfectly fine prize too, at least to me)

@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

nomination accepted…

[hozn]

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

http://freezing.hozn.net/

I can help with some of these other questsions — e.g. weekday/weekend distance is a pretty trivial query.

Right now here’s what weekday warrior looks like:

mysql> select
-> A.id,
-> A.name,
-> sum(distance) as total_distance
-> from daily_scores DS
-> join athletes A on A.id = DS.athlete_id
-> where DAYOFWEEK(ride_date) IN (2,3,4,5,6)
-> group by A.id, A.name
-> order by total_distance desc
-> ;
+

---

+

---

+

---

+
| id | name | total_distance |
+

---

+

---

+

---

+
| 1129136 | Rod Smith | 1337.2003955841064 |
| 75834 | Pete Beers | 1258.796175301075 |
| 182475 | Hans Lellelid | 1166.668829202652 |
| 754817 | Shawn Dread | 1102.5912912487984 |
| 300685 | Chris Randall | 1078.8127031326294 |
| 488016 | jeff lemieux | 1025.880711555481 |
| 120192 | Will Lynn | 966.9974447488785 |
| 186394 | Elizabeth M. | 907.9707537293434 |

But it’s a little closer for weekend warrior:

mysql> select
-> A.id,
-> A.name,
-> sum(distance) as total_distance
-> from daily_scores DS
-> join athletes A on A.id = DS.athlete_id
-> where DAYOFWEEK(ride_date) IN (1,7)
-> group by A.id, A.name
-> order by total_distance desc
-> ;
+

---

+

---

+

---

+
| id | name | total_distance |
+

---

+

---

+

---

+
| 300685 | Chris Randall | 658.0815916061401 |
| 1473093 | Justin Antos | 619.3079282045364 |
| 75834 | Pete Beers | 596.2577639818192 |
| 1129136 | Rod Smith | 559.4644396305084 |
| 550287 | Kevin Ulrich | 326.3741452693939 |
| 10446 | Sean Chisham | 323.4553096294403 |
| 784659 | Christopher N. | 317.126194357872 |

(of course you may wish to use % of riding instead of just how many miles ridden?)

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.)

[Author]

Posts