Transcript February, 2010 CONTEXT  CONSTITUTIONAL AMENDMENTS  Creation of the Statistical and Geographical Information System (SNIEG)  INEGI’s Autonomy (July 16th 2008)  Concept of.

February, 2010
CONTEXT
 CONSTITUTIONAL AMENDMENTS
 Creation of the Statistical and Geographical Information
System (SNIEG)
 INEGI’s Autonomy (July 16th 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 SITUATIONWITH
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
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