Page 9 of 19 FirstFirst ... 7891011 ... LastLast
Results 81 to 90 of 188

Thread: Freezing Saddles Pointless Prizes

  1. #81
    Join Date
    Nov 2011
    Location
    Falls Church
    Posts
    431
    Post Thanks / Like

    Default

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

  2. #82
    Join Date
    Jun 2012
    Location
    Arlington
    Posts
    883
    Post Thanks / Like

    Default

    Quote Originally Posted by Bilsko View Post
    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.)

  3. #83
    vvill's Avatar
    vvill is offline I really need to log off the internet and go for a ride.
    Join Date
    Jul 2011
    Location
    McLean, VA <=> DC
    Posts
    1,837
    Post Thanks / Like

    Default

    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.

  4. #84
    Join Date
    Jun 2012
    Location
    Arlington
    Posts
    883
    Post Thanks / Like

    Default

    Quote Originally Posted by eminva View Post
    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

  5. #85
    Join Date
    Dec 2011
    Location
    Clarendon
    Posts
    754
    Post Thanks / Like

    Default

    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?

  6. #86
    Join Date
    Sep 2011
    Location
    Rosslyn, VA
    Posts
    890
    Post Thanks / Like

    Default 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.
    Attached Images Attached Images  

  7. #87
    Join Date
    Nov 2010
    Location
    Vienna, VA to Farragut North
    Posts
    1,403
    Post Thanks / Like

    Default

    Quote Originally Posted by hozn View Post
    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

  8. #88
    Join Date
    Jun 2012
    Location
    Arlington
    Posts
    883
    Post Thanks / Like

    Default

    Quote Originally Posted by GuyContinental View Post
    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.)

  9. #89
    vvill's Avatar
    vvill is offline I really need to log off the internet and go for a ride.
    Join Date
    Jul 2011
    Location
    McLean, VA <=> DC
    Posts
    1,837
    Post Thanks / Like

    Default

    Quote Originally Posted by hozn View Post
    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

  10. #90
    Join Date
    Jun 2012
    Location
    Arlington
    Posts
    883
    Post Thanks / Like

    Default

    Quote Originally Posted by vvill View Post
    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;

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •