Street Tree Archive

District of Columbia

@usgov.district_of_columbia_street_tree_archive

Table List

1 table(88.2 MB)

Table 1

@usgov.district_of_columbia_street_tree_archive.table_1

88.2 MB
1861805 rows
12 columns

objectid OBJECTID	tbox_stat TBOX STAT	dbh DBH	condition CONDITION	genus_name GENUS NAME	year YEAR	ward_id WARD ID	anc_id ANC ID	smd_id SMD ID	sci_nm SCI NM	cmmn_nm CMMN NM	globalid GLOBALID
1	Plant	9	Excellent	Quercus	2021	1	1D	1D06	Quercus robur 'Fastigiata'	English oak (Fastigiata)	{564E651C-DA63-48D2-A2C9-FA4542BE373B}
2	Plant	2	Good	Quercus	2021	1	1D	1D03	Quercus nuttallii	Nuttall oak	{29DB149F-5C7E-4F6E-8321-22DC504E479C}
3	Plant	5	Good	Quercus	2021	1	1D	1D03	Quercus palustris	Pin oak	{5AC3DA4A-D07B-4CF1-B4E6-EDD68779E061}
4	Plant	2	Excellent	Quercus	2021	1	1D	1D05	Quercus phellos	Willow oak	{9DDD51E9-F983-49A5-A979-96482B5B126A}
5	Plant	38	Fair	Quercus	2021	1	1D	1D05	Quercus palustris	Pin oak	{F06AE179-E21E-4521-8F3D-E318A3FE24A6}
6	Plant	14.4	Good	Quercus	2021	1	1D	1D05	Quercus palustris	Pin oak	{467387DC-FE9A-4BAA-A3B8-B99BDAE46113}
7	Plant	3.8	Good	Carpinus	2021	1	1D	1D03	Carpinus species	Hornbeam	{5F8552DB-0B6B-4BF7-A691-C1E8E53AD40F}
8	Plant	5.5	Good	Quercus	2021	1	1A	1A05	Quercus species	Oak	{100050F7-B3A3-4B28-89C7-16360CEF2753}
9	Plant	16	Good	Platanus	2021	1	1D	1D03	Platanus occidentalis	American sycamore	{E28176B7-BAD3-482C-ACE4-4FEB9DC2DC1A}
10	Retired	3	Excellent	Liquidambar	2021	1	1A	1A03	Liquidambar rotundiloba	Rotundiloba sweetgum	{78E6BCD7-5613-4D9B-BEDA-CC365A8CADED}


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "tbox_stat" VARCHAR,
  "dbh" DOUBLE,
  "condition" VARCHAR,
  "genus_name" VARCHAR,
  "year" BIGINT,
  "ward_id" DOUBLE,
  "anc_id" VARCHAR,
  "smd_id" VARCHAR,
  "sci_nm" VARCHAR,
  "cmmn_nm" VARCHAR,
  "globalid" VARCHAR
);