How to use Google fusion Table

I have a good news for you. It is not a rocket science! All you have to do is to create a Google account, (probably you already have one). Than go to your Google drive, search for Google fusion table and connect it to your drive. Great! Than you will need some data what you are going to use before you can begin.


A good source of information is cso. So i went to its site and I exported some data to exel and saved it on my local drive. (You can input data to exel manually or copy and paste.) Than you have to open your Google drive and click “new” and click fusion table. Than choose file from your computer and click next. Than you can set in which row are the column name’s are and click next. Than click file and geocode. Than I created a few buckets clicking on change style and I got this.

https://fusiontables.google.com/embedviz?q=select+col0+from+18h1vLz8EWrnEUjZ4ZZhjzbydk51B4jXBjGc82qmU&viz=MAP&h=false&lat=52.84212564207156&lng=-7.07087744140631&t=1&z=7&l=col0&y=2&tmplt=2&hml=ONE_COL_LAT_LNG

The point of colors on the map refers to number of the population of the county by males and females.
Than i downloaded a kml file from idependent’s website and I followed the same steps. KML is a Keyhole Markup Language, an XML notation for expressing geographic annotation and visualization within Internet-based, two-dimensional maps and three-dimensional Earth browsers.
https://fusiontables.google.com/data?docid=1rStJn0RE-SmugK115yZHitdRho6hkYpN0r8w5OKK#map:id=3

Than I merged the two tables and I got this.

https://fusiontables.google.com/embedviz?q=select+col2%3E%3E1+from+18AoPQgeGggsMEa-j1tTZ5V3g8H8wufrJDQ_z7dXq&viz=MAP&h=false&lat=53.50030984792301&lng=-7.96208334375001&t=1&z=7&l=col2%3E%3E1&y=2&tmplt=2&hml=KML

We can see on the map that the most populated county is Dublin. I am not looking for the reasons now why there is a huge difference in the population of the Capital and the counties because this blog is not about the economy of Ireland. But feel free to create your own fusion table about unemployment, number of new jobs created or  even on the number of universities in each county and merge it with this table. I am sure you will get interesting figures.

I was interested about how many accidents are on the irish roads so I retrieve some data from rsa’s website and I created a fusion table.

https://fusiontables.google.com/embedviz?q=select+col2%3E%3E1+from+1nuh6CH9806TbosI_KHgW7DbbR6ABhvVJFEON6Ebn&viz=MAP&h=false&lat=53.12618376086364&lng=-8.11589193750001&t=1&z=7&l=col2%3E%3E1&y=3&tmplt=3&hml=KML

Conclusion

Google fusion tables allow you to visualise and understand your raw data on a map or chart. It helps you to understand the corellation between two or more datasets. But it does not give you answers so I reccommend it to use with caution if you are looking for correlation.  However is a great tool which can be used widely to visualise data geographically.

Leave a Reply

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