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.
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
The form that you pull the link and HTML looks like this:
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.