IMPLEMENTING SDMX IN MEXICO February, 2010
CONTEXT CONSTITUTIONAL AMENDMENTS Creation of the Statistical and Geographical Information System (SNIEG) INEGI’s Autonomy (July 16 th 2008) Concept of statistical and geographical information of “National Interest”
…CONTEXT FEDERAL LAW National Statistical and Geographical Information System Law INEGI is the coordinator of the system and also a producer of statistical and geographical information All information requested about statistical and geographical information of national interest made by foreign governments or any international organization must be reported to INEGI (Art 51)
CURRENT SITUATION WITH INTERNATIONAL EXCHANGES International organizations request information to each statistical unit in Mexico Each directorate of OECD asks for information in different ways and formats, they even retrieves information of Mexico from public websites We don’t have accurate records of the statistical information delivered to international organizations
…CURRENT SITUATION WITH INTERNATIONAL EXCHANGES On the other hand, we need to set up standards to exchange information within the country.
PROBLEMS TO SOLVE Difficulties to reach the right informant Delays on reaching information delivery deadlines Partial information delivery (no matter if it exists or not) Heterogeneous quality of exchanged information Loss of contacts because of staff changes in institutions Set up standard to exchange information
SDMX ROLE SDMX is part of a set of standards and protocols that are being adopted to build the technological infrastructure of the network Considered useful for national and international information exchange
REQUEST UPLOAD NOTIFICATION INTERNATIONAL EXCHANGE SITE NOTIFICATION ANSWER UPLOAD NOTIFICATION INEGI SUPPORT ANSWER DOWNLOAD (Website for international statistical information exchange) REQUEST DOWNLOAD FOREIGN RELATIONS MINISTRY INFORMANT INSTITUTIONS INTERNATIONAL ORGANIZATIONS EXCHANGE MECHANISM
PLANED DEPLOYMENT FIRST STAGE: Information upload in traditional formats (Excel files, Text files, etc. ) Skill development on SDMX issues (technical and conceptual) and distribution of the desktop tool SECOND STAGE: Adopt SDMX standard for exchange within the country. Deposit of information transformed to SDMX files (using internationally defined DSD or generic format)
PLANED DEPLOYMENT THIRD STAGE: Incorporation of exchanges with other international organizations FOURTH STAGE : Automation of the transformation and exchange process (integration to the collaboration network)
SDMX 2 BUILDER Desktop tool to transform information from different formats to SDMX Complements the Website for International Statistical Information Exchange It will be endowed to statistic information producers in Mexico We aim that it will help to make easier SDMX adoption by national institutions We have already used the tool in three workshops to train users on technical SDMX issues
TRANSFORMATION PROCESS USING SDMX 2 BUILDER DATA AND STRUCTURAL METADATA Direct Data Typing • Define the message format • Import or type data (typically both) • Map data to SDMX tags • Save the file • It also generates a script for automatic transformation ODBC Database Connection Text File (CSV) Microsoft Excel Worksheet DIFERENT FORMATS SDMX 2 Builder SDMX FILE
FEATURES Based on SDMX 2. 0 version Support of “Generic Data”, “Compact Data” and “Cross Sectional Data” message types Construction of Data Structure Definitions Code lists definition SDMX Files Edition Multiple sources (Text files , Excel Worksheets, Databases) Conversion scripts (for automatic dataflow construction) Multilanguage (any language using Latin alphabet can be added) Windows XP platform
STATUS Technological platform has been developed and is operational (ready to be used) Desktop tool ready to be delivered, a new version of the tool for SDMX 2. 1 is under design (it also will be web enabled) National and international agreements with national informants and international requesters (with OECD in the first stage) Data Exchange between OECD and INEGI each month (after a pilot test) Developing a legal mandate to make official and obligatory the use of the site for Mexican Ministries
Скачать презентацию IMPLEMENTING SDMX IN MEXICO February 2010 CONTEXT
c6d9ce5c9897d5351e34c421f86aaf20.ppt