OUseful.Info, the blog…

Trying to find useful things to do with emerging technologies in open education

Simple Map Making With Google Fusion Tables

A quicker than quick recipe to make a map from a list of addresses in a simple text file using Google Fusion tables…

Here’s some data (grabbed from The Gravesend Reporter via this recipe) in a simple two column CSV format; the first column contains address data. Here’s what it looks like when I import it into Google Fusion Tables:

data in a fusion table

Now let’s map it:-)

First of all we need to tell the application which column contains the data we want to geocode – that is, the addrerss we want Fusion Tables to find the latitude and longitude co-ordinates for…

tweak the column

Then we say we want the column to be recognised as a column type:

change name make location

Computer says yes, highlighting the location type cells with a yellow background:

fusion table.. yellow...

As if by magic a Map tab appears (though possibly not if you are using Google Fusion Tables as apart of a Google Apps account…) The geocoder also accepts hints, so we can make life easier for it by providing one;-)

map tab...

Once the points have been geocoded, they’re placed onto a map:


We can now publish the map in preparation for sharing it with the world…

publish map

We need to change the visibility of the map to something folk can see!

privacy and link

Public on the web, or just via a shared link – your choice:

make seeable

Here’s my map:-)

The data used to generate this map was originally grabbed from the Gravesend Reporter: Find your polling station ahead of the Kent County Council elections. A walkthrough of how the data was prepared can be found here: A Simple OpenRefine Example – Tidying Cut’n’Paste Data from a Web Page.

Written by Tony Hirst

May 1, 2013 at 9:03 pm

3 Responses

Subscribe to comments with RSS.

  1. If you access Google Fusion Tables via an organisational Google Apps account, you may find that the mapping features are not available, as described here: http://support.google.com/fusiontables/answer/1657096

    It also seems that Google is locking down on the way it makes – or rather, doesn’t make – geo-coded information available by Fusion Tables’ export KML functionality….: https://support.google.com/fusiontables/answer/171215?hl=en

    Tony Hirst

    May 2, 2013 at 1:33 pm

  2. […] Simple Map Making With Google Fusion Tables […]

  3. […] Sourcehttp://blog.ouseful.info/2013/05/01/simple-map-making-with-google-fusion-tables/ […]

    Week 4 | inaricampaigning

    February 17, 2014 at 10:07 am

Comments are closed.


Get every new post delivered to your Inbox.

Join 1,354 other followers

%d bloggers like this: