Census update webinar:Census Geography Tools

James Crone

Webinar

24th July 2013

Welcome

An introduction…

James CroneUK Data Service

EDINA GeoServicesUniversity of Edinburgh

During the webinar today you will see examples of how online tools provided through Census Support can be used to:

search for and download digital boundary datasets

create shaded choropleth map visualizations of 2011 census data

make selections from ONS postcode directories and create custom lookups to geographies held by Census Support

Welcome

What is the UK Data Service?

• a comprehensive resource funded by the ESRC

• a single point of access to a wide range of secondary social science data

• support, training and guidance

Who is it for?

• academic researchers and students

• government analysts

• charities and foundations

• business consultants

• independent research centres

• think tanks

ukdataservice.ac.uk

What is Census Support?

• access to, and user support for, data from the last five UK population censuses (1971 – 2011)

• download of census data earlier than 2001 through Census Support is currently restricted to UK academic users.

census.ukdataservice.ac.uk

Poll

Have you used census data before?

• No

• Yes, for the UK

• Yes, for outside the UK

Quick Introduction to the Census and Census Data

What is a census?

“The total process of collecting, compiling, evaluating, analysing and publishing demographic, economic and social data pertaining at a specified time, to all persons in a country or well delimited parts of the country”

United Nations (1998)

Household census questions

• accommodation type – house or flat?

• own or rent?

• how many rooms?

Individual census questions

• male or female?

• age?

• country of birth?

• health?

What sort of output data is produced?

Digital Boundaries / Aggregate Data

Contains National Statistics data © Crown Copyright and database right 2012Contains Ordnance Survey data © Crown Copyright and database right 2012

Census Support Geography Tools

Boundary Data Selector: Select the boundary data you want, for the area you want, in the format you want.

Easy Download: The most regularly requested census boundaries available as ready-to-use national datasets in popular formats.

Thematic Mapper: Create choropleth thematic maps from your own uploaded CSV files.

Postcode Directory Download: Download complete versions of current and historical postcode directories.

Postcode Data Selector: Download subsets of the postcode data that you want from postcode directories released between 2001 and the present day.

GeoConvert: Geography matching and conversion tool.

Download digital boundaries using Census Support Boundary Data Selector

Census Support Boundary Data Selector

Features of Boundary Data Selector:

• Access to more than 400 boundary datasets held by Census Support

• As well as core census boundaries, a wide range of other geographies available

• Output datasets to various data formats

Using Census Support Boundary Data Selector

1. Search for and select boundary dataset to download from Census Support.

2. Take complete dataset or select only the features you need.

3. Pick output format to download boundary data in.

Boundary Data Selector Demo

Use Boundary Data Selector to search for and download 2011 Lower Layer Super Output Areas for Nottingham in KML format which we`ll then look at in Google Earth.

On with the DEMO!

The Choropleth Map – visualize small area aggregate (census) data

Contains National Statistics data © Crown Copyright and database right 2012Contains Ordnance Survey data © Crown Copyright and database right 2012

Proportion of people working more than 49 hours per week (2011 Census)

Thematic Mapper can be used to create choropleth maps from CSV census data.

Census Support Thematic Mapper

Features of Thematic Mapper:

• Create Choropleth maps from uploaded CSV file. No GIS required!

• Uses boundaries held by Census Support

• Wizard driven data-upload process

• Backdrop Ordnance Survey basemaps

• Maps can be exported to a shapefile for subsequent offline use

Thematic Mapper Demo -

Use Thematic Mapper to create a choropleth map of proportions of travel to work by tram for Nottingham as recorded in the 2011 Census (Aggregate 2011 Census Data downloaded from Census Support InFuse)

On with the

Demo!

Use Thematic Mapper to create a choropleth map of proportions of travel to work by tram for Nottingham as recorded in the 2011 Census (Aggregate 2011 Census Data downloaded from Census Support InFuse)

Poll

Which of these do you know for your home?

• Census 2011 Output Area Code

• Grid Reference

• Postcode

Georeferencing by Postcode

ONS Postcode Directory (ONSPD)

Different ways to write postcode

Postcode Metadata e.g. when introduced / retireda

PostcodeLocationa

Geographies (GeoIDs) which postcode located within including 2001/11 census

~ 2.5 Million Records in latest ONSPDLookups to 40 or so geographies.

Census Support Postcode Data Selector used to download postcode data

Slice up a postcode directory

Features of Postcode Data Selector

• Make selections from ONSPD`s

• Access to most quarterly updates of ONSPD released since 2001

• In addition add custom lookups to ANY geography held by UK Data Service Census Support as a boundary dataset.

Postcode Data Selector Demo

Use Postcode Data Selector to extract all postcodes within postcode sector NG9 1 with lookups to 2011/2001 Output Areas, 1991 Enumeration Districts (std fields) and 1981/1971 Enumeration Districts (custom Census Support look-ups)

On with the DEMO!

What we`ve seen today

Boundary Data Selector

Thematic Mapper

Postcode Data Selector

Census Support Help

ukdataservice.ac.uk/help