Saturday, October 20, 2018

So where do you coffeeneur?

It's back, the communal coffeeneuring map.  It's the only coffeeneuring map that I will make in 2018 so please check it out and, more importantly, add the coffee shops where you drink coffee, or other approved beverages, this year.  First, the map, followed by information about how to add to the map and how to copy the map.  Zoom into the map and click on a marker to see who drank what and how they liked the shop.



So this is how it works ...

Anyone interested in adding their stops to the map should email me directly.  Find my email address in the About Me section of the right column of this blog.  Please send me your Gmail account, which seems to be the easiest to work with.  I will give you editing privileges via email.  If you have added your stops in the past, you should be all set.  Open Google Drive and look for tables that have been shared with you.  It is called Coffeeneuring Stops.

Notice that you will have editing privileges, which means you can add rows of data but also accidentally delete or otherwise edit another person's data.  So you you will have to be careful.  This is what the table looks like so far:


If you want to add a coffeeneuring stop, you go to the Rows view (note the tab for Row, Cards, and Map of Location) and then in the Edit menu, select Add Row.  You might select Delete Row by accident, which will delete all of the rows and end this experiment.  The Add Row interface looks like this:


You need to fill in the coffee shop name (Shop), which is a simple text field.

Next, add the address (Address).  The address could be something like "1720 Massachusetts Avenue, Lexington, MA 02420" (the Ride Studio Cafe address), or it could be "Concord, MA", which would be less precise.  It's best to check the address in Google Maps.  For instance, something like "Starbucks in Lexington, MA" yields the less helpful (in this instance) map of all of the nearby Starbucks.  "Ride Studio Cafe Lexington, MA" works since there is only one Ride Studio Cafe in or near Lexington, MA.  An address could be a latitude, longitude pair, like "33.023513, -113.049178", works.  Try this one in Google Maps.  I've had lunch at this place, but didn't get there by bike.  If you think you don't have access to where you visited in spherical coordinates, simply open Google Earth and zoom to where you had coffee and look at the bottom of the Google Earth window.  Google Maps likes Decimal Degrees and not Degrees Minutes Seconds, which is the Google Earth default.  Change this in the Tools menu under Options.  In the Options window, look for Show Lat/Long then click on the Decimal Degrees radio box.

Now add a link to the coffee shops website (Link).  This is a hyperlink, if that term is still used, which take the map reader to the website and will hopefully help other coffeeneurs figure out if they want to visit the shop as well.

You can add notes about the coffee shop, or your visit in the Notes field.

The last field, Coffeeneur, is meant to identify you, the person entering the data.  And by identifying you, I mean your online presence, if you have one.  For instance, you could put in a link to your Twitter page or a blog post about a coffeeneuring trip.  You could have put in a link to your Instagram account.  Anything works but it should be a legitimate web address or leave it blank and leave your first name in the Notes field.  Once you added a row and saved it (see the above image) then you need to click on the Map of Locations tab.  This geocodes the address, making it possible to put a pushpin on the map representing the shop and the data about it that you added.  Doing this may change the map extent.  While it is presently centered around Lexington, MA, adding a point in Finland, where there is an active coffeeneur, will center the map over the Atlantic and scale it so that both the eastern United States and Europe are in the map.

So be brave and contact me and I'll give you permission to edit the map and soon you will be adding to the map on this page.  A word of warning: I work a full time job during regular-ish business hours and have two children.  That means it might take a day or two after you send me an email to invite you as an editor.  If I seemed to forget, don't worry about pinging me.

Duplicates?

Apparently there are only so many coffee shops - people are visiting the same shops that others have been to on this year's coffeeneuring challenge or last year's, when we started this map.  And this is a challenge for the those adding their coffeeneuring stops to the map.  I have an interim measure to deal with  this, although not gracefully.  There is now a new column in the data: Older visits.  For now, if you see that the shop that you want to add is already in the map, you can do two things, depending on the year the shop was last visited:

1) If the information is from the current year, put your name/twitter feed/blogpots into the More Coffeeneurs 1 2 3 columns.  If you run out of columns, let me know.  Add anything you want to the notes but write that a second coffeeneur is adding the notes.

2) If the information is older, feel free to add to the notes before the older notes and put your name/twitter feed/blogpots into the More Coffeeneurs 1 column (or 2 if 1 is filled in or 3 if two is filled in).  If you run out of columns, let me know.

These extra columns aren't showing up on the map now but I'll fix that this evening.

Making the map your own

Having a group map is great but you might want to include a map of your stops on your blog.  You can do this easily.  First, when looking at the map view, use the filter to find only your entries.  If you did this with single entry, like I did last year (with "https://twitter.com/NEBicyclist"), you can easily find your data by clicking on Filter, then Coffeeneur and then clicking on the checkbox for you name.  You might search for your name, as I did in the example below.


Or you might have added your stops with a blog post for each entry, which I am doing this year.  In this case, you need to scroll down through the list and check off each of your entries.  Remember that this list is alphabetic and where how you entered a link matters.  For instance, some of the twitter links are http:twitter.com and others are https:/twitter.com.  Therefore all of the https links are after all of the http links


Once you have your stops selected, you can publish you maps.  Publish is under the Tools menu.  You will get two options: a link like this one for my map or HTML so you can embed your map using HTML as I have done here:




The form that you pull the link and HTML looks like this:


You may have to mess with how the map is centered as long as  your stops are in the center of the map but it is mostly a trial and error process.

It should be put before the last DIV in the HTML in Blog

Once you have your map all set, go back to the original fusion  table and delete your filter.  The link and embedded code still have the filters.


Friday, August 31, 2018

D2R2 2018


Another D2R2 happened a couple of weeks ago and I got to be there.  I didn't actually ride the D2R2 per se.  I rode the Green River Ride and added some extra stuff with some help.   I ended up starting the 100K with Joe (@geojoek on Instagram) and his friend Nancy.  We rode the brown route on the map at the bottom of this post.  We bailed from the main route maybe 18 miles in and Joe knew the roads to take down (as in losing elevation) to the Green River Tour.

For me, it was a pretty fabulous day.  I was hoping to ride with Joe and Alex and Carla but I was early and they were late and the rain was threatening so I was eager to get out so I could get back and avoid the thunderstorms that were in the forecast (but never materialized).  After getting an early start out of the house, I arrived at D2R2 headquarters by 7:15 and picked up my registration materials, found Joe, and ate breakfast.  After changing and getting my bike out of my car, we all met up and left with a slightly bigger group with some faster riders who soon left us behind.  The first challenge was Old Albany Road, something I heard about conditions there, thanks to Pamela Blalock:



As my comment on her posts suggest, it was time to get a second set of tires for the Surly.  That was part of the plan when I first started using Compass tires 2 years ago (and was delayed when the bike with those tires was trashed in a collision with a car).  I had Clement (now Donnelly) USH tires, which were pretty good for commuting and road rides and pretty good for dirt.  To meet the demands of this year's D2R2 (15 inches of rain fell on the area in the month prior to the ride), I got the 40 mm Donnelly MSOs.  They got me up Old Albany and made me feel pretty comfortable on the rest of the dirt roads we encountered, particularly on the descents.  I kept the tires on for the next week or so and enjoyed a late evening ride on the Reformatory Branch Trail and Battle Road and appreciated the stability on sandy stretches of trail and on the muddy sections.  They are off now for the commutes when I can look my bike up securely (the bike cage I use is temporarily out of commission).

Without going into details about the rest of the ride, let's just say it was pretty nice.  I loved the views from the high elevations and also loved the dirt sections along the Green River (but the views up high are the best).  Joe was able to get us on nice alternative roads on our way into Greenfield and we followed the official route back to finish.  Rain came but wasn't overwhelming and I saw some pretty cool bikes en route, at lunch, and at the finish.  Joe and Nancy are about my speed and it was a great social experience - a rolling conversation punctuated with some substantial climbs and quick descents.

Like my experience in 2009, the narrow roads were busy and I saw people passing others on narrow sections of dirt roads.  The crowds thinned out on the way to the Patten Hill rest stop and it was quiet on our private route to the Green River Tour.  Lunch, on the other hand, was out of hand.  There was a law enforcement officer at the lunch stop using his loudspeaker to try to get people off of the bridge and the road.  He was largely unsuccessful.  I wonder if the rain caused this by making people less interested in getting back on their bikes in the rain.

I'll end this with pictures and captions.  The rest of the Instagram posts are from Joe, who is an actual photographer.


I knew it would be raining on my morning drive to Deerfield so my bike was loaded into the car for a dry start to the day.
Some people camped and some of them camped in style or didn't pack light.
Damp morning at the food and registration tents.
Kind of a nice road, if you ask me.
I don't know this cyclist but he was working hard to get up the hill, as were most other cyclists I saw as I waited for Joe and Nancy,  This was the first big one north of Route 2.  Most everyone stopped to catch their breath here.  Peter Weigle passed me on this hill and proved to me that not only does he make some of the best bikes around but he can power up hills on his Weigle.
Even the paved roads are scenic.  That's Nancy in the light blue jersey.
A panorama of the snack stop at the little big house on Patten Hill.  This is where we decided to shorten our ride and head  to the Green River Tour.

Joe heard there was a good view from the top of the hill just west of the snack stop and it didn't disappoint.  We eventually were overtaken by rain that you can see falling here.  We had it for about the last 15 minutes of the ride to the lunch stop and through lunch but it was light and I didn't melt. I did wear a rain coat for lunch, which was better than getting cold.

A pair of matching Ebisu bikes.  I've heard of these but never saw one of the east coast.
A Firefly at the lunch stop, just thrown into the bushes, as one does with a $6,000 or $8,000 bike.
A Indy Fab at the lunch spot.
Joe lives around here so he knows all the swimming holes.  There was a fabulous series of swimming holes in a gorge above where the bikes are parked.  Swimming wasn't a priority on this year's D2R2 but would be on a hotter day.

From Joe:





A post shared by GeoJoeK (@geojoek) on

That's me on Old Albany Road.  This is a pretty nice section of road.  It got worse, particularly in the steeper sections.




A post shared by GeoJoeK (@geojoek) on

Nancy and me at the top of Patten Hill.

The route and timing from Strava.


To Nancy and Joe: thanks for the ride and the great day!


So this is what the Green River Tour looks like. Maybe. These are the roads I used over the 5 times I rode the Green River Tour.  Orange: 2014, Green: 2015, Blue: 2017, Brown: 2018.  2013 (the basic GRT) is a thicker line covered by the other years.