60 likes | 278 Views
Country report 2014 – Statistics Norway. PC-Axis Reference Group meeting 2014 bjarte.mellemstrand@ssb.no marianne.vik.dysterud@ssb.no. API datasets. Beta version launched June 2013 Selected data sets on fixed URIs (GET) Automatic update at publishing
E N D
Country report 2014 – Statistics Norway PC-Axis Reference Group meeting 2014 bjarte.mellemstrand@ssb.no marianne.vik.dysterud@ssb.no
API datasets • Beta versionlaunched June 2013 • Selected data setsonfixedURIs (GET) • Automatic update at publishing • Typicalusers: banks, newsagencies • Somecriteria for creatingdatasets: • Statbanktablesthatareoften used • Goodqualityon metadata • Long time series • Oftenpublished • Suitable for visualization • Currentlyabout180 API datasetshttp://www.ssb.no/en/omssb/tjenester-og-verktoy/api
API datasetexample • Savedqueryhttps://www.ssb.no/statistikkbanken/SelectVarVal/define.asp?MainTable=FolkemEttAarig&PLanguage=1&nvl=&Qid=2007810&QT=SD&FQ=1 • API datasethttp://data.ssb.no/api/v0/dataset/59322?lang=en • Formats: CSV and JSON-Stat • Visualizedpopulationpyramid http://www.ssb.no/en/befolkning/befolkningspyramide
Whyuse PX-web insteadofStatbank web? • Newertechnology • Components already in use (e.g. tablebuilder) • More intuitive interface (search, elimination) • Display NPM characters • Show hierarchy in code lists • Link betweentables • Clickablefootnotes • Mark periodswithspecialcharacters (CNMM 2.3) • List tablespublished for the first time (CNMM 2.3) • API for all tableswill be possible
PX-Web challenges • Upgrade to CNMM 2.3 • Migrateexistingsavedqueries • Link to metadata systems • Integration of Statbank tables and corresponding web articles • Ability to show groupings as integral values, not only aggregated • Button to select all contents in a table • Maps
Standard Statbank Load Utility New data trigger SDMX-OUT WS File description STATBANK Dataflow-ID SDMX-ml.xml SDMX2NSI Meta Data Sdmxquery Sdmx-ml.xml SDMX-RI eDAMIS WS Mapping store DSD.xml ESTAT