Mapping in Google Fusion is Fun

Google fusion

In this project you will see the steps which involves the process how to achieve the heat map of Irish population based on population of Irish counties according to 2011 Irish census data. It also include where the data was taken and the steps was taken to clean the data for getting the accurate result. There is also other ideas and concept that can be shown in Fusion table.

  1. Importing Data

First step was to get the files we need to analyse. So the raw files was downloaded from the link below:

Population data of Male, Female and total number of Population per Province and counties  http://www.cso.ie/en/statistics/population/populationofeachprovincecountyandcity2011/

Kml file which includes the geocoding of Irish counties: http://www.independent.ie/editorial/test/map_lead.kml

Also, density of population per county: http://homepage.tinet.ie/~cronews/geog/census/cosize.html

2. Cleaning Data

Second step was to clean the data what we have downloaded, so that we can get the results we want. The population data was copied to the excel spreadsheet to sort and clean. Originally population data contains the province and counties which was then divided separately. Province data was separated into different sheet and counties in different, so population can be analysed according to province and counties. Some of the big counties were divided into many parts such as:

  • Dublin
    • Dublin City
    • Dun Laoghaire-Rathdown
    • Fingal
    • South Dublin
  • Cork
    • Cork City
    • Cork County
  • Limerick
    • Limerick City
    • Limerick County
  • Tipperary
    • Tipperary North
    • Tipperary South
  • Waterford
    • Waterford City
    • Waterford County
  • Galway
    •  Galway City
    • Galway County

 

County Males Females Total Persons
Carlow 27,431 27,181 54,612
Cavan 37,013 36,170 73,183
Clare 58,298 58,898 117,196
Cork 257,470 261,562 519,032
Donegal 80,523 80,614 161,137
Dublin 619,902 653,167 1,273,069
Galway 124,758 125,895 250,653
Kerry 72,628 72,873 145,502
Kildare 104,658 105,654 210,312
Kilkenny 47,788 47,631 95,419
Laois 40,587 39,972 80,559
Leitrim 16,144 15,654 31,798
Limerick 95,815 95,994 191,809
Longford 19,649 19,351 39,000
Louth 60,763 62,134 122,897
Mayo 65,420 65,218 130,638
Meath 91,910 92,225 184,135
Monaghan 30,441 30,042 60,483
Offaly 38,430 38,257 76,687
Roscommon 32,353 31,712 64,065
Sligo 32,435 32,958 65,393
Tipperary 79,584 79,170 158,754
Waterford 56,464 57,331 113,795
Westmeath 42,783 43,381 86,164
Wexford 71,909 73,411 145,320
Wicklow 67,542 69,098 136,640

Table-1

All of these counties were then added together to form a single county name and added the population together to make it total population of county, so that the data(table-1) will match the county names as on KML file. By doing that it will make it easier and cleaner to merge the file in Fusion Tables. Next was to clean the data from density of population per county file. As the population density shown in this table was from 2002. So, the population was changed according to 2011 census data and current population density was taken to show the population per county in 2011.

County Area (km²) Population Person per km²
Carlow 896 54,612 61
Cavan 1,931 73,183 38
Clare 3,147 117,196 37
Cork 7,457 519,032 70
Donegal 4,841 161,137 33
Dublin 921 1,273,069 1382
Galway 6,148 250,653 41
Kerry 4,746 145,502 31
Kildare 1,693 210,312 124
Kilkenny 2,061 95,419 46
Laois 1,719 80,559 47
Leitrim 1,588 31,798 20
Limerick 2,686 191,809 71
Longford 1,091 39,000 36
Louth 820 122,897 150
Mayo 5,585 130,638 23
Meath 2,342 184,135 79
Monaghan 1,294 60,483 47
Offaly 2,000 76,687 38
Roscommon 2,547 64,065 25
Sligo 1,836 65,393 36
Tipperary 4,303 158,754 37
Waterford 1,837 113,795 62
Westmeath 1,838 86,164 47
Wexford 2,352 145,320 62
Wicklow 2,024 136,640 68

Table-2

3. Merging Files & Heat Map in Google Fusion

After cleaning the data all the files were uploaded in google fusion tables. Which includes KML, Population of Ireland  and Population Density per County. Population and Population Density file then merged with KML file making two different maps. One shows the map of total population per county and other shows the map of density of population per county. They are then divided into buckets and each buckets then assigned a different colour which represents the population density depend on colour shown in Legend beside. Live Google Fusion heat map can be seen by clicking on the Heat Map photos below.

Total Population/County Heat MapMap-1. Total Population/County Heat Map

 

Map-2. Population Density/km²

Map-2. Population Density/km² Heat Map

4. Analysing the Heat Map

As we can see from the heat map, we can analyse that which county is more populated and which is less populated. Mostly counties in the midlands have very less population than of those which is beside the sea. Stronger colour shows that population in that county is higher populated than the ones with lighter colour. Legend board on the side of the heat map shows the population in buckets with different colours. As you can see from Map-1 that Dublin has the most populated which is shown by very dark red colour than Cork is shown in little lighter red. Galway and Kildare falls in very light red bucket putting Galway and Kildare  3rd and 4th position respectively. But, when we see the Map-2 the density of population is not the same as the total population. Where Dublin stays on 1st position as it is represented in dark red. Louth and Kildare has 2nd and 3rd most populated density in Ireland. In this analysis we can see that may be some counties is not as populated when it comes to the total population but they rank higher in density of population per km².  There is big population in Dublin, Cork and Galway there could be many reason for that such as – Facilities provided in cities, better connection to other big cities(motorways), schools , colleges and Universities, better career opportunities(big companies), health services and many more. Depending on the population and density many more analysis can be done according to one’s need.

In the chart-1 you can see the population of gender in each county.

Chart-1 Population By Gender

Chart-1

 

In the pie chart-2 you can see the population by province and also the percent of population.
Chart-3 population By Province

Chart-2

Chart-3 shows the % of population/County

Chart-3 % of Population/County

Chart-3

Other Ideas for Fusion Table

Fusions tables are very good tool to visualize a set of data on the geography of world map. It can be shown for a small town, city, country or anywhere on the world map. Normally it is very hard for humans to see the information they need in big sets of data. But, by putting that data in Fusion tables, one can see the information they want by just going to the area they want to get information about.

Garda Stations

Map-3

Here you can see the information about Garda stations, address, contact information in all over Ireland, which is shown by small blue dots. It would be very hard to find the Garda station you looking for in some table. By putting this information in fusion table, it makes it easy to access the information you need by just zooming to the area on the map and by clicking on the blue dot. This data was taken from Garda website. You can also access this data live on Google Fusion Table or by clicking on the map photo itself.

One thought on “Mapping in Google Fusion is Fun”

Leave a Reply

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