[hozn]

I think the official leaderboard won’t clear out the [apparently?] bogus entry(s) from Mark Williams until it does the daily refresh.

[hozn]

@acl 46504 wrote:

1) vvill, Robert O, TwoWheelsDC, and anyone else who thinks they may be a candidate for Non Freezing Riding, would you mind PMing me with approximate mileage and weather conditions. Winner will be an arbitrary and totally non-scientific combination of how far you rode and how warm and sunny it was. No need to be too precise.

I am happy to provide some numbers if you like. A surprising number of the top warmest rides (especially if you consider distance) are actually right here.

[TABLE=”class: data”]
[TR]
[TH=”bgcolor: #D3DCE3, colspan: 6″][/TH]
[/TR]
[TR]
[TH=”bgcolor: #D3DCE3″]ride[/TH]
[TH=”bgcolor: #D3DCE3″]date[/TH]
[TH=”bgcolor: #D3DCE3″]location[/TH]
[TH=”bgcolor: #D3DCE3″]athlete[/TH]
[TH=”bgcolor: #D3DCE3″]distance[/TH]
[TH=”bgcolor: #D3DCE3″]avg_ride_temp[/TH]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]41954722[/TD]
[TD=”class: nowrap”]2013-02-23[/TD]
[TD]Xelha, Quintana Roo[/TD]
[TD]Robert O.[/TD]
[TD=”class: nowrap, align: right”]2[/TD]
[TD=”class: nowrap, align: right”]82[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]41878149[/TD]
[TD=”class: nowrap”]2013-02-22[/TD]
[TD]Xelha, Quintana Roo[/TD]
[TD]Robert O.[/TD]
[TD=”class: nowrap, align: right”]7[/TD]
[TD=”class: nowrap, align: right”]79[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]41674111[/TD]
[TD=”class: nowrap”]2013-02-20[/TD]
[TD]Xelha, Quintana Roo[/TD]
[TD]Robert O.[/TD]
[TD=”class: nowrap, align: right”]1[/TD]
[TD=”class: nowrap, align: right”]78[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]41525327[/TD]
[TD=”class: nowrap”]2013-02-19[/TD]
[TD]Xelha, Quintana Roo[/TD]
[TD]Robert O.[/TD]
[TD=”class: nowrap, align: right”]12[/TD]
[TD=”class: nowrap, align: right”]78[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]41674108[/TD]
[TD=”class: nowrap”]2013-02-20[/TD]
[TD]Xelha, Quintana Roo[/TD]
[TD]Robert O.[/TD]
[TD=”class: nowrap, align: right”]2[/TD]
[TD=”class: nowrap, align: right”]77[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]43059189[/TD]
[TD=”class: nowrap”]2013-03-03[/TD]
[TD]Austin, TX[/TD]
[TD]Christopher N.[/TD]
[TD=”class: nowrap, align: right”]2[/TD]
[TD=”class: nowrap, align: right”]75[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]35530111[/TD]
[TD=”class: nowrap”]2013-01-03[/TD]
[TD]NULL[/TD]
[TD]Crystal Bae[/TD]
[TD=”class: nowrap, align: right”]3[/TD]
[TD=”class: nowrap, align: right”]73[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]39199090[/TD]
[TD=”class: nowrap”]2013-01-30[/TD]
[TD]College Park, MD[/TD]
[TD]Ron Alford[/TD]
[TD=”class: nowrap, align: right”]6[/TD]
[TD=”class: nowrap, align: right”]73[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]39177415[/TD]
[TD=”class: nowrap”]2013-01-30[/TD]
[TD]Mount Rainier, MD[/TD]
[TD]Trish Newberg[/TD]
[TD=”class: nowrap, align: right”]10[/TD]
[TD=”class: nowrap, align: right”]71[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]39093009[/TD]
[TD=”class: nowrap”]2013-01-29[/TD]
[TD]Mount Rainier, MD[/TD]
[TD]Rod Smith[/TD]
[TD=”class: nowrap, align: right”]5[/TD]
[TD=”class: nowrap, align: right”]71[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]39207446[/TD]
[TD=”class: nowrap”]2013-01-30[/TD]
[TD]Mount Rainier, MD[/TD]
[TD]Rod Smith[/TD]
[TD=”class: nowrap, align: right”]54[/TD]
[TD=”class: nowrap, align: right”]71[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]42613637[/TD]
[TD=”class: nowrap”]2013-02-28[/TD]
[TD]San Diego, CA[/TD]
[TD]Marc Mitcham[/TD]
[TD=”class: nowrap, align: right”]65[/TD]
[TD=”class: nowrap, align: right”]70[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]39171736[/TD]
[TD=”class: nowrap”]2013-01-30[/TD]
[TD]Silver Spring, MD[/TD]
[TD]Peter Kong[/TD]
[TD=”class: nowrap, align: right”]2[/TD]
[TD=”class: nowrap, align: right”]70[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]39173369[/TD]
[TD=”class: nowrap”]2013-01-30[/TD]
[TD]Greenbelt, MD[/TD]
[TD]Ron Alford[/TD]
[TD=”class: nowrap, align: right”]8[/TD]
[TD=”class: nowrap, align: right”]70[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]39099468[/TD]
[TD=”class: nowrap”]2013-01-29[/TD]
[TD]Greenbelt, MD[/TD]
[TD]Ron Alford[/TD]
[TD=”class: nowrap, align: right”]16[/TD]
[TD=”class: nowrap, align: right”]70[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]35026771[/TD]
[TD=”class: nowrap”]2013-01-01[/TD]
[TD]Lane Cove, NSW[/TD]
[TD]Will Lynn[/TD]
[TD=”class: nowrap, align: right”]64[/TD]
[TD=”class: nowrap, align: right”]70[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]35282429[/TD]
[TD=”class: nowrap”]2013-01-02[/TD]
[TD]Lane Cove, NSW[/TD]
[TD]Will Lynn[/TD]
[TD=”class: nowrap, align: right”]2[/TD]
[TD=”class: nowrap, align: right”]70[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]39070799[/TD]
[TD=”class: nowrap”]2013-01-29[/TD]
[TD]Washington, DC[/TD]
[TD]Robert O.[/TD]
[TD=”class: nowrap, align: right”]1[/TD]
[TD=”class: nowrap, align: right”]69[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]39076384[/TD]
[TD=”class: nowrap”]2013-01-29[/TD]
[TD]Washington, DC[/TD]
[TD]Chris Maimone[/TD]
[TD=”class: nowrap, align: right”]1[/TD]
[TD=”class: nowrap, align: right”]69[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]39197909[/TD]
[TD=”class: nowrap”]2013-01-30[/TD]
[TD]Washington, DC[/TD]
[TD]Shawn Dread[/TD]
[TD=”class: nowrap, align: right”]16[/TD]
[TD=”class: nowrap, align: right”]69
[/TD]
[/TR]
[/TABLE]

Note that these are only individual rides. I can get a sum of miles above X temperature or something more complex, if desired. This might also be one of the better ones for human interpretation, since I’m sure everyone feels that rides out in the desert during ‘freezing saddles’ are more “unfreezing” than the 70F local rides.

[hozn]

I’m Hans, the guy on the left from this few-year-old race-day photo:

[ATTACH=CONFIG]2541[/ATTACH]
I work for a small software engineering company out in Reston that has very cycling-friendly benefits — and even sponsors a cycling team (we have a 9-person team for a ~100-person company, so that seems like a good ratio; and there are other more casual cyclists here that aren’t on the team).

I tend to do most of my riding during the week (commuting). As it’s getting warmer I’ll be doing more riding with my son; he loves his iGo:
[ATTACH=CONFIG]2542[/ATTACH]

This is my normal commuter bike/setup:
[ATTACH=CONFIG]2544[/ATTACH]
This is when I want to have fun in the woods on the way to/from work:
[ATTACH=CONFIG]2543[/ATTACH]
And this is when I’m out doing a weekend road ride or a longer pre-work morning ride:
[ATTACH=CONFIG]2540[/ATTACH]

[hozn]

You are right, sorry to create confusion; what I said was subtly different than what you wrote. I don’t know the cron schedule for the official leaderboard. I was planning to ensure my sync script runs at 9:30 or just after and basically any subsequent runs would fail the “is it before end of competition?” check.

It sounds like Ron’s method may have a little gray area (e.g. if he’s not tired by 9:30 — maybe out cycling himself!), but I think the gist here is to make sure rides are uploaded by 9:30 to guarantee they count. I am assuming that Ron will make any necessary allowances for the sync schedule if his script.

[hozn]

I will have my site/db follow the same rules for consistency. — i.e. Rides have to be *uploaded* by 9:30 pm to count.

[hozn]

@mstone 45710 wrote:

To be fair, it is harder to get a good MTB workout inside the beltway due to the lack of, well, mountains.

Yes, it’s true that inside the beltway there are very few mountain biking options, but just outside the beltway there are lots of miles to be had. I would say that mountain biking can be a much better — or at least full-body — workout than road biking, but I would also agree that riding at 5mph on pavement is probably not going to work wonders.

Ultimately, though, there is nothing about a heavy mountain bike that will prevent you from losing weight/getting in shape. — Any more than there is something about a light road bike that will facilitate it. It’s just exercise; push yourself and you will get results.

Of course, once you bike more, you will probably want to get a lighter/faster bike for road riding — or a fancier mtb for off-road trail riding. That constant urge to upgrade equipment is just a symptom of cycling. At least that’s what I tell myself.

[hozn]

Yeah, apologies, you can’t just add dates together in MySQL using the “+” operator, apparently (horrid database!) And I was only getting rides between noon and 2pm due to use of “>” instead of “>=”; that one was my fault

Here is the correct query (as a note-to-self) and the top X:

select A.id athlete_id, A.name as athlete_name, count(R.id) as lunch_rides
from ride_start_end R join athletes A on A.id = R.athlete_id
where hour(R.ride_start) >= 11 and hour(R.ride_start) < 14 and hour(R.ride_end) < 14
group by A.id, A.name
order by lunch_rides desc;

[TABLE=”class: data”]
[TR]
[/TR]
[TR]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]661772[/TD]
[TD]Trish Newberg[/TD]
[TD=”class: nowrap, align: right”]43[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]1410917[/TD]
[TD]Karen Smith[/TD]
[TD=”class: nowrap, align: right”]39[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]120192[/TD]
[TD]Will Lynn[/TD]
[TD=”class: nowrap, align: right”]13[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]265671[/TD]
[TD]Ron Alford[/TD]
[TD=”class: nowrap, align: right”]13[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]1404871[/TD]
[TD]Michael Essig[/TD]
[TD=”class: nowrap, align: right”]12[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]784659[/TD]
[TD]Christopher N.[/TD]
[TD=”class: nowrap, align: right”]11[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]302448[/TD]
[TD]Laurie Lemieux[/TD]
[TD=”class: nowrap, align: right”]11[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]488016[/TD]
[TD]jeff lemieux[/TD]
[TD=”class: nowrap, align: right”]8[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]866699[/TD]
[TD]Lena Varuolo[/TD]
[TD=”class: nowrap, align: right”]8[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]126281[/TD]
[TD]Shawn Gallagher[/TD]
[TD=”class: nowrap, align: right”]7[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]136274[/TD]
[TD]Mark Blacknell[/TD]
[TD=”class: nowrap, align: right”]7[/TD]
[/TR]
[TR=”class: even, bgcolor: #CCFFCC”]
[TD=”class: nowrap, align: right”][/TD]
[TD][/TD]
[TD=”class: nowrap, align: right”][/TD]
[/TR]
[/TABLE]

[hozn]

@KayakCyndi 45598 wrote:

Just PMed you. But hmmm … something seems wacky with that data. Karen Smith (ACL) has WAY more lunchtime rides than that. I think she averages something like 4 a week!

Very possible my query is bad! — I will dig a little deeper and see what’s up.

[hozn]

@acl 45561 wrote:

The list: pick anything that appeals to you.
(SNIP)

Also, please use the current reports on the http://freezing.hozn.net site as simply examples of the types of things that are possible; I’m happy to help with other queries if people have more original ideas, etc.

[hozn]

@KayakCyndi 43212 wrote:

I will provide a prize for the person with the most lunch time rides. These will need to be rides that take place between 11am and 2pm. I MIGHT be able to datamine Strava (thanks to a very techi-SO) but if you THINK you are a candidate for this pointless prize please PM me so I have fewer records to sort through.

All that said, I think I know who is winning this one already (acl)!

Hi — I’ve got the data for this in my database. If you’d like access, just PM me.

In the meantime, I think this is the right query — and the current top X results:

select A.id athlete_id, A.name as athlete_name, count(R.id) as lunch_rides
from rides R join athletes A on A.id = R.athlete_id
WHERE HOUR(R.start_date) < 14 and HOUR(R.start_date) > 11
and (HOUR(R.start_date + sec_to_time(R.elapsed_time)) < 14)
GROUP BY A.id, A.name
ORDER BY lunch_rides desc;

[TABLE=”class: data”]
[TR]
[/TR]
[TR]
athlete_idathlete_namelunch_rides[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]661772[/TD]
[TD]Trish Newberg[/TD]
[TD=”class: nowrap, align: right”]12[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]1404871[/TD]
[TD]Michael Essig[/TD]
[TD=”class: nowrap, align: right”]8[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]1410917[/TD]
[TD]Karen Smith[/TD]
[TD=”class: nowrap, align: right”]6[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]1546879[/TD]
[TD]Robert O.[/TD]
[TD=”class: nowrap, align: right”]4[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[TD=”class: nowrap, align: right”]163744[/TD]
[TD]Elizabeth W.[/TD]
[TD=”class: nowrap, align: right”]3[/TD]
[/TR]
[TR=”class: even, bgcolor: #D5D5D5″]
[TD=”class: nowrap, align: right”]1224809[/TD]
[TD]Ken Buja[/TD]
[TD=”class: nowrap, align: right”]3[/TD]
[/TR]
[TR=”class: odd, bgcolor: #E5E5E5″]
[/TR]
[/TABLE]

(Note: this only includes rides that also finish before 2pm.)

[hozn]

@Justin Antos 45506 wrote:

I’m planning on using the W&OD out to West Falls Church tonight – think it’ll be melted enough by then for smooth tires?

Thanks for the help W&OD riders!!

I would have said it would still be messy, but I am not sure. It is warmer out than I was expecting. I would love to know how it looks (how slushy it is still) tonight so I know if I should change my tires. I will check your Strava. I assume it will not be frozen this evening, in any event, so you should be ok.

[hozn]

@dcv 45481 wrote:

Did I pass you this morning? Not many cyclist on the trails – I was riding east on the WOD from Vienna on a black & blue Felt CX. I think I just figured out who Lena is – on a MTB, think i saw her riding west on shreve road to avoid the icy WOD this morning?

Yes, I think you did see me / I saw you — cool. I was riding my cx/touring bike (silver w/ silver fenders). Lena rides an orange cx/touring bike also w/ full (silver) fenders & black paniers, so maybe that was someone else riding west on shreve. I rode/walked with her on the trail from Shreve and then we got on the road at Virginia intersection and detoured around the hill that leads down to 495 bridge.

[hozn]

@GuyContinental 45463 wrote:

Lena! Go Ochos!

Yeah, I rode/walked part of the way with Lena this AM. It was pretty awful riding conditions. We took a detour to skip the hill after 66, which was of course, solid ice, but then getting on around Gallows was still horrid. I ended up riding on ahead between Gallows and Vienna; I think I fell twice and caught myself a few other times; the “double track” through the snow there looked very rideable, but it was mostly riding on ice. Thought things might just “be fine” west of Vienna, but no so much. Took me twice as long as normal to get into work; I am glad I left early!

I do even have studded tires. I don’t know why I didn’t mount them; I looked at my phone weather & it said 33F, so I figured it hadn’t gotten below freezing and the trail would just be slushy. I was obviosly wrong

Beautiful morning, though. Hard to complain too much when this is really all by choice.

[hozn]

I have the minimal Tubus Fly rack that is fantastic for carrying panier(s) and adds less than 1lb to the bike. I actually don’t need it, though, as I’ve decided that I hate riding bikes with racks & would rather wear a backpack (or plan my week ahead and skip the backpack too), so I would be open to parting with it and my Ortlieb metro panier bag at steep discount if you still are looking for a rack (and think that the Tubus Fly would be a good fit).

[hozn]

I personally will only be able to shirk my family responsibilities for one evening, so if it’s all on the 21st that works well, but if the happy hour is later I will probably just go to the happy hour and skip the awards ceremony.

Is there any concern over having to pay $25-$30 to attend the awards ceremony? Perhaps not; I’m sure we all agree it’s for a good cause (I definitely am a huge fan of what Phoenix Bikes is doing), but it’s not exactly pocket change. OTOH, I’m sure it’ll help them with their fundraising if a significant portion of the BAFS group does attend.

[Author]

Posts