Name: Tree Census In New York City
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Tree Census In New York City

Context

New York City’s trees shade us in the summer, beautify our neighborhoods, help reduce noise, and support urban wildlife. Beyond these priceless benefits, our urban forest provides us a concrete return on the financial investment we put into it. This return includes stormwater interception, energy conservation, air pollutant removal, and carbon dioxide storage. Our publicly owned trees are as much of an asset to us as our streets, sewers, bridges, and public buildings.

Content

This dataset includes a record for every tree in New York City and includes the tree's location by borough and latitude/longitude, species by Latin name and common names, size, health, and issues with the tree's roots, trunk, and branches.

Acknowledgements

The 2015, 2005, and 1995 tree censuses were conducted by NYC Parks and Recreation staff, TreesCount! program staff, and hundreds of volunteers.

Tables

New York Tree Census 1995

@kaggle.nycparks_tree_census.new_york_tree_census_1995

42.09 MB
516,989 rows
27 columns

CREATE TABLE new_york_tree_census_1995 (
  "recordid" BIGINT,
  "address" VARCHAR,
  "house_number" VARCHAR,
  "street" VARCHAR,
  "zip_original" BIGINT,
  "cb_original" BIGINT,
  "site" VARCHAR,
  "species" VARCHAR,
  "diameter" BIGINT,
  "status" VARCHAR,
  "wires" VARCHAR,
  "sidewalk_condition" VARCHAR,
  "support_structure" VARCHAR,
  "borough" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "cb_new" BIGINT,
  "zip_new" BIGINT,
  "censustract_2010" VARCHAR,
  "censusblock_2010" VARCHAR,
  "nta_2010" VARCHAR,
  "segmentid" BIGINT,
  "spc_common" VARCHAR,
  "spc_latin" VARCHAR,
  "location" VARCHAR
);

New York Tree Census 2005

@kaggle.nycparks_tree_census.new_york_tree_census_2005

57.68 MB
1,777,116 rows
47 columns

CREATE TABLE new_york_tree_census_2005 (
  "objectid" VARCHAR,
  "cen_year" DOUBLE,
  "tree_dbh" DOUBLE,
  "tree_loc" VARCHAR,
  "pit_type" VARCHAR,
  "soil_lvl" VARCHAR,
  "status" VARCHAR,
  "spc_latin" VARCHAR,
  "spc_common" VARCHAR,
  "vert_other" VARCHAR,
  "vert_pgrd" VARCHAR,
  "vert_tgrd" VARCHAR,
  "vert_wall" VARCHAR,
  "horz_blck" VARCHAR,
  "horz_grate" VARCHAR,
  "horz_plant" VARCHAR,
  "horz_other" VARCHAR,
  "sidw_crack" VARCHAR,
  "sidw_raise" VARCHAR,
  "wire_htap" VARCHAR,
  "wire_prime" VARCHAR,
  "wire_2nd" VARCHAR,
  "wire_other" VARCHAR,
  "inf_canopy" VARCHAR,
  "inf_guard" VARCHAR,
  "inf_wires" VARCHAR,
  "inf_paving" VARCHAR,
  "inf_outlet" VARCHAR,
  "inf_shoes" VARCHAR,
  "inf_lights" VARCHAR,
  "inf_other" VARCHAR,
  "trunk_dmg" VARCHAR,
  "zipcode" DOUBLE,
  "zip_city" VARCHAR,
  "cb_num" DOUBLE,
  "borocode" DOUBLE,
  "boroname" VARCHAR,
  "cncldist" DOUBLE,
  "st_assem" DOUBLE,
  "st_senate" DOUBLE,
  "nta" VARCHAR,
  "nta_name" VARCHAR,
  "boro_ct" DOUBLE,
  "x_sp" DOUBLE,
  "y_sp" DOUBLE,
  "objectid_1" DOUBLE,
  "location_1" VARCHAR
);

New York Tree Census 2015

@kaggle.nycparks_tree_census.new_york_tree_census_2015

54.64 MB
683,788 rows
41 columns

CREATE TABLE new_york_tree_census_2015 (
  "tree_id" BIGINT,
  "block_id" BIGINT,
  "created_at" TIMESTAMP,
  "tree_dbh" BIGINT,
  "stump_diam" BIGINT,
  "curb_loc" VARCHAR,
  "status" VARCHAR,
  "health" VARCHAR,
  "spc_latin" VARCHAR,
  "spc_common" VARCHAR,
  "steward" VARCHAR,
  "guards" VARCHAR,
  "sidewalk" VARCHAR,
  "user_type" VARCHAR,
  "problems" VARCHAR,
  "root_stone" VARCHAR,
  "root_grate" VARCHAR,
  "root_other" VARCHAR,
  "trunk_wire" VARCHAR,
  "trnk_light" VARCHAR,
  "trnk_other" VARCHAR,
  "brch_light" VARCHAR,
  "brch_shoe" VARCHAR,
  "brch_other" VARCHAR,
  "address" VARCHAR,
  "zipcode" BIGINT,
  "zip_city" VARCHAR,
  "cb_num" BIGINT,
  "borocode" BIGINT,
  "boroname" VARCHAR,
  "cncldist" BIGINT,
  "st_assem" BIGINT,
  "st_senate" BIGINT,
  "nta" VARCHAR,
  "nta_name" VARCHAR,
  "boro_ct" BIGINT,
  "state" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "x_sp" DOUBLE,
  "y_sp" DOUBLE
);

New York Tree Species

@kaggle.nycparks_tree_census.new_york_tree_species

12.26 kB
57 rows
10 columns

CREATE TABLE new_york_tree_species (
  "species_scientific_name" VARCHAR,
  "species_common_name" VARCHAR,
  "form" VARCHAR,
  "growth_rate" VARCHAR,
  "fall_color" VARCHAR,
  "environmental_tolerances" VARCHAR,
  "location_tolerances" VARCHAR,
  "notes_suggested_cultivars" VARCHAR,
  "tree_size" VARCHAR,
  "comments" VARCHAR
);