Tag: data

Stuff we've seen March 9th through to May 21st

These are my links for March 9th through May 21st:

  • Why its essential to socialize your business philosophy – “If you can’t or refuse to adapt your business philosophy to realize the full potential of social media, you will be wondering why your socialized competitors are doing increasingly more business than you are.”
  • Home is where the Art is: How to do social media – “Whatever you do with digital media, it is just that – digital media. The important stuff is the conversations it supports. No conversation, no point to digital media” This is from a customer and makes me very proud!
  • Talk About Local 2010 – What we learnt – Blog – – Much to our surprise, Greener Leith won the ‘Best Specialist Hyperlocal’ award, for which we’re most grateful. We’re still laughing at the plastic umbrella (price tag unremoved), tiny plastic trophy and the camouflage hat that made up the prize
  • Nick Petrie | One year of Redbrick – The student media scene is a great place for experimentation because the business model is different. It is an environment where risk should be encouraged and entrepreneurship supported. Social media is the buzz topic at the moment, but it is the concepts that surround it that matter; relationships, community engagement and conversations – the interactions that publications have with their audience.
  • 2008-09 Citizenship Survey: Empowered Communities Topic Report – Corporate – Communities and Local Government – “Using 2008-09 Citizenship Survey data, this report provides an in-depth examination of community empowerment: whether people feel they can influence local and national decisions; whether they would like to be more involved in decision making; what would make it easier to influence decision making; and how people would influence decisions if they wanted to.”
  • future interviews « ‘i interview interesting people’ – Interesting journalistic process from Robert Dale
  • Design for America – Sunlight Labs is pleased to announce our latest contest — “Design for America.” This 10 week long design and data visualization extravaganza is focused on connecting the talents of art and design communities throughout the country to the wealth of government data now available through bulk data access and APIs, and to help nurture the field of information visualization. Our goal is simple and straightforward — to make government data more accessible and comprehensible to the American public.

Digital scrutiny: the web’s the tool

While I’ve watched the election drama unfold over the last few days I’ve been busy trying to finish off the first stage of my digital scrutiny project – which is looking into how it might be possible to use the web to help the public scrutinise local government.

My idea has turned into a blog – Where Can We Swim – that I’m busy trying to develop as a sort of laboratory for the scrutiny of swimming pool provision. At the heart of my idea is a basic belief that we – the public – in all our great unwashed glory, might be able to help to run public facilities – not just as volunteers, but because we’re clever and can actually come up with new ways of doing things.

A reappraisal
When I started the project I hoped to develop a kind of tool kit for scrutiny. I even imagined I’d be scraping data in order to provide really good quality information. But my assumptions were totally off. By posting about my swimming pools idea on Podnosh I’ve learned of the work that Plings has done to find out all the local authorities providing free swimming to under 16s.

The Where can I swim for free site

This has made me think about how this provision will continue in the future. I’ve also realised the mines of local information that exist from websites locally, like the Moseley Road Bath’s excellent updates on swimming pool news in Birmingham and are helping to keep an eye on how the city council runs its pools.

Swimming around the web
And, when I first encountered the daftness of the Active Places data set run by Sport England (the store for all the country’s public sporting facilities), I imagined I’d spend my time trying to unlock the data, but it turns out that the folk at Rewired State have already had a crack at it.

What all this is beginning to prove is that my idea of a tool kit makes no sense whatsoever. Instead it’s pretty simple really: the web’s the tool. The real trick – something I’m only beginning to understand – is learning to use it to make connections between you and other people who have the same idea. And, if you do that, then suddenly all sorts of clever things begin to happen.

Report: April's Central Birmingham Social Media Surgery


Jon Law (left) and James Robertson at Apri's Central Birmingham SMS

Last night was a really interesting surgery  at thestudio – not least because it saw the first introduction of the Social Media Surgery Plus website.

We were blessed, quite surprisingly, with a large number of people happy to help others, which was great to see. Nick Booth helped the Civic Centre Residents’ group with their efforts to use Scribd with their residents’ blog, which they set up a few surgeries ago.
Karen Caine was helped by Andy Mabbett and learned about using data sets in conjunction with her long-established site, BrumCityCentre.com, for Birmingham City Centre Neighbourhood Forum.
John Newson was helped with his blog by Danny Smith.

Another busy Social Media Surgery

Heidi Blanton very kindly came down to help as a surgeon for the first time and helped Nancy Langfeldt with the blog for the South Birmingham Food Cooperative, which she had set up at a previous surgery. Jon Law of the Balsall Heath Housing Co-operative was helped by James Robertson with his site.

As I indicated earlier a great number of other people came along. And we had more people ready to help than those needing help, including Mary Horesh of Birmingham Friends of the Earth.

Scrutinising swimming pool facilities

I’ve been a bit annoyed with the provision of swimming facilities here in Brum for a while. Nick Booth suggested I compare them with those of the other core cities to see how Birmingham rated. So I’ve just had a little go.

What I did

First I went to each council’s website, found its list of leisure facilities and then checked each one to work out which were swimming pools. Occasionally, in the case of Manchester, that was easy because it was quite handy. In other cases it was a pain, because the council had different ideas about presentation. Anyway, I managed to make a crude tally of the number of pool facilities.

I wanted to do more, but as this spreadsheet shows it’s hard to get all the data.

Newcastle Swimming Pools

Some councils provide more information than others, some are completely inconsistent about what they do present. You’ll also see that, scandalously, I’ve added some Scottish cities and left out the likes of Sheffield in my list.

I then had a look on the same sites for population statistics. I didn’t always find them. On some occasions the website provided a mid-2008 census estimate, and sometimes it was just the numbers from the 2001 census. Sometimes it was in a nice HTML format, and other times it was buried in a PDF.

What I produced

I managed to collate the information into this incredibly crude spreadsheet, where I divided the population of the city by the number of pool facilities.

Swimming pool comparison

I then used Many Eyes to upload my spreadsheet and turn it into a visualisation, which you can see here:-

Now, this isn’t a great analysis. After all, Birmingham has Moseley Road Baths, which is something like 20m long, while the Manchester Aquatics Centre has two 50m pools in one facility. Yet they each get a score of one. Deeply unfair. If I could find out how long and how wide each pool was then I could add it all up and then compare the total swimming area to population. But that depth (pun intended) of information isn’t available.

So what does this mean?
For me this is a scrutiny issue, because working out how Birmingham compares to other cities in terms of facilities helps us to understand whether it needs to improve. But the information isn’t there, or if it is it’s inconsistent. And it’s not just geeks who’d like to know how big a swimming pool is, how long it’s open for and even how warm it is. It’s all information that’s relevant to users.

What can be done?
Making comparisons between councils’ services would be made easier if we all were engaged in a discussion about what information needs to be made available and in what formats that information is presented in.

As this little experiment demonstrates, it’s not technically challenging to collect data and then use a free, web-based tool like Many Eyes to interpret it. And, for the time being, I’m considering setting up a site that looks specifically at swimming pools to work out how that process could become more useful and accurate.