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.

What is Google fusion table for

Google recently introduced a new data management tool called Google fusion table. It is a cloud based API (application programming interface) for visualizing, merging and collaborating on data. It Enables users to retrieve data from any kind of sources, update data and collaborate in real time. It is also has a good function which enables users to embedd data to any blog or site. Still not clear? Than let see an example. Lets say you are watching the election in TV. You see a nice chart on the screen about the popularity of different canditates in different counties or cities. This chart can be easily done by Google fusion table. In my next post I will demonstrate how to create a similar map.