Housing Database Project Level Files - Inactive Included by US Government | Demographics and Population Studies

About this Dataset

Housing Database Project Level Files - Inactive Included

The NYC Department of City Planning's (DCP) Housing Database contains all NYC Department of Buildings (DOB) approved housing construction and demolition jobs filed or completed in NYC since January 1, 2010. It includes the three primary construction job types that add or remove residential units: new buildings, major alterations, and demolitions, and can be used to determine the change in legal housing units across time and space. Records in the Housing Database Project-Level Files are geocoded to the greatest level of precision possible, subject to numerous quality assurance and control checks, recoded for usability, and joined to other housing data sources relevant to city planners and analysts. Data are updated semiannually, at the end of the second and fourth quarters of each year. Please see DCP's annual Housing Production Snapshot summarizing findings from the 21Q4 data release [here. Additional Housing and Economic analyses are also available. All previously released versions of this data are available at BYTES of the BIG APPLE - Archive.
Organization: City of New York
Last updated: 2024-05-24T20:40:29.737406
Tags: building, census-block, census-tract, certificate-of-occupancy, city-council-district, co, community-district, construction, development, dwelling-unit, filing, house, housing, job-application, net-units, nta, permit, pipeline, puma, unit-change

Tables

Table 1

@usgov.city_of_new_york_housing_database_project_level_files__56f5c80e.table_1

12.91 MB
103805 rows
64 columns


CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "job_number" VARCHAR,
  "job_type" VARCHAR,
  "residflag" VARCHAR,
  "nonresflag" VARCHAR,
  "job_status" VARCHAR,
  "compltyear" DOUBLE,
  "permityear" DOUBLE,
  "classainit" DOUBLE,
  "classaprop" DOUBLE,
  "classanet" DOUBLE,
  "hotelinit" DOUBLE,
  "hotelprop" DOUBLE,
  "otherbinit" DOUBLE,
  "otherbprop" DOUBLE,
  "units_co" DOUBLE,
  "boro" BIGINT,
  "bin" BIGINT,
  "bbl" BIGINT,
  "addressnum" VARCHAR,
  "addressst" VARCHAR,
  "occ_init" VARCHAR,
  "occ_prop" VARCHAR,
  "bldg_class" VARCHAR,
  "job_desc" VARCHAR,
  "datefiled" TIMESTAMP,
  "datepermit" TIMESTAMP,
  "datelstupd" TIMESTAMP,
  "datecomplt" TIMESTAMP,
  "zoningdst1" VARCHAR,
  "zoningdst2" VARCHAR,
  "zoningdst3" VARCHAR,
  "specldst1" VARCHAR,
  "specldst2" VARCHAR,
  "landmark" VARCHAR,
  "floorsinit" DOUBLE,
  "floorsprop" DOUBLE,
  "enlargemnt" VARCHAR,
  "ownership" VARCHAR,
  "cenblock20" DOUBLE,
  "centract20" DOUBLE,
  "bctcb2020" DOUBLE,
  "bct2020" DOUBLE,
  "nta2020" VARCHAR,
  "ntaname20" VARCHAR,
  "cdta2020" VARCHAR,
  "cdtaname20" VARCHAR,
  "commntydst" DOUBLE,
  "councildst" DOUBLE,
  "schsubdist" VARCHAR,
  "schcommnty" DOUBLE,
  "schelmntry" DOUBLE,
  "schmiddle" DOUBLE,
  "firecmpany" VARCHAR,
  "firebattln" DOUBLE,
  "firedivsn" DOUBLE,
  "policepcnt" DOUBLE,
  "pl_firm07" DOUBLE,
  "pl_pfirm15" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geomsource" VARCHAR,
  "dcpedited" VARCHAR,
  "version" VARCHAR
);