Fusion Tables (advanced)
data downloads & links
data downloads & links
hands-on Prep
hands-on Prep
- Open Google Drive (drive.google.com)
- Click on New > More > Connect more apps
- Search for Fusion Tables and add it to your drive
hands-on activity #1
hands-on activity #1
- Download FirstNationsOntario.csv
- Open Google Drive (drive.google.com)
- Create a new Fusion Table from Google Drive (New > More > Fusion Table).
- Use the "Choose file" button to select the FirstNationsOntario.csv file from your computer and click "Next".
- Click on the Map view.
- Click "Change feature styles" and using the drop-down box under "Select one icon", change the placemarks to a different style. Click "Save".
hands-on activity #2
hands-on activity #2
Add custom icons
- Add a new column "icon". Click Edit > Change columns.
- Click "New" and select "Column.
- Title the new column "Icon" and click "Save".
- Open a new tab to the Custom Icon Library.
- Click on the icon you want and copy the Icon Name (you must copy it exactly, it is case sensitive)
- Paste the icon name in your Fusion Table icon column, for each row.
- Go to the Map view.
- Click "Change feature styles" and change the settings from Fixed to Column.
- Under Column, click "Use icon specified in column" and select the "Icon" column using the drop down box. Click "Save".
Edit the infowindow
- In the Map view, click "Change infowindow".
- Select "Custom"
- Delete the current code and copy and paste the below in. Click "Save".
Infowindow script
<div class='googft-info-window'>
{Name}<br>
<b>website:</b> <a href="{website}" target="_blank">{website}</a><br>
</div>
Create a heat map
- In Map view, click heat map.
- Adjust the settings to your taste.
hands-on activity #3
hands-on activity #3
- Create a Fusion Table with StatisticsCanada2011.csv
- Create a Fusion Table with CanadaBoundaries.kml
- While in the Canada Boundaries Table, select File > Merge.
- Select the StatisticsCanada2011.csv table to merge with.
- For the CanadaBoundaries table, select either the "name" or "NAME" column to merge on. For the StatisticsCanada2011 table, select the "Province/Territory" column. Then click "Next".
- Click to view merged table.
- In the map view, click "Change Feature Styles".
- Select Polygons > Fill color > Buckets.
- Divide into 5 buckets and click "Use this range".
- Select colors for the 5 buckets.
- Click "Save" to see your updated map.
- To add a legend, click "Change Feature Styles" and select the Automatic Legend.