Visualising Plymouth's Neighbourhood Data

Visualising Plymouth’s Neighbourhood Data : 

Visualising Plymouth’s Neighbourhood Data Adam Fleet Awais Raza

Summary : 

Summary Background Data Procurement Data Visualisation Profile Design Profile Use

Background: Locality and Neighbourhood Working : 

Background: Locality and Neighbourhood Working Developed by the Plymouth 2020 Partnership Aimed at improving Service delivery Accountability Engagement Neighbourhood Profiles needed to Identify critical issues Public and Service Provider perspectives Based around the priorities for Local Area Agreement

Background:Strengths & Weaknesses : 

Background:Strengths & Weaknesses 43 Natural Neighbourhoods Non standard area of geography Does not fit in with National geographies Partners already providing data at Neighbourhood level Police Primary Care Trust Education Areas for development Housing Economy Environment Transport

Background: Current Practices in Plymouth : 

Background: Current Practices in Plymouth Profiling developed thematically Health, Crime, Education No holistic picture of Plymouth Lack of consistency Appearance Data used Duplication of effort Over reliance on Census data Lack of Plymouth 2020 Partnership branding Labour intensive Difficult to refresh

Background: What’s been done elsewhere… : 

Background: What’s been done elsewhere… Government Office South West Holistic Plymouth LA Profile Examples of other work Association of Public Health Observatories LBO Hammersmith & Fulham Leicestershire County Council Swindon Borough Council Sheffield Primary Care Trust Census data MOSAIC

Background: Our idea… : 

Background: Our idea… Use local data Census rumours Audit Commission Quality of Life indicators One profile for all audiences Public, practioners, councillors etc Easy to understand Sustainable Act as a prompt only

Slide 9: 

Map of Neighbourhood Scorecard (Value vs City vs Region vs Nation) Health Life Expectancy Crime Burglary Rates Education KS2/KS4 Results Environment Missed bins Economy/Worklessness Employment rates Basic facts Population Housing types …

Procurement of Data:Condition of Neighbourhood Data : 

Procurement of Data:Condition of Neighbourhood Data Postcode lookup table Lack of consistency No formal documentation Sporadically produced Household and Dwelling estimates Qualitative data How can this be used Some areas not working at a Neighbourhood level Litter & Detritus

Procurement of Data:Local Data : 

Procurement of Data:Local Data GP Register Data 95% House Prices – Land Registry 18,000 < £250 Local Priorities “Consultation” Services GP Surgeries – NHS Choices Children’s Centres Community Facilities

Procurement of Data:Data procurement problems : 

Procurement of Data:Data procurement problems Raw data aggregated to Neighbourhood level Postcode Lookup Table System reporting designed for specific purpose Unable to extract raw data Data cleansing! Data only available at National level of Geography Jobcentre Plus

Data Visualisation:Overview : 

Data Visualisation:Overview Data Visualising Master-class WOW! How do we visualise data in Plymouth? Not a focus Limited by Technology - Excel Resources Lack of co-ordination Lack of skills/awareness

Data Visualisation:Plymouth : 

Data Visualisation:Plymouth

Data Visualisation:Plymouth : 

Data Visualisation:Plymouth

Data Visualisation:Plymouth : 

Data Visualisation:Plymouth

Data Visualisation:Plymouth : 

Data Visualisation:Plymouth

Slide 23: 

North Prospect Glenholt

Slide 24: 

North Prospect

Slide 25: 

Glenholt

Profile Design:Neighbourhood Scorecard : 

Profile Design:Neighbourhood Scorecard Bring together thematic indicators Based on Local Area Agreement Priorities Features to include Trend over the last few years Neighbourhood Value Rank against other Neighbourhoods City Average Regional Average National Average

Profile Design:Existing Scorecards : 

Profile Design:Existing Scorecards

Profile Design:Neighbourhood Scorecard Design : 

Profile Design:Neighbourhood Scorecard Design

Profile Design:Neighbourhood Scorecard Design : 

Profile Design:Neighbourhood Scorecard Design

Profile Design:Neighbourhood Scorecard Design : 

Profile Design:Neighbourhood Scorecard Design

Profile Design:Outputs : 

Profile Design:Outputs Documentation and semi automation Postcode Lookup table < 5 working days LSOA to Neighbourhood Lookup table < 5 working days Wetted the appetite for Local data Broadband Connectivity and Internet Access Virgin Media and BT Business Startups Gloucester Banksearch-Consultancy Black and Minority Ethnic Population BME Population of North Somerset Local Priorities

Profile Design:Scorecard Summary Table : 

Profile Design:Scorecard Summary Table Assign each indicator a standardised score between 0-100 Simple method of comparison of performance against local priorities Not intended to mimic the Indices of Multiple Deprivation Contentious issue with Partners about its purpose

Profile Design:Neighbourhood Comparison : 

Profile Design:Neighbourhood Comparison

Profile Design:Neighbourhood Comparison : 

Profile Design:Neighbourhood Comparison

Profile Use : 

Profile Use Underpinning Locality Working Police beat officers & Health visitors Regeneration team reallocated Neighbourhood Managers Plymouth Emergency Evacuation Plan “Short Sermon” Strategic Housing Survey

Thank you : 

Thank you For further information please feel free to contact; Patrick Hartop (patrick.hartop@plymouth.gov.uk) Adam Fleet (adam.fleet@plymouth.gov.uk)