database of nyc housing data
Project description
a tool for building a database of NYC housing data
This is a Python library and cli tool for installing, updating and managing NYC-DB, a postgres database of Housing Data for NYC.
For more background information on this project, the api, and to download the full database dump see: https://github.com/aepyornis/nyc-db
How to use
Requirements: Postgres and Python3
After installing via pip:
pip3 install nycdb
You’ll be able to use the program nycdb to import a database.
For example to load all of hpd violations:
nycdb --download hpd_violations
nycdb --load hpd_violations -P YOUR_PG_PASSWORD -D YOUR_DATABASE
To see all possible datasets:
nycdb --list-datasets
After a dataset has been loaded you can verify it with “–verify”
nycdb --verify hpd_violations
nycdb --verify-all
By default the downloaded data files are stores in ‘./data’. Use –root-dir to change the location of the data directory.
To see more options run: nycdb –help
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.