monitoring human development oecd expert group on sdmx geneva 10-11 may 2007
TRANSCRIPT
Monitoring Human Development
OECD EXPERT GROUP ON SDMX GENEVA 10-11 MAY 2007
Indicators - SDMXStatistical data and metadata exchange (SDMX) ISO/TS 17369:2005 developed by BIS, ECB, EUROSTAT, IMF, OECD, UN and World Bank
Sources - DDI/DCData Documentation Initiative (DDI) and Dublin Core (DC) ISO 15836:2003 Information and documentation
Digital Maps - UNGIWGGeographic information metadata ISO 19115:2003
Challenge
Milestones
Standards
Partnerships
Tour
MDG Monitoring
EmergencyInfo
Digital Map Library
DevInfo.org
Other DatabasesIntegration with Existing Systems
System IntegrationThe DevInfo database system is designed to be integrated with existing systems through data exchange mechanisms
Challenge
Milestones
Standards
Partnerships
Tour
MDG Monitoring
EmergencyInfo
DevInfo.org
Digital Map Library
Information on Indicator
Information on Area
Information on Data Source
Type International dataset
Publisher UN Statistics Division
Title MDG Data set
Year 2006
Observation Country Data
Customized Tables
SAVE and SHARE customized reports
• Rapid Assessment• Regular Situation Reports• MDG Reports• Poverty Reduction• Sector Reports
Panel with themes,layers,features,insets
L02States
Zoom-in to state level
INDIAPopulation Density
751,000 children
50
Point Layer
Earthquake
Earthquake simulation
INDIA
Challenge
Milestones
Standards
Partnerships
Tour
MDG Monitoring
EmergencyInfo
DevInfo.org
Challenge
Milestones
Standards
Partnerships
Tour
MDG Monitoring
Aid Effectiveness
EmergencyInfo
SDMX
DevInfo.org
SDMX
International Data
National Data
Metadata
How is SDMX being implemented using DevInfo database technology?
Challenge
Milestones
Standards
Partnerships
Tour
MDG Monitoring
Aid Effectiveness
EmergencyInfo
SDMX
DevInfo.org
Key Family
Dimensions
Attributes
Country
Time
Frequency
Unit
Unit Multiplier
Topic
Stock/Flow
Geographic Area
Time Period
Indicator
Subgroup
Unit
SDMX Model DevInfo MDGs
Data Source
-Key Family
Challenge
Milestones
Standards
Partnerships
Tour
MDG Monitoring
Aid Effectiveness
EmergencyInfo
SDMX
DevInfo.org
Key Family
-Key Family
Dimensions
Attributes
Geographic Area
Time Period
Indicator
Subgroup
Unit
DevInfo MDGs
Data Source
Proportion of the populationusing improved drinking
water sources
Total
Rural
Urban
Percent
2004
Bangladesh
UNSD MDG 2006
Example
Geographic Area
Time Period
Indicator
Subgroups
Unit
Data Source
Observation
ISSUE 1Geographic Area Code List
Area IDs for geographic areas are standardized and coding handles multiple geographic areas: global, regions, countries, sub-national geographic areas
RECOMMENDATION
UNGIWG Spatial Database
Challenge
Milestones
Standards
Partnerships
Tour
MDG Monitoring
Aid Effectiveness
EmergencyInfo
SDMX
DevInfo.org
Code Lists
-Code Lists
-Key Family
Area ID Countries
Challenge
Milestones
Standards
Partnerships
Tour
MDG Monitoring
Aid Effectiveness
EmergencyInfo
SDMX
DevInfo.org
Code Lists
-Code Lists
-Key Family
Area ID Sub-national
Area ID
Time Period Code List
Time Periods are standardized to handle a start and end time period. Also, able to specify combinations of years, months, days.
RECOMMENDATION
yyyy.mm.dd - yyyy.mm.dd
ISSUE 2
Challenge
Milestones
Standards
Partnerships
Tour
MDG Monitoring
Aid Effectiveness
EmergencyInfo
SDMX
DevInfo.org
Code Lists
-Code Lists
-Key Family
Time Period
YYYY.MM.DD – YYYY.MM.DD
MDG Indicator Structural Definitions
Rationalized and simplified MDG indicator names: indicators, units, subgroups.
Indicator: Unemployment rate
Unit: Per cent
Subgroups:* Male 15-24 yr Female 15-24 yr Total 15-24 yr
Subgroups include sex, location (urban/rural), age groups, other attributes
ISSUE 3
Challenge
Milestones
Standards
Partnerships
Tour
MDG Monitoring
Aid Effectiveness
EmergencyInfo
SDMX
DevInfo.org
Code Lists
-Code Lists
-Key Family
Indicator
Indicators by MDG
Challenge
Milestones
Standards
Partnerships
Tour
MDG Monitoring
Aid Effectiveness
EmergencyInfo
SDMX
DevInfo.org
Code Lists
-Code Lists
-Key Family
Unit
Units for MDG Indicators
Challenge
Milestones
Standards
Partnerships
Tour
MDG Monitoring
Aid Effectiveness
EmergencyInfo
SDMX
DevInfo.org
Code Lists
-Code Lists
-Key Family
Subgroup
Subgroups for MDG Indicators
Code Lists Indicator
Unit
Subgroup
Code Lists Global ID
Unit
MDG Indicator Structural Definitions
Data Sources
Metadata on data sources are in DDI XML format:
(a) Link from primary data source to secondary/ tertiary data sources
(b) Link to nature of data pointsCountry Data (C)Country Adjusted (CA)Estimated (E)Modelled (M)Global monitoring data (G)Non-relevant (N)
ISSUE 4
The data source should link the user from UNSD (in this example)to the UN agency providing the data and on to the primary data source at country level.
Domains
The expert working group is working on the creation of MDG domains and establishing methods for updating the related code lists, key families and indicator metadata. This will be very helpful for data exchange at national level.
IUS: Linkages to goals, sectors, other classifications.
RECOMMENDATION
Build on subject matter expertise of the18 UN agencies of MDG expert working group
ISSUE 5
Domains Sector Indicator
Indicator Metadata
MDG SDMX Registry
The expert working group will be working on the creation of an MDG SDMX registry at global level.
ISSUE 6
MDG Data Management
The expert working group is working on an SDMX-ML compliant data collection mechanism:
From national level to international level (UN agency)
From UN agency to UNSD.
The information in this spreadsheet will be transformed into an SDMX-ML format.
ISSUE 7
Challenge
Milestones
Standards
Partnerships
Tour
MDG Monitoring
Aid Effectiveness
EmergencyInfo
SDMX
DevInfo.org
-Key Family
-Code Lists
-Domains
-SDMX-ML
Implementation of DevInfo and SDMX to Support Monitoring Millennium Development Goals
A Pilot Study with the Southern African Development Community
-Pilot
-Registry
MDG SDMXRegistry
ZambiaMozambiqueMalawi
MDG SDMXRegistry
MDG Template MDG Template MDG Template
National Data National Data National Data
ZambiaMozambiqueMalawi
MDG SDMXRegistry
MDG Template MDG Template MDG Template
National Data National Data National Data
ZambiaMozambiqueMalawi
MDG SDMXRegistry
Agent
MDG Template
Regional Data
QA
MDG Template
Regional Data