saspac 2011 and beyond - burisa conference 13.05.11
DESCRIPTION
SASPAC presented at the Census 2011 Beyond conference on 13th May 2011.TRANSCRIPT
2011 and BeyondAlan LewisSASPAC Project OfficerIntelligence UnitGreater London Authority
BURISA – Census 2011 and Beyond: Essential User Guide13th May 2011
Overview
What is SASPAC?
Who uses it and why?
What SASPAC users want in 2011
SASPAC’s 2011 preparations
2011 and beyond?
What is SASPAC?
Software application to interrogate and access Census data
Owned by the Local Government Association
Managed/developed on behalf of LGA and users by the Greater London Authority (GLA)
“Not for Profit” - owned and managed by the Public Sector
What is SASPAC?
A 30-year success story!
1991 2001 20111981
What is SASPAC?
A 30-year success story!
1981 1991 2001 2011
• 1981 Census SAS
• mainframe application
• Durham/Edinburgh University
• LAMSAC
• 150 members
What is SASPAC?
A 30-year success story!
19911981 2001 2011
• 1981 Census SAS
• mainframe application
• Durham/Edinburgh University
• LAMSAC
• 150 members
• 1991 Census LBS/SAS
• PC & mainframe application
• London Research Centre
• 320 members
What is SASPAC?
A 30-year success story!
20011981
• 1981 Census SAS
• mainframe application
• Durham/Edinburgh University
• LAMSAC
• 150 members
1991
• 1991 Census LBS/SAS
• PC & mainframe application
• London Research Centre
• 320 members
• 2001 Census outputs
• Windows application
• Origin/Destination data
• GIS/Web Publishing
• 390 members
2011
What is SASPAC?
A 30-year success story!
20111981 1991 2001
• 2011 Census outputs
• new interface
• on/off-line modes
• ‘Lite’ /’Pro’ versions
• more than just Census
• 1981 Census SAS
• mainframe application
• Durham/Edinburgh University
• LAMSAC
• 150 members
• 1991 Census LBS/SAS
• PC & mainframe application
• London Research Centre
• 320 members
• 2001 Census outputs
• Windows application
• Origin/Destination data
• GIS/Web Publishing
• 390 members
Who uses it and why?
Peak membership following 2001 was almost 400 organisations
Users include: local, central and regional government, health sector, academia, Census Offices, private sector
Helpdesk provides SASPAC and Census support/advice
Access to wide range of Census outputs
Value for money: organisation-wide licence
Data
Function Services
Tools
• UK-wide census offices
• Origin/destination
• Commissioned tables
• 1971 to 1991 censuses
• MYE/IMD/NeSS
• users’ local data
• rich metadata searching/browsing
• manipulation/querying
• custom geographies
• area profiling
• xls, csv, xml export
Who uses it and why?
• HTML
• Integrated GIS
• Web Publishing
• Google Maps/Earth integration
• NDE Wizard
SASPAC’s USPs
• training
• helpdesk support
• data processing & distribution
• documentation
• represent user interests
What SASPAC users want in 2011?
Our user survey said…
access to wide range of data (not just Census)
new and improved interface
data searching, browsing and variable/table outputs
variety of export formats (.xls, .html, .xml, .del, + others)
What SASPAC users want in 2011?
Our user survey said…
command line syntax (macro language)
custom tools (e.g. geography, variables, local data)
improved metadata integration
simplified data storage
continued helpdesk support/advice
data distribution world has changed since 2003!
drive to make more data open and accessible
lots more data becoming available online:
2011 Preparations
Census Offices will:“provide a query management interface (an Application Programming Interface or API) which external partners can use to access the various forms of ONS data in a backend data store”
(2011 Census Output Strategy, December 2009)
Allowing SASPAC to:
1. access Census data as soon as it’s published2. improve error tracking/management3. improve metadata integration4. more than just Census data
2011 Preparations
2011 Preparations
SASPAC is a Partner working with ONS, NOMIS and Manchester University to help develop the 2011 Census API
began in early 2010 and an ‘alpha’ version made available to Partners in December (using 2001 test data)
SASPAC developed a demo application that combined the Census and NeSS API and published this using IA and OS API.
2011 Preparations
Census Data Source
Census API
NeSS API
SASPAC Web Services Wizard
SASPAC’s demonstration app:
SASPAC Outputs
Web Publishing
Mapping
Excel
SASPAC Outputs
Web Publishing
Mapping
Excel
2011 Preparations
Census Data Source
Census API
NeSS API
SASPAC Web Services Wizard
SASPAC’s demonstration app:
2011 Preparations
SASPAC is a Partner working with ONS, NOMIS and Manchester University to help develop the 2011 Census API
began in early 2010 and an ‘alpha’ version made available to Partners in December (using 2001 test data)
SASPAC produced a development application that combined the Census and NeSS API and published this using IA and OS API.
Programme of development underway and will continue as API develops until Census is published
SASPAC’s next 12 months: more prototyping (Framework in place)
user involvement (testing, workshops, SAP)
KHub ‘data and app store’
July 2012 – SASPAC 2011 released with first Census outputs
2011 Preparations
2011 and Beyond
SASPAC 2011:
New interface
‘Lite’ and ‘Pro’ version
On/offline access
Continued helpdesk support/training
2011 and Beyond
SASPAC 2011:
More data (APIs, bulk and user)
SASPAC API and URI feeds
Online user forum/community
Retain and strengthen USPs
2011 and Beyond
SASPAC Web Services Wizard
SASPAC Outputs
Beyond 2011…?
Census Data Sources
