Building an SDG Dashboard using Drupal and .Stat Suite

1. Building an SDG Dashboard using Drupal and .Stat Suite SIS-CC Guiding principle #1: component based

2. SPC overview • The Pacific Community (SPC) is the principal scientific and technical organisation in the Pacific region. • Started in 1947. • International development organisation owned and governed by 26 country and territory members (provide support to 22 of them) • Covers more than 20 sectors. • Renowned for knowledge and innovation in such areas as fisheries science, public health surveillance, geoscience, conservation of plant genetic resources for food security, and statistics for development.

3. SUSTAINABLE DEVELOPMENT GOALS In 2015 world leaders adopted 17 development goals that focus on ending all forms of poverty, fighting inequalities and tackling climate change, while ensuring that no one is left behind.

4. PACIFIC SDG TASKFORCE ESTABLISHED Chaired by PIFS, comprised of CROP, UN, PICTs, DFAT/MFAT, USP. 2016 Sdg timeline in the pacific BETA SDG DASHBOARD RELEASED SPC publish SDG indicators on behalf of PICTs Regional Report presented at HLPF Pacific SDG Steering Committee (SPC is the CROP rep) 5 PICTs SUBMIT VNR PACIFIC SD ROADMAP ENDORSED Forum Leaders endorse Roadmap including set of 132 regional indicators 2019 2017 SAMOA SUBMITS VNR 2020 2018 5 more PICTs SUBMIT VNR SDG Dashboard updated UN review of indicators 2015 1st QUADRENNIAL REGIONAL REPORT Prepared by smaller SDG Working Group PIFS, SPC, UNESCAP, UNDP KIRIBATI SUBMIT VNR SPC JOINS SIS-CC ADOPTION Forum Leaders commit to the 2030 Agenda

5. Pacific sdgS Almost 50% of the 132 SDG indicators for the Pacific are currently not measurable due to a lack of data.

6. Now Loaded into .stat v8 using SDG DSD Previously Series of Excel spreadsheets Pacific sdgs

7. PACIFIC Sdg DSD + dataset structure • Extensive collaboration/cooperation between OECD and SPC with OECD making several visits to Noumea to provide assistance. • OECD Statistician worked closely with SPC SDG expert in understanding the indicators, including data cleaning and harmonisation – coverage 16 Pacific States • IAEG-SDGs DSD has 32 Concepts (16 Dimensions, 15 Attributes) – SPC DSD entirely consistent with official DSD but ‘trimmed’ for ease of use; 19 Concepts (13 Dimensions, 5 Attributes) • Ongoing ‘discussions’ with IAEG: reporting of ‘bugs’, inconsistencies, dimension/attribute queries, extension of Codelists, etc. • .Stat Suite Basecamp for Data Producers on Day 3 is all about modelling and disseminating SDG indicators in the .Stat Suite and will discuss the SPC DSD in more depth.

9. Pacific data hub

10. Sdgdashboard

11. Sdgdashboard

12. Drupal: Create entity Drupal: Show data .Stat : create query Define parameters Dotstat – drupalintegration

13. Full JSON from .Stat (extract) Parameters used to parse JSON Parsed results stored in Drupal "dataSets": [ { "action": "Information", "annotations": [], "observations": { "0:0:0:0:0:0:0:0:0:0:0:0:0": [ 102, 0, 0, 0, 0, 0 ], "0:0:1:0:0:0:0:0:0:0:0:0:0": [ 105, 1, 0, 1, 0, 0 ] } ], ... "structure": { "dimensions": { "observation": [ { "id": "FREQ", "name": "Frequency", "keyPosition": 0, "values": [ { "id": "A", "name": "Annual" }, ... ] }, ... ], ... Dotstat – drupalintegration { "AS": { "country":"American Samoa", "year":"2018", "value":56700 }, "CK":{ "country":"Cook Islands", "year":"2018", "value":15200 }, "FJ":{ "country":"Fiji", "year":"2018", "value":888400 }, "PF":{ "country":"French Polynesia“, "year":"2018", "value":277100 }, ... } { "index": "dim[2].id", "country": "dim[2].name", "year": "dim[4].name", "value": "val[0]" }

14. Drupal block parameters Drupal entity Dotstat – drupalintegration : Key STATS

15. Drupal block parameters Dotstat – drupalintegration : Chart

16. SDD Beta website • Will be data-driven from dotStat API

17. SDD Beta website • Will be data-driven from dotStat API Coming soon!