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
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.