Information and Privacy Commissioners' Right to Know Forum Open Data at The City of Calgary Presented by Dale McNamee September 2014 Copyright © 2014 The City of Calgary. All rights reserved. Content Data/Information Where we have been Where we are Where we are going Data The height of Mt. Everest is generally considered as "data", 8848 meters or 29,029 ft Information Book on Everest: Summit of Achievement By Broughton Coburn Online Data Distribution History • 1993: Introduced as a BBS dial up service administered by IT • 1999: Mainframe dial up replaced by web frontend • 2000 to 2003: New services introduced, including click wrap licensing • 2010: Initial Open Data Catalogue • 2013: Open Data Catalogue reconfigured Past Open Data • 2004: OECD initiates notion of Open Data • 2007: OECD adopts resolution to promote distribution of government data • 2009: US launched data.gov followed by municipal governments • Fall 2010: The City of Calgary launches Public Data Catalogue Pilot. Licensing terms and general catalogue format aligned with Vancouver, San Francisco Data Licensing Revenue $3,000,000 $2,500,000 $2,000,000 $1,500,000 Revenue $1,000,000 $500,000 $0 1994 2004 Year 2014 Open Data Policy Challenge • Revenue from data licensing offsets the tax burden of collecting and managing the data necessary for municipal government operations • Provide more data, which currently generates revenue, for free increases the municipal tax burden • Calgary elected officials and senior administration are committed to a responsible balance between that which is licensed for revenue and that which is licensed without cost (both are licensed) Open Data Educational Video Present power of data in the hands of many What’s Happening Open Data Catalogue launched in August 2013 • Currently 100 datasets • 10000+ downloads per month • Data is released under an Open Data License that allows data to be used for any lawful purpose • Data has been used to support one datathon (by Data for Good) and one hackathon (by Startup Calgary) • Currently 22 apps available for Android and IOS that use Calgary Open Data (source Google Play and Apple App stores) that have been downloaded more than 750,000 times (source Google Play for Android, xyo.net for IOS) Our Process Popular Datasets 20000 18000 16000 14000 Number of Downloads 12000 10000 8000 6000 4000 2000 0 Calgary Transit Schedule and Routes Census Data Calgary Business School Locations Licenses ‐ Open Data Version 100 Year Flood Plain Current Initiatives Partnerships with other Open Data providers or users • • • • Government of Canada Government of Alberta Other Alberta Municipalities (e.g. Calgary Regional Partnership) NGOs – Data for Good, Universities, Innovate Calgary Observe and participate in standards activities • Open Knowledge Foundation Partnerships with The University of Calgary UofC Student Data Licenses for City Data: 2004-2014 250 200 Number of Data Licenses 150 100 * 50 0 2004 2005 2006 2007 2008 2009 * 2010 2011 2012 Year (*2014 data is up to August 25, 2014) 2013 2014 Benefits • Citizens right to access • Transparency • Foster and promote innovation • Improved data quality Startup Calgary Weekend Civic Hackathon • • • • Weekend of August 22 to 24, 2014 Hosted by Startup Calgary Sponsored by City of Calgary (Municipal Building as the venue) Other sponsors included Innovate Calgary, Microsoft, Banff School of Management • 50 competitors formed teams and pitched 8 apps using City of Calgary open data • Teams had 54 hours to research and develop their apps and then pitch them to a panel of 5 judges Startup Calgary Weekend Winning Teams 3rd place Homefetch • An app designed to help new home buyers determine which area of The City had the amenities and home that best suited their needs 2nd place Trustr • An app to help landlords filter prospective tenants for their rental units 1st place Live Transit • An app to allow transit riders to purchase tickets using smart phones Amount of data/information available on The City of Calgary web sites Data.calgary.ca • 100 data sets CITYonline.calgary.ca • 23 data sets/123 products/services Calgary.ca • • • • • 24038 Documents 2497 Webpages 854 Newsfeeds or articles 9072 maps 1609 Videos The Future Open Data Opportunities Data Already Publicly Available o But not in re-useable format Geographical data o Parks, parking, recycle depots, pathways, recreation facilities, etc… Schedules o Transit, Waste & Recycling, City facilities we are not we are Thank you https://data.calgary.ca/OpenData/Pages/DatasetList ingAlphabetical.aspx