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.
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 City
- Dun Laoghaire-Rathdown
- South Dublin
- Cork City
- Cork County
- Limerick City
- Limerick County
- Tipperary North
- Tipperary South
- Waterford City
- Waterford County
- Galway City
- Galway County
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²|
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.
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.
In the pie chart-2 you can see the population by province and also the percent of population.
Chart-3 shows the % of population/County
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.
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.