Thank you for inviting me to appear before you.
It's a privilege and a pleasure to be here today to present Vancouver's experience with open data. As you've heard from our two other speakers today, we embarked on this very important initiative with a view to collaborating with sister and brother municipal governments so that we could take advantage of our shared learnings and move the curve and the agenda of change for us as quickly as possible.
I think what's very clear about success in this particular area is that you need political direction and leadership. In May 2009, our council endorsed the principles of open and accessible data with a very complicated motion, about half of which I didn't really understand. They talked about cadastral data and all this, and most of us were staring at each other. In fact, the essence was that the City of Vancouver will freely share with citizens, business, and other jurisdictions the greatest amount of data possible, while respecting privacy and security concerns. At the end, it was that summarizing statement that gave the direction to staff: get on with this, do it properly, and we're behind you and will support you.
We launched our open data website in September 2009, which was six months after the council motion. I remember the day that council passed this motion. As the city manager, I went out into the lobby outside the council chambers to meet with my staff and talk to them very briefly and give them some direction. I could see that we had our information and our IT staff and some of our senior management all just staring at me asking what this actually meant.
I'll come back to that, because I think the dynamics of getting going on this are very important to understand. Your support and clarity around the intention of this, as our elected officials in government, really makes a difference as to whether action ensues.
We started with 75 data sets—this was information that actually was available on our website, if you had a couple of years to look for it—and basically a sort of divining rod that could take you to it. We have thousands of pages of information on our current website. We're in the process of significantly revamping our website and making it, with a very significant investment, much more user-friendly. But our first step was to take public data that really wasn't found or used by the public and make it user-friendly and actually available.
Today, in February 2011, we have 126 different data sets from our city currently available. Those range from data on our engineering assets to parks and community information, school boundaries, zoning districts and labels, traffic counts, where all traffic signals are, bikeways, rapid transit information, business licences, garbage schedules, recycling schedules. Really, what we did was start with things that were relatively easy, which we knew from our 311 data the public would be very interested in.
That's another piece of advice: start where there's going to be receptivity and interest. Don't start with your most polarized, politicizing data and expect it to go quickly. I think staff understand that and will move.
Since September 2009, we've had 45,000 individual downloads of data sets. That gives you a bit of an idea of the volume. Unlike the City of Ottawa, which is well out ahead of us in terms of public consultation, our consultation was more strategically focused on the community that had been working with our elected officials to say, “Do this; it's the right thing to do”. It's the developer community, the information community, some of our academic colleagues. We're a little bit behind the eight ball now, basically embracing our broad public and community in helping them understand how to use this.
We have about 425 visits per day to our open data website. Given the fact that a lot of the data we have on the website is technical, I think this is just a measure of the interest, and that's prior to having a full and extensive public engagement process.
The favourite data downloads of the people who are using our website in the 200,000 visits we've had since we started are of property information. As Monsieur Michaud indicated on the geospatial data, they're very interested in that. On infrastructure data, we have a lot of our development community and our professional community looking for our infrastructure data.
This was one of the places where we had long conversations with our engineering colleagues, who were very concerned about whether the data integrity was sufficient and what risks there were for them to put the data that they use every day out into the public arena. They were...I think “shy” is an interesting word, but they were very nervous that the data wasn't up to date enough and would lead to difficulties.
But at the end of the day, what's very, very clear is that our professional community, our public, and our academic community welcome this, and they understand that the data may not be perfect. You can adequately provide them a measure of the quality of the data as we best understand it. What is happening, as Guy has said, is that they are giving us feedback and helping us improve the data on a much steeper curve and in a much more rapid turnover than would have happened if we had continued managing it just ourselves.
Garbage collection schedules are the most common phone call we receive from our 311 platform. It is one of the most popular downloads, which tells you something. There's not anything very difficult about publishing a garbage collection schedule. Our citizens want it. It seems so simplistic to have not gotten to that earlier.
As we set up our open data catalogue, we had a number of things that we wanted to ensure were an integral part of our first phase of this. The first thing was to provide some tools to assist the user community to use the data correctly or in the best way possible. I'll come back to that.
The other thing, as you've heard, was for us to collaborate with our partners and, in this case, across municipal governments. I think when you're collaborating with partners who share the challenges that you do, it helps you get over them. It's easier to move ahead as a group than on your own.
We asked for feedback on the data: its usability, its friendliness, and obviously what kinds of data sets our users wanted. We also asked our citizens what data they wanted to see next. We gave updates. We made sure, as people revisited the website, that they understood what was new and what had been added. We have worked hard to connect with our wider data community and with the broad array of partners who have a tremendous interest in all of this data.
I think it's fair to say that we've bitten off the low-hanging fruit. Now the challenge is how to keep going. You can look at my little graph. It shows you that our first curve was quite steep. It's still growing now, but it's flatter. I think one of our most important exercises now is to look at what's keeping us from steepening that curve again. Is it the complexity of the data? Is it the difficulty in ensuring that it can be presented in a user-friendly fashion? That's some of what we're working with, both within our own organization and with other municipal governments.
FOI, as you've heard, is an important part of open government and sharing of data. Interestingly, as a general manager...and I've worked in the past as a deputy minister in the province. For those of us at that level of government, at the interface of our elected officials and our bureaucracy, a big part of our job is managing the sharing of information and the strategic advantages, opportunities, and risks with that--and how to do it properly. I would say that FOI is always a very huge opportunity for us, but as you've heard, learning how to manage it more proactively is a challenge that I think many of us could use some help with.
Having looked at our FOI requests, the things that we believe are suitable right away for open data include financial information. We currently share PDF versions of our budgets and all of our financial reports. There's a huge amount of financial information that, on a regular basis, is published and discussed in open council at the municipal level. But we don't provide a lot of detailed breakdowns on an ongoing basis by department or project.
A big area of interest is expense claims of elected officials. Our council has pledged to have those published as they happen, on a quarterly basis.
Regarding the list of contracts between the city and third parties, we publish annually, under our provincial statute, that kind of financial information--but it's once a year. We are now starting to publish quarterly reports of contracts that are procured and issued by the city, and a metric of whether they are procured openly or are sole-sourced, and if so, why. Just the notion that we will be publishing that and the work we've done on procurement in preparation for it has reduced our sole-sourcing of contracts to 2% of all our large competitive contracts.
Dog impound data, interestingly, is a huge source of interest to our public. I have no explanation for that, but we'll be publishing it.
There are our 311 statistics, which are basically all of the data on the people phoning in to our 311 platform and asking questions. Of course, when you start to publish that, it actually makes your organization a lot smarter, because they realize if you're going to publish what citizens are asking, then the next question will be on what we are doing about it.
I can't emphasize...and you've heard a lot from Mr. Michaud about the advantages and what we've learned through this initiative. I think we have learned all the same things, but one of the things for me as the city manager is that this openness around our data makes our organization work much better, and we're more proactive; we think it through. The normalization of the notion that all of what you're doing and all the data that you are collecting will be made public and that's just normal business really ramps up the rigour, the analysis, and the thoughtfulness of the work that we do as public servants.
We have many different requests from our public. Just to give you some examples, they're very interested in community centre data, all of the parks and recreation data. They want data from our cemeteries, cemetery records. I assume these are people doing genealogical research and interested in that...and the Vancouver Public Library.
So we have a long list of things that we plan to release.
One of the ways we've looked at it, which is of assistance to us in terms of the feasibility, is on a risk matrix, where we look at data in terms of its cost and complexity to publish, and then look at it in terms of the public value. When you map your data in that way it actually starts to make it easier to understand how quickly you can make it available and what the end result is going to be.
We've had commercial applications done, which I think you've heard about from previous speakers at this committee. We have academic research. How global warming will transform Vancouver's shoreline is the product of our open data. We have citizens reporting disabled parking abuse through one of the apps that's been developed. I think you know that Vancouver is the centre of online games, and we have a game that's been created called TaxiCity, which was developed by Vancouverites who built the game with our data and are selling it as an entrepreneurial undertaking.
Finally, in regard to the benefits we have found, this whole initiative does transform your relationship with community. It builds trust. It allows you to engage with your community in a completely different way, and it's very empowering to our public and our partners. It enhances the return on investments in data--collecting data and keeping it. Ensuring that it's quality data does cost money, and if you're able to share it and get all of the corollary benefits, it's hugely beneficial. There's economic development, transformation, and value for money in the public sector, because we are learning quite quickly about where citizen self-service could actually be initiated through the kinds of things citizens want. And I think it's building partnerships with other governments, which is very effective.
I'm going to stop there and just say that in the next year we're going to be developing simple tools for our citizens. We hope to develop and see a common website; our G-4 group is looking at developing a common website and sharing that with other government and crown agencies. We want to build open data principles into all of our work and normalize it and therefore steepen the curve of change.
Ladies and gentlemen, thank you for giving me the opportunity to appear before your committee.