google fusion table

This is my first blog and the topics is Google fusion table.

In this blog I will be writing about how I achieved Irish Population Intensity Map using 2 sets of data Provided to me. Please find the link to my google fusion table here.

Google Fusion Tables uses the same structured data as Spreadsheets, but allows you to merge different data tables together. It is easy to use even without knowing any programming and will give you a sense of how powerful data work can be. Also, Fusion Tables makes it extremely easy to create and publish interactive map. You can easily upload data sets from CSV, KML and spreadsheets, and visualize the data using a variety of tools. Users can merge data from multiple tables and conduct detailed discussions about the data on rows, columns and even cells.

We were provided two links and based on those links I have constructed an Intensity map for the Republic of Ireland with data I received from the 2011 census and map_lead kml file.

Please find the single unmerged tables below.

Below is an image of a Intensity map representing the Republic of Ireland’s population and boundary lines. Each county is divided into male,female and total number of person (population). This is how my completed practical looks like.

I will now be reporting the structure and present the contextual information to achieve the intensity map for the Republic of Ireland.

I first had to source the correct data sets. I needed population file in CSV version and county boundary lines(KML). I downloaded the appropriate files needed to complete this task.

The map above is two seperated by google fusion table one of which is Polygon map and the other is displayed as points of data and also get information windows when clicked on the ploygons.

To open Fusion tables and begin to upload my population data. This data was opened in spreadsheet format. I read trough the data sheet checking all data was input and correct for male,female and total number of person.

I now had two separate files uploaded on Fusion tables and needed to merge my data creating one single file. I matched both files with county names and clicked on merge. When merging was complete I opened map geometry and checked the merge was successful. My both files were merged successfully and but I still needed to make my intensity map more interactive and effective.

I clicked on polygon then fill color and clicked on to bucket to further use this range, fill counties depending on total population. As show on two images below

Conclusion :

To conclude fusion table helped me in creating an interactive data source. I learned that we can work in teams even if are not in same location by accessing our Google drive. While looking at population, you could find more detailed information to see where concentrated areas on a more local level and the number of total person living in each counties. This information could further help me in indicate where schools and churches are located. I can even merge the third table and show more information about shopping malls located in each town and city.

References:

http://www.independent.ie/editorial/test/map_lead.kml

http://www.cso.ie/en/statistics/population/populationofeachprovincecountyandcity2011/

https://support.google.com/fusiontables/answer/2571232?hl=en

Leave a Reply

Your email address will not be published. Required fields are marked *