Tuesday, October 20, 2015

Coffeeneuring map: duplicates and making the map your own

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 you 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.

Give it a try and ask questions via comments here or send me email.

And also feel free to leave comments on how you thinks it's best to deal with duplicate coffeeneuring stops.


  1. If a coffee shop was visited last year, and we visited it this year, how should we handle updating the notes/coffeeneur/year fields? Thanks!

    1. I'd add notes if the place has changed for the better or worse or if you wanted to add any comments. If you have a new blog post or instagram or similar, I'd add it in the first additional coffeeneur column. This is bound to get messy. I did add this page which hopefully adds some insight.