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)

Mn

@kaggle.new_york_city_nyc_buildings.mn

3.61 MB
42958 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	ltdheight LtdHeight	splitzone SplitZone	bldgclass BldgClass	landuse LandUse	ownertype OwnerType	ownername OwnerName	lotarea LotArea	bldgarea BldgArea	comarea ComArea	otherarea OtherArea	areasource AreaSource	numbldgs NumBldgs	numfloors NumFloors	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	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
MN	1	10	101	5	1018	2	1	10004	E007	1	8100	1	1	nan	1 GOVERNORS ISLAND	R3-2	nan	nan	nan	nan	nan	GI	nan	nan	N	Y4	8	P	GOVERNORS ISLAND CORP	7736692	2725731	2725731	2725731	2	158							nan		N	5	5	104445450	156510900	104445450	156510900	1900		Governors Island Historic District	CASTLE WILLIAMS	0.35	0.6		1	1	1000010010	5	979071	190225	16a	Y	199 999	10101	nan			1	16V2
MN	1	101	101	1	1001	2	1	10004	E007	1	8200	1	1	nan	1 LIBERTY ISLAND	R3-2	nan	nan	nan	nan	nan	nan	nan	nan	N	P7	8	X	U S GOVT LAND & BLDGS	541886	541886	541886	541886	2	10			500	1046			nan		Y	5	5	4225950	12197250	4225950	12197250	1900		nan	STATUE OF LIBERTY NATIONAL MONUMENT	1	0.6		1	1	1000010101	1	971677	190636	16a	Y	199 999	10101	nan			1	16V2
MN	1	201	101	1	1000	2	1	10004	E007	1	8200	1	1	nan	1 ELLIS ISLAND	R3-2	nan	nan	nan	nan	nan	nan	nan	nan	N	Z9		X	U S GOVT LAND & BLDGS	2764190	603130	603130	603130	2	7							nan		N	5	5	14972400	108450450	14972400	108450450	1900		Ellis Island Historic District	nan	0.22	0.6		1	1	1000010201	1	972790	193648	12b	nan	199 999	10101	nan			1	16V2
MN	1	301	101			2	1	10004	E007	1		1	1	nan	JOE DIMAGGIO HIGHWAY	ZNA	nan	nan	nan	nan	nan	nan	nan	nan	N	U0	7	nan	nan					7								nan		N		5							nan	nan					1	1000010301				12b	nan	199 999	10101	nan			4	16V2
MN	1	401	101			2	1	10004	E007	1		1	1	nan	JOE DIMAGGIO HIGHWAY	ZNA	nan	nan	nan	nan	nan	nan	nan	nan	N	U0	7	nan	nan					7								nan		N		5							nan	nan					1	1000010401				12b	nan	1 99 999	10101	nan			4	16V2
MN	2	1	101	9	1025	2	1	10004	L015	1	7700	1	1	nan	MARGINAL STREET	M1-4	nan	nan	nan	nan	nan	LM	nan	nan	N	Y7	7	C	NYC DSBS	209215	280000	280000	280000	2	2	5		709.42	564.42	268	210	E		Y	5	5	18818100	32193900	18818100	32193900	1900	2006	nan	BATTERY MARITIME BUILDING	1.34		2	6.5	1	1000020001	9	980670	194440	12b	nan	101N100	10101	nan	1000020001	Tue Aug 07 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	1	16V2
MN	2	2	101	9	1025	2	1	10004	L015	1	7700	1	1	nan	10 SOUTH STREET	C4-6	nan	nan	nan	nan	nan	LM	nan	nan	N	Y7	7	C	10 SSA LANDLORD, LLC	191502	158197	158197	158197	2	1	5		311	555	205	270	nan		N	2	5	18787500	25390080	18787500	25390080	1900	2014	nan	nan	0.83	10	3.4	10	1	1000020002	9	981037	194506	12b	nan	11N 100	10101	nan	1000020001	Tue Aug 07 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	1	16V2
MN	2	3	101	9		2	1	10004	L015	1	7700	1	1	nan	MARGINAL STREET	C4-6	nan	nan	nan	nan	nan	LM	nan	nan	N	Y7	7	C	NYC DSBS	38800	7500	7500	7500	2		1		91.9	564.56	50	75	nan		N	2	5	735750	822150	735750	822150	1900		nan	nan	0.19	10	3.4	10	1	1000020003	9			12b	nan	101N100	10101	nan	1000020001	Tue Aug 07 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	1	16V2
MN	2	23	101	9	1025	2	1	10004	L015	1	7700	1	1	nan	1 PIER 6	C4-6	nan	nan	nan	nan	nan	LM	nan	nan	N	T2	7	C	NYC DSBS	510025	24346	24346	24346	2	1	2		793.67	551	85	551	nan		Y	5	5	15255450	17134650	15255450	17134650	1987		nan	nan	0.05	10	3.4	10	1	1000020023	9	981687	194732	12b	nan	101N100	10101	nan			1	16V2
MN	3	1	101	319	1000	2	1	10004	L015	1	9000	1	1	nan	10 BATTERY PARK	PARK	nan	nan	nan	nan	nan	nan	nan	nan	N	Q1	9	C	PARKS AND RECREATION	945425	945425	945425	945425	2	6	1	4	323	1260	89	57	nan	1	Y	1		127100700	129665250	127100700	129665250	1951		nan	BATTERY PARK CONTROL HOUSE (IRT SUB	1				1	1000030001	319	979916	195328	12b	nan	101S087	10101	nan			1	16V2


CREATE TABLE mn (
  "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
);