Housing Database

 All DCP Housing Database Files
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 all three 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 Database 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.

Please see DCP’s Info Brief summarizing findings from the 20Q2 data release here. Additional Housing and Economic analyses are also available.

DOB Open Data are the primary source for the NYC Department of City Planning’s (DCP) Housing Database, and despite efforts DCP makes to correct errors, there are still unknown inaccuracies throughout the data. The data are administrative in nature, and most of the information associated with a record is provided by the applicant, and not necessarily verified by DCP.

The DCP Housing Database is based on DOB Open Data to identify housing construction. However, not all construction in NYC occurs legally by approval through the DOB. Illegal conversions of the housing stock may be prevalent in certain neighborhoods but are not represented in this data.

DCP uses information such as job description, occupancy codes, and unit change to differentiate hotels and class B units from class A housing units. However, there may be hotels and class B units that DCP could not identify using these means.

PROJECT LEVEL FILES

Release 20Q2 Download
ESRI Shapefiles Download
ESRI File Geodatabase Download
CSV Download

The NYC Department of City Planning’s (DCP) Housing Database Project-Level Files contain all NYC Department of Buildings (DOB)-approved housing construction and demolition jobs filed or completed in NYC since January 1, 2010. It includes all three 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 Database 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.

Project Level Files Read Me
Project Level Files Data Dictionary

Individual Features
File Name Name Description    REST GeoJSON CSVShapefile
HousingDB
_post2010
HousingDB Post-2010

Data for all active new buildings, demolitions, and major alterations involving housing units in NYC since 2010.

Link to NYC Zoning Districts REST Feature Service Link to NYC Zoning Districts GeoJSON Download Download

HousingDB
_post2010_
completed_jobs

HousingDB Post-2010 Completed Jobs

Data for all completed new buildings, demolitions, and major alterations involving housing units in NYC that received a first CO since 2010.

Link to NYC Commercial Overlay District REST Feature Service Link to NYC Commercial Overlay District GeoJSON Download Download
HousingDB
_post2010_
incomplete_jobs
HousingDB Post-2010 Incomplete Jobs

Data for all active, incomplete new buildings, demolitions, and major alterations involving housing units in NYC.

Link to NYC Special Purpose Districts (Zoning) REST Feature Service Link to NYC Special Purpose Districts (Zoning) GeoJSON Download Download
HousingDB
_post2010_
inactive_jobs
HousingDB Post-2010 Inactive Jobs

Data for all withdrawn, stalled, or duplicate new buildings, demolitions, and major alterations involving housing units in NYC. Stalled projects are defined by DCP as those that have not had any status updates within three years of the data vintage date.

Link to NYC Limited Height Districts (Zoning) REST Feature Service Link to NYC Limited Height Districts (Zoning) GeoJSON Download Download
HousingDB
_post2010 (inactives included)
HousingDB Post-2010 (Inactives Included)

Data for all new buildings, demolitions, and major alterations involving housing units in NYC since 2010, including inactive projects.

Link to NYC Special Purpose Districts With Subdistricts (Zoning) REST Feature Service Link to NYC Special Purpose Districts With Subdistricts (Zoning) GeoJSON Download Download

UNIT CHANGE SUMMARY FILES

The NYC Department of City Planning’s (DCP) Housing Database Unit Change Summary Files provide the 2010 census count of housing units, the net change in Class A housing units since the census, and the count of units pending completion for commonly used political and statistical boundaries. These tables are aggregated from the DCP Housing Database Project-Level Files, which is derived from Department of Buildings (DOB)-approved housing construction and demolition jobs filed or completed in NYC since January 1, 2010. Net housing unit change is calculated as the sum of all three construction job types that add or remove residential units: new buildings, major alterations, and demolitions. These files can be used to determine the change in legal housing units across time and space.

Unit Change Summary File Read Me
Unit Change Summary File Data Dictionary

Individual Features
File Name Name    REST GeoJSON CSVShapefile
HousingDB
_by_CensusBlock
Census Block Unit Change Summary File Link to NYC Zoning Districts REST Feature Service Link to NYC Zoning Districts GeoJSON Download Download
HousingDB
_by_CensusTract
Census Tract Unit Change Summary File Link to NYC Commercial Overlay District REST Feature Service Link to NYC Commercial Overlay District GeoJSON Download Download
HousingDB_by_NTA Neighborhood Tabulation Area (NTA) Unit Change Summary File Link to NYC Special Purpose Districts (Zoning) REST Feature Service Link to NYC Special Purpose Districts (Zoning) GeoJSON Download Download
HousingDB_by_PUMA Public Use Microdata Area (PUMA) Unit Change Summary File Link to NYC Limited Height Districts (Zoning) REST Feature Service Link to NYC Limited Height Districts (Zoning) GeoJSON Download Download
HousingDB_by
_CommunityDistrict
Community District Unit Change Summary File Link to NYC Special Purpose Districts With Subdistricts (Zoning) REST Feature Service Link to NYC Special Purpose Districts With Subdistricts (Zoning) GeoJSON Download Download
HousingDB_by
_ CityCouncilDistrict
City Council District Unit Change Summary File Link to NYC Special Purpose Districts With Subdistricts (Zoning) REST Feature Service Link to NYC Special Purpose Districts With Subdistricts (Zoning) GeoJSON Download Download