Special Report: Open Public Data

Open Data is Cool

Dowsing and Milton Splash are just small examples of what can be accomplished with open data.

By Nik Garkusha
Published July 26, 2011

The heat has been scorching! Residents across Ontario, Quebec and part of the US are trying to stay cool. Many people seek out public swimming pools and splash-pads, and turn to their municipalities for information. Others, like Joey Coleman of Open Hamilton and yours truly seek out ways to make that information more accessible.

Hamilton's Dowsing and Milton's Splash are two of the most recent examples of what is possible with open data. They represent a real-life case study of how Open Data can help keep us cooler, while also helping cities provide a better service at a lower cost.

Better Service, Lower Cost

Many municipalities, like the Town of Milton, provide great-looking printed community maps with swimming pool / spray pad information and various community services guides [PDf].

The challenge with those are production and printing costs, which pose a barrier to keeping the information current. For instance, the Milton map is missing some of the newer facilities (like the two splash pads in newer areas of Milton).

The solution: post the source data for the map, i.e. a machine-readable list of facilities with geographic coordinates.

No fancy formatting, no map production, or printing, or distribution required - save our taxpayer dollars. Just publish the raw, most up-to-date data online, the data that already exists in town's information systems.

To Milton's credit, town staff produced a Beat the Heat [PDF] poster with an updated list of facilities, which even included an advisory on one of the spray pads closed for repairs.

The obvious challenge: what happens when repairs are completed, but the flyer is still in circulation? Again, open data to the rescue.

One Source

With so many sources of information (maps, guides, flyers, website pages), open data can become one definitive source of data.

Open Hamilton's Dowsing does just that by pulling partial data for water facilities from at least four sources into one dataset. Milton Splash similarly integrates information from three printed publications into a single dataset.

One place as one definitive source of data drives better accuracy and also better government efficiency. Cities with open data catalogues discover that not only citizens, but also city staff use those catalogues as the primary source of data.

When implemented correctly with workflows and processes to keep the data current, cities can realize significant savings by having just one place to update. Many open data catalogues, such as Microsoft's open source OGDI or commercial Socrata, provide open standard Application Programming Interfaces (APIs) to the data. This creates a cascading effect, with open data APIs driving many different uses.

Many Uses

Even without "fancy" APIs or "catalogues" any municipality can realize the benefits of open data. All it takes is data, a website and a license. (A license outlines the terms of use for how the data should be used. For more info on the topic of licenses see this recent article on the state of open data licenses in Canada).

Once the data is online in a machine-readable format, it can literally "turn on" any number of web pages, digital maps, visualizations, online reports, web and mobile applications, and even ordinary spreadsheets like Excel, accessible for those without programming skills.

That is Government as a Platform, the vision popularized by Tim O'Reilly.

For water facilities, all the cities need to do is provide the names, coordinates, hours and status (advisories, etc.) as a download.

For Milton I used OGDI, which allowed me to make the data accessible as an HTML table, a file download (CSV), a map or KML download (common mapping format), or as an XML oData feed or JSON API to power any number of third party interactive maps and apps just like Milton Splash.

Dowsing and Milton Splash are just small examples of what can be accomplished with open data. Both are relatively uncomplicated apps, but each can provide a useful service to Hamilton and Milton residents searching for a pool or a spray pad nearby. As the heat wave breaks records, one couldn't ask for a better way to showcase the value of Open Data.

This was first published on OpenHalton.

Nik Garkusha is an open data and open source geek, technology evangelist and consultant. He is the founder of OpenHalton.ca. He is also the Open Source Strategy Lead at Microsoft (Port25.ca).


View Comments: Nested | Flat

Read Comments

[ - ]

By WRCU2 (registered) - website | Posted July 27, 2011 at 09:14:35

Yes my friend, open data is cool. I found this data right out in the open on The Hamilton Spectator web site.

combined investments and initiatives are already making a difference for Ontario families, as the poverty rate for children in Ontario declined from 15.2 per cent in 2008 to 14.6 per cent in 2009. In 2009, 19,000 fewer Ontario children were living in poverty. Madeleine Meilleur, Ontario Minister of Community and Social Services

As an average reader I may celebrate the 19,000 children lifted from poverty and never even give IT a second thought. Cool. However as an open, avid and more intuitive data reader, I may also use the numbers given and work backwards towards the actual number of Ontario children STILL living in poverty: .6/100 = 19,000/X ; .6X = 1,900,000 ; X = 3.17 Million and I find this number is so much more chillin'.

Let us celebrate the coolness of OpenData by making an even bigger splash that tempers our public errata with some cold hard cash!

Comment edited by WRCU2 on 2011-07-27 09:47:04

Permalink | Context

By DM (anonymous) | Posted July 28, 2011 at 11:49:12 in reply to Comment 66959

the dangers of open data! need to check your math!

article tells us that
0.152x - 0.146y = 19,000
where x = population of children in 2008 and y = population of children in 2009

if we assume that x = y (necessary based on information provided to solve the problem) then,
0.152x - 0.146x = 19,000
0.006x = 19,000
x = 3,166,667 = total population of children

Thus, the number of children STILL living in poverty is
0.146x = 0.146 X 3,166,667 = 462,333

Permalink | Context

By WRCU2 (registered) - website | Posted July 31, 2011 at 13:22:40 in reply to Comment 67037

Thanks for the correction although that number is still chilling!

Permalink | Context

By TnT (registered) | Posted July 28, 2011 at 09:40:37 in reply to Comment 66959

Sad, but chilling. I guess it shows that the data is helpful to get behind the spin. A cautionary tale of it also being used as spin.

Permalink | Context

[ - ]

By WRCU2 (registered) - website | Posted July 27, 2011 at 12:44:46

Wow, one vote and IT wasn't even my own very COOL!

Permalink | Context

View Comments: Nested | Flat

Post a Comment

You must be logged in to comment.

Events Calendar

There are no upcoming events right now.
Why not post one?

Recent Articles

Article Archives

Blog Archives

Site Tools