internet access to census migration and journey-to-work data john stillwell and oliver duke-williams...

Internet Internet Access to Access to Census Census

Migration and Migration and Journey-to-Journey-to-Work DataWork Data

John Stillwell and Oliver Duke-WilliamsJohn Stillwell and Oliver Duke-WilliamsCentre for Computational GeographyCentre for Computational Geography

University of Leeds, Leeds LS2 9JTUniversity of Leeds, Leeds LS2 9JT

Paper presented at the 32Paper presented at the 32ndnd Annual Conference Annual Conference

of the Regional Science Association International of the Regional Science Association International

British and Irish Section (Session on Migration British and Irish Section (Session on Migration Analysis)Analysis)

Dudley Hotel, Brighton and Hove, 21-23 August 2002Dudley Hotel, Brighton and Hove, 21-23 August 2002

FocusFocus

• The provision and development of a The provision and development of a Census Interaction Data Service (CIDS) Census Interaction Data Service (CIDS)

• The development of a web-based The development of a web-based information system (WICID) that allows information system (WICID) that allows researchers to extract data on researchers to extract data on interaction flows between sets of interaction flows between sets of origins and destinationsorigins and destinations

PresentationPresentation• The challenge: aims and objectivesThe challenge: aims and objectives

• Census-based interaction data setsCensus-based interaction data sets

• System architecture System architecture

• Metadata structureMetadata structure

• Features of the interfaceFeatures of the interface

• Some examples of data extraction and Some examples of data extraction and analysisanalysis

• Conclusions - next stepsConclusions - next steps

AcknowledgementsAcknowledgements• Funded by ESRC and JISC under the 2001 Funded by ESRC and JISC under the 2001

Census of Population Programme Census of Population Programme

(Award number H507 255177)(Award number H507 255177)

• Began: 1 August 2001Began: 1 August 2001

• Ends: 31 July 2006Ends: 31 July 2006

• Paul Boyle and Zhiqiang Feng, St Paul Boyle and Zhiqiang Feng, St AndrewsAndrews

The ChallengeThe Challenge

• To increase the use of the Origin-To increase the use of the Origin-Destination (interaction) data sets Destination (interaction) data sets that will be produced as outputs that will be produced as outputs from the 2001 UK Census from the 2001 UK Census

(as well as the equivalent special (as well as the equivalent special migration and commuting data sets migration and commuting data sets produced from 1991 and 1981 produced from 1991 and 1981 Censuses)Censuses)

Objectives Objectives • To provide users with access to existing To provide users with access to existing

census based interaction data sets (for census based interaction data sets (for 1991 and 1981) via the Internet1991 and 1981) via the Internet

• To maintain and develop an ‘user-friendly’ To maintain and develop an ‘user-friendly’ interface for query building and data interface for query building and data extractionextraction

• To develop a flexible system that allows To develop a flexible system that allows new data sets (e.g. 2001 Census new data sets (e.g. 2001 Census interaction data) to be added without any interaction data) to be added without any major system redesign major system redesign

Objectives Objectives

• To allow users the option of To allow users the option of constructing queries that involve the constructing queries that involve the selection of origin and destination areas selection of origin and destination areas at different spatial scales at different spatial scales

• To produce a library of popular sub-sets To produce a library of popular sub-sets of interaction data for quick extraction of interaction data for quick extraction and downloadingand downloading

• To provide facilities to download the To provide facilities to download the data in alternative formatsdata in alternative formats

Interaction Data Sets for Interaction Data Sets for 19911991Original data setsOriginal data sets

• SMS Set 1 (2 tables, 12 counts, wards)SMS Set 1 (2 tables, 12 counts, wards)

• SMS Set 2 (12 tables, 93 counts, districts)SMS Set 2 (12 tables, 93 counts, districts)

• SWS Set C (9 tables, 274 counts, wards)SWS Set C (9 tables, 274 counts, wards)

• Table 100 (2 tables, 47 counts, districts)Table 100 (2 tables, 47 counts, districts)

Derived data setsDerived data sets

• SMS Set 1 Tables 3-10 (adjusted by Rees and SMS Set 1 Tables 3-10 (adjusted by Rees and Duke-Williams) so-called SMSGAPSDuke-Williams) so-called SMSGAPS

• SMS Set 1 Table 3 (adjusted by Simpson and SMS Set 1 Table 3 (adjusted by Simpson and Middleton) so called SMS-MIGPOPMiddleton) so called SMS-MIGPOP

Interaction Data Sets for Interaction Data Sets for 19811981• 1981 SMS Set 2 (Male and female 1981 SMS Set 2 (Male and female

migrants between wards in 1991)migrants between wards in 1991)

• 1981 SWS Set C (Five tables - 172 1981 SWS Set C (Five tables - 172 counts - of journey to work flows counts - of journey to work flows between wards in 1991)between wards in 1991)

• all re-estimated for 1991 ward all re-estimated for 1991 ward geography by Boyle and Feng as part of geography by Boyle and Feng as part of a Census Development Programme a Census Development Programme projectproject

System ArchitectureSystem Architecture

MetadataMetadataStructureStructure

CIDS HomepageCIDS Homepage

Features of the WICID Features of the WICID InterfaceInterface

Login in screenLogin in screen

General Query ScreenGeneral Query Screen

Area Selection ToolsArea Selection Tools

List Area Selection ToolList Area Selection Tool

Data Selection ToolsData Selection Tools

Data Selection OptionsData Selection Options

Table Selection for 1991 SMS 2Table Selection for 1991 SMS 2

Variable Selection with Table 4 of the 1991 SMS 2

Variable Selection with Table 4 of the 1991 SMS 2

Off the shelf facilityOff the shelf facility

Data extractionData extraction

WICID Output PlannerWICID Output Planner

WICID Output PreviewerWICID Output Previewer

Some examples of data Some examples of data extractionextraction

What were theWhat were the migrant flows to migrant flows to Brighton from elsewhere in 1990-91?Brighton from elsewhere in 1990-91?

Need to designa set of zonesthat are suitable:- districts in Sussex- counties in SE- other GB regions- NI and Eire- overseas

Query: Extraction of SMS data on migration to Brighton, 1990-91

Query: Extraction of SMS data on migration to Brighton, 1990-91

Source: 1991 CensusCrown Copyright: ESRC/JISC Purchase

Migration flows to Brighton, 1990-91Migration flows to Brighton, 1990-91 North 52 Hampshire 177

Yorkshire and Humberside 160 Hertfordshire 68East Midlands 151 Isle Of Wight 19East Anglia 118 Kent 149South West 294 Oxfordshire 70West Midlands 176 Surrey 198North West 174Wales 111 Eastbourne 74Scotland 99 Hastings 39Northern Ireland 16 Hove 1609

Lewes 433Irish Republic 56 Rother 21Total inflow from overseas 1643 Wealden 87

Adur 139Inner London 611 Arun 76Outer London 532 Chichester 28Bedfordshire 33 Crawley 102Berkshire 81 Horsham 90Buckinghamshire 48 Mid Sussex 231Essex 106 Worthing 101

Query: SMS data on age-specific migration to Brighton from rest of GB and from overseas, 1990-91

Query: SMS data on age-specific migration to Brighton from rest of GB and from overseas, 1990-91

0

500

1000

1500

2000

2500

Age group

Nu

mb

er o

f in

-mig

ran

ts

Inflows from GB

Inflows from overseas

Age profiles of in-migrants to Brighton from rest of GB and from overseas, 1990-91

Age profiles of in-migrants to Brighton from rest of GB and from overseas, 1990-91

Query: Students aged 19-21 Query: Students aged 19-21 with term-time residence in with term-time residence in Sussex and usual residence Sussex and usual residence

by countyby county

Query: Students aged 19-21 Query: Students aged 19-21 with term-time residence in with term-time residence in Sussex and usual residence Sussex and usual residence

by countyby county

Source: 1991 Census Crown Copyright: ESRC/JISC Purchase

Main county origins with term-time addresses in Sussex

Main county origins with term-time addresses in Sussex

Source: 1991 Census Crown Copyright: ESRC/JISC Purchase

Main county destinations of students with term-time address outside Sussex

Main county destinations of students with term-time address outside Sussex

Query: Migration flows in life course ages for DTLR modelling system

Query: Migration flows in life course ages for DTLR modelling system

Spatial Interaction Modelling

dDOBAM ijjijiij

Power function model:

Exponential function model:

eDOBAM ijjijiij

d

Intra-area flows included Intra-area flows excludedAge Power Exponential Mean mig Power Exponential Mean mig

group parameter parameter distance parameter parameter distance

1-14 2.66 0.045 45.1 1.47 0.011 122.415-19 2.56 0.040 51.4 1.41 0.011 129.120-24 2.33 0.034 53.0 1.24 0.010 116.925-29 2.48 0.041 45.8 1.46 0.013 98.230-44 2.49 0.039 49.6 1.50 0.012 110.945-59 2.61 0.041 51.1 1.66 0.013 119.760+ 2.83 0.049 45.8 1.71 0.013 121.6

Decay parameters and mean migration distances

Parameters and MMLs for matrices that exclude intra-area flows

Parameters and MMLs for matrices that include intra-area flows

0

0.5

1

1.5

2

2.5

3

1-14

15-1

9

20-2

4

25-2

9

30-4

4

45-5

9

60+

Age

Gen

eral

ized

par

amte

r

0

20

40

60

80

100

120

140

Dis

tan

ce (

km)

Decay parameterMean migration length

0

0.5

1

1.5

2

2.5

3

1-14

15-1

9

20-2

4

25-2

9

30-4

4

45-5

9

60+

Age

Gen

eral

ized

par

amte

r

0

20

40

60

80

100

120

140

Dis

tan

ce (

km)

Decay parameterMean migration length

Social structure of Leeds and surrounding districts using 1991

SWS

Social structure of Leeds and surrounding districts using 1991

SWS

Query: Journey to work flows Query: Journey to work flows between zones by social class, between zones by social class,

19911991

0

10000

20000

30000

40000

50000

60000

70000

80000

90000

I II III (NM) III (M) IV V

Social class structure of commuters in Leeds and between Leeds and surrounding

districts, 1991

Social class structure of commuters in Leeds and between Leeds and surrounding

districts, 1991

Source: 1991 Census Crown Copyright: ESRC/JISC Purchase

% of flow in Class II

56.436.233.428.413

%of flow in class I

2110.4

8.36.20

Source: 1991 Census Crown Copyright: ESRC/JISC Purchase

Proportions of commuters to Central Leeds from other wards and surrounding districts by social class, 1991

Proportions of commuters to Central Leeds from other wards and surrounding districts by social class, 1991

Professional

Managerial and Technical

% in class III (M)

24.115.312.811

1

% in class III (NM)

46.432.53028.318

Source: 1991 Census Crown Copyright: ESRC/JISC Purchase

Skilled Non-manual

Skilled Manual

% in class V

12.83.832.50

Source: 1991 Census Crown Copyright: ESRC/JISC Purchase

Partly Skilled

Unskilled

Conclusions/Next stepsConclusions/Next steps• CIDS now up and running CIDS now up and running

• Flexible metadata structure of WICID will Flexible metadata structure of WICID will allow 2001 Census results to be included in allow 2001 Census results to be included in the systemthe system

• WICID will be used to verify the 2001 data in WICID will be used to verify the 2001 data in 20032003

• Mapping option for geographical area Mapping option for geographical area selection now being developedselection now being developed

• Analysis and modelling facilities intended Analysis and modelling facilities intended but raise difficult questionsbut raise difficult questions