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
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
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
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.
·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...
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...
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.
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...
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 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...
Ready to download the document? Go ahead and hit continue!