Baselight

Tree Census In New York City

What tree species are thriving on the streets of each NYC borough?

@kaggle.nycparks_tree_census

New York Tree Species
@kaggle.nycparks_tree_census.new_york_tree_species

  • 11.97 KB
  • 57 rows
  • 10 columns
species_scientific_name

Species Scientific Name

species_common_name

Species Common Name

form

Form

growth_rate

Growth Rate

fall_color

Fall Color

environmental_tolerances

Environmental Tolerances

location_tolerances

Location Tolerances

notes_suggested_cultivars

Notes Suggested Cultivars

tree_size

Tree Size

comments

Comments

Ginkgo bilobaGinkgoUprightSlowYellowSalt Drought High Wind Pollution and High pH TolerantMedian Tree Narrow Growing Space'Autumn Gold' or 'Presedential Gold'Large (Mature Height > 50 ft)nan
Quercus spp. 'Fastigiata'Fastigiata OakUprightSlowMaroonnoneMedian Tree Narrow Growing SpaceSimilar tree is Quercus roburLarge (Mature Height > 50 ft)nan
Liquidambar styracifluaSweetgumPyramidalMediumYellowWet Site TolerantnonePlant Spring Only lawn pits only look for 'Rotundiloba'Large (Mature Height > 50 ft)nan
Metasequoia glyptostroboidesDawn RedwoodPyramidalMediumOrange/BrownWet Site Drought High pH TolerantMedian Tree Narrow Growing SpaceCan Grow 2 to 3 Feet per YearLarge (Mature Height > 50 ft)nan
Taxodium distichumBaldcypressPyramidalMediumOrange/BrownWet Site Salt and High Wind TolerantMedian Tree Narrow Growing SpaceIdeal For Wet SoilsLarge (Mature Height > 50 ft)nan
Tilia cordataLittleleaf LindenPyramidalMediumYellowPollution TolerantMedian Tree'Greenspire'Large (Mature Height > 50 ft)nan
Gymnocladus dioicusCoffeetreeRoundedMediumYellowDrought Tolerantnone'Espresso'Large (Mature Height > 50 ft)nan
Gleditsia triacanthos var. inermisHoneylocustRoundedMediumYellowWet Site Salt Drought High Wind Pollution and High pH TolerantMedian Tree'Halka'Large (Mature Height > 50 ft)nan
Liriodendron tulipiferaTulip TreePyramidalMediumYellownonenone'Rotundiloba'Large (Mature Height > 50 ft)nan
Quercus rubraNorthern Red OakRoundedMediumMaroonSalt TolerantnonePlant Spring OnlyLarge (Mature Height > 50 ft)nan

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

Share link

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