Buildings Subject To HPD Jurisdiction
City of New York
@usgov.city_of_new_york_buildings_subject_to_hpd_jurisdiction
City of New York
@usgov.city_of_new_york_buildings_subject_to_hpd_jurisdiction
Pursuant to New York City’s Housing Maintenance Code, the Department of Housing
Preservation and Development (HPD) collects information on multiple dwellings in New York
City, and other buildings that fall under its jurisdiction. HPD’s Buildings Open Data covers all
buildings which meet any of the following criteria:
a. HPD has required the owner to register the building under the Housing Maintenance
Code (HMC)
b. HPD has initiated a litigation action under the HMC
c. HPD has received a complaint for the building
d. HPD has initiated a work order for the purposes of emergency repair, demolition, or
the Alternative Enforcement Program (AEP) for the building
e. HPD has added the property to the AEP program
Buildings are identified by a BuildingID.
Organization: City of New York
Last updated: 2020-11-10T17:03:56.988071
Tags: buildings, department-of-housing-preservation-and-development, hpd
CREATE TABLE table_1 (
"buildingid" BIGINT,
"boroid" BIGINT,
"boro" VARCHAR,
"housenumber" VARCHAR,
"lowhousenumber" VARCHAR,
"highhousenumber" VARCHAR,
"streetname" VARCHAR,
"zip" DOUBLE,
"block" BIGINT,
"lot" BIGINT,
"bin" DOUBLE,
"communityboard" BIGINT,
"censustract" DOUBLE,
"managementprogram" VARCHAR,
"dobbuildingclassid" DOUBLE,
"dobbuildingclass" VARCHAR,
"legalstories" DOUBLE,
"legalclassa" DOUBLE,
"legalclassb" DOUBLE,
"registrationid" BIGINT,
"lifecycle" VARCHAR,
"recordstatusid" BIGINT,
"recordstatus" VARCHAR
);Anyone who has the link will be able to view this.