My best (and only) sleaze ride to date was worth 11 points!
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.)
Originally Posted by Bilsko
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.
Sorry that I never responded directly to this; I missed it in my updates.
Originally Posted by 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.
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):
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?
Dirt-Y Mustache award
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.
Thank you, Hans! Appreciate the effort.
Originally Posted by hozn
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.)
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.
Originally Posted by hozn
Originally Posted by vvill
So, does this top-X look about right (I just grabbed the top few)?
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;