• Education

The Area Profiler

Kadhem JallabHead of TWRI

November 2009

• TWRI: sub-regional Research unit working on behalf of the Cities of Newcastle Upon Tyne and Sunderland and the Metropolitan Boroughs of Gateshead, North and South Tyneside

• Identified requirements of its 5 districts to access and share broad range of spatially referenced indicator data

BACKGROUND

• Need for a data warehousing solution emerged in 2001.

• undertook unsuccessful search to find an affordable commercial off-the-shelf GIS solution

– In house development infeasible as required extensive resources and in-depth experience

– Contracting out considered to be an expensive option

BACKGROUND

DATA WAREHOUSE

• The Data Warehouse was established specifically :

- data cleansing

- To make data available in consistent way

- To support various Policy Work

• datasets collected over time to cover all five Districts

– Demographics

– Economic

– Crime, Fire, Ambulance, Probation ...

– Drugs

– Social (including Index of Deprivation)

– Health

DATA WAREHOUSE

SUMMARY SPECIFICATION

• Web-based to reach large number of users

• Ability to personalise content securely for different user types

• Capability to produce custom tables and summary profiles with local, regional & national comparisons for one or more selected areas

SUMMARY SPECIFICATION

• Selection by various methods inc. maps

• Provide direct access to raw data via export

• visualisation of spatial patterns and hot spots

• Ability to rapidly explore multiple scenarios

Phase 1: Pilot (TWAP)

Development divided into 2 phases:

• A standalone, desktop-based prototype was developed using external contractors

• Limited specifications to enable testing

• Used to explore requirements in more detail

Phase 2: Web enabled AreaProfiler

• Production of new off-the-shelf product, AreaProfiler

• Now fully operational and hosted at North Tyneside Council

• System Administration by TWRI staff

THE DATA FLOW PROCESS

Address basedData

Cleansing process AreaProfiler

data warehouse

Web applicationSecure, multi-

user environment

DATA AVAILABLE NOW

• Total over 200 Variables

• Geographies

- Districts, 2004 Wards, Output Areas,

Super OAs, special geographies

• Census 2001

• Economic, Demographic, Social

• Crime, Fire Incidents, Probation Services

• Index of Deprivation 2007

FUTURE DATA

• LAA Indicators

• Every Child Matters

• Social Services

• +++

AREAPROFILER VERSION 2

Additional functionality to version 1

• Addition of SVG functionality

• Improved mapping and charting capability

• Addition of (static) point data

• Improved administrative functionality (edit / delete indicators)

• Addition of street / postcode search

CURRENT USERS

• Education

• Social Services

• Regeneration

• Planning

• Housing

• Environmental/Neighbourhood Services

• Community safety

• External funding

CURRENT USES OF AP

• Performance Monitoring

• Policy Development

• Service Planning

• Targets Bidding Applications

• Bench Marking

• Information Sharing

OTHER USES

• Informing locality planning

• Area children’s strategy groups

• For reference

• Answering specific area data queries

• For NRF areas and for Area Planning

• Extract of data for proof of concept

PRE-SET PROFILE(S)• Economic

• Education

• Crime

• Housing

• Social

PRE-SET PROFILE EXAMPLE

OTHER GEOGRAPHICAL UNITS

• Individual communities

• Neighbourhoods

• Pre-set areas used by Councils

• Police Beats

• Neighbourhood Renewal Areas

PARTNERS

• Other organisations have shown an interest in using Area Profiler

- Durham Observatory

- Tyne & Wear Fire

- Northumbria Police

FUTURE ENHANCEMENTS TO AP2

• Point Data

• Aerial Photography

• Online User Guide

Web Site:www.twri.org.uk

E-mail:twri@twri.org.uk