Freezing Saddles Pointless Prizes

[ShawnoftheDread]

@hozn 44464 wrote:

Probably another good leaderboard is total time in the saddle.

.

One for us slowpokes. I like it.

[hozn]

@ShawnoftheDread 44467 wrote:

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

This was as I understood it, though my query was more like “sleaze days”. I assumed the 10 points were based on total miles (i.e. at least 1.0) for the day. If that is wrong I need to adjust my points algorithm.

[Arlingtonrider]

@ShawnoftheDread 44468 wrote:

.

One for us slowpokes. I like it.

Total time in the saddle wouldn’t necessarily pick up the slowpokes, though. We have a lot of faster riders with a lot of saddle time. I think it would take a different algorithm that also takes mileage into account to pick up the slow folks.

[Bilsko]

@hozn 44417 wrote:

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

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…

[rcannon100]

@hozn 44469 wrote:

This was as I understood it, though my query was more like “sleaze days”. I assumed the 10 points were based on total miles (i.e. at least 1.0) for the day. If that is wrong I need to adjust my points algorithm.

Er, Shawn is right; I spoke clumsily. And You are saying it better. It really is a sleaze “day.” As long as in one day, the rider rides a mile or more , then the rider gets the 10 point bonus. So it can be .5 + .5 in one day or whatever. But the total of the rides for the day needs to be 1 mile or more.

[culimerc]

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

[hozn]

@Bilsko 44474 wrote:

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]

@eminva 44428 wrote:

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]

@hozn 44566 wrote:

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]

@GuyContinental 44573 wrote:

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]

@hozn 44566 wrote:

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]

@vvill 44611 wrote:

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

[TABLE=”class: data”]
[TR]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]564600[/TD]
[TD]Kathy Lewis[/TD]
[TD=”class: nowrap, align: right”]46[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]1412719[/TD]
[TD]Brad Hancock[/TD]
[TD=”class: nowrap, align: right”]38[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]1473093[/TD]
[TD]Justin Antos[/TD]
[TD=”class: nowrap, align: right”]34[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]300685[/TD]
[TD]Chris Randall[/TD]
[TD=”class: nowrap, align: right”]28[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]313677[/TD]
[TD]Randy Napiza[/TD]
[TD=”class: nowrap, align: right”]27[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]120192[/TD]
[TD]Will Lynn[/TD]
[TD=”class: nowrap, align: right”]25[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]75834[/TD]
[TD]Pete Beers[/TD]
[TD=”class: nowrap, align: right”]23[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]784659[/TD]
[TD]Christopher N.[/TD]
[TD=”class: nowrap, align: right”]21[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]1224809[/TD]
[TD]Ken Buja[/TD]
[TD=”class: nowrap, align: right”]12[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]10446[/TD]
[TD]Sean Chisham[/TD]
[TD=”class: nowrap, align: right”]12[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]1129136[/TD]
[TD]Rod Smith[/TD]
[TD=”class: nowrap, align: right”]11[/TD]
[/TR]
[/TABLE]

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;

[Author]

Posts