Baselight

New York City - Buildings Database

The PLUTO master record of buildings in New York City.

@kaggle.new_york_city_nyc_buildings

Loading...
Loading...

About this Dataset

New York City - Buildings Database

Context:

PLUTO is a master record of the locations and characteristics of buildings in New York City. It’s published by the New York City Department of City Planning on an approximately quarterly-to-half-yearly basis, and is one of the more important datasets for civic analysis in New York City.

Content:

PLUTO includes information on building height, square footage, location, type, landmark status, number of units, owner, year of construction, and other related fields.

Acknowledgements:

This dataset is published as-is by the New York City Department of Planning.

Inspiration:

  • What is the distribution of the heights of buildings in New York City? The age?
  • Can you define neighborhoods by clustering similar buildings within them?
  • What (and where) is the split between commercial, residential, and office space in New York City?

Tables

Bk

@kaggle.new_york_city_nyc_buildings.bk
  • 16.51 MB
  • 277131 rows
  • 84 columns
Loading...

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
);

Bx

@kaggle.new_york_city_nyc_buildings.bx
  • 5.85 MB
  • 89830 rows
  • 84 columns
Loading...

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
);

Mn

@kaggle.new_york_city_nyc_buildings.mn
  • 3.61 MB
  • 42958 rows
  • 84 columns
Loading...

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
);

Qn

@kaggle.new_york_city_nyc_buildings.qn
  • 19.28 MB
  • 324403 rows
  • 84 columns
Loading...

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
);

Si

@kaggle.new_york_city_nyc_buildings.si
  • 7.44 MB
  • 124048 rows
  • 84 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.