Slide 1
Slide 1 text
Dr Alex D Singleton
Spatial Analysis using the
School of Environmental Sciences
Spatial Analysis using the
National Pupil Database
Slide 2
Slide 2 text
Content
• Geographic referencing and the NPD
• Indicators and Geodemographics
• Catchment models
• Mapping and the Geoweb
• Mapping and the Geoweb
Slide 3
Slide 3 text
GEOGRAPHIC REFERENCING
Putting people and schools on the map...
% Level 4-5 Qualifications (2001 Census)
Slide 4
Slide 4 text
Households
Building Blocks
Pupils Postcodes
~15-25 addresses in a postcode
Slide 5
Slide 5 text
Building Blocks
• School locations
– Derived from postcode + Edubase
• Caveats
– Postcodes come from PLASC – state schools
– Postcodes come from PLASC – state schools
• Independent pupils lack spatial reference
– Spatial Resolution
• LSOA
• OA if you are nice to DfE!
Slide 6
Slide 6 text
No content
Slide 7
Slide 7 text
Min: 40 households &100 people
Slide 8
Slide 8 text
Min: 1,000 residents; 400 households. Av 1,500 residents
Slide 9
Slide 9 text
Min size of 5,000 residents, 2,000 households
Slide 10
Slide 10 text
Min size of 5,000 residents, 2,000 households
Slide 11
Slide 11 text
INDICATORS AND
GEODEMOGRAPHICS
Social and spatial characteristics
Output Area Classification
Slide 12
Slide 12 text
Indicators and Geodemographics
• Linked to NPD
– Composite Measures:
• Income Deprivation Affecting Children Index
– LSOA; Part of IMD
– LSOA; Part of IMD
• Geodemographics
– Output Area Classification (Output Area)
– ACORN (Postcode)
– Raw variables
• Council Tax bands; JSA etc... plus lots more..
Slide 13
Slide 13 text
No content
Slide 14
Slide 14 text
Example: GCSE Grade Profiles
2009 GCSE Grade A*
15
20
25
30
%
E
Wealthy Achievers
Hard Pressed
0
5
10
E
Entries
A*
Slide 15
Slide 15 text
Students Achieving 5 A*-C Grades
at GCSE in 2009
75%
35%
Slide 16
Slide 16 text
No content
Slide 17
Slide 17 text
Data Link
DCSF
HESA (0)
HESA (+1)
~20%
Direct Entry
Gap Year
Key Stage 5
HESA (+1)
HESA (+2)
Gap Year
Gap Years
National Targets = 18-30 Age Range
Slide 18
Slide 18 text
40
50
60
70
80
HE Progression Rate with 95% Confidence Intervals (%)
Wealthy Achievers Urban Prosperity Comfortably Off Moderate Means Hard Pressed
Inner City
Adversity
Asian
Communities
Home owning
Asian family areas
0
10
20
30
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
HE Progression Rate with 95% Confidence Intervals (%)
Low income, singles, small
rented flats
Low income, singles, small
rented flats
Flows – KS4
Slide 19
Slide 19 text
1.0
2.0
3.0
4.0
5.0
6.0
1A:Wealthy Executives
1B:Affluent Greys
1C:Flourishing Families
2A:Prosperous
Professionals
2B:Educated Urbanites
5A:Struggling Families
5B:Burdened Singles
5C:High-Rise Hardship
5D:Inner City Adversity
Subject Profiles
0.0
2B:Educated Urbanites
2C:Aspiring Singles
3A:Starting Out
3B:Secure Families
3C:Settled Suburbia
3D:Prudent Pensioners
4A:Asian Communities
4B:Post-Industrial Families
4C:Blue-Collar Roots
5A:Struggling Families
Medicine and Dentistry
Slide 20
Slide 20 text
2.0
4.0
6.0
8.0
10.0
12.0
14.0
1A:Wealthy Executives
1B:Affluent Greys
1C:Flourishing Families
2A:Prosperous
Professionals
2B:Educated Urbanites
5A:Struggling Families
5B:Burdened Singles
5C:High-Rise Hardship
5D:Inner City Adversity
Subject Profiles
0.0
2B:Educated Urbanites
2C:Aspiring Singles
3A:Starting Out
3B:Secure Families
3C:Settled Suburbia
3D:Prudent Pensioners
4A:Asian Communities
4B:Post-Industrial Families
4C:Blue-Collar Roots
5A:Struggling Families
Mathematical and Computer Sciences
Slide 21
Slide 21 text
Blue Collar Communities
Legend
Legend
20 students
50 students
100 students
200+ students
Slide 22
Slide 22 text
Prospering Suburbs
Legend
Legend
20 students
50 students
100 students
200+ students
Slide 23
Slide 23 text
CATCHMENT MODELS
Where can I go to school?
Catchment Map of E Leeds
Slide 24
Slide 24 text
http://www.udel.edu/johnmack/frec480/cholera/cholera2.html
Slide 25
Slide 25 text
No content
Slide 26
Slide 26 text
No content
Slide 27
Slide 27 text
No content
Slide 28
Slide 28 text
No content
Slide 29
Slide 29 text
No content
Slide 30
Slide 30 text
No content
Slide 31
Slide 31 text
No content
Slide 32
Slide 32 text
No content
Slide 33
Slide 33 text
No content
Slide 34
Slide 34 text
MAPPING AND THE GEOWEB
Profiling for the public
Target Schools for University Oxford
Slide 35
Slide 35 text
OpenStreetMap
Data
great_britain.osm
(.xml)
PostgreSQL DB
with PostGIS
osm2pgsql
NASA’s
SRTM
DEMs
GDAL Tools
UKBorders
English MSOAs
and Postcodes
PLASC/NPD
OAC
Shapefiles
ArcGIS
Color
Brewer
PerryGeo
Hillshading
OSM
Tiles
Tiles
PLASC/NPD
mySQL
DB
Schools Atlas
IDACI
OpenLayers (.js)
HEFCE POLAR
Mapnik
OSM Tiling
Script (.py)
Stylesheets(.x
ml)
AJAX
Requests
PVC
(.kml)
OAC R
Google
Chart API
Tiles
Chart
Cache
Slide 36
Slide 36 text
No content
Slide 37
Slide 37 text
No content
Slide 38
Slide 38 text
No content
Slide 39
Slide 39 text
No content
Slide 40
Slide 40 text
No content
Slide 41
Slide 41 text
No content
Slide 42
Slide 42 text
No content
Slide 43
Slide 43 text
No content
Slide 44
Slide 44 text
No content
Slide 45
Slide 45 text
No content
Slide 46
Slide 46 text
www.alex-singleton.com
www.alex-singleton.com