![Page 1: Greenlandic Summer 2015 PC-Axis International, Stockholm 2015Lars Pedersen](https://reader035.vdocuments.us/reader035/viewer/2022081506/5697c01d1a28abf838cd0652/html5/thumbnails/1.jpg)
Greenlandic Summer 2015
PC-Axis International, Stockholm 2015 Lars Pedersen
![Page 2: Greenlandic Summer 2015 PC-Axis International, Stockholm 2015Lars Pedersen](https://reader035.vdocuments.us/reader035/viewer/2022081506/5697c01d1a28abf838cd0652/html5/thumbnails/2.jpg)
Visitors: Business as usual ?
www.stat.gl http://bank.stat.gl
2013 2014 2015 2013 2014 2015
Desktop 93 81 77 97 94 92
Cell 3 10 14 1 2 4
Tablet 4 9 9 2 4 4
![Page 3: Greenlandic Summer 2015 PC-Axis International, Stockholm 2015Lars Pedersen](https://reader035.vdocuments.us/reader035/viewer/2022081506/5697c01d1a28abf838cd0652/html5/thumbnails/3.jpg)
Smartphones :
![Page 4: Greenlandic Summer 2015 PC-Axis International, Stockholm 2015Lars Pedersen](https://reader035.vdocuments.us/reader035/viewer/2022081506/5697c01d1a28abf838cd0652/html5/thumbnails/4.jpg)
50 shades of gray:
![Page 5: Greenlandic Summer 2015 PC-Axis International, Stockholm 2015Lars Pedersen](https://reader035.vdocuments.us/reader035/viewer/2022081506/5697c01d1a28abf838cd0652/html5/thumbnails/5.jpg)
On iPhones it is pure sadism:
![Page 6: Greenlandic Summer 2015 PC-Axis International, Stockholm 2015Lars Pedersen](https://reader035.vdocuments.us/reader035/viewer/2022081506/5697c01d1a28abf838cd0652/html5/thumbnails/6.jpg)
https://github.com/sylvain-hamel/safarimobile-multiline-selecthttp://www.stat.gl/demo/testselect/experiments/experiments.html
! Important repare this ios feature
![Page 7: Greenlandic Summer 2015 PC-Axis International, Stockholm 2015Lars Pedersen](https://reader035.vdocuments.us/reader035/viewer/2022081506/5697c01d1a28abf838cd0652/html5/thumbnails/7.jpg)
! Important
![Page 8: Greenlandic Summer 2015 PC-Axis International, Stockholm 2015Lars Pedersen](https://reader035.vdocuments.us/reader035/viewer/2022081506/5697c01d1a28abf838cd0652/html5/thumbnails/8.jpg)
! Is it done better?
![Page 9: Greenlandic Summer 2015 PC-Axis International, Stockholm 2015Lars Pedersen](https://reader035.vdocuments.us/reader035/viewer/2022081506/5697c01d1a28abf838cd0652/html5/thumbnails/9.jpg)
• Multilingual px-files• Translation of pxweb to Danish & Greenlandic
• Short addresses• Visible table id
• Responsive design
• Last updated statbank files for our front page
• The (important) little things
Moving to pxweb 2015R1
![Page 10: Greenlandic Summer 2015 PC-Axis International, Stockholm 2015Lars Pedersen](https://reader035.vdocuments.us/reader035/viewer/2022081506/5697c01d1a28abf838cd0652/html5/thumbnails/10.jpg)
MATRIX="BEXSTM1";
DESCRIPTION="Population July 1st. <em>[BEESTM1]</em>";DESCRIPTION[da]="Befolkningen pr 1. juli 2011-2015 <em>[BEDSTM1]</em>";DESCRIPTION[kl]="1. Juli innuttaasut 2011-2015 <em>[BENSTM1]</em>";
The language specific files does not exist and generates an 404 error-> catch the error, use language code to find right file in menu.xml
Short language specific addresses
![Page 11: Greenlandic Summer 2015 PC-Axis International, Stockholm 2015Lars Pedersen](https://reader035.vdocuments.us/reader035/viewer/2022081506/5697c01d1a28abf838cd0652/html5/thumbnails/11.jpg)
Using saved queries in operation
1) Do data & use2) Do px-file & use3) Add Testbank & use4) Do Excel -> Word -> testsite -> website5) Copy Statbank
Recommended work-flow
![Page 12: Greenlandic Summer 2015 PC-Axis International, Stockholm 2015Lars Pedersen](https://reader035.vdocuments.us/reader035/viewer/2022081506/5697c01d1a28abf838cd0652/html5/thumbnails/12.jpg)
Standardizing px-files with a sas macro
![Page 14: Greenlandic Summer 2015 PC-Axis International, Stockholm 2015Lars Pedersen](https://reader035.vdocuments.us/reader035/viewer/2022081506/5697c01d1a28abf838cd0652/html5/thumbnails/14.jpg)
Aggregations– They do not behave as in pcaxis/pxweb 2008
Calculations– Decimals / using constant value is needed
Observed UserConfusion- Address line : session information is visible
Some bugs
![Page 15: Greenlandic Summer 2015 PC-Axis International, Stockholm 2015Lars Pedersen](https://reader035.vdocuments.us/reader035/viewer/2022081506/5697c01d1a28abf838cd0652/html5/thumbnails/15.jpg)
api
www.tourismstat.gl
![Page 16: Greenlandic Summer 2015 PC-Axis International, Stockholm 2015Lars Pedersen](https://reader035.vdocuments.us/reader035/viewer/2022081506/5697c01d1a28abf838cd0652/html5/thumbnails/16.jpg)
api & saved queries (api light)
• When showing table on screen – url and query (POST method)
• When saving a saved query– the response can be fetched as GET
How can this be used?
![Page 17: Greenlandic Summer 2015 PC-Axis International, Stockholm 2015Lars Pedersen](https://reader035.vdocuments.us/reader035/viewer/2022081506/5697c01d1a28abf838cd0652/html5/thumbnails/17.jpg)
enable cross-origin resource sharing
Remove enableCors
Add as response header insteadActivate saved queriesActivate JSON-STAT format
![Page 19: Greenlandic Summer 2015 PC-Axis International, Stockholm 2015Lars Pedersen](https://reader035.vdocuments.us/reader035/viewer/2022081506/5697c01d1a28abf838cd0652/html5/thumbnails/19.jpg)
keyfigures & indicators
www.stat.gl/demo
![Page 20: Greenlandic Summer 2015 PC-Axis International, Stockholm 2015Lars Pedersen](https://reader035.vdocuments.us/reader035/viewer/2022081506/5697c01d1a28abf838cd0652/html5/thumbnails/20.jpg)
• Eurostat data brought to you by Finland• http://pxnet2.stat.fi/PXWeb/sq/388fce4b-65c3-49eb-959a-c3dd81dbbcb7
• Nordic data brought to you by Denmark• http://91.208.143.100/pxweb/norden/sq/265aeeda-d9e2-4f54-b432-e9002911d07b
• Globalization indicators by UNECE• http://w3.unece.org/PXWeb2015/sq/f9fdd927-0af9-44d6-88d0-31120f9a62f3
• Population in Sweden by SCB• http://www.statistikdatabasen.scb.se/sq/5292
• A little of everything brougth to you by yours truly
samples – copy/paste links to www.stat.gl/demo
![Page 21: Greenlandic Summer 2015 PC-Axis International, Stockholm 2015Lars Pedersen](https://reader035.vdocuments.us/reader035/viewer/2022081506/5697c01d1a28abf838cd0652/html5/thumbnails/21.jpg)
• a learning ressource – open source• Free (MIT license)• Github (StatisticsGreenland)
• To allow it used on your site:– Fix ‘enable cross-origin resource sharing’– Enable ‘saved queries’– Enable ‘JSON-STAT format’
www.stat.gl/demo