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)

Si

@kaggle.new_york_city_nyc_buildings.si

7.44 MB
124048 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	splitzone SplitZone	bldgclass BldgClass	landuse LandUse	easements Easements	ownertype OwnerType	ownername OwnerName	lotarea LotArea	bldgarea BldgArea	comarea ComArea	officearea OfficeArea	retailarea RetailArea	garagearea GarageArea	strgearea StrgeArea	factryarea FactryArea	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
SI	1	10	501	3	2000	31	49	10301	L078	120	500	5	1	2C	139 BAY STREET	C4-2	nan	nan	nan	nan	nan	SG	nan	N	E9	6		nan	139 BAY POINTE PROPER	5716	18965	18965		6965		12000		2	1	4	1	112.58	84	100	50	nan	1	Y	5		103050	546300			1884	2000	nan	nan	3.32	2.43	3.4	4.8	5	5000010010	3	963297	171951	21c	nan	501 017	50101	nan			1	16V2
SI	1	17	501	3		31	49	10301	L078	120	500			nan	BAY STREET	C4-2	nan	nan	nan	nan	nan	SG	nan	N	V1	11		nan	139 BAY POINTE PROPER	780								4				26	35			nan		Y	5	5	7776	7776					nan	nan		2.43	3.4	4.8	5	5000010017	3			21c	nan	501 017	50101	nan			1	16V2
SI	1	18	501	3		31	49	10301	L078	120	500			nan	BAY STREET	C4-2	nan	nan	nan	nan	nan	SG	nan	N	V1	11		nan	139 BAY POINTE PROPER	520								4				26	25			nan		Y	5	5	5184	5184					nan	nan		2.43	3.4	4.8	5	5000010018	3			21c	nan	501 017	50101	nan			1	16V2
SI	1	19	501	3		31	49	10301	L078	120	500			nan	BAY STREET	C4-2	nan	nan	nan	nan	nan	SG	nan	N	V1	11		nan	139 BAY STREET REALTY	278								4				39	15			nan		Y	5	5	3240	3240					nan	nan		2.43	3.4	4.8	5	5000010019	3			21c	nan	501 017	50101	nan			1	16V2
SI	1	21	501	3		31	49	10301	L078	120	500			nan	BAY STREET	C4-2	nan	nan	nan	nan	nan	SG	nan	N	V1	11		P	K MANDEL	6302								4				75	82			nan		Y	5	5	60300	60300					nan	nan		2.43	3.4	4.8	5	5000010021	3			21c	nan	501 017	50101	nan			1	16V2
SI	1	30	501	3		31	49	10301	L078	120	500			nan	BAY STREET	C4-2	nan	nan	nan	nan	nan	SG	nan	N	U7	7		nan	MTA - STATEN ISLAND R									7				216	80			nan		Y	5	5							nan	nan		2.43	3.4	4.8	5	5000010030	3			21c	nan	501 017	50101	nan			1	16V2
SI	1	51	501	3	2000	31	49	10301	L078	120	500	5	1	2C	65 BAY STREET	C4-2	nan	nan	nan	nan	nan	SG	nan	N	O7	5		P	57 BAY STREET ASSOCIA	4600	10600	10600	9400		1200			2	1	3	1	194	70	110	41	nan		Y	5	5	82800	1136250			1923	1991	nan	nan	2.3	2.43	3.4	4.8	5	5000010051	3	963320	172669	21c	nan	501 017	50101	nan	5000010051	Thu May 02 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	1	16V2
SI	1	55	501	3	2000	31	49	10301	L078	120	500	5	1	2C	45 BAY STREET	C4-2	nan	nan	nan	nan	nan	SG	nan	N	Z3	8	1	P	UNITED STATES POSTAL	14200	34800	34800	34800					2	1	2	1	213	234	260	100	nan	1	Y	5		129600	1856700	129600	1856700	1932		nan	nan	2.45	2.43	3.4	4.8	5	5000010055	3	963387	172845	21c	nan	501 018	50101	nan			1	16V2
SI	1	60	501	3	2000	31	49	10301	L078	120	500	5	1	2C	5 BAY STREET	C4-2	nan	nan	nan	nan	nan	SG	nan	N	Y7	7	1	C	NYC DSBS	334565	34941	34941					34941	2	4	4	1	372	234	241	41	nan		Y	5	5	1286550	1894050	1286550	1894050	1931		nan	OLD ADMINISTRATION BUILDING (THIRD	0.1	2.43	3.4	4.8	5	5000010060	3	963621	172927	21c	nan	501 018	50101	nan	5000010060	Thu Dec 26 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	1	16V2
SI	1	65	501	3	2000	31	49	10301	L078	120	500	5	1	nan	150 BAY STREET	C4-2	M1-1	nan	nan	nan	nan	SG	nan	Y	Y7	7		C	NYC DSBS	121810	22326	22326					22326	2	2	3	1			122	61	nan	1	N			1370250	1773450	1370250	1773450	1931		nan	nan	0.18	2.43	3.4	4.8	5	5000010065	3	963871	172762	21c	nan	501 018	50101	nan	5000010060	Thu Dec 26 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	1	16V2


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