Street_Tree_List

Data source: data.sfgov.org

143 rows where SiteOrder = 3 and qSpecies = 59 sorted by qCaretaker

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

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker ▼	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
593	593	140072	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	601X Octavia St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6005402.0	2111410.0	37.7778348570605	-122.424857751543	(37.7778348570605, -122.424857751543)
1176	1176	246082	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1390 Waller St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		5999092.1637	2108384.801	37.7691700156221	-122.44646789257601	(37.7691700156221, -122.446467892576)
2797	2797	142505	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	620 Vallejo St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/17/2014 12:00:00 AM	22	Width 0ft	Permit Number 774306	6010566.6807	2118940.2612	37.7988015168915	-122.407522281284	(37.7988015168915, -122.407522281284)
2908	2908	140145	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	2077 HAYES ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		5997912.6072	2109907.6306	37.7732838718856	-122.45065770078699	(37.7732838718856, -122.450657700787)
4278	4278	246148	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1504 Waller St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		5998461.6736	2108298.4947	37.768897008730896	-122.44864249661501	(37.7688970087309, -122.448642496615)
5657	5657	26166	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1501 Lombard St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	3X3		6005131.2215	2119837.4845	37.8009593191179	-122.426394664407	(37.8009593191179, -122.426394664407)
5722	5722	21711	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1900 Sutter St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	6x6		6003392.8992	2114541.4083	37.7863192355998	-122.43203159373999	(37.7863192355998, -122.43203159374)
6233	6233	4722	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1040 Columbus Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			22	4x4		6008317.4743	2120903.2884	37.804065344872704	-122.415444338519	(37.8040653448727, -122.415444338519)
6362	6362	21629	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1615 Sutter St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/29/1994 12:00:00 AM	12	4X4		6004674.0893	2114666.9174	37.786736403473704	-122.427607948661	(37.7867364034737, -122.427607948661)
6459	6459	13183	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	2001 Lombard St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/26/1993 12:00:00 AM	12	3x3		6002759.5454	2119509.3192	37.7999239124366	-122.43457818463301	(37.7999239124366, -122.434578184633)
6546	6546	13195	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	2098 Lombard St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			40	3X3		6002408.3176	2119538.5881	37.7999843325384	-122.435795658785	(37.7999843325384, -122.435795658785)
6739	6739	99228	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1111 Columbus Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	2x2		6008013.4555	2121093.6827	37.8045710271276	-122.416509914664	(37.8045710271276, -122.416509914664)
6749	6749	13206	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	2150 Lombard St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			70	3X3		6002065.1856	2119491.2596	37.799834883876	-122.436979633615	(37.799834883876, -122.436979633615)
7263	7263	4725	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1050 Columbus Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			30	4x4		6008238.1211	2120976.4945	37.8042618899237	-122.415724133248	(37.8042618899237, -122.415724133248)
15892	15892	97244	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1300X Keith St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3x3		6016216.2447	2094842.5281	37.7329489559822	-122.38629180873501	(37.7329489559822, -122.386291808735)
22235	22235	17057	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1285 Oak St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	3X3		6000879.2146	2109627.576	37.772684273376	-122.440375738629	(37.772684273376, -122.440375738629)
22359	22359	246131	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1486 Waller St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		5998602.7919	2108317.2701	37.768956629428395	-122.448155732181	(37.7689566294284, -122.448155732181)
22888	22888	245220	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	351 Laguna St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 0ft		6005075.2787	2110089.7787	37.774191391909596	-122.425893994936	(37.7741913919096, -122.425893994936)
24601	24601	138420	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1819 STEINER ST	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			14	Width 0ft		6002521.5979	2114452.899	37.786026776312596	-122.435039736101	(37.7860267763126, -122.435039736101)
24888	24888	45611	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1100 Fillmore St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/06/2001 12:00:00 AM	16		Permit Number 44335	6003449.1823	2112117.4289	37.7796667869975	-122.43166374401001	(37.7796667869975, -122.43166374401)
27146	27146	140419	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1120 STEINER ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 0ft		6002875.6498	2112268.3783	37.780048730384	-122.43365863076201	(37.780048730384, -122.433658630762)
27737	27737	248360	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1485 Waller St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		5998667.1431	2108281.3848	37.768861776014795	-122.447930562543	(37.7688617760148, -122.447930562543)
28034	28034	140161	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	251 ASHBURY ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		5998791.141	2109784.5074	37.7729960548875	-122.44760988046998	(37.7729960548875, -122.44760988047)
30246	30246	140690	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1120 FILLMORE ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6003362.1468	2112293.1578	37.7801443609542	-122.431977389111	(37.7801443609542, -122.431977389111)
31925	31925	139285	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	855 FILLMORE ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6003448.7737	2111306.0955	37.7774390440386	-122.431607217597	(37.7774390440386, -122.431607217597)
33367	33367	141080	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	192 Commonwealth Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		5996588.0468	2113019.8793	37.7817533832417	-122.45546448989799	(37.7817533832417, -122.455464489898)
34800	34800	140777	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	77 TERRA VISTA AVE	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6000158.3968	2112814.4573	37.7813935692054	-122.44309803536699	(37.7813935692054, -122.443098035367)
35662	35662	142960	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	180 Pfeiffer St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6009952.201	2121096.8109999998	37.804688455991396	-122.409800896711	(37.8046884559914, -122.409800896711)
36777	36777	142949	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	20 BELLAIR PL	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6010058.1538	2121167.8448	37.8048894342531	-122.40943925119	(37.8048894342531, -122.40943925119)
37168	37168	140723	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	555 PIERCE ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6002602.535	2110423.8561	37.7749686327575	-122.434471537714	(37.7749686327575, -122.434471537714)
37976	37976	140209	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	704 Fillmore St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6003553.8988	2110879.8473	37.7762746300025	-122.431213122749	(37.7762746300025, -122.431213122749)
40023	40023	141792	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1280 WEBSTER ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6003805.1483	2112935.1558	37.7819322319873	-122.43049066646499	(37.7819322319873, -122.430490666465)
43832	43832	138987	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	661 FILLMORE ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6003459.8516	2110684.9037	37.7757340330654	-122.43152453742701	(37.7757340330654, -122.431524537427)
44977	44977	143125	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2095 LOMBARD ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6002486.7834	2119470.7090000003	37.799802411097296	-122.435519279075	(37.7998024110973, -122.435519279075)
46666	46666	140592	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	950 STEINER ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6002968.2418	2111603.9288	37.778229571438295	-122.433290821469	(37.7782295714383, -122.433290821469)
47183	47183	98470	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1500 16th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3x3		6011914.0134	2107036.3406	37.7661914486194	-122.402022750022	(37.7661914486194, -122.402022750022)
50778	50778	140610	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	860 Fillmore St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		6003498.0852	2111306.0629	37.7774417494141	-122.431436630621	(37.7774417494141, -122.431436630621)
54759	54759	139432	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	539 OCTAVIA ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6005403.0601	2111196.299	37.77724814614	-122.424838877048	(37.77724814614, -122.424838877048)
55070	55070	120657	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	160 Folsom St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3x3	Permit Number 778623	6015078.8336	2115510.7898	37.7896365150846	-122.39166873056001	(37.7896365150846, -122.39166873056)
56825	56825	108010	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	419X Ivy St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7			6005279.8436	2111122.0196	37.777037232737705	-122.42525983588001	(37.7770372327377, -122.42525983588)
58026	58026	199854	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2505 Keith St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6014200.0457	2092143.0549	37.7254249428706	-122.393073571548	(37.7254249428706, -122.393073571548)
58031	58031	143187	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	184 FRANCISCO ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6010390.2098	2121342.6183	37.8053879184635	-122.408302464879	(37.8053879184635, -122.408302464879)
58347	58347	143363	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1892 UNION ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6003957.9860000005	2118713.6123	37.7978070663315	-122.43037432608801	(37.7978070663315, -122.430374326088)
58484	58484	138743	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2965 Bush St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5999307.6319	2114263.2516	37.7853230365302	-122.446145501349	(37.7853230365302, -122.446145501349)
58650	58650	138132	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2131 Bush St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6003095.0366	2114792.1671	37.786990864454296	-122.433080043725	(37.7869908644543, -122.433080043725)
59283	59283	140706	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	500 PIERCE ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6002658.7155	2110338.0026	37.774736089286606	-122.434271058386	(37.7747360892866, -122.434271058386)
59370	59370	141680	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2340 TURK BLVD	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		5998758.0111	2111834.2387	37.7786221965848	-122.447872077437	(37.7786221965848, -122.447872077437)
59660	59660	117031	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	2100 Sutter St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	3x3		6002487.092999999	2114413.0027	37.78591527192879	-122.435156258966	(37.7859152719288, -122.435156258966)
61363	61363	138465	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1870 Scott St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6001534.446	2114897.4717	37.7871913575616	-122.43848687191401	(37.7871913575616, -122.438486871914)
63167	63167	142150	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	20 Stanyan Blvd	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		5996389.5624	2112799.0591	37.7811356783284	-122.456135178495	(37.7811356783284, -122.456135178495)
63234	63234	142593	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	365 COLUMBUS AVE	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6008314.0969	2120822.0003	37.8038419583694	-122.415450267897	(37.8038419583694, -122.415450267897)
64636	64636	246098	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	700 Stanyan St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		5997112.7214	2108174.1833	37.7684784553517	-122.45329942957198	(37.7684784553517, -122.453299429572)
64988	64988	138503	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1799 Steiner St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6002537.1515	2114272.2749	37.7855317115931	-122.43497300238899	(37.7855317115931, -122.434973002389)
66174	66174	30889	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	412 Hayes St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/08/1995 12:00:00 AM	21	4x4	Permit Number 34719	6005803.6075	2111060.8215	37.776898773465796	-122.42344361968	(37.7768987734658, -122.42344361968)
66204	66204	143212	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	175 FRANCISCO ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6010402.9445	2121293.4361	37.8052535894305	-122.408254923564	(37.8052535894305, -122.408254923564)
68465	68465	108005	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	520 Hayes St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			21	3x3		6005304.2003	2110990.4457	37.7766773388863	-122.425166213949	(37.7766773388863, -122.425166213949)
68579	68579	138831	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	745 BUCHANAN ST	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 0ft		6004451.1778	2111098.9724	37.7769271009021	-122.428124806353	(37.7769271009021, -122.428124806353)
70659	70659	139446	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	508 OCTAVIA ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6005466.7779	2111071.8783	37.7769101159246	-122.424609603708	(37.7769101159246, -122.424609603708)
71986	71986	200997	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	150 Folsom St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6015155.9522	2115579.6824	37.7898299587744	-122.39140672399999	(37.7898299587744, -122.391406724)
72177	72177	143349	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1651 UNION ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6005080.6941	2118822.0519999997	37.798168345125205	-122.426497166568	(37.7981683451252, -122.426497166568)
72866	72866	142989	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1851 Grant Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6010373.868	2120901.8959999997	37.8041768891146	-122.408327913174	(37.8041768891146, -122.408327913174)
73003	73003	117049	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2183 Sutter St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	3x3		6002213.4716	2114319.9367	37.7856441950939	-122.436096250016	(37.7856441950939, -122.436096250016)
73100	73100	141695	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	392 EWING TER	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5998748.3741	2112341.6402	37.78001483889879	-122.44794195643499	(37.7800148388988, -122.447941956435)
73309	73309	110467	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	465 Grove St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		15	3x3		6005585.7014	2111327.1742	37.7776178118347	-122.424216371681	(37.7776178118347, -122.424216371681)
73921	73921	142633	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	241 BAY ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6009714.0145	2121546.0367	37.805908566732896	-122.41065691150699	(37.8059085667329, -122.410656911507)
75416	75416	33693	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	401 Ivy St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/03/1996 12:00:00 AM	13		Permit Number 37765	6005397.8063	2111143.0332	37.7771015944949	-122.42485326118401	(37.7771015944949, -122.424853261184)
76808	76808	138539	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1700 FILLMORE ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6003089.8085	2114203.6138	37.785374549591204	-122.433056065597	(37.7853745495912, -122.433056065597)
120867	120867	143169	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	185 Bay St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6009906.0036	2121573.3589	37.80599434882029	-122.40999443049999	(37.8059943488203, -122.4099944305)
129779	129779	141586	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1301 FULTON ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6001472.6683	2111100.3675	37.776761961586	-122.438428460489	(37.776761961586, -122.438428460489)
130403	130403	143498	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	857 Kearny St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6011217.723999999	2117930.0991	37.796064276257205	-122.40519827705499	(37.7960642762572, -122.405198277055)
130476	130476	142490	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	651 COLUMBUS AVE	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6009644.6785	2119609.6491	37.8005878398576	-122.41076002073	(37.8005878398576, -122.41076002073)
130725	130725	245471	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2700 24th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 0ft		6010463.1133	2102261.5065	37.7529997408326	-122.406704626743	(37.7529997408326, -122.406704626743)
131662	131662	247451	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	915 Oak St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6002618.2019	2109871.0089	37.773451540866496	-122.434377807884	(37.7734515408665, -122.434377807884)
131793	131793	138473	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1749 FILLMORE ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6003016.4418	2114370.4842	37.7858285716099	-122.433321820329	(37.7858285716099, -122.433321820329)
131804	131804	138123	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1850 FILLMORE ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6003035.9259	2114580.1998	37.786405502849604	-122.433269401448	(37.7864055028496, -122.433269401448)
132458	132458	97936	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2133 Stockton St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	3x3		6009809.8586	2121486.2629	37.8057498158932	-122.41032100357701	(37.8057498158932, -122.410321003577)
132858	132858	138866	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	700 STEINER ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6003084.5886	2110775.7422	37.7759621766443	-122.43282915583401	(37.7759621766443, -122.432829155834)
134331	134331	139436	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	410 Ivy St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6005361.8436	2111159.167	37.7771438626442	-122.424978815742	(37.7771438626442, -122.424978815742)
134866	134866	244278	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	589 Oak St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6004214.5249	2110092.3934	37.774149889764	-122.42887168253701	(37.774149889764, -122.428871682537)
135066	135066	141781	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1480 ELLIS ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6003816.5092	2113214.7018	37.7827004390473	-122.43047131515301	(37.7827004390473, -122.430471315153)
135750	135750	247391	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	215 Scott St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6002287.9227	2109197.4231	37.7715832884679	-122.435472094457	(37.7715832884679, -122.435472094457)
147110	147110	248373	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1609 Waller St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		5997837.6943	2108167.0669	37.768500442306106	-122.45079131066002	(37.7685004423061, -122.45079131066)
148433	148433	244501	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	607 Oak St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6004030.4942	2110064.8827	37.7740639341827	-122.42950631481199	(37.7740639341827, -122.429506314812)
148475	148475	137800	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1900 Laguna St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6004352.4834	2115615.8021	37.7893236058288	-122.42878829933001	(37.7893236058288, -122.42878829933)
149432	149432	140067	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	616 Octavia St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6005420.4192	2111411.6517	37.7778404325738	-122.424794150591	(37.7778404325738, -122.424794150591)
150460	150460	106407	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	650 Presidio Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	5x6		5999244.445	2114365.5896	37.7856004213418	-122.44637147273599	(37.7856004213418, -122.446371472736)
151721	151721	139365	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1590 LYON ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		5999665.9385	2114296.9513	37.7854360225018	-122.44490829680599	(37.7854360225018, -122.444908296806)
152489	152489	111433	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	500X Presidio Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	3x3		5999168.0016	2114897.9415	37.7870577541309	-122.446674260217	(37.7870577541309, -122.446674260217)
153723	153723	245132	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1585 Oak St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		5999461.1138	2109428.3140000002	37.7720563046211	-122.44526675609801	(37.7720563046211, -122.445266756098)
153827	153827	143126	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2055 LOMBARD ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6002559.0217	2119480.0502	37.7998321621177	-122.43526997659201	(37.7998321621177, -122.435269976592)
155583	155583	142120	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1218 Grove St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		6001961.8598	2110867.3987	37.77615010114471	-122.436719523648	(37.7761501011447, -122.436719523648)
155652	155652	143146	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2190 LOMBARD ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6001904.5176	2119470.0863	37.7997676141851	-122.437534086686	(37.7997676141851, -122.437534086686)
155936	155936	111731	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	313 Ivy St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	2.5x3		6005824.7151	2111202.6522	37.7772893974301	-122.423380687053	(37.7772893974301, -122.423380687053)
157258	157258	143535	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2095 UNION ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6003024.3746	2118536.7593	37.7972685458155	-122.433592232654	(37.7972685458155, -122.433592232654)
158904	158904	141084	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	3360 GEARY BLVD	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		5996679.0822	2112965.7318	37.7816099317752	-122.45514563789	(37.7816099317752, -122.45514563789)
162133	162133	138374	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1801 Steiner St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6002553.8497	2114553.8768	37.786305866911796	-122.43493537792601	(37.7863058669118, -122.434935377926)
162784	162784	141765	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1529 O'Farrell St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6003847.9445	2113512.4132	37.7835196607686	-122.43038381035	(37.7835196607686, -122.43038381035)
162965	162965	138040	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1 Wilmot St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6003385.4026	2115029.2516	37.7876583048425	-122.432092380369	(37.7876583048425, -122.432092380369)
163380	163380	245439	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2940 16th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			22	Width 0ft		6007210.058999999	2106771.9452	37.7652018171161	-122.418274106734	(37.7652018171161, -122.418274106734)
163469	163469	138718	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1605 Lyon St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		5999603.495	2114383.6783	37.7856705883683	-122.445130569247	(37.7856705883683, -122.445130569247)

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