Street_Tree_List

Data source: data.sfgov.org

108 rows where SiteOrder = 8 and qSpecies = 32

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

- 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: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
2449	2449	192165	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1500 Mission St	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		09/30/2008 12:00:00 AM	29	Width 4ft	Permit Number 779453	6007288.76075	2109818.60353	37.7735716516336	-122.418217917334	(37.7735716516336, -122.418217917334)
8330	8330	23533	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2750 Van Ness Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	3x3		6005739.67426	2119887.69379	37.8011315565386	-122.424292729842	(37.8011315565386, -122.424292729842)
13660	13660	117220	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 04th St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/06/2016 12:00:00 AM	3		Permit Number 778712	6013718.755890001	2111339.55053	37.7781076611892	-122.39608205125799	(37.7781076611892, -122.396082051258)
13875	13875	100273	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 Federal St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	1x1		6015216.1617	2113535.8467	37.7842213945326	-122.391055490318	(37.7842213945326, -122.391055490318)
14911	14911	21988	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2585 03rd St	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4x6		6015920.52958	2103275.9123	37.756088918284604	-122.38790244203899	(37.7560889182846, -122.387902442039)
23441	23441	218859	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1251 Funston Ave	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 5ft		5992039.2755	2106763.98784	37.7643143326521	-122.470745140778	(37.7643143326521, -122.470745140778)
23717	23717	190342	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	101 Howard St	8	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 3ft		6014826.26604	2116061.6193	37.7911349426626	-122.39258114252199	(37.7911349426626, -122.392581142522)
25427	25427	123305	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	401 05th Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 4ft		5994337.6818	2112408.21093	37.779944522099704	-122.46320524064501	(37.7799445220997, -122.463205240645)
25757	25757	112703	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	100 North Point St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	3x3		6010065.02511	2121996.61103	37.80716540491979	-122.409473998846	(37.8071654049198, -122.409473998846)
25975	25975	190211	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	121 Main St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6013914.14494	2116628.7080900003	37.7926413385806	-122.39577682766	(37.7926413385806, -122.39577682766)
26904	26904	128685	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	270 Washington St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6013016.98656	2117923.9286599997	37.7961477583652	-122.39897199927	(37.7961477583652, -122.39897199927)
26905	26905	192098	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	999 Brannan St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 3ft		6010707.34193	2108618.01402	37.77046694101539	-122.406307866326	(37.7704669410154, -122.406307866326)
27031	27031	128174	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	211 Beach St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6009021.33226	2122150.03233	37.8075281266926	-122.413096790009	(37.8075281266926, -122.413096790009)
27633	27633	192028	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 Brannan St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6012889.46074	2110709.33139	37.776331047768394	-122.398906658113	(37.7763310477684, -122.398906658113)
28324	28324	128004	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2445 Mason St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6008820.56005	2121577.1168	37.805943772163204	-122.413751060276	(37.8059437721632, -122.413751060276)
28340	28340	127600	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	7 Ada Ct	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6008095.684769999	2114192.28554	37.7856261220825	-122.41573638563601	(37.7856261220825, -122.415736385636)
28799	28799	127996	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	260 Bay St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 4ft		6009391.121719999	2121556.20408	37.805918375298795	-122.41177505549601	(37.8059183752988, -122.411775055496)
31863	31863	190314	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	235 01st St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 4ft		6013928.07501	2115065.82867	37.788350810692	-122.395619078484	(37.788350810692, -122.395619078484)
34480	34480	127326	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2701 Buchanan St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 5ft		6003538.3738	2117644.9259099998	37.7948489511644	-122.431749957696	(37.7948489511644, -122.431749957696)
35560	35560	126757	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1755 Filbert St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6004674.460659999	2119114.12408	37.7989473272061	-122.427923677844	(37.7989473272061, -122.427923677844)
37519	37519	119394	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	491 31st Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 5ft		5986270.74775	2112760.12891	37.7804427678726	-122.49113788550301	(37.7804427678726, -122.491137885503)
39289	39289	192068	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	400 15th St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6011228.78907	2107468.40502	37.7673395315233	-122.404423236252	(37.7673395315233, -122.404423236252)
40879	40879	128117	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2300 Stockton St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6009760.33787	2122129.7127900003	37.8075137923806	-122.410537843773	(37.8075137923806, -122.410537843773)
43917	43917	127095	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1550 Bay St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6003361.4578	2120715.66217	37.8032703664959	-122.432581558114	(37.8032703664959, -122.432581558114)
44920	44920	189806	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2301 Alameda St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 4ft		6010201.29352	2107833.60296	37.768284808036	-122.408002972378	(37.768284808036, -122.408002972378)
48678	48678	128315	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1150 Sansome St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6011980.53416	2119746.61642	37.8010946105983	-122.402686597724	(37.8010946105983, -122.402686597724)
50690	50690	128029	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2601 Jones St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 4ft		6007868.73718	2121431.95	37.805491683870294	-122.417034709883	(37.8054916838703, -122.417034709883)
51995	51995	225508	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	450 Church St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 4ft		6004195.74141	2106258.0557	37.763620663995	-122.428663273099	(37.763620663995, -122.428663273099)
52311	52311	128412	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	251 Sutter St	8	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 3ft		6011365.53208	2115598.62793	37.7896708769491	-122.404522629328	(37.7896708769491, -122.404522629328)
54111	54111	128493	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	201 Montgomery St	8	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 3ft		6011961.6023	2116106.4791900003	37.791098610068005	-122.402495999902	(37.791098610068, -122.402495999902)
54767	54767	104475	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	717 Battery St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/09/2013 12:00:00 AM	16		Permit Number 767241	6012448.38296	2118528.40226	37.7977757974783	-122.400981986754	(37.7977757974783, -122.400981986754)
57441	57441	128516	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	80 Davis St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 4ft		6013382.8889999995	2117199.9031599998	37.7941801379622	-122.39765508693701	(37.7941801379622, -122.397655086937)
57542	57542	127668	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	330 Gough St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 4ft		6005970.45175	2111012.7201	37.776776114160704	-122.42286303441601	(37.7767761141607, -122.422863034416)
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)
59383	59383	127336	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2519 Buchanan St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 5ft		6003633.835	2116964.8058700003	37.7929869264477	-122.431371075121	(37.7929869264477, -122.431371075121)
59591	59591	128100	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2021 Grant Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6010200.9764	2122085.81865	37.8074179633436	-122.409009806572	(37.8074179633436, -122.409009806572)
60029	60029	190180	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	91 Spear St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6014085.4849	2116875.2091900003	37.7933277029699	-122.395201255249	(37.7933277029699, -122.395201255249)
60390	60390	128083	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	109 North Point St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 4ft		6009715.0017	2121896.66309	37.8068713545053	-122.41067827198499	(37.8068713545053, -122.410678271985)
60496	60496	128259	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	350 Union St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 5ft		6011225.99501	2119723.89837	37.8009900760912	-122.40529604180401	(37.8009900760912, -122.405296041804)
60684	60684	128756	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	145 Geary St	8	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 4ft		6010913.96156	2114842.14016	37.7875684949465	-122.40603171059401	(37.7875684949465, -122.406031710594)
61825	61825	128225	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	68 Green St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6012486.62834	2119554.0931599997	37.8005942314015	-122.40092174834899	(37.8005942314015, -122.400921748349)
64242	64242	128270	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2 Lombard St	8	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 4ft		6011859.51793	2120856.45591	37.804135202245604	-122.40318348214	(37.8041352022456, -122.40318348214)
64338	64338	190160	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	70 Steuart St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 4ft		6014378.60543	2117086.97655	37.793925463435	-122.39420186293002	(37.793925463435, -122.39420186293)
65022	65022	128359	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1335 Battery St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 4ft		6012164.33015	2120592.98911	37.8034288045464	-122.402110117006	(37.8034288045464, -122.402110117006)
66542	66542	126769	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	200 Moulton St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6002238.72171	2119331.6030900003	37.7994063708645	-122.43636770211901	(37.7994063708645, -122.436367702119)
66871	66871	189813	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	220 San Bruno Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 4ft		6010835.2592	2107226.1455200003	37.766652342460496	-122.405767341407	(37.7666523424605, -122.405767341407)
69232	69232	126956	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	250 Laurel St	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 2ft		5998094.8526099995	2115625.78698	37.7889948655654	-122.450439589331	(37.7889948655654, -122.450439589331)
69542	69542	128075	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	111 North Point St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6009525.60238	2121869.5076099997	37.806786171612	-122.411331809333	(37.806786171612, -122.411331809333)
70289	70289	128338	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	190 Greenwich St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6011999.17579	2120522.18024	37.8032251611641	-122.402676661103	(37.8032251611641, -122.402676661103)
70782	70782	128328	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	149 Union St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6012215.8302	2119810.2133299997	37.801282366543	-122.401876840053	(37.801282366543, -122.401876840053)
70869	70869	192112	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	367 Tehama St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6011488.6234800005	2112595.97552	37.7814331787306	-122.403885362539	(37.7814331787306, -122.403885362539)
71504	71504	98651	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2110 Greenwich St	8	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW 4		23	5x5		6002674.17203	2119228.66956	37.799148474973705	-122.434853527066	(37.7991484749737, -122.434853527066)
75141	75141	128134	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2600 Jones St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6007854.55751	2121865.58739	37.8066815444876	-122.41711452652001	(37.8066815444876, -122.41711452652)
83742	83742	190119	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	101 Potrero Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	Width 4ft		6010301.8592300005	2107798.08422	37.7681929117011	-122.407652618992	(37.7681929117011, -122.407652618992)
92191	92191	102333	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3201X 18th St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3x3		6008125.3	2105602.6	37.7620425418858	-122.415025724241	(37.7620425418858, -122.415025724241)
118376	118376	102342	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	401X Shotwell St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3x3		6007842.0	2105589.3	37.7619900992271	-122.416004610168	(37.7619900992271, -122.416004610168)
122957	122957	128696	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	300 Washington St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6012797.32935	2117894.1121799997	37.79605364700421	-122.399729967672	(37.7960536470042, -122.399729967672)
129586	129586	190247	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	60 New Montgomery St	8	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 3ft		6012252.79605	2115009.77228	37.7881035636755	-122.40141136625	(37.7881035636755, -122.40141136625)
129772	129772	192077	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	121 Vermont St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6011151.7490300005	2107654.57043	37.7678463939135	-122.404702815691	(37.7678463939135, -122.404702815691)
131774	131774	128091	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	103 North Point St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6009972.302209999	2121930.59441	37.8069789439766	-122.409790224757	(37.8069789439766, -122.409790224757)
132073	132073	127068	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3252 Pierce St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 3ft		6001369.87535	2119586.0879599997	37.8000557128665	-122.439392462107	(37.8000557128665, -122.439392462107)
133806	133806	189734	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 Carolina St	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 4ft		6012410.091659999	2105093.88145	37.760885563039395	-122.40017046549801	(37.7608855630394, -122.400170465498)
134937	134937	126687	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2801 Divisadero St	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 5ft		6000575.90002	2117927.00422	37.7954550915302	-122.442020761354	(37.7954550915302, -122.442020761354)
135680	135680	190237	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	536 Mission St	8	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 4ft		6013038.17401	2115310.45321	37.7889729517976	-122.398715186183	(37.7889729517976, -122.398715186183)
135777	135777	128533	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	400 California St	8	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 4ft		6012201.74089	2116820.49629	37.793072534717105	-122.4017153326	(37.7930725347171, -122.4017153326)
136056	136056	189725	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	645 Carolina St	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 4ft		6012416.0818300005	2104951.5513299997	37.7604950899983	-122.40013975184601	(37.7604950899983, -122.400139751846)
136704	136704	128188	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	151 Beach St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6009505.56595	2122216.65424	37.80773822540021	-122.41142569045601	(37.8077382254002, -122.411425690456)
148355	148355	128577	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	401 Washington St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6012768.379369999	2117834.0684	37.7958871672194	-122.399825922632	(37.7958871672194, -122.399825922632)
150954	150954	128017	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	590 Bay St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6008055.65139	2121378.44537	37.805355286373	-122.416384073766	(37.805355286373, -122.416384073766)
150956	150956	128594	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	298 Clay St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6013099.53041	2117626.96914	37.7953369772614	-122.39866552918899	(37.7953369772614, -122.398665529189)
151030	151030	190152	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	643 Market St	8	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 3ft		6012042.16585	2115158.26918	37.7884995468687	-122.402150558612	(37.7884995468687, -122.402150558612)
152402	152402	127611	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	91 Myrtle St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 4ft		6007158.66736	2114158.58344	37.7854808653823	-122.41897581107901	(37.7854808653823, -122.418975811079)
153817	153817	127644	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	30 Grove St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			21	Width 4ft		6007939.9704	2111706.64993	37.7787924112801	-122.416099017452	(37.7787924112801, -122.416099017452)
154110	154110	128451	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	251 Leidesdorff St	8	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 4ft		6012146.507569999	2116585.86441	37.7924252089997	-122.401889943174	(37.7924252089997, -122.401889943174)
155433	155433	190094	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	357 Bryant St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 3ft		6014680.38573	2113296.62099	37.7835347900434	-122.392892357392	(37.7835347900434, -122.392892357392)
156119	156119	225357	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	133 Otis St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6006846.39556	2109305.4948400003	37.7721378678859	-122.419711713729	(37.7721378678859, -122.419711713729)
156203	156203	224415	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	401 Treat Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 3ft		6008508.64162	2105951.33232	37.7630216147802	-122.413724557246	(37.7630216147802, -122.413724557246)
157599	157599	189775	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2250 26th St	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16			6011802.753280001	2101385.15924	37.7506683445725	-122.40201026526	(37.7506683445725, -122.40201026526)
157803	157803	218947	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	265 Casitas Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5994959.84342	2096480.8612099998	37.7362479259859	-122.45989883578899	(37.7362479259859, -122.459898835789)
159165	159165	124712	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3801 Jackson St	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 3ft		5996036.658530001	2115836.84865	37.7894563721222	-122.45757590119301	(37.7894563721222, -122.457575901193)
160437	160437	192126	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	807 Mission St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			28	Width 4ft		6011150.07784	2113419.14707	37.7836744952253	-122.405114553219	(37.7836744952253, -122.405114553219)
160607	160607	190102	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	333 Bryant St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6014869.19728	2113481.75633	37.7840536152337	-122.392252089585	(37.7840536152337, -122.392252089585)
160705	160705	127697	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	751 Powell St	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 5ft		6010048.08579	2116214.9518	37.7912894389969	-122.409124388283	(37.7912894389969, -122.409124388283)
161139	161139	128672	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	250 Washington St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 3ft		6013392.30755	2117975.00239	37.796308901584	-122.397676888287	(37.796308901584, -122.397676888287)
164501	164501	190307	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	250 Fremont St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 4ft		6014201.40485	2115197.1929200003	37.7887267066265	-122.394682597341	(37.7887267066265, -122.394682597341)
166009	166009	128066	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	262 North Point St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 4ft		6009084.93005	2121810.40932	37.806599177367794	-122.412852667211	(37.8065991773678, -122.412852667211)
166284	166284	127514	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	335 Powell St	8	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 4ft		6010238.1387	2114901.34541	37.7876932363033	-122.40837411179501	(37.7876932363033, -122.408374111795)
166785	166785	128655	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	99 Broadway	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6012979.83036	2118865.43828	37.7987308486974	-122.399166689903	(37.7987308486974, -122.399166689903)
167734	167734	246685	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	65 Randall St	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 4ft		6004978.8033300005	2097597.3431	37.7398846440669	-122.425338555951	(37.7398846440669, -122.425338555951)
168214	168214	128156	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	200 Beach St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6008846.95725	2122172.85858	37.807581011328004	-122.41370187274099	(37.807581011328, -122.413701872741)
169019	169019	128293	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	101 Lombard St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6011708.71285	2120782.03449	37.8039224361403	-122.40370011746599	(37.8039224361403, -122.403700117466)
169375	169375	189617	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1022 Harrison St	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 0ft		6010909.29281	2110559.94876	37.7758103412047	-122.405746120085	(37.7758103412047, -122.405746120085)
169936	169936	127105	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1601 Beach St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6002505.01994	2121244.0915599996	37.8046726892538	-122.43558311198099	(37.8046726892538, -122.435583111981)
170276	170276	128150	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	580 North Point St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6007635.589980001	2121667.4715	37.8061252481373	-122.417858255075	(37.8061252481373, -122.417858255075)
171954	171954	127470	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	726 Sutter St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 4ft		6009023.5642	2115321.29812	37.7887782350869	-122.412606019156	(37.7887782350869, -122.412606019156)
172418	172418	128615	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	350 Washington St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 4ft		6013744.86634	2118068.19144	37.7965844026114	-122.39646348792401	(37.7965844026114, -122.396463487924)
173619	173619	190296	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	180 Spear St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6014934.54688	2115984.27929	37.7909285977144	-122.39220108002701	(37.7909285977144, -122.392201080027)
174309	174309	189631	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1455 11th St	8	: 4	Tree 1	Private 1			9	Width 3ft		6007308.187530001	2110441.11785	37.7752820209699	-122.41819486052799	(37.7752820209699, -122.418194860528)
175273	175273	128277	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	55 Francisco St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 5ft		6011021.69532	2121382.8122400003	37.8055336219402	-122.406119948501	(37.8055336219402, -122.406119948501)
176329	176329	127635	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	11 Hyde St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6008240.08971	2111777.143	37.77900283825821	-122.415065774669	(37.7790028382582, -122.415065774669)

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