Street_Tree_List

Data source: data.sfgov.org

134 rows where qSiteInfo = 2 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: SiteOrder, DBH, PlotSize

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
23640	23640	218911	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	623 Laguna Honda Blvd	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5995731.43182	2099885.12493	37.745639539837605	-122.457477374284	(37.7456395398376, -122.457477374284)
24193	24193	127237	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1600 Broadway	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 3ft		6001081.5481199995	2117269.05753	37.7936773440867	-122.440223932108	(37.7936773440867, -122.440223932108)
25036	25036	127225	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2801 Green St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 4ft		5999606.34401	2117712.3673	37.7948104565905	-122.44536013655501	(37.7948104565905, -122.445360136555)
26364	26364	126688	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2801 Divisadero St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 5ft		6000574.048880001	2117936.56798	37.79548124560729	-122.44202785340201	(37.7954812456073, -122.442027853402)
26899	26899	126789	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3544 Baker St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5999210.07801	2121038.76235	37.8039212166464	-122.446970753095	(37.8039212166464, -122.446970753095)
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)
27454	27454	189614	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1022 Harrison St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 0ft		6011103.60933	2110745.72652	37.7763313085817	-122.405087010566	(37.7763313085817, -122.405087010566)
28710	28710	189732	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 Carolina St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 4ft		6012411.88865	2105040.54683	37.7607392181654	-122.400160504611	(37.7607392181654, -122.400160504611)
32907	32907	126694	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2801 Divisadero St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 5ft		6000564.04952	2118006.17276	37.7956717921666	-122.44206745147	(37.7956717921666, -122.44206745147)
35874	35874	189706	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	500 Wisconsin St	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 4ft		6012644.064180001	2105069.3805400003	37.760831332131296	-122.399359532434	(37.7608313321313, -122.399359532434)
36528	36528	127235	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1600 Broadway	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 3ft		6001129.36606	2117275.25182	37.793697074308	-122.44005892269199	(37.793697074308, -122.440058922692)
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)
37044	37044	189726	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	637 Carolina St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 4ft		6012413.83323	2104972.73702	37.760553135844	-122.400149016688	(37.760553135844, -122.400149016688)
37106	37106	127078	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	235 Marina Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 2ft		6002357.66417	2121865.24389	37.8063698385551	-122.43613752782801	(37.8063698385551, -122.436137527828)
37712	37712	189773	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2150 26th St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20			6012060.25758	2101403.52141	37.750733131726605	-122.401121078568	(37.7507331317266, -122.401121078568)
37763	37763	189762	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2200 26th St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24			6011977.64986	2101382.7583	37.7506715119927	-122.401405285922	(37.7506715119927, -122.401405285922)
37918	37918	126693	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2801 Divisadero St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 5ft		6000564.95745	2118000.54097	37.7956563804956	-122.44206390543002	(37.7956563804956, -122.44206390543)
39250	39250	225556	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	25 Temple St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 3ft		5999966.16742	2105813.69675	37.762160286394504	-122.443260079285	(37.7621602863945, -122.443260079285)
40437	40437	189735	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 Carolina St	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 4ft		6012410.52829	2105115.38305	37.7609446260225	-122.400170465508	(37.7609446260225, -122.400170465508)
41517	41517	218917	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	113 Edgehill Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 1ft		5994873.89414	2098975.72105	37.7430932497504	-122.46037670942499	(37.7430932497504, -122.460376709425)
41946	41946	127249	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2401 Broadway	15	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		6002092.09211	2117350.15553	37.7939574999807	-122.436733176716	(37.7939574999807, -122.436733176716)
42006	42006	224870	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	886 Castro St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 4ft		6002438.81243	2103075.7659400003	37.7547832744558	-122.43451238183901	(37.7547832744558, -122.434512381839)
42891	42891	189707	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	500 Wisconsin St	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 4ft		6012643.92045	2105052.7047	37.760785535943796	-122.399358858836	(37.7607855359438, -122.399358858836)
43496	43496	189711	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	500 Wisconsin St	17	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 4ft		6012646.51479	2105003.00325	37.7606492113219	-122.39934639692899	(37.7606492113219, -122.399346396929)
43867	43867	189712	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	500 Wisconsin St	18	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 4ft		6012644.68977	2104989.85234	37.7606130001075	-122.399351785657	(37.7606130001075, -122.399351785657)
45003	45003	189771	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2150 26th St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17			6012116.60941	2101393.437	37.7507085856343	-122.400925499422	(37.7507085856343, -122.400925499422)
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)
46864	46864	218910	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	623 Laguna Honda Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5995736.44002	2099882.18046	37.7456317427251	-122.457459843802	(37.7456317427251, -122.457459843802)
47653	47653	127186	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2025 Lyon St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 4ft		5999405.68269	2115831.81018	37.7896354868404	-122.445919130863	(37.7896354868404, -122.445919130863)
48167	48167	189619	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1022 Harrison St	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 0ft		6010873.70675	2110523.15136	37.775707313965796	-122.40586662925399	(37.7757073139658, -122.405866629254)
49563	49563	127109	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1751 North Point St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 3ft		6002382.406280001	2120876.71316	37.8036570003292	-122.435981124049	(37.8036570003292, -122.435981124049)
51880	51880	127056	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	611 Marina Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5999997.13941	2121576.82436	37.805443524274004	-122.444285775883	(37.805443524274, -122.444285775883)
52180	52180	189767	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2250 26th St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			6011863.83807	2101384.7414	37.750670606386	-122.401798998332	(37.750670606386, -122.401798998332)
52937	52937	126686	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2801 Divisadero St	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 5ft		6000576.75881	2117918.99228	37.795433141791705	-122.44201721443999	(37.7954331417917, -122.44201721444)
53534	53534	123362	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	756 04th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 4ft		5994764.00334	2110429.44522	37.7745359086336	-122.461586911299	(37.7745359086336, -122.461586911299)
53680	53680	126689	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2801 Divisadero St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 5ft		6000572.85603	2117944.92717	37.7955041297654	-122.44203258116	(37.7955041297654, -122.44203258116)
55888	55888	189714	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	550 Wisconsin St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 4ft		6012647.13321	2104908.73509	37.7603904062104	-122.39933764023	(37.7603904062104, -122.39933764023)
56366	56366	127083	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	129 Marina Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 2ft		6002845.61482	2121466.23172	37.8053019664882	-122.43442034344	(37.8053019664882, -122.43442034344)
56736	56736	189769	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2250 26th St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			6011832.10193	2101383.8726	37.750666449719404	-122.401908684142	(37.7506664497194, -122.401908684142)
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)
57993	57993	127107	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1763 North Point St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 3ft		6002331.82998	2120869.8297	37.8036352268581	-122.436155652762	(37.8036352268581, -122.436155652762)
58854	58854	122027	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1305 Cabrillo St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		5991558.6277	2110626.93895	37.7748931489004	-122.47268922403299	(37.7748931489004, -122.472689224033)
59955	59955	218909	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	631 Laguna Honda Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5995768.57404	2099858.15881	37.7455676309566	-122.45734699238399	(37.7455676309566, -122.457346992384)
60085	60085	123361	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	756 04th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 4ft		5994763.35319	2110444.72464	37.7745778244496	-122.46159026828899	(37.7745778244496, -122.461590268289)
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)
60146	60146	126690	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2801 Divisadero St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 5ft		6000570.82689	2117954.15432	37.7955293494555	-122.442040264952	(37.7955293494555, -122.442040264952)
60981	60981	189618	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1022 Harrison St	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 0ft		6010891.122930001	2110540.49572	37.7757559115527	-122.40580760405199	(37.7757559115527, -122.405807604052)
61205	61205	218945	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	6 Laguna Honda Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5995319.838880001	2100306.50618	37.74677289696329	-122.45893109509399	(37.7467728969633, -122.458931095094)
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)
61937	61937	189763	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2200 26th St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17			6011959.27944	2101379.59003	37.7506617876195	-122.401468590114	(37.7506617876195, -122.401468590114)
62530	62530	189709	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	500 Wisconsin St	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 4ft		6012645.7874300005	2105024.7394	37.760708853455704	-122.399350438495	(37.7607088534557, -122.399350438495)
63166	63166	189620	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1022 Harrison St	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 0ft		6010860.68443	2110512.08897	37.7756762109182	-122.405910897479	(37.7756762109182, -122.405910897479)
64432	64432	189622	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1022 Harrison St	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 0ft		6010815.005059999	2110468.41734	37.7755537439388	-122.406065837194	(37.7755537439388, -122.406065837194)
66585	66585	126722	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2600 Green St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		6000563.44048	2117892.65033	37.7953600547671	-122.44206140622101	(37.7953600547671, -122.442061406221)
66793	66793	126725	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2600 Green St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		6000536.04567	2117889.39562	37.795349556998	-122.442155962749	(37.795349556998, -122.442155962749)
66870	66870	189723	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	645 Carolina St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 4ft		6012421.63462	2104907.53528	37.7603745412592	-122.40011745588001	(37.7603745412592, -122.40011745588)
67403	67403	189713	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	500 Wisconsin St	20	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 4ft		6012646.78195	2104977.7853099997	37.7605799833111	-122.399343702572	(37.7605799833111, -122.399343702572)
69658	69658	218908	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	631 Laguna Honda Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		5995776.70302	2099852.9405099996	37.7455537696964	-122.457318506357	(37.7455537696964, -122.457318506357)
70506	70506	189765	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2200 26th St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18			6011917.92181	2101379.95131	37.750660471909704	-122.401611634485	(37.7506604719097, -122.401611634485)
71114	71114	189616	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1022 Harrison St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 0ft		6010960.00413	2110606.3499	37.7759405837328	-122.405573964684	(37.7759405837328, -122.405573964684)
72408	72408	189733	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 Carolina St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 4ft		6012410.849219999	2105048.45516	37.760760874734004	-122.400164654983	(37.760760874734, -122.400164654983)
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)
74912	74912	189764	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2200 26th St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17			6011937.99786	2101379.88854	37.7506614197981	-122.401542205007	(37.7506614197981, -122.401542205007)
75276	75276	189715	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	572 Wisconsin St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 4ft		6012651.9598	2104851.09783	37.760232416003	-122.39931690097201	(37.760232416003, -122.399316900972)
75499	75499	189708	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	500 Wisconsin St	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 4ft		6012646.07352	2105034.04262	37.7607344139903	-122.399350102144	(37.7607344139903, -122.399350102144)
76706	76706	126788	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3544 Baker St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5999213.04425	2121022.9498099997	37.803877969155295	-122.44695934970301	(37.8038779691553, -122.446959349703)
76724	76724	189615	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1022 Harrison St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 0ft		6010985.3669300005	2110629.90425	37.77600667669871	-122.40548788698	(37.7760066766987, -122.40548788698)
96029	96029	122025	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1325 Cabrillo St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5991485.32082	2110624.5167900003	37.7748822545895	-122.47294262886801	(37.7748822545895, -122.472942628868)
129701	129701	127084	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	129 Marina Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 2ft		6002859.14133	2121454.4841400003	37.8052704785265	-122.43437269285499	(37.8052704785265, -122.434372692855)
131423	131423	127224	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2801 Green St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 4ft		5999569.7807	2117708.6209400003	37.7947980828303	-122.44548638071001	(37.7947980828303, -122.44548638071)
132462	132462	126692	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2801 Divisadero St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 5ft		6000565.52048	2117994.74634	37.79564050205379	-122.44206154111001	(37.7956405020538, -122.44206154111)
133352	133352	126691	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2801 Divisadero St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 5ft		6000568.99339	2117964.5679900004	37.795557838165294	-122.442047357013	(37.7955578381653, -122.442047357013)
133357	133357	127223	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2805 Green St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 4ft		5999532.85278	2117700.93935	37.7947748830208	-122.445613603298	(37.7947748830208, -122.445613603298)
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)
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)
136434	136434	127093	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3760 Webster St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 3ft		6002551.5488	2121587.4680000003	37.8056181528115	-122.43544667313299	(37.8056181528115, -122.435446673133)
137627	137627	127077	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	235 Marina Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 2ft		6002342.007569999	2121872.97995	37.806390190207296	-122.43619226415501	(37.8063901902073, -122.436192264155)
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)
149905	149905	126891	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3535 Washington St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		5997843.40756	2115771.32736	37.789380086562794	-122.4513200526	(37.7893800865628, -122.4513200526)
150224	150224	189716	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	572 Wisconsin St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 4ft		6012652.6613300005	2104835.1598	37.7601886927834	-122.399313355828	(37.7601886927834, -122.399313355828)
150505	150505	189731	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 Carolina St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 4ft		6012411.49834	2105033.14539	37.7607188736847	-122.400161334703	(37.7607188736847, -122.400161334703)
150696	150696	127236	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1600 Broadway	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 3ft		6001102.91257	2117270.48902	37.793682490910605	-122.44015011215001	(37.7936824909106, -122.44015011215)
151007	151007	126685	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2801 Divisadero St	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 5ft		6000577.63851	2117912.00016	37.7954139934018	-122.442013668413	(37.7954139934018, -122.442013668413)
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)
152511	152511	189766	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2250 26th St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			6011876.33535	2101384.92006	37.7506717943678	-122.40175579399299	(37.7506717943678, -122.401755793993)
153235	153235	218920	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	113 Edgehill Way	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 1ft		5994843.7095	2098965.85604	37.7430644264715	-122.460480364392	(37.7430644264715, -122.460480364392)
154337	154337	127222	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2805 Green St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 4ft		5999514.15871	2117699.6383	37.794770243393	-122.4456781935	(37.794770243393, -122.4456781935)
156187	156187	119139	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	549 47th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5981289.11687	2111973.6044900003	37.777990882347495	-122.508312980233	(37.7779908823475, -122.508312980233)
156643	156643	189730	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 Carolina St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 4ft		6012412.96907	2105022.8383299997	37.7606906547821	-122.400155524183	(37.7606906547821, -122.400155524183)
156859	156859	189621	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1022 Harrison St	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 0ft		6010839.6718	2110492.69386	37.7756217812499	-122.405982219115	(37.7756217812499, -122.405982219115)
157014	157014	126724	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2600 Green St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		6000544.44011	2117891.24554	37.795355114786794	-122.44212704955	(37.7953551147868, -122.44212704955)
157457	157457	189718	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	572 Wisconsin St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 4ft		6012648.68072	2104830.95357	37.7601769215491	-122.399326827679	(37.7601769215491, -122.399326827679)
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)
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)
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)
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)
159857	159857	127086	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1400 Jefferson St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		6002483.38051	2121629.71373	37.805730276683	-122.435685603204	(37.805730276683, -122.435685603204)
160041	160041	189724	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	645 Carolina St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 4ft		6012422.04751	2104914.38437	37.7603933703686	-122.400116508894	(37.7603933703686, -122.400116508894)

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