Tree Census In New York City

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

@kaggle.nycparks_tree_census

Table List

4 tables(147.26 MB)

New York Tree Census 1995

New York Tree Census 2005

New York Tree Census 2015

New York Tree Species

New York Tree Census 2015

@kaggle.nycparks_tree_census.new_york_tree_census_2015

52.11 MB
683788 rows
41 columns

tree_id Tree Id	block_id Block Id	created_at Created At	tree_dbh Tree Dbh	curb_loc Curb Loc	status Status	health Health	spc_latin Spc Latin	spc_common Spc Common	steward Steward	guards Guards	sidewalk Sidewalk	user_type User Type	problems Problems	root_stone Root Stone	root_grate Root Grate	root_other Root Other	trunk_wire Trunk Wire	trnk_light Trnk Light	trnk_other Trnk Other	brch_light Brch Light	brch_shoe Brch Shoe	brch_other Brch Other	address Address	zipcode Zipcode	zip_city Zip City	cb_num Cb Num	borocode Borocode	boroname Boroname	cncldist Cncldist	st_assem St Assem	st_senate St Senate	nta Nta	nta_name Nta Name	boro_ct Boro Ct	state State	latitude Latitude	longitude Longitude	x_sp X Sp	y_sp Y Sp
606945	305778	Tue Jun 28 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	10	OnCurb	Alive	Good	Fraxinus pennsylvanica	green ash	nan	nan	NoDamage	TreesCount Staff	Stones	Yes	No	No	No	No	No	No	No	No	76-046 164 STREET	11366	Fresh Meadows	408	4	Queens	24	25	14	QN37	Kew Gardens Hills	4125700	New York	40.72433932	-73.80518011	1038250.055	203232.9417
160321	341273	Wed Aug 19 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	9	OnCurb	Alive	Good	Gleditsia triacanthos var. inermis	honeylocust	nan	nan	NoDamage	Volunteer	BranchLights	No	No	No	No	No	No	Yes	No	No	72-020 32 AVENUE	11370	East Elmhurst	403	4	Queens	25	34	13	QN28	Jackson Heights	4030902	New York	40.75662595	-73.89416679	1013570.588	214953.6472
541347	325281	Wed Dec 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	7	OnCurb	Alive	Good	Pyrus calleryana	Callery pear	nan	nan	NoDamage	TreesCount Staff	BranchLights	No	No	No	No	No	No	Yes	No	No	153-026 119 AVENUE	11434	Jamaica	412	4	Queens	28	32	10	QN76	Baisley Park	4028800	New York	40.67977677	-73.78846289	1042922.921	187008.2671
613930	203822	Tue Jul 05 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	10	OnCurb	Alive	Good	Pyrus calleryana	Callery pear	nan	nan	NoDamage	TreesCount Staff	nan	No	No	No	No	No	No	No	No	No	89 89 STREET	11209	Brooklyn	310	3	Brooklyn	43	46	22	BK31	Bay Ridge	3005000	New York	40.62274274	-74.0375434	973827.8722	166160.5847
18353	338911	Sat Jun 13 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	4	OnCurb	Alive	Good	Prunus virginiana	'Schubert' chokecherry	nan	nan	NoDamage	TreesCount Staff	BranchLights	No	No	No	No	No	No	Yes	No	No	559 BEACH 68 STREET	11692	Arverne	414	4	Queens	31	31	10	QN12	Hammels-Arverne-Edgemere	4095400	New York	40.5965141	-73.79762248	1040452.463	156667.5017
21173	108713	Mon Jun 15 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	8	OnCurb	Alive	Good	Gleditsia triacanthos var. inermis	honeylocust	nan	nan	NoDamage	Volunteer	TrunkOtherBranchOther	No	No	No	No	No	Yes	No	No	Yes	3554 BROADWAY	10031	New York	109	1	Manhattan	7	71	31	MN04	Hamilton Heights	1022900	New York	40.8268873	-73.94988854	998118.5001	240538.5367
544698	201434	Wed Jan 20 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2	OnCurb	Alive	Fair	Quercus rubra	northern red oak	1or2	nan	NoDamage	TreesCount Staff	nan	No	No	No	No	No	No	No	No	No	2030 PITKIN AVENUE	11207	Brooklyn	305	3	Brooklyn	42	55	19	BK85	East New York (Pennsylvania Ave)	3114400	New York	40.67134672	-73.89761379	1012651.928	183882.7143
546240	228778	Sat Feb 06 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2	OnCurb	Alive	Good	Tilia americana	American linden	1or2	Helpful	NoDamage	Volunteer	nan	No	No	No	No	No	No	No	No	No	5008 FT HAMILTON PARKWAY	11219	Brooklyn	312	3	Brooklyn	44	48	17	BK88	Borough Park	3011400	New York	40.63777439	-73.99869226	984612.9484	171634.7857
646348	309729	Fri Jul 29 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	4	OnCurb	Alive	Good	Quercus palustris	pin oak	nan	nan	Damage	TreesCount Staff	nan	No	No	No	No	No	No	No	No	No	85-006 WOODHAVEN BOULEVARD	11421	Woodhaven	409	4	Queens	32	38	15	QN53	Woodhaven	4001400	New York	40.69666784	-73.85308695	1024988.19	193125.4947
413812	501196	Mon Nov 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	5	OnCurb	Alive	Good	Ulmus americana	American elm	nan	nan	Damage	TreesCount Staff	nan	No	No	No	No	No	No	No	No	No	1340 EAST BAY AVENUE	10474	Bronx	202	2	Bronx	17	84	34	BX27	Hunts Point	2009300	New York	40.80896707	-73.88264729	1016736.46	234027.3437


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