Street_Tree_List

Data source: data.sfgov.org

146 rows where qSiteInfo = 4 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, PlotSize

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
24435	24435	189790	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	671 Connecticut St	1	: 4	Tree 1	Private 1			12	Width 3ft		6013319.6658	2103964.90842	37.7578363244071	-122.39694547056601	(37.7578363244071, -122.396945470566)
25118	25118	249530	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	236 Myrtle St	1	: 4	Tree 1	Private 1			6	Width 3ft		6006266.61639	2114058.0965400003	37.7851546812964	-122.422054907229	(37.7851546812964, -122.422054907229)
25995	25995	189634	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1455 11th St	11	: 4	Tree 1	Private 1			7	Width 3ft		6007263.01198	2110493.68646	37.7754238188976	-122.41835486160299	(37.7754238188976, -122.418354861603)
26803	26803	189610	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	55 Sherman St	23	: 4	Tree 1	Private 1			18	Width 10ft		6010659.83752	2111049.78613	37.7771413675214	-122.406643580555	(37.7771413675214, -122.406643580555)
28397	28397	249531	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	246 Myrtle St	1	: 4	Tree 1	Private 1			7	Width 3ft		6006201.54989	2114050.0866900003	37.7851290182315	-122.42227944813601	(37.7851290182315, -122.422279448136)
28493	28493	92501	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	645 05th St	2	: 4	Tree 1	Private 1			24			6013077.25048	2110692.4491	37.7762951549369	-122.398255852047	(37.7762951549369, -122.398255852047)
28617	28617	226531	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	101 Rose St	2	: 4	Tree 1	Private 1			14	Width 3ft		6006054.679409999	2109842.3217700003	37.7735672350795	-122.42248848118	(37.7735672350795, -122.42248848118)
29840	29840	246959	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2173 15th St	1	: 4	Tree 1	Private 1			22	Width 4ft		6003061.26496	2107089.31896	37.7658388409276	-122.43264645046699	(37.7658388409276, -122.432646450467)
31382	31382	249379	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	774 Geary St	1	: 4	Tree 1	Private 1			15	Width 4ft		6008031.48613	2114489.63478	37.786438961746505	-122.415979559602	(37.7864389617465, -122.415979559602)
31574	31574	189607	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1000 06th St	2	: 4	Tree 1	Private 1			25	Width 3ft		6011287.74653	2111158.98765	37.777476320014	-122.404479121929	(37.777476320014, -122.404479121929)
31758	31758	189585	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	25 Stillman St	3	: 4	Tree 1	Private 1			18	Width 3ft		6014156.36179	2113112.63363	37.7830004821267	-122.39469240262899	(37.7830004821267, -122.394692402629)
33094	33094	189778	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	800 Wisconsin St	10	: 4	Tree 1	Private 1			32	Width 5ft		6012724.71744	2103552.97155	37.7566721007586	-122.39897415133001	(37.7566721007586, -122.39897415133)
33542	33542	190139	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	401 Barneveld Ave	4	: 4	Tree 1	Private 1			3	Width 2ft		6011347.78295	2098111.56945	37.741654371349604	-122.40335333078501	(37.7416543713496, -122.403353330785)
34024	34024	189637	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1457 11th St	2	: 4	Tree 1	Private 1			29	Width 3ft		6007464.35939	2110196.45279	37.774619018289705	-122.41763727995199	(37.7746190182897, -122.417637279952)
34949	34949	189630	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1455 11th St	7	: 4	Tree 1	Private 1			14	Width 3ft		6007441.71426	2110305.43642	37.7749169870715	-122.41772334055901	(37.7749169870715, -122.417723340559)
35122	35122	189629	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1455 11th St	6	: 4	Tree 1	Private 1			16	Width 3ft		6007461.61467	2110284.7901	37.774861417042	-122.417653036967	(37.774861417042, -122.417653036967)
35623	35623	189789	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	673 Connecticut St	1	: 4	Tree 1	Private 1			14	Width 3ft		6013320.4621	2103950.0195299997	37.7577954870833	-122.39694167273198	(37.7577954870833, -122.396941672732)
36986	36986	190145	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1270 Fairfax Ave	5	: 4	Tree 1	Private 1			16	Width 4ft		6017279.69898	2096994.64423	37.7389170445949	-122.38276484453002	(37.7389170445949, -122.38276484453)
38479	38479	249413	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	640 Turk St	2	: 4	Tree 1	Private 1			14	Width 4ft		6006896.39396	2112943.4670599997	37.7821296802828	-122.41979694968799	(37.7821296802828, -122.419796949688)
38903	38903	249332	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	840 Post St	3	: 4	Tree 1	Private 1			16	Width 4ft		6008070.22885	2114841.12367	37.7874062428634	-122.41587041788799	(37.7874062428634, -122.415870417888)
39417	39417	189597	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	411 Bryant St	6	: 4	Tree 1	Private 1			18	Width 3ft		6014335.70711	2113051.36538	37.7828422230287	-122.39406764630199	(37.7828422230287, -122.394067646302)
40490	40490	246458	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	401 Duncan St	1	: 4	Tree 1	Private 1			11	Width 3ft		6003866.26481	2099806.76686	37.7458882950042	-122.429342761286	(37.7458882950042, -122.429342761286)
40783	40783	190148	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1711 Oakdale Ave	1	: 4	Tree 1	Private 1			6	Width 3ft		6014397.54059	2095926.93864	37.735825689785706	-122.39265542203199	(37.7358256897857, -122.392655422032)
41837	41837	249334	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	875 Post St	1	: 4	Tree 1	Private 1			10	Width 3ft		6007974.7465699995	2114781.52678	37.7872372359533	-122.416196545342	(37.7872372359533, -122.416196545342)
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)
42599	42599	190131	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	100 Industrial St	7	: 4	Tree 1	Private 1			5	Width 4ft		6011654.92131	2097288.97497	37.7394128516087	-122.402233521954	(37.7394128516087, -122.402233521954)
42662	42662	190140	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1401 Fairfax Ave	1	: 4	Tree 1	Private 1			19	Width 3ft		6016375.816219999	2097583.85317	37.740484913635605	-122.385931141602	(37.7404849136356, -122.385931141602)
43861	43861	189787	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	679 Connecticut St	1	: 4	Tree 1	Private 1			13	Width 3ft		6013321.62455	2103920.68806	37.757715013961	-122.396935596012	(37.757715013961, -122.396935596012)
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)
45367	45367	189608	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	55 Sherman St	21	: 4	Tree 1	Private 1			27	Width 10ft		6010698.53691	2111009.64615	37.7770333175687	-122.406506877295	(37.7770333175687, -122.406506877295)
45382	45382	190151	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	43 Bridgeview Dr	1	: 4	Tree 1	Private 1			9	Width 2ft		6013910.41512	2095496.0882400002	37.7346155971136	-122.39430946233699	(37.7346155971136, -122.394309462337)
45576	45576	247217	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	898 Duboce Ave	1	: 4	Tree 1	Private 1			18	Width 3ft		6001734.68886	2108311.17777	37.769118442685	-122.437322288417	(37.769118442685, -122.437322288417)
45695	45695	189605	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	215 Clara St	3	: 4	Tree 1	Private 1			2	Width 3ft		6011774.59908	2111718.41989	37.7790395872403	-122.40283428260099	(37.7790395872403, -122.402834282601)
45966	45966	249338	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	851 Post St	4	: 4	Tree 1	Private 1			11	Width 3ft		6008100.791680001	2114799.69697	37.7872942133891	-122.415761742029	(37.7872942133891, -122.415761742029)
45977	45977	189588	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	15 Stillman St	3	: 4	Tree 1	Private 1			14	Width 3ft		6014257.88071	2113209.71429	37.7832726871175	-122.394347985691	(37.7832726871175, -122.394347985691)
46938	46938	189598	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	412 Bryant St	1	: 4	Tree 1	Private 1			17	Width 3ft		6014306.60489	2113024.2886900003	37.7827662590956	-122.39416643232799	(37.7827662590956, -122.394166432328)
47706	47706	249378	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	764 Geary St	2	: 4	Tree 1	Private 1			16	Width 4ft		6008051.64406	2114491.85735	37.7864461976841	-122.41590997546999	(37.7864461976841, -122.41590997547)
49276	49276	189053	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1498 Fairfax Ave	10	: 4	Tree 1	Private 1			17	Width 4ft		6016104.71748	2097862.0759900003	37.74123385017221	-122.38688790245199	(37.7412338501722, -122.386887902452)
49974	49974	189604	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	215 Clara St	2	: 4	Tree 1	Private 1			9	Width 3ft		6011760.8178199995	2111704.36546	37.779000227523206	-122.402880969084	(37.7790002275232, -122.402880969084)
50857	50857	189057	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1398 Fairfax Ave	1	: 4	Tree 1	Private 1			16	Width 4ft		6016659.73338	2097454.68952	37.7401459645668	-122.384940461042	(37.7401459645668, -122.384940461042)
51824	51824	190130	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	100 Industrial St	6	: 4	Tree 1	Private 1			6	Width 4ft		6011690.7758	2097300.73442	37.7394471418669	-122.40211037869301	(37.7394471418669, -122.402110378693)
53515	53515	189632	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1455 11th St	9	: 4	Tree 1	Private 1			7	Width 3ft		6007298.00895	2110457.3775	37.775326093154504	-122.4182312237	(37.7753260931545, -122.4182312237)
54954	54954	127069	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3252 Pierce St	9	: 4	Tree 1	Private 1			9	Width 3ft		6001380.49031	2119587.4899	37.800060166303396	-122.439355830906	(37.8000601663034, -122.439355830906)
55060	55060	189793	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	308 Hernandez Ave	1	: 4	Tree 1	Private 1			13	Width 3ft		6013450.09241	2105609.9853	37.7623606049856	-122.39660971586099	(37.7623606049856, -122.396609715861)
55612	55612	246817	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	188 Brewster St	1	: 4	Tree 1	Private 1			7	Width 2ft		6010169.08234	2098827.13597	37.7435532583908	-122.40747933761601	(37.7435532583908, -122.407479337616)
56194	56194	247219	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	898 Duboce Ave	3	: 4	Tree 1	Private 1			17	Width 3ft		6001696.7328699995	2108310.3892	37.769114119654205	-122.437453519276	(37.7691141196542, -122.437453519276)
56535	56535	189056	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1298 Fairfax Ave	2	: 4	Tree 1	Private 1			17	Width 4ft		6017215.97894	2097042.62645	37.739045273523104	-122.38298849961201	(37.7390452735231, -122.382988499612)
56968	56968	127064	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3252 Pierce St	4	: 4	Tree 1	Private 1			8	Width 3ft		6001385.25853	2119550.33485	37.799958419693105	-122.43933666636299	(37.7999584196931, -122.439336666363)
58508	58508	189595	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	411 Bryant St	4	: 4	Tree 1	Private 1			15	Width 3ft		6014364.840369999	2113079.9785700003	37.7829224074815	-122.393968860282	(37.7829224074815, -122.393968860282)
58659	58659	190129	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	100 Industrial St	5	: 4	Tree 1	Private 1			4	Width 4ft		6011744.4272	2097318.12593	37.739497889703	-122.401926096826	(37.739497889703, -122.401926096826)
58981	58981	189788	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	677 Connecticut St	1	: 4	Tree 1	Private 1			14	Width 3ft		6013320.33604	2103932.9624400004	37.7577486450122	-122.39694091281099	(37.7577486450122, -122.396940912811)
59412	59412	249362	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	610 Leavenworth St	1	: 4	Tree 1	Private 1			17	Width 3ft		6008385.00133	2114591.25294	37.7867378496037	-122.41476367620001	(37.7867378496037, -122.4147636762)
61048	61048	189785	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	500 Texas St	3	: 4	Tree 1	Private 1			10	Width 3ft		6013782.84096	2104671.65945	37.7598026803771	-122.395393116622	(37.7598026803771, -122.395393116622)
61191	61191	190128	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	100 Industrial St	4	: 4	Tree 1	Private 1			8	Width 4ft		6011796.42353	2097334.30265	37.7395452093339	-122.40174745189199	(37.7395452093339, -122.401747451892)
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)
62875	62875	190141	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1385 Fairfax Ave	1	: 4	Tree 1	Private 1			22	Width 4ft		6016685.94194	2097355.07165	37.7398738836642	-122.384842903479	(37.7398738836642, -122.384842903479)
63153	63153	246956	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2157 15th St	1	: 4	Tree 1	Private 1			9	Width 3ft		6003133.80616	2107095.11064	37.7658588571132	-122.432395959599	(37.7658588571132, -122.432395959599)
63182	63182	189590	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	15 Stillman St	5	: 4	Tree 1	Private 1			13	Width 3ft		6014290.16171	2113241.33755	37.7833613117285	-122.39423852019199	(37.7833613117285, -122.394238520192)
63186	63186	190126	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2177 Jerrold Ave	2	: 4	Tree 1	Private 1			18	Width 4ft		6012310.55549	2099218.77103	37.744748237035104	-122.400102105343	(37.7447482370351, -122.400102105343)
63589	63589	249393	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	320 Turk St	1	: 4	Tree 1	Private 1			16	Width 3ft		6008405.64882	2113154.88185	37.7827950814738	-122.414590558504	(37.7827950814738, -122.414590558504)
63936	63936	189584	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	25 Stillman St	2	: 4	Tree 1	Private 1			19	Width 3ft		6014144.58829	2113102.88171	37.782973050999296	-122.39473245124901	(37.7829730509993, -122.394732451249)
64318	64318	126640	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	619 Hayes St	1	: 4	Tree 1	Private 1			10	Width 3ft		6004870.87553	2110876.4929299997	37.776339963657996	-122.42665709607401	(37.776339963658, -122.426657096074)
64640	64640	189624	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1455 11th St	1	: 4	Tree 1	Private 1			18	Width 3ft		6007595.48584	2110148.75293	37.7744954235495	-122.417180305629	(37.7744954235495, -122.417180305629)
66899	66899	249375	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	746 Geary St	2	: 4	Tree 1	Private 1			16	Width 3ft		6008127.05575	2114504.28031	37.786484547475794	-122.41564994908	(37.7864845474758, -122.41564994908)
67440	67440	189601	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	491 03rd St	1	: 4	Tree 1	Private 1			8	Width 3ft		6013780.757680001	2112590.74143	37.781546595846706	-122.39595526393299	(37.7815465958467, -122.395955263933)
67575	67575	189633	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1455 11th St	10	: 4	Tree 1	Private 1			10	Width 3ft		6007281.55408	2110475.16176	37.775373998252	-122.418289406239	(37.775373998252, -122.418289406239)
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)
69207	69207	189627	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1455 11th St	4	: 4	Tree 1	Private 1			16	Width 3ft		6007528.52851	2110215.7250900003	37.7746755460784	-122.417416671761	(37.7746755460784, -122.417416671761)
69508	69508	189779	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1651 20th St	1	: 4	Tree 1	Private 1			10	Width 3ft		6013017.59805	2104710.46941	37.7598666527441	-122.398042456397	(37.7598666527441, -122.398042456397)
71355	71355	190146	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1298 Fairfax Ave	3	: 4	Tree 1	Private 1			18	Width 4ft		6017196.21156	2097055.6209099998	37.739079861441496	-122.38305775101601	(37.7390798614415, -122.383057751016)
71776	71776	246957	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2157 15th St	2	: 4	Tree 1	Private 1			11	Width 3ft		6003142.68624	2107094.6668700003	37.7658581421603	-122.432365213587	(37.7658581421603, -122.432365213587)
72432	72432	190142	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1385 Fairfax Ave	2	: 4	Tree 1	Private 1			19	Width 4ft		6016719.34934	2097329.5303	37.7398055999553	-122.384725614793	(37.7398055999553, -122.384725614793)
73372	73372	226530	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	498 Oak St	1	: 4	Tree 1	Private 1			16	Width 4ft		6004664.90455	2110206.95803	37.7744899376984	-122.427321901889	(37.7744899376984, -122.427321901889)
73523	73523	189626	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1455 11th St	3	: 4	Tree 1	Private 1			14	Width 3ft		6007544.583380001	2110195.50679	37.774620934744895	-122.41735970148599	(37.7746209347449, -122.417359701486)
73540	73540	189638	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1457 11th St	3	: 4	Tree 1	Private 1			29	Width 3ft		6007490.46455	2110170.79422	37.774550034893	-122.417545157896	(37.774550034893, -122.417545157896)
73606	73606	249374	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	746 Geary St	1	: 4	Tree 1	Private 1			18	Width 3ft		6008149.07625	2114506.99215	37.7864932313311	-122.415573955478	(37.7864932313311, -122.415573955478)
76194	76194	189591	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	480 02nd St	3	: 4	Tree 1	Private 1			13	Width 3ft		6014351.962	2113206.2727099997	37.7832684666162	-122.394022258432	(37.7832684666162, -122.394022258432)
120086	120086	189055	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1270 Fairfax Ave	4	: 4	Tree 1	Private 1			16	Width 4ft		6017298.65982	2096980.57474	37.7388794601286	-122.38269830729601	(37.7388794601286, -122.382698307296)
129629	129629	226539	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1220 Potrero Ave	1	: 4	Tree 1	Private 1			23	Width 4ft		6010527.00308	2102195.727	37.7528226993215	-122.406479047766	(37.7528226993215, -122.406479047766)
129630	129630	189587	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	15 Stillman St	2	: 4	Tree 1	Private 1			13	Width 3ft		6014237.43529	2113190.9156400003	37.78321993379179	-122.394417402538	(37.7832199337918, -122.394417402538)
129669	129669	190137	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	411 Barneveld Ave	1	: 4	Tree 1	Private 1			3	Width 2ft		6011221.00191	2097926.45403	37.7411390022656	-122.40377867685301	(37.7411390022656, -122.403778676853)
130152	130152	189050	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1498 Fairfax Ave	7	: 4	Tree 1	Private 1			18	Width 4ft		6016154.01606	2097829.997	37.7411484972995	-122.386715207445	(37.7411484972995, -122.386715207445)
131349	131349	189593	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	411 Bryant St	2	: 4	Tree 1	Private 1			16	Width 3ft		6014388.49606	2113104.8604	37.7829920419783	-122.393888763056	(37.7829920419783, -122.393888763056)
131656	131656	189600	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	420 Bryant St	2	: 4	Tree 1	Private 1			15	Width 3ft		6014290.1250599995	2113010.78907	37.78272827622221	-122.394222500581	(37.7827282762222, -122.394222500581)
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)
133995	133995	189592	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	411 Bryant St	1	: 4	Tree 1	Private 1			16	Width 3ft		6014401.84324	2113116.11767	37.7830236936205	-122.393843375191	(37.7830236936205, -122.393843375191)
134293	134293	189794	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	334 Mississippi St	1	: 4	Tree 1	Private 1			16	Width 4ft		6014017.77828	2105474.1327299997	37.7620191611724	-122.394636773263	(37.7620191611724, -122.394636773263)
134359	134359	249337	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	851 Post St	3	: 4	Tree 1	Private 1			12	Width 3ft		6008084.284109999	2114798.49621	37.787289988396	-122.41581876984199	(37.787289988396, -122.415818769842)
135262	135262	189781	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1651 20th St	3	: 4	Tree 1	Private 1			10	Width 3ft		6013048.21421	2104711.53321	37.7598712788584	-122.39793664395901	(37.7598712788584, -122.397936643959)
137375	137375	249414	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	640 Turk St	3	: 4	Tree 1	Private 1			14	Width 4ft		6006875.43405	2112939.59497	37.782117867684704	-122.419869186806	(37.7821178676847, -122.419869186806)
137804	137804	249336	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	851 Post St	2	: 4	Tree 1	Private 1			11	Width 3ft		6008067.240569999	2114796.28027	37.787282945806396	-122.415877580082	(37.7872829458064, -122.415877580082)
147170	147170	189784	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	230 Texas St	1	: 4	Tree 1	Private 1			20	Width 4ft		6013708.09947	2105987.51004	37.76341156080721	-122.39574381262	(37.7634115608072, -122.39574381262)
147942	147942	189586	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	15 Stillman St	1	: 4	Tree 1	Private 1			20	Width 3ft		6014223.36299	2113181.97862	37.7831946124959	-122.394465461439	(37.7831946124959, -122.394465461439)
148340	148340	189594	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	411 Bryant St	3	: 4	Tree 1	Private 1			16	Width 3ft		6014377.41636	2113091.2514400003	37.78295405913	-122.393926141605	(37.78295405913, -122.393926141605)
150920	150920	190127	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2177 Jerrold Ave	4	: 4	Tree 1	Private 1			21	Width 4ft		6012375.886530001	2099169.2398900003	37.7446158775204	-122.399872724272	(37.7446158775204, -122.399872724272)
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)
151884	151884	249335	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	851 Post St	1	: 4	Tree 1	Private 1			13	Width 3ft		6008046.429819999	2114794.0792400003	37.7872757323303	-122.415949425153	(37.7872757323303, -122.415949425153)
152358	152358	246961	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2179 15th St	1	: 4	Tree 1	Private 1			15	Width 3ft		6003024.34646	2107086.69679	37.765829547320706	-122.43277395635	(37.7658295473207, -122.43277395635)
154514	154514	189589	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	15 Stillman St	4	: 4	Tree 1	Private 1			15	Width 3ft		6014277.53935	2113227.7601799998	37.7833233297614	-122.394281237993	(37.7833233297614, -122.394281237993)
154576	154576	190132	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	100 Industrial St	10	: 4	Tree 1	Private 1			4	Width 4ft		6011496.4373	2097233.7856099997	37.7392524656321	-122.402777612703	(37.7392524656321, -122.402777612703)

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