Open Data, Open Innovation
and The Cloud
Expectations are Changing
Personalized, quality services wherever they are Engagement in issues that affect them
Their privacy and security respected
Citizens expect…
Tools that follow their work style
Workplacesthat support the devices they use
Social tools to help them collaborate across boundaries
Workers expect…
The ability to consult with constituents wherever they are Insight and performance management
Competitive environment, attracting investments
Exploiting the Latest Technology Trends
Consumerization
Cloud Computing
Data Explosion
Scenarios
• Mash-up data to create data feeds
• Publish feeds into Open Data Catalogues • Develop applications that consume data
Utilization
• Reuse data internally across agencies • Stimulate public innovation
• Improve citizen services 4
Open Government Data
“Value of 47 open data apps Apps for Democracy initiative”
Savings by CDN Government
Cost to
Washington DC for 47 apps Annual Cost of Open Data
Country Data Type Estimated Business Value
Australia GIS/Spatial €5.2Bn
Australia Statistics €19M
Denmark Energy/Construction €540M England/Wales Local Geospatial €400M
Ireland National €83M
Spain National €550M
UK GIS/Met/Mapping €7.5Bn
LOB Apps Hierarchical Flat files oData Feeds Civil Servant Agency Citizen Developer Open Data Data Catalog Search tools API Data feeds Internal Data Integration Services Analysis
Services Reporting Services
Open Government Data Scenarios
7 Performance Management Advanced Analytics For Government Public Websites Community Data Geographic Information Systems Enterprise Information Management Open Government Data Government ERP Government Data InteroperabilityCloud is Open for developers Low entry cost
Open Data and the Cloud
Innovation Accelerator Build quickly Minimal infrastructure Highly scalable Data agilityEye On Earth is the outcome of a strong collaboration with Microsoft. It maps sensor water and air quality data, while allowing citizen feedback through its dynamic and user-friendly web site.
Eye On Earth is a Cloud-based service by European Environmental Agency (EEA), since 2009
Water quality measured vs. reported at Brno dam – Brněnská přehrada
www.eyeonearth.eu Localized in 26 Languages Open for more information Map functions Enquiry pushpin
Eye On Earth Solution Builder SDK (Azure)
• Enabler for rapid development of simple geo‐based solutions
Preparation services Runtime services DataMarket publication services Azure Solution Builder Portal Data Transformation Spatial Data Manipulation Data Imports ExportsTiling Web Map Service Spatial
Cost-Effective Infrastructure
Catalogue Integration Seamless Access
Cloud Scale
Big Data Analytics
http://data.gov.uk
UK Weather Data Archive
Facts and Figures
• UK Met Office Weather Data on data.gov.uk
– 5,000 UK locations,
– Hourly forecasts: daily + 5 days, 3hrly + 5 days
– Approx 250 million rows per hour of data
• Transport for London (TfL) ‐ London Underground Trains
– #1 European popular Open Data solution by citizen usage
• average 2.3million hits per day from 80+ ISV mobile apps on iOS, Win8/WP, Android– Major CAPEX savings (£2m+) for TfL cloud infrastructure
– ‘London Tube Map’ Windows 8 app
Microsoft Open Government Data Initiative
(OGDI)
The cloud: Azure
OGDI/DataLab
Open APIs, Scale &
Reliability of Windows Azure
Roll out open data portal fast and at low cost
Open Source with
European OGDI version on
GOVDATA.EU
9 EU Member States
already publishing data
Dataset Categories
Leveraging Windows Azure DataMarket
18
DataMarket
For Citizens
• Read datasets directly into Excel
• User friendly mash-up by Excel PowerPivot (free add-in, downloadable)
https://datamarket.azure.com/
• Open standards, comfort for non-IT professionals • Both cost-free, and also for-fee datasets from
commercial providers
• UN, EEA, World Bank, US Data.gov free datasets
already there, and more...
For Developers
• REST based API for all datasets • Software Development Kit on github
Enable new innovative applications and services (backed by SLA) Deliver better services at lower cost (*ratio)
‘Business’ Opportunity for Open Data in
the Cloud
Stimulate business and economic growth Industry and Citizen Engagement Enable business insight for Government workers Enable developers and citizens to easily consume Open Data and Big DataProduce – Upload – Consume (Open Data)
Export relational views from databases to create data feeds Create an Open Data Catalog by eg. OGDI Software Development Kit (SDK) Browse, visualize, create applications https://github.com/openlab/DataLab/wikimagayler@microsoft.com
www.azure.com/datamarket
https://github.com/openlab/DataLab/wiki
www.powerpivot.com
www.govdata.eu
www.microsoft.com/opengov
© 20011 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the
accuracy of any information provided after the date of this presentation.
City of Brampton, Canada
2 months to deploy Cloud: Cost Savings Mobile: Agile & Relevant
Engage Citizens
Connect with Community Analyze Resident Data
Improve Efficiency Faster Time-To Market Better Government
Open Data Catalogue Alberta, Canada
City of Medicine Hat
Cloud Catalogue built in ‘few days’ Minimal CAPEX Ultra‐low cost http://data.medicinehat.ca3 month to launch
Purchased Azure Windows 7 & VS 2010
Shared code with other customers
[screenshot]
City of Madrid‘s 245,000 Trees in the Cloud
• Sidewalk Trees: inventory in Windows Azure • ArboMap –Web 2.0 Citizen engagement • Tree health prevention
Open Government Data ‐ Visualization
Visuals, mashed‐up data, and map projection can help handle information overload
Open311 311 Citizen Call Center
City of San Francisco
Cloud Citizens can report and track non‐emergency incidents Open Data with the Cloud http://www.heygov.com/default.aspx?MapID=SanFran311systems—more services than the city could provide if it focused on presentation development rather than opening the data publicly through web services.
Government of Colombia Transparency
Government of Colombia
Cloud eGovernment Insight Accountability Open Government and e‐Government http://datos.gov.coThe Colombian Government, in order to contribute to