Economic Inclusion and Human Mobility in Bogotá

Download

Data and Code for the reproduction of the results in the paper: “Economic Inclusion and Human Mobility in Bogotá” by M. Coscia, F. Neffke, and R. Hausmann.

Folder “data” contains the raw data used for the analysis, namely:
– bogota_map.*: Shapefile of the city of Bogota.
– cell_attributes.csv: The attributes of the shapefile in CSV format without the geometry.
– cell_coordinates.csv: The coordinates of the towers in Bogota.
– dane_2011.csv: CSV file containing info about workers in Bogota from DANE’s Gran Encuesta de Hogares (aggregation of all 2011 months).
– encuesta_mob_2011.dta: Stata data file with the results of the public DANE Encuesta Mobilidad conducted in 2011.
– encuesta_trips.dta: Stata data file with all trip information from the public DANE Encuesta Mobilidad conducted in 2011.
– gmaps_traveltimes_driving.csv: CSV file containing the distance and car travel time between the centroid of each of the cells in which we divide the city.
– gmaps_traveltimes_driving.csv: CSV file containing the distance and public transit travel time between the centroid of each of the cells in which we divide the city.
– od_traveltimes.csv: CSV file containing the number of observed commuters for each pair of cells, as aggregated from CDR cellphone data.

The other folders contain the scripts to reproduce all the figures and tables. In particular:
– Most of the data analysis script (*.py) need to be run in Python (tested on Ubuntu 18.04.1, Python 3.6.5. Requires several libraries such as pandas, numpy, scipy, shapely, geopandas, etc).
– Most of the plots are generated using Gnuplot v5.2 (*.gp).
– The maps (*.qgs) are generated using the free software QGIS (version 2.18).

The scripts follow the naming convention XX_scriptname.extension. XX is a zero-padded numeral (e.g. “02”). Unless otherwise specified, the scripts need to be run in the order of their name. So always run the “01” script before attempting to run “02”. The folders are not standalone: each folder depends on the content of the “data” folder and/or the content generated in lowered-numbered folders (e.g. “fig2” depends on some of the calculations made in “fig1”).

Download