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)
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
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.
Source Distribution
nycdb-0.1.15.tar.gz
(14.4 kB
view details)
Built Distribution
nycdb-0.1.15-py3-none-any.whl
(33.9 kB
view details)
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
Algorithm | Hash digest | |
---|---|---|
SHA256 | 459cd1d751f33bea85151263ba3adfff96c5beb59b496e7cd7b36e916399ff55 |
|
MD5 | b4642b84e9fb571e21f6db13add01efc |
|
BLAKE2b-256 | feefff0aabef58684c908a4ff7439eeced50de751fc5f224d9c81ee4ed06040a |
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
Algorithm | Hash digest | |
---|---|---|
SHA256 | 32a89e667b901470621c6c8b1731b127abce0c95cbd3e0b1a74d8cdf053384ef |
|
MD5 | 427b43586bc296eb4053b17a87518f19 |
|
BLAKE2b-256 | ba426aeb86c3419147b823a5d766921ada692c434ef69f8af599f6fa67bd7749 |