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

Making transparency in extractive industry readable.

Sergiu Nagailic / Nikro

About Me

Sergiu Nagailic

• From Moldova
• Digital Nomad: we travel a lot
• Contributor: Co-founded Drupal

Moldova Association

• Into Startups: Co-founded

MedicalTourism.Review ○ T: +(373) 692 73 293 ○ E: nikro.md@gmail.com ○ Tw: @nikro_md ○ W: http://nikro.me

About DG

Development Gateway

Tools and Technology

• Aid Management Program
• Tracking the SDGs
• Adaptive Management and M&E

Transparency and Data Use

• Linking IATI and AIMS
• Open Contracting and eProcurement
• Extractives Industries Transparency

Initiative Applied Research

• Results Data Initiative
• Open Contracting Readiness Assessments
• Tools for Adaptive Management
• Cities Alliance Data Toolkit Development

About EITI

Extractive Industry Transparency Initiative

The Extractive Industries Transparency Initiative (EITI) is a global standard to promote the

• pen and accountable management
• f oil, gas and mineral resources.
• 52 Implementing Countries
• 2.3 Trillions USD Revenues

Disclosed in EITI Reports

• 341 Fiscal Years covered by

EITI Reports

EITI pre-work technical overview

Technical

• Drupal 7 based website;
• Fairly simple structure (site-wise)

and good quality of the legacy-code;

• 130 contrib modules, 10 custom

modules used and 27 features.

General

• No dynamic elements;
• No layout flexibility;
• Reports used as spreadsheets

+ metadata;

• Data couldn’t be used in charts,

dynamic widgets, nor exported or re-used by other third parties.

EITI RFP - focus, target audience, vision & goals

Technical

• Develop a global EITI Data Portal;
• Make (spreadsheet) data readable,

analysable, researchable, understandable;

• Create dynamic country and thematic

pages;

• Create a dynamic layered maps;
• Create dynamic and static charts;
• Create an API for data reusability;

General

• Draw attention to the importance and

availability of extractives data at a country level;

• Make data available for analysis by

technical and non-technical users;

• Improve understanding of how natural

resource management benefits 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 EITI staff; 2. Restructure (normalize) the data

• keys, references, etc.

3. Come up with a set of custom entities with properties and fields.

Implementing Countries Summary Data Indicators Indicator Values Organization Revenue Stream GFS Codes

Implementation - extending migrate module

Migrate + Custom Plugins

Implementing Countries Summary Data Indicators Indicator Values Organization Revenue Stream GFS Codes

• Custom Migrations
• Custom Source
• Custom Destinations

Implementation - happy panels family

Panelizer Custom Ctools Content Types Fieldable Panel Panes Custom Fields - Content Widgets

Maps Visualizations (Charts) Bookmarks Facts Icon Blocks Comparison Tool Value Chain Header Tabs Embedded 3rd Parties

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

Result: 25+ Report Pages Created

Feature: Additional configurable widgets for Progress Reports.

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

Questions.