Info Windows for Google Maps (from Fusion Tables)

A slightly boring technical post today because from time to time people get in touch to ask technical questions. So, I thought I'd just share a bit of my (limited) knowledge on controlling what appears in a google map info window when you click a map layer using Fusion Tables. Most of this probably applies to non-Fusion Table maps as well. Here's what I'm talking about...

Link directly to this page here.

As you can see from the screenshot above, this info window has a chart (drawn from the Fusion Table which is mapped) an image (a map key) and some text, which also pulls out unique data for each area on the map when you click on it. Since Fusion Tables are relatively new, there isn't an awful lot of information out there on how to do this (at least not info that simpletons like me can understand) so I spent quite a bit of time experimenting with the code behind the info windows. There is some useful information on this page and the pages it links to but when you have your own dataset it can be a bit difficult to grasp.

Not much else to say except that I've copied an image below which shows the code and the info window side by side. If you click on the image it should take you to a PowerPoint file which you can then use to copy the code if you wish. I'm certainly no expert but someone may find this useful!

Comparing Deprivation in the English Core Cities

The eight English core cities outside London often work together on issues that affect them. One thing I've been looking at recently on some work in Sheffield is how the core cities compare in terms of patterns of deprivation. So, I've mapped and compared them below. Red areas are amongst the 10% most deprived in England and the darkest blue areas are amongst the 10% least deprived in England. The maps are at different scales but the point here is just to provide a quick visual comparison of cities in this map matrix view.

Joblessness in Edinburgh and Glasgow

I'm currently finishing off a piece of work relating to spatial patterns of labour market deprivation in Scotland so I thought I'd share a couple of findings about the contrasting cities of Edinburgh and Glasgow*. I've been using data from the Scottish Index of Multiple Deprivation (2009) employment deprivation domain, which gives a jobless rate for each small area (Data Zone). The official explanation is that it is 'involuntary exclusion from the labour force' and it includes things like unemployment claimants and incapacity benefit claimants.

I've been looking at the data within the context of local labour markets and have done some comparisons between Edinburgh and Glasgow. The data are now a bit old (from 2008) but what's really interesting are the numbers... In Glasgow, the total population of Data Zones where the jobless rate was 25% or more was a little over 170,000 (more than the population of Dundee) and areas with a rate of 33% or more contained just over 51,000 people (more than the population of Perth). By contrast, the figures for Edinburgh were just under 25,000 and just under 11,000 respectively. Even when you take into account the difference in population (about 600,000 for Glasgow vs. 450,000 for Edinburgh) that's a big difference! I know this contrast isn't particularly surprising but the numbers did surprise me a bit.





*I've added Aberdeen and Dundee because David Manley suggested it. A good idea!

Deprivation in Wales

My experiments in mapping deprivation continue... I should really have done something on Wales before now but to make up for it I've done a 3D annotated map, a Google fusion table version with Welsh Index of Multiple Deprivation 2005 and 2008 data (also embedded below), plus a new version of a fusion table map with a drop-down menu for choosing local authority areas. For both the google map versions you can find out about each area just by clicking on it.

Click here for a full size version, and here's the shortened URL http://goo.gl/GYnIF

Finally, here's a screenshot of the page with the drop-down menu for selecting local authorities. You can click here, or click on the image below to go to the separate web page for this one...

Local Deprivation in England

Rather than leave my English Indices of Deprivation fusion table work on a single blog page, I thought I'd take a minute or two to put it on a separate web page with its own address. A screenshot of the result is shown below. I've just used blogger for this and added a floating key so that no matter where you zoom or pan you can remember the colour scheme. The colour scheme is based on quintiles (i.e. 20% most deprived, 40% most deprived and so on). Click the image below to go to the web page. It's very basic!

United States Census 2010

The 2010 US Census was conducted in April 2010 and already the results are looking very interesting. By the end of 2010 there was a new total population figure for the US, indicating a growth of 9.7% between 2000 and 2010. The total population on the twenty third US Census day was 308,745,538. This is just over double the total population from 1950. For a more up to date population estimate, you can check the US population clock from the US Census Bureau. Because I'm interested in all this, I've produce a graphic which shows population density and some population data for the lower 48 states, at county level. A couple of nuggets here: Los Angeles county has nearly 10 million people and Loving County (Texas) has only 82 people. All other counties lie somewhere in between...

Does Anyone Look at This Blog?

When I started this blog I wasn't really sure if anyone would ever look at it but as it turns out people somehow find it and some lost souls even return more than once! Even more surprisingly (for me) is that people often get in touch with me because of it, which is really good because I like to make contact with like-minded researchers and share ideas in this way. Google Analytics allows you to keep track of the number of visitors and the country of origin so I thought I'd highlight the usefulness of that and also post some charts of the visits to my blog...

Here's a chart showing visits per day since I started blogging (as usual, click images to enlarge)


This is a Google Analytics map showing visits per country (still work to do in Africa!)


Most blog visits in the USA come from California


The point of this post is threefold. 1 - to highlight the magical properties of Google Analytics. It really is brilliant. 2 - to demonstrate that blogging does help connect like-minded people and make collaboration possible. 3 - to write about something other than deprivation!

P.S. There will be more on deprivation in the near future...