Longest Coldest Ride

Our Community › Forums › Freezing Saddles Winter Riding Competition › Longest Coldest Ride

  • Creator
    Topic
  • March 18, 2016 at 10:11 am #917998
    ewilliams0305
    Participant

    Chris and I are in need of Data for these Pointless prizes.

    Do we have the information somewhere accessible? Or do we need to have people submit entries?

    I’m all about making sure the winner actual goes on the forum;) but in the spirit of competition it does feel good…

    I think all we really need is distance, ride time, and average temperature. I’m.also open to suggestions as to how we include ride time into the calculations because the truly longest coldest ride could be longer if your slower and I know we like to award slow around here:)

  • Creator
    Topic
Viewing 10 replies - 1 through 10 (of 10 total)
  • Author
    Replies
  • March 18, 2016 at 10:19 am #1049673
    hozn
    Participant

    We obviously have the data, “accessible” depends a bit on familiarity with SQL. I am happy to get people DB access. For queries like this, I can also run it, as it should be trivial. (Just finalize exactly what you mean by “longest”, obviously. )

    March 18, 2016 at 2:23 pm #1049692
    creadinger
    Participant

    @hozn 137010 wrote:

    We obviously have the data, “accessible” depends a bit on familiarity with SQL. I am happy to get people DB access. For queries like this, I can also run it, as it should be trivial. (Just finalize exactly what you mean by “longest”, obviously. )

    For my cold prizes, I have pretty specific information that I need:

    1) The ride during the coldest recorded temperature (doesn’t have to be local, and if there are ties, then distance will break it).

    2) I looked back through wunderground data for IAD, DCA, and BWI and it looks like 2/14 was the day with the coldest high temperature. So I need the longest localish ride on 2/14. Or, if non-local rides occurred on 2/14 in lower temperatures elsewhere, I’ll consider them as well.

    Thanks!

    March 18, 2016 at 2:26 pm #1049693
    hozn
    Participant

    Oh, ok. That is pretty easy. I can also give you longest (elapsed time? moving time? distance?) ride with the coldest temperature for that ride. I.e. avg ride temp lowest and longest. Not sure how exactly we would sort.

    But can easily just find longest-distance rides on a specific da of that is what you want.

    March 18, 2016 at 2:27 pm #1049694
    Steve O
    Participant

    @creadinger 137028 wrote:

    For my cold prizes, I have pretty specific information that I need:

    1) The ride during the coldest recorded temperature (doesn’t have to be local, and if there are ties, then distance will break it).

    2) I looked back through wunderground data for IAD, DCA, and BWI and it looks like 2/14 was the day with the coldest high temperature. So I need the longest localish ride on 2/14. Or, if non-local rides occurred on 2/14 in lower temperatures elsewhere, I’ll consider them as well.

    Thanks!

    This is already on the Freezing Saddles website. Scroll over to get time of the ride.
    [ATTACH=CONFIG]11276[/ATTACH]

    March 18, 2016 at 3:43 pm #1049697
    creadinger
    Participant

    @Steve O 137030 wrote:

    This is already on the Freezing Saddles website. Scroll over to get time of the ride.
    [ATTACH=CONFIG]11276[/ATTACH]

    As a non-freezing saddles participant I didn’t think I’d have access. What is the link again? As I recall, the website is blocked here at work, so I’ll check at home. Something probably about how saddle could mean many other things, and freezing saddles… well obviously that’s some fetish site not related to bicycling in winter.

    March 18, 2016 at 3:56 pm #1049698
    creadinger
    Participant

    @hozn 137029 wrote:

    Oh, ok. That is pretty easy. I can also give you longest (elapsed time? moving time? distance?) ride with the coldest temperature for that ride. I.e. avg ride temp lowest and longest. Not sure how exactly we would sort.

    But can easily just find longest-distance rides on a specific da of that is what you want.

    This is how I stated it in the beginning…. “1) awarding the coldest overall temperature ride.. pretty self explanatory unless there are ties. Longest ride wins. 2) Longest ride on the day with the coldest high temperature. So, that would be 2/14.

    And by longest I mean distance.

    March 18, 2016 at 5:39 pm #1049709
    Steve O
    Participant

    I think anyone can access freezingsaddles.com without being signed up.
    Just click on the Leaderboards menu item > Individual (Various)
    [ATTACH=CONFIG]11281[/ATTACH]

    Select and click on “Draw Chart”
    [ATTACH=CONFIG]11282[/ATTACH]
    Easy. There’s a whole bunch of these different leaderboards, both for individuals and teams.

    March 20, 2016 at 10:21 pm #1049846
    ewilliams0305
    Participant

    So mine is slightly more complex:(

    I said I would take the distance ridden devided by the temperature. The person with the highest number wins. Absolute zero will be zero since we really didn’t get any rides below zero. Ill keep it simple and just use elapsed time as a tie breaker.

    Is there an easy way to simply look at all the rides logged on the coldest days? However a century on a slightly warmer day could actually be the winner.

    March 21, 2016 at 12:30 am #1049851
    hozn
    Participant

    Distance divided by temp might actually be easier since it is a simple query. If you know SQL, though, and want db access shoot me an email (hans-at-velum.net).

    March 21, 2016 at 2:09 am #1049856
    Rod Smith
    Participant

    According to Freezing Saddles website my coldest ride was a 63.5 mile jaunt at 22.65ºF for a score of 2.80

  • Author
    Replies
Viewing 10 replies - 1 through 10 (of 10 total)
  • You must be logged in to reply to this topic.