2. Make a KML from two data sources

Topics covered

  • Attribution
  • Public Data
  • Image support
  • Fusion
  • Column control
  • Mapping
  • Bubble customization - template 5
  • Export to KML file

Show: Final "African Heads of State with Flags" KML in Google Earth

"We're going to use two different data sources to make this simple educational KML."

Show: Browser Tab 1: JapanAfrica African Heads of State webpage

"I found this listing of African Heads of State on this website, which is very useful."

Show: Browser Tab 2: African Heads of State table
"I've brought it into Google Fusion Tables. Because Fusion Tables is intended to foster collaboration around data, we know that attribution, or getting credit for where the data comes from, is important. See how I made sure this data set is attributed to JapanAfrica network."
  1. Show attribution next to table name
  2. Show attribution at File > About
"Now I'd like to combine this with the flags from the countries. Let me show you a public table with the flags from all countries that someone else put up in Fusion Tables.  I can view and use it, but I can't edit it."

Show: Browser Tab 3: Fusion Tables table listing
  1. Click Public Tables 
  2. Search for [country flags] and open "Country Flags - Large" or "Country Flags" 
  3. Show the Flags as images
  4. Show I can't edit Flags 
  5. Show Visualize > Map  to indicate presence of all countries
  6. Copy the URL 
"Fusion Tables supports images; just enter a URL in the cell and Fusion Tables will show it in the table, and it can also be exported in the KML."

"This table has flags from ALL countries. When I combine it with the African data set, only the countries listed in the African data set will match, and I will have effectively grabbed only the subset of the country flags that I need." 

"OK, so let's start combining the two data sets."

Show: Browser Tab 2: African Heads of State table
  1. Click Merge
  2. Paste URL into "Merge with:" and click Get. 
  3. Select the "Country" radio button for both tables ("COUNTRY")
Tip: don't use COUNTRY, as the capital letter spelling of country names won't match any country names from the Flags file. Although the column names are identical in this exercise, It's not necessary for the columns to be named the same in order to merge on them.

"Fusion Tables offers column-by-column access controls. In this case, I don't need to include the "COUNTRY" column in my new merged table."
  1. Check "Select columns" button on left, and un-check "COUNTRY" column. 
  2. Save as: "African Heads of State and Flags"
  3. Show two different background colors in merged table
  4. Point out combined attribution next to table name
  5. Show File > About and how source of data is tracked 

"So let's map our merged data table."

  1. Visualize > Map
  2. Show default bubble style
  3. Click "Configure Info Window"
  4. Select "template 5" and specify the information that should be used to populate the info bubble template
    1. specify "Country" as Title
    2. specify "HEADS" as paragraph 1
    3. specify "Flag" column as photo link
    4. specify "table attribution" as something....
    5. Press Save
  5. Show new bubbles
  6. Export to KML
  7. Open in Google Earth

"The African Heads of State public too, so you can repeat what I just did."