HPD Affordable Housing Production Data

HPD reports on projects, buildings, and units that began after January 1, 2014, and are counted towards either the Housing New York plan (1/1/2014 – 12/31/2021) or the Housing Our Neighbors: A Blueprint for Housing & Homelessness plan (1/1/2022 – present). Complete info on data is available here.

General Notes

  • Available by project and by building  
    • building has bbls
    • project has program info
    • I’m joining project info to individual buildings
  • 8,108 building entries 1604 marked confidential - no location data
  • 3037 entries that overlap with our filtered DCP dataset
    • 2147 unique overlapping projects
      • ex: New Penn Development is a complex of 10 affordable housing buildings, so it has 10 entries in this dataset.
  • Filtering by new construction only  
    • (3,946/8,108)
      • 970/3,946 are marked confidential

Data

## [1] "Column Names:"
##  [1] "project_id"                       "project_name"                    
##  [3] "project_start_date"               "project_completion_date"         
##  [5] "building_id"                      "number"                          
##  [7] "street"                           "borough"                         
##  [9] "postcode"                         "bbl"                             
## [11] "bin"                              "community_board"                 
## [13] "council_district"                 "census_tract"                    
## [15] "nta_neighborhood_tabulation_area" "latitude"                        
## [17] "longitude"                        "latitude_internal"               
## [19] "longitude_internal"               "building_completion_date"        
## [21] "reporting_construction_type"      "extended_affordability_only"     
## [23] "prevailing_wage_status"           "extremely_low_income_units"      
## [25] "very_low_income_units"            "low_income_units"                
## [27] "moderate_income_units"            "middle_income_units"             
## [29] "other_income_units"               "studio_units"                    
## [31] "x1_br_units"                      "x2_br_units"                     
## [33] "x3_br_units"                      "x4_br_units"                     
## [35] "x5_br_units"                      "x6_br_units"                     
## [37] "unknown_br_units"                 "counted_rental_units"            
## [39] "counted_homeownership_units"      "all_counted_units"               
## [41] "total_units"
## [1] "Total Entries:"
## [1] 3946
## [1] "Entries Marked Confidential:"
## [1] 970

Mapping

You can click on points to bring up bbl and project name.

Program Analysis

It seems like the number of confidential program groups and NA tax benefits makes this dataset not very useful for program analysis.

Units by Program Group

Removed Confidential Entries (3,823,936/4,097,311)

## # A tibble: 4 × 3
##   program_group                  count total_units
##   <chr>                          <int>       <dbl>
## 1 Multifamily Incentives Program  2229       46357
## 2 CONFIDENTIAL                     970        1365
## 3 Multifamily Finance Program      553       59099
## 4 Small Homes Program              194        1365

Units by Tax Benefit

NAs removed (2,570,097 NAs out of 2,579,320)

## # A tibble: 8 × 3
##   planned_tax_benefit count total_units
##   <chr>               <int>       <dbl>
## 1 421a                 2186       42093
## 2 NA                   1056        6631
## 3 420c                  409       43648
## 4 UDAAP                 152         286
## 5 Article XI            133       14595
## 6 420a                    4         551
## 7 Article IV              4          41
## 8 467-m                   2         341

Units by Project

Confidential Removed, vast majority of units (3,823,936/4,097,311)

## # A tibble: 2,522 × 3
##    project_name                                      count total_units
##    <chr>                                             <int>       <dbl>
##  1 CONFIDENTIAL                                        970        1365
##  2 Nehemiah Spring Creek Homes at Gateway Estates 4A    83         110
##  3 SPRING CREEK PHASE 4C                                30         240
##  4 SPRING CREEK PHASE 4B-2                              21         240
##  5 SPRING CREEK PHASE 4B-1                              20         160
##  6 MOTHER GASTON-HINSDALE                               17          50
##  7 URBAN ECOSPACES                                      15          23
##  8 BLAKE/HENDRIX                                        13          30
##  9 MOSAIC                                               13          42
## 10 BED STUY CENTRAL AND NORTH PHASE I                   11          31
## # ℹ 2,512 more rows