Home

Welcome to the Magic Box wiki!

Magic Box serves various kinds of data aggregated by administrative boundaries. Currently available:

• Population
• Mosquito prevalence (aegypti and albopictus)
• Zika case data (weekly) for the Americas from Paho

Begin here by installing the API. It comes with test data, but you can continue with the instructions below to get most of the same data we use.

Download shapefiles from gadm.org

import_shapefiles_to_postgres

General Setup

vm

sudo apt-get update
ssh-keygen -t rsa

Installing GDAL/OGR on Ubuntu

sudo add-apt-repository ppa:ubuntugis/ppa && sudo apt-get update
sudo apt-get install gdal-bin

nvm

curl -o- https://raw.githubusercontent.com/creationix/nvm/v0.32.1/install.sh | bash

node

nvm install 6

java

sudo add-apt-repository -y ppa:webupd8team/java   
sudo apt-get update
sudo apt-get -y install oracle-java8-installer

Postgres

sudo apt-get update
sudo apt-get install postgresql postgresql-contrib
sudo apt-get install postgis*
sudo -i -u postgres
CREATE USER user_name SUPERUSER;

One time ingestion of administrative boundaries

Download shapefiles from gadm.org and import to postgres.

Aggregate population rasters by administrative boundaries

Downloads, imports, and aggregates country specific population rasters from worldpop.

Get zika cases from Paho

Calculate risk for zika

Need to update all repos below this point.

assign_admins_to_airports

• Assigns admin regions to airports
• by querying an api that takes lat/lon and returns an admin.
• Airport is then indexed by elasticsearch

Mobility

aggregate_airport_mobility_by_admin