Making transparency in extractive industry readable . Sergiu - PowerPoint PPT Presentation

Making transparency in extractive industry readable . Sergiu Nagailic / Nikro

● From Moldova ● Digital Nomad: we travel a lot ● Contributor: Co-founded Drupal Moldova Association ● Into Startups: Co-founded About Me MedicalTourism.Review Sergiu Nagailic ○ T: +(373) 692 73 293 ○ E: nikro.md@gmail.com ○ Tw: @nikro_md ○ W: http://nikro.me

Tools and Technology ● Aid Management Program ● Tracking the SDGs ● Adaptive Management and M&E Transparency and Data Use About DG ● Linking IATI and AIMS ● Open Contracting and eProcurement ● Extractives Industries Transparency Initiative Development Gateway Applied Research ● Results Data Initiative ● Open Contracting Readiness Assessments ● Tools for Adaptive Management ● Cities Alliance Data Toolkit Development

The Extractive Industries Transparency Initiative (EITI) is a global standard to promote the open and accountable management About EITI of oil, gas and mineral resources. ● 52 Implementing Countries Extractive Industry ● 2.3 Trillions USD Revenues Disclosed in EITI Reports Transparency Initiative ● 341 Fiscal Years covered by EITI Reports

EITI pre-work technical overview Technical General ● Drupal 7 based website; ● No dynamic elements; ● Fairly simple structure (site-wise) ● No layout flexibility; and good quality of the ● Reports used as spreadsheets legacy-code; + metadata; ● 130 contrib modules, 10 custom ● Data couldn’t be used in charts, modules used and 27 features. dynamic widgets, nor exported or re-used by other third parties.

EITI RFP - focus, target audience, vision & goals Technical General ● Develop a global EITI Data Portal; ● Draw attention to the importance and ● Make (spreadsheet) data readable, availability of extractives data at a country analysable, researchable, understandable; level; ● Create dynamic country and thematic ● Make data available for analysis by pages ; technical and non-technical users; ● Create a dynamic layered maps ; ● Improve understanding of how natural ● Create dynamic and static charts ; resource management benefits ● Create an API for data reusability; sustainable development; ● Provide guidance to countries that are considering adoption of the EITI Standard.

EITI RFP - focus, target audience, vision & goals { API } Charts Dynamic Pages Maps

Implementation - general overview ● Data was analyzed, broken down into a bunch of custom entities ; ● Portal relies on custom ctools content types, custom fields, fieldable panel panes ; ● Migrated the data from legacy D7 to D7; ● Used Migrate module to import spreadsheet data; ● Charts and Maps are using custom React-based JS libs fed by the API data; ● 71 contrib modules, 22 custom modules, 24 features.

Implementation - data & custom entities 1. Analyze the data - together with Implementing Summary EITI staff; Countries Data 2. Restructure (normalize) the data Indicator Indicators - keys, references, etc. Values 3. Come up with a set of custom Organization GFS Codes entities with properties and fields. Revenue Stream

Implementation - extending migrate module Implementing Summary Countries Data Migrate Indicator + Indicators Values Custom Plugins Organization GFS Codes Revenue Stream ● Custom Migrations ● Custom Source ● Custom Destinations

Implementation - happy panels family Embedded 3rd Parties Custom Fields - Panelizer Content Widgets Tabs Custom Ctools Fieldable Panel Content Types Panes Header Value Chain Visualizations Icon Maps Bookmarks Facts Comparison Tool (Charts) Blocks

Let’s see what we ended up with.

Samples: ● Dynamic Page - Homepage - https://eiti.org/ ● Custom Page - Map - https://eiti.org/countries ● Dynamic Page - Data - https://eiti.org/data ● Dynamic Page - About - https://eiti.org/who-we-are ● Country Page - Peru - https://eiti.org/peru ● Country Page - Mongolia - https://eiti.org/mongolia ● Country Page - USA - https://eiti.org/united-states-america

Feature: Additional configurable widgets for Progress Reports. Result: 25+ Report Pages Created

Happy Client. More Transparency. Readable Data. Bigger Impact.

Questions.