40 likes | 54 Views
Eurostat main tables and graphs. Nordic webseminar, Stockholm, 16.-17. February 2010. The contents of the Eurostat tables. The tables in the database are presented according to the grouping of topics used in Official Statistics of Finland (OSF)
E N D
Eurostat main tables and graphs Nordic webseminar, Stockholm, 16.-17. February 2010
The contents of the Eurostat tables • The tables in the database are presented according to the grouping of topics used in Official Statistics of Finland (OSF) • At the moment all tables are in English, but translating the titles of the tables to Finnish is under consideration • Eurostat has added new tables to the predifined table set almost weekly • The automatic script downloads new tables as they are added to the ES service
Downloading the data Markku Huttunen • SF has made a script to automatically download the ES tables • ES home > Statistics > Bulk download > Bulk download facility (>) • Bulk download area contains both predefined and database tables • All tables are downloaded but only predefined tables are used to create px-tables and PX-Web database • Data and all metadata are stored in different files: data files, dictionary files and table of contents • table of contents -> contents of the data files -> dictionary files -> PC-Axis files • The tables are downloaded from the ES site as they are • System consists of three scripts • a python script of 550 rows parses data and metadata into valid px-files • the file containing the python code: eurostat_pdt.py 16.2.2010 3
Internet-dissemination with PX-Web and Verti PXWEB1 DMZ Dissemination area Internet PXWEB Internal dissemination and development area PXWEB StatFin (+ about 15 dissemination data bases) PXWEB2 VERTI test PXWEB PXWEB Automatic updating system PC-Axis -files Findicator VERTI1 PXWEB VERTI develop- ment VERTI2 PXWEB VERTI vevelop- ment VERTI runtime VERTI runtime Other graph and table needs VERTIh1* Feedback service for data providers ….. PXWEB VERTIh* develop- ment VERTIh* runtime VERTIh* runtime VERTIh = data bases for confidential information TP/PaTu/DB/Hans Baumgartner 2.1.2020 4