Google fusion table and data visualization - How to create thematic polygon data map tutorial

This is my second tutorial about Google Fusion tables, this time I will show you how to  create thematic polygon data map with Fusion Table.


1. Go to Fusion Table and click Open. You can add data from Computer, Google Spreadsheet or just paste the link with data from Internet. That's really cool!









2.Now you need to Geocode your data, or merge your data with other geocoded tabel, remember that each City, Country Name or ISO Code must appear in both files.
each district (or county) name must appear in both files - See more at: http://commons.trincoll.edu/jackdougherty/how-to/gft-thematic-maps/#sthash.ObeLUZMx.dpuf


TIP: There are daily limits on free geocodes in Fusion Tables . Fusion Tables can only geocode up to 2,500 requests per 24 hour period. So it's easier and faster to merge two tables. You can always use  this public table, properly geocoded in KML format.

3. So we will merge our data table with the geocoded table. In the main menu, select File and  Merge. Remember to confirm the source of the match, which means to select the correct data columns that are common to both tables. In this exercise, go to the right-hand World Boundaries table and select “Name” to match it up with the “Country Name” column of the World Bank spreadsheet data, as shown below.
The “Fusion” part: Merge the spreadsheet table with the boundary table 
4) In your web browser, go to the GFT spreadsheet tab (which should already be open; if not, click on it in your Google Drive tab). In the menu, select File > Merge: - See more at: http://commons.trincoll.edu/jackdougherty/how-to/gft-thematic-maps/#sthash.ObeLUZMx.dpuf
The “Fusion” part: Merge the spreadsheet table with the boundary table 
4) In your web browser, go to the GFT spreadsheet tab (which should already be open; if not, click on it in your Google Drive tab). In the menu, select File > Merge: - See more at: http://commons.trincoll.edu/jackdougherty/how-to/gft-thematic-maps/#sthash.ObeLUZMx.dpuf




4. Open new merged table and click on Map tab and then on Feature Style in the right menu .




5. Last to do is to click Fill Color and Gradient and customize your map, don't forget to chose correct column with data to present from drop down menu.



6. Finally publish your new map. Go to Tools and Publish and copy link or Iframe code to embed into website or blog. 
Modify the map zoom level and position, then select Map of Geometry > Publish. - See more at: http://commons.trincoll.edu/jackdougherty/how-to/gft-thematic-maps/#sthash.ObeLUZMx.dpuf



No comments:

Post a Comment

Fork me on GitHub