The Atlas is a site housing The Observatory, the master's thesis work of Alexander Simoes. This Observatory is a tool that allows users to quickly compose a visual narrative about countries and the products they exchange.
The observatory provides access to bilateral trade data for roughly 200 countries, 50 years and 1000 different products of the SITC4 revision 2 classification. The source of the data we are using is:
1962 - 2000
The Center for International Data from Robert Feenstra
2001 - 2009
The Observatory will run in all modern browsers so long as they have Javascript turned on and have full support for SVG graphics. This includes the latest versions of Firefox, Chrome (Chromium), Safari (WebKit), Opera and IE.
Note: Internet Explorer versions 8 and below will not work as they do not have SVG support built in.
Adding the Observatory to computer via virtualenv
-
Clone from github (this will create an oec folder in the current directory)
git clone https://github.com/alexandersimoes/oec.git -
Create the virtual environment
virtualenv oec -
Activate this newly created environment
. /path/to/oec/bin/activate -
Install required software
mysql # if using homebrew, not install ONLY the client brew install mysql --client-only --universal -
Install the required Python libraries
pip install -r requirements.txt -
Create a MySQL database on your local machine
-
Import the latest dump of the database from 18.85.28.32/static/db/ (warning this step could take hours!)
mysql -u username -p -h localhost DB_NAME < oec_xxxx-xx-xx.sql -
Be sure to create the following local environment variables
export OEC_SECRET_KEY=some_s3cret_k3y export OEC_DB_USER=my_db_username export OEC_DB_PW=my_db_password export OEC_DB_HOST=localhost export OEC_DB_NAME=oec * export CACHE_DIR=/home/ * only necessary if using filesystem caching -
Updating translations (if something is changed)
pybabel extract -F babel.cfg -o messages.pot oec --no-location --omit-header --no-wrap pybabel update -i messages.pot -d oec/translations --no-wrap --no-fuzzy-matching -l [2-LETTER-LANG-CODE] pybabel compile -d oec/translations -l [2-LETTER-LANG-CODE] --statistics -
Running the testing server
python run.py runserver
$ sudo apt-get install python-virtualenv python-pip git libmysqlclient-dev python-dev
$ virtualenv oec
$ source oec/bin/activate
$ git clone https://github.com/alexandersimoes/oec.git -b v3.0 —-single-branch
$ pip install -r requirements.txt
$ pip install gunicorn
export OEC_SECRET_KEY=yet_another_supers3cret_k35y
export OEC_DB_USER=oec_user
export OEC_DB_PW=oec_pw
export OEC_DB_HOST=localhost
export OEC_DB_NAME=oec
export CACHE_DIR=/home/macro/sites/oec/cache
export OEC_PRODUCTION=1
$ mkdir /home/macro/sites/oec/cache
$ sudo nano /etc/nginx/sites-available/oec.conf
server {
listen 80;
server_name 104.239.233.5;
root /home/macro/sites/oec;
access_log /home/macro/sites/oec/logs/access.log;
error_log /home/macro/sites/oec/logs/error.log;
location / {
proxy_set_header X-Forward-For $proxy_add_x_forwarded_for;
proxy_set_header Host $http_host;
proxy_redirect off;
if (!-f $request_filename) {
proxy_pass http://127.0.0.1:8000;
break;
}
}
}
$ sudo ln -s /etc/nginx/sites-available/oec.conf /etc/nginx/sites-enabled/
$ mkdir /home/macro/sites/oec/logs
$ sudo nginx -t
sudo apt-get install supervisor
$ sudo nano /etc/supervisor/conf.d/oec.conf
[program:oec]
command = /home/macro/venv/oec/bin/gunicorn oec:app
directory = /home/macro/sites/oec
user = macro
stdout_logfile = /home/macro/sites/oec/logs/gunicorn.log
redirect_stderr = true
environment=PATH="/home/macro/venv/oec/bin", OEC_SECRET_KEY="oec-secret-key", OEC_DB_USER="oec_user", OEC_DB_PW="oec_pw", OEC_DB_HOST="localhost", OEC_DB_NAME="oec", CACHE_DIR="/home/macro/sites/oec/cache", OEC_PRODUCTION="1"
$ sudo supervisorctl reread
$ sudo supervisorctl update
$ sudo supervisorctl status oec
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent
