Street_Tree_List

Data source: data.sfgov.org

5,685 rows where qSpecies = 32 sorted by TreeID 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: qSiteInfo, qCaretaker, qCareAssistant

Link	rowid	TreeID ▲	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
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)
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)
1777	1777	251693	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	98 11th St	4	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)
1783	1783	251690	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	98 11th St	1	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)
1568	1568	251592	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1999X Hyde St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2	Private 3			3x3		6007220.0	2119146.0	37.799178528828	-122.41911751038602	(37.799178528828, -122.419117510386)
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)
599	599	251330	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2232 Webster St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6003295.0	2116396.0	37.791405922266996	-122.43250281523301	(37.791405922267, -122.432502815233)
49950	49950	249562	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1398 Post St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6005512.90813	2114488.9963	37.7862952869479	-122.424693170059	(37.7862952869479, -122.424693170059)
28397	28397	249531	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	246 Myrtle St	1	: 4	Tree 1	Private 1			7	Width 3ft		6006201.54989	2114050.0866900003	37.7851290182315	-122.42227944813601	(37.7851290182315, -122.422279448136)
25118	25118	249530	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	236 Myrtle St	1	: 4	Tree 1	Private 1			6	Width 3ft		6006266.61639	2114058.0965400003	37.7851546812964	-122.422054907229	(37.7851546812964, -122.422054907229)
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)
61734	61734	249439	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	900 Ellis St	4	: 4	Tree 1	Private 1			15	Width 6ft		6006372.16148	2113566.88832	37.7838118963457	-122.421654852808	(37.7838118963457, -122.421654852808)
67778	67778	249437	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	900 Ellis St	2	: 4	Tree 1	Private 1			16	Width 6ft		6006423.6127	2113573.86871	37.783833963915704	-122.421477346411	(37.7838339639157, -122.421477346411)
137375	137375	249414	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	640 Turk St	3	: 4	Tree 1	Private 1			14	Width 4ft		6006875.43405	2112939.59497	37.782117867684704	-122.419869186806	(37.7821178676847, -122.419869186806)
38479	38479	249413	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	640 Turk St	2	: 4	Tree 1	Private 1			14	Width 4ft		6006896.39396	2112943.4670599997	37.7821296802828	-122.41979694968799	(37.7821296802828, -122.419796949688)
148981	148981	249412	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	640 Turk St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6006934.45085	2112950.09504	37.782150022933	-122.419665760187	(37.782150022933, -122.419665760187)
63589	63589	249393	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	320 Turk St	1	: 4	Tree 1	Private 1			16	Width 3ft		6008405.64882	2113154.88185	37.7827950814738	-122.414590558504	(37.7827950814738, -122.414590558504)
186577	186577	249392	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	318 Turk St	1	: 4	Tree 1	Private 1			17	Width 3ft		6008424.06306	2113156.66711	37.7828010178889	-122.414526979149	(37.7828010178889, -122.414526979149)
31382	31382	249379	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	774 Geary St	1	: 4	Tree 1	Private 1			15	Width 4ft		6008031.48613	2114489.63478	37.786438961746505	-122.415979559602	(37.7864389617465, -122.415979559602)
47706	47706	249378	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	764 Geary St	2	: 4	Tree 1	Private 1			16	Width 4ft		6008051.64406	2114491.85735	37.7864461976841	-122.41590997546999	(37.7864461976841, -122.41590997547)
161285	161285	249377	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	764 Geary St	1	: 4	Tree 1	Private 1			17	Width 4ft		6008079.22511	2114494.71861	37.7864556045784	-122.415814754355	(37.7864556045784, -122.415814754355)
158530	158530	249376	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	758 Geary St	1	: 4	Tree 1	Private 1			15	Width 4ft		6008105.262	2114499.7195099997	37.78647079952329	-122.415725027196	(37.7864707995233, -122.415725027196)
66899	66899	249375	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	746 Geary St	2	: 4	Tree 1	Private 1			16	Width 3ft		6008127.05575	2114504.28031	37.786484547475794	-122.41564994908	(37.7864845474758, -122.41564994908)
73606	73606	249374	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	746 Geary St	1	: 4	Tree 1	Private 1			18	Width 3ft		6008149.07625	2114506.99215	37.7864932313311	-122.415573955478	(37.7864932313311, -122.415573955478)
188437	188437	249364	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	650 Leavenworth St	1	: 4	Tree 1	Private 1			15	Width 3ft		6008364.20652	2114704.18195	37.7870467568593	-122.41484361694201	(37.7870467568593, -122.414843616942)
179801	179801	249363	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	610 Leavenworth St	2	: 4	Tree 1	Private 1			16	Width 3ft		6008381.36401	2114616.8221	37.7868078519475	-122.414778070746	(37.7868078519475, -122.414778070746)
59412	59412	249362	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	610 Leavenworth St	1	: 4	Tree 1	Private 1			17	Width 3ft		6008385.00133	2114591.25294	37.7867378496037	-122.41476367620001	(37.7867378496037, -122.4147636762)
158094	158094	249360	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 Leavenworth St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6008338.71076	2114562.35621	37.7866559051821	-122.41492178511001	(37.7866559051821, -122.41492178511)
182919	182919	249359	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 Leavenworth St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6008334.89193	2114587.28483	37.7867241385409	-122.41493676241998	(37.7867241385409, -122.41493676242)
162185	162185	249358	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	615 Leavenworth St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6008328.7047	2114614.93819	37.786799720286496	-122.41496012681601	(37.7867997202865, -122.414960126816)
70313	70313	249357	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	615 Leavenworth St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6008326.67703	2114634.61716	37.7868536400235	-122.414968535469	(37.7868536400235, -122.414968535469)
62531	62531	249355	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	625 Leavenworth St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6008323.0201	2114666.64303	37.7869413697974	-122.414983455249	(37.7869413697974, -122.414983455249)
165204	165204	249353	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	645 Leavenworth St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 3ft		6008320.499419999	2114705.2378700003	37.787047200214296	-122.41499490900401	(37.7870472002143, -122.414994909004)
169308	169308	249352	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	645 Leavenworth St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6008319.11721	2114724.79129	37.7871008114872	-122.41500107566401	(37.7871008114872, -122.415001075664)
25434	25434	249351	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	645 Leavenworth St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6008312.55041	2114752.31158	37.787176006507394	-122.415025744055	(37.7871760065074, -122.415025744055)
49293	49293	249350	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	645 Leavenworth St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6008310.57123	2114769.46889	37.7872230050951	-122.415033806481	(37.7872230050951, -122.415033806481)
33509	33509	249349	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	645 Leavenworth St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6008308.39616	2114784.90378	37.787265263326894	-122.415042424695	(37.7872652633269, -122.415042424695)
25496	25496	249348	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	645 Leavenworth St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6008306.02819	2114799.4985700003	37.787305204007204	-122.41505165082701	(37.7873052040072, -122.415051650827)
32248	32248	249347	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	825 Post St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6008271.46114	2114824.52265	37.7873719714978	-122.415173017931	(37.7873719714978, -122.415173017931)
147753	147753	249346	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	825 Post St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6008254.23565	2114821.79772	37.7873635214419	-122.41523242176399	(37.7873635214419, -122.415232421764)
59612	59612	249345	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	825 Post St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6008236.3272	2114819.25777	37.7873555408825	-122.41529420158999	(37.7873555408825, -122.41529420159)
73999	73999	249344	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	825 Post St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6008218.06152	2114816.04092	37.787345681610205	-122.41535716941002	(37.7873456816102, -122.41535716941)
154879	154879	249343	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	825 Post St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6008198.25467	2114813.0269299997	37.7873362926859	-122.415425483722	(37.7873362926859, -122.415425483722)
184963	184963	249342	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	825 Post St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6008177.754369999	2114809.68521	37.787325964877795	-122.415496174003	(37.7873259648778, -122.415496174003)
29258	29258	249341	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	825 Post St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6008157.0718	2114805.83399	37.7873142278188	-122.415567458796	(37.7873142278188, -122.415567458796)
177630	177630	249339	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	829 Post St	1	: 4	Tree 1	Private 1			13	Width 3ft		6008120.77004	2114802.70738	37.7873036023197	-122.41569283415501	(37.7873036023197, -122.415692834155)
45966	45966	249338	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	851 Post St	4	: 4	Tree 1	Private 1			11	Width 3ft		6008100.791680001	2114799.69697	37.7872942133891	-122.415761742029	(37.7872942133891, -122.415761742029)
134359	134359	249337	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	851 Post St	3	: 4	Tree 1	Private 1			12	Width 3ft		6008084.284109999	2114798.49621	37.787289988396	-122.41581876984199	(37.787289988396, -122.415818769842)
137804	137804	249336	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	851 Post St	2	: 4	Tree 1	Private 1			11	Width 3ft		6008067.240569999	2114796.28027	37.787282945806396	-122.415877580082	(37.7872829458064, -122.415877580082)
151884	151884	249335	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	851 Post St	1	: 4	Tree 1	Private 1			13	Width 3ft		6008046.429819999	2114794.0792400003	37.7872757323303	-122.415949425153	(37.7872757323303, -122.415949425153)
41837	41837	249334	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	875 Post St	1	: 4	Tree 1	Private 1			10	Width 3ft		6007974.7465699995	2114781.52678	37.7872372359533	-122.416196545342	(37.7872372359533, -122.416196545342)
186291	186291	249333	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	840 Post St	4	: 4	Tree 1	Private 1			15	Width 4ft		6008047.50765	2114838.3401	37.7873973224712	-122.415948831592	(37.7873973224712, -122.415948831592)
38903	38903	249332	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	840 Post St	3	: 4	Tree 1	Private 1			16	Width 4ft		6008070.22885	2114841.12367	37.7874062428634	-122.41587041788799	(37.7874062428634, -122.415870417888)
179161	179161	249331	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	840 Post St	2	: 4	Tree 1	Private 1			15	Width 4ft		6008088.32978	2114844.6854	37.7874170401044	-122.41580804451799	(37.7874170401044, -122.415808044518)
155319	155319	249330	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	840 Post St	1	: 4	Tree 1	Private 1			13	Width 4ft		6008126.924269999	2114851.2473400002	37.7874372271876	-122.41567497991501	(37.7874372271876, -122.415674979915)
173370	173370	248278	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	133 Lundy's Ln	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6006775.60494	2098799.3248	37.7432863674857	-122.41921119514299	(37.7432863674857, -122.419211195143)
74684	74684	248277	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	133 Lundy's Ln	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6006764.276959999	2098780.3138099997	37.7432335296045	-122.419249016145	(37.7432335296045, -122.419249016145)
162134	162134	248157	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	225 Rutledge St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 2ft		6010099.29576	2099517.7004	37.745445491324894	-122.40776932670401	(37.7454454913249, -122.407769326704)
129476	129476	248130	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	150 Rutledge St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			22	Width 5ft		6010302.22198	2099510.3901	37.7454367768839	-122.407067121658	(37.7454367768839, -122.407067121658)
174543	174543	248129	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	138 Rutledge St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			21	Width 5ft		6010351.09027	2099495.3382900003	37.7453981824921	-122.40689708144899	(37.7453981824921, -122.406897081449)
55537	55537	248128	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	138 Rutledge St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 5ft		6010367.41991	2099492.2850599997	37.7453907127161	-122.406840400774	(37.7453907127161, -122.406840400774)
65649	65649	248103	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	63 Brewster St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6010415.25784	2099499.43001	37.7454130078172	-122.40667548758499	(37.7454130078172, -122.406675487585)
183048	183048	247220	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	898 Duboce Ave	4	: 4	Tree 1	Private 1			17	Width 3ft		6001660.99493	2108696.8913	37.7701733267561	-122.437604817625	(37.7701733267561, -122.437604817625)
56194	56194	247219	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	898 Duboce Ave	3	: 4	Tree 1	Private 1			17	Width 3ft		6001696.7328699995	2108310.3892	37.769114119654205	-122.437453519276	(37.7691141196542, -122.437453519276)
176160	176160	247218	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	898 Duboce Ave	2	: 4	Tree 1	Private 1			17	Width 3ft		6001717.2937	2108310.88188	37.769116641340794	-122.43738243597001	(37.7691166413408, -122.43738243597)
45576	45576	247217	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	898 Duboce Ave	1	: 4	Tree 1	Private 1			18	Width 3ft		6001734.68886	2108311.17777	37.769118442685	-122.437322288417	(37.769118442685, -122.437322288417)
174442	174442	247040	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	582 Valley St	1	: 4	Tree 1	Private 1			14	Width 3ft		6002230.349909999	2099188.47495	37.7440978581249	-122.434955309639	(37.7440978581249, -122.434955309639)
159986	159986	247038	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	550x Valley St	16	Median : Yard 3	Tree 1	DPW 2			11			6002247.5223900005	2099161.75856	37.7440254762006	-122.434894020862	(37.7440254762006, -122.434894020862)
174903	174903	247035	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	550x Valley St	13	Median : Yard 3	Tree 1	DPW 2			13			6002263.72164	2099154.77603	37.7440072235471	-122.434837508343	(37.7440072235471, -122.434837508343)
31162	31162	247033	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	550x Valley St	11	Median : Yard 3	Tree 1	DPW 2			8			6002285.13208	2099166.02387	37.7440393230544	-122.434764280156	(37.7440393230544, -122.434764280156)
151068	151068	246982	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	38 Clipper St	1	: 4	Tree 1	Private 1			18	Width 8ft		6004902.47134	2101076.4890799997	37.74943326963471	-122.425850064247	(37.7494332696347, -122.425850064247)
152358	152358	246961	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2179 15th St	1	: 4	Tree 1	Private 1			15	Width 3ft		6003024.34646	2107086.69679	37.765829547320706	-122.43277395635	(37.7658295473207, -122.43277395635)
29840	29840	246959	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2173 15th St	1	: 4	Tree 1	Private 1			22	Width 4ft		6003061.26496	2107089.31896	37.7658388409276	-122.43264645046699	(37.7658388409276, -122.432646450467)
71776	71776	246957	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2157 15th St	2	: 4	Tree 1	Private 1			11	Width 3ft		6003142.68624	2107094.6668700003	37.7658581421603	-122.432365213587	(37.7658581421603, -122.432365213587)
63153	63153	246956	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2157 15th St	1	: 4	Tree 1	Private 1			9	Width 3ft		6003133.80616	2107095.11064	37.7658588571132	-122.432395959599	(37.7658588571132, -122.432395959599)
34764	34764	246821	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	198 Brewster St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10			6010041.69314	2098721.17607	37.7432551843714	-122.407912349468	(37.7432551843714, -122.407912349468)
165866	165866	246818	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	190 Brewster St	1	: 4	Tree 1	Private 1			6	Width 2ft		6010161.52665	2098811.57583	37.7435101107114	-122.407504366642	(37.7435101107114, -122.407504366642)
55612	55612	246817	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	188 Brewster St	1	: 4	Tree 1	Private 1			7	Width 2ft		6010169.08234	2098827.13597	37.7435532583908	-122.40747933761601	(37.7435532583908, -122.407479337616)
166371	166371	246687	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	65 Randall St	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 9ft		6004944.1218	2097602.36636	37.7398964773322	-122.42545882766301	(37.7398964773322, -122.425458827663)
27960	27960	246686	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	65 Randall St	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 4ft		6004961.87116	2097597.9446799997	37.7398853392354	-122.425397143159	(37.7398853392354, -122.425397143159)
167734	167734	246685	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	65 Randall St	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 4ft		6004978.8033300005	2097597.3431	37.7398846440669	-122.425338555951	(37.7398846440669, -122.425338555951)
188592	188592	246684	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	65 Randall St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 4ft		6004997.42528	2097597.83608	37.73988704974779	-122.425274204056	(37.7398870497478, -122.425274204056)
127240	127240	246683	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	65 Randall St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 4ft		6005013.28889	2097598.95016	37.7398910049652	-122.425219433535	(37.7398910049652, -122.425219433535)
60834	60834	246682	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	65 Randall St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 4ft		6005028.19634	2097600.03774	37.7398948333787	-122.42516796712799	(37.7398948333787, -122.425167967128)
152152	152152	246681	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	65 Randall St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 4ft		6005137.38612	2097606.83226	37.7399196573536	-122.42479091738701	(37.7399196573536, -122.424790917387)
147841	147841	246680	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	65 Randall St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 4ft		6005184.39895	2097607.58215	37.7399243716053	-122.42462841978201	(37.7399243716053, -122.424628419782)
184951	184951	246679	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	65 Randall St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 4ft		6005202.46496	2097607.42576	37.739924962478796	-122.42456594386101	(37.7399249624788, -122.424565943861)
152345	152345	246678	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	65 Randall St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			19	Width 4ft		6005222.8012	2097609.38503	37.7399314906489	-122.424495768869	(37.7399314906489, -122.424495768869)
186943	186943	246677	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	25 Randall St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14			6005248.94304	2097610.63078	37.7399363874552	-122.424405469757	(37.7399363874552, -122.424405469757)
153949	153949	246676	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	25 Randall St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15			6005260.167640001	2097612.18333	37.739941284250996	-122.42436677011601	(37.739941284251, -122.424366770116)
76606	76606	246675	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	950 San Jose Ave	5	Front Yard : Yard 7	Tree 1	Private 1			19	Width 8ft		6005283.663509999	2097689.92499	37.7401560720365	-122.424291058881	(37.7401560720365, -122.424291058881)
48262	48262	246674	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	950 San Jose Ave	4	Front Yard : Yard 7	Tree 1	Private 1			16	Width 8ft		6005286.18809	2097704.16876	37.740195324763704	-122.424283342697	(37.7401953247637, -122.424283342697)
132636	132636	246673	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	950 San Jose Ave	3	Front Yard : Yard 7	Tree 1	Private 1			15	Width 8ft		6005263.852999999	2097708.23975	37.740205241579396	-122.424360857976	(37.7402052415794, -122.424360857976)
37960	37960	246672	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	950 San Jose Ave	2	Front Yard : Yard 7	Tree 1	Private 1			5	Width 8ft		6005247.4068	2097710.7023400003	37.7402110745895	-122.42441789747299	(37.7402110745895, -122.424417897473)
156072	156072	246459	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	401 Duncan St	2	: 4	Tree 1	Private 1			11	Width 3ft		6003883.97814	2099806.25098	37.7458878813339	-122.42928147427601	(37.7458878813339, -122.429281474276)
40490	40490	246458	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	401 Duncan St	1	: 4	Tree 1	Private 1			11	Width 3ft		6003866.26481	2099806.76686	37.7458882950042	-122.429342761286	(37.7458882950042, -122.429342761286)
61786	61786	226575	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	301 Fair Oaks St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6005481.2837	2101831.85502	37.7515400232668	-122.42390221991998	(37.7515400232668, -122.42390221992)
28980	28980	226574	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	375 Fair Oaks St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 6ft		6005499.0576	2101536.54316	37.7507301684604	-122.42381975928801	(37.7507301684604, -122.423819759288)
39558	39558	226573	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3705 25th St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6005744.88516	2101373.53681	37.7502964650211	-122.422958081044	(37.7502964650211, -122.422958081044)
157769	157769	226572	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 Tiffany Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 8ft		6006471.88526	2099931.8525799997	37.7463789237643	-122.4203417473	(37.7463789237643, -122.4203417473)

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