Bookmarks for April 25th through April 30th

I find this stuff so that you don’t have to.

You can find all my bookmarks on Delicious. There is also even more stuff on my shared Google Reader page.

You can also see all the videos I think are worth watching at my video scrapbook.

Bookmarks for April 19th through April 23rd

I find this stuff so that you don’t have to.

  • Open innovation, why bother? – 100% Open – "…if open innovation is to deliver sustainable business advantage then we need a better understanding of what motivates contributors to these initiatives, else there is a risk of a backlash against them…"
  • Docs.com – MS Office + Facebook beats Google Docs? Am not convinced!
  • TALKI – The easiest way to embed a forum – Embed a forum on your website – just like that! Users can sign in with Facebook, Twitter or Google accounts.
  • Government 2.0 Can and Must Save Money – "I think that the current shortage of resources and a sometimes dramatic budgetary situation can be a powerful incentive to make this change happen, to tap into the creativity of employees as well as external resources." YES!!!
  • Red Sweater Blog – Apple Downloads – VERY interesting – is Apple going to go down the App Store route for vetting Mac software now, too?
  • HTML5 presentation – "Slideshow-style presentation on HTML5 made using HTML5."
  • CDC Provides a Great Example of What Social Media Is About – "CDC’s strategy puts them in a better position to identify patterns where trust may be shifting elsewhere early enough to take action: many other agencies worldwide, which just care about publishing data and creating their Facebook pages, will be taken by surprise."
  • data.lincoln.gov.uk (beta) – Lincoln City Council start publishing data publicly – great work, and props to Andrew Beeken who must have driven this through.
  • Simplifying the social web with XAuth – "We think that XAuth can simplify and improve the social web, while keeping your private information safe. This is just one of many steps that Google is taking, along with others in the industry, to make the social web easier and more personalized."
  • Open Government and the Future of Public Sector IT – Great talk from Microsoft's Dave Coplin.

You can find all my bookmarks on Delicious. There is also even more stuff on my shared Google Reader page.

You can also see all the videos I think are worth watching at my video scrapbook.

Bookmarks for April 11th through April 16th

I find this stuff so that you don’t have to.

You can find all my bookmarks on Delicious. There is also even more stuff on my shared Google Reader page.

You can also see all the videos I think are worth watching at my video scrapbook.

Bookmarks for April 5th through April 10th

I find this stuff so that you don’t have to.

  • Social Media Security – "We have found a huge lack of accurate information around security issues and awareness of social media. This website aims to help educate users of social media of the threats, risks and privacy concerns that go with using them."
  • E-government is not a financial cure-all – "Whoever is in charge after 6 May, I expect the drive towards "smarter government" (or whatever catch phrase replaces it) to continue. There are simply no other tools in the box. But whoever is in charge will avidly wish someone had made a bolder start while the going was good."
  • bantApp.com: Bant Diabetes Monitoring App for the iPhone and iPod Touch – Interesting iphone app for diabetes management, via @robertbrook
  • Two models of open innovation – "Based on our recent experience of working on open innovation projects, and also building upon a great paper by Kevin Boudreau and Karim Lakhani, we have concluded that there are two distinct ways of doing open innovation – creating competitive markets or collaborative communities"
  • Let government screw up – "I have the opportunity to speak to groups across government about the benefits, challenges and potential costs of social media. In the face of institutional anxiety, I’ve argued that social media is a positive environment that encourages experimentation. In fact, online users are willing to accept mis-steps and stumbles from government organizati0ns simply because it demonstrates initiative and ambition, if not expertise."
  • Project Spaces: A Format for Surfacing New Projects – home – "The event format I'm calling Project Spaces has emerged from working with various collaborators to facilitate events for communities actively engaged and committed to finding better ways to do things."
  • Can Open Office Escape From Under A Cloud? – "I do see a future for Open Office in the enterprise — one that’s closely tied to integration with collaboration, content management, and business processes and facilitated by the likes of Oracle and IBM."
  • A democratic view of social media behaviours – Interesting action research post from Catherine – plenty to chew on here.
  • Digital exclusion, porn and games – "I wonder if – as with mobile phones – there’s a certain, influential generation that see the technology as being more than just a technology. And instead, a marker for a whole way of life they just haven’t accepted yet."
  • Social media measurement – Great stuff from Stuart Bruce – debunking a few myths and some marketing BS.

You can find all my bookmarks on Delicious. There is also even more stuff on my shared Google Reader page.

You can also see all the videos I think are worth watching at my video scrapbook.

Using the places database

I was asked recently by a colleague for some information about the names and locations of local authorities in this country. I was able to respond quickly and usefully thanks to the places database, which sits on the website of the Department for Communities and Local Government.

Here’s what I did, as a simple example of what you can do with this resource. We’re just going to produce a spreadsheet containing the names and contact information for local councils in England. I’m no expert on this stuff, but hopefully this demonstrates some of what is possible, and encourages folk to have a play.

First, go to http://www.places.communities.gov.uk/ in your web browser.

Scroll down and choose ‘download data by theme’:

Download data

On the next screen, we need to tell the system what information we want to extract through a number of steps. Here’s what steps 1-3 should look like for our example (click for a bigger version):

Steps 1 to 3

For step 1 select Current, step 2 select Key Facts, step 3 select Local Authority.

Two more questions to answer:

Steps 4-5

Step 4 choose Place Details, Step 5 leave start and end dates both as current.

Finally, there is a bit of a warning message – which I just ignore – and then the option to download the data as either an Excel spreadsheet or in CSV format:

Steps 6-7

Then just hit download, and your data will be saved to your computer. Dead easy.

Thanks to Martin Stone who first pointed this out to me.

I’d be interested to find out what uses other people have been putting this tool to.