Street_Tree_List

Data source: data.sfgov.org

1,442 rows where qSpecies = 59 sorted by SiteOrder 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, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder ▲	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
112823	112823	113475	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	450 CHURCH ST	32	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4				6x6		6004088.0	2106523.0	37.764342039298896	-122.429054808288	(37.7643420392989, -122.429054808288)
87131	87131	113474	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	450 CHURCH ST	31	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4				6x6		6004088.0	2106523.0	37.764342039298896	-122.429054808288	(37.7643420392989, -122.429054808288)
124165	124165	113473	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	450 CHURCH ST	30	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4				6x6		6004088.0	2106523.0	37.764342039298896	-122.429054808288	(37.7643420392989, -122.429054808288)
96050	96050	113472	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	450 CHURCH ST	29	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4				6x6		6004088.0	2106523.0	37.764342039298896	-122.429054808288	(37.7643420392989, -122.429054808288)
42976	42976	113471	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	450 CHURCH ST	28	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4				6x6		6004088.0	2106523.0	37.764342039298896	-122.429054808288	(37.7643420392989, -122.429054808288)
144168	144168	113470	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	450 CHURCH ST	27	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4				6x6		6004088.0	2106523.0	37.764342039298896	-122.429054808288	(37.7643420392989, -122.429054808288)
80997	80997	113469	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	450 CHURCH ST	26	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4				6x6		6004088.0	2106523.0	37.764342039298896	-122.429054808288	(37.7643420392989, -122.429054808288)
111779	111779	113467	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	450 CHURCH ST	24	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4				6x6		6004088.0	2106523.0	37.764342039298896	-122.429054808288	(37.7643420392989, -122.429054808288)
51389	51389	141496	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2901 TURK BLVD	20	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		5997041.2335	2111532.8232	37.77769631160189	-122.45378926737101	(37.7776963116019, -122.453789267371)
67728	67728	141494	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2901 TURK BLVD	18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		5996978.1424	2111525.1425	37.7776716051006	-122.45400696498899	(37.7776716051006, -122.454006964989)
4565	4565	142525	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	301 FRANCISCO ST	15	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4			23	Width 0ft		6009759.5801	2121214.59	37.8050010513122	-122.410475804946	(37.8050010513122, -122.410475804946)
96109	96109	141490	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2901 TURK BLVD	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5996921.6348	2111517.4619	37.7776472759958	-122.454201888036	(37.7776472759958, -122.454201888036)
230	230	138371	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			17	Width 0ft		6002611.3346	2114434.4469999997	37.785981206770394	-122.434727951803	(37.7859812067704, -122.434727951803)
3347	3347	140434	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1499 Turk St	13	Sidewalk: Curb side : Cutout 1	Tree 1	Police Dept 18			14	Width 0ft		6003279.731000001	2112394.6985	37.780418493723204	-122.43226975660299	(37.7804184937232, -122.432269756603)
67341	67341	199739	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1500 Armstrong Ave	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6014497.7489	2092432.2899	37.7262356573725	-122.392064648003	(37.7262356573725, -122.392064648003)
211	211	138370	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			16	Width 0ft		6002647.5104	2114436.9248	37.7859900638921	-122.434602970779	(37.7859900638921, -122.434602970779)
3337	3337	140433	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1499 Turk St	12	Sidewalk: Curb side : Cutout 1	Tree 1	Police Dept 18			15	Width 0ft		6003251.7396	2112391.1099	37.7804070531695	-122.432366335522	(37.7804070531695, -122.432366335522)
37099	37099	141488	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2901 TURK BLVD	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5996896.3984	2111514.1702	37.7776367906711	-122.454288950996	(37.7776367906711, -122.454288950996)
69184	69184	199738	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1500 Armstrong Ave	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6014531.8139	2092406.2929	37.7261661660829	-122.39194506905001	(37.7261661660829, -122.39194506905)
163560	163560	199757	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1555 Yosemite Ave	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6015056.6652	2092285.8367	37.7258645418149	-122.39012226093901	(37.7258645418149, -122.390122260939)
173192	173192	142746	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	661 LOMBARD ST	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	Width 0ft		6009447.7459	2120475.7434	37.802954876200204	-122.41150271469601	(37.8029548762002, -122.411502714696)
192	192	138369	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			16	Width 0ft		6002665.8461	2114439.4026	37.78599790817471	-122.434539711553	(37.7859979081747, -122.434539711553)
38816	38816	246090	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	700 Stanyan St	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		5997084.5583	2108373.7477	37.769024793611	-122.45341125296001	(37.769024793611, -122.45341125296)
71914	71914	143259	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	661 LOMBARD ST	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 0ft		6009421.8295	2120470.7273	37.802939649537294	-122.41159204460399	(37.8029396495373, -122.411592044604)
133517	133517	140585	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	949 FILLMORE ST	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			21	Width 0ft		6003432.0437	2111445.4153	37.777820633348796	-122.43167504147699	(37.7778206333488, -122.431675041477)
178657	178657	142600	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	365 COLUMBUS AVE	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6008394.1949	2120748.9012	37.803645748305	-122.415167905628	(37.803645748305, -122.415167905628)
188	188	138368	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			13	Width 0ft		6002679.2262	2114443.3671	37.786009553218996	-122.434493703661	(37.786009553219, -122.434493703661)
27933	27933	143258	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	661 LOMBARD ST	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			21	Width 0ft		6009397.1671	2120467.3833	37.8029290843214	-122.41167715318599	(37.8029290843214, -122.411677153186)
39425	39425	142599	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	365 COLUMBUS AVE	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6008384.0855	2120756.6777	37.8036665324855	-122.415203440632	(37.8036665324855, -122.415203440632)
46667	46667	141799	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1280 WEBSTER ST	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6003782.7951	2113127.1113	37.782458027558	-122.43058169950899	(37.782458027558, -122.430581699509)
47656	47656	140713	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	500 PIERCE ST	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6002640.192000001	2110470.3137	37.775098331299	-122.434344596397	(37.775098331299, -122.434344596397)
49750	49750	137532	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1300 Pierce St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6002250.4834	2113262.6052	37.7827431340216	-122.435892519009	(37.7827431340216, -122.435892519009)
155611	155611	140584	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	949 FILLMORE ST	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 0ft		6003428.3587	2111466.6041	37.77787860365579	-122.431689302353	(37.7778786036558, -122.431689302353)
161629	161629	246091	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	700 Stanyan St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		5997087.5866	2108354.0638	37.7689709202682	-122.45339935697099	(37.7689709202682, -122.453399356971)
164399	164399	141486	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2901 TURK BLVD	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5996862.6584	2111508.4097	37.77761903893	-122.454405252217	(37.77761903893, -122.454405252217)
201	201	138367	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			15	Width 0ft		6002691.6152	2114444.3582	37.7860129777854	-122.434450912019	(37.7860129777854, -122.434450912019)
26522	26522	140712	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	500 PIERCE ST	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6002642.8382	2110450.4669999997	37.7750439873946	-122.434334023387	(37.7750439873946, -122.434334023387)
41568	41568	140583	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	949 FILLMORE ST	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			21	Width 0ft		6003424.6737	2111485.9504	37.7779315149131	-122.431703431668	(37.7779315149131, -122.431703431668)
72235	72235	143257	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	661 LOMBARD ST	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			21	Width 0ft		6009374.1767	2120464.0392	37.8029186125655	-122.41175647573	(37.8029186125655, -122.41175647573)
97930	97930	199735	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1500 Armstrong Ave	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6014648.3519	2092320.2341	37.7259363350419	-122.391536186534	(37.7259363350419, -122.391536186534)
147829	147829	141798	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1280 WEBSTER ST	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6003785.6349	2113107.9429	37.7824055567974	-122.43057050684901	(37.7824055567974, -122.430570506849)
164164	164164	142598	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	365 COLUMBUS AVE	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6008376.308999999	2120765.2318	37.8036895828586	-122.415230957587	(37.8036895828586, -122.415230957587)
187956	187956	246092	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	700 Stanyan St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		5997091.8262	2108330.4431	37.7689063069149	-122.45338298694901	(37.7689063069149, -122.453382986949)
217	217	138366	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	Width 0ft		6002708.9598	2114445.3493	37.7860166836287	-122.43439097535801	(37.7860166836287, -122.434390975358)
3051	3051	99233	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1111 Columbus Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3x3		6008063.2168	2121048.832	37.8044506767497	-122.416334531861	(37.8044506767497, -122.416334531861)
3339	3339	140429	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1499 TURK ST	8	Sidewalk: Curb side : Cutout 1	Tree 1	Police Dept 18			15	Width 0ft		6003096.7102	2112369.578	37.7803391401181	-122.432901115602	(37.7803391401181, -122.432901115602)
3904	3904	4665	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	600X Columbus Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	Rec/Park 3			100	5X5		6009675.3838	2119664.5956	37.8007404309352	-122.410657649881	(37.8007404309352, -122.410657649881)
7644	7644	7201	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	949 Fillmore St	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6003424.6737	2111504.3754	37.7779821053868	-122.431704747493	(37.7779821053868, -122.431704747493)
43131	43131	143256	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	661 LOMBARD ST	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			22	Width 0ft		6009354.5304	2120461.1132	37.8029094763595	-122.411824255457	(37.8029094763595, -122.411824255457)
130431	130431	142597	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	365 COLUMBUS AVE	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6008368.5325	2120773.0083	37.8037104981311	-122.41525841948	(37.8037104981311, -122.41525841948)
130527	130527	141689	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2350 TURK BLVD	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		5998480.6511	2111795.7451	37.778500645914995	-122.44882879479601	(37.778500645915, -122.448828794796)
153096	153096	199728	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2300 Jennings St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6014985.6871	2092077.3996	37.725288278052	-122.390353072543	(37.725288278052, -122.390353072543)
154687	154687	246093	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	700 Stanyan St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		5997094.8545	2108310.1536	37.7688507707463	-122.453371047271	(37.7688507707463, -122.453371047271)
157740	157740	140711	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	500 PIERCE ST	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6002645.4844	2110432.6051	37.7749950932562	-122.434323592325	(37.7749950932562, -122.434323592325)
167113	167113	143354	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1651 UNION ST	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 0ft		6005214.4581	2118841.5322	37.798229393632205	-122.42603569078501	(37.7982293936322, -122.426035690785)
195	195	138365	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			19	Width 0ft		6002748.6045	2114451.296	37.78603526200121	-122.43425424087799	(37.7860352620012, -122.434254240878)
273	273	20166	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1155X Steiner St	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			20	4X4		6002621.0	2112212.0	37.7798794773869	-122.43453554599199	(37.7798794773869, -122.434535545992)
1759	1759	7200	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	949 Fillmore St	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6003420.9887	2111521.8792	37.7780299575939	-122.431718745255	(37.7780299575939, -122.431718745255)
3335	3335	140428	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1499 TURK ST	7	Sidewalk: Curb side : Cutout 1	Tree 1	Police Dept 18			14	Width 0ft		6003076.6138	2112365.9894	37.7803281468599	-122.43297038187401	(37.7803281468599, -122.432970381874)
5145	5145	4664	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	600X Columbus Ave	7	Sidewalk: Curb side : Cutout 1	Tree 1	Rec/Park 3			90	5X5		6009692.467999999	2119649.5892	37.8007001848924	-122.410597470914	(37.8007001848924, -122.410597470914)
8244	8244	99232	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1111 Columbus Ave	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3x3		6008054.705	2121057.3439	37.8044735696368	-122.416364591045	(37.8044735696368, -122.416364591045)
18580	18580	497	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2749X 24th St	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			20	3X3		6010516.451	2102220.2128	37.75288934158429	-122.40651726425399	(37.7528893415843, -122.406517264254)
22044	22044	15319	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1680 Mission St	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6006779.4102	2108712.5677	37.77050605746361	-122.41990134010099	(37.7705060574636, -122.419901340101)
23633	23633	137529	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1300 Pierce St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		6002258.0131	2113181.285	37.7825202770743	-122.43586064910801	(37.7825202770743, -122.435860649108)
26537	26537	199734	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1500 Armstrong Ave	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6014741.5822	2092253.0007	37.725756899909	-122.391209195431	(37.725756899909, -122.391209195431)
46867	46867	140710	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	500 PIERCE ST	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6002647.4691	2110413.42	37.7749425283913	-122.434315354923	(37.7749425283913, -122.434315354923)
50506	50506	140544	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1025 FILLMORE ST	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6003387.6502	2111766.8151	37.7787006008552	-122.431851568456	(37.7787006008552, -122.431851568456)
60153	60153	140509	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1020 FILLMORE ST	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6003414.9884	2111885.4448	37.779027878196004	-122.43176546737101	(37.779027878196, -122.431765467371)
133245	133245	246094	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	700 Stanyan St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		5997100.0026	2108265.6377	37.7687288366145	-122.453350026115	(37.7687288366145, -122.453350026115)
136070	136070	111735	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	313 Ivy St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	2.5x3		6005874.8827	2111210.5438	37.7773138971451	-122.423207702005	(37.7773138971451, -122.423207702005)
148089	148089	141688	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2350 TURK BLVD	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		5998531.7594	2111801.3756	37.7785190283548	-122.44865239820801	(37.7785190283548, -122.448652398208)
150951	150951	138127	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1850 FILLMORE ST	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	Width 0ft		6003021.61	2114689.1851	37.78670393670271	-122.433326721425	(37.7867039367027, -122.433326721425)
161834	161834	143353	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1651 UNION ST	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6005181.3418	2118836.9868	37.7982150414331	-122.42614995936701	(37.7982150414331, -122.426149959367)
173501	173501	142596	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	365 COLUMBUS AVE	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6008359.2007	2120780.7848	37.8037313259866	-122.415291263605	(37.8037313259866, -122.415291263605)
176045	176045	199858	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2513 Keith St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6014132.4385	2092038.2943	37.7251335354362	-122.393299957721	(37.7251335354362, -122.393299957721)
176204	176204	143255	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	661 LOMBARD ST	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			21	Width 0ft		6009331.5401	2120459.4412	37.802903595680704	-122.411903695843	(37.8029035956807, -122.411903695843)
179301	179301	110471	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	465 Grove St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		12	3x3		6005689.0684	2111342.3906	37.77766542832121	-122.42385987213899	(37.7776654283212, -122.423859872139)
216	216	138364	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	Width 0ft		6002783.7892	2114453.2783	37.7860427018539	-122.43413265320801	(37.7860427018539, -122.434132653208)
3349	3349	140427	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1499 TURK ST	6	Sidewalk: Curb side : Cutout 1	Tree 1	Police Dept 18			14	Width 0ft		6003052.211	2112362.4007	37.7803169090148	-122.43305454594	(37.7803169090148, -122.43305454594)
4252	4252	244056	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	401 Cole St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		5997913.0484	2109110.0936	37.771094065570296	-122.45059866498	(37.7710940655703, -122.45059866498)
6110	6110	13189	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2055X Lombard St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6002690.4208	2119498.1098	37.7998892100694	-122.43481657946998	(37.7998892100694, -122.43481657947)
7037	7037	4663	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	600X Columbus Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Rec/Park 3			60	5X5		6009710.0139	2119634.3519	37.8006593307081	-122.41053567802	(37.8006593307081, -122.41053567802)
7090	7090	21632	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1615 Sutter St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/04/1991 12:00:00 AM	12	4X4		6004741.4911	2114677.6404	37.7867696583856	-122.42737551849501	(37.7867696583856, -122.427375518495)
8426	8426	99231	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1111 Columbus Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	2x2		6008046.5206	2121063.2366	37.804489289265106	-122.416393331612	(37.8044892892651, -122.416393331612)
8894	8894	21590	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1500 Sutter St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	2X2		6005256.9547	2114799.289	37.78713281444121	-122.425600795702	(37.7871328144412, -122.425600795702)
20426	20426	496	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2749X 24th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6010495.2306	2102220.2128	37.7528881543902	-122.406590648723	(37.7528881543902, -122.406590648723)
29770	29770	138507	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1701 FILLMORE ST	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6003042.8042	2114198.3962	37.785357557038296	-122.433218313249	(37.7853575570383, -122.433218313249)
30500	30500	140709	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	500 PIERCE ST	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6002649.4537	2110396.2195	37.7748954127382	-122.43430725979401	(37.7748954127382, -122.434307259794)
30671	30671	111734	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	313 Ivy St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	2.5x3		6005865.3001	2111209.4164	37.777310260787	-122.423240771205	(37.777310260787, -122.423240771205)
37138	37138	140693	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1120 FILLMORE ST	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6003357.1733	2112337.09	37.780264705851	-122.43199773269801	(37.780264705851, -122.431997732698)
39969	39969	139449	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	508 OCTAVIA ST	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6005461.1411	2111122.6096	37.7770490933731	-122.42463271281	(37.7770490933731, -122.42463271281)
44319	44319	143254	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	661 LOMBARD ST	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6009304.3696	2120454.8431	37.802889446076605	-122.411997395012	(37.8028894460766, -122.411997395012)
46381	46381	98473	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1500 16th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3x3		6011870.2645	2107034.4384	37.7661837837598	-122.402173936122	(37.7661837837598, -122.402173936122)
46704	46704	246095	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	700 Stanyan St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		5997104.5451	2108242.017	37.768664240613205	-122.45333260848801	(37.7686642406132, -122.453332608488)
48419	48419	138126	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1850 FILLMORE ST	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			14	Width 0ft		6003024.8426	2114663.3242	37.78663311261921	-122.433313688795	(37.7866331126192, -122.433313688795)
60794	60794	137528	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1300 Pierce St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 0ft		6002263.2838	2113153.4253	37.7824440807926	-122.435840420812	(37.7824440807926, -122.435840420812)
66616	66616	110470	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	465 Grove St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		15	3x3		6005644.9931	2111337.1436	37.777648533038395	-122.42401197054701	(37.7776485330384, -122.424011970547)
67407	67407	142493	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	651 COLUMBUS AVE	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6009645.6019	2119599.491	37.8005599999984	-122.410756107582	(37.8005599999984, -122.410756107582)
68835	68835	199857	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2511 Keith St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6014147.0563	2092057.1756	37.725186191812	-122.39325074575198	(37.725186191812, -122.393250745752)
73758	73758	199726	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2300 Jennings St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6015013.7839	2092118.9829	37.725404016033295	-122.390258847729	(37.7254040160333, -122.390258847729)

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