NYC Open Data ↗ 100.0K rows 8.1 MB Apr 6, 2026

NYC Street Tree Census

Every street tree in New York City from the 2015 Tree Census, recorded by volunteers. Includes species, size, health condition, and location. Perfect for practice with filtering, aggregation, and exploring geographic patterns.

Open in Data Lab

Schema

9 columns in this dataset

Column	Type	Description
`tree_id`	INTEGER
`species`	VARCHAR
`diameter`	INTEGER
`health`	VARCHAR
`borough`	VARCHAR
`zip_code`	VARCHAR
`latitude`	DOUBLE
`longitude`	DOUBLE
`address`	VARCHAR

Example Queries

Try these queries to start exploring the data

Most common species

Run in Data Lab

SELECT species, COUNT(*) as total FROM nyc_trees GROUP BY species ORDER BY total DESC LIMIT 10

Tree health by borough

Run in Data Lab

SELECT borough, health, COUNT(*) as trees FROM nyc_trees GROUP BY borough, health ORDER BY borough, trees DESC

Largest trees

Run in Data Lab

SELECT species, address, borough, diameter FROM nyc_trees ORDER BY diameter DESC LIMIT 20