WICID (Web-based Interface to Census Interaction Data): A ...

WICID (Web-based Interface to Census Interaction Data): A ...

Web Access to Census Interaction Data John Stillwell and Oliver Duke-Williams Centre for Computational Geography University of Leeds, Leeds LS2 9JT Paper presented at XVI AESOP Congress, Track 6: Information Technology in Planning,

Volos, 10-15 July 2002 Focus The provision and development of a Census Interaction Data Service (CIDS) The development of a web-based information system (WICID) that allows researchers to extract data on interaction flows between origins and destinations

Presentation

The challenge: aims and objectives Census based interaction data sets Importance of interaction data in planning System architecture and metadata structure Features of the interface Some examples of data extraction Acknowledgements Funded by ESRC and JISC under the 2001

Census of Population Programme (Award number H507 255177) Began: 1 August 2001 Ends: 31 July 2006 Paul Boyle and Zhiqiang Feng, University of St Andrews The Challenge Aim is to increase the use of the OriginDestination (interaction) data sets that will

be produced as outputs from the 2001 UK Census (as well as the equivalent special migration and commuting data sets produced from 1991 and 1981 censuses) Objectives To provide users with access to existing census based interaction data sets (for 1991

and 1981) via the Internet To develop an user-friendly interface for query building and data extraction To develop a flexible system that allows new data sets (e.g. 2001 Census interaction data) to be added without any major system redesign Objectives

To allow users the option of constructing queries that involve the selection of origin and destination areas at different spatial scales To produce a library of popular sub-sets of interaction data for quick extraction and downloading To provide facilities to download the data in alternative formats

Interaction Data Sets for 1991 Original data sets SMS Set 1 (2 tables, 12 counts, wards) SMS Set 2 (12 tables, 93 counts, districts) SWS Set C (9 tables, 274 counts, wards) Table 100 (2 tables, 47 counts, districts) Derived data sets SMS Set 1 Tables 3-10 (adjusted by Rees and DukeWilliams) so-called SMSGAPS SMS Set 1 Table 3 (adjusted by Simpson and

Middleton) so called SMS-MIGPOP Interaction Data Sets for 1981 1981 SMS Set 2 (Male and female migrants between wards in 1991) 1981 SWS Set C (Five tables - 172 counts - of journey to work flows between wards in 1991) all re-estimated for 1991 ward geography by Boyle and Feng as part of a Census

Development Programme project Importance of interaction data in planning Interaction data sets are very important because they provide information on migration and commuting flows between small areas (wards) e.g. migration data used for population estimation and projection by central and local

government agencies e.g. commuting data used to define TTWAs and in transport planning System Architecture Metadata Structure

Features of the WICID Interface Login in screen WICID General Query screen WICID Area Selection Tools WICID List Area Selection Tool

WICID Data Selection Tools WICID Data Selection Options WICID Table Selection for 1991 SMS 2 WICID Variable Selection with Table 1 of 1991 SMS 2

WICID Data extraction WICID Output Planner WICID Output Previewer Some examples of data extraction: Query 1: Migrants from Greece to GB by age

Age profile of migrants from Greece, 1990-91 Migrants to GB from Greece, 1990-91 600 500 Male Female 400

300 200 100 0 1-4 5- 10- 16- 20- 25- 30- 35- 40- 45- 50- 55- 60- 65- 70- 75- 80- 85+ 10 14 19 24 29 34 39 44 49 54 59 64 69 74 79 84 5 Year age group

Source: 1991 Census Crown Copyright: ESRC/JISC Purchase Query 2: Migrants to districts in GB from Greece, 1990-91 Districts receiving most migrants from Greece, 1990-91

Forest Heath Westminster,City of Manchester Camden Kensington and Chelsea Haringey Glasgow City Wandsworth Birmingham

Barnet 182 152 91 84 81 80 51

50 49 48 Source: 1991 Census Crown Copyright: ESRC/JISC Purchase Social structure of Leeds and surrounding districts using 1991 SWS

Query: Journey to work flows between zones by social class, 1991 Social class structure of commuters in Leeds and between Leeds and surrounding districts, 1991 90000 80000 70000

60000 50000 40000 30000 20000 10000 0 I

II III (NM) III (M) IV

V Source: 1991 Census Crown Copyright: ESRC/JISC Purchase Proportions of commuters to Central Leeds from other wards and surrounding districts by social class, 1991 %of flow in class I 21

10.4 8.3 6.2 0 Source: 1991 Census Crown Copyright: ESRC/JISC Purchase Professional

% of flow in Class II 56.4 36.2 33.4 28.4 13 Managerial and Technical

% in class III (NM) 46.4 32.5 30 28.3 18 Source: 1991 Census

Crown Copyright: ESRC/JISC Purchase Skilled Non-manual % in class III (M) 24.1 15.3 12.8 11

1 Skilled Manual Source: 1991 Census Crown Copyright: ESRC/JISC Purchase Partly Skilled

% in class V 12.8 3.8 3 2.5 0 Unskilled

Conclusions/Next steps CIDS now up and running Flexible metadata structure of WICID will allow 2001 Census results to be included in the system WICID will be used to verify the 2001 data in 2003 Mapping option for geographical area selection now being developed

Analysis and modelling facilities intended but raises difficult questions

Recently Viewed Presentations

  • Introduction to Versioning - University of Virginia

    Introduction to Versioning - University of Virginia

    For Excel spreadsheets this would include writing down the steps taken in transforming the data, while advanced data tools (such as Open Refine, formerly Google Refine), often provide methods of exporting machine-readable data containing processing history.
  • Population and settlement Introduction Match up the words

    Population and settlement Introduction Match up the words

    ·Was the first European to explore and describe the Great Lakes, he formed relationships with local Aboriginal groups (Algonquin) and agreed to provide assistance in their wars against the Iroquois. ·1620: Louis XIII ordered him to administer the country (essentially...
  • English Language Teaching Methods What's New Under the Sun?

    English Language Teaching Methods What's New Under the Sun?

    grammar translation. method. Studied German using. audiolingual. method. Phase . II. Trained as an audio-lingual German. teacher. Began teaching . general grammar-based EFL and. English for Specific. Purposes (ESP) in Germany. Phase . III. First exposure to CLT. Early work...
  • WJEC English Language - King's Lynn Academy

    WJEC English Language - King's Lynn Academy

    Campaign Walkthrough. Unit 1 Reading is an exam mission, to be undertaken with military precision: At the start of the exam select your weapon of choice - you will need your highlighter to complete the mission.
  • Omb Uniform guidance - University of Missouri

    Omb Uniform guidance - University of Missouri

    Omb Uniform guidance. A DEEPER LOOK INTO THE CHANGES TO COME. Presented by: Susan Cessac, Manager of Cost Analysis Heather Dempsey, Senior Accountant - Cost Analysis University of Missouri System
  • Review of Saturated Hydrocarbons: - Chemeketa Community College

    Review of Saturated Hydrocarbons: - Chemeketa Community College

    Organic Chemistry's Golden Rule: Carbon must have a total of 4 bonds. Alkane names are based on the total number of carbons in the longest continuous chain: methane, ethane, propane, butane, pentane, hexane, heptane, octane, nonane, & decane. Any atom...
  • Expanding Ukraine's Exports under the GSP Program

    Expanding Ukraine's Exports under the GSP Program

    New Administration Trade Policy: EXPAND OUR GOODS AND SERVICES EXPORTS. ENFORCE U.S. TRADE LAWS. PROTECT U.S. INTELLECTUAL PROPERTY RIGHTS. ... Full description and list in Guidebook. GSP Program: Eligible Products. Ineligible. Most textiles & apparel. Watches.
  • Systems Software - T&T Software WWW Server

    Systems Software - T&T Software WWW Server

    Systems Software Unit 2 What is Software? Intangible A file Performs tasks / jobs A set of instruction Run/executed by the Central Processing Unit (CPU) Must be in the computer's memory to run Two Types of Software Systems Software Applications...