Skip to main content

database of nyc housing data

Project description

*****
NYCDB
*****

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:

.. code-block:: bash

pip3 install nycdb


You'll be able to use the program `nycdb` to import a database.


For example to load all of hpd violations:

.. code-block:: bash

nycdb --download hpd_violations
nycdb --load hpd_violations -P YOUR_PG_PASSWORD -D YOUR_DATABASE

To see all possible datasets:

.. code-block:: bash

nycdb --list-datasets


After a dataset has been loaded you can verify it with "--verify"

.. code-block:: bash

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`

Adding New Datasets
**********
[Guide Here](./ADDING_NEW_DATASETS.rst)

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

nycdb-0.1.15.tar.gz (14.4 kB view details)

Uploaded Source

Built Distribution

nycdb-0.1.15-py3-none-any.whl (33.9 kB view details)

Uploaded Python 3

File details

Details for the file nycdb-0.1.15.tar.gz.

File metadata

  • Download URL: nycdb-0.1.15.tar.gz
  • Upload date:
  • Size: 14.4 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.4.2 requests/2.21.0 setuptools/40.6.2 requests-toolbelt/0.8.0 tqdm/4.28.1 CPython/3.7.2rc1

File hashes

Hashes for nycdb-0.1.15.tar.gz
Algorithm Hash digest
SHA256 459cd1d751f33bea85151263ba3adfff96c5beb59b496e7cd7b36e916399ff55
MD5 b4642b84e9fb571e21f6db13add01efc
BLAKE2b-256 feefff0aabef58684c908a4ff7439eeced50de751fc5f224d9c81ee4ed06040a

See more details on using hashes here.

File details

Details for the file nycdb-0.1.15-py3-none-any.whl.

File metadata

  • Download URL: nycdb-0.1.15-py3-none-any.whl
  • Upload date:
  • Size: 33.9 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.4.2 requests/2.21.0 setuptools/40.6.2 requests-toolbelt/0.8.0 tqdm/4.28.1 CPython/3.7.2rc1

File hashes

Hashes for nycdb-0.1.15-py3-none-any.whl
Algorithm Hash digest
SHA256 32a89e667b901470621c6c8b1731b127abce0c95cbd3e0b1a74d8cdf053384ef
MD5 427b43586bc296eb4053b17a87518f19
BLAKE2b-256 ba426aeb86c3419147b823a5d766921ada692c434ef69f8af599f6fa67bd7749

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page