Skip to content

Dataset: PLUTO

Jump to bottom
khy236 edited this page Jan 20, 2024 · 19 revisions

PLUTO

The pluto_latest dataset can be added to NYCDB by running:

nycdb --download pluto_latest
nycdb --load pluto_latest

Specific versions of PLUTO can be added by specifying their version name e.g.:

nycdb --download pluto_22v1
nycdb --load pluto_22v1

Provenance

The dataset comes from the NYC Open Data portal:

  • PLUTO

    The Primary Land Use Tax Lot Output (PLUTO) data file contains extensive land use and geographic data at the tax lot level in a comma-delimited file. The PLUTO tax lot data files contain over seventy data fields derived from data files maintained by the Department of City Planning (DCP), Department of Finance (DOF), Department of Citywide Administrative Services (DCAS), and Landmarks Preservation Commission (LPC). DCP has created additional fields based on data obtained from one or more of the major data sources. PLUTO data files contain three basic types of data: 1) Tax Lot Characteristics; 2) Building Characteristics; and 3) Geographic/Political/Administrative Districts.

Context

The PLUTO data is updated monthly. Check the City Planning web site, www.nyc.gov/planning for update status. The date of the source data files and the base map used to create this version are:

SOURCE DATE OF DATA
Department of City Planning – E-Designations 11/09/22
Department of City Planning – Zoning Map Index 07/31/19
Department of City Planning – NYC City Owned and Leased Properties 06/30/22
Department of City Planning – NYC GIS Zoning Features 10/31/22
Department of City Planning – Political and Administrative Districts 08/30/22
Department of City Planning – Geosupport version 22B 08/30/22
Department of Finance – Digital Tax Map (DTM) 11/09/22
Department of Finance – Mass Appraisal System (CAMA) 09/27/22
Department of Finance – Property Tax System (PTS) 11/07/22
Landmarks Preservation Commission – Historic Districts 05/26/22
Landmarks Preservation Commission – Individual Landmarks 06/13/22
Department of Information Telecommunications and Technology – Building Footprint Centroids 11/07/22
Department of Parks and Recreation – GreenThumb Garden Info 11/01/22

Data dictionary

You can download the latest data dictionary here.

To create the table here the best way is to use Google Sheets (or similar) to fill out all the information, then export to a CSV file, and use this tool to convert a CSV to an HTML table. Then you can paste that HTML code into this template replacing everything between the <summary> ... </summary> tags.

Click to Expand the my_funky_dataset Data Dictionary
column_name data_type description
boroughid integer Borough code (1 = Manhattan, 2 = Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island)
borough text Borough name
block integer Number assigned by DoF identifying the Tax block the lot is on
lot integer Unique number assigned by DoF within a Block identifying a lot
bbl char(10) A combination of three numeric codes--a 1-digit borough number, a block number (up to 5 digits) and a lot number (up to 4 digits)--designated and modified by the Department of Finance (DOF). BBLs are used by various city agencies to identify real estate for taxes, zoning, construction, and other purposes.

Tables

This dataset has the following tables:

  • pluto_latest is the only table in this dataset. Specific versions of PLUTO can be used by accessing their version number. The versions of PLUTO available are: pluto_10v1, pluto_15v1, pluto_16v2, pluto_17v1, pluto_18v1, pluto_19v1, pluto_19v2, pluto_20v8, pluto_21v3, and pluto_22v1.

Example queries

Following are some useful SQL queries related to the dataset.

How many total units and total residential units are there in each zoning code

The pluto_latest table has information on lot zoning districts such as: R1-1 - R10H Residential Districts C1-6 - C8-4 Commercial Districts M1-1 – M3-2 Manufacturing Districts M1-1/R5 – M1-6/R10 Mixed Manufacturing & Residential Districts BPC Battery Park City PARK Areas designated as PARK, BALL FIELD, PLAYGROUND and PUBLIC SPACE in NYC

SELECT 
zonedist1, 
 	SUM(unitstotal) AS totalunits, 
 	SUM(unitsres) AS totalresunits
FROM pluto_latest
GROUP BY zonedist1
ORDER BY totalunits DESC;

Known Issues and Data Pitfalls

  • Missing fields
  • Needs to be sanitized
Clone this wiki locally