Freezing Saddles Pointless Prizes

[culimerc]

My best (and only) sleaze ride to date was worth 11 points!

[hozn]

Wunderground is good, but not always the best for hourly data. I use the Utah Climate Center's tool for good hrly data ( no API, but data can be exported to Google Docs or similar for integration with Strava data). Dont have the coding skills to be of much help, but I can help you find the right data if it helps...

I will look at alternatives. As it is my wunderground developer key limits me to 500 calls per day, so weather information for the rides (almost 3k, I think?) would need to be spaced out over a week or so. That's kind clunky. I played with the Utah Climate Center's tool a bit; it looks interesting, but I really need to be able to use some sort of API (even if screen scraping) so I can feet it lat & lon (or locality name if there's no geo for the ride) and have it return weather for that area. (Of course *most* of the rides are local here, but not all of them.)

[vvill]

I think the Weather Channel has an API? Never tried it though.

Endomondo had some weather info it was pulling for uploaded rides, but I don't know the data source.

[hozn]

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

Sorry that I never responded directly to this; I missed it in my updates.

Yeah, I went ahead and added support this weekend for segment tracking. It took awhile to initially fill that data in, but it's all there now (but not exposed in the UI). I need to look up the Hains Point segments (and any others that might be of interest), but it should be relatively easy to build a leaderboard for most times around Hains point, etc.

On a less-directly-related note, I began updating the UI to support a more generic way of pulling up different leaderboards. I will update everything to use this new model over the course of the week. Here's the new basic format with a couple new metrics, such as time in the saddle (perhaps not surprisingly dominated by Rod Smith):

http://freezing.hozn.net/leaderboard/individual_generic

-Hans

[GuyContinental]

Wow Hans, there is some great stuff in there! Something for everyone... I seem to be a very fast sleaze ;-)

I suppose that now that you have the pieces in place you could implement for the BA Strava club, no?

[Dickie]

Sorry all, been out of the country due to a family emergency. I am SOOOO out of the loop and trying to get caught up over the next few days. I offered a pointless prize called the "DIRT-Y Mustache award", for the most polite rider dealing with an un-polite situation..... any nominees? There is a nice wooden bicycle mustache just waiting to be awarded (or mailed) to you.

[eminva]

Yeah, I went ahead and added support this weekend for segment tracking. It took awhile to initially fill that data in, but it's all there now (but not exposed in the UI). I need to look up the Hains Point segments (and any others that might be of interest), but it should be relatively easy to build a leaderboard for most times around Hains point, etc.

-Hans

Thank you, Hans! Appreciate the effort.

So, hear that, ya'll? Get your Hains Point Loops in so that you can be considered for this fabulous pointless prize!

(And those of you tracking manually, I'll be happy to collect your data by private message as the competition draws to a close.)

Liz

[hozn]

Wow Hans, there is some great stuff in there! Something for everyone... I seem to be a very fast sleaze ;-)

I suppose that now that you have the pieces in place you could implement for the BA Strava club, no?

Yeah, this can be applied to any Strava club (or set of clubs), really. After the competition is over, I'm going to go back through to clean things up, make the application more generic, and write up more detailed instructions so that it can be used/extended by others around the world that might want to use Strava for similar cycling competitions. (I suppose it would work for other activities too, though there are probably some cycling assumptions here.)

[vvill]

I need to look up the Hains Point segments (and any others that might be of interest), but it should be relatively easy to build a leaderboard for most times around Hains point, etc.

I think these are the main two. First is the full loop but may miss those who start a loop from the north corner. The second should cover most if not all iterations.
http://app.strava.com/segments/614873
http://app.strava.com/segments/1081507

[hozn]

I think these are the main two. First is the full loop but may miss those who start a loop from the north corner. The second should cover most if not all iterations.
http://app.strava.com/segments/614873
http://app.strava.com/segments/1081507

Thanks, vvill.

So, does this top-X look about right (I just grabbed the top few)?

564600	Kathy Lewis	46
1412719	Brad Hancock	38
1473093	Justin Antos	34
300685	Chris Randall	28
313677	Randy Napiza	27
120192	Will Lynn	25
75834	Pete Beers	23
784659	Christopher N.	21
1224809	Ken Buja	12
10446	Sean Chisham	12
1129136	Rod Smith	11

I think I did that right ...

select A.id, A.name, count(E.id) as hains_loops
from athletes A
join rides R on R.athlete_id = A.id
join ride_efforts E on E.ride_id = R.id
where E.segment_id = 1081507
group by A.id, A.name
order by hains_loops desc;