420 likes | 428 Views
Explore the use of SDMX technology in integrating DevInfo database for efficient MDG monitoring in India. Access customized reports and data exchange mechanisms for effective data sharing. Enhance data exchange at national level with standardized code lists and indicator metadata.
E N D
Monitoring Human Development OECD EXPERT GROUP ON SDMX GENEVA 10-11 MAY 2007
Indicators - SDMX Statistical data and metadata exchange (SDMX) ISO/TS 17369:2005developed by BIS, ECB, EUROSTAT, IMF, OECD, UN and World Bank Sources - DDI/DC Data Documentation Initiative (DDI) and Dublin Core (DC) ISO 15836:2003 Information and documentation Digital Maps - UNGIWG Geographic information metadata ISO 19115:2003 Challenge Milestones Standards Partnerships Tour MDG Monitoring EmergencyInfo Digital Map Library DevInfo.org
Other Databases Integration with Existing Systems System Integration The DevInfo database system is designed to be integrated with existing systems through data exchange mechanisms
Challenge Milestones Standards Partnerships Tour MDG Monitoring EmergencyInfo Digital Map Library DevInfo.org
Type International dataset Publisher UN Statistics Division Title MDG Data set Year 2006 Observation Country Data Information on Data Source
Customized Tables • SAVE and SHARE customized reports • Rapid Assessment • Regular Situation Reports • MDG Reports • Poverty Reduction • Sector Reports
Panel with themes, layers, features, insets
INDIA Population Density Zoom-in to state level L02 States
Earthquake 50 Point Layer Earthquake simulation INDIA 751,000 children
Challenge Milestones Standards Partnerships Tour MDG Monitoring EmergencyInfo DevInfo.org
International Data National Data Metadata Challenge Milestones Standards Partnerships Tour MDG Monitoring Aid Effectiveness EmergencyInfo DevInfo.org SDMX How is SDMX being implemented using DevInfo database technology? SDMX
Challenge Key Family SDMX Model DevInfo MDGs Milestones Country Geographic Area Standards Partnerships Time Time Period Tour Frequency Dimensions MDG Monitoring Topic Indicator Aid Effectiveness EmergencyInfo Subgroup DevInfo.org SDMX Stock/Flow -Key Family Attributes Unit Unit Unit Multiplier Data Source
Challenge Key Family DevInfo MDGs Example Milestones Geographic Area Bangladesh Standards Time Period 2004 Partnerships Tour Indicator Proportion of the population using improved drinking water sources Dimensions MDG Monitoring Aid Effectiveness EmergencyInfo Subgroup Total DevInfo.org SDMX Rural -Key Family Attributes Urban Unit Percent Data Source UNSD MDG 2006
Indicator Unit Geographic Area Subgroups Observation Time Period Data Source
ISSUE 1 Geographic 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 Code Lists Area ID Countries Milestones Standards Partnerships Tour MDG Monitoring Aid Effectiveness EmergencyInfo DevInfo.org SDMX -Key Family -Code Lists
Challenge Code Lists Area ID Sub-national Milestones Standards Partnerships Tour Area ID MDG Monitoring Aid Effectiveness EmergencyInfo DevInfo.org SDMX -Key Family -Code Lists
ISSUE 2 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
Challenge Code Lists Time Period Milestones Standards Partnerships Tour MDG Monitoring Aid Effectiveness EmergencyInfo DevInfo.org SDMX -Key Family -Code Lists YYYY.MM.DD – YYYY.MM.DD
ISSUE 3 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
Challenge Code Lists Indicator Milestones Standards Partnerships Tour MDG Monitoring Aid Effectiveness EmergencyInfo DevInfo.org SDMX -Key Family -Code Lists Indicators by MDG
Challenge Code Lists Unit Milestones Standards Partnerships Tour MDG Monitoring Aid Effectiveness EmergencyInfo DevInfo.org SDMX -Key Family -Code Lists Units for MDG Indicators
Challenge Code Lists Subgroup Milestones Standards Partnerships Tour MDG Monitoring Aid Effectiveness EmergencyInfo DevInfo.org SDMX -Key Family Subgroups for MDG Indicators -Code Lists
Code Lists Indicator Subgroup Unit
Code Lists Global ID Unit
ISSUE 4 • Data Sources • Metadata on data sources are in DDI XML format: • Link from primary data source to secondary/ tertiary data sources • Link to nature of data points • Country Data (C) • Country Adjusted (CA) • Estimated (E) • Modelled (M) • Global monitoring data (G) • Non-relevant (N)
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.
ISSUE 5 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
Domains Sector Indicator Indicator Metadata
ISSUE 6 MDG SDMX Registry The expert working group will be working on the creation of an MDG SDMX registry at global level.
ISSUE 7 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.
Challenge Milestones Standards Partnerships Tour MDG Monitoring Implementation of DevInfo and SDMX to Support Monitoring Millennium Development Goals A Pilot Study with the Southern African Development Community Aid Effectiveness EmergencyInfo DevInfo.org SDMX -Key Family -Code Lists -Domains -SDMX-ML -Registry -Pilot
MDG SDMX Registry
MDG SDMX Registry Zambia Mozambique Malawi MDG Template MDG Template MDG Template National Data National Data National Data
MDG SDMX Registry Zambia Mozambique Malawi MDG Template MDG Template MDG Template National Data National Data National Data
MDG SDMX Registry MDG Template Agent QA Regional Data Zambia Mozambique Malawi
MDG Template Regional Data
For more information, contact: Mr. Nicolas Pron DevInfo Global Administrator npron@unicef.org www.devinfo.org