My first CA for Data Management and analytics was to prepare a fusion table showing the dispersal of the population of the Republic of Ireland, the source of the information was from the Central Statistics Office (www.cso.ie) and also the Irish Independent (www.independent.ie). The information from the CSO was in the KML file format (Keyhole Markup Language) this gave the geographical boundaries, the Information from the Independent was saved as a CSV file (common separated value) this gave the population breakdown per county.
Both sets of information were uploaded to my google drive and prepared separately as individual fusion tables, once they were both uploaded they were then merged, a common value between both tables was needed, I modified the CSV file headings as the counties were under the heading “location” and the KML file had the counties listed as “county”, this mismatch caused issues when merging the information, also some of the location names did not match on the CSV and KML files causing areas of the map to remain unpopulated, simple modifications in rendering the files fixed this issue.
Once the information had been merged successfully the fusion table offers options to highlight the data as required, initially the population location was pin pointed with marker icons in red, by holding the mouse over the icon you get a pop up tab giving male, female and total population of that location, this is not very clear and will not quickly deliver the information at a glance, in order to show the information clearly and meaningful format I rendered the map using polygon background colors with a gradient fill, this was presented from light yellow for sparsely populated areas through green light blue and finally dark blue and red for heavily populated areas, as expected Dublin with a population of 1.2 million was noticeably different from the rest of the country, smaller county populations like Leitrim with a total population of 31 thousand was colored very light yellow.
I divided the population numbers into buckets graded in an upward incremental value of 30,000 per bucket, this helped the variation of colors stand out more and shows clearly the variation in population numbers across the republic. Further dissemination of information can be obtained by breaking out male and female populations per county and the country as a whole, interestingly Dublin with the largest population also had the biggest discrepancy between males and females with a difference of 34,000 more females than males, almost every other county had s 1:1 ratio with only small deviations between both sexes.
Google fusion tables are a fantastic way to show at a glance anything from trends, statistics, population numbers or any other data sets in an easy to understand graphical format using colors to instantly highlight major differences or even fine tuning it down to minor differences by tightening bucket variances, this is a very valuable tool which I intend to make use of in my own work environment.
Google Fusion Map For CA1
PoP up information
Using Buckets to separate population values