Feeds:
Posts
Comments

Posts Tagged ‘mashup’

www.workingincanada.gc.ca/tool

(via GTEC Blog post announcing winners of this year’s GTEC awards – this one received the bronze in the service delivery category for federal tech.)

This is a neat initiative. It’s a webapp that’s aimed at helping new Canadians make informed decisions about where to live and work. Put together by HRSDC.

Users enter info on the profession they are interested in and the geographic location they want to investigate, and they receive a grab bag of useful info. Here’s a screen grab at the “choose location” step.

Screen grab of the Working in Canada Tool interface at the "choose location" step

click image to see full size

It has a nice clean interface, the workflow is very obvious. I was able to blast through it in about 30 sec to get lots of relevant info: whether or not the profession is regulated or requires certification, hourly wages for my chosen location, what the outlook for that job type is, and even links to job opportunities from www.jobbank.gc.ca

Even though this is aimed at newcomers to Canada, I could imagine it being used by anyone considering a move within Canada too. F’r instance I was able to find out that people in the marketing communications world make more or less the same in Montreal (average salary: $28.33/hr) and Ottawa ($28.70/hr), and this is slightly lower than the national average ($29.97/hr). I might have to play around more with this to figure out where I need to move to!

To make the whole thing work, the app pulls data from a wide variety of govt sources. The aforementioned job bank, but also labour market information, the NOC job classification database, the CMHC, and more. See the app’s About page for the full list.

Pretty nice example of pulling together info trapped in widely spread out databases and making it work to improve government services.

Read Full Post »

Found this after my post yesterday on SpotCrime:

Vexed tracker: Crime-spotting site denied cop reports

Article from The Hook, a Charlottesville, VA, alternative-style weekly paper (a la Ottawa Xpress or Toronto’s Now Magazine).

Seems that Colin Drane, the guy behind SpotCrime, has had some trouble getting the powers-that-be in Charlottesville to play nice with him:

He launched Spotcrime.com and UCrime.com here October 8, shortly after Charlottesville police declined to provide him with the daily incident report it emails to local media. “The logic was, you have ads on your site and we’re not going to share,” relates Drane, who notes that the Hook, which receives the daily report, has ads on its website. He says city police plan to launch their own crime-tracking site on Google Maps.

Weird logic excuse if you ask me – taking Drane at his word, it’s as if the police force would rather spend their own time and resources developing a mashup rather than let SpotCrime do it for them for free.

Anyhow, there’s always the other side of the story:

City spokesman Ric Barrick says that the Charlottesville police daily incident report is available online, and that Drane “can go onto the website like anyone can.” … Barrick cautions that information on the daily incident report is raw, and what someone calls in as a crime may, upon investigation, turn out to be something completely different. “You have to be very careful in comparing this data,” he warns.

“I do feel like we’re more willing and transparent to get that to the public,” says Barrick. “Other jurisdictions don’t put it out at all. We do have a website. Other jurisdictions don’t. To say we don’t share isn’t fair– but we don’t put out every bit of crime data.”

The reliability factor is an issue, I suppose. I’m envisaging somebody calling the police about some crazy noise in the street at 2 a.m. that turns out to be cats fighting in an alley. But if the data is suspect, then why is it released to the local media and issued on Charlottesville’s police force website too? & why do so many police forces in other places release this data? I don’t get it.

In case you’re wondering in what form Charlottesville’s daily incident report is posted online, turns out that it is (what else) a PDF file that is basically a text table listing reported incidents and arrests with street names and relevant dates. No sorting possible. No mapping despite location data being one of the key pieces of info being provided. And being a PDF, it’s painful to parse or scrape. Ugh.

So overall– yes the Charlottesville police do make an effort to provide the data, but it’s not in a very useful format. SpotCrime provides a very useful way to present the kind of data that the Charlottesville police provide. Really they ought to be able to work together.

Aside: other SpotCrime tidbits:

Read Full Post »

(Seen via this post on Mashable)

SpotCrime mashes up police reports (according to TechCrunch, 90% of the data is scraped this way) with Google Maps to provide crime maps for various cities. Users can filter by date, type of crime or time of day.

Click to see full size.

Click to see full size.

Above screen shot is the Ottawa map – here’s SpotCrime’s Ottawa site. Looks like over the last 2 months it’s all about vandalism, theft, and breaking and entering. Very different from Toronto’s profile, which appears to be much more about face to face confrontation — assault, robbery and a few shootings for good measure.

Many other major Canadian cities are included as well – see the list.

SpotCrime also allows users to click on the map icons to get additional detail on each incident and a link to the source data – every one that I clicked through pointed me to a police report of some sort. Users can also sign up for crime alerts or report a crime. Not sure how this last bit works – how is the info vetted? I’m sure there’s more than a few folks out there that might get some kicks out of abusing this. But help documentation on the site is, uh, lacking, and I didn’t go poking around the SpotCrime blog to see if they’d addressed this issue.

Anyhow, it’s still a pretty nice re-use of government data. Very simple and easy to grasp quickly. Much more user-oriented and immediate that the Ottawa Police’s own crime statistics reporting, which is essentially a set of PDF files (ugh) that list reported crimes by district and month.

I wonder how long it’ll take before the Ottawa police decide to collaborate with these folks or someone similar? Would make a lot of sense – they could drop their PDFs and just point folks to SpotCrime or deliver it through their site.

Read Full Post »

Interesting that despite the fact that Radiohead’s sound hasn’t progressed since their Kid A/Amnesiac breakthrough back in the day, the band continues to keep my attention in other ways.

They’ve just released a very cool video that was created using rotating laser scanners, 3D imaging and data visualization techniques — and no film or cameras.

Says the director of the video, James Frost (who’s done videos for the Flaming Lips among others):

In a weird way it’s a direct reflection of where we are in society… that everything is data. Everything around us is data-driven in some shape or form, and we’re so reliant on it now. It seems like our lives are digital, and so in that sense, it definitely felt apt.

Actually, that is as good an explanation for the current data visualization craze as I’ve heard yet.

Aesthetically, “House of Cards” reminds me a little of Tron, crossed with those toy boxes with rows of movable cylindrical metal pins that make a 3D contour when you press your hand or face on them (what the heck are they called?).

And Google is totally getting in on the action – Google Code is also hosting the video, as well as a “making of” clip (where I got the quote from the director above) and assorted other goodies for programmers who want to do remixes/mashups.

It’ll be interesting to see what comes out of making the data and source code available. There’s already 15 videos posted to the official YouTube group. Most focus on fiddling with the image data - this one is neat – but there’s already one that takes a hack at both the visual and auditory channel.

Read Full Post »

Getting at the data

(Image source: Unhindered by Talent on Flickr)

My trusty Google Alerts on all things Govt 2.0 have been feeding me a steady trickle of reaction and reportage on a draft paper from scholars at Princeton which was released last month. In the paper the authors argue that the US federal government should pretty much get out of the business of maintaining websites and simply release the data.

In order for public data to benefit from the same innovation and dynamism that characterize private parties’ use of the Internet, the federal government must reimagine its role as an information provider. Rather than struggling, as it currently does, to design sites that meet each end-user need, it should focus on creating a simple, reliable and publicly accessible infrastructure that “exposes” the underlying data. Private actors, either nonprofit or commercial, are better suited to deliver government information to citizens and can constantly create and reshape the tools individuals use to find and leverage public data. The best way to ensure that the government allows private parties to compete on equal terms in the provision of government data is to require that federal websites themselves use the same open systems for accessing the underlying data as they make available to the public at large.

Typical reaction from the Web 2.0 set is along the lines of:

That’s a compelling vision of the future of open government, and one that makes a lot of sense. The idea is something like CSS — which separates the display code of a web site from the content. A government data platform would separate the content from the task of displaying it, which the commercial and non-profit spaces are likely better suited for than the government itself.

OK, well sure, makes sense that someone who’s got buckets of data that was publicly paid for (like Stats Canada, to take a Canuck example) should be making it freely available for others to use, for mashups or something similar.

This is basically the same argument that Hans Rosling makes with his Gapminder project and in this mind-melting presentation at TED from a couple of years back (presenting macroeconomics data like a sportscaster — wow!). He’s been working specifically with UN data, but the idea is still basically the same.

But to suggest that Govt should get out of the Web business altogether is absurd.

First off, there’s the privacy issue – lots of Govt data is about individual citizens. I’m not sure how well people would take it if their information was being accessed by marketers or advertisers who were able to freely connect to the social insurance database or the passport database. Think of the Facebook vs privacy controversy – and then up the angst by orders of magnitude. So while making some govt data more freely available is a good thing, there’s lots of data that the bureaucracy holds that really no one else should be able to get at. (But this isn’t really a Web publishing issue is it – it’s more about NOT publishing at all.)

More importantly, there are other compelling reasons for the existence of Government Web sites than just to provide a shell for their databases – like, well, gee, how about informing citizens about what Govt is up to? Don’t you want to know how your taxes are being used? Don’t you want to know how the government of the day is responding to issues or dealing with crises?

As a citizen, I’d be pretty miffed if I could no longer go to directly to www.parl.gc.ca to see what’s going on in Parliament. Sure, most of the time it’s a bore, and the really big news gets reported by the media and blogosphere, but I still like the idea that I can go there and see for myself what is happening — without any filter. And plus the protocol stuff is pretty funny.

Or what about getting access to government services – I would rather go to www.canada.gc.ca directly to find out how to apply for government services than have to check with a third party. And if I wanted to check on the status of my tax refund? Again I’m not sure that I’d want to go to a third party to see whether my cheque is in the mail or not (here’s an example where privacy and Web publishing come together).

Basically, framing the issue as an either/or choice doesn’t make a lot of sense for me. There is lots of room for both opening up govt databases for third party use and also to maintain a solid govt web presence.

Other reporting on this can be found here, here, here and here.

Read Full Post »

Follow

Get every new post delivered to your Inbox.