open data, open opportunities


Presentation Description

Paul Davidson, Chief Information Officer at Sedgemoor District Council and Director of Standards for the Local e-Government Standards Body (LeGSB)


Presentation Transcript

Open Data, Open Opportunities?:

Open Data, Open Opportunities? Paul Davidson, CIO Sedgemoor District Council and Director of Standards of the Local e-Government Standards Body (LeGSB)

Points of view ...:

Sedgemoor District Council We have your data, how would you like it? Local e-Government Standards Body (LeGSB) Mission to promote eStandards that support Efficiency, Transformation, and Transparency of Local Services Semantics, Syntax, Data Quality, Rights, Authentication, Transport, Governance Cabinet-Office CTO Council Cross Government Enterprise Architecture, and Domains UK eGIF (now Standards and Architecture Framework), eGMS, PSIA UK Govt. Infrastructure Strategy UK Location Council Interoperability Working Group Linked Data Working Group Transparency Strategy Standards Group With COI, OPSI European Interoperability Architecture Working Group Trusted Information Exchange Group Points of view ...

Re-using information from other sources:

3 Re-using information from other sources Disciplines of Operational Data Handling and Integration Public Data Publishing Knowledge Management Statistics, Analytics and Insight

Themes for eStandards:

Themes for eStandards Draft Public Sector Information Architecture

Public Data / Open Data:

Public Data / Open Data Public Data "Public Data" is the objective, factual, non-personal data on which public services run and are assessed, and on which policy decisions are based, or which is collected or generated in the course of public service delivery. ” Working definition of “Public Data at What do we mean by Open Data? licensing it for re-use making it available in a machine-readable form.

Public Data Principles at

Public Data Principles at Public data policy and practice will be clearly driven by the public and businesses who want and use the data, including what data is released when and in what form – and in addition to the legal Right To Data itself this overriding principle should apply to the implementation of all the other principles. Public data will be published in reusable, machine-readable form – publication alone is only part of transparency – the data needs to be reusable, and to make it reusable it needs to be machine-readable. At the moment a lot of Government information is locked into PDFs or other unprocessable formats. Public data will be released under the same open licence which enables free reuse, including commercial reuse – all data should be under the same easy to understand licence. Data released under the Freedom of Information Act or the new Right to Data should be automatically released under that licence. Public data will be available and easy to find through a single easy to use online access point ( – the public sector has a myriad of different websites, and search does not work well across them. It’s important to have a well-known single point where people can find the data. Public data will be published using open standards, and following relevant recommendations of the World Wide Web Consortium. Open, standardised formats are essential. However to increase reusability and the ability to compare data it also means openness and standardisation of the content as well as the format. Public data underlying the Government’s own websites will be published in reusable form for others to use – anything published on Government websites should be available as data for others to reuse. Public bodies should not require people to come to their websites to obtain information. Public data will be timely and fine grained – Data will be released as quickly as possible after its collection and in as fine a detail as is possible. Speed may mean that the first release may have inaccuracies; more accurate versions will be released when available. Release data quickly, and then re-publish it in linked data form – Linked data standards allow the most powerful and easiest re-use of data. However most existing internal public sector data is not in linked data form. Rather than delay any release of the data, our recommendation is to release it ‘as is’ as soon as possible, and then work to convert it to a better format. Public data will be freely available to use in any lawful way – raw public data should be available without registration , although for API-based services a developer key may be needed. Applications should be able to use the data in any lawful way without having to inform or obtain the permission of the public body concerned. Public bodies should actively encourage the re-use of their public data – in addition to publishing the data itself, public bodies should provide information and support to enable it to be reused easily and effectively. The Government should also encourage and assist those using public data to share knowledge and applications, and should work with business to help grow new, innovative uses of data and to generate economic benefit. Public bodies should maintain and publish inventories of their data holdings – accurate and up-to-date records of data collected and held, including their format, accuracy and availability.

Making data meaningful?:

Making data meaningful? Spending on maintaining the roads has more meaning when you know the length of roads in the council area, and perhaps the number of road surface related traffic accidents in the area. Spending on Schools has more meaning when you know the number of school age children and the exam pass rates. You may want to find those councils that spend a lot more or less than their neighbours on a particular type of product You might find a pattern between the spending on a certain type of product and the political control of a council.

An Open Licence?:

An Open Licence?


Syntax? For Humans Web pages ( e.g. HTML ) Documents ( e.g. PDF, RTF ) For Download and Manipulation Tabular ( e.g. csv ) Geographical ( e.g. KML ) For Machines For Applications ( e.g. XML ) Linked Data ( e.g. RDF, OWL, URIs ... ) Over the Web ( e.g. Web Services, APIs ) Adapted by LG Group from diagram produced by Ian Painter, Snowflake

Slide 10:

10 Applying Frameworks to local standards See

Defining formats for the local sector:

Defining formats for the local sector Guidance on how to publish data sets from the LGA and the LG Group.

... for instance ...:

... for instance ...

Payments to suppliers for Goods and Services :

Payments to suppliers for Goods and Services

Aggregating and Querying:

Aggregating and Querying

Bristol C.C. Air Quality Data:

Bristol C.C. Air Quality Data Do we need Ontology to turn linkable data into ‘Linked Data’?

Measured at?:

Measured at? Do we need Ontology to turn linkable data into ‘Linked Data’?

As Linked Data?:

As Linked Data? With BCC, Defra, Ordnance Survey,

... so what ...:

... so what ... Viewing Provide an HTML view of the data with click-able links to definitions from the Ontology, and identifiers. Shows the map points Can have custom layout in html using xslt Can slice the data via an API Call Combining Can combine data with other Air Quality Data from other sources using the same Ontology Can combine with demographics, health incident statistics, traffic counts, carbon emissions etc Defining Threshold levels of air quality and health consequences Pollutants Linking For a given point, location what are the administrative geographies What air quality measuring points are within a radius / box

Reducing Data Burdens at RBWM:

Reducing Data Burdens at RBWM With, Unit4, Capita, Civica, Royal Borough of Windsor and Maidenhead Data Burdens and the Single Transparent List Efficient Reduced time spent by each Local Authority in preparing financial returns, and coping with annual changes to reporting requirements from CLG. Existing Financial systems can be developed to provide an extract, mapped to the SERCOP headings, in Linked Data form. No further manual data preparation would be necessary by accountants at a Local Authority As the requirements for financial returns are altered, from year to year, changes are applied by CLG rather than at each Local Authority as at present. Substantial reduction in the time to prepare returns which is typically a 3 week activity each year from each Local Authority. Transparent Meaningful and comparable data provided to the public in a re-useable form. A simple spreadsheet approach can be taken to publishing all council’s budgets, and actual to data, aggregated to SERCOP headings. A web interface can be provided to support portals and apps etc which want to incorporate local financial data into their service. Links to other data sets that provide context to financial data can be associated with certain SERCOP headings leading to meaningful comparisons.

For Policy and Decision Making:

For Policy and Decision Making Standards (and Linked-Data) can help improve partnership working, and achieve efficiency savings - primarily through the ability to acquire and share data more easily and efficiently. Index of Multiple Deprivation Triple Store Opportunity to blend with other sources, say Housing or local economies. using crowd-sourced information alongside the official evidence-base. central to the success of policies such as Right-to-Reclaim underused land or building assets, where local insight and opinion is implortant

Legsb The Local e-Government Standards Body:

Legsb The Local e-Government Standards Body

authorStream Live Help