Street_Tree_List

Data source: data.sfgov.org

1,169 rows where SiteOrder = 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: qLegalStatus, qCareAssistant

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
143	143	18836	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2055 Sacramento St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6004953.14987	2116100.2629400003	37.7906877916676	-122.426744576702	(37.7906877916676, -122.426744576702)
312	312	226557	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	320 Dolores St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 7ft		6004833.37225	2106401.74543	37.7640512674875	-122.42646813862	(37.7640512674875, -122.42646813862)
461	461	98533	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1805X Baker St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	6x6	Permit Number 779899	5999986.39066	2115181.83206	37.787883958235504	-122.44386322941901	(37.7878839582355, -122.443863229419)
592	592	251331	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2232 Webster St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6003295.0	2116396.0	37.791405922266996	-122.43250281523301	(37.791405922267, -122.432502815233)
926	926	19204	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	630 Sansome St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6012243.07343	2117875.4725099998	37.7959715542054	-122.401646502996	(37.7959715542054, -122.401646502996)
928	928	224422	Property Tree 7	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3255x 24th St	2	Front Yard : Cutout 8	Tree 1	MTA 6			16	Width 3ft		6007298.0	2102020.0	37.7521590216883	-122.417633107694	(37.7521590216883, -122.417633107694)
941	941	18512	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	626 Powell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6010135.39241	2115955.1821	37.790581064620106	-122.408803973339	(37.7905810646201, -122.408803973339)
1021	1021	189660	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2573 03rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	Width 4ft		6015900.45488	2103484.96239	37.7566618134199	-122.38798645493601	(37.7566618134199, -122.387986454936)
1057	1057	189664	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2585 03rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			20	Width 5ft		6015924.43943	2103136.85911	37.755707324239395	-122.38787921795799	(37.7557073242394, -122.387879217958)
1381	1381	189623	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	347 10th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6009091.0	2109329.0	37.7723285943803	-122.411949073152	(37.7723285943803, -122.411949073152)
1403	1403	122808	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1830 17th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/15/2017 12:00:00 AM	3	4x4		6011911.59203	2106562.15691	37.7648893115244	-122.401997787192	(37.7648893115244, -122.401997787192)
1627	1627	101897	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1030 Leavenworth St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3x3	Permit Number 769674	6008181.44725	2116041.89613	37.7907095228698	-122.415570672075	(37.7907095228698, -122.415570672075)
1678	1678	25510	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1845 Gough St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3X3		6005220.005340001	2116049.4982	37.7905634882709	-122.42581765535401	(37.7905634882709, -122.425817655354)
1771	1771	192159	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	13 South Van Ness Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			21	Width 3ft	Permit Number 779453	6007133.19838	2109972.1913099997	37.7739846095361	-122.41876692647	(37.7739846095361, -122.41876692647)
1903	1903	127944	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	101 Vallejo St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/12/2017 12:00:00 AM	3	Width 3ft		6012622.90875	2119176.76577	37.7995657819845	-122.400423640834	(37.7995657819845, -122.400423640834)
1911	1911	127947	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	855 Front St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/12/2017 12:00:00 AM	3	Width 3ft		6012711.6665	2119148.4967900002	37.7994931113801	-122.400114518675	(37.7994931113801, -122.400114518675)
2043	2043	127861	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1898 Hyde St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			19	Width 3ft		6007317.93078	2118761.71757	37.798128900073294	-122.418751368192	(37.7981289000733, -122.418751368192)
2170	2170	127072	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3399X Steiner St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 4ft	Permit Number 779572	6001832.0	2119600.0	37.800120199825	-122.437794333712	(37.800120199825, -122.437794333712)
2209	2209	189798	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 Potrero Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			17	Width 3ft		6010293.93626	2108038.50565	37.7688526102954	-122.407696978027	(37.7688526102954, -122.407696978027)
2770	2770	9915	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1900 Gough St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			26	3X3		6005229.572240001	2116308.1912	37.791274334888705	-122.42580297571999	(37.7912743348887, -122.42580297572)
2950	2950	9693	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	414 Gough St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/17/2012 12:00:00 AM	3	3X3		6005939.70475	2111200.2280099997	37.777289230461705	-122.422982727867	(37.7772892304617, -122.422982727867)
3059	3059	126695	Significant Tree 6	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2829 Divisadero St	2	Front Yard : Yard 7	Tree 1	Private 1			11	10x10	Permit Number 779774	6000551.43021	2118023.61416	37.7957189625051	-122.44211236900601	(37.7957189625051, -122.442112369006)
3067	3067	104742	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 Waverly Pl	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3x3		6010759.24365	2116982.20549	37.793435947175205	-122.406717882525	(37.7934359471752, -122.406717882525)
3574	3574	127916	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1175 Columbus Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 4ft		6007863.0053199995	2121226.60678	37.8049275409425	-122.417039987112	(37.8049275409425, -122.417039987112)
3594	3594	127750	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1033 Jones St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6008528.0	2116225.0	37.791231755005896	-122.41438457516001	(37.7912317550059, -122.41438457516)
3728	3728	18515	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	634 Powell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6010129.36296	2116007.85487	37.790725353638	-122.408828552704	(37.790725353638, -122.408828552704)
3741	3741	11063	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1706 Hyde St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			70	3X4		6007392.7334199995	2118206.86499	37.7966096249815	-122.418453164696	(37.7966096249815, -122.418453164696)
4314	4314	100306	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1434 Taylor St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/14/2012 12:00:00 AM	2	3x3	Permit Number 769213	6008902.154180001	2117844.1551	37.795698569500104	-122.413204553065	(37.7956985695001, -122.413204553065)
4868	4868	225613	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	235 Laussat St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6003605.0	2109124.0	37.77145640087421	-122.430911009882	(37.7714564008742, -122.430911009882)
5073	5073	104053	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2465 Washington St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18			6002918.10064	2116474.72915	37.791600712350295	-122.433812507839	(37.7916007123503, -122.433812507839)
5202	5202	123243	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	590 08th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 4ft	Permit Number 780398	5993481.9137	2111464.4660900002	37.7773039172851	-122.466097100812	(37.7773039172851, -122.466097100812)
5365	5365	23511	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2642 Van Ness Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			30	3X3		6005783.8382	2119486.2694099997	37.8000318412439	-122.42411133926599	(37.8000318412439, -122.424111339266)
5845	5845	110971	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2485 Washington St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			22	3x3		6002809.55078	2116465.5408400004	37.791569323321	-122.434187431628	(37.791569323321, -122.434187431628)
5960	5960	23430	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1940 Van Ness Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			20	3X3		6006108.8789099995	2117166.17514	37.793679794731396	-122.422821595465	(37.7936797947314, -122.422821595465)
6036	6036	11119	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2100 Hyde St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x4		6007209.66009	2119548.23397	37.8002823797943	-122.41918183766701	(37.8002823797943, -122.419181837667)
6302	6302	106216	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	585X Bush St	2	Sidewalk: Curb side : Cutout 1	Tree 1	MTA 6			10	3x5		6010698.10573	2115852.22595	37.7903298740626	-122.406849749212	(37.7903298740626, -122.406849749212)
6379	6379	7348	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2226 Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6002838.16405	2116011.64355	37.79032466161	-122.434055969611	(37.79032466161, -122.434055969611)
6450	6450	18841	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2085 Sacramento St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	2x2		6004830.024730001	2116087.16929	37.79064487779711	-122.427169650269	(37.7906448777971, -122.427169650269)
6527	6527	18518	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	655 Powell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	4X4		6010076.89605	2116057.79617	37.7908595414795	-122.409013611597	(37.7908595414795, -122.409013611597)
6647	6647	23432	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1946 Van Ness Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			21	3X3		6006100.2402099995	2117213.04995	37.7938080137776	-122.42285481909799	(37.7938080137776, -122.422854819098)
6745	6745	7365	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2360 Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6002776.693940001	2116420.21341	37.791443000945705	-122.43429787376002	(37.7914430009457, -122.43429787376)
6860	6860	93474	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1345 Sacramento St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	3x2		6008356.752640001	2116586.1732799998	37.792213826952704	-122.41500266293501	(37.7922138269527, -122.415002662935)
6871	6871	9692	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	330 Gough St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6005977.63731	2110934.31764	37.7765612454456	-122.422832604057	(37.7765612454456, -122.422832604057)
6888	6888	27268	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2080 Van Ness Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			16	3X3		6006061.90991	2117499.35626	37.794591976178296	-122.423007804569	(37.7945919761783, -122.423007804569)
6936	6936	113768	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2580 Broadway	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/12/2016 12:00:00 AM	3	3x3	Permit Number 777079	6001245.42868	2117302.08267	37.7937773514059	-122.43965926129101	(37.7937773514059, -122.439659261291)
7086	7086	6376	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	311X Elm St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	4X4		6006100.46192	2112621.53299	37.7812008577844	-122.422527635837	(37.7812008577844, -122.422527635837)
7104	7104	11125	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2115 Hyde St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6007141.03643	2119683.43961	37.8006497555411	-122.419428900332	(37.8006497555411, -122.419428900332)
7205	7205	18500	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	519X Powell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	4X4		6010154.14929	2115557.66128	37.789490618641295	-122.408711019419	(37.7894906186413, -122.408711019419)
7209	7209	106548	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1439 Green St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	3x3		6006143.70032	2118621.75372	37.797678411694	-122.422804603669	(37.797678411694, -122.422804603669)
7221	7221	109623	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	451 Jackson St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/16/2015 12:00:00 AM	3	3x3	Permit Number 775170	6011938.15364	2118065.18841	37.79647544883721	-122.402714938942	(37.7964754488372, -122.402714938942)
7245	7245	7988	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2123 Franklin St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6005523.45781	2117337.0408	37.794115900277205	-122.424859366576	(37.7941159002772, -122.424859366576)
7303	7303	7359	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2318 Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6002798.384190001	2116304.6096200002	37.7911268136944	-122.434214557878	(37.7911268136944, -122.434214557878)
7318	7318	23526	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2750 Van Ness Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			23	3X3		6005750.26843	2119815.94369	37.8009351472915	-122.424250963512	(37.8009351472915, -122.424250963512)
7336	7336	11048	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1563 Hyde St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			70	4x4		6007418.062059999	2117715.56837	37.7952620727512	-122.418330669843	(37.7952620727512, -122.418330669843)
7378	7378	2811	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1075 California St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	2X2		6009171.094	2116334.89627	37.791569608406895	-122.412167249844	(37.7915696084069, -122.412167249844)
7389	7389	18951	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2841 Sacramento St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			16	3X3		6001216.78701	2115581.69582	37.789051985994	-122.439634971495	(37.789051985994, -122.439634971495)
7532	7532	11105	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2000 Hyde St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			70	3X3		6007252.676530001	2119218.74255	37.7993801016803	-122.41900960041401	(37.7993801016803, -122.419009600414)
7611	7611	93477	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	113X Leroy Pl	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	1.5x3	Tree 2 on Leroy	6008311.901880001	2116662.47431	37.7924208104303	-122.415163251278	(37.7924208104303, -122.415163251278)
7636	7636	99241	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	560X Ellis St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Rec/Park 3			10	4x4		6008235.1228	2113825.75072	37.7846275436788	-122.415228013286	(37.7846275436788, -122.415228013286)
7684	7684	101521	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3010 Clay St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	4x4	Permit Number 23924	6000238.846469999	2115823.4476799998	37.7896600644188	-122.443035877412	(37.7896600644188, -122.443035877412)
7752	7752	115670	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2600X Scott St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/12/2016 12:00:00 AM	3	3x3	Permit Number 777079	6001200.65079	2117319.78555	37.7938234101762	-122.43981546632	(37.7938234101762, -122.43981546632)
7865	7865	4751	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1201 Columbus Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			50	3X3		6007679.06678	2121391.72732	37.8053705712658	-122.41768823913601	(37.8053705712658, -122.417688239136)
7893	7893	113778	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1753 Greenwich St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/22/2016 12:00:00 AM	3	3x3	Permit Number 776886	6004527.88766	2119441.95127	37.7998391633122	-122.428454248166	(37.7998391633122, -122.428454248166)
8227	8227	105539	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2098X Greenwich St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	12x8		6002981.58919	2119269.06905	37.799276850493996	-122.433792649035	(37.799276850494, -122.433792649035)
8255	8255	98623	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3500X Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2		12	6x6		6002295.23154	2119980.02637	37.80118998188	-122.43621858733299	(37.80118998188, -122.436218587333)
8391	8391	7856	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	915 Franklin St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3X3		6006092.78469	2113271.83344	37.782985990458606	-122.422600419785	(37.7829859904586, -122.422600419785)
8484	8484	27265	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1735 Van Ness Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			8	2X2		6006106.90098	2116460.38112	37.791741749419295	-122.422778257137	(37.7917417494193, -122.422778257137)
8497	8497	99180	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	350 Beach St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	3x3		6008539.94575	2122132.3901400003	37.807452650197	-122.41476149536699	(37.807452650197, -122.414761495367)
8540	8540	11128	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2124 Hyde St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			50	3X3		6007192.56875	2119648.8163799997	37.8005575912102	-122.419248119507	(37.8005575912102, -122.419248119507)
8593	8593	11052	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1601 Hyde St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			70	3X3		6007402.40355	2117857.62243	37.7956512363783	-122.418394928194	(37.7956512363783, -122.418394928194)
8625	8625	112608	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2200X Steiner St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			27	3x3		6002378.33364	2115831.7760400004	37.7898046843888	-122.43563407476101	(37.7898046843888, -122.435634074761)
8716	8716	100476	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	340 Mason St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	3x3		6009833.38685	2114620.58318	37.786899656544705	-122.409754655664	(37.7868996565447, -122.409754655664)
8787	8787	11101	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1954 Hyde St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			70	3X3		6007270.585390001	2119081.1863	37.7990034152267	-122.418937867815	(37.7990034152267, -122.418937867815)
8948	8948	7955	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1756 Franklin St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3X3		6005731.7408300005	2116171.91633	37.790928523081895	-122.424055788151	(37.7909285230819, -122.424055788151)
9012	9012	11097	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1930 Hyde St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			70	3X3		6007278.45191	2119022.53652	37.7988428206086	-122.418906485047	(37.7988428206086, -122.418906485047)
11127	11127	17225	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1880X Alemany Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/06/1990 12:00:00 AM	20	3X3		6001020.116669999	2091172.22125	37.7220182913915	-122.438565764807	(37.7220182913915, -122.438565764807)
12965	12965	96562	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	421 Hamilton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	2x2		6009504.65574	2092358.16495	37.7257536399061	-122.40932035147199	(37.7257536399061, -122.409320351472)
13839	13839	100181	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	230 Ritch St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15			6013794.16577	2112184.81721	37.7804327665865	-122.39588042503999	(37.7804327665865, -122.39588042504)
13921	13921	100267	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 Federal St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	1x1		6015119.18661	2113440.6394599997	37.783954595377104	-122.391384334617	(37.7839545953771, -122.391384334617)
14075	14075	19383	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	550 06th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/09/1993 12:00:00 AM	6	3X3		6012054.10922	2110354.99744	37.77531154572979	-122.40177147639	(37.7753115457298, -122.40177147639)
14119	14119	15268	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1535 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	3X3		6007464.35841	2109890.1913799997	37.7737780973065	-122.417615572103	(37.7737780973065, -122.417615572103)
14164	14164	114473	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	145 South Van Ness Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15			6007374.36978	2108955.06944	37.7712054103423	-122.41786055823799	(37.7712054103423, -122.417860558238)
14397	14397	100256	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2X Federal St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	2x2		6015186.92454	2113537.3546700003	37.7842239126372	-122.391156746807	(37.7842239126372, -122.391156746807)
14444	14444	18315	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	180 Potrero Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			40	4X4		6010239.5154099995	2107483.3538	37.7673252439851	-122.40784606493901	(37.7673252439851, -122.407846064939)
14496	14496	843	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	111X Potrero Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/31/2015 12:00:00 AM	40	3x3	Permit Number 777000	6010316.34076	2107575.5688099996	37.7675827459718	-122.407586838062	(37.7675827459718, -122.407586838062)
14715	14715	18348	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	450 Potrero Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			40	3x3		6010315.31619	2106176.19135	37.7637403169978	-122.407491711398	(37.7637403169978, -122.407491711398)
14823	14823	18356	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	530 Potrero Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			40	3x3		6010323.6176	2105892.85967	37.7629628170943	-122.407443022981	(37.7629628170943, -122.407443022981)
15174	15174	112196	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	325 05th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			36			6011775.52702	2112050.94015	37.7799526626161	-122.40285446518601	(37.7799526626161, -122.402854465186)
15425	15425	112142	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	275 05th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	3x3		6011537.6076	2112303.10611	37.7806317640729	-122.403695287202	(37.7806317640729, -122.403695287202)
15609	15609	18334	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	301 Potrero Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			45	3X3		6010355.24064	2106864.9460400003	37.765633715437495	-122.40740218388599	(37.7656337154375, -122.407402183886)
15885	15885	102737	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	665 Minna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	3x3		6009147.89785	2111222.04181	37.7775296345182	-122.411886052493	(37.7775296345182, -122.411886052493)
15898	15898	95419	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1855X Evans Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	3x3		6014271.438519999	2099507.06769	37.7456489764305	-122.39334186644399	(37.7456489764305, -122.393341866444)
16029	16029	103338	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	560 09th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3x3		6010306.00475	2108638.0249799998	37.770499428132204	-122.407697511346	(37.7704994281322, -122.407697511346)
16214	16214	15280	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1551 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			1	3X3		6007333.49611	2109742.48343	37.7733651619099	-122.418057773243	(37.7733651619099, -122.418057773243)
16267	16267	18305	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	100 Potrero Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6010224.24414	2107746.60355	37.7680472125438	-122.407917452249	(37.7680472125438, -122.407917452249)
16468	16468	18343	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	440 Potrero Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			40	3x3		6010304.42545	2106332.47862	37.7641688367591	-122.407540398864	(37.7641688367591, -122.407540398864)
16504	16504	117214	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 04th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/06/2016 12:00:00 AM	3		Permit Number 778712	6013802.24625	2111251.09103	37.7778694163842	-122.395787025958	(37.7778694163842, -122.395787025958)
16518	16518	18300	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	55 Potrero Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			45	3X3		6010302.289030001	2107927.42815	37.7685480845408	-122.40766025331101	(37.7685480845408, -122.407660253311)
16797	16797	18302	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	66 Potrero Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			40	3x6		6010215.98922	2107911.06317	37.7684983187762	-122.407957604264	(37.7684983187762, -122.407957604264)
16864	16864	15265	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1517 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6007548.55895	2109980.53522	37.7740308976381	-122.417330711836	(37.7740308976381, -122.417330711836)

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