Open Data Is Not Web 2.0

A colleague of mine tweeted today that “There are 3 types of Web 2.0 in Government: Social Media, Collaborative Tools & Open Data”.  I’m not sure if I agree with him. Since my thoughts are longer than 140 characters, so I’ll blog about it instead.

The Wikipedia definition of Web 2.0, which I think is accurate, says:

“The term Web 2.0 is commonly associated with web applications that facilitate interactive information sharing, interoperability, user-centered design,[1]  and collaboration on the World Wide Web. A Web 2.0 site gives its users the free choice to interact or collaborate with each other in a social media dialogue as creators (prosumer) of user-generated content in a virtual community, in contrast to websites where users (consumer) are limited to the passive viewing of content that was created for them.”

By this definition, Social Media is Web 2.0, Collaborative Tools are Web 2.0, but open data is not.

Open data is published information.  It is intended to be used by an audience, not in a collaborative fashion on the hosting website, but elsewhere, for analysis in other applications. These applications may be designed specifically for use with that dataset (like TaxiCity), or they could be an existing everyday application (MS Excel, for example) used to analyze a dataset.

One could argue that open data is user-generated content, and this would be correct, depending on the dataset.  I don’t think it’s enough though to generalize it under the term Web 2.0.

“In Government”: The original tweet did specify that there are 3 types of Web 2.0 in government.  It may be worth noting that providing open data is new the direction that government (at least in Canada) is heading with their web publishing. The timing of this happens to coincide with their use of collaborative tools and social media.  In my opinion, it is a separate action though – grouped with transparancy and open government, not Web 2.0.

Thoughts?

Mobile GEDS Usage Graphs (November 2009 – August 2010)

Mobile GEDS has been running for a while now, so I thought I’d take a look at its usage stats.

The first query was just to see what language the site was being queried in.

Chart of GEDS usage by Language

More interesting is the usage by device/browser.  For the sake of this graph, I grouped all the Blackberry models together, and all the versions of each desktop browser together (Chrome, Firefox, IE, Opera and Safari).  I was more interested in what device users were accessing the service from, so when you see a browser name, it’s a desktop version (Windows, Mac, Linux), mobile devices show the device name, not the browser.

Here’s the actual data:

Browser/Device Number of Queries
iPhone 271
Internet Explorer 269
Blackberry 222
Mozilla Firefox 183
Google Chrome 40
Apple Safari 29
Samsung SPH-M540 17
iPod 9
HTC Magic (Android) 9
HTC Dream 6
iPad 5
Crawlers 4
HTC Nexus One 2
LG 8700 2
Opera 2
Samsung Omnia SCH-i910 1
Sony Ericsson X10 1
Motorola K3 1

The Cat Empire – Cinema

Browsing through the shelves at Compact Music this week (yes, I still shop at record stores), I came across a new release from Melbourne, Australia’s The Cat Empire. I hadn’t realized they had a new album coming out, although I probably should have guessed it by their appearance this summer at the Bluesfest in Ottawa.

If you’ve never heard their music, I recommend checking them out. They have a very distinctive sound, which I credit their horn section for. Their style could probably best be described as a mix of jazz, rock and ska.

I love driving with great music cranked up on the stereo. On Cinema, I give credit to Waiting (track 1), Falling (track 2), Call Me Home (track 9), and On My Way (track 10) for keeping my short musical attention span while behind the wheel. The Cat Empire’s upbeat tracks have always been my favourites. The scratching finish to Call Me Home is particularly enjoyable.

I’m happy to report that Cinema has a feeling closer to 2005′s Two Shoes and their debut release The Cat Empire in 2003 than it did to their previous album So Many Nights (2007). Unfortunately I don’t think any of the tracks on this album will have the lasting power in my musical physce as Chariot, Hello, or The Car Song.

Cinema by The Cat Empire

Rating: 3.5 of 5

In One Word: Fun!

View Comments

Back to the Future vs Tik Tok

Not the usual subject of my blog posts, but this video made me smile enough that I felt I should share it.  I’m a big fan of the Back to the Future series, especially the first part, which this video spoofs.

Enjoy!

Ottawa Supports Open Data

The open data community in Ottawa has a reason to celebrate this morning.  Ottawa City Council has given the green light to the release of municipal datasets in open formats, with the launch of their data catalogue, officially still in beta at www.ottawa.ca/opendata.

The terms of use for these datasets is for “world-wide, royalty-free, non-exclusive licence to use, modify, and distribute the datasets in all current and future media and formats for any lawful purpose”.

The very limited catalogue launched today includes SHP files for municipal landmarks including parks, museums, sports fields, wading pools and splash parks.  The catalogues format has columns setup to support other formats including CSV, XLS, DWG, and KML — a very similar layout to the Vancouver Open Data Catalogue.

In addition to the official city website, dataott.org has also been launched.  This site, being billed by the city has the “community-led discussion”, is a location for users to request additional datasets they would like to see released.

Today’s success puts Ottawa on a growing list of Canadian municipalities now publishing open data, including Vancouver, Edmonton, and Toronto.

Thank you to the city councilors who voted in favour of this endeavor. Also, thank you to everyone who has been involved in bringing awareness to this issue – including, but of course not limited to Edward Ocampo-Gooding, Mary Beth Baker, Thomas Cort, Daniel Beauchamp, Mark Faul, Shawn Simister, Willem van Bergen, Robert Giggey, Derek Gour, Chris Taggart, and more.

View Comments

Letter on Open Data to City of Ottawa Councillors

The following e-mail was sent to councillors Bob Monette, Rainer Bloess and Rob Jellett, who represent the east end of the City of Ottawa, in which I live.  I encourage you all to write your councillors in support of Open Data.

-

Councillor,

As a resident of Ottawa’s East End, and as a software developer, I am writing you regarding the presentations that were made before the IT Services Subcommittee on Monday, April 19th with regards to “open data” in the City of Ottawa.

If you are not yet familiar with the topic of Open Data, the basic idea is that information should be made available in standard formats that can be read by a variety of computer programs. This data should be available for use by the public, without restrictions.

For example, the City current publishes its Garbage Collection Calendar as a PDF file on its website.  Although PDF files are a popular format in which to present data, they are is not “open”. All you can do with a PDF-based calendar is look at it, or print it.

An open version of this same calendar would be, in its simplest form, a list of dates on which garbage collection would occur and which types of garbage and recycling are collected on those dates.  Although not as visually appealing as the current PDF calendar, this list of dates can be read by many different pieces of software to provide value-added services such as sending reminders to your cell phone or e-mail address the night your recycling should be put out, or adding the collection schedule to your calendar software of choice.

A few examples of other datasets that would be of value if provided in an open format include map layers of bicycle paths, parks and parking lots, lists of upcoming events, or the inspection records of local restaurants.

There are a growing number of developers that are, for their own utility or enjoyment, taking data that is made available by the City, and creating computer applications to inform and serve the citizens of this city.  These applications take many forms – from websites to applications for mobile phones.  The Open Data initiative aims to make more information available.

Yes, there is a cost associated with making the data available.  However, you will see a great return on this investment as these applications are released.  The cost of preparing this data and making it available is minimal compared to the cost of having the city develop the applications that will be created by the community.

This Saturday, April 24th, the “Open Data Hackfest” will be taking place at City Hall.  This event will showcase applications already being created with the limited data that is available.  Other cities in Canada – Vancouver, Toronto and Edmonton, to name a few – have released many datasets in open formats.  I encourage you to look at what both our own local developers and other cities are doing, to see the possibilities that exist for our city.

You can find information about these initiatives through the following links:

I believe in the value and the benefits of open data to the City of Ottawa, and am very glad to see that IT Services Subcommittee is in favour of it.  When this issue is presented before the full council, I hope you will support it as well.

Please do not hesitate to contact me if you have any questions.

Shawn M. Hooper

Facebook Social Plugins

Facebook has just announced at their F8 conference, a new feature called Social Plugins.  These plugins are intended to make the integration of Facebook into websites as simple as possible.

The first example the showed is the “Like” button plug-in, which allows you to add the famous “Like” button to any page on your website with 1 line of code.  There’s no authorization required (ie Facebook Connect).  Just insert:

<iframe src=”http://www.facebook.com/widgets/like.php?href=page_url_here”  scrolling=”no” frameborder=”0″ style=”border:none; width:450px; height:80px”></iframe>

and away you go.  It takes 2 seconds to implement.   I’ve done it.  Check out the Like button below.

Review of the Official Twitter for Blackberry App

This weekend I downloaded the newly released Twitter for Blackberry application. This application, released by Research in Motion,  is being billed as the official Twitter application for the Blackberry smartphone. I found several good and bad things about it.

Pros:

  • Clean user interface
  • Supports lists
  • Integrates notifications into the Blackberry Messages window

Cons:

  • No support for the old style re-tweets.
  • I found the compose new tweet window to be too small
  • Couldn’t attach tweet location on a per-tweet basis.

After using it for a few days, I have decided to switch back to using UberTwitter.

Mobile GEDS has a new home

The Mobile GEDS application now has a new home.  Point your favourite mobile device to:

http://geds.gc20.ca/

Enjoy!

View Comments

SQL: SET vs SELECT

I’m re-writing an old stored procedure that uses dozens of SET statements.  While looking for ways to improve its efficiency, I came across a test that shows running a single SELECT statement setting multiple variable values is much faster than running multiple SET statements.  You can see the test here:

http://sqlblog.com/blogs/alexander_kuznetsov/archive/2008/10/31/assigning-multiple-variables-with-one-select-works-faster.aspx

Cheers.

Shawn

View Comments