Street_Tree_List

Data source: data.sfgov.org

300 rows where SiteOrder = 2 and qSpecies = 59 sorted by Location

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, PlantDate, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location ▼
65375	65375	200196	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1124 Fitzgerald Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 0ft		6015063.1024	2090263.455	37.720311838731	-122.38995879887301	(37.720311838731, -122.389958798873)
177466	177466	32291	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1400 Egbert Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/15/1996 12:00:00 AM	7		Permit Number 36872	6014236.59	2091225.7906	37.722908348540294	-122.39288309530001	(37.7229083485403, -122.3928830953)
18821	18821	25266	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1738 Ocean Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			13	3X3		5994668.335	2092363.0322	37.7249246023662	-122.460608386003	(37.7249246023662, -122.460608386003)
162336	162336	217617	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1830 Ocean Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		5994396.9504	2092455.3654	37.7251625099423	-122.46155321589701	(37.7251625099423, -122.461553215897)
36681	36681	199730	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1500 Armstrong Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6014897.5638	2092133.7733	37.725438180339	-122.390661646389	(37.725438180339, -122.390661646389)
73307	73307	199853	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2503 Keith St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6014209.1818	2092155.2364	37.7254588983374	-122.39304284056499	(37.7254588983374, -122.393042840565)
173135	173135	199722	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2300 Jennings St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6015093.5789	2092222.3792	37.72569234746	-122.38999022091998	(37.72569234746, -122.38999022092)
65445	65445	199741	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2396 Keith St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6014513.885	2092478.0086	37.7263620876399	-122.392012061617	(37.7263620876399, -122.392012061617)
61042	61042	38609	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1570 Revere Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/15/2002 12:00:00 AM	6		Permit Number 45423	6015273.2073	2094293.4811	37.7313891398709	-122.38951383063	(37.7313891398709, -122.38951383063)
13740	13740	97243	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1300X Keith St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3x3		6016226.9194	2094855.7145	37.7329857540551	-122.38625582218701	(37.7329857540551, -122.386255822187)
4557	4557	245383	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	3720 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			14	Width 0ft		6005268.7499	2096538.92	37.7369948294896	-122.42426078327499	(37.7369948294896, -122.424260783275)
154252	154252	245378	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	3550 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6005581.5521	2097815.7311	37.7405183234498	-122.42327002037099	(37.7405183234498, -122.423270020371)
44905	44905	182129	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2650 Ulloa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		5987716.6576	2098310.3756	37.740852067466506	-122.485075392772	(37.7408520674665, -122.485075392772)
41163	41163	181854	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2318 32nd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 0ft		5986419.9945	2099457.4563	37.7439260290789	-122.48964304245001	(37.7439260290789, -122.48964304245)
148571	148571	183823	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2235 27th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		5987905.9224	2100064.0482	37.7456782117444	-122.48454959408501	(37.7456782117444, -122.484549594085)
116559	116559	113410	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	401x DUNCAN ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6003916.0	2099815.0	37.745913716911	-122.429171370863	(37.745913716911, -122.429171370863)
92442	92442	37059	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1450 Sanchez St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/01/1998 12:00:00 AM		3x3	Permit Number 39663	6003906.83973736	2099821.31146391	37.745930528166596	-122.429203495744	(37.7459305281666, -122.429203495744)
19398	19398	547	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2889 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6009603.6887	2102171.1765	37.7527035922626	-122.409670319384	(37.7527035922626, -122.409670319384)
168438	168438	245420	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2855 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		6009712.0846	2102179.2059	37.7527317128259	-122.409296032004	(37.7527317128259, -122.409296032004)
19043	19043	533	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2850 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6009680.0053	2102218.3979	37.7528375279845	-122.409409734124	(37.7528375279845, -122.409409734124)
21990	21990	528	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	2836 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3X3		6009819.9871	2102225.5005	37.7528648722833	-122.408926150195	(37.7528648722833, -122.408926150195)
10079	10079	492	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2749X 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6010397.1581	2102215.0511	37.752868494158704	-122.406929439613	(37.7528684941587, -122.406929439613)
188438	188438	245412	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2802 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 0ft		6009963.8161	2102233.787	37.7528956807716	-122.408429345015	(37.7528956807716, -122.408429345015)
177119	177119	245470	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2700 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			21	Width 0ft		6010486.0542	2102262.08	37.753002599060295	-122.40662533272899	(37.7530025990603, -122.406625332729)
879	879	246305	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2135 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	Width 0ft		6006876.9266	2105933.3644	37.762880513109295	-122.41936683944401	(37.7628805131093, -122.419366839444)
228	228	246283	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2125 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			17	Width 0ft		6006872.377	2105970.5198	37.7629822769131	-122.419385210964	(37.7629822769131, -122.419385210964)
187140	187140	183273	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1251 40th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		5983646.3542	2106625.2038	37.7634443416971	-122.49976317535801	(37.7634443416971, -122.499763175358)
26993	26993	101263	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	2000 Irving St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12		Permit Number 20727	5989478.8752	2106534.6445	37.76353621964879	-122.479583963683	(37.7635362196488, -122.479583963683)
92566	92566	113466	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	450 CHURCH ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4				6x6		6004088.0	2106523.0	37.764342039298896	-122.429054808288	(37.7643420392989, -122.429054808288)
67589	67589	181728	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2755 29th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5987089.3098	2107026.595	37.7647478839827	-122.487884750055	(37.7647478839827, -122.487884750055)
157627	157627	245462	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2886 16th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6007544.8329	2106792.8686	37.7652781065022	-122.41711768386001	(37.7652781065022, -122.41711768386)
57912	57912	200832	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2000 16th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6010535.924	2106957.4024	37.7658976908793	-122.406783753376	(37.7658976908793, -122.406783753376)
165399	165399	32294	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1616 16th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/19/1996 12:00:00 AM	12		Permit Number 36875	6011626.7926	2107023.9767	37.7661414653506	-122.403015326989	(37.7661414653506, -122.403015326989)
177880	177880	248404	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1713 Waller St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		5997468.9999	2108115.1317	37.768336729240296	-122.452062838629	(37.7683367292403, -122.452062838629)
155231	155231	246099	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	700 Stanyan St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		5997115.1441	2108154.4994	37.7684245472814	-122.453289628456	(37.7684245472814, -122.453289628456)
52969	52969	248377	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	701 Cole St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 0ft		5997902.4997	2108143.1434	37.7684384639657	-122.45056543049401	(37.7684384639657, -122.450565430494)
153054	153054	246152	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1720 Waller St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		5997446.2877	2108155.2565	37.7684456006596	-122.45214429305	(37.7684456006596, -122.45214429305)
35119	35119	248351	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1587 Waller St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		5997991.38	2108188.2649	37.7685674429378	-122.450261255818	(37.7685674429378, -122.450261255818)
167539	167539	248335	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1559 Waller St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		5998127.3503	2108207.3431	37.768627607196	-122.449792323102	(37.768627607196, -122.449792323102)
177206	177206	246136	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1556 Waller St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		5998150.3653	2108253.3731	37.768755310607	-122.449716033907	(37.768755310607, -122.449716033907)
4243	4243	246126	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1546 Waller St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		5998264.228999999	2108270.3316	37.768808388052605	-122.449323411621	(37.7688083880526, -122.449323411621)
173043	173043	248359	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1485 Waller St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		5998647.9135	2108278.8108	37.768853609287206	-122.44799689076099	(37.7688536092872, -122.447996890761)
189100	189100	246130	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1486 Waller St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		5998621.8702	2108319.087	37.768962708792	-122.448089872703	(37.768962708792, -122.448089872703)
150342	150342	246133	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	662 Clayton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		5998546.7685	2108359.3633	37.7690690038469	-122.44835254426701	(37.7690690038469, -122.448352544267)
156171	156171	246039	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1378 Waller St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		5999138.4966	2108392.6745	37.7691942805388	-122.446308196721	(37.7691942805388, -122.446308196721)
72403	72403	247348	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1563 Page St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		5999102.728999999	2109036.7578	37.7709607271706	-122.44647825803001	(37.7709607271706, -122.44647825803)
73607	73607	247258	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2089 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		5997028.4355	2109091.0184	37.7709910168471	-122.453657177015	(37.7709910168471, -122.453657177015)
19705	19705	17131	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2001 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		5997393.7333	2109140.5793	37.771148033222794	-122.452397184671	(37.7711480332228, -122.452397184671)
18301	18301	17129	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1999 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		5997503.109	2109154.2513	37.7711918386222	-122.452019838592	(37.7711918386222, -122.452019838592)
19773	19773	17120	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1931 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3X3		5997753.4769	2109191.4219	37.7713082373467	-122.45115649157499	(37.7713082373467, -122.451156491575)
72703	72703	244544	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1921 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		5997795.9759	2109196.9758	37.7713259200895	-122.451009886929	(37.7713259200895, -122.451009886929)
21997	21997	17116	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1899 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3X3		5997981.6278	2109222.6111	37.771406934874896	-122.450369559944	(37.7714069348749, -122.450369559944)
22051	22051	28786	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	800 Haight St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	3X3		6002265.8749	2109178.7673	37.7715308120493	-122.43554702410299	(37.7715308120493, -122.435547024103)
18044	18044	4510	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1805X Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		5998343.9349	2109273.4537	37.7715672642721	-122.449119990901	(37.7715672642721, -122.449119990901)
186591	186591	247390	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	217 Scott St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6002281.8171	2109227.9509	37.7716667634841	-122.43549539828501	(37.7716667634841, -122.435495398285)
159801	159801	247268	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1621 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		5999221.2905	2109393.9379	37.77194822419221	-122.44609384766501	(37.7719482241922, -122.446093847665)
18829	18829	14559	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1595X Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3x3		5999419.8987	2109421.3340000003	37.772034786606	-122.44540881989799	(37.772034786606, -122.445408819898)
21019	21019	15299	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1640 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6006975.8032	2109269.1574	37.7720453828325	-122.41926150288602	(37.7720453828325, -122.419261502886)
47829	47829	245112	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1511 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		5999762.5828	2109470.1939	37.7721884999222	-122.44422696449499	(37.7721884999222, -122.444226964495)
155471	155471	247306	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	873 Page St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6002371.1002	2109493.4114	37.772400722701796	-122.435205553676	(37.7724007227018, -122.435205553676)
151317	151317	245078	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1387 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6000393.4407	2109556.4466	37.7724612989944	-122.442050971779	(37.7724612989944, -122.442050971779)
21314	21314	17056	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1285 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	5x4.5		6000853.6213	2109624.5846	37.7726746024779	-122.44046405381799	(37.7726746024779, -122.440464053818)
185077	185077	244147	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	405 Rose St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6004529.1957	2109628.6007	37.772894233589795	-122.42775012801701	(37.7728942335898, -122.427750128017)
166183	166183	140160	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	251 ASHBURY ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		5998786.9251	2109803.6706	37.773048431195	-122.44762584345501	(37.773048431195, -122.447625843455)
171426	171426	140142	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	208 Cole St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		5997849.5605	2109871.4122	37.773180816519606	-122.450873174815	(37.7731808165196, -122.450873174815)
2909	2909	140144	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	2077 HAYES ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		5997892.6775	2109904.5645	37.7732743123753	-122.450726418895	(37.7732743123753, -122.450726418895)
17687	17687	9652	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	75 Gough St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/07/1995 12:00:00 AM	3	2x3		6006083.2108	2109791.7339	37.773429942464205	-122.42238619158998	(37.7734299424642, -122.42238619159)
50203	50203	247450	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	917 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6002601.5894	2109867.0536	37.773439737619704	-122.43443498999599	(37.7734397376197, -122.434434989996)
17157	17157	16991	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	899 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6002773.5007	2109890.2869	37.7735132873347	-122.433841985714	(37.7735132873347, -122.433841985714)
17284	17284	16993	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	900 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6002625.7759	2109923.0859	37.7735949613156	-122.434355332323	(37.7735949613156, -122.434355332323)
18945	18945	17664	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	892X Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6002741.8184	2109937.0039	37.773639762745	-122.433954919315	(37.773639762745, -122.433954919315)
30879	30879	247445	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	811 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6003098.9445	2109936.0688	37.7736574554899	-122.432719499751	(37.7736574554899, -122.432719499751)
57372	57372	247439	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	430 Scott St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6002222.1913	2110011.395	37.7738145198575	-122.435757709689	(37.7738145198575, -122.435757709689)
21063	21063	16972	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	780 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3X3		6003244.9501	2110008.9107	37.7738657407699	-122.43221964740499	(37.7738657407699, -122.432219647405)
130045	130045	244324	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	717 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6003593.9138	2110004.6215	37.7738737432923	-122.43101221930401	(37.7738737432923, -122.431012219304)
58025	58025	244505	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	691 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6003712.7095	2110021.2984	37.7739262645997	-122.430602475909	(37.7739262645997, -122.430602475909)
168437	168437	244244	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	150 Page St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6005791.8047	2110016.6014	37.7740309317752	-122.423410197258	(37.7740309317752, -122.423410197258)
56402	56402	244277	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	591 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6004198.7601	2110089.4375	37.7741408812785	-122.42892600498301	(37.7741408812785, -122.428926004983)
167163	167163	142073	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	419 BRODERICK ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6001163.9737	2110159.9703	37.774162304079	-122.439428898655	(37.774162304079, -122.439428898655)
21210	21210	19218	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1103X Fell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6002097.9849	2110143.8576	37.7741711731344	-122.43619684024799	(37.7741711731344, -122.436196840248)
53929	53929	140264	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2100X Grove St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		5997701.9343	2110276.144	37.7742836533846	-122.451413027686	(37.7742836533846, -122.451413027686)
62836	62836	71305	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	445 Broderick St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/11/1988 12:00:00 AM	12			6001154.5387	2110263.7555	37.7744467352044	-122.43946897716299	(37.7744467352044, -122.439468977163)
120076	120076	140725	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	508 SCOTT ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6002187.9434	2110254.4569	37.77447996187411	-122.43589357348499	(37.7744799618741, -122.435893573485)
39552	39552	141364	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	451 BRODERICK ST	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 0ft		6001150.566000001	2110292.0606	37.7745242278003	-122.439484748915	(37.7745242278003, -122.439484748915)
170986	170986	141341	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	448 BRODERICK ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6001191.7822	2110294.5435	37.7745333908239	-122.43934235241699	(37.7745333908239, -122.439342352417)
71619	71619	140705	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	500 PIERCE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		6002662.6848	2110317.4944	37.774680004154504	-122.43425586131599	(37.7746800041545, -122.434255861316)
175619	175619	244473	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	859 Fell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6003334.8057	2110313.6958	37.774707699745996	-122.43193059003599	(37.774707699746, -122.431930590036)
74857	74857	245843	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	350 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 0ft		6005198.7946	2110284.9355	37.774734224571795	-122.42548062261001	(37.7747342245718, -122.42548062261)
38088	38088	142102	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	900 Fell St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 0ft		6003042.617000001	2110331.1771	37.7747391304954	-122.43294257823798	(37.7747391304954, -122.432942578238)
35911	35911	142179	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	400 BAKER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6000700.9795	2110406.5438	37.7748129727095	-122.441048166714	(37.7748129727095, -122.441048166714)
18202	18202	16867	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	235 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	5x5		6005854.7098	2110323.2964	37.7748765923478	-122.42321440275299	(37.7748765923478, -122.423214402753)
22102	22102	16865	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	230 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6005838.6934	2110371.3705	37.7750076883115	-122.423273225017	(37.7750076883115, -122.423273225017)
63097	63097	140722	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	555 PIERCE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6002600.4394	2110449.7026	37.775039481864205	-122.43448063524599	(37.7750394818642, -122.434480635246)
47374	47374	70252	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	500 Broderick St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/11/1993 12:00:00 AM	10			6001164.2534	2110490.0118	37.7750685309709	-122.43945159440399	(37.7750685309709, -122.439451594404)
48261	48261	140224	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	610 FILLMORE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6003614.5841	2110462.3343	37.775131681161106	-122.430973390858	(37.7751316811611, -122.430973390858)
158599	158599	112132	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	630 Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		9			6003600.3374	2110567.9569	37.775420887509796	-122.431030213476	(37.7754208875098, -122.431030213476)
76232	76232	140214	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	668 Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6003589.5295	2110658.3502	37.7756684727789	-122.43107405366001	(37.7756684727789, -122.43107405366)
163992	163992	138865	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	700 STEINER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6003091.7893	2110720.9068	37.775812020633005	-122.432800328558	(37.775812020633, -122.432800328558)
49751	49751	141659	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	16 LOYOLA TER	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		5998449.6222	2110830.3835	37.7758482379963	-122.44886658065799	(37.7758482379963, -122.448866580658)
911	911	12249	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	511 Laguna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6004989.1563	2110705.1842	37.7758762780635	-122.42623573054199	(37.7758762780635, -122.426235730542)

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