My friend Ton Zylstra’s talk at Cognitive Cities, Spice Up Your City With Open Gov was a call to action for citizen hackers to catalyze the release and use of open government data. While Ton’s talk was full of useful memes, the most useful one was a call to find “The Man in the Blue Shirt” – a single advocate inside the public service to ally your efforts with.

My government data efforts over the years have profited from many such “blue shirts” – people working in government who “get it” and have the logistical and social skills to help you get things done. The halls of the municipal, provincial and federal governments are filled with people like this, just waiting to be asked to help.

So here’s my first “ask.”

The City of Charlottetown releases building permit, subdivision and rezoning approval data every week locked inside PDF files. It’s good that they release the information on the web, but because it’s released as data that, for all intents and purposes, is just an amorphous mass of text, it’s next-to-impossible for citizens to add value to the data.

Let’s say, for example, that I want to build an application to alert me when a building permit is issued within 1 kilometer of my house. Or an application that displays a map of the city showing where building permits have been approved. Or a report showing how long, on average, it takes the city to approve permits. With the data in its current form, I’m left to try to manually scape the data out, and it’s practically impossible to build these kinds of applications.

The stock answer at City Hall is that “we have no IT department,” which is true. But it’s precisely inside small bureaucracies like the City of Charlottetown where releasing data in an open, usable form is most useful: the City, in its citizens, does have an IT department, and it’s we the people. The relatively small engineering effort required to release data in an open form could have tremendous leveraging effect once we citizens get our hands on it and enliven the data in ways the City itself never could.

To get this effort rolling, I’ve created a github project called Charlottetown-Building-Permits and taken last week’s PDF file of building permit approvals and created an XML version of it along with a draft XML schema.

It doesn’t take much more effort to create this XML file than it does to create a PDF file (and, indeed, the XML can be used to create the PDF file if needed), and yet the XML file is revolutionarily more useful.

Consider this a call to action for a “man in a blue shirt” – yes, Councillor Rob Lantz, IT-savvy Chair of Planning and Heritage, I’m looking at you – to take this and run with it. I’m here to help.