User query examples

Navigation CWSWG Home Wiki Forum More ways to browse Site map Report a problem Help Subscribe to RSS feeds Special pages Browser requirements How to edit pages List of all pages Recently updated pages List of oldest pages Site map Report a problem Help Subscribe to RRS feeds Tag cloud browser category census-hub comment contact cubes data_feed eurostat forum help log-in metadata pages problem queries rank rss sdmx specifications tag Search pages only pages and forum forum only Add content

Content Example user queries that a data feed would need to be able to answer: Below are some example user queries that a data feed would ideally be able to answer. These are reasonably straightforward to start with and could help evaluate ONS' SDMX proof of concept work? It would also be interesting to ask more complex queries of the feed - e.g. user defined polygons or previously disclosive cross-tabs like industry/ethnic group for larger geographies - and see how it would cope. Name of requester: Alan Lewis (SASPAC) Query: Details on the economic activity (employed/self-employed…etc) of the UK population for electoral ward/division geographies. Population base: Resident population aged 16 to 74 Variables: Key Statistics table KS009, variables KS0090001 to KS0090015 Geography: LAU-2 (UK electoral wards/divisions) England, Wales, Scotland and Northern Ireland Format: XML Name of requester: Alan Lewis (SASPAC) Query: Details of the method of travel to work for custom workplace population geographies. Population base: Employed people aged 16 to 74 Variables: Special Workplace Statistics, variables SWS3010001 to SWS3010036 Geography: Custom workplace geography built from an aggregation of 2001 Census Output Areas Format: MS Excel (1997-2003 or 2007) Name of requester: Alan Lewis (SASPAC) Query: Pre-school aged population profile of residents within 2 miles of a school? Population base: Resident population Variables: Population weighted Easting/Northing and Census Area Statistics table CS001 Geography: Selection of 2001 Census Output Area population centroids Format: HTML In all cases here the request would provide the queried varaiables along with the appropriate metadata. Related Wiki pages related to this one: Video demonstrations Data feed user queries Linked from This page is linked to from the following pages: Page info Page attribute Value Page title User query examples Page name case-study-examples Category wiki URL http://www.ukcensusoutputs.net/wiki:case-study-examples Page author ONS_Brendan Date created 1244711285|%e %b %Y, %H:%M %Z|agohover Last edited by ONS_Brendan Last edited 1244711520|%O ago (%e %b %Y, %H:%M %Z) Page rating 0 Page comments 0 Page tags data_feed queries Files

Wiki navigation Wiki home 1 About the CWSWG 1.1 Terms of Reference 1.2 Group members & contacts 1.3 CWSWG meetings & events 2 Member projects 2.1 ONS 2.2 MIMAS / CDU 2.3 NOMIS 2.4 SASPAC 2.5 Data Feeds Network (DFN) 2.6 EDINA 2.7 GROS 2.8 NISRA 3 Definitions and technical specifications 4 Metadata 5 Eurostat Census Hub Project 6 Coverting 2001 tables to 2011 SDMX cube format 7 Suggested topics Sortable list of all wiki pages Frequently Asked Questions (FAQs) Edit this menu Tag cloud 2001 api census-hub cube cubes data_feed demo eurostat madrid metadata queries research sdmx specifications supporting_information video New entries Suggestions for new pages, created: 18 May 2011 18:56 Metadata, created: 25 Mar 2010 10:56 Cube design & sparsity, created: 25 Mar 2010 10:54 EDINA Development progress, created: 24 Mar 2010 10:47 GROS Development progress, created: 24 Mar 2010 10:43 Recent edits Metadata, edited: 26 Jan 2012 20:24 Suggestions for new pages, edited: 18 May 2011 18:56 Member projects, edited: 18 May 2011 18:49 Definitions and technical specifications, edited: 16 Jun 2010 10:03 Cube design & sparsity, edited: 25 Mar 2010 10:54 Add new