lg inform plus learning day training session

LG Inform PlusA series of screen images to

simulate the interactive Learning Days run during 2015

Tim Adams: Programme Managerrev: April 2015

Objectives for the session

• Explain the background and vision

• Demonstrate the new product

• Encourage you to use it:– to adopt the standards in your own organisation– for viewing prep-prepared material– tailoring and building your own material– sharing the information by a variety of channels

Agenda – 1 (the building blocks)

• Background / objectives / take-up

• The Landing Page

• Tools & content available

• Information Sharing Standards

• Context & performance reporting with drilldown

Agenda – 2 (Light touch use)

• Small Area Reporting - simple components

• Public small area reports

• Small area geographies

• Creating and using natural neighbourhoods

Agenda – 3 (Report authoring)

• Entering report edit mode

• Adding simple components

• Adding simple text narratives

• Adding fixed text tokens

• Adding relative text tokens

Agenda – 4 (Other tools)

• Direct data feed via an API – application programmable interface)

• Records retention guidance tool

• Powers & Duties guidance tool

• Open data tools

• Conclusions & other questions

Agenda – 1 (the building blocks)

• Background / objectives / take-up

• The Landing Page

• Tools & content available

• Information Sharing Standards

• Context & performance reporting with drilldown

Why have we done this?

• Severe financial pressures– Productivity through deconstruction of performance– More sophisticated techniques than the past

• Dismantling of previous infrastructures– the demise of the Audit Commission– sector move to self regulation & re-wiring public services– look at industry standards and methods– offer coordinated facilitation not an imposition

• Transparency Agenda– legislation advancing on public right of access to data– reduce freedom of information work loads– how do we make data transparent?

Information Management

• Based upon the esd-toolkit programme which first appeared in 2001

• Sector-led creation of information sharing standards to aid knowledge creation and data sharing

• Local Government Business Model sets out the semantics

• Open Data inventories, schemas and validation tools promote easier data publication

• Performance and context reporting tools• Direct data feed via an Application Interface (API)• Records management tools linked to legislation

@LGInformPlus

Self financing – subscriptions led

• Four subscriptions bands based upon organisation size:– Large Councils - £2260pa – Counties, large unitaries, mets– Medium Councils - £1450pa – Medium unitaries, mets– Small Councils - £735pa - Districts– Fire Authorities - £525pa

• This funds:– Online services and resources– Core small programme team and support service– Events and engagement– New developments– Information standards

@LGInformPlus

Agenda – 1 (the building blocks)

• Background / objectives / take-up

• The Landing Page

• Tools & content available

• Information Sharing Standards

• Context & performance reporting with drilldown

http://www.local.gov.uk/lginformplus

http://www.esd.org.uk

local.gov.uk/lginformplus

Agenda – 1 (the building blocks)

• Background / objectives / take-up

• The Landing Page

• Tools & content available

• Information Sharing Standards

• Context & performance reporting with drilldown

standards.esd.org.uk

esd-standards: http://standards.esd.org.uk

esd-standards: Functions List

esd-standards: Functions List

esd-standards: drill down to service

See links to other controlled lists

Metrics related to Functions

esd-standards: “care” related metrics

esd-standards: http://standards.esd.org.uk

esd-standards: links to available tools

Invoke LG Inform large area reporting

Invoke LG inform Plus small area report

Agenda – 1 (the building blocks)

• Background / objectives / take-up

• The Landing Page

• Tools & content available

• Information Sharing Standards

• Context & performance reporting with drilldown

local.gov.uk/lginform

Practice break. light small area metrics• Look at the standards pages and small area metric-

types• Try downloading the list into a spreadsheet

• Choose some of interest and look at what tools are available

• Create and download a map, chart or table, download it and (if you can) paste it into a MS Word document – REMEMBER TO SIGN IN

• Try an LG Inform report and see if you can drilldown – remember to choose a small area metric

Agenda – 2 (Light touch use)

• Small Area Reporting - simple components

• Public small area reports

• Small area geographies

• Creating and using natural neighbourhoods

reports.esd.org.uk

Public Access view (signed out)

Signed in view

Column Sort

collection makes predominance map

single metric makes intensity map

Very narrow & very tall

Practice break. More complex bars• Practise with any of the features we have covered

OR• Produce a sorted bar chart of vertical bars for the

top 30 wards in you area plotting obesity in adults against binge drinking in adults

• Is there a correlation? Are there any wards that break the trend?

• If you can place this component graphic into MS Word

Agenda – 2 (Light touch use)

• Small Area Reporting - simple components

• Public small area reports

• Small area geographies

• Creating and using natural neighbourhoods

Public Access view

Signed-in Access view

http://www.local.gov.uk/web/guest/health-and-wellbeing-boards/-/journal_content/56/10180/6111055/ARTICLE

Practice break. Public Reports• Practise with any of the features we have

covered

OR

• Find and view some public reports for your area of interest.

• Create a pdf version or a word version (via rft)

• Look at different areas or different wards

Agenda – 2 (Light touch use)

• Small Area Reporting - simple components

• Public small area reports

• Small area geographies

• Creating and using natural neighbourhoods

neighbourhoods.esd.org.uk

Let’s create a natural neighbourhood

• Council Area: BLACKPOOL

• Subject: Tourist Impact Areas

• Logic: All wards or output areas connecting with the beach area

Practice break. Neighbourhoods

• Practise with any of the features we have covered

OR

• Try creating a natural neighbourhood type and areas for your area.

Agenda – 3 (Report authoring)

• Entering report edit mode

• Adding simple components

• Adding simple text narratives

• Adding fixed text tokens

• Adding relative text tokens

Home page

cursor hover

Save

Stop edit

Add text

Add table

Add bar

Add pie

Add map

Add location map

STOP EDIT RETURNS TO “SAFE” MODE

ENTER “EDIT” MODE

Agenda – 3 (Report authoring)

• Entering report edit mode

• Adding simple components

• Adding simple text narratives

• Adding fixed text tokens

• Adding relative text tokens

Lets move legend to the left side

Practice break. Basic report creation

• Practise with any of the features we have covered

OR

• Start up a new report of your own.

• How about adding a bar chart of Life expectancy at birth for males and then for females?

• A pie chart of household tenure?

• A map of population by ward?

Agenda – 3 (Report authoring)

• Entering report edit mode

• Adding simple components

• Adding simple text narratives

• Adding fixed text tokens

• Adding relative text tokens

A simple text narrative

ABOUT THE AREAHere is a breakdown of Pendle giving the area, population size and gender split of each Ward. In terms of area, Pendle is ranked 6 out of the 12 Districts within the Lancashire County (the largest area has the highest ranking), and is ranked 7 out of all 18 Districts in North West.

The total area of Pendle District is 16,936 hectares. The Ward with the largest area is Boulsworth, representing 25.88% of the total area of the District.

The most densely populated Ward is Walverden with 55.80 persons per hectare, the least densely populated Ward is Higham and Pendleside with 0.60 persons per hectare.

@LGInformPlus

http://bit.ly/1FqNaAS

A simple text narrative with variables

ABOUT THE AREAHere is a breakdown of Pendle giving the area, population size and gender split of each Ward. In terms of area, Pendle is ranked 6 out of the 12 Districts within the Lancashire County (the largest area has the highest ranking), and is ranked 7 out of all 18 Districts in North West.

The total area of Pendle District is 16,936 hectares. The Ward with the largest area is Boulsworth, representing 25.88% of the total area of the District.

The most densely populated Ward is Walverden with 55.80 persons per hectare, the least densely populated Ward is Higham and Pendleside with 0.60 persons per hectare.

@LGInformPlus

http://bit.ly/1FqNaAS

A simple text narrative with variables

ABOUT THE AREAHere is a breakdown of Pendle giving the area, population size and gender split of each Ward. In terms of area, Pendle is ranked 6 out of the 12 Districts within the Lancashire County (the largest area has the highest ranking), and is ranked 7 out of all 18 Districts in North West.

The total area of Pendle District is 16,936 hectares. The Ward with the largest area is Boulsworth, representing 25.88% of the total area of the District.

The most densely populated Ward is Walverden with 55.80 persons per hectare, the least densely populated Ward is Higham and Pendleside with 0.60 persons per hectare.

@LGInformPlus

http://bit.ly/1FqNaAS

Types of text token

Default is wrong – we want number of districts in the county

NO! This is the lowest density !

Practice break. Text Tokens

• Practise with any of the features we have covered

OR

• Start up a new report of your own

OR

• Make a copy of the shared report and try creating text tokens

http://bit.ly/1FqNaAS

Agenda – 3 (Report authoring)

• Entering report edit mode

• Adding simple components

• Adding simple text narratives

• Adding fixed text tokens

• Adding relative text tokens

Practice break. Relative Text Tokens

• Try creating a simple report of one text component that using relative text tokens to show this sentence

• {child-area-short-label} is a child of {parent-area-short-label} is a child of {ancestor-1-short-label} is a child of {ancestor-2-short-label}

Text token

Agenda – 4 (Other tools)

• Direct data feed via an API – application programmable interface)

• Records retention guidance tool

• Powers & Duties guidance tool

• Open data tools

• Conclusions & other questions

LG Inform / LG Inform PlusThe technical environment

LA indicator data

Centrally gathered indicator data

esd-toolkitIntermediate

database

Indicator (validated

original and derived) data

Indicator data for validation

Other esd and 3rd party

licensed data

3rd party app

3rd party app

3rd party app

ONS

Open data

Open Linked Data

esd-standards

spend

projects

data.gov.uk

legislation.gov.ukOrdnance

Survey

Web Service methods

Ontology

Original data

Public data used by Inform

Data optimised for Inform

KHub desktop

inform App

Inform user

settings

KHub

Upload

Download

http://stark-fortress-7714.herokuapp.com/

http://stark-fortress-7714.herokuapp.com/

http://stark-fortress-7714.herokuapp.com/

api.esd.org.uk

All LA Typesin JSON (JavaScript Object Notation)

All MetricTypes

Agenda – 4 (Other tools)

• Direct data feed via an API – application programmable interface)

• Records retention guidance tool

• Powers & Duties guidance tool

• Open data tools

• Conclusions & other questions

esd-standards• www.esd.org.uk - standards

What is the retention guidance?

The records retention guidance is information that guides English councils on:•types of records that could be kept to comply with Section 12 of the Lord Chancellor’s Code of Practice on the management of records and to meet likely business needs•How long those records might be kept

Where can you find the guidance?

Full guidance

at http://retention.esd.org.uk/

or from the LG Inform Plus

home page at:

www.esd.org.uk

Records Retention

Where can you find the guidance?

For a single function or service

via esd standards

http://standards.esd.org.uk/

• Find the function or service you are interested in• Click on the ‘tools’ option• Choose the ‘records retention tool

Retention guidance• Looking at guidance online

• Downloading guidance to create your own schedule• Guidance as open data• Getting help

Retention guidance - filter

Retention guidance - search

Retention guidance - detail

Retention guidance - download

Retention guidance - data

Retention guidance - help

Agenda – 4 (Other tools)

• Direct data feed via an API – application programmable interface)

• Records retention guidance tool

• Powers & Duties guidance tool

• Open data tools

• Conclusions & other questions

What is ‘Powers and duties’?

Powers and duties is a list of the things which legislation either:•Requires a local authority to do (duty)•Allows a local authority to do (power)

The ‘powers and duties’ list was put together by esd in conjunction with Kent County Council legal services.

At present it only refers to primary legislation (Acts of Parliament) and generally not secondary legislation (Statutory Instruments or SIs)

Where can you find powers and duties?

List at: http://id.esd.org.uk/list/powersAndDuties

Full guidance

at http://retention.esd.org.uk/

or from the LG Inform Plus

home page at: www.esd.org.uk

Records Retention

Where can you find powers and duties?

For a single function or service

via esd standards

http://standards.esd.org.uk/

• Find the function or service you are interested in• Click on the ‘tools’ option• Choose the ‘Powers and duties’ tool

Powers and duties - filter

Powers and duties - search

Powers and duties - detail

Powers and duties - download

Powers and duties - data

Powers and duties - help

Agenda – 4 (Other tools)

• Direct data feed via an API – application programmable interface)

• Records retention guidance tool

• Powers & Duties guidance tool

• Open data tools

• Conclusions & other questions

Making local data useful• Councils need to be compare with one another

• Innovators need to build apps cost-effectively

Hence we offer standards for:

• what we call things• format of open data

@LGInformPlus

URIs - Uniform Resource Identifiers

Codes that give precise definitions of things, eg:

• http://id.esd.org.uk/service/860 – premises licence service

• http://opendatacommunities.org/id/unitary-authority/york York City Council

• http://statistics.data.gov.uk/id/statistical-geography/E06000014 York area - from ONS

These normally resolve to descriptions with properties that are human and machine readable

URIs resolved - service

standards.esd.org.uk

URIs resolved – local authorities

opendatacommunities.org

URIs resolved – statistical geographies

statistics.data.gov.uk

URIs resolved – natural neighbourhoods

neighbourhoods.esd.org.uk

Schemas defining data formats

• Inventory schema for a list of all open datasets published by one council

• Individual schemas for each dataset – indexed against the Service and Function lists

What the scheme sets out to do• Provide useful data – responding to common requests

• Keep it as simple as possible for councils• Enable data users to accurately interpret data and

aggregate it across councils

Hampshire

Durham

Sevenoaks

Leeds

Craven

Westminster

Any council

The inventory schema

• Automatically harvested by data.gov.uk in beta

• Automatically output by DataShare DKAN and CKAN may follow

• Can be uploaded to and validated by esd-toolkit• Indexes datasets and their schemas against functions and

services

Inventory

Dataset Documents

ODF, PDF, HTML

Data

CSV, XML, ...

Dataset Documents

ODF, PDF , HTML

Data

CSV, XML, ...

inventory.esd.org.uk

Dataset schemas• Define the structure of data for a service or

function (group of services)

• Shared to allow (not mandate) consistency – share yours!

• Some validated schemas encouraged

• Formats:– Tabular: DataShare definitions and CSV validation files as

used by the ODI’s csvlint.io– XML– Linked data profiles

opendata.esd.org.uk

Agenda – 4 (Other tools)

• Direct data feed via an API – application programmable interface)

• Records retention guidance tool

• Powers & Duties guidance tool

• Open data tools

• Conclusions & other questions

LG Inform is……..

• ‘The LGA’s free data service which presents you with up-to-date published data about your local area and the performance of your council.

• Whether you’re interested in scrutiny, a portfolio area or simply need an overview, LG Inform can help you review and compare performance with other authorities’.

Key Information – LG Inform

• About us: www.local.gov.uk/about-lginform

• LG Inform: www.lginform.local.gov.uk

• Help and support: – Log-in assistance: lginform@esd.org.uk– Support: lginform@esd.org.uk– General enquiries: LGInform@local.gov.uk

• LG Inform Knowledge Hub Group– https://knowledgehub.local.gov.uk/group/lginform

The carousel displays up to datenews stories from the LGA