Street_Tree_List

Data source: data.sfgov.org

300 rows where SiteOrder = 2 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, PlantDate, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker ▼	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
30976	30976	31653	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1708 Laguna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/05/1995 12:00:00 AM	8		Permit Number 35163	6004466.8826	2114789.0769	37.787060100362794	-122.428333544653	(37.7870601003628, -122.428333544653)
31733	31733	33694	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	401 Ivy St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/03/1996 12:00:00 AM	12		Permit Number 37765	6005381.091	2111139.6901	37.777091471020704	-122.424910846803	(37.7770914710207, -122.424910846803)
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)
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)
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)
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)
36773	36773	140504	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1020 FILLMORE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6003445.3738	2111793.5292	37.7787772231874	-122.431653787974	(37.7787772231874, -122.431653787974)
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)
38851	38851	142632	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	241 BAY ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6009699.071	2121543.9755	37.805902069362794	-122.410708480373	(37.8059020693628, -122.410708480373)
39408	39408	97935	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2133 Stockton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	3x3		6009806.2516	2121504.2981	37.8057991338594	-122.41033476040501	(37.8057991338594, -122.410334760405)
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)
40051	40051	143180	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	37 MIDWAY ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6010061.0151	2121485.1789	37.8057609150954	-122.40945175887501	(37.8057609150954, -122.409451758875)
40269	40269	138110	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1600 SUTTER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6004839.6037	2114746.6136	37.786964589964796	-122.42704098629801	(37.7869645899648, -122.427040986298)
40459	40459	138740	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	700 PRESIDIO AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5999265.5073	2114223.1094	37.7852104108131	-122.44628835045299	(37.7852104108131, -122.446288350453)
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)
41314	41314	142953	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	19 PFEIFFER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6010052.6528	2121119.7714	37.804757128417	-122.409454893216	(37.804757128417, -122.409454893216)
41357	41357	137799	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1900 Laguna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6004356.41	2115593.3639	37.789262218427	-122.42877311351002	(37.789262218427, -122.42877311351)
41838	41838	108009	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	419X Ivy St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8			6005268.3816	2111120.1092	37.7770313396992	-122.42529935055799	(37.7770313396992, -122.425299350558)
42709	42709	143520	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2174 UNION ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6002609.217	2118527.6063	37.7972198497902	-122.435028126326	(37.7972198497902, -122.435028126326)
43497	43497	106406	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	650 Presidio Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	5x6		5999248.4097	2114351.2177	37.785561186294295	-122.446356721815	(37.7855611862943, -122.446356721815)
44534	44534	138691	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2844 BUSH ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		5999863.2879	2114398.2903	37.7857255339984	-122.44423281375099	(37.7857255339984, -122.444232813751)
44685	44685	142988	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1861 Grant Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6010372.0828	2120911.5359	37.804203257928	-122.408334771369	(37.804203257928, -122.408334771369)
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)
45497	45497	72023	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	655 Stockton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/04/1989 12:00:00 AM	12			6010509.9754	2116460.1743	37.7919886256319	-122.40754355100599	(37.7919886256319, -122.407543551006)
45943	45943	138610	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1716 BAKER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6000062.7737	2114910.7976	37.7871441247685	-122.443579481437	(37.7871441247685, -122.443579481437)
47321	47321	142489	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	651 COLUMBUS AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6009636.3672	2119608.7257	37.8005848384211	-122.410788716085	(37.8005848384211, -122.410788716085)
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)
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)
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)
48871	48871	142566	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2125 POWELL ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6009390.752	2120983.7745	37.804346606020495	-122.41173586211	(37.8043466060205, -122.41173586211)
49156	49156	140591	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	950 STEINER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6002971.355	2111585.6946	37.778179681485206	-122.433278748514	(37.7781796814852, -122.433278748514)
49275	49275	200985	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	160 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6015097.3421	2115526.2135	37.789679892382495	-122.39160577131099	(37.7896798923825, -122.391605771311)
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)
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)
50833	50833	143130	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2770 LOMBARD ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		5999261.9713	2119102.3163	37.7986072215669	-122.44665176347	(37.7986072215669, -122.44665176347)
50947	50947	140439	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1100 FILLMORE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6003462.4449	2112120.7446	37.77967664282979	-122.431618099739	(37.7796766428298, -122.431618099739)
51172	51172	141777	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	7 Hollis St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6003915.306	2113275.4592	37.7828728597693	-122.43013385606702	(37.7828728597693, -122.430133856067)
51773	51773	138588	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1732 BAKER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6000056.8342	2114968.7073	37.7873027909955	-122.443604192363	(37.7873027909955, -122.443604192363)
52503	52503	142516	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1205 KEARNY ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6011083.7416	2119059.5323	37.7991579346332	-122.40574147910499	(37.7991579346332, -122.405741479105)
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)
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)
54336	54336	143505	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	11 Gerke Aly	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6010554.2854	2120185.3922	37.802219647583	-122.40765301215599	(37.802219647583, -122.407653012156)
54416	54416	143548	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2237 UNION ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6002268.9185	2118432.4796	37.7969393283412	-122.4361988317	(37.7969393283412, -122.4361988317)
55013	55013	140533	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1099 FILLMORE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6003358.5145	2111988.9607	37.7793089056656	-122.43196822698799	(37.7793089056656, -122.431968226988)
55994	55994	140049	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	651 Octavia St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6005353.1353	2111583.6293	37.778308840554	-122.42503914866998	(37.778308840554, -122.42503914867)
56306	56306	138131	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2135 Bush St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6003060.8632	2114789.3963	37.7869813180356	-122.433198077825	(37.7869813180356, -122.433198077825)
56313	56313	138373	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1801 Steiner St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6002557.3186	2114515.2232	37.786199930917796	-122.43492061108101	(37.7861999309178, -122.434920611081)
56339	56339	143506	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1944 UNION ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6003692.4061	2118683.7427	37.797710004942495	-122.43129117281099	(37.7977100049425, -122.431291172811)
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)
56971	56971	138011	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1401 Gough St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6005427.9087	2114512.7674	37.786355755539105	-122.424988938346	(37.7863557555391, -122.424988938346)
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)
57517	57517	142945	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	152 PFEIFFER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6010109.3364	2121119.0539	37.804758334186296	-122.40925868229799	(37.8047583341863, -122.409258682298)
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)
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)
58547	58547	143344	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1806 UNION ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6004302.136	2118760.3647	37.797954924547504	-122.429186806628	(37.7979549245475, -122.429186806628)
59398	59398	141694	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	392 EWING TER	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		5998733.647999999	2112339.0414	37.780006861514	-122.44799271326	(37.780006861514, -122.44799271326)
59550	59550	110908	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	633 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13			6013338.0101	2113761.7403	37.784737246892796	-122.39756912252199	(37.7847372468928, -122.397569122522)

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