Drafts

@cm3 の草稿置場 / 少々Wikiっぽく使っているので中身は適宜追記修正されます。

Google Fusion Table Tutorial By Example

Contents

  1. Prepare Table Data with Google Spreadsheets
  2. Visualise Table Data with Google Fusion Tables
  3. Other TIPS

Prepare Table Data with Google Spreadsheets

Google SpreadSheets is a service like "Online Excel". And it's easy to corraborate with other Google services.

First you have to prepare table data with place names. For example, I used Population Percentage by Province and Gender data from Statistics Indonesia. Click download button on the top right and open it.

f:id:cm3ak:20150115135943p:plain

Besides, open Google SpreadSheets and click (+) button on the bottom right.

Copy Excel data to SpreadSheets.

f:id:cm3ak:20150115140820p:plain

First row is column name in the sample above. Click title of SpreadSheets and name it. Then data is automatically saved.

Visualise Table Data with Google Fusion Tables

Open Google FusionTables and press "Create a Fusion Table" button.

f:id:cm3ak:20150115141313p:plain

Next, press Google SpreadSheets to import the data you've made.

f:id:cm3ak:20150115141421p:plain

f:id:cm3ak:20150115141623p:plain

Select what you made, click "Select", and so on. Finally you will get the view like below.

f:id:cm3ak:20150115142046p:plain

Yellow names are place names to be resolved.

Once click "Map of Place" tab or "File > Geocode > Begin Geocoding", place names will be resolved.

f:id:cm3ak:20150115142419p:plain

Click "Change feature styles..." menu, and "Buckets" tab.

f:id:cm3ak:20150115142817p:plain

You can classify points by colors.

f:id:cm3ak:20150115143130p:plain

Settings above is an example settings. I used 4 colors, and set each range by clicking "use this range" automatically.

Finally, you'll get the visualization like below.

f:id:cm3ak:20150115143347p:plain

References