Icon for Socrata external plugin
  • buildings_selected_for_the_underlying_conditions
Updated 12 days ago
Indexed 6 hours ago

Buildings Selected for the Underlying Conditions Program

Each year, the Department of Housing Preservation and Development (HPD) designates buildings for participation in the Underlying Conditions Program (Local Law 6 of 2013). These buildings are selected based on the number and severity of class "B" and "C" violations related to the presence of mold or water leaks issued by HPD within the past year and an inspection is attempted to verify conditions before the order is issued.


NameSocrata field nameColumn name in sgr mountData typeDescription
ORDER_ISSUE_DATEorder_issue_dateorder_issue_dateCalendar dateThe date the building was issued an Underlying Conditions Order.
TOTAL_UNITStotal_unitstotal_unitsNumberTotal Units reflects the number of units in the building as of the report run date and may vary from the unit count reported when the building was selected for the Underlying Conditions program. HPD records indicated that all the buildings had at least three dwelling units at the time of selection.
CURRENT_STATUScurrent_statuscurrent_statusText"Active" buildings are currently participating in program. "Discharged" buildings have met a statutory requirement for removal from the program.
COUNCIL DISTRICTcouncil_districtcouncil_districtNumber
CENSUS TRACTcensus_tractcensus_tractNumber
COMMUNITY BOARDcommunity_boardcommunity_boardNumber
STREETstreet_namestreet_nameTextThe Street Name is the name of the street in the building's address. E.g, the street name is 'Gold Street' in '100 Gold Street.'
Number (PHN)phnphnTextPHN stands for Primary House Number. PHN is the street number in the building's address. E.g, the house number is '100' in '100 Gold Street.'
BUILDING_IDbuilding_idbuilding_idNumberThe Building ID is a unique numeric identifier assigned to each building by HPD.
BOROboroboroTextThe Borough is the borough where the building is located.
Upstream Metadata