data

Enterprise mashups

Quite a few people – at least those that read this blog and others like it – are comfortable with the idea of mashups, the activity of taking data from one source, and combining it with one or more others to create something useful and interesting.

Often this happens on maps, but of course it doesn’t have to.

One potential application of this sort of technology which doesn’t get discussed much, certainly in the public services context, is enterprise mashups, in other words applying these techniques within the organisation, behind the firewall. So, taking a set of data or statistics from one department and mashing it up with another.

I’d read about enterprise mashups before, but the idea didn’t really catch on until I saw Bill Ive’s post about JackBe, a vendor providing a platform for organisations to do this stuff. Here’s a video giving an example of how JackBe can be used:

I certainly remember my days as a Business Analyst at a county council where I spent days taking information from one source and having to reformat it to make it play nicely with another, usually in Excel. Having a tool like this available would have made life much easier.

Here’s a whitepaper explaining all this in more detail (PDF warning).

(Obviously, there are other providers of enterprise mashup platforms and not just JackBe, it’s just that I wasn’t looking at their websites when I was writing this post.)

Bookmarks for April 11th through April 16th

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

  • A New Approach to Printing – “a service that enables any application (web, desktop, or mobile) on any device to print to any printer.”
  • Governments and Citizens: You Don’t Own Your Tweets – This is a really interesting piece on ownership of online content.
  • Beauty is the new must-have feature – “I’m predicting that we’ll start to have a non-functional requirement around making beautiful experiences when we build systems, and that we’ll be rubbish at it when it happens.”
  • Follow Finder by Google – “Follow Finder analyzes public social graph information (following and follower lists) on Twitter to find people you might want to follow.”
  • Enterprise 2.0 and improved business performance – “Despite growing evidence, which I’ve presented here and elsewhere, there still remains for many people a real question about the overall ability of social software to improve how organizations get things done.”
  • calibre – E-book management – Really handy (for a Kindle owner, anyway) open source, cross platform ebook conversion tool.
  • Why does government struggle with innovation? – “If innovation is becoming a core attribute required by government organisations, merely to keep up with the rate of change in society and the development of new ways to deliver services and fulfil public needs, perhaps we need to rewrite some of the rulebook, sacrificing part of our desire for stability in return for greater change.”
  • The Biggest Obstacle to Innovation – “There are many candidates for the biggest obstacle to innovation. You could try lack of management support, no employee initiative, not enough good ideas, too many good ideas but no follow-through just for starters. My nominee for The Biggest Obstacle to Innovation is: Inertia”
  • Lichfield District Council – Open Election Data Project Case Study – “An early adopter Lichfield District Council has been actively sharing a range of local data for some time. In March 2010 the Council was the first authority to make its local election results openly available as part of the Open Election Data Project.”
  • Google Docs Gets More Realtime; Adds Google Drawings To The Mix – Me likey!
  • YouTube – SearchStories’s Channel – Make your own Google search story video – like in the Superbowl ad. Cute.

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.

Bookmarks for March 30th through April 5th

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

  • The Collapse of Complex Business Models « Clay Shirky – Awesome stuff from Shirky.
  •   Reflecting on my MSc research by Michele Ide-Smith – "By researching the attitudes and perceptions of authorities and citizens I hope to gain a better understanding of perceived barriers, threats and opportunities of using social media for community engagement"
  • Cinch – "Cinch is a free and easy way to create and share audio, text and photo updates using your phone or computer. Cinch enables you to capture and report on your experiences in a way that simple text just can't do. Using a simple interface, you can make and broadcast your content creations through Facebook, Twitter, CinchCast.com and more."
  • The State of the Internet Operating System – O’Reilly Radar – "Ask yourself for a moment, what is the operating system of a Google or Bing search? What is the operating system of a mobile phone call? What is the operating system of maps and directions on your phone? What is the operating system of a tweet?"
  • Penval’s Digital Inclusion Manifesto – Well done Paul Nash. This is what the digital inclusion debate needs – proper, thought through ideas. Genuinely constructive contributions. Not just people bleating about the problems.
  • tecosystems » Forking, The Future of Open Source, and Github – Is the future of open source going to be based on communities such as Apache and Eclipse or will it be based on companies that sell open source? Neither.
  • Dr Dennis Kimbro & his views on recruitment – Really interesting and thought provoking piece on talent management, and attitudes to it, in local government.
  • In quest of simplicty – "We expect IT to be complex and costly, but the lesson of the past 5 years in IT – where we’ve seen the consumerization of enterprise IT (“enterprise” is often a coy way of saying “this has to be complex and expensive – no questions!”) – is that IT can be both simple and cheap."
  • Law and social media – dull but important – "Social media throws up issues of privacy and identity which are far more complex when you have a complete record of someone’s time online and a also a need to balance the personal with the professional roles of an individual. "
  • Powerful petitions with real teeth set to bite – "Local people can now demand their councils take action on underperforming schools and hospitals, drink disorder, anti-social behaviour and other concerns under new rules giving real power to local petitions, announced Communities Secretary John Denham today."

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 March 21st through March 29th

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.

Load more posts!