db-developments

Processing DOB Job Application and Certificate of Occupancy data to identify jobs that will increase or decrease the number of units

Instructions

1. Create .env file and set environmental variables: RECIPE_ENGINE, BUILD_ENGINE, EDM_DATA

2. Start postgis docker container for local database:

docker run --name <custom_container_name> -e POSTGRES_PASSWORD=postgres -p 5432:5432 -d postgis/postgis

3. Check connection (e.g. via database app like Postico)

💡 Note: If failing to connect on mac, try brew services stop postgresql

4. Run scripts:

./bash/01_dataloading.sh
...

Development File Download

Note that these files are not official releases, they are provided for QAQC purposes only, for official releases, please checkout Bytes of the Big Apple

Main Tables

	Devdb	HousingDB
CSV	devdb.csv	housing.csv
Shapefile	devdb.shp.zip	housing.shp.zip

Aggregation Tables 2020 Geographies

block | tract | NTA | CDTA

Aggregation Tables 2010 Geographies

block | tract | commntydst | councildst | NTA

All files bundle.zip

Published Versions

20Q4

	HousingDB	Devdb
CSV	dcp_housing.csv	dcp_developments.csv
Zipped CSV	dcp_housing.csv	dcp_developments.csv.zip
Shapefile	dcp_housing.shp.zip	dcp_developments.shp.zip