I want to produce maps from a set of government data for my local website. But I don't write code and don't think I should have to. So I am experimenting with simple ways of producing a map from a real data set. First off Google Fusion Tables.
Noise is a big problem in an urban area and Westminster City Council has published via FOI a list of commercial noise complaints with approximate locations (they take the street numbers off for some reason). It's at Whatdotheyknow.com I downloaded the spreadsheet of data and tidied it up a tiny bit, putting the word 'London' where it was missing from each address field.
Then i uploaded it to Google Docs and imported it into Google Fusion Tables a Google Labs product that has been around for a year. I hit Edit, Modify Columns to tell the sheet what was in each column and then I hit the Visualize menu and selected - Map. The following emerged, just like that:
There's a small snag for me - I couldn't figure out how to configure the simple weblink to show a particular level of zoom in a map. If you get an embeddable link then this will give you zoom control - but you can't use iframes in wordpress.com the popular publishing platform. There is a KML option but practically no corporate desktops nor government departments run google earth - this diminishes the use of the data to achive social impact.
Pretty good all in all - quick and simple with no techno stuff, the help page was useful. It isn't perfect, but it's easy. If you can use a spreadsheet you can take some real public data and make a map to make a point. Any suggestions for other visualisation services i could try with no coding required are welcome.
UPDATE
This small post was just done for my own benefit and i wasn't expecting it to get the traffic it has. If you have suddenly landed here from the Guardian or elsewhere then you should know that I run a small business, talk about local with 4IP and Screen West Midlands funding to help people get a voice online. I am also on the Local Public Data panel for CLG to advise them on freeing up data from local government. If you are reading this from Google and also hadn't heard of Fusion Tables then feel free to send me some corporate bumf for the free publicity - some cupcakes maybe or a fetching jacket (XL).
Showing posts with label #opendata. Show all posts
Showing posts with label #opendata. Show all posts
Sunday, August 29, 2010
Thursday, July 1, 2010
Towards an open, transparent BBC - publishing in detail its mainstream expenditure #opendata
Today the BBC Trust announced that it wants the coporation to publish the pay of its top stars. This follows on from publication of the pay and expenses of senior executives. Publishing executive pay does not seem to have damaged the BBC's ability to function as a business. Publishing stars' pay is also unlikely to damage the BBC. I wonder if it is time to go further and make the BBC much more open - apply some of the open data work being done in central and local government to this £3billion per annum, tax payer funded organisation while protecting its journalistic independence.
The BBC is a fabulous national institution. It is funded by what is known as a regressive tax - a fixed charge on every person or business that owns a television set. For ante diluvian reasons the tax is a called a 'licence fee'. The poorer you are the greater the proportion of your income goes on the tax. To my mind, this places a strong moral obligation on the BBC to be prudent and transparent in expenditure, especially in such tough economic times.
Michael Lyons the Chair of the BBC Trust tackles this in his speech:
Michael Lyons says that the BBC can appear spendthrift when it is unclear how it spends its money. The answer for Michael Lyons is to follow the open data movement that is starting to bring transparency to government. This would involve systematic publishing of detailed items of expenditure on the internet for others to analyse. We would then know precisely how our money is being spent. And it might even help the market for goods and services in TV to work better and drive out further value. It also gives a voice to the listener and viewer - if I want the BBC to spend more on local radio in my area it is very hard to campaign for that if i don't know what it actually spends.
Publishing data can be done safely and responsibly. As a member of the Local Public Data Panel I helped draft guidance for Local Government on how they could publish detailed expenditure on goods and services over £500. These offer a handy, adaptable framework. The BBC I suspect is not short of accountants, expenditure managment systems and technologists who can help prepare and publish the data.
To safeguard genuine journalistic independence, simple circles could be drawn around the new, current affairs etc, bring out into the open all expenditure on goods and services. There would be much wailing and gnashing of teeth about where the boundaries lie between news/current affairs and the rest. But that doesn't stop anyone publishing the budget and expenditure of Bargain Hunt, Dog Borstal or Doctor Who or the accounts department next week.
There will be confidentiality clauses in contracts - lawyers love those even when you are only contracting for a whelk stall. But, as the Chairman set out, there is a strong public interest case. Indeed elsewhere in the publicly funded sector, the Information Commissioner has been quite clear about the relative importance of the public interest viz a viz commerical confidentiality.
The new government has said that it would bring the National Audit Office in to audit the BBC and Michael Lyons tackles this in his speech. The NAO faces a huge task - publishing detailed expenditure data and bringing many eyes to bear on the problem might help that.
Declaration: I speak occasionally on media issues and was on the panel appointed by the last government to advise on the Independently Financed News Consortia. When in the civil service, in the diatant past I used to work on media regulation. I now run a company called talk about local that helps people in deprived communities find a voice online. This article is my own personal view and does not represent the views of employers or clients past or present.
The BBC is a fabulous national institution. It is funded by what is known as a regressive tax - a fixed charge on every person or business that owns a television set. For ante diluvian reasons the tax is a called a 'licence fee'. The poorer you are the greater the proportion of your income goes on the tax. To my mind, this places a strong moral obligation on the BBC to be prudent and transparent in expenditure, especially in such tough economic times.
Michael Lyons the Chair of the BBC Trust tackles this in his speech:
"there are distinct areas where further change – and acceleration of change - is needed. First: to demonstrate that every pound the BBC takes from licence fee payers is used well....To the public the BBC can appear spendthrift when it is unclear how the BBC is using the money the public gives it. This underlines the need for much greater financial control and transparency by the BBC.
...The answer lies in much more openness by the BBC. Openness about how it's spending the public's money
Due to the way it is funded the BBC has a direct responsibility to licence fee payers who are effectively its shareholders. This goes beyond the obligations that commercial companies have towards investors and is different from the relationship that other parts of the public sector have with tax payers.
The third area where we are asking the BBC to go the extra mile is in increased transparency over how the BBC spends the public's money."
Michael Lyons says that the BBC can appear spendthrift when it is unclear how it spends its money. The answer for Michael Lyons is to follow the open data movement that is starting to bring transparency to government. This would involve systematic publishing of detailed items of expenditure on the internet for others to analyse. We would then know precisely how our money is being spent. And it might even help the market for goods and services in TV to work better and drive out further value. It also gives a voice to the listener and viewer - if I want the BBC to spend more on local radio in my area it is very hard to campaign for that if i don't know what it actually spends.
Publishing data can be done safely and responsibly. As a member of the Local Public Data Panel I helped draft guidance for Local Government on how they could publish detailed expenditure on goods and services over £500. These offer a handy, adaptable framework. The BBC I suspect is not short of accountants, expenditure managment systems and technologists who can help prepare and publish the data.
To safeguard genuine journalistic independence, simple circles could be drawn around the new, current affairs etc, bring out into the open all expenditure on goods and services. There would be much wailing and gnashing of teeth about where the boundaries lie between news/current affairs and the rest. But that doesn't stop anyone publishing the budget and expenditure of Bargain Hunt, Dog Borstal or Doctor Who or the accounts department next week.
There will be confidentiality clauses in contracts - lawyers love those even when you are only contracting for a whelk stall. But, as the Chairman set out, there is a strong public interest case. Indeed elsewhere in the publicly funded sector, the Information Commissioner has been quite clear about the relative importance of the public interest viz a viz commerical confidentiality.
The new government has said that it would bring the National Audit Office in to audit the BBC and Michael Lyons tackles this in his speech. The NAO faces a huge task - publishing detailed expenditure data and bringing many eyes to bear on the problem might help that.
Declaration: I speak occasionally on media issues and was on the panel appointed by the last government to advise on the Independently Financed News Consortia. When in the civil service, in the diatant past I used to work on media regulation. I now run a company called talk about local that helps people in deprived communities find a voice online. This article is my own personal view and does not represent the views of employers or clients past or present.
Subscribe to:
Posts (Atom)