/db-developments

🏠 🏘️ 🏗️ Developments Database

Primary LanguageShell

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
  1. Check connection (e.g. via database app like Postico)

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

  1. 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