Local Law 44 - Building
City of New York
@usgov.city_of_new_york_local_law_44_building
City of New York
@usgov.city_of_new_york_local_law_44_building
CREATE TABLE table_1 (
"projectid" BIGINT,
"buildingid" VARCHAR,
"reportingconstructiontype" VARCHAR,
"borough" VARCHAR,
"block" VARCHAR,
"lot" VARCHAR,
"bin" VARCHAR,
"housenumber" VARCHAR,
"streetname" VARCHAR,
"countedrentalunits" BIGINT,
"countedhomeownershipunits" BIGINT,
"allcountedunits" BIGINT,
"totalbuildingunits" BIGINT,
"basesquarefootage" DOUBLE,
"stories" VARCHAR,
"bbl" VARCHAR,
"community_board" VARCHAR,
"council_district" VARCHAR,
"census_tract" VARCHAR,
"nta" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"postcode" VARCHAR
);
Anyone who has the link will be able to view this.