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 1995

@kaggle.nycparks_tree_census.new_york_tree_census_1995

40.14 MB
516989 rows
27 columns

recordid Recordid	address Address	house_number House Number	street Street	zip_original Zip Original	cb_original Cb Original	site Site	species Species	diameter Diameter	status Status	wires Wires	sidewalk_condition Sidewalk Condition	support_structure Support Structure	borough Borough	x X	y Y	longitude Longitude	latitude Latitude	cb_new Cb New	zip_new Zip New	censustract_2010 Censustract 2010	censusblock_2010 Censusblock 2010	nta_2010 Nta 2010	segmentid Segmentid	spc_common Spc Common	spc_latin Spc Latin	location Location
433600	73-031 57 AV	73-031	57 AV	11378	405	Front	QUPA	6	Good	Yes	Good	nan	Queens	1015198.8	204725.3752	-73.888337	40.728546	405	11378	49302	2000	QN30	74525	OAK PIN	QUERCUS PALUSTRIS	(40.728546 -73.888337)
48050	2434 HOFFMAN ST	2434	HOFFMAN ST	10458	106	Adjacent	GLTR	10	Excellent	nan	Good	nan	Bronx	1015285.352	251404.6333	-73.887809	40.856668	206	10458	389	3005	BX06	80255	HONEYLOCUST	GLEDITSIA TRIACANTHOS	(40.856668 -73.887809)
506340	33 MULBERRY CIR	33	MULBERRY CIR	10314	502	Front	QURU	21	Good	nan	Good	nan	Staten Island	938159.2455	157433.6199	-74.165972	40.598675	502	10314	29103	4004	SI05	4866	OAK NORTHERN RED	QUERCUS RUBRA	(40.598675 -74.165972)
348044	79-037 213 ST	79-037	213 ST	11364	411	Front	ACPL	15	Poor	nan	Good	nan	Queens	1051164.586	207115.0182	-73.758549	40.734906	411	11364	129103	3004	QN42	181602	MAPLE NORWAY	ACER PLATANOIDES	(40.734906 -73.758549)
354765	68-015 172 ST	68-015	172 ST	11365	408	Front	ACPL	7	Good	nan	nan	nan	Queens	1040337.002	206542.9578	-73.797623	40.733411	408	11365	1223	3001	QN38	95970	MAPLE NORWAY	ACER PLATANOIDES	(40.733411 -73.797623)
228644	30-023 84 ST	30-023	84 ST	11370	403	Front	QUPA	25	Good	nan	Good	nan	Queens	1016259.46	216533.0617	-73.884454	40.760952	403	11370	337	1003	QN28	130572	OAK PIN	QUERCUS PALUSTRIS	(40.760952 -73.884454)
154016	562 1 ST	562	1 ST	11215	206	Front	PLAC	15	Poor	nan	Good	nan	Brooklyn	991553.1885	183318.2085	-73.973673	40.66984	306	11215	165	3000	BK37	29005	LONDON PLANETREE	PLATANUS ACERIFOLIA	(40.66984 -73.973673)
499366	93 LITTLE CLOVE RD	93	LITTLE CLOVE RD	10301	501	Side	GIBI	6	Good	Yes	Good	nan	Staten Island	955952.0001	161863.0001	-74.101919	40.610908	501	10301	16901	2024	SI07	13098	GINKGO	GINKGO BILOBA	(40.610908 -74.101919)
51547	100 ALCOTT PL	100	ALCOTT PL	10475	110	Front	GLTR	5	Excellent	nan	Good	nan	Bronx	1031112.5	256828.32	-73.830557	40.871484	210	10475	46201	7000	BX13	223241	HONEYLOCUST	GLEDITSIA TRIACANTHOS	(40.871484 -73.830557)
377394	86-008 RANGE ST	86-008	RANGE ST	11427	413	Front	FRPE	8	Good	nan	Good	nan	Queens	1058167.918	206404.0153	-73.733287	40.732899	413	11427	1621	1005	QN43	100932	ASH GREEN	FRAXINUS PENNSYLVANICA	(40.732899 -73.733287)


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