monitoring human development oecd expert group on sdmx geneva 10-11 may 2007

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

For more information, contact:

Mr. Nicolas PronDevInfo Global Administratornpron@unicef.org

www.devinfo.org