GOOGLE FUSION TABLES ON IRISH POPULATION

Population of Ireland 2011: Heat map above

Above is the image of a merge heat map of  Population of Republic of Ireland based on the 2011 Census data collected from the Irish Central Statistic Office (CSO).  The counties are represented in five different colours based on their sizes as you can see above. The purple and blue colours represents the highest populated counties and the light blue, yellow and orange represent the lower populated counties.

TO ACHIEVE THIS GOOGLE FUSION HEAT MAP:

In order to get this Irish Population visual Map, I used Google Fusion Tables to glean some mapping information from the Irish Population Census 2011 Data published on the CSO website.

Step One :

Step Two:

I copied and pasted the 2011 Irish population Data into an Excel 2013 Spreadsheet, the Data was scrubbed as there were Provinces data included, and some Counties were also divided into sets, Laois was wrongly spelt of which I did not realise initially until I later found out and as such, I had to open a new spreadsheet and do some sorting so that it would match with data in the kml file; After sorting the Data, it was stored in my document folder. The Irish  KML mapping data was also downloaded and stored  in my folder.

Step Three:

Then I logged in to my Gmail account and opened Google Drive where I selected the Google Fusion Table. The population Data was loaded into Google Fusion Tables and the kml data was uploaded to the Google Fusion Tables as well. I later clicked on the map of geometry to view what the map looks like, but there were no distinguishing features, but we need the colour features for the purpose of this exercise, at the Configure Map area, change feature styles was selected, and under polygons features,  fill colours was selected  and buckets column was clicked, five different colours were assigned to differentiate the sizes of the counties, and range was set and saved, automatic legend button clicked on and saved to show polygon fill legend.

Step Four:

MERGING THE GOOGLE FUSION TABLES

Now that I had the geometry and the Data, from the “File” menu drop-down, “Merge” button was selected which brought the “Merge: Select a table” Dialogue and the lead map kml was clicked and another dialogue table popped up where I had to chose which columns were relevant to my project which was done and merged table created, hence the view above was achieved. But sharing it to the public on my blog, the default settings was changed to public, and the embedded code was copied and pasted into the text editor of my page and updated for preview.

INFORMATION GLEANED FROM THE HEAT MAP

After critically examined the heat-map I began to see what one could glean out of it. Taking the Motorways into consideration, cities like Limerick, Galway, Cork are all connected to Dublin  by large motorways.

It could be suggested that there should be a large motorway from Cork to Athlone, and there could be another large motorway from Donegal to Sligo linking to Athlone, and from Sligo linking to Galway thereby allowing people from Donegal, Athlone, Sligo have a peaceful smooth ride all the way to Dublin.

The heat map could be used for many business strategic analysis, for instance, I was viewing the Dublin area of the heat map thinking if I could suggest another road network for the city centre area, but what was appearing to me were forks and Knifes symbols, glass cup symbols, Graduation hat symbols which indicates either restaurant, Inn, bars, Schools and so many other signs that could be useful to know what is happening in a particular area and as such, one would be able to know what kind of business fits into a particular area, where some other businesses are missing, the strategic location where your business might be best located in terms of competitions, and even the government could use it to trace criminals, which areas needs some better architectural designs and so on and so forth.

 

Published by

obafemi

Digital Marketing Strategist

Leave a Reply

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