How to make maps with Fusion Tables

Inspired by the Guardian Data Blog I decided to explore Fusion Tables and Google Maps with Australian data. To start with, I selected a set of Socio-Economic Indexes for Areas, created from 2006 Census data, and postal area boundaries from the Australian Bureau of Statistics (ABS).Today I would like to share a few observations regarding creating maps with data from Fusion Tables.

Although Fusion Tables is not yet a fully featured thematic mapping, analysis and publishing application however, with a little bit of effort, anyone can create informative maps which are visually attractive and fast to deploy. The best thing about Fusion Tables is that you don’t need to manage any complex infrastructure yourself and that the application is free (however, with some limitations on data storage volumes, currently capped at 250MB per account).

Spatial Data

Since Fusion Tables support spatial data only in KML format you have to convert your dataset before uploading it to the server, or alternatively, find a publicly available table that has already been uploaded by someone else.

Google provides a tool to translate SHP data into KML format and to import directly into Fusion Tables but it didn’t work for me with complex data. There are some free alternatives available (really easy to use one is QGIS, for example) but loading other than KML data into Fusion Tables will always be a multi step process.

If you decide to upload your own data, please note a couple of annoying limitations of Fusion Tables. Firstly, complex polygon structures are not supported (for example, I could not upload postcode number 0822 in Northern Territory at full resolution, yet it works perfectly with Google Maps). Secondly, some larger polygons and/or with many parts get generalised automatically as you load them to Fusion Tables as, for example, postal area 7255 in Tasmania (compare the results below – the same KML file as imported to Fusion Tables, on the left, and as displayed directly on Google Map – note green outlines on all, even the smallest islands):


Table search functionality in Fusion Tables is rather crude so, it may not be an easy task to locate what you are looking for. Not to mention that the concept of metadata is non-existent in Fusion Tables so, it is hard to know if the data you find is appropriate for your purposes.

Numeric data

Upload of tabular numeric information in csv format is very straightforward but if you disallow “Export” option up front, you will not be able to edit the data in Fusion Tables. My suggestion is to import the data as “Private” (default option) and allow for “Export”, then add new columns with formulas (if required), and disallow export only when you are ready to publish the data (if at all).

Table Operations

You can easily create a map based on data from numeric tables if those tables contain a “spatial reference” column, for example, postcode numbers (provided you can find equivalent spatial data set in Fusion Tables). To combine numeric and spatial data tables you have to use “Merge” function. My suggestion is to use “smaller table” as a starting point. For example, to create thematic map with postcodes for Sydney area only, select relevant numeric table first and then merge with a table containing postal areas for the entire NSW. Only relevant boundaries will be included in the merged table (ie. the subset of NSW postcodes). If you do the operation in the reverse order, the merged table will contain all postcodes for NSW but only a handful will have the data that can be used in creating a thematic map.

When you “Create View” (ie. copy the table – your own or from other users to your account) or “Merge” tables with spatial geometry column you will lose map formatting parameters (eg. colour setting for polygon fills, etc.). This is very unfortunate, especially when you need to retain colour schema from the original table.

Styling Map

Handling “No data” fields is not easy in Fusion Tables. The problem is that polygons with “no value” in the table default to red fill when rendered on the map (as in the example below – there was no data for 2006 postcode in the merged numeric table). A workaround is to include some value in the table for the missing record (eg. traditional -9999) if you can. Then you can specify map settings to colour only that value, for example, as white and/or fully transparent.


Fully transparent overlays (eg. if fill is set to 0% transparency) are not clickable – it is a very handy feature for handling polygons with missing data in the numeric table (ie. no information window will be displayed when the polygon is clicked). However, when your objective is to present on the map only outlines of the polygons but you still want to display information about those polygons on click of the map, you have to change transparency parameter to a value greater than 0.

Tutorials

If you are eager to start playing with Fusion Tables, Google produced easy to follow tutorial on how to create thematic maps (note, if you are working with your own data, choose “Map” option and not “Intensity Map” in the relevant step).

Share|

Mapnificient Is Very Good Maps Invention

Mapnificient is the best idea I’ve seen in a very long time. It allows you to pick your location, set an amount of time and then find exactly where can you go using public transportation in that time. Absolute genius.

I can see myself using Mapnificient on a daily basis, limiting my searches for bars, cafés and restaurants by time rather than space. And I can see myself using this for the next time I have to rent an apartment, to see exactly what areas are within 30 minutes of the Gawker’s office, which is my maximum time when it comes to travel in NYC using the subway or the bus.

It is so damn useful that it makes me wonder why Google or Bing Maps hasn’t implemented this yet. I hope Stefan Wehrmeyer makes an app for all iOS, Windows Phone 7 and Android as soon as possible.

Lifted from  Gizmodo

Share|

Google Maps Mashups 2

DHO Discovery Interface

 


Ireland’s Digital Humanities Project is using Google Maps and the Simile Time-Line as a way to browse Irish digital collections and resources.

You can select to view a collection from the drop-down menu. Once you have selected a collection you can choose to browse the collection in a Google Maps view or on a time-line.

The map view obviously depends on whether location data has been added to individual collections.

Cairo Street Art


Cairo Street Art has created a Google Map that allows anyone to post photos of graffiti found in and around the Egyptian capital.

The map is actually just an embedded Google My Map. It is a nice example of how you can create a cloud based map without any programming knowledge using a collaborative Google My Map and simply embedding the map in your website.

Brown University – Campus Map


Brown University are using Google Maps to help students and visitors find buildings, parking lots and other facilities on their campus.

The Google Map uses a map overlay of the campus, which shows the names of the college buildings and is color-coded for ease of use. If you click on a building you can view a thumbnail photo and click on links to a video, a floor-plan of the building and its web page.

The Brown University Campus Map was developed by Fortune Ganesh.

Laid Off Tweets Map


There is no Friday Fun this week. Instead we have Friday Glum.

Mizabaar has created an animated Google Map that shows the latest geo-tagged tweets that mention ‘laid off’. You can select to view Tweets on the map from different regions of the United States.

This is just the latest of a series of Twitter maps from Mibazaar. If you want to create your own Twitter Map showing your own Tweets then try Mibazaar’s Twitter Status Map. This map takes your latest Twitter status update, along with your profile location, and displays it on a Google Map.

Hurtigruten: Minute by Minute



This is incredible and pretty mesmerising!

Norwegian Public Service broadcaster NRK are live broadcasting the voyage of the cruise liner Hurtigruten around the Norway coastline for 134 hours. As well as amazing live footage you can follow the position of the cruise liner on a real-time Google Map.

No money seems to have been spared for this live broadcast from the Hurtigruten. There seems to be a large number of cameras being used with some excellent editing between the various live views. There is also a pretty cool soundtrack, with the occasional addition of live commentary.

The event is obviously a big thing in Norway. Whilst I’ve been watching the voyage this morning nearly every house that has been passed has had the owners out front waving flags at the passing ship.

What makes this event unmissable however is the incredible Norwegian scenery which should be viewable for nearly the whole 134 hours, due to the broadcast being timed to coincide with the summer solstice and the Midnight Sun.

The map itself is also incredible. You can add layers of photos and videos of the cruise from a drop down menu. You can also click on the small circles on the ship’s track to change from the live broadcast to watch a replay of the footage from the selected location.

There may well be no more posts on Google Maps Mania today … as I don’t think I’ll be able to tear myself away from watching this.

Stories of Jewish Chicago


The Spertus Institute of Jewish Studies is holding an eight-part exhibit that explores the Chicago Jewish experience. As part of the exhibit the Institute is creating the Greater Chicago Jewish Memory Map.

Visitors are being asked to contribute their own personal stories of Chicago Jewish life to a Google Map of the Chicago area. You can read the submitted stories on the Stories of Jewish Chicago page. Each of the stories is accompanied by a Google Map showing the location talked about by the visitor.

Eventually all the stories will also be added to the Greater Chicago Jewish Memory Map.

Share|