Wattie's Wordpress

Random reviews, remarks, reports and rants!

Posts Tagged ‘cuts

We can work it out!

leave a comment »

The biggest problem I had with my Production Labs project was that the client wanted an animated timeline map showing the Manchester cuts in sequence. No matter how much I searched, I could not find a way to do it within my current abilities.

I even spoke the the Flash developers at the Financial Times, but they said that I would need a lot of expertise to achieve what I wanted. Then over a beer in the afternoon a fellow Online Journalist, Desi Velikova, suggested I look at Tableau to see if that would work.

Firstly, I made sure I had all the longitude and latitude data in the spreadsheet, dates formatted correctly etc and then loaded it into Tableau. At first it just showed a map with one large circle in the middle, but then I found out the default setting was to find the average of the numbers, so correcting that immediately changed the view to one of Manchester with all the locations of the cuts correctly displayed.

Next, through trial and error (as the help facility was anything but helpful), I managed to work out how to add a time element to the map and also change the size of the markers depending on the size of the cut (dropped from the final version) and how to change colour depending on which department the cut was from.

You can see a screenshot of the resulting map below, or to see it in action, have a look on Kijamedia.


Written by Andy Watt

March 24, 2011 at 7:54 pm

Production Labs – finally got the data

leave a comment »

For my production labs project, I am working with data concerning the Manchester budget cuts. In a previous discussion, I had agreed to a Google map showing where the cuts were taking place which would link back to the online report on the newspaper’s website. I was also going to look at different ways in which to visualise the data such as heat maps etc but the email I received envisaged something much more ambitious.

They would like an animated map, with locations showing up when the timeline reaches the date the respective cuts were announced, with links back to the website. Quite simply, I do not have the ability to do this. I am not a coder and there is not service out there which I could tap into to allow me to achieve this, so I will have to look for alternatives as near as possible to what they want.

Written by Andy Watt

March 14, 2011 at 11:55 pm

Posted in Production Labs

Tagged with ,