Street_Tree_List

Data source: data.sfgov.org

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

Search:

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

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

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

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

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

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant

Link	rowid ▲	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
189132	189132	127661	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	351 Hayes St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 5ft		6006169.59466	2111057.68357	37.776910807423	-122.42217733372101	(37.776910807423, -122.422177333721)
189049	189049	224725	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 Treat Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6008501.01971	2104985.35015	37.7603688215875	-122.41368259038299	(37.7603688215875, -122.413682590383)
189040	189040	127212	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2332 Baker St	16	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		5999771.60185	2117008.74774	37.7928879353713	-122.444737723873	(37.7928879353713, -122.444737723873)
188992	188992	224334	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 Fair Oaks St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 4ft		6005384.8818	2103641.26634	37.756502803379	-122.42436427271099	(37.756502803379, -122.424364272711)
188919	188919	128603	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	302 Clay St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6012734.44977	2117571.80464	37.7951651617906	-122.39992490023899	(37.7951651617906, -122.399924900239)
188871	188871	190172	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	91 Spear St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 4ft		6014300.683019999	2116737.7398099997	37.792962209493496	-122.39444701903	(37.7929622094935, -122.39444701903)
188853	188853	126890	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3535 Washington St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		5997854.60212	2115773.0434	37.7893854393346	-122.45128144470199	(37.7893854393346, -122.451281444702)
188848	188848	127426	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1870 Sacramento St	5	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 5ft		6005819.50643	2116272.06707	37.79120846673779	-122.423759246615	(37.7912084667378, -122.423759246615)
188812	188812	127080	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	225 Marina Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 2ft		6002392.83913	2121845.29115	37.8063170519664	-122.43601437016501	(37.8063170519664, -122.436014370165)
188806	188806	224362	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3298 16th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 8ft		6005110.48857	2106660.40423	37.764777144474394	-122.42552808356001	(37.7647771444744, -122.42552808356)
188771	188771	190201	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	100 Mission St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 4ft		6014306.70716	2116527.44421	37.7923851217206	-122.39441144365601	(37.7923851217206, -122.394411443656)
188717	188717	226559	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	500 Dolores St	23	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 6ft		6004935.37263	2104529.68791	37.758916806783795	-122.425982076637	(37.7589168067838, -122.425982076637)
188716	188716	224904	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1130 Shotwell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6008033.04615	2101317.58647	37.750271686907396	-122.415041484884	(37.7502716869074, -122.415041484884)
188715	188715	117410	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 Beach St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	3x3		6010007.96728	2122282.37389	37.8079468411282	-122.40969164376999	(37.8079468411282, -122.40969164377)
188714	188714	192026	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	228 Townsend St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6014357.45044	2111330.04165	37.7781170671892	-122.39387189357201	(37.7781170671892, -122.393871893572)
188701	188701	224871	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	243 Chenery St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 4ft		6004648.05495	2096912.1028200001	37.7379844377336	-122.42643336811001	(37.7379844377336, -122.42643336811)
188689	188689	41258	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	201 California St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/07/1999 12:00:00 AM	4		Permit Number 41947	6012985.5179	2116864.57793	37.793237278822204	-122.399006496356	(37.7932372788222, -122.399006496356)
188659	188659	224365	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3265 16th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 6ft		6005109.72115	2106603.48826	37.7646208234183	-122.42552668692	(37.7646208234183, -122.42552668692)
188658	188658	115586	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	490 02nd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	3x3		6014380.71599	2113178.02492	37.7831925026787	-122.39392080232	(37.7831925026787, -122.39392080232)
188644	188644	224899	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	220 Bonview St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6006906.54916	2097732.5595299997	37.7403646419256	-122.41868278860301	(37.7403646419256, -122.418682788603)
188635	188635	128413	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	48 Campton Pl	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 3ft		6010829.24578	2115389.17061	37.7890657717061	-122.406363370683	(37.7890657717061, -122.406363370683)
188597	188597	63627	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	67 University St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/19/1987 12:00:00 AM	4		Permit Number 24270	6007827.91665	2093727.62728	37.7294198035797	-122.415213626819	(37.7294198035797, -122.415213626819)
188592	188592	246684	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	65 Randall St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 4ft		6004997.42528	2097597.83608	37.73988704974779	-122.425274204056	(37.7398870497478, -122.425274204056)
188556	188556	192021	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	477 Brannan St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6013715.13183	2111494.11021	37.77853184531921	-122.39610542282101	(37.7785318453192, -122.396105422821)
188535	188535	127129	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2306 Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			26	Width 5ft		6002805.59045	2116260.40582	37.79100585039561	-122.434186463044	(37.7910058503956, -122.434186463044)
188534	188534	106943	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2336 Divisadero St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	6x9		6000836.4507	2116444.1968400003	37.7913985348765	-122.44101278413099	(37.7913985348765, -122.441012784131)
188525	188525	31337	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	745 Buchanan St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/12/1995 12:00:00 AM	16	6x18	Permit Number 34951	6004453.62375	2111092.9915400003	37.7769108173179	-122.42811591873699	(37.7769108173179, -122.428115918737)
188508	188508	65025	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2826 Gough St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	04/28/1989 12:00:00 AM	16		Permit Number 26076	6004809.703480001	2119306.48905	37.7994831621734	-122.427469404204	(37.7994831621734, -122.427469404204)
188507	188507	224753	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1670 Alabama St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			26	Width 3ft		6009278.36268	2099633.18805	37.74571660363	-122.41061614773199	(37.74571660363, -122.410616147732)
188491	188491	218955	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	118 Kensington Way	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5994914.67576	2098399.27134	37.7415128081785	-122.46019394380801	(37.7415128081785, -122.460193943808)
188450	188450	127730	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1315 Sacramento St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6008458.84125	2116599.72906	37.7922567839761	-122.414650393123	(37.7922567839761, -122.414650393123)
188437	188437	249364	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	650 Leavenworth St	1	: 4	Tree 1	Private 1			15	Width 3ft		6008364.20652	2114704.18195	37.7870467568593	-122.41484361694201	(37.7870467568593, -122.414843616942)
188410	188410	127294	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2753 Fillmore St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 4ft		6002585.68226	2117512.73305	37.7944319346497	-122.435036941128	(37.7944319346497, -122.435036941128)
188379	188379	122058	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	101 18th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		5990191.66474	2114668.45777	37.785910814474704	-122.477713273252	(37.7859108144747, -122.477713273252)
188358	188358	124244	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1130 Clement St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 7ft		5991991.6420599995	2113466.17808	37.7827139803523	-122.47139827219802	(37.7827139803523, -122.471398272198)
188305	188305	45567	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	250 Laurel St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/07/2014 12:00:00 AM	5		Permit Number 772596	5998102.08454	2115576.16187	37.788859022076295	-122.45041098909401	(37.7888590220763, -122.450410989094)
188275	188275	190295	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	180 Spear St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6014925.69453	2115995.23175	37.7909581791127	-122.39223247535801	(37.7909581791127, -122.392232475358)
188208	188208	225580	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	56 Potomac St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6003134.5643	2108628.68734	37.770069727566295	-122.432502885425	(37.7700697275663, -122.432502885425)
188186	188186	218852	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1346 16th Ave	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			13	Width 3ft		5991155.44082	2106257.8165599997	37.7628733705378	-122.473765117276	(37.7628733705378, -122.473765117276)
188164	188164	189603	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	514 Bryant St	2	: 4	Tree 1	Private 1			14	Width 3ft		6013664.01939	2112409.94185	37.7810436661816	-122.39634644924801	(37.7810436661816, -122.396346449248)
188160	188160	127147	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2889 Washington St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6000958.98087	2116200.88741	37.7907374486335	-122.440571374383	(37.7907374486335, -122.440571374383)
188121	188121	128162	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2802 Jones St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6007823.469380001	2122122.71011	37.807385789190704	-122.417240345286	(37.8073857891907, -122.417240345286)
188046	188046	224921	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	404 Diamond St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			23	Width 5ft		6001773.50146	2103458.40142	37.755796109818704	-122.43684059623199	(37.7557961098187, -122.436840596232)
188036	188036	126894	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3232 Pacific Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 4ft		5998802.70995	2116602.87757	37.791718185386706	-122.44806088700199	(37.7917181853867, -122.448060887002)
188015	188015	189780	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1651 20th St	2	: 4	Tree 1	Private 1			10	Width 3ft		6013032.11681	2104710.31542	37.7598670385488	-122.397992231954	(37.7598670385488, -122.397992231954)
187988	187988	224332	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3641 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6005537.20611	2101947.34988	37.751860302410606	-122.42371704413	(37.7518603024106, -122.42371704413)
187980	187980	226508	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	520 South Van Ness Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 4ft		6007418.63528	2106509.26489	37.76449229679179	-122.417534071059	(37.7644922967918, -122.417534071059)
187885	187885	127490	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1000 Sutter St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 4ft		6007656.89689	2115128.3654099996	37.788171692705795	-122.41732082828699	(37.7881716927058, -122.417320828287)
187867	187867	126852	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3300 Pierce St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 2ft		6001355.81378	2119802.66392	37.8006495729845	-122.439456653911	(37.8006495729845, -122.439456653911)
187826	187826	176464	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	300 Gaven St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 4ft		6008910.663480001	2094859.0925900002	37.7325873561203	-122.41155036257099	(37.7325873561203, -122.411550362571)
187820	187820	190348	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	446 Spear St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 4ft		6016052.989580001	2114824.98528	37.7878074780845	-122.388250337589	(37.7878074780845, -122.388250337589)
187817	187817	225003	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	459 Sanchez St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 3ft		6003637.14023	2105607.06329	37.761801565713	-122.430548844757	(37.761801565713, -122.430548844757)
187809	187809	128526	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	300 California St	5	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 4ft		6012563.28952	2116872.1643	37.7932345718721	-122.40046797652701	(37.7932345718721, -122.400467976527)
187786	187786	190284	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	190 Steuart St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6015126.83136	2116303.99434	37.791817136007104	-122.391558140299	(37.7918171360071, -122.391558140299)
187704	187704	58265	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3773 Clay St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/17/1979 12:00:00 AM	8		Permit Number 18039	5996781.674769999	2115294.23702	37.7880092733608	-122.45495901893999	(37.7880092733608, -122.45495901894)
187694	187694	192155	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1404 Mission St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 3ft		6007717.03674	2110231.31305	37.774728951406104	-122.416765686697	(37.7747289514061, -122.416765686697)
187693	187693	128196	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	149 Beach St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6009829.55437	2122260.48779	37.8078767479704	-122.41030754266899	(37.8078767479704, -122.410307542669)
187684	187684	192066	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	400 15th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6011269.0088599995	2107470.7193	37.767348133541205	-122.404284283802	(37.7673481335412, -122.404284283802)
187682	187682	218906	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	160 Dorantes Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		5993761.1168599995	2099844.95033	37.7454158586537	-122.46428745721	(37.7454158586537, -122.46428745721)
187656	187656	126740	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2526 Union St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6000711.39573	2118260.58718	37.796378742941606	-122.441575874852	(37.7963787429416, -122.441575874852)
187649	187649	225506	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	450 Church St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 4ft		6004191.48893	2106316.33024	37.763780431248605	-122.428682135469	(37.7637804312486, -122.428682135469)
187639	187639	224959	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	184 Clipper St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 3ft		6003924.61092	2101024.3627	37.7492348333324	-122.429227814433	(37.7492348333324, -122.429227814433)
187632	187632	68261	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	331 Holyoke St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/09/1993 12:00:00 AM	4		Permit Number 32067	6009662.93548	2092873.24927	37.72717681975	-122.40880951134301	(37.72717681975, -122.408809511343)
187542	187542	128288	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	101 Lombard St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6011508.83416	2120753.62103	37.803833252157396	-122.404389812943	(37.8038332521574, -122.404389812943)
187514	187514	127586	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	10 Ada Ct	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6008112.096419999	2114177.6862	37.7855869584016	-122.41567857183	(37.7855869584016, -122.41567857183)
187480	187480	71692	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	364 Hayes St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/19/1981 12:00:00 AM	26	6x7		6006147.03421	2111101.3621799997	37.777029465781496	-122.422258481339	(37.7770294657815, -122.422258481339)
187476	187476	128186	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	151 Beach St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6009453.22814	2122211.38304	37.807720816332896	-122.411606446096	(37.8077208163329, -122.411606446096)
187458	187458	225415	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	789 Noe St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6003100.40659	2103660.40939	37.7564261001934	-122.432266160473	(37.7564261001934, -122.432266160473)
187418	187418	117350	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	391 Hayes St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	3x3		6006016.7159400005	2111041.8116	37.7768586026778	-122.42270506039699	(37.7768586026778, -122.422705060397)
187400	187400	224378	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1851 15th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 6ft		6005223.79384	2107208.92105	37.766289642272504	-122.425175222853	(37.7662896422725, -122.425175222853)
187380	187380	224767	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	308 Lily St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6004967.19895	2110061.42624	37.7741074344349	-122.426265843319	(37.7741074344349, -122.426265843319)
187348	187348	126855	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2166 Chestnut St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 3ft		6001467.42249	2119756.71282	37.8005297545057	-122.439067147637	(37.8005297545057, -122.439067147637)
187325	187325	48432	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1190 Sacramento St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/26/2002 12:00:00 AM	11		Permit Number 45810	6009089.71563	2116719.69738	37.7926216119548	-122.41247603116501	(37.7926216119548, -122.412476031165)
187315	187315	218888	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1355 08th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 2ft		5993614.91113	2106274.6654	37.7630617730996	-122.465259958907	(37.7630617730996, -122.465259958907)
187311	187311	128138	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2600 Jones St	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6007845.13181	2121937.6775700003	37.8068789555583	-122.417152257582	(37.8068789555583, -122.417152257582)
187308	187308	128210	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1075 Front St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6012623.01173	2119782.0506700003	37.8012277543156	-122.40046582444499	(37.8012277543156, -122.400465824445)
187305	187305	120788	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	415 21st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		5989337.08046	2112514.31643	37.7799465157752	-122.48051212362499	(37.7799465157752, -122.480512123625)
187290	187290	128244	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	17 Lombard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 4ft		6011882.21543	2120801.15498	37.80398462694821	-122.403101043101	(37.8039846269482, -122.403101043101)
187270	187270	117111	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	383 Rhode Island St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	7x5		6011764.5702	2106656.38691	37.7651398392517	-122.40251292782699	(37.7651398392517, -122.402512927827)
187262	187262	31505	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	101 28th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/30/2014 12:00:00 AM	13	3x3	Permit Number 54070	6005154.62899	2099588.74591	37.7453625153619	-122.424872264669	(37.7453625153619, -122.424872264669)
187246	187246	128422	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	555 California St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 5ft		6011620.77993	2116677.04557	37.7926462165134	-122.403715404142	(37.7926462165134, -122.403715404142)
187213	187213	128689	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	300 Washington St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6012940.41857	2117912.34834	37.7961116946655	-122.39923612834	(37.7961116946655, -122.39923612834)
187111	187111	126704	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1910 Union St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 3ft		6003768.9976699995	2118687.84204	37.797725600913296	-122.431026437836	(37.7977256009133, -122.431026437836)
187099	187099	65403	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	840 Geary St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/02/1989 12:00:00 AM	15		Permit Number 28252	6007717.08524	2114448.95426	37.7863095816566	-122.41706442708599	(37.7863095816566, -122.417064427086)
187097	187097	218914	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	265 Casitas Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5994998.52296	2096325.6672900002	37.7358240260431	-122.459753867773	(37.7358240260431, -122.459753867773)
187079	187079	64239	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	100 26th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/11/1988 12:00:00 AM	6		Permit Number 25032	5987737.4253	2115200.68824	37.7872294336752	-122.48624324308099	(37.7872294336752, -122.486243243081)
187071	187071	225440	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	4614 18th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 3ft		6000488.22886	2105219.21001	37.7605577277636	-122.441411813324	(37.7605577277636, -122.441411813324)
187021	187021	128415	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	555 California St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 4ft		6011478.27052	2116657.13994	37.792583598491504	-122.404207093202	(37.7925835984915, -122.404207093202)
186990	186990	127802	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	945 Union St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6008446.28486	2119301.06839	37.7996732887356	-122.414885112579	(37.7996732887356, -122.414885112579)
186956	186956	224733	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3590 19th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 3ft		6005695.82472	2104922.4558900003	37.7600382038289	-122.423379996206	(37.7600382038289, -122.423379996206)
186943	186943	246677	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	25 Randall St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14			6005248.94304	2097610.63078	37.7399363874552	-122.424405469757	(37.7399363874552, -122.424405469757)
186904	186904	122327	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1652 Greenwich St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3x3		6004971.37179	2119547.67497	37.8001545393563	-122.42692716065399	(37.8001545393563, -122.426927160654)
186872	186872	57399	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1500 Clay St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/02/1976 12:00:00 AM	13		Permit Number 16239	6007504.46351	2116826.6452099998	37.7928261735302	-122.41796866032601	(37.7928261735302, -122.417968660326)
186870	186870	68201	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2400 Filbert St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/29/1993 12:00:00 AM	19		Permit Number 31983	6001408.58226	2118706.52124	37.79764285697971	-122.43919544492701	(37.7976428569797, -122.439195444927)
186856	186856	224747	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3676 23rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 5ft		6005225.561919999	2102557.6638700003	37.7535184858989	-122.424838169557	(37.7535184858989, -122.424838169557)
186823	186823	128199	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	57 Union St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6012331.79959	2119825.41249	37.801330571117795	-122.40147660126199	(37.8013305711178, -122.401476601262)
186786	186786	192101	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	407 Bryant St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6014433.850190001	2113057.6117599998	37.7828648283935	-122.39372854705799	(37.7828648283935, -122.393728547058)
186780	186780	218946	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	15 Merced Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			37	Width 3ft		5995278.15169	2100133.50673	37.7462954873605	-122.459062719878	(37.7462954873605, -122.459062719878)
186742	186742	127607	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	91 Myrtle St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 4ft		6007061.893759999	2114145.37635	37.785439152144896	-122.419309682605	(37.7854391521449, -122.419309682605)
186741	186741	189754	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1411 Kansas St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 5ft		6011759.63515	2101724.24628	37.7515969971051	-122.40218320940399	(37.7515969971051, -122.402183209404)

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