210 likes | 219 Views
Korea, Seoul, November 2012. SCAD: Development of statistical information systems for the provision of census data. Presented by: Jasim Mohamed Lahdan Alqubaisi Survey Planning, Design & Processing Department Manager. Overview. Abu Dhabi Census 2011. Abu Dhabi and SCAD
E N D
Korea, Seoul, November 2012 SCAD: Development of statistical information systems for the provision of census data Presented by: Jasim Mohamed Lahdan Alqubaisi Survey Planning, Design & Processing Department Manager
Overview Abu Dhabi Census 2011 • Abu Dhabi and SCAD • Abu Dhabi Census 2011 • Abu Dhabi Census 2011 Output Planning • Census 2011 Thematic Maps • Census 2011 Community Tables • Census 2011 Table Builder • Scenarios • Demonstration The Tools Scenarios and Demo
Abu Dhabi and SCAD • Abu Dhabi is the federal capital of the United Arab Emirates (UAE). • Last 40 years seen significant population growth and economic development. • Recognised need for official agency to provide statistics for decision making & policy. • In 2008, Statistics Centre – Abu Dhabi (SCAD) was established. • As a young statistical office, SCAD in fortunate position to review and implement best practices from NSOs and other international statistical bodies.
Abu Dhabi Census 2011 • First official census conducted 1975. • Subsequent censuses 1980, 1985, 1995, 2001 and 2005. • In 2005Census, output limited to hardcopy tables and PDF tables.
Abu Dhabi Census 2011 Output Planning • Census 2011 • First census conducted by SCAD (October 2011). • Census Outputs Aim • To make rich census data more widely available/accessible (on-line statistical tools). • Obligation • To ensure that the time and effort from enumerators and SCAD census team, and the good will of the citizens, were repaid with quality outputs.
Abu Dhabi Census 2011 Output Planning • Pre-requisites • Ease of use – tools do not require training or registration (intuitive). • Spatial representation – AD GIS integrated, expectation data presented in maps. • Take away data – first time data available electronically, easy to extract for analysis. • Sense of community – given growth, ability to know about local area important. • Confidentiality – privacy and protection of identification of individuals (Law #7). • Metadata – tools to link contextually to central metadata system. • Publishing standards – outputs consistent and meet SCAD standards. • Language accessibility – Arabic official language, most govt. services dual language.
Abu Dhabi Census 2011 Output Planning • User requirements • External users – utilised CRM analysis where reviewed all client requests related to households, population and buildings. • Government users – SLAs with key agencies which provide guidance on the type and format of data required. Additionally, meetings on functionality. • Internal users – expatriate professionals from international NSOs. Additionally, local Emirati staff with previous census experiences – critical that design meets local ideals. • International review – various census on-line tools were studied. AD Census tools incorporate some of the best practices from these tools.
Abu Dhabi Census 2011 Output Planning • Development • Timeframe - very compact compared with similar census tools (9 month devel). Proof of concept using tools on other data sets (e.g. Foreign Trade Table Builder). • Development partner – SAS is SCAD’s selected vendor for data analysis/processing, but also for dissemination. Census tools development was joint venture between SCAD’s SIS Team and SAS. • Application architecture – multi-tier architecture. User interface developed with J2EE based Java Server pages. The Census data resides in Oracle database as back-end. SAS used as middleware - facilitates secure comms across front & back-end layers.
Abu Dhabi Census 2011 Output Planning • Confidentiality • With the tools providing increased data manipulation, comes increased potential/risk of disclosure. • A working group reviewed existing international disclosure control methods (both pre & post-tabular). • Adopted a seeded random rounding to base 5. The seed, or ‘key’, ensures same result is repeatedly produce and caters for differencing when subsets are generated. • Minimum output geography • Threshold of =>500 persons and =>5 households.
The Tools Census 2011 Thematic Maps
The Tools – Census 2011 Thematic Maps • The on-line thematic (choropleth) mapping tool allows user to quickly see census data represented geographically. • Easily recognise spatial ‘clusters’ or ‘hot spots’. • While standard annotated maps show where something is in a place, thematic maps tell a story about that place. • The tool includes standard mapping functions, such as: drag zoom, layer transparency, pan, export, and colour palette. • Over 70 census variables, organised by theme, are available for selection.
The Tools Census 2011 Community Tables
The Tools – Census 2011 Community Tables • Concept is to provide an instant statistical snapshot of a user-defined community. • Important aspect of the tool is to empower user to define their own ‘community of interest’ either from map or folder selection tools. • User can also select from 24 pre-defined census tables to form the basis of output report. • Report provided in PDF, Excel, or HTML formats.
The Tools Census 2011 Table Builder
The Tools – Census 2011 Table Builder • Purpose to provide clients with the highest degree of freedom in selecting and combining census data. • Users design their own census output tables by accessing variables and by modifying the table structure to suit their own requirements. • Table builder also allows for easy export and offers some elementary data analysis.
Scenarios and Demonstration • 1. ADHealth Authority implementing new aged health care services – like to know where older persons are located?
Scenarios and Demonstration • 2. Property developer interested in building a new mall in Khalifa City - would like a social profile of local area?
Scenarios and Demonstration • 3. AD Education Council would like to know highest level of educational attainment by gender by regions in Abu Dhabi?
Conclusion • SCAD recognises its responsibility to expand and improve the quality, timeliness, and accessibility of statistics produced in the Emirate of Abu Dhabi. • The suite of on-line census tools is evidence of SCAD’s commitment to this goal. • This project has set a positive benchmark for other future statistical outputs.
Contact Information: Mr.Jasim Alqubaisi Survey Planning, Design & Processing Department Manager P.O. Box: 6036, Abu Dhabi, U.A.E Tel:+9712 8100222 Fax:+9712 8100800 Office:+9712 8100522 Mobile:+9715 06666051 Email: jmalqubaisi@scad.ae Thank You. Korea, Seoul, November 2012