Longest Coldest Ride

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

Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • 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
    Posts
Viewing 10 posts - 1 through 10 (of 10 total)
  • You must be logged in to reply to this topic.