Transcript PC-AXIS REFERENCE GROUP MEETING 2012

23rd
PC-Axis Reference Group
Meeting 2014
Copenhagen
Statistics Sweden
23rd PC-Axis Reference Group Meeting - Copenhagen
Agenda - Thursday 2 October
________________________________________________________________
09.00 – 09.15 Welcome/opening – Annegrete Wulff - Denmark Statistics
09:15 – 10:00 Presentations and Introduction – Åsa Arrhén - Statistics Sweden
10:00 – 10:15 PX-Web API at INSTAT - Helda Curma - INSTAT, Albania
10:15 – 10:45 Coffee break
10:45 – 11:30 Mobil Statistikbank - Lars Knudsen - Denmark Statistics
11:30 – 12:15 Map component - Pavel Bublavý - Tieto, Finland
12:15 – 12:30 Statistics Norway´s solution for SDMX-RI, API and why we want to use
PX-Web - Bjarte Mellemstrand - Statistics Norway
12:30 – 13:30 Lunch
13:30 – 14:30 Presentation PX-Web 2014 May, Maria Gunnarsson & Petros Likidis, SCB
14:30 – 15:00 News in PX-Edit, Veli-Matti Jantunen, Statistikcentralen
15:00 – 15:30 Coffee break
15:30 – 16:00 PC-Axis file format – Petros Likidis, SCB
16:00 – 16:15 Summing up
Statistics Denmark invites for dinner
23rd PC-Axis Reference Group Meeting - Copenhagen
Agenda – Friday 3 October
_______________________________________________________________
09.00 – 10:00 Beta version of STAT-TAB-3, Alain Nadeau, Swiss Federal
Statistical Office
10:00 – 10:30 Coffee
10.30 – 11.15 David Roon, Yoocos, Switzerland - Build applications with PC-Axis
and CubeCORE
11:15 – 11:45 Publishing at NIER, Torbjörn Lindqvist, National Institute of
Economic Research
11:45 – 12:15 Country report – Eoin McCuirc, CSO, Ireland
12:30 – 13:30 Lunch
13:30 – 14:30 Wishes for future development.
14:30 – 15:00 Coffee
15:00 – 15:30 Continued wishes for future development. Discussion
15:30 – 16:00 Summing up and comments
23rd PC-Axis Reference Group Meeting - Copenhagen
New members
Agency for Statistics, Bosnia and
Herzegovina
ASEANstats, Indonesia
Welcome !
23rd PC-Axis Reference Group Meeting - Copenhagen
Presentation
• Name
• Organisation
• Role
23rd PC-Axis Reference Group Meeting - Copenhagen
PC-Axis around the world
Africa (6)
Cap Verde
Mali
Mozambique
Niger
South Africa
Burkina Faso
Asia (7)
Armenia
ASEANstats
Bhutan
Kyrgyzstan
Palestine
Taiwan (R.O.C.)
Vietnam
Jordan
Oceania (1)
New Zealand
23rd PC-Axis Reference Group Meeting - Copenhagen
Europe
Albania
Basque
Bosnia and
Herzegovina
Croatia
Denmark
Estonia
Faroe Island
Finland
Georgia
Greenland
Iceland
Ireland
Kosovo
Latvia
Luxembourg
Macedonia F.Y.R.
Moldova
Norway
Slovakia
Slovenia
Spain
Sweden (15)
Switzerland
Ukraine
UNECE
Åland
The PC-Axis team at Statistics Sweden
• Support, marketing, administration, courses,
planning, testing:
• Åsa Arrhén
• Thomas Molin
• PC-Axis
• Tim Forsström
• .Net-development
•
•
•
•
•
•
Björn Berglund
Maria Gunnarsson
Petros Likidis
Mikael Nordberg
Tobias Olofsson
Ulf Wallin
23rd PC-Axis Reference Group Meeting - Copenhagen
Who is responsible?
• Statistics Sweden
•
•
•
•
PX-Web
PC-Axis Main module
PC-Axis SQL
PX-Batch
• Statistics Denmark
• Menu & graphs (PX-Web)
• PX-Make
• Statistics Norway
• SQL-parser (PX-Web)
• Statistics Finland
• PX-Edit
23rd PC-Axis Reference Group Meeting - Copenhagen
PX-Web since Tirana
23rd PC-Axis Reference Group Meeting - Copenhagen
Progress since last meeting
• PX-Web 2013 R1 December
•
•
•
•
•
Attributes at cell level
API
One home page per database
Possibility to choose sort order; MATRIX, TABLE or file name
More…
• PX-web 2014 May R1
•
•
•
•
Search functionality
Logging user statistics
New settings
More…
• Test site
• PX-Web works with CNMM 2.3
• Statistics Sweden uses PX-Web for the Statistical Database
23rd PC-Axis Reference Group Meeting - Copenhagen
2000 - 2012 www.ssd.scb.se
23rd PC-Axis Reference Group Meeting - Copenhagen
2012 (Sep) – 2014 (May)
www.scb.se/statistikdatabasen
23rd PC-Axis Reference Group Meeting - Copenhagen
May 2014 – http://www.statistikdatabasen.scb.se
23rd PC-Axis Reference Group Meeting Copenhagen
Our API
• Release version 1.0 in May 2014
23rd PC-Axis Reference Group Meeting - Copenhagen
Statistical Database
• 3 160 tables in the database
• 1 350 translated to English
23rd PC-Axis Reference Group Meeting Copenhagen
Statistics from the API
• 1,0 million whitdrawals per year
• ½ million queries with
API from May-August
Dataour
queries
1200000 2014
1000000
800000
600000
Querys
400000
200000
0
Statistical
database
Website
API 4 month
API usage by formats
Most requested tables
23rd PC-Axis Reference Group Meeting Copenhagen
API usage by country
http://jsfiddle.net/ukmejgum/2/
Examples
• Newspaper using our api to show party
preferences in the elections.
Updated live
through the api
Import and export Google
chart
http://jsfiddle.net/DoubleEE/v33zS/
23rd PC-Axis Reference Group Meeting Copenhagen
• Hack for Sweden March 2014
• Thirteen authorities cooperated
• Purpose: Focus on our open data and inspire use
of it, gain goodwill, and increase open data in
general
• Communication channels: personal contacts,
invitations to university educations, press releases,
event site, Facebook, Twitter
• Different categories and winners
Best visualisation
The
government of your neighborhood
23rd PC-Axis Reference Group Meeting Copenhagen
API at www.scb.se
•
•
•
•
Survey page
Recently updated tables
Search
Economic indicators
23rd PC-Axis Reference Group Meeting - Copenhagen
Future plans API
• More internal use
• Graphs with API
• Visuslisation
• Dynamic tables
• Hackaton March 2015 http://hackforsweden.se
• More functions
23rd PC-Axis Reference Group Meeting Copenhagen
Release Plan PX-Web
Version
Date
PX-Web
2012 R2
PX-Web
2014
May R1
14 May
PX-Web 2014 May R2
1 November 2014
PX-Web 2014 December R1
December
PX-Web 2014 December R2
Spring 2015
PX-Web 2015
23rd PC-Axis Reference Group Meeting - Copenhagen
Plans
•
•
•
•
Saved query (light) December 2014
PC-Axis to .net
Formalised cooperation on developing
New version December 2014
23rd PC-Axis Reference Group Meeting - Copenhagen