ANCIR/mozambique

Who are the people behind the mining industry in Mozambique? A partial answer can be found by connecting minerals concessions to the people who control the licensed exploration and mining companies. Accessible at: ancir.github.io # Mozambique Extractives / PEP Project This project aims to perform data anlysis on an integrated dataset of company information, extractives concessions data and a set of politically exposed persons (PEPs). The goal is to find conflicts of interest and linkages between PEPs and mining/drilling rights. ## Data Sources The data is partially extracted from public sources, from semi-public data sources and from manually conducted research by CIP. ### FlexiCadastre The ``flexicadastre_scrape.py`` and ``flexicadastre_parse.py`` scripts are importers for FlexiCadastre, a GIS solution developed by SpatialDimension and used to store extractives licensing info for a variety of countries. ### Hermes Pandoras Box Hermes is an effort to extract structured data from bulletins released as Part III of the official gazette of Mozambique. The data holds information on companies registered in the country since the late seventies, as well as associated personalities. It is unclear if a) the data is complete and verified, and b) this dataset if considered an official release by the Government of Mozambique. ### Politically Exposed Persons This dataset is manually curated by researchers at CIP. It lists key personel in top positions of government and FRELIMO. The tabular layout is inspired by the Popolo data standard. ### Boletin The scraper for the public section of the Mozambican government gazette will download all published PDF files that form Part III. Documents will also be uploaded to sourceAFRICA automatically, if the necessary credentials are provided. ## Setup and configuration All ETL scripts in this package are geared towards generating tables in a SQL database. Many of them will only work when used against PostgreSQL 9.3 or later (i.e. with support for the ``LEVENSHTEIN()`` function). Your database should be created with the UTF-8 encoding, e.g. with the command: ```bash $ createdb -E utf-8 mozambique ``` Before running any of the scripts, make sure to set th …