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)

Qn

@kaggle.new_york_city_nyc_buildings.qn

19.28 MB
324403 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	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	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
QN	6	1	402	1		30	26	11101	L115	108	720	4	2	3B	2 STREET	R10	nan	nan	nan	C2-5	nan	SHP	N	Q1	9	1	C	DEPT OF GENERAL SERVI	1684828			7				524.58	268			nan		Y	5	5	17036550	17091000	17036550	17091000			nan	nan		10	10	4	4000060001	1			8d	Y	401 011	40101	nan	4000060001	Fri Sep 20 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	1	16V2
QN	6	3	402	1	1015	30	26	11101	L115	108	720	4	2	3B	2 STREET	R10	nan	nan	nan	nan	nan	SHP	N	U2	7		P	NORCEM PROPERTIES INC	21139			7	1			192.17	110			nan		N	5	5							nan	nan		10	10	4	4000060003	1	995513	209421	8d	nan	401 011	40101	nan			1	16V2
QN	6	8	402	1	1011	30	26	11101	L115	108	720	4	2	3B	1-50 51 AVENUE	R10	nan	nan	nan	nan	nan	SHP	N	W1	8		C	NYC DEPT OF EDUCATION	33454	136108	136108	2	1	5	1	130	184.48	125	249	nan	1	N			621900	17329500	621900	17329500	2011	2011	nan	nan	4.07	10	10	4	4000060008	1	995477	209867	8d	nan	401 011	40101	nan	4000060001	Wed Aug 07 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	1	16V2
QN	6	20	402	1		30	26	11101	L115	108	720	4	2	3B	2 STREET	R10	nan	nan	nan	nan	nan	SHP	N	V0	11		C	HOUSING PRESERVATION	28703			4								nan		N		5	73440	73440	73440	73440			nan	nan		10	10	4	4000060020	1			8d	nan	401 011	40101	nan	4000060001	Fri Sep 20 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	1	16V2
QN	6	30	402	1		30	26	11101	L115	108	720	4	2	3B	2 STREET	R10	nan	nan	nan	C2-5	nan	SHP	N	V0	11		C	HOUSING PRESERVATION	75847			4				333.06	306.52			nan		Y		5	198622	198622	198622	198622			nan	nan		10	10	4	4000060030	1			8d	nan	401 011	40101	nan	4000060001	Fri Sep 20 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	1	16V2
QN	6	38	402	1	1015	30	26	11101	L115	108	720	4	2	3B	1-01 54 AVENUE	R10	nan	nan	nan	nan	nan	SHP	N	T2	7	1	P	NYS OGS	37100			7				255	119			nan		Y	9	5	93150	105750	93150	105750	2011		nan	nan		10	10	4	4000060038	1			8d	nan	401 011	40101	nan			1	16V2
QN	6	40	402	1		30	26	11101	L115	108	720	4	2	3B	2 STREET	R10	nan	nan	nan	C2-5	nan	SHP	N	V0	11		C	HOUSING PRESERVATION	69572			4				240.35	363.26			nan		Y		5	182150	182150	182150	182150			nan	nan		10	10	4	4000060040	1			8d	nan	401 011	40101	nan	4000060001	Fri Sep 20 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	1	16V2
QN	6	45	402	1		30	26	11101	L115	108	720	4	2	3B	2 STREET	PARK	nan	nan	nan	nan	nan	nan	N	Q0	9		C	HOUSING PRESERVATION	15305			4				50	304.19			nan		Y		5	320850	320850	320850	320850			nan	nan				4	4000060045	1			8d	nan	401 011	40101	nan	4000060001	Fri Sep 20 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	1	16V2
QN	6	50	402	1	1015	30	26	11101	L115	108	720	4	2	3B	2 STREET	R10	nan	nan	nan	C2-5	nan	SHP	N	G7	10		C	HOUSING PRESERVATION	64242			7				200	336.76			nan		Y		5	1247850	1247850	1247850	1247850			nan	nan		10	10	4	4000060050	1	995300	209090	8d	nan	401 011	40101	nan	4000060001	Fri Sep 20 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	1	16V2
QN	6	60	402	1	1015	30	26	11101	L115	108	720	4	2	3B	2 STREET	R10	nan	nan	nan	C2-5	nan	SHP	N	Z9			C	HOUSING PRESERVATION	110906			7	1			118.69	340.92			nan		Y		5	1924650	1924650	1924650	1924650			nan	nan		10	10	4	4000060060	1	995395	209442	8d	nan	401 011	40101	nan	4000060001	Fri Sep 20 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	1	16V2


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