joão poças, methodology and information systems department

João Poças, Methodology and Information Systems Department

«

Eurostat, Visualisation Task Force,6 May 2008

DISSEMINATION«one input - many outputs

« Current Dissemination Process

Publishing Data Tables

Publishing Maps

Some Plans in discussion

«

Topics

Current Dissemination Process

Data Warehouse

MetadataDatabase

XML data and Metadata

DisseminationDatabase

(BDD)

Dissemination

Statistics Portugal Portal

Publications

Data and Data and MetadataMetadata

Other Data Sources

-Indicators-Tables (pre-defined and user-defined)-Maps

-Press releases-Publications-Excel and PDF tables

Oracle Database:+ 18.500.000 values+ 1.600 indicators

Publishing Data Tables

DisseminationDatabase

(BDD)

“bddXplorer” (http://www.ine.pt)

Data and Data and MetadataMetadata

User “selections”XSLT

CSV

HTML

XLSApache POI

(POIFS)XML Filedata;metadata;layout;

Java

Publishing Maps

DisseminationDatabase

(BDD)

http://www.ine.pt

Data and Data and MetadataMetadata

Indicator selection

.NetARCGis Server 9.2

Thematic Maps

http://maps.ine.pt/ (Statistical data | Main indicators )

Plans “in discussion”

DisseminationDatabase

(BDD)

Publications

Data and Data and MetadataMetadata

Web Service

Excel Templates

XML Filedata;metadata;layout;

Altova StyleVisionTemplates

PDF

Excel/Word ?

XSLT

Each cell has one “formula” that retrieves data from web service (indicator; rows, cols)

Altova Authentic Editor

Plans “in discussion”

DisseminationDatabase

(BDD)

“bddXplorer” (http://www.ine.pt)

Data and Data and MetadataMetadata

User “selections”XSLT

CSV

HTML

XLSApache POI

(POIFS)XML Filedata;metadata;layout;

+SDMX Graphs Maps