Street_Tree_List

Data source: data.sfgov.org

5,685 rows where qSpecies = 32 sorted by XCoord 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
23208	23208	6749	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1215 Fairfax Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			21	3x3		6017498.178719999	2096747.56806	37.738250691012205	-122.381992253155	(37.7382506910122, -122.381992253155)
23319	23319	6750	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1215 Fairfax Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			21	3x3		6017497.29462	2096749.0937700002	37.7382548314821	-122.381995416066	(37.7382548314821, -122.381995416066)
155209	155209	190144	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1270 Fairfax Ave	2	: 4	Tree 1	Private 1			13	Width 3ft		6017331.65483	2096956.7216900003	37.738815787225796	-122.382582565458	(37.7388157872258, -122.382582565458)
120086	120086	189055	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1270 Fairfax Ave	4	: 4	Tree 1	Private 1			16	Width 4ft		6017298.65982	2096980.57474	37.7388794601286	-122.38269830729601	(37.7388794601286, -122.382698307296)
58003	58003	189678	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 24th St	19	: Yard 23	Tree 1	Private 1			15			6017295.34569	2102596.83049	37.7543003681831	-122.38310055604299	(37.7543003681831, -122.383100556043)
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)
137284	137284	189677	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 24th St	14	: Yard 23	Tree 1	Private 1			9			6017255.58244	2102660.6719	37.754473466102795	-122.38324251223801	(37.7544734661028, -122.383242512238)
174582	174582	189679	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 24th St	20	: Yard 23	Tree 1	Private 1			12			6017238.946959999	2102621.26617	37.7543643468473	-122.383297299846	(37.7543643468473, -122.383297299846)
56535	56535	189056	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1298 Fairfax Ave	2	: 4	Tree 1	Private 1			17	Width 4ft		6017215.97894	2097042.62645	37.739045273523104	-122.38298849961201	(37.7390452735231, -122.382988499612)
163742	163742	189680	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 24th St	21	: Yard 23	Tree 1	Private 1			9			6017213.38014	2102597.10976	37.754296605427704	-122.38338403586701	(37.7542966054277, -122.383384035867)
61562	61562	189676	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 24th St	11	: Yard 23	Tree 1	Private 1			11			6017209.44087	2102637.39107	37.754406991811294	-122.383400462871	(37.7544069918113, -122.383400462871)
71355	71355	190146	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1298 Fairfax Ave	3	: 4	Tree 1	Private 1			18	Width 4ft		6017196.21156	2097055.6209099998	37.739079861441496	-122.38305775101601	(37.7390798614415, -122.383057751016)
28022	28022	189675	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 24th St	10	: Yard 23	Tree 1	Private 1			8			6017194.50129	2102669.93128	37.754495514781496	-122.383454393407	(37.7544955147815, -122.383454393407)
14914	14914	6792	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1375 Fairfax Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3x3		6016736.55231	2097315.7132900003	37.739768612644	-122.384665171383	(37.739768612644, -122.384665171383)
72432	72432	190142	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1385 Fairfax Ave	2	: 4	Tree 1	Private 1			19	Width 4ft		6016719.34934	2097329.5303	37.7398055999553	-122.384725614793	(37.7398055999553, -122.384725614793)
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)
16261	16261	6803	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1381 Fairfax Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3x3		6016702.460969999	2097342.51463	37.7398403182643	-122.384784912507	(37.7398403182643, -122.384784912507)
14817	14817	6802	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1381 Fairfax Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			20	3x3		6016686.26757	2097353.7409	37.739870247704204	-122.384841684893	(37.7398702477042, -122.384841684893)
62875	62875	190141	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1385 Fairfax Ave	1	: 4	Tree 1	Private 1			22	Width 4ft		6016685.94194	2097355.07165	37.7398738836642	-122.384842903479	(37.7398738836642, -122.384842903479)
50857	50857	189057	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1398 Fairfax Ave	1	: 4	Tree 1	Private 1			16	Width 4ft		6016659.73338	2097454.68952	37.7401459645668	-122.384940461042	(37.7401459645668, -122.384940461042)
14941	14941	6814	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1400X Fairfax Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Fire Dept 11			12	3X3		6016451.12132	2097615.70854	37.7405765491786	-122.38567298313801	(37.7405765491786, -122.385672983138)
42662	42662	190140	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1401 Fairfax Ave	1	: 4	Tree 1	Private 1			19	Width 3ft		6016375.816219999	2097583.85317	37.740484913635605	-122.385931141602	(37.7404849136356, -122.385931141602)
15881	15881	6819	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1400X Fairfax Ave	11	Sidewalk: Curb side : Cutout 1	Tree 1	Fire Dept 11			12	3X3		6016343.96785	2097693.33127	37.7407837556653	-122.386048891651	(37.7407837556653, -122.386048891651)
130152	130152	189050	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1498 Fairfax Ave	7	: 4	Tree 1	Private 1			18	Width 4ft		6016154.01606	2097829.997	37.7411484972995	-122.386715207445	(37.7411484972995, -122.386715207445)
180090	180090	189051	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1498 Fairfax Ave	8	: 4	Tree 1	Private 1			16	Width 4ft		6016137.18374	2097841.52701	37.7411792244368	-122.38677421196199	(37.7411792244368, -122.386774211962)
155682	155682	189052	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1498 Fairfax Ave	9	: 4	Tree 1	Private 1			19	Width 4ft		6016122.19881	2097851.77649	37.741206537755296	-122.38682673957199	(37.7412065377553, -122.386826739572)
49276	49276	189053	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1498 Fairfax Ave	10	: 4	Tree 1	Private 1			17	Width 4ft		6016104.71748	2097862.0759900003	37.74123385017221	-122.38688790245199	(37.7412338501722, -122.386887902452)
175412	175412	189054	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1498 Fairfax Ave	11	: 4	Tree 1	Private 1			17	Width 4ft		6016089.14176	2097873.9953400004	37.7412657158495	-122.38694258933701	(37.7412657158495, -122.386942589337)
171722	171722	190349	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	446 Spear St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 4ft		6016076.82056	2114790.30571	37.7877135762729	-122.38816546497299	(37.7877135762729, -122.388165464973)
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)
35490	35490	192167	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	818 Mendell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			29	Width 3ft		6016012.76751	2096784.5302	37.738270037232205	-122.387130695121	(37.7382700372322, -122.387130695121)
1062	1062	189665	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2585 03rd St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			19	Width 5ft		6015925.0907	2103156.8300799998	37.755762196378996	-122.387878359099	(37.755762196379, -122.387878359099)
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)
1044	1044	189667	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2585 03rd St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			17	Width 5ft		6015923.778390001	2103213.67674	37.7559182125844	-122.38788686398199	(37.7559182125844, -122.387886863982)
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)
1035	1035	189666	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2585 03rd St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			20	Width 5ft		6015923.45326	2103178.08659	37.7558204715491	-122.38788550510598	(37.7558204715491, -122.387885505106)
14911	14911	21988	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2585 03rd St	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4x6		6015920.52958	2103275.9123	37.756088918284604	-122.38790244203899	(37.7560889182846, -122.387902442039)
1037	1037	189668	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2585 03rd St	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			19	Width 5ft		6015920.2977599995	2103253.32542	37.7560268866495	-122.387901667748	(37.7560268866495, -122.387901667748)
14917	14917	21989	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2585 03rd St	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4x6		6015918.99863	2103291.42641	37.7561314319344	-122.38790881913401	(37.7561314319344, -122.387908819134)
16745	16745	21990	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2585 03rd St	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4x9		6015917.77015	2103307.70313	37.7561760563058	-122.387914203395	(37.7561760563058, -122.387914203395)
1055	1055	21993	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2585 03rd St	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4x6		6015910.4355	2103353.3332599998	37.756300940646604	-122.387942753271	(37.7563009406466, -122.387942753271)
31624	31624	189661	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2585 03rd St	16	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 5ft		6015908.09217	2103411.17152	37.756459622437795	-122.38795489320499	(37.7564596224378, -122.387954893205)
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)
1046	1046	189659	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2573 03rd St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	Width 4ft		6015895.51865	2103530.26934	37.7567859432258	-122.388006687875	(37.7567859432258, -122.388006687875)
61242	61242	189657	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2505 03rd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 5ft		6015867.180380001	2103823.80533	37.7575903607135	-122.388125177147	(37.7575903607135, -122.388125177147)
161826	161826	189658	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2505 03rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 5ft		6015864.609540001	2103849.31595	37.7576602650169	-122.388135848506	(37.7576602650169, -122.388135848506)
23125	23125	15028	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	900 Mendell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			5	3X3		6015848.122169999	2096570.1490599997	37.737672271366	-122.387685009354	(37.737672271366, -122.387685009354)
134141	134141	189669	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2475 03rd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 5ft		6015848.0451	2104085.46802	37.7583077705949	-122.38820961627898	(37.7583077705949, -122.388209616279)
148982	148982	189670	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2455 03rd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 5ft		6015847.32517	2104116.64553	37.75839333751029	-122.38821428198601	(37.7583933375103, -122.388214281986)
41908	41908	189672	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2427 03rd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 4ft		6015841.43821	2104253.31303	37.7587682711682	-122.388244179947	(37.7587682711682, -122.388244179947)
175939	175939	189671	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2445 03rd St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 4ft		6015841.1097	2104206.72552	37.7586403335901	-122.388242064727	(37.7586403335901, -122.388242064727)
174726	174726	189673	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2353 03rd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 4ft		6015829.00973	2104455.77471	37.7593234991101	-122.388301294093	(37.7593234991101, -122.388301294093)
13448	13448	59987	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1546 Innes Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/11/1982 12:00:00 AM	20		Permit Number 19471	6015827.92235	2097026.6864599998	37.738924711310794	-122.387786695709	(37.7389247113108, -122.387786695709)
34054	34054	189674	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2347 03rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6015825.57929	2104513.0961599997	37.7594807014943	-122.388317159013	(37.7594807014943, -122.388317159013)
13666	13666	15030	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	900 Mendell St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6015814.843090001	2096523.3244599998	37.737541857055604	-122.387796805884	(37.7375418570556, -122.387796805884)
16456	16456	15031	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	900 Mendell St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6015804.02925	2096508.49114	37.7375005287238	-122.38783316007	(37.7375005287238, -122.38783316007)
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)
129554	129554	59986	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1552 Innes Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/11/1982 12:00:00 AM	19	3x3	Permit Number 19470	6015757.2015	2097078.5324799998	37.7390631520541	-122.388034834851	(37.7390631520541, -122.388034834851)
33257	33257	59984	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1562 Innes Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/11/1982 12:00:00 AM	20		Permit Number 19468	6015739.3496	2097091.61317	37.7390980799033	-122.38809747171899	(37.7390980799033, -122.388097471719)
159595	159595	60020	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1575 Innes Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/22/1982 12:00:00 AM	15		Permit Number 19507	6015654.8886400005	2097084.06623	37.739072677666705	-122.38838897527799	(37.7390726776667, -122.388388975278)
53207	53207	192168	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1516 Kirkwood Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			29	Width 4ft		6015644.07634	2096462.96533	37.737366661932995	-122.38838302088301	(37.737366661933, -122.388383020883)
16439	16439	54186	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1536 Kirkwood Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/19/1972 12:00:00 AM	20	3x3	Permit Number 9921	6015571.57326	2096517.43556	37.7375122082315	-122.388637501128	(37.7375122082315, -122.388637501128)
16663	16663	100274	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 Federal St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	1x1		6015236.2818	2113554.4161799997	37.7842734985691	-122.390987179627	(37.7842734985691, -122.390987179627)
14115	14115	100254	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2X Federal St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	2x2		6015227.31131	2113576.31726	37.7843331361945	-122.39101974588499	(37.7843331361945, -122.391019745885)
13875	13875	100273	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 Federal St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	1x1		6015216.1617	2113535.8467	37.7842213945326	-122.391055490318	(37.7842213945326, -122.391055490318)
15776	15776	100272	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 Federal St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	1x1		6015193.569569999	2113513.1652900004	37.7841578628497	-122.391132065814	(37.7841578628497, -122.391132065814)
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)
179920	179920	190288	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	190 Steuart St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6015182.77044	2116248.02621	37.7916665652214	-122.391360675282	(37.7916665652214, -122.391360675282)
13549	13549	100271	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 Federal St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	1x1		6015178.9141	2113499.10422	37.7841184410568	-122.391181785729	(37.7841184410568, -122.391181785729)
14152	14152	100257	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2X Federal St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	2x2		6015171.2792	2113522.46957	37.784182173302	-122.391209833759	(37.784182173302, -122.391209833759)
38540	38540	190287	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	190 Steuart St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6015169.048880001	2116262.66084	37.791705986981896	-122.391409175691	(37.7917059869819, -122.391409175691)
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)
119497	119497	190286	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	190 Steuart St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6015153.32574	2116277.33628	37.791745409684	-122.391464604522	(37.791745409684, -122.391464604522)
146500	146500	190350	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	4 Federal St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 2ft		6015151.51293	2113506.51683	37.7841372737458	-122.391277103055	(37.7841372737458, -122.391277103055)
16467	16467	100269	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 Federal St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	1x1		6015149.19988	2113471.58342	37.78404122616921	-122.391282662663	(37.7840412261692, -122.391282662663)
75146	75146	190285	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	190 Steuart St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6015142.16619	2116289.92514	37.7917793563916	-122.39150409733	(37.7917793563916, -122.39150409733)
14907	14907	100268	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 Federal St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	1x1		6015133.4862	2113455.2111	37.7839953994148	-122.391335881848	(37.7839953994148, -122.391335881848)
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)
74859	74859	39875	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	301 Bryant St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/21/1999 12:00:00 AM	14		Permit Number 41173	6015122.448890001	2113715.2291	37.7847087371596	-122.391392250474	(37.7847087371596, -122.391392250474)
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)
24934	24934	190351	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	6 Federal St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			25	Width 2ft		6015118.929169999	2113473.3383400002	37.7840443647849	-122.39138751192199	(37.7840443647849, -122.391387511922)
135858	135858	39874	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	301 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/21/1999 12:00:00 AM	11		Permit Number 41173	6015106.35848	2113700.77588	37.784668158863795	-122.391446907649	(37.7846681588638, -122.391446907649)
33173	33173	41425	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1568 Indiana St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/12/2005 12:00:00 AM	14		Permit Number 42032	6015102.0577	2101304.61846	37.750630787079395	-122.390595272152	(37.7506307870794, -122.390595272152)
14073	14073	100266	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 Federal St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/03/2017 12:00:00 AM	3	1x1	Permit Number 779105	6015095.83494	2113421.2206	37.783899979542106	-122.391463765467	(37.7838999795421, -122.391463765467)
136499	136499	46261	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1325 Indiana St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/30/2002 12:00:00 AM	13		Permit Number 44545	6015094.37152	2102457.09283	37.7537948115904	-122.390702379615	(37.7537948115904, -122.390702379615)
57418	57418	190352	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	8 Federal St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	Width 2ft		6015093.65836	2113449.8432	37.783978449892004	-122.391473297374	(37.783978449892, -122.391473297374)
66410	66410	46262	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1325 Indiana St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/30/2002 12:00:00 AM	11		Permit Number 44545	6015093.12445	2102475.079	37.753844128607504	-122.39070794912399	(37.7538441286075, -122.390707949124)
182003	182003	190347	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	75 Howard St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6015078.15625	2116306.2272200002	37.7918205651212	-122.391726713716	(37.7918205651212, -122.391726713716)
179677	179677	189662	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1177 Indiana St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			13	Width 4ft		6015057.63998	2103157.3463	37.7557155206704	-122.390878342778	(37.7557155206704, -122.390878342778)
171505	171505	189663	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1177 Indiana St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			11	Width 4ft		6015055.47575	2103171.59722	37.7557545305733	-122.39088682336799	(37.7557545305733, -122.390886823368)
156906	156906	190346	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	75 Howard St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6015051.30484	2116280.7543599997	37.7917491319689	-122.391817838416	(37.7917491319689, -122.391817838416)
42122	42122	190345	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	75 Howard St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6015041.594380001	2116270.26796	37.791719799677104	-122.39185070326799	(37.7917197996771, -122.391850703268)
57374	57374	190344	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	75 Howard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6015032.67079	2116261.93292	37.791696418196004	-122.391880996008	(37.791696418196, -122.391880996008)
16201	16201	100258	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	20X Federal St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	3x3		6015031.621809999	2113390.73913	37.7838127201334	-122.39168378907401	(37.7838127201334, -122.391683789074)
57006	57006	190353	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	20 Federal St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6015020.15445	2113379.99675	37.7837825874477	-122.39172271082899	(37.7837825874477, -122.391722710829)
171073	171073	66475	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	75 Howard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/16/1991 12:00:00 AM	12	3x3	Permit Number 29630	6015018.79305	2116250.2508	37.791663571364396	-122.391928196037	(37.7916635713644, -122.391928196037)
162830	162830	190297	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	225 Main St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6015009.1682	2115480.58395	37.7895497094874	-122.39190765463002	(37.7895497094874, -122.39190765463)
118765	118765	105165	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1600X OAKDALE AVE	4	Sidewalk: Curb side : Cutout 1	Tree 1	Arts Commission 19			16	3x3		6015006.0	2095503.0	37.734695414582795	-122.390522107646	(37.7346954145828, -122.390522107646)
161244	161244	190354	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	20 Federal St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6015003.991	2113364.09082	37.783738016125895	-122.391777518225	(37.7837380161259, -122.391777518225)
40701	40701	190298	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	225 Main St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 5ft		6014996.8762300005	2115494.03882	37.7895859710557	-122.391951125143	(37.7895859710557, -122.391951125143)

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