New York City - Buildings Database

The PLUTO master record of buildings in New York City.

@kaggle.new_york_city_nyc_buildings

Table List

5 tables(52.7 MB)

Bx

@kaggle.new_york_city_nyc_buildings.bx

5.85 MB
89830 rows
84 columns

borough Borough	block Block	lot Lot	cd CD	ct2010 CT2010	cb2010 CB2010	schooldist SchoolDist	council Council	zipcode ZipCode	firecomp FireComp	policeprct PolicePrct	healtharea HealthArea	sanitboro SanitBoro	sanitdistrict SanitDistrict	sanitsub SanitSub	address Address	zonedist1 ZoneDist1	zonedist2 ZoneDist2	zonedist3 ZoneDist3	zonedist4 ZoneDist4	overlay1 Overlay1	overlay2 Overlay2	spdist1 SPDist1	splitzone SplitZone	bldgclass BldgClass	landuse LandUse	easements Easements	ownertype OwnerType	ownername OwnerName	lotarea LotArea	bldgarea BldgArea	comarea ComArea	resarea ResArea	officearea OfficeArea	retailarea RetailArea	strgearea StrgeArea	factryarea FactryArea	areasource AreaSource	numbldgs NumBldgs	numfloors NumFloors	unitsres UnitsRes	unitstotal UnitsTotal	lotfront LotFront	lotdepth LotDepth	bldgfront BldgFront	bldgdepth BldgDepth	ext Ext	irrlotcode IrrLotCode	lottype LotType	bsmtcode BsmtCode	assessland AssessLand	assesstot AssessTot	exemptland ExemptLand	exempttot ExemptTot	yearbuilt YearBuilt	yearalter1 YearAlter1	histdist HistDist	landmark Landmark	builtfar BuiltFAR	residfar ResidFAR	commfar CommFAR	facilfar FacilFAR	borocode BoroCode	bbl BBL	tract2010 Tract2010	xcoord XCoord	ycoord YCoord	zonemap ZoneMap	zmcode ZMCode	sanborn Sanborn	taxmap TaxMap	edesignum EDesigNum	appbbl APPBBL	appdate APPDate	plutomapid PLUTOMapID	version Version
BX	2260	1	201	19	1022	7	8	10454	L029	40	4700	2	1	2A	122 BRUCKNER BOULEVARD	M1-5/R8A	nan	nan	nan	nan	nan	MX-1	N	Z9			nan	122 BRUCKNER PARTNERS	15000								7	1				75	200			nan	N	3	5	130500	152100					nan	nan		6.02	5	6.5	2	2022600001	19	1005957	232162	6b	nan	209S016	20901	E-143			1	16V2
BX	2260	4	201	19	1022	7	8	10454	L029	40	4700	2	1	2A	126 BRUCKNER BOULEVARD	M1-5/R8A	nan	nan	nan	nan	nan	MX-1	N	G5	7		nan	24 INDIAN HEAD HOLDIN	13770	752	752		272		480		2	2	1		1	137.58	100	16	16	nan	N	5	5	117000	293850		18225	1931	1994	nan	nan	0.05	6.02	5	6.5	2	2022600004	19	1006076	232156	6b	nan	209S016	20901	E-143			1	16V2
BX	2260	10	201	19	1022	7	8	10454	L029	40	4700	2	1	2A	138 BRUCKNER BOULEVARD	M1-5/R8A	nan	nan	nan	nan	nan	MX-1	N	F9	6		P	ANJOST CORP	35000	39375	39375					39375	2	1	2		1	175	200	175	200	nan	N	4	5	153000	822150			1931		nan	nan	1.13	6.02	5	6.5	2	2022600010	19	1006187	232036	6b	nan	209S016	20901	E-143			1	16V2
BX	2260	17	201	19	1022	7	8	10454	L029	40	4700	2	1	2A	144 BRUCKNER BOULEVARD	M1-5/R8A	nan	nan	nan	nan	nan	MX-1	N	E9	6		nan	144 BRUCKNER LLC	2500	10625	10625			2125		8500	2	1	5		1	25	100	25	85	nan	N	5	5	33750	227250			1931	2001	nan	nan	4.25	6.02	5	6.5	2	2022600017	19	1006299	232033	6b	nan	209S016	20901	E-143			1	16V2
BX	2260	18	201	19	1022	7	8	10454	L029	40	4700	2	1	2A	148 BRUCKNER BOULEVARD	M1-5/R8A	nan	nan	nan	nan	nan	MX-1	N	C7	4		P	148 BRUCKNER LLC	1875	8595	1719	6876		1719			2	1	5	8	10	25	75	25	70	nan	N	3	2	17316	108227		44548	1920	2009	nan	nan	4.58	6.02	5	6.5	2	2022600018	19	1006363	232040	6b	nan	209S016	20901	E-143			1	16V2
BX	2260	19	201	19	1022	7	8	10454	L029	40	4700	2	1	2A	ST ANNS AVENUE	M1-5/R8A	nan	nan	nan	nan	nan	MX-1	N	G7	10		nan	138 BRUCKNER BLVD. AS	15625								7					175	100			nan	Y	3	5	147150	147150					nan	nan		6.02	5	6.5	2	2022600019	19	1006303	231950	6b	nan	209S016	20901	E-143	2022600019	Mon Dec 31 1990 00:00:00 GMT+0000 (Coordinated Universal Time)	1	16V2
BX	2260	34	201	19	1022	7	8	10454	L029	40	4700	2	1	2A	519 EAST 132 STREET	M1-5/R8A	nan	nan	nan	nan	nan	MX-1	N	E9	6		nan	122 BRUCKNER PARTNERS	8700	5316	5316				5316		2	2	1		2	87	100	32	100	E	N	5	5	39600	150750			1931		nan	nan	0.61	6.02	5	6.5	2	2022600034	19	1006046	232055	6b	nan	209S016	20901	E-143			1	16V2
BX	2260	38	201	19	1022	7	8	10454	L029	40	4700	2	1	2A	517 EAST 132 STREET	M1-5/R8A	nan	nan	nan	nan	nan	MX-1	N	F9	6		nan	122 BRUCKNER PARTNERS	5000	14550	14550				4850	9700	2	1	3		1	50	100	50	97	nan	N	5	5	21600	307800			1931		nan	nan	2.91	6.02	5	6.5	2	2022600038	19	1005986	232089	6b	nan	209S016	20901	E-143			1	16V2
BX	2260	52	201	19		7	8	10454	nan	40	4700			nan	LINCOLN AVENUE	M3-1	nan	nan	nan	nan	nan	nan	N	V9	11		C	NYC DSBS	4200								4					84	50			nan	Y	5	5	90000	90000	90000	90000			nan	nan			2		2	2022600052	19			6b	nan	nan		nan			2	16V2
BX	2260	62	201	19		7	8	10454	nan	40	4700			nan	EAST 132 STREET	M3-1	M1-5/R8A	nan	nan	nan	nan	MX-1	Y	U7	7	5	P	NYS DOT	1704700								7					877	263			nan	N	5	5							nan	nan			2		2	2022600062	19			6b	Y	209S016	20901	nan			1	16V2


CREATE TABLE bx (
  "borough" VARCHAR,
  "block" BIGINT,
  "lot" BIGINT,
  "cd" BIGINT,
  "ct2010" DOUBLE,
  "cb2010" DOUBLE,
  "schooldist" DOUBLE,
  "council" DOUBLE,
  "zipcode" DOUBLE,
  "firecomp" VARCHAR,
  "policeprct" DOUBLE,
  "healtharea" DOUBLE,
  "sanitboro" DOUBLE,
  "sanitdistrict" DOUBLE,
  "sanitsub" VARCHAR,
  "address" VARCHAR,
  "zonedist1" VARCHAR,
  "zonedist2" VARCHAR,
  "zonedist3" VARCHAR,
  "zonedist4" VARCHAR,
  "overlay1" VARCHAR,
  "overlay2" VARCHAR,
  "spdist1" VARCHAR,
  "spdist2" VARCHAR,
  "spdist3" VARCHAR,
  "ltdheight" VARCHAR,
  "splitzone" VARCHAR,
  "bldgclass" VARCHAR,
  "landuse" DOUBLE,
  "easements" BIGINT,
  "ownertype" VARCHAR,
  "ownername" VARCHAR,
  "lotarea" BIGINT,
  "bldgarea" BIGINT,
  "comarea" BIGINT,
  "resarea" BIGINT,
  "officearea" BIGINT,
  "retailarea" BIGINT,
  "garagearea" BIGINT,
  "strgearea" BIGINT,
  "factryarea" BIGINT,
  "otherarea" BIGINT,
  "areasource" BIGINT,
  "numbldgs" BIGINT,
  "numfloors" DOUBLE,
  "unitsres" BIGINT,
  "unitstotal" BIGINT,
  "lotfront" DOUBLE,
  "lotdepth" DOUBLE,
  "bldgfront" DOUBLE,
  "bldgdepth" DOUBLE,
  "ext" VARCHAR,
  "proxcode" DOUBLE,
  "irrlotcode" VARCHAR,
  "lottype" DOUBLE,
  "bsmtcode" DOUBLE,
  "assessland" DOUBLE,
  "assesstot" DOUBLE,
  "exemptland" DOUBLE,
  "exempttot" DOUBLE,
  "yearbuilt" BIGINT,
  "yearalter1" BIGINT,
  "yearalter2" BIGINT,
  "histdist" VARCHAR,
  "landmark" VARCHAR,
  "builtfar" DOUBLE,
  "residfar" DOUBLE,
  "commfar" DOUBLE,
  "facilfar" DOUBLE,
  "borocode" BIGINT,
  "bbl" DOUBLE,
  "condono" BIGINT,
  "tract2010" BIGINT,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "zonemap" VARCHAR,
  "zmcode" VARCHAR,
  "sanborn" VARCHAR,
  "taxmap" DOUBLE,
  "edesignum" VARCHAR,
  "appbbl" DOUBLE,
  "appdate" TIMESTAMP,
  "plutomapid" BIGINT,
  "version" VARCHAR
);