Street_Tree_List

Data source: data.sfgov.org

292 rows where SiteOrder = 5 and qSpecies = 32

Search:

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

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

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

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

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

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

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

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize, PermitNotes

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
315	315	127442	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2101 Van Ness Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			19	Width 4ft		6005941.14617	2117647.79475	37.794992735681504	-122.423436220932	(37.7949927356815, -122.423436220932)
901	901	224716	Property Tree 7	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3255x 24th St	5	Front Yard : Cutout 8	Tree 1	MTA 6			13	Width 3ft		6007298.0	2102020.0	37.7521590216883	-122.417633107694	(37.7521590216883, -122.417633107694)
1435	1435	226556	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	301 Dolores St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			21	Width 6ft		6004916.06592	2106558.9555200003	37.7644876032441	-122.42619331838199	(37.7644876032441, -122.426193318382)
1786	1786	251694	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	98 11th St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3	Permit Number 779453	6007396.0	2110315.0	37.77494067377889	-122.417882154347	(37.7749406737789, -122.417882154347)
2364	2364	192162	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1500 Mission St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			29	Width 5ft	Permit Number 779453	6007414.0762	2109937.75552	37.7739058675964	-122.417792878858	(37.7739058675964, -122.417792878858)
2659	2659	253154	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1454 Jones St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6008456.02855	2117561.49656	37.7948974030383	-122.41472821952499	(37.7948974030383, -122.414728219525)
3241	3241	23530	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2750 Van Ness Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6005733.88187	2119852.14358	37.8010336176693	-122.424310244146	(37.8010336176693, -122.424310244146)
3474	3474	106212	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	585X Bush St	5	Sidewalk: Curb side : Cutout 1	Tree 1	MTA 6			12	3x5		6010752.41967	2115858.63176	37.790350501826204	-122.406662277468	(37.7903505018262, -122.406662277468)
5200	5200	18839	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2055 Sacramento St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6005013.40971	2116109.26217	37.7907159080697	-122.426536721815	(37.7907159080697, -122.426536721815)
5535	5535	98626	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3500X Fillmore St	5	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2		6	6x6		6002283.11168	2120054.94147	37.8013949904512	-122.43626589165301	(37.8013949904512, -122.436265891653)
7883	7883	26843	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	100 Van Ness Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3	Permit Number 775213	6006968.35618	2110982.6622	37.7767498377733	-122.419408844544	(37.7767498377733, -122.419408844544)
7911	7911	42632	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1651 Union St	5	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2	06/26/2000 12:00:00 AM	16	4x4	Permit Number 42688	6005134.3142099995	2118828.07494	37.7981879136105	-122.42631205408199	(37.7981879136105, -122.426312054082)
8849	8849	95551	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1333 Bush St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/27/2016 12:00:00 AM	3		Permit Number 779044	6007189.57448	2115360.3539400003	37.7887823728581	-122.41895414822599	(37.7887823728581, -122.418954148226)
8935	8935	19207	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	630 Sansome St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6012222.627	2118025.44923	37.79638221340979	-122.401727798999	(37.7963822134098, -122.401727798999)
13456	13456	100270	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 Federal St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	1x1		6015164.42669	2113486.59389	37.7840832865491	-122.39123103259399	(37.7840832865491, -122.391231032594)
14046	14046	15032	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	900 Mendell St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6015793.96455	2096498.2238200002	37.7374717791904	-122.387867242574	(37.7374717791904, -122.387867242574)
14088	14088	18359	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	530 Potrero Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			40	3X3		6010330.56094	2105773.09746	37.7626343658127	-122.407410564659	(37.7626343658127, -122.407410564659)
15491	15491	21985	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2585 03rd St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4x9		6015923.77814	2103194.18916	37.7558647037982	-122.38788550510598	(37.7558647037982, -122.387885505106)
15509	15509	6804	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1381 Fairfax Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3x9		6016716.56136	2097329.28644	37.7398047761739	-122.384735237561	(37.7398047761739, -122.384735237561)
16357	16357	117217	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 04th St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/06/2016 12:00:00 AM	3		Permit Number 778712	6013756.29755	2111297.17195	37.77799338791311	-122.395949209701	(37.7779933879131, -122.395949209701)
17431	17431	5364	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	240 Dolores St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			50	3X3		6004803.911280001	2106914.7530400003	37.765458198358495	-122.42660656853701	(37.7654581983585, -122.426606568537)
18054	18054	5536	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	900X Dolores St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			90	6X6		6005028.08743	2102877.14934	37.7543845627197	-122.425543815419	(37.7543845627197, -122.425543815419)
21170	21170	5396	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	347 Dolores St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			23	3x3		6004920.3528	2106347.10243	37.763906147460496	-122.42616340782699	(37.7639061474605, -122.426163407827)
21781	21781	17041	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1200X Oak St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6000936.6602300005	2109686.5385	37.772849440274705	-122.440181257454	(37.7728494402747, -122.440181257454)
22432	22432	9872	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1450X Gough St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	3X3		6005450.688630001	2114725.08205	37.786940005526205	-122.42492523651698	(37.7869400055262, -122.424925236517)
22437	22437	7888	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1187 Franklin St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6005995.08562	2113950.47576	37.7848438629952	-122.42298666871001	(37.7848438629952, -122.42298666871)
22687	22687	9867	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1400X Gough St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	3X3		6005468.52862	2114618.9775	37.7866496764769	-122.42485596263	(37.7866496764769, -122.42485596263)
22708	22708	7868	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1000 Franklin St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	2X2		6006094.882730001	2113627.1755	37.7839617908505	-122.42261842060101	(37.7839617908505, -122.422618420601)
22846	22846	126805	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2500 Chestnut St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5999823.489630001	2119526.80124	37.799804802901605	-122.444739267121	(37.7998048029016, -122.444739267121)
23482	23482	190196	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			9	Width 4ft		6014341.4496	2116607.3297099997	37.79260639992339	-122.394296828661	(37.7926063999234, -122.394296828661)
23607	23607	116400	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	491 31st Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	3x3		5986230.292280001	2112656.5149	37.7801559096657	-122.491270210016	(37.7801559096657, -122.491270210016)
23891	23891	224403	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	298 Clinton Park	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 4ft		6004902.87687	2108216.37777	37.7690377420167	-122.42635695181002	(37.7690377420167, -122.42635695181)
24043	24043	96715	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3301 Buchanan St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	6x9		6003252.88656	2119687.16373	37.800440220701205	-122.432883751884	(37.8004402207012, -122.432883751884)
25379	25379	128693	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	300 Washington St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6012857.60903	2117903.50011	37.7960827841462	-122.3995220462	(37.7960827841462, -122.3995220462)
25602	25602	224374	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	99 Rosemont Pl	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6005143.26148	2107927.6943599996	37.768258671917	-122.425504927819	(37.768258671917, -122.425504927819)
25634	25634	128547	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	530 California St	5	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 4ft		6011621.44747	2116740.1603200003	37.792819551831	-122.40371753735	(37.792819551831, -122.40371753735)
25719	25719	192074	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	121 Vermont St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6011156.08381	2107582.1855900004	37.7676478838626	-122.404682725733	(37.7676478838626, -122.404682725733)
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)
27866	27866	127652	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	301 Grove St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 4ft		6006305.169919999	2111423.23911	37.7779221805011	-122.421734307897	(37.7779221805011, -122.421734307897)
27925	27925	112700	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	100 North Point St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	3x3		6010133.84115	2122006.13363	37.8071954071956	-122.409236517546	(37.8071954071956, -122.409236517546)
27938	27938	128409	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	251 Sutter St	5	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 3ft		6011283.06953	2115589.6115900003	37.789641511384204	-122.40480730793699	(37.7896415113842, -122.404807307937)
28983	28983	128035	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	685 North Point St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 4ft		6007774.31809	2121629.81403	37.806029656510404	-122.417375491781	(37.8060296565104, -122.417375491781)
29758	29758	192148	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	50 08th St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6008592.38406	2111349.07723	37.7778472624731	-122.41381675484199	(37.7778472624731, -122.413816754842)
29897	29897	124710	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3801 Jackson St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 3ft		5996010.5045	2115832.83525	37.7894438500217	-122.45766610015801	(37.7894438500217, -122.457666100158)
31238	31238	126883	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	405 Locust St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5997638.0862	2115015.12343	37.787291992989395	-122.451975858001	(37.7872919929894, -122.451975858001)
31423	31423	127812	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1800 Leavenworth St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 5ft		6007816.61312	2118667.40639	37.797898009944205	-122.417019090476	(37.7978980099442, -122.417019090476)
31677	31677	127985	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	240 Bay St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 4ft		6009667.96414	2121595.80643	37.8060426400222	-122.41081979381799	(37.8060426400222, -122.410819793818)
32256	32256	190121	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	200 Potrero Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			23	Width 4ft		6010255.23585	2107209.9788599997	37.766575498978604	-122.40777241138201	(37.7665754989786, -122.407772411382)
33064	33064	128300	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1445 Sansome St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6011816.634380001	2120597.96825	37.803423063273	-122.403313689569	(37.803423063273, -122.403313689569)
33372	33372	128131	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2600 Jones St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6007862.51017	2121816.20609	37.8065464033523	-122.41708350350001	(37.8065464033523, -122.4170835035)
33486	33486	225542	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	11 Park Hill Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6001178.12685	2107930.11444	37.768040482017206	-122.439220083643	(37.7680404820172, -122.439220083643)
33635	33635	128286	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1701 Montgomery St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 5ft		6011243.233580001	2121267.67473	37.8052298714169	-122.40534516727	(37.8052298714169, -122.40534516727)
33864	33864	190304	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	250 Fremont St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 4ft		6014138.83736	2115262.54738	37.7889026760559	-122.39490365248899	(37.7889026760559, -122.394903652489)
35466	35466	190157	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	70 Steuart St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 4ft		6014319.0284	2117151.13499	37.7940983158456	-122.394412501243	(37.7940983158456, -122.394412501243)
35844	35844	128267	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2 Lombard St	5	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			7	Width 4ft		6011926.44398	2120867.47841	37.8041692046961	-122.402952654037	(37.8041692046961, -122.402952654037)
36016	36016	128014	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	590 Bay St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6008120.87976	2121388.3478599996	37.8053861439291	-122.41615904360901	(37.8053861439291, -122.416159043609)
36671	36671	128522	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	131 Sacramento St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 4ft		6013471.772419999	2117291.0284	37.7944352953952	-122.397353931849	(37.7944352953952, -122.397353931849)
36815	36815	127018	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2859 Filbert St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		5999248.83703	2118357.7805	37.7965621749705	-122.44664361481001	(37.7965621749705, -122.44664361481)
36903	36903	127752	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1033 Jones St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6008599.68492	2116159.4367400003	37.7910557609695	-122.414131906064	(37.7910557609695, -122.414131906064)
36927	36927	115925	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	355 Bryant St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	3x3		6014780.05189	2113392.5655400003	37.7838037673585	-122.39255426179	(37.7838037673585, -122.39255426179)
36986	36986	190145	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1270 Fairfax Ave	5	: 4	Tree 1	Private 1			16	Width 4ft		6017279.69898	2096994.64423	37.7389170445949	-122.38276484453002	(37.7389170445949, -122.38276484453)
37180	37180	128397	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	316 Sutter St	5	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			18	Width 2ft		6010793.77559	2115575.52379	37.7895754687694	-122.406499230364	(37.7895754687694, -122.406499230364)
38476	38476	128530	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	350 California St	5	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 3ft		6012448.833769999	2116858.16011	37.7931897361809	-122.400863019012	(37.7931897361809, -122.400863019012)
38585	38585	192085	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	655 09th St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 4ft		6010705.32809	2108350.52633	37.769732368494296	-122.40629598269301	(37.7697323684943, -122.406295982693)
38914	38914	127033	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3851 Divisadero St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6000081.7878	2121492.06537	37.8052156279642	-122.44398674590299	(37.8052156279642, -122.443986745903)
39465	39465	189705	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	500 Wisconsin St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 9ft		6012637.736959999	2105122.26077	37.7609761769225	-122.39938512804399	(37.7609761769225, -122.399385128044)
40472	40472	226541	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1301 Potrero Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 3ft		6010639.3353	2101703.49528	37.751477423242505	-122.40605590595699	(37.7514774232425, -122.406055905957)
41083	41083	190208	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	121 Main St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6013944.577880001	2116596.04464	37.792553345306395	-122.39566923815701	(37.7925533453064, -122.395669238157)
41905	41905	128325	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	149 Union St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6012183.1231	2119804.50863	37.801264877440204	-122.401989620435	(37.8012648774402, -122.401989620435)
42212	42212	128080	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	109 North Point St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 4ft		6009637.33282	2121886.34956	37.8068386812172	-122.410946332908	(37.8068386812172, -122.410946332908)
42732	42732	128072	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	111 North Point St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 4ft		6009436.58528	2121857.30143	37.806747663529	-122.411639008733	(37.806747663529, -122.411639008733)
42833	42833	225320	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	230 Gough St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 4ft		6006014.77117	2110673.71473	37.7758477880836	-122.422685623354	(37.7758477880836, -122.422685623354)
42894	42894	128552	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	580 California St	5	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			7	Width 4ft		6011490.88451	2116722.25518	37.7927630941901	-122.404168032955	(37.7927630941901, -122.404168032955)
43384	43384	106520	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2510 Jackson St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17			6002025.17401	2116727.45546	37.7922439236606	-122.43692011968001	(37.7922439236606, -122.43692011968)
43513	43513	128669	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	250 Washington St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6013452.64097	2117986.0115	37.7963424894733	-122.397468893095	(37.7963424894733, -122.397468893095)
44117	44117	190226	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	71 Stevenson St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 4ft		6012715.87533	2115521.84575	37.789535423756796	-122.399845153746	(37.7895354237568, -122.399845153746)
45074	45074	249440	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	900 Ellis St	5	: 4	Tree 1	Private 1			15	Width 6ft		6006344.64005	2113562.97552	37.7837996008221	-122.421749788816	(37.7837996008221, -122.421749788816)
45191	45191	189810	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	220 San Bruno Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 4ft		6010832.28252	2107301.43349	37.7668588996454	-122.405782941039	(37.7668588996454, -122.405782941039)
45368	45368	225585	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	522 Waller St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 3ft		6003180.08818	2108951.19631	37.770957839554896	-122.43236845655599	(37.7709578395549, -122.432368456556)
45397	45397	190311	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	235 01st St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 4ft		6013959.192559999	2115030.6848	37.788256044625705	-122.395508952885	(37.7882560446257, -122.395508952885)
45532	45532	128682	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	270 Washington St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6013095.52445	2117935.63267	37.79618427084971	-122.39870106232999	(37.7961842708497, -122.39870106233)
45770	45770	224971	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	163 Jersey St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6004119.60488	2101576.23386	37.750761179792	-122.428592855278	(37.750761179792, -122.428592855278)
45896	45896	128728	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	150 Columbus Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6011247.0652	2118237.2878	37.796909382509206	-122.405118391502	(37.7969093825092, -122.405118391502)
46063	46063	127685	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	901 California St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6009987.94935	2116446.70982	37.7919224214293	-122.40934882221201	(37.7919224214293, -122.409348822212)
46611	46611	128114	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2300 Stockton St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6009769.14231	2122071.6367599997	37.807354823737	-122.410503270223	(37.807354823737, -122.410503270223)
46961	46961	127560	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	181 Ellis St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 4ft		6010074.68482	2114026.3447	37.7852815387496	-122.408877875115	(37.7852815387496, -122.408877875115)
47812	47812	127665	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	330 Gough St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 4ft		6005972.79495	2110984.05651	37.776697543104206	-122.42285289097099	(37.7766975431042, -122.422852890971)
48075	48075	128217	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1073 Front St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6012645.37885	2119606.88563	37.8007480406569	-122.400376113479	(37.8007480406569, -122.400376113479)
48187	48187	128088	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	103 North Point St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6009903.55292	2121923.0557	37.8069543915923	-122.41002761428301	(37.8069543915923, -122.410027614283)
48468	48468	225608	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	299 Laussat St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6003391.64026	2109124.2962	37.7714451228224	-122.431649052862	(37.7714451228224, -122.431649052862)
49028	49028	128256	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	100 Broadway	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 5ft		6012622.23236	2118878.54826	37.7987469105978	-122.40040502308001	(37.7987469105978, -122.40040502308)
49211	49211	218959	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	113 Stillings Ave	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6000075.97071	2095686.0154799998	37.7343583730463	-122.44215328546998	(37.7343583730463, -122.44215328547)
49775	49775	128382	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	127 Trenton St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 3ft		6010062.26131	2118004.30718	37.7962033688491	-122.409201662523	(37.7962033688491, -122.409201662523)
51232	51232	189690	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1555 Mariposa St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6012682.424880001	2106090.19913	37.7636364120244	-122.39929852152201	(37.7636364120244, -122.399298521522)
51772	51772	190261	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	133 Stevenson St	5	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 2ft		6011936.19797	2114760.72734	37.7874020753891	-122.402489228003	(37.7874020753891, -122.402489228003)
52647	52647	127323	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2701 Buchanan St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 5ft		6003533.2764099995	2117688.64743	37.7949687102838	-122.431770718569	(37.7949687102838, -122.431770718569)
52881	52881	225319	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	100 Oak St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 4ft		6006215.028530001	2110426.4498900003	37.7751801547778	-122.421975311837	(37.7751801547778, -122.421975311837)
52947	52947	190099	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	333 Bryant St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6014845.182030001	2113457.74571	37.7839863540405	-122.392333494401	(37.7839863540405, -122.392333494401)
53369	53369	127260	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2629 Pierce St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 4ft		6001624.6889	2117460.2909999997	37.794233329254496	-122.438358328995	(37.7942333292545, -122.438358328995)
53393	53393	225397	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	23 Clover Ln	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 5ft		6000453.09509	2105161.9963	37.7603986314035	-122.441529218925	(37.7603986314035, -122.441529218925)

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