A database of the built environment in Chicago using open data, forked from Edifice
Installation and dependencies
- PostgreSQL (9.0.x or later; 9.1.x+ preferred)
- PostGIS (2.0.x or later)
- Python (2.7.x or later)
pip install -r requirements.txt
easy_install wget easy_install psycopg2 easy_install PyYAML
Copy over the example setup.cfg:
cp setup.cfg.example setup.cfg
setup_benefice.py is used to recreate the benefice database on a system with a PostgreSQL database installed (with PostGIS 2.0.x+ support).
Drop and recreate from scratch a
base_postgis template database, using the 'postgres' admin user.
python setup_benefice.py --create_template
Drop and recreate from scratch an
benefice database struture, using the 'benefice' user.
python setup_benefice.py --create
Download (~165mb), unzip, and import City of Chicago data into the
benefice database. [NOTE: WORK IN PROGRESS]
python setup_benefice.py --data
--bindir [DIRNAME]: specify the location of PostgreSQL binaries such as pg_config, psql, etc.
--user [USERNAME]: use a username other than 'benefice' as the owner of the main database.
--database [DBNAME]: use a name other than 'benefice' for the main database.
--delete_downloads: delete downloaded zip and csv files after import
--help: provide usage info
QGIS and TileMill
Once you are done setting up your Benefice database, you can use the following tools (including psql) to explore the datasets.