Street_Tree_List

Data source: data.sfgov.org

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

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

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes ▼	XCoord	YCoord	Latitude	Longitude	Location
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)
231	231	138360	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			14	Width 0ft		6002847.7164	2114462.1983	37.7860708218731	-122.433912120385	(37.7860708218731, -122.433912120385)
342	342	21738	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2045 Sutter St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6002837.9936	2114410.7158	37.7859289122324	-122.43394207733601	(37.7859289122324, -122.433942077336)
594	594	140071	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	601X Octavia St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6005402.0	2111410.0	37.7778348570605	-122.424857751543	(37.7778348570605, -122.424857751543)
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)
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)
1072	1072	7266	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1740 Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			16	4X4		6003064.3461	2114369.1192	37.7858275412041	-122.433155987425	(37.7858275412041, -122.433155987425)
1120	1120	7264	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1730 Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	4X4		6003073.6496	2114318.6841	37.78568958693	-122.43312019509199	(37.78568958693, -122.433120195092)
1172	1172	143012	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	336 LOMBARD ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 0ft		6010686.887999999	2120692.5302	37.803619545603205	-122.40722991099	(37.8036195456032, -122.40722991099)
1463	1463	13191	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2095 Lombard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6002470.5921	2119469.4635	37.7997980716779	-122.43557521775601	(37.7997980716779, -122.435575217756)
1477	1477	138092	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1890 Sutter St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			19	Width 0ft		6003632.0	2114586.0	37.7864552256154	-122.43120755079399	(37.7864552256154, -122.431207550794)
1504	1504	21609	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1531 Sutter St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/09/1990 12:00:00 AM	12	4X4		6005037.9058	2114711.086	37.7868782513618	-122.42635237507	(37.7868782513618, -122.42635237507)
1838	1838	9642	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1482 Golden Gate Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			15	3x3		6002517.4506	2111986.4237	37.7792542228164	-122.43487763237101	(37.7792542228164, -122.434877632371)
1971	1971	21669	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1776 Sutter St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			22	4X4		6004141.1865	2114642.4934	37.7866391841692	-122.42944992335698	(37.7866391841692, -122.429449923357)
2052	2052	143142	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2140 LOMBARD ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			16	Width 0ft		6002105.6639	2119495.6188	37.7998491537216	-122.43683987606899	(37.7998491537216, -122.436839876069)
2132	2132	13212	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	2190 Lombard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			70	3X3		6001925.0681	2119471.9545	37.7997739121356	-122.437463108341	(37.7997739121356, -122.437463108341)
2799	2799	142504	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	610 Vallejo St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		09/29/1999 12:00:00 AM	12	Width 0ft		6010596.4955	2118942.3174	37.7988088315184	-122.407419256939	(37.7988088315184, -122.407419256939)
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)
3343	3343	140423	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1499 TURK ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Police Dept 18			13	Width 0ft		6002956.7531	2112350.9171	37.7802799627924	-122.43338395792802	(37.7802799627924, -122.433383957928)
3990	3990	21628	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1615 Sutter St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/29/1994 12:00:00 AM	6	4X4		6004654.6857	2114664.3643	37.786728295749896	-122.427674898563	(37.7867282957499, -122.427674898563)
4021	4021	4643	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	515 Columbus Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			65	3x3		6010000.9813	2119283.7816	37.7997130589262	-122.409504050861	(37.7997130589262, -122.409504050861)
4206	4206	13097	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1475 Lombard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6005336.846	2119866.4127	37.801050369840205	-122.42568517574	(37.8010503698402, -122.42568517574)
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)
4255	4255	4659	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	600X Columbus Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Rec/Park 3			90	5X5		6009780.1976	2119571.0943	37.800489575353104	-122.410288343699	(37.8004895753531, -122.410288343699)
4440	4440	28068	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	3445 Geary Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	3X3		5996452.8473	2112841.7002	37.78125639187	-122.455919329089	(37.78125639187, -122.455919329089)
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)
5501	5501	99227	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1111 Columbus Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	2x2		6008003.9616	2121103.5041	37.8045974602939	-122.416543465428	(37.8045974602939, -122.416543465428)
5835	5835	7158	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	719 Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6003514.1332	2110837.5014	37.7761561050706	-122.431347659332	(37.7761561050706, -122.431347659332)
5852	5852	4724	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1050 Columbus Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			30	4x4		6008259.9153	2120954.1415	37.8042017393393	-122.41564712883101	(37.8042017393393, -122.415647128831)
5884	5884	17676	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1004 Pierce St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6002427.6935	2112026.5749	37.779359371412795	-122.43519101157301	(37.7793593714128, -122.435191011573)
6161	6161	7251	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1701 Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6003028.1584	2114287.7355	37.785602029314205	-122.43327536926	(37.7856020293142, -122.43327536926)
6232	6232	13105	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1530 Lombard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/26/1993 12:00:00 AM	90	3X3		6004999.0901	2119899.25	37.8011214413621	-122.426856296775	(37.8011214413621, -122.426856296775)
6400	6400	106204	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1600X Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	5x5		6003122.9413	2113972.2468	37.7847411535968	-122.432924900964	(37.7847411535968, -122.432924900964)
6429	6429	7178	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	837 Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	6x6		6003458.7438	2111235.1971	37.777244939721704	-122.431567664925	(37.7772449397217, -122.431567664925)
6530	6530	8195	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1301 Fulton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		6001448.9604	2111096.3198	37.776749499067705	-122.438510182933	(37.7767494990677, -122.438510182933)
6743	6743	7207	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	940 Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	4X4		6003456.4877	2111615.9101	37.778290155247205	-122.431602656487	(37.7782901552472, -122.431602656487)
6870	6870	9637	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1460 Golden Gate Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	3X3		6002620.3308	2112001.9911	37.7793028076481	-122.43452284095801	(37.7793028076481, -122.434522840958)
6933	6933	18012	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2707 Pine St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		6000934.1764	2114843.3331	37.787008543855	-122.44055978525299	(37.787008543855, -122.440559785253)
6963	6963	13021	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	423 Lombard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			15	3X3		6010315.0722	2120598.0088	37.803339197434	-122.408509932207	(37.803339197434, -122.408509932207)
7032	7032	6224	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1220 Ellis St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X4		6005090.9413	2113387.3731	37.7832466624445	-122.42607461530899	(37.7832466624445, -122.426074615309)
7121	7121	18036	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2807 Pine St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6000406.6253	2114762.207	37.7867557380075	-122.44237916186701	(37.7867557380075, -122.442379161867)
7489	7489	22786	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1885 Turk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6001038.3513	2112073.2703	37.7794085922078	-122.440000666135	(37.7794085922078, -122.440000666135)
7524	7524	21650	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1688 Sutter St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3X3		6004543.8112	2114703.7787	37.7868302455522	-122.428061307883	(37.7868302455522, -122.428061307883)
7541	7541	7214	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	950 Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	4X4		6003450.6988	2111662.2209	37.778416985075104	-122.431625989594	(37.7784169850751, -122.431625989594)
7620	7620	13281	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	2524 Lombard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/26/1993 12:00:00 AM	40	3x3		6000224.9781	2119238.0771	37.7990349463185	-122.44332922273199	(37.7990349463185, -122.443329222732)
7652	7652	13207	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	2199 Lombard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/26/1993 12:00:00 AM	12	3X3		6001946.8642	2119395.357	37.799564834652706	-122.43738219799299	(37.7995648346527, -122.437382197993)
7692	7692	4721	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1040 Columbus Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	5x5		6008335.3567	2120887.0824	37.8040218523597	-122.415381307054	(37.8040218523597, -122.415381307054)
8030	8030	10637	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	843 Hayes St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		08/02/1990 12:00:00 AM	12	3X3		6003821.4079	2110734.0055	37.7758893402664	-122.43027732793101	(37.7758893402664, -122.430277327931)
8072	8072	7258	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1714 Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	4X4		6003084.9119	2114241.8074	37.785479141806604	-122.433075736157	(37.7854791418066, -122.433075736157)
8120	8120	17670	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1015X Pierce St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/15/1995 12:00:00 AM	12	3X3		6002378.1109	2112076.6861	37.7794941484605	-122.435366123882	(37.7794941484605, -122.435366123882)
8138	8138	13110	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1599 Lombard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/22/1994 12:00:00 AM	16	3x3		6004846.6308	2119801.5197	37.800844477708004	-122.427376906198	(37.800844477708, -122.427376906198)
8257	8257	13205	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	2150 Lombard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			70	3X3		6002007.2704	2119484.4094	37.799812783065704	-122.43717955071301	(37.7998127830657, -122.437179550713)
8290	8290	21710	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1900 Sutter St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	4x4		6003404.4442	2114543.7174	37.7863262303196	-122.431991815976	(37.7863262303196, -122.431991815976)
8359	8359	7168	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	761 Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6003490.0388	2111001.7309	37.7766056731066	-122.431442734929	(37.7766056731066, -122.431442734929)
8449	8449	7686	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	521 Francisco St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3X3		6008772.4139	2121077.9257	37.8045704150203	-122.413882343906	(37.8045704150203, -122.413882343906)
8583	8583	21586	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1500 Sutter St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	2X2		6005346.0976	2114810.866	37.7871696385608	-122.425293204645	(37.7871696385608, -122.425293204645)
8594	8594	13185	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2055X Lombard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6002536.6029	2119475.0682	37.7998172097056	-122.435347197327	(37.7998172097056, -122.435347197327)
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)
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)
14599	14599	7391	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1035X Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/28/1992 12:00:00 AM	30	3x3		6010784.4697	2111320.9947	37.77789301527721	-122.40623154915001	(37.7778930152772, -122.40623154915)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
22559	22559	9075	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	5612 Geary Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		5989561.9341	2112697.6008	37.7804628284507	-122.47974767842399	(37.7804628284507, -122.479747678424)
23229	23229	28073	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1075 Columbus Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6008262.9463	2120869.8064	37.803970346765496	-122.415630664984	(37.8039703467655, -122.415630664984)
23704	23704	138749	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1528 BAKER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6000156.6321	2114235.0077	37.785293933510104	-122.443206197892	(37.7852939335101, -122.443206197892)
23797	23797	143335	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1820 UNION ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6004232.6567	2118749.9753	37.7979224644928	-122.42942648353399	(37.7979224644928, -122.429426483534)
24233	24233	140776	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	77 TERRA VISTA AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		6000147.5673	2112813.1036	37.7813892348129	-122.443135402805	(37.7813892348129, -122.443135402805)
24338	24338	142592	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	365 COLUMBUS AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		6008300.8769	2120835.2204	37.803877514381	-122.415496953155	(37.803877514381, -122.415496953155)
26247	26247	140689	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1120 FILLMORE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6003360.489	2112281.5531	37.780112403361294	-122.431982295298	(37.7801124033613, -122.431982295298)
26431	26431	143534	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2095 UNION ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6003009.3374	2118534.798	37.797262307390795	-122.433644124881	(37.7972623073908, -122.433644124881)
26479	26479	138715	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2900 BUSH ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		5999573.0166	2114358.1558	37.785598770554294	-122.445234179741	(37.7855987705543, -122.445234179741)
29172	29172	138854	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	519 Ivy St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6004884.6976	2111071.1642	37.776875264769295	-122.42662314727501	(37.7768752647693, -122.426623147275)
29669	29669	137591	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1235 Steiner St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		6002786.4345	2112612.3356	37.7809880882364	-122.433991859956	(37.7809880882364, -122.433991859956)
30263	30263	143538	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2145 UNION ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6002756.9739	2118500.147	37.797152842338704	-122.434514886579	(37.7971528423387, -122.434514886579)
30821	30821	143043	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	443 LOMBARD ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6010277.7096	2120592.1376	37.8033209840901	-122.40863881299299	(37.8033209840901, -122.408638812993)
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)
33681	33681	138719	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1715 BRODERICK ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6000532.2571	2114677.58	37.7865305339642	-122.44193843038099	(37.7865305339642, -122.441938430381)
34762	34762	139445	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	508 OCTAVIA ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6005470.16	2111049.3311	37.7768483978097	-122.424596299715	(37.7768483978097, -122.424596299715)
34879	34879	143218	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	251 FRANCISCO ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6010143.2987	2121269.7317	37.8051739606787	-122.409151790672	(37.8051739606787, -122.409151790672)
34909	34909	143246	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	647 CHESTNUT ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6008746.811000001	2120723.5878	37.8035960540957	-122.413945863948	(37.8035960540957, -122.413945863948)
34969	34969	140050	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	501 FULTON ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6005278.6254	2111629.2967	37.778430022863496	-122.425300156764	(37.7784300228635, -122.425300156764)

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