Tutorial 5 - Using Google Fusion to create heatmaps

Follow this example in order to learn how to upload your postcodes into Google Fusion and view them as a heatmap. You will need a file of postcodes with easting and northing values and population counts in plain text format in order to complete this tutorial.

Example Test File

Stage 1: Preparing Google Fusion

  1. Go to drive.google.com and sign into your Google account (you can create an account here if you don't already have one).
  2. In the left-hand pane, click 'NEW' -> 'More' -> 'Connect more apps'.

    Connect more apps

  3. Type 'fusion tables' in the Search Apps box and hit Enter.

    Connect Fusion Tables apps

  4. Click the '+ CONNECT' button and then 'OK'.

Stage 2: Creating a Google Fusion table

  1. Click 'NEW' -> 'More' -> 'Google Fusion Tables'.

    Create new Fusion Table

  2. In the 'Import new table' dialog box, click 'Choose file' and select the CSV file.

    Import new Table

  3. Click 'Next' to review, 'Next' again to advance, and finally 'Finish'.
  4. Click the 'Map of...' tab to view the data. You might find that Google hasn't matched the points to the correct area. If this is the case, you can click 'Location' in the left-hand pane and select 'Postcode' to re-geocode the points.

    Map points

  5. Clicking on 'Heatmap' in the left-hand pane enables you to view a heatmap of the area.
  6. You can choose 'Population' from the 'Weight' dropdown box to show the areas with the highest populations.
  7. You can change the Radius and Opacity to suit your preference. To share the map, click the 'Share' button in the top-right.

    View heatmap

GeoConvert is provided by UK Data Service