Google Fusion Tables

obs-blog-fusiontables-postLearn how to create a choropleth map of your data and visualize it on Google Maps.

Fusion Tables is an experimental data visualization web application to gather, visualize, and  share larger data tables. The Guardian newspaper makes active use of this as part of their  pioneering data journalism work.

You can easily upload data sets from CSV, KML and spreadsheets, and visualize the data using a  variety of tools. Users can merge data from multiple tables and easily visualize large data sets  on Google Maps.

All you need is a Google Drive account to get started.

How to create thematic polygon data maps is an excellent step-by-step guide to walk you through the process of making your own maps.


This Population Density map pictured (click to open) used 2011 Census table (KS101EW) data on usual resident population which was merged with an LSOA boundary file.


KML boundary files for Bradford


Understanding Bradford District

A new report published today provides Bradford Council and its partners, citizens and businesses with accurate and up-to-date information about the district. The report offers a descriptive analysis of the district and highlights issues and trends that need to be addressed to make Bradford a better place to live and work..  A shorter summary and ‘in your pocket’ guide are also available.

Key findings

  • With a population of 524,600, Bradford is the fourth largest district in England, after Birmingham, Leeds and Sheffield.
  • Bradford’s economy is £8.3 billion, constituting a fifth of West Yorkshire’s economic output and businesses. Between 2008 and 2011, Bradford’s growth was more than twice the regional average and also higher than UK growth.
  • Educational attainment is improving year on year with the rate of improvement for achieving five or more good GCSEs at grades A*-C including Maths and English accelerating faster than the national average.
  • Qualification levels are still lower than the regional and national averages.
  • Social work interventions regarding children in need of care and protection has fallen, with 345 referrals per 10,000 population compared to the English average of 533 referrals per 10,000 population.
  • We have a low proportion of social housing compared to regionally and nationally, but 99.9% of the stock meets the Decent Homes standard.
  • We have maintained consistent levels of resident satisfaction; the Office of the Crime Commissioner found that over the last three years the percentage of people who said they were satisfied with their local area has been between 70% and 71%.
  • Regular volunteering and civic participation are above the national averages demonstrating high levels of active citizenship.
  • Overall crime levels continue to reduce, particularly burglaries and violent crime.

Links to download :-

Summary with chapter highlights; full report including links to supporting notes; and an ‘In your pocket’ guide with key statistics from the analysis.