slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
OECD Expert Group on Statistical Data and Metadata Exchange PowerPoint Presentation
Download Presentation
OECD Expert Group on Statistical Data and Metadata Exchange

Loading in 2 Seconds...

play fullscreen
1 / 18

OECD Expert Group on Statistical Data and Metadata Exchange - PowerPoint PPT Presentation


  • 116 Views
  • Uploaded on

OECD Expert Group on Statistical Data and Metadata Exchange Part 1: Exchange of experience and practices for data sharing and exchange 1.1 Tools presently used Gesmes/TS deliveries from output databases at Statistics Sweden Lars Nordbäck. Preparation phase - Retrieval from the database.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'OECD Expert Group on Statistical Data and Metadata Exchange' - tyler-hopkins


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

OECD Expert Group on Statistical Data and Metadata Exchange

Part 1: Exchange of experience and practices for data sharing and exchange

1.1 Tools presently used

Gesmes/TS deliveries from output databases at Statistics Sweden

Lars Nordbäck

slide5

The Selection program is monitored using a bat- and a txt-file

1

The arrays to remove are marked with a minus sign. The minus option is used when a few arrays shall be removed, if a few shall remain you can use a plus sign and enter those arrays to remain

The name of the input gesmesfile is on line one, and the resulting file is in line two.

Gesselect is started by clicking the gesselect.bat file

slide6

The Concatenation program is monitored using a bat- and a txt-file

1

Name of resulting file

2

2

The name of the gesmesfiles to concatenate are entered in a text-file. The first name however shall be on the resulting file

3

Gesconc is started by clicking the gesconc.bat file

slide9

Gesmes/TS deliveries from the output database SSD

PC-Axis SQL – save queries

PX-Batch – run queries that produces gesmesfiles

GesSelect – selecting arrays from a rectangular retrieval

Gesconc – concatenating several Gesmes-files into one file

Statel/Stadium – keeps track on delivieries

slide10

Possible development

  • - Better solutions for special signs
  • Automatic delivery, projects in Denmark and Norway
  • Gesmes/TS-XML?
slide15

Using one existing standard

  • Gesmes/TS is used by ECB and Eurostat
  • We have tools to produce Gesmes/TS
  • We can produce from our existing public databases
  • We are going to make automatic data transfer, the goal is to achieve EDIFACT as it is used in the automotive industry
  • The same tools are used by several countries
slide16

Countries using the PC-Axis family software

Europe: Croatia, Denmark, Estonia, Finland, Ireland, Iceland, Latvia, Lithuania, Norway, Slovenia, Spain, Sweden and UN/ECE in Geneva

Asia: Taiwan, The Philippines

Afrika: Algeria, Kuwait, East Africa Community, Namibia, Uganda, South Africa

South America: Bolivia and Brazil

Discussions with Romania, Slovakia and Tanzania

slide18

IF the statistics is in the Public Output Data Base, SSD, the Gesmes files are created fetching metadata and data fromalt 1) a table entered for the Public SSD on the Statistics Sweden website alt 2) a special composed table especially established for the reporting to other organisations. If necessary a converting file is used to get the demanded codes.If the statistics is missing in the SSD Gesmes files can be created using Excel.

Metadata

Metadata

SSD-table

Eurostat-table

Code converting file

PC-Axis

Excel-Gesmes conversion

Selections, DSt

Gesmesfiles

The Excel conversion add in produced by the consultant Anders Törnqvists will be available for other institutions from the consultant direct.

PC-Axis function for creating Gesmesfiles has been further developed to be able to use open array parameters

Concatenation,DSt

Gesmesfile – ready to send