Today ONS updated the timetable for the publication of the 2011 Census flow data. These datasets relate to:
- Travel to Work (or study in Scotland)
- Second Residences
- Student migration
The next data to be published will be four Safeguarded migration tables including:
- OA to OA/country flow (counts)
- ward to ward flows by sex and age
These are expected to be available later this month, with the Secure tables coming in November and safeguarded tables in December.
All Safeguarded tables will be available in SASPAC and users will be able to download the System Files from the UKDS website directly (having registered and accepted the T&Cs).
All Secure flow tables will only be accessible to approved researchers via the ONS secure VML (Virtual Microdata Laboratory). SASPAC will be available in the VML to allow our users to integrate these datatsets.
More details on the flow data, including table layouts, can be found on the ONS website and details of SASPAC’s specialist OD training courses here.
We have recently developed more training videos. Please take a look on our page to view these great step-by-step videos now currently available.
The most recent videos added are:
Part B and
This module shows you how to work with origin-destination dataset sets including filtering the data, rezoning to asymmetric zones and outputting the data into either an Excel pivot table or into Mapshore.
ONS have recently announced further details on how to access the 2011 Origin-Destination (OD) datasets. The safeguarded tables are now expected to be released via the UK Data Service available in September. To support this, SASPAC have been working with ONS to make these tables available to download from the UK Data Service in a SASPAC format (.SYS). This means users will be able to: download the data from the UKDS, a software update from www.saspac.org and access these tables on their desktops. To prepare for the data, we would recommend registering for the UKDS now (open to academic/public sector users) and then signing up to the additional safeguarded t&cs when the data is published.
The SASPAC team have been working on the integrating the OD Public tables recently published. However, having raised some potential issues in the data with ONS, some corrected data was released yesterday (12/8/14) but there are still some outstanding issues – once we are confident in these datasets we will release these to our users.
A reminder that these public, safeguarded and secure OD data releases are just the priority tables and a lot more are due to be published in November/December this year.
Please take some time to view our video training page; the videos available are great step-by-step guides of how to carry out common tasks.
There are currently 7 videos available with the most recent videos added being modules 4a & 4b, these modules show:
Module 4a – Demonstrates how to create new zones – By individual area selection.
Module 4b – Demonstrates how to create new zones – By reference to a gazetteer.
Please take a look and keep an eye out for more videos becoming available soon!
Recent months have seen a number of datasets released by the Census Offices for England & Wales and Scotland, the SASPAC team have been busy processing and quality assuring this data and are now in a position to release a software update to users. SASPAC v9.90 incorporates all the data tables currently available including the most recent updates:
England & Wales
- 21 Workplace for Output Areas/workplace zones and larger geographies
- 10 Workday tables for Output Areas and larger geographies
- Supplementary Release 2: 3 DC and 8 LC tables (published on 23/5/14)
- 6 Armed Forces tables for LA*
- QS613EW – detailed Country of birth table for LAs
*published for a limited number of LAs due to disclosure control
- Release 3f: 16 Detailed & 8 Local Characteristic tables relating to health, housing, population and diversity)
Here is a list of all the tables and datasets currently available for E&W (.xls) and Scotland (.xls).
In addition, the SASPAC team have also Incorporated the ONS Mid-year population estimate data from 2001 to 2012 for Output and higher geographies in E&W.
Users will need to download a small update to upgrade to v9.90, instructions on how to this can be found in the following Release note (.pdf).
Following release 2B of the Scottish Census results from NRS, the SASPAC team is pleased to release a software update to our
users. This release incorporates all the Key (29) and Quick Statistic tables (32) currently available for Scottish Census geographies.
SASPAC v9.85 is available to download from the software page along with update instructions (.pdf). This release includes:
- access to all Key statistics (with percentage values) and Quick Statistics tables;
- new “year” and “country” filters to restrict data searching/selection to just Scottish tables;
- enhanced hierarchic geography trees that present 2011 Output Areas within Multi-member wards, Postcode sectors and Datazones (facilitates easy selection of “all the OAs within area X”).
All the necessary System files may also be downloaded from our data page.
The next Census release for Scotland is scheduled for 18 December and will include four Key and 27 Quick statistics tables relating to Living Arrangements (planned table layouts). Please note, we also expect to release an updated full installation package later in December 2013, this will update all previous versions of the application.
Please contact the helpdesk if you have any issue with this release or require any further details.
Following the release of the 2011 Census Detailed Characteristics tables for Middle Layer Super Output Area (MSOAs) and Census Merged Wards on 12 July, SASPAC v9.83 is now available and provides access to all these datasets tables. Software update files (7MB .zip) and instructions (.pdf) are downloadable from our website.
In addition, updated System files relating to these new tables are available to download from SASPAC’s data page or a link to just the Detailed Characteristics datasets (National to MSOA/ward geographies) can be downloaded here (640 MB .zip).
Finally, following user demand, the software’s CSV export function has now been enhanced to include cell-level metadata descriptions:
|SASPAC CSV output without metadata:
|SASPAC CSV output available with v9.83 with metadata:
Users may also be interested in saving version of the Census table layouts for all the datasets currently available:
Quick Statistics table layouts (22.07.13) (pdf)
Key Statistics table layouts (22.07.13) (.pdf)
Detailed Characteristics table layouts (22.07.13) (.pdf)
Commissioned table layouts (22.07.13) (.pdf)
As tables are released/updated these layouts will be updated on our support page.