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)

Bk

@kaggle.new_york_city_nyc_buildings.bk

16.51 MB
277131 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	spdist2 SPDist2	spdist3 SPDist3	ltdheight LtdHeight	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	otherarea OtherArea	areasource AreaSource	numbldgs NumBldgs	numfloors NumFloors	unitsres UnitsRes	unitstotal UnitsTotal	lotfront LotFront	lotdepth LotDepth	bldgfront BldgFront	bldgdepth BldgDepth	ext Ext	proxcode ProxCode	irrlotcode IrrLotCode	lottype LotType	bsmtcode BsmtCode	assessland AssessLand	assesstot AssessTot	exemptland ExemptLand	exempttot ExemptTot	yearbuilt YearBuilt	yearalter1 YearAlter1	yearalter2 YearAlter2	histdist HistDist	landmark Landmark	builtfar BuiltFAR	residfar ResidFAR	commfar CommFAR	facilfar FacilFAR	borocode BoroCode	bbl BBL	condono CondoNo	tract2010 Tract2010	xcoord XCoord	ycoord YCoord	zonemap ZoneMap	zmcode ZMCode	sanborn Sanborn	taxmap TaxMap	edesignum EDesigNum	appbbl APPBBL	appdate APPDate	plutomapid PLUTOMapID	version Version
BK	1	1	302	21		13	33	11201	L118	84	1000	3	2	1B	JOHN STREET	M3-1	M1-4/R8A	nan	nan	nan	nan	MX-2	nan	nan	nan	Y	V1	11	1	P	BROOKLYN BRIDGE PARK	151930								4					206.25	337.42			nan		Y	5	5	1164645	1164645						DUMBO Historic District	nan			2		3	3000010001		21			12d	nan	302 007	30101	nan	3000010001	Tue Nov 26 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	1	16V2
BK	1	50	302	21	2000	13	33	11201	L118	84	1000	3	2	1B	10 JAY STREET	M1-4/R8A	M3-1	nan	nan	nan	nan	MX-2	nan	nan	nan	Y	E9	6		nan	SAFDI PLAZA REALTY IN	19682	154400	154400		17160		68620	68620	2	1	9		90	109.08	207.25	88	195	nan	1	Y	3		834300	12019950		290250	1920	1994	2007	DUMBO Historic District	nan	7.84	5.4	2	6.5	3	3000010050		21	987838	195989	12d	nan	302 007	30101	E-231			1	16V2
BK	1	7501	302	21	2000	13	33	11201	L118	84	1000	1	2	nan	1 JOHN STREET	M3-1	nan	nan	nan	nan	nan	nan	nan	nan	nan	N	RM	4	1	nan	nan		102534	4686	97848		4686			7	1	12	42	44					nan		N		5	389696	5864853						nan	nan			2		3	3000017501	3819	21	987624	195992	12d	nan	302 007	30101	nan	3000010002	Fri Mar 04 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	1	16V2
BK	3	1	302	21	3002	13	33	11201	L118	84	1000	3	2	1B	JAY STREET	M3-1	nan	nan	nan	nan	nan	nan	nan	nan	nan	N	U4	7	1	nan	CONSOLIDED EDISON CO/	387060								7	15				1051	469			nan		Y	5	5								nan	nan			2		3	3000030001		21	988568	196151	12d	nan	302 007	30101	nan			1	16V2
BK	3	5	302	21		13	33	11201	L118	84	1000	3	2	1B	JAY STREET	M3-1	nan	nan	nan	nan	nan	nan	nan	nan	nan	N	T2	7		C	NYC DSBS	6384								7									nan		N	5	5	21150	21150	21150	21150				DUMBO Historic District	nan			2		3	3000030005		21			12d	nan	302 007	30101	nan			4	16V2
BK	3	35	302	21		13	33	11201	L118	84	1000	3	2	1B	GOLD STREET	M3-1	nan	nan	nan	nan	nan	nan	nan	nan	nan	N	T2	7		C	NYC DSBS									7									nan		N	5	5	1800	1800	1800	1800				nan	nan			2		3	3000030035		21			nan	nan	302 007	30101	nan			2	16V2
BK	5	1	302	21	3001	13	33	11201	L118	84	1000	3	2	1B	135 MARSHALL STREET	M3-1	nan	nan	nan	nan	nan	nan	nan	nan	nan	N	U2	7		nan	CONSOLIDED EDISON CO/									7	4				363.25	346			nan		Y	3	5								nan	nan			2		3	3000050001		21	989346	196266	12d	nan	302 008	30101	nan			1	16V2
BK	5	8	302	21		13	33	11201	L118	84	1000	3	2	1B	GOLD STREET	M3-1	nan	nan	nan	nan	nan	nan	nan	nan	nan	N	T2	7		C	NYC DSBS									7									nan		N	5	5	1800	1800	1800	1800				nan	nan			2		3	3000050008		21			12d	nan	300 000	30101	nan			4	16V2
BK	6	1	302	21	3000	13	33	11201	E207	84	1000	3	2	1B	1 HUDSON AVENUE	M3-1	nan	nan	nan	nan	nan	nan	nan	nan	nan	N	U2	7	1	P	CONSOLIDATED EDISON C	323307								7	15				302.92	657			nan		Y	3	5								nan	nan			2		3	3000060001		21	989745	196040	12d	nan	302 009	30101	nan			1	16V2
BK	6	10	302	21		13	33	11201	E207	84	1000	3	2	1B	HUDSON AVENUE	M3-1	nan	nan	nan	nan	nan	nan	nan	nan	nan	N	T2	7		C	NYC DSBS	66889								7					60	538			nan		Y	5	5	11700	11700	11700	11700				nan	nan			2		3	3000060010		21			12d	nan	302 009	30101	nan			1	16V2


CREATE TABLE bk (
  "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" BIGINT,
  "assesstot" BIGINT,
  "exemptland" BIGINT,
  "exempttot" BIGINT,
  "yearbuilt" BIGINT,
  "yearalter1" BIGINT,
  "yearalter2" BIGINT,
  "histdist" VARCHAR,
  "landmark" VARCHAR,
  "builtfar" DOUBLE,
  "residfar" DOUBLE,
  "commfar" DOUBLE,
  "facilfar" DOUBLE,
  "borocode" BIGINT,
  "bbl" BIGINT,
  "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
);