This tutorial was prompted by questions students raised in my online mapping course: some students ran into problems when working with real-world data sets that (a) are not properly formatted and (b) do not come with ready-made KML geographic data.
For purpose of demonstration, this tutorial focuses on how to search public Fusion Tables data for KML data. We will use a data set that has been formatted and uploaded to my Fusion Tables account; if you want to, you can read this tutorial for how to prepare data. Also, we will only show key steps in creating the heat map; if you need details, read this step-by-step guide on creating heat maps.
The data set and the mapping needs
Say I ran into a table that lists wine consumption in some European countries, and I wanted to create an interactive heat map. Below is a screenshot of the table that I uploaded to my Fusion Tables account, notice that the table has four columns (it was not created by me), but I actually only need two columns: Country and Per Capita in L. And notice that the table does not have KML geographic data for each country.
How to search Fusion Tables public data
As is said in this KML tutorial, there are people from around the world sharing all kinds of data via Fusion Tables. So, at the Fusion Tables public data site, I typed “Europe KML” in the search box, and found one file, nov2012_europe_kml_map, that contains KML data for European countries:
This file, as shown below, is in Japanese and has columns of data that are not relevant to what we want to do. What we actually need from this table are just two columns: Id, which lists the countries; geometry, which lists KML geographic information for each country.
How to create a heat map of European wine consumption
Back to my wine consumption table, and following the step-by-step tutorial, I click File>Merge, and copy/paste link to the europe_kml_map table, as shown in the screenshot, then click Next.
In the next window, I instruct Fusion Tables to match the Country column in my table with the Id column in the europe_kml_map table, then click Next.
In the next window, I need to select what columns to keep in the new, merged table. Notice that the two original tables both contain columns that are not relevant to what I need to do, which is to plot per capital wine consumption on a map; so I selected to keep three columns in this step, then clicked Merge.
Notice here that I’m keeping the Country column in my table, not the Id column in the other table, this is because the Id column in the other table has additional countries for which I do not have wine consumption data.
By this step, I have created a new table with three columns: Country, Per Capita in L, and geometry, as is shown in the screen shot below. The heat map tutorial we referenced above has details on how to create a heat map with a table such as this one; embedded below the table is the actual map I created.
- Google Maps tutorial (part 1/5): What Fusion Tables is and does
- Google Maps tutorial (part 2/5): How to work with Fusion Tables
- Google Maps tutorial (part 3/5): How Fusion Tables map works
- Google Maps tutorial (part 4/5): About KML/KMZ geographic files
- Google Maps tutorial (part 5/5): How to create a Fusion Tables intensity map
Latest posts by Mu Lin (see all)
- Critical thinking exercises in online courses: How I incorporate them in lecture and production courses - September 10, 2015
- RTE Innovation Lead Glen Mulcahy: Bad news and good news about mobile journalism - May 5, 2015
- How to write a headline: Discussions and rewrites in my Writing for the Web course - April 19, 2015