Street_Tree_List

Data source: data.sfgov.org

5,685 rows where qSpecies = 32 sorted by PlotSize descending

Search:

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by TreeID Sort by qLegalStatus Sort by qSpecies Sort by qAddress Sort by SiteOrder Sort by qSiteInfo Sort by PlantType Sort by qCaretaker Sort by qCareAssistant Sort by PlantDate Sort by DBH Sort by PlotSize Sort by PermitNotes Sort by XCoord Sort by YCoord Sort by Latitude Sort by Longitude Sort by Location

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qSiteInfo, qCaretaker, qCareAssistant

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize ▲	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
3018	3018	128709	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	4x Columbus Ave	1	Median : Yard 3	Tree 1	Private 1			19	Width 9ft		6011726.08303	2117794.9108	37.795721488711294	-122.403429729102	(37.7957214887113, -122.403429729102)
39465	39465	189705	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	500 Wisconsin St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 9ft		6012637.736959999	2105122.26077	37.7609761769225	-122.39938512804399	(37.7609761769225, -122.399385128044)
46155	46155	189816	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 15th St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 9ft		6010379.86715	2107373.23208	37.767030731308104	-122.40735284165702	(37.7670307313081, -122.407352841657)
46834	46834	189823	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 15th St	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 9ft		6010524.410519999	2107382.85181	37.767065233807	-122.40685356416	(37.767065233807, -122.40685356416)
57651	57651	189821	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 15th St	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 9ft		6010484.40346	2107380.66629	37.7670569942101	-122.406991789056	(37.7670569942101, -122.406991789056)
61472	61472	189819	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 15th St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 9ft		6010449.36204	2107378.3567	37.7670486916722	-122.407112829708	(37.7670486916722, -122.407112829708)
74607	74607	189822	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 15th St	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 9ft		6010499.44736	2107381.21521	37.767059343243105	-122.40693979295901	(37.7670593432431, -122.406939792959)
151482	151482	189815	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 15th St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 9ft		6010361.40821	2107373.60835	37.7670307313104	-122.407416715103	(37.7670307313104, -122.407416715103)
157732	157732	189820	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 15th St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 9ft		6010468.25457	2107379.34073	37.7670524508424	-122.40704755241	(37.7670524508424, -122.40704755241)
166371	166371	246687	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	65 Randall St	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 9ft		6004944.1218	2097602.36636	37.7398964773322	-122.42545882766301	(37.7398964773322, -122.425458827663)
169978	169978	189818	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 15th St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 9ft		6010426.403390001	2107376.26761	37.767041670665996	-122.407192093242	(37.767041670666, -122.407192093242)
175528	175528	189817	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 15th St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 9ft		6010416.08165	2107377.1962599996	37.767043642870796	-122.407227860188	(37.7670436428708, -122.407227860188)
184815	184815	189770	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	752 San Bruno Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 9ft		6010962.700209999	2104799.54607	37.7599965733071	-122.405155654013	(37.7599965733071, -122.405155654013)
34828	34828	218916	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	544 Judson Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 8ft		5996794.9301	2093643.7566799999	37.728563285644604	-122.453349451027	(37.7285632856446, -122.453349451027)
35305	35305	176450	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	306 Niagara Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 8ft		5998817.229619999	2090113.0618900002	37.718984525607	-122.446104420884	(37.718984525607, -122.446104420884)
37046	37046	224775	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1254 Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	Width 8ft		6005132.40845	2101023.1416599997	37.749299781465105	-122.42505113981001	(37.7492997814651, -122.42505113981)
37960	37960	246672	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	950 San Jose Ave	2	Front Yard : Yard 7	Tree 1	Private 1			5	Width 8ft		6005247.4068	2097710.7023400003	37.7402110745895	-122.42441789747299	(37.7402110745895, -122.424417897473)
42040	42040	189611	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1002 Harrison St	1	: 4	Tree 1	Private 1			26	Width 8ft		6011365.32335	2110994.5569	37.7770291662965	-122.40419918094	(37.7770291662965, -122.40419918094)
45076	45076	189753	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1440 Kansas St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 8ft		6011710.04414	2101629.60758	37.7513343716924	-122.40234804881901	(37.7513343716924, -122.402348048819)
45212	45212	224734	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3740 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	Width 8ft		6005363.43954	2104318.5589099997	37.758361279372295	-122.42448660208099	(37.7583612793723, -122.424486602081)
45478	45478	224358	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3216 16th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			21	Width 8ft		6005460.521790001	2106677.82399	37.7648447465213	-122.424318647403	(37.7648447465213, -122.424318647403)
48262	48262	246674	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	950 San Jose Ave	4	Front Yard : Yard 7	Tree 1	Private 1			16	Width 8ft		6005286.18809	2097704.16876	37.740195324763704	-122.424283342697	(37.7401953247637, -122.424283342697)
49915	49915	224738	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3672 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 8ft		6005826.11207	2104345.60475	37.7584616581002	-122.422888396198	(37.7584616581002, -122.422888396198)
50664	50664	126965	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	48 Parker Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 8ft		5996871.90335	2114255.83844	37.7851632832987	-122.454571800557	(37.7851632832987, -122.454571800557)
55552	55552	126964	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	48 Parker Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 8ft		5996871.72113	2114270.32352	37.7852030450262	-122.45457347777901	(37.7852030450262, -122.454573477779)
73610	73610	192051	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	311 Townsend St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			31	Width 8ft		6013302.41922	2110215.29688	37.7749975429264	-122.39744345487499	(37.7749975429264, -122.397443454875)
76606	76606	246675	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	950 San Jose Ave	5	Front Yard : Yard 7	Tree 1	Private 1			19	Width 8ft		6005283.663509999	2097689.92499	37.7401560720365	-122.424291058881	(37.7401560720365, -122.424291058881)
132636	132636	246673	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	950 San Jose Ave	3	Front Yard : Yard 7	Tree 1	Private 1			15	Width 8ft		6005263.852999999	2097708.23975	37.740205241579396	-122.424360857976	(37.7402052415794, -122.424360857976)
134963	134963	224363	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3298 16th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 8ft		6005062.52777	2106659.51249	37.7647719859487	-122.42569390415301	(37.7647719859487, -122.425693904153)
136408	136408	224359	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3216 16th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			23	Width 8ft		6005443.089869999	2106677.47927	37.7648428156587	-122.424378915481	(37.7648428156587, -122.424378915481)
137517	137517	126966	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	32 Parker Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 8ft		5996866.787930001	2114389.9756	37.7855312948716	-122.45459919211099	(37.7855312948716, -122.454599192111)
149325	149325	226560	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	749 Dolores St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 8ft		6005048.60664	2104047.06132	37.75759802654	-122.42555611183701	(37.75759802654, -122.425556111837)
151068	151068	246982	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	38 Clipper St	1	: 4	Tree 1	Private 1			18	Width 8ft		6004902.47134	2101076.4890799997	37.74943326963471	-122.425850064247	(37.7494332696347, -122.425850064247)
155879	155879	189752	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1440 Kansas St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 8ft		6011708.7603	2101642.1472400003	37.75136873119779	-122.402353370112	(37.7513687311978, -122.402353370112)
157026	157026	218857	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1250 14th Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 8ft		5991792.482469999	2106755.85942	37.7642777392596	-122.471598127965	(37.7642777392596, -122.471598127965)
157769	157769	226572	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 Tiffany Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 8ft		6006471.88526	2099931.8525799997	37.7463789237643	-122.4203417473	(37.7463789237643, -122.4203417473)
159605	159605	127896	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	11 Fallon Pl	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 8ft		6008940.22386	2118573.66854	37.7977037707737	-122.413124434271	(37.7977037707737, -122.413124434271)
161793	161793	126967	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	32 Parker Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 8ft		5996866.037140001	2114400.44978	37.7855600111213	-122.454602546567	(37.7855600111213, -122.454602546567)
166133	166133	126963	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	48 Parker Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 8ft		5996871.288509999	2114280.54966	37.785231098475	-122.45457571352101	(37.785231098475, -122.454575713521)
177191	177191	189751	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1434 Kansas St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 8ft		6011708.5069	2101654.92142	37.751403792165604	-122.402355144494	(37.7514037921656, -122.402355144494)
188806	188806	224362	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3298 16th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 8ft		6005110.48857	2106660.40423	37.764777144474394	-122.42552808356001	(37.7647771444744, -122.42552808356)
288	288	226558	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	320 Dolores St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			22	Width 7ft		6004836.50691	2106380.98977	37.7639944545966	-122.42645581878	(37.7639944545966, -122.42645581878)
312	312	226557	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	320 Dolores St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 7ft		6004833.37225	2106401.74543	37.7640512674875	-122.42646813862	(37.7640512674875, -122.42646813862)
40800	40800	224735	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3755 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 7ft		6005292.90765	2104272.7404099996	37.7582314891971	-122.424727273269	(37.7582314891971, -122.424727273269)
41020	41020	224778	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1379 Dolores St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 7ft		6005255.281330001	2100266.52541	37.7472292273526	-122.424572428891	(37.7472292273526, -122.424572428891)
41817	41817	224737	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3646 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 7ft		6005976.89881	2104353.50991	37.7584918708254	-122.422367469281	(37.7584918708254, -122.422367469281)
123933	123933	124042	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	835 Lake St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 7ft		5992827.42703	2114798.67685	37.786420969755994	-122.468603820853	(37.786420969756, -122.468603820853)
133787	133787	189777	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1027 Rhode Island St	1	: 4	Tree 1	Private 1			16	Width 7ft		6011952.80925	2103344.3528299998	37.7560562360087	-122.40162904355302	(37.7560562360087, -122.401629043553)
158960	158960	224727	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1102 York St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 7ft		6009981.53531	2102756.63648	37.7543323012985	-122.40840494503	(37.7543323012985, -122.40840494503)
160961	160961	189719	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	572 Wisconsin St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 7ft		6012655.432030001	2104759.5682	37.7599812893225	-122.39929846665702	(37.7599812893225, -122.399298466657)
163505	163505	124245	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1130 Clement St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 7ft		5991975.1446	2113464.3401900004	37.7827079796513	-122.47145521190399	(37.7827079796513, -122.471455211904)
173950	173950	224777	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1379 Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			22	Width 7ft		6005258.128280001	2100242.3184	37.747162921236	-122.424560862703	(37.747162921236, -122.424560862703)
188358	188358	124244	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1130 Clement St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 7ft		5991991.6420599995	2113466.17808	37.7827139803523	-122.47139827219802	(37.7827139803523, -122.471398272198)
544	544	224355	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3120 16th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/27/1976 12:00:00 AM	23	Width 6ft	Permit Number 16120	6005992.7506800005	2106707.14788	37.7649553019752	-122.42247988543501	(37.7649553019752, -122.422479885435)
1435	1435	226556	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	301 Dolores St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			21	Width 6ft		6004916.06592	2106558.9555200003	37.7644876032441	-122.42619331838199	(37.7644876032441, -122.426193318382)
1441	1441	226555	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	301 Dolores St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			21	Width 6ft		6004913.144780001	2106531.61539	37.7644123686589	-122.42620147522699	(37.7644123686589, -122.426201475227)
2003	2003	127110	Significant Tree 6	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3201 Laguna St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23	Width 6ft		6003718.35126	2119752.0994	37.8006449063974	-122.431277695812	(37.8006449063974, -122.431277695812)
2060	2060	127860	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1898 Hyde St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			19	Width 6ft		6007322.606430001	2118731.77235	37.798046941256	-122.418733064272	(37.798046941256, -122.418733064272)
2472	2472	224776	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1600 Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	Width 6ft		6005221.0	2098972.0	37.743672820465896	-122.42459890056001	(37.7436728204659, -122.42459890056)
24087	24087	224740	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3686 20th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			25	Width 6ft		6005715.83971	2104337.63998	37.7584335659607	-122.42326920153099	(37.7584335659607, -122.423269201531)
24269	24269	127025	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2198 Greenwich St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 6ft		6002439.9675	2119194.72849	37.7990419817485	-122.435661523871	(37.7990419817485, -122.435661523871)
27215	27215	120462	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	75 West Clay St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 6ft		5988526.89995	2115008.4578299997	37.7867476054693	-122.483497765205	(37.7867476054693, -122.483497765205)
28281	28281	127931	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	680 Beach St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 6ft		6007017.28347	2121922.09912	37.8067895746458	-122.42001609288602	(37.8067895746458, -122.420016092886)
28980	28980	226574	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	375 Fair Oaks St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 6ft		6005499.0576	2101536.54316	37.7507301684604	-122.42381975928801	(37.7507301684604, -122.423819759288)
33732	33732	224745	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	14 Fair Oaks St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 6ft		6005352.49972	2103549.80259	37.756249836672794	-122.424469755991	(37.7562498366728, -122.424469755991)
36037	36037	127026	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2198 Greenwich St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 6ft		6002420.43291	2119191.80813	37.7990328536301	-122.435728910967	(37.7990328536301, -122.435728910967)
36369	36369	126682	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2850 Divisadero St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 6ft		6000598.56985	2118144.03071	37.796052280935704	-122.441957905049	(37.7960522809357, -122.441957905049)
36609	36609	120464	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	75 West Clay St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 6ft		5988508.84723	2115012.1663900004	37.786756737379996	-122.483560494571	(37.78675673738, -122.483560494571)
36866	36866	126683	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2850 Divisadero St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 6ft		6000601.6004800005	2118120.5180200003	37.7959878939838	-122.441945730027	(37.7959878939838, -122.441945730027)
38121	38121	127385	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1919 Octavia St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	Width 6ft		6004752.115	2115904.45404	37.790138781622	-122.427426191764	(37.790138781622, -122.427426191764)
38690	38690	224379	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1839 15th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 6ft		6005245.84332	2107211.7119299998	37.766298550959505	-122.42509915641001	(37.7662985509595, -122.42509915641)
41761	41761	224743	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	110 Liberty St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 6ft		6005521.47175	2104036.98093	37.7575970552701	-122.423920033676	(37.7575970552701, -122.423920033676)
43036	43036	127024	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2198 Greenwich St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 6ft		6002458.58256	2119198.03735	37.799052124320795	-122.435597346446	(37.7990521243208, -122.435597346446)
45074	45074	249440	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	900 Ellis St	5	: 4	Tree 1	Private 1			15	Width 6ft		6006344.64005	2113562.97552	37.7837996008221	-122.421749788816	(37.7837996008221, -122.421749788816)
46329	46329	126876	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	413 Walnut St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 6ft		5998594.70529	2115127.83971	37.7876562291843	-122.448674293879	(37.7876562291843, -122.448674293879)
48039	48039	127794	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2229 Taylor St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 6ft		6008462.92143	2120654.02887	37.8033891147652	-122.414923354455	(37.8033891147652, -122.414923354455)
52176	52176	127777	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1501 Hyde St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 6ft		6007446.01905	2117496.6288400004	37.7946624929361	-122.418218403875	(37.7946624929361, -122.418218403875)
54706	54706	127905	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	937 Lombard St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 6ft		6007996.96181	2120271.7748	37.8023133475557	-122.41650873688299	(37.8023133475557, -122.416508736883)
55750	55750	126634	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2800 Divisadero St	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 6ft		6000614.8529199995	2118015.66138	37.7957007404413	-122.44189234447501	(37.7957007404413, -122.441892344475)
60088	60088	120463	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	75 West Clay St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 6ft		5988518.34055	2115009.8271	37.7867508669083	-122.483527478764	(37.7867508669083, -122.483527478764)
61522	61522	127796	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2229 Taylor St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 6ft		6008469.86419	2120613.07952	37.803277068243396	-122.414896428735	(37.8032770682434, -122.414896428735)
61734	61734	249439	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	900 Ellis St	4	: 4	Tree 1	Private 1			15	Width 6ft		6006372.16148	2113566.88832	37.7838118963457	-122.421654852808	(37.7838118963457, -122.421654852808)
62456	62456	224407	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3526 19th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 6ft		6006056.27394	2104942.82839	37.7601144789255	-122.422134820985	(37.7601144789255, -122.422134820985)
62911	62911	224811	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1285 Sanchez St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 6ft		6003906.2351	2100805.72431	37.7486334629739	-122.429275769879	(37.7486334629739, -122.429275769879)
64822	64822	176448	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	843 Cayuga Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 6ft		6001153.28465	2092061.4502700001	37.724467487066	-122.43816910622401	(37.724467487066, -122.438169106224)
67034	67034	226511	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	801 Treat Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 6ft		6008570.46834	2103775.16623	37.7570498321943	-122.41335681457599	(37.7570498321943, -122.413356814576)
67778	67778	249437	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	900 Ellis St	2	: 4	Tree 1	Private 1			16	Width 6ft		6006423.6127	2113573.86871	37.783833963915704	-122.421477346411	(37.7838339639157, -122.421477346411)
70567	70567	226512	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	801 Treat Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 6ft		6008569.507069999	2103796.87916	37.7571093969942	-122.41336167450301	(37.7571093969942, -122.413361674503)
74833	74833	176447	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	843 Cayuga Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 6ft		6001152.60647	2092059.5558	37.7244622467113	-122.438171314947	(37.7244622467113, -122.438171314947)
76629	76629	128296	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	101 Lombard St	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 6ft		6011760.219769999	2120791.0173	37.8039499778675	-122.403522505873	(37.8039499778675, -122.403522505873)
121245	121245	127795	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2229 Taylor St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 6ft		6008467.1705599995	2120633.53828	37.8033330915089	-122.414907199018	(37.8033330915089, -122.414907199018)
128429	128429	127904	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	937 Lombard St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 6ft		6007970.92827	2120270.81905	37.802309259211796	-122.416598758152	(37.8023092592118, -122.416598758152)
134314	134314	127799	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2229 Taylor St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 6ft		6008480.70239	2120534.34164	37.8030614827683	-122.41485334673	(37.8030614827683, -122.41485334673)
136358	136358	224780	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1445 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			21	Width 6ft		6004571.62093	2100489.66516	37.7478032844105	-122.42695236508101	(37.7478032844105, -122.426952365081)
136980	136980	224736	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3751 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 6ft		6005316.304409999	2104275.01271	37.7582390497985	-122.42464651864701	(37.7582390497985, -122.424646518647)
146419	146419	189649	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	636 San Bruno Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 6ft		6010952.336680001	2105119.1773900003	37.7608736299435	-122.405214004748	(37.7608736299435, -122.405214004748)
152827	152827	127917	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2357 Jones St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 6ft		6007984.65596	2120608.29341	37.8032366509171	-122.416575173411	(37.8032366509171, -122.416575173411)
153136	153136	224380	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1556 15th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			22	Width 6ft		6007070.08962	2107355.32554	37.7667957627472	-122.418799605125	(37.7667957627472, -122.418799605125)
156729	156729	123350	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	560 04th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 6ft		5994717.55453	2111733.42255	37.7781136098793	-122.461842157685	(37.7781136098793, -122.461842157685)
160032	160032	190133	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1300 Phelps St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 6ft		6014167.590919999	2096559.46483	37.73754970274621	-122.39349470802401	(37.7375497027462, -122.393494708024)

Next page

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");