Street_Tree_List

Data source: data.sfgov.org

846 rows where PlotSize = "Width 0ft" and qSpecies = 59 sorted by qAddress

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, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
150055	150055	141767	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1 Hollis St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6003884.399	2113511.8848	37.783520274802896	-122.43025765421301	(37.7835202748029, -122.430257654213)
182825	182825	142620	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1 Scotland St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6009140.6951	2120065.1504	37.8018102626301	-122.412536232083	(37.8018102626301, -122.412536232083)
51707	51707	138041	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1 Wilmot St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6003396.2249	2115029.767	37.7876603335628	-122.43205497415701	(37.7876603335628, -122.432054974157)
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)
1462	1462	247381	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1001 Oak St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	Width 0ft		6002208.0	2109818.0	37.7732826991746	-122.43579295981199	(37.7732826991746, -122.435792959812)
1466	1466	247380	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1001 Oak St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			13	Width 0ft		6002208.0	2109818.0	37.7732826991746	-122.43579295981199	(37.7732826991746, -122.435792959812)
1468	1468	247377	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1001 Oak St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			15	Width 0ft		6002208.0	2109818.0	37.7732826991746	-122.43579295981199	(37.7732826991746, -122.435792959812)
35602	35602	217547	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	102 Broad St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		5995842.2441	2088093.8487	37.713269899907104	-122.45624180431801	(37.7132698999071, -122.456241804318)
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)
48348	48348	140506	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1020 FILLMORE ST	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6003442.3352	2111811.0008	37.77882502362021	-122.43166554740299	(37.7788250236202, -122.431665547403)
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)
153736	153736	140503	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1020 FILLMORE ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 0ft		6003449.1719	2111783.654	37.7787503236279	-122.43163994364099	(37.7787503236279, -122.431639943641)
168873	168873	140508	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1020 FILLMORE ST	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6003419.5462	2111864.9347	37.778971820925996	-122.43174823532401	(37.778971820926, -122.431748235324)
183645	183645	140505	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1020 FILLMORE ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6003444.6141	2111801.8852	37.7788001236235	-122.43165701281	(37.7788001236235, -122.43165701281)
41284	41284	140538	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1025 FILLMORE ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6003370.5162	2111893.2524	37.7790467948997	-122.43191987222	(37.7790467948997, -122.43191987222)
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)
147281	147281	140543	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1025 FILLMORE ST	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6003386.4685	2111785.1308	37.7787508242216	-122.43185696454799	(37.7787508242216, -122.431856964548)
160247	160247	140539	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1025 FILLMORE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6003373.4703	2111871.9826	37.7789885607925	-122.43190813363	(37.7789885607925, -122.43190813363)
161539	161539	140542	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1025 FILLMORE ST	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6003382.3327	2111808.7639	37.778815480381205	-122.43187295981501	(37.7788154803812, -122.431872959815)
176807	176807	140541	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1025 FILLMORE ST	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6003379.3786	2111825.8979	37.7788623586164	-122.43188440296001	(37.7788623586164, -122.43188440296)
184755	184755	140540	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1025 FILLMORE ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6003378.1969	2111847.7586	37.7789223156672	-122.43189005228001	(37.7789223156672, -122.43189005228)
54338	54338	140510	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1040 FILLMORE ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6003410.4306	2111922.6668	37.7791298221794	-122.43178389299601	(37.7791298221794, -122.431783892996)
130767	130767	140511	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1040 FILLMORE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6003403.594	2111971.2833	37.7792629234397	-122.431811015775	(37.7792629234397, -122.431811015775)
159948	159948	247386	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1045 Oak St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6001982.645	2109781.5209999997	37.773169733383	-122.436569880602	(37.773169733383, -122.436569880602)
56022	56022	140512	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1050 Fillmore St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		6003399.7958	2111999.3898	37.779339881579205	-122.431826162709	(37.7793398815792, -122.431826162709)
182858	182858	247387	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1053 Oak St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6001955.5092	2109778.1291	37.7731588780046	-122.43666350389	(37.7731588780046, -122.43666350389)
28588	28588	143227	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	106 PFEIFFER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6010308.3267	2121146.7978	37.8048456584244	-122.408572011197	(37.8048456584244, -122.408572011197)
183602	183602	140513	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1060 Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6003397.5169	2112023.6980000003	37.779406496655604	-122.431835782497	(37.7794064966556, -122.431835782497)
188842	188842	140546	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1060 Steiner St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6002924.6148	2111925.6484	37.779110458039604	-122.43346473978701	(37.7791104580396, -122.433464739787)
136427	136427	140548	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1080 Steiner St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6002919.3909	2111977.3656	37.7792521641585	-122.433486508226	(37.7792521641585, -122.433486508226)
175898	175898	199982	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1081 Quesada Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6018036.5838	2092513.2332	37.7266537566215	-122.379836574534	(37.7266537566215, -122.379836574534)
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)
134568	134568	140535	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1099 FILLMORE ST	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6003363.1308	2111944.3591	37.7791867024877	-122.4319490716	(37.7791867024877, -122.4319490716)
163747	163747	140534	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1099 FILLMORE ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6003360.1767	2111967.4014	37.7792498034321	-122.431960936856	(37.7792498034321, -122.431960936856)
175434	175434	140536	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1099 FILLMORE ST	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6003366.6758	2111915.9993	37.779109034509204	-122.43193478240102	(37.7791090345092, -122.431934782401)
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)
155154	155154	137517	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	11 Seymour St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6001642.6038	2112140.9289	37.779628745329	-122.437915153636	(37.779628745329, -122.437915153636)
164772	164772	137520	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	11 Seymour St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6001651.2928	2112086.3813	37.779479465517504	-122.437881186624	(37.7794794655175, -122.437881186624)
174213	174213	137519	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	11 Seymour St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6001649.8446	2112101.8284	37.7795217969961	-122.437887303264	(37.7795217969961, -122.437887303264)
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)
146337	146337	247502	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1105 Fell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6002054.0619	2110138.0012	37.7741525973198	-122.436348358239	(37.7741525973198, -122.436348358239)
173948	173948	140405	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1111 Webster St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6003761.2248	2112532.0496	37.7808229146257	-122.430613848284	(37.7808229146257, -122.430613848284)
181633	181633	140404	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1113 Webster St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6003757.2396	2112557.5551	37.7808927206056	-122.430629455565	(37.7808927206056, -122.430629455565)
186757	186757	140403	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1119 WEBSTER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6003754.0514	2112594.2194	37.7809932110185	-122.43064310216101	(37.7809932110185, -122.430643102161)
113892	113892	142943	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	112 PFEIFFER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6010269.581	2121139.6226	37.8048237870919	-122.408705588917	(37.8048237870919, -122.408705588917)
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)
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)
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)
45184	45184	140688	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1120 FILLMORE ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6003366.7058	2112262.0737	37.780059270229295	-122.431959397228	(37.7800592702293, -122.431959397228)
148925	148925	140691	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1120 FILLMORE ST	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6003358.8311	2112311.3938	37.780194244485294	-122.43199016217899	(37.7801942444853, -122.431990162179)
150798	150798	140692	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1120 FILLMORE ST	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6003358.0022	2112322.1697	37.780223785424496	-122.43199379942301	(37.7802237854245, -122.431993799423)
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)
131547	131547	140420	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1120 STEINER ST	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6002874.2144	2112292.0633	37.7801136820125	-122.43366528968599	(37.7801136820125, -122.433665289686)
150035	150035	140421	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1120 STEINER ST	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6002869.1903	2112320.0547	37.780190254306795	-122.43368467143	(37.7801902543068, -122.43368467143)
65375	65375	200196	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1124 Fitzgerald Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 0ft		6015063.1024	2090263.455	37.720311838731	-122.38995879887301	(37.720311838731, -122.389958798873)
284	284	137592	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1125 Steiner St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/16/1990 12:00:00 AM	18	Width 0ft		6002857.6038	2112094.871	37.7795712988398	-122.433708655697	(37.7795712988398, -122.433708655697)
74307	74307	137574	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1135 STEINER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		6002846.9387	2112168.7066	37.7797734277366	-122.43375082949801	(37.7797734277366, -122.433750829498)
30887	30887	140482	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1137 WEBSTER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6003743.6898	2112670.736	37.781202719512	-122.430684409839	(37.781202719512, -122.430684409839)
183176	183176	142938	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1160 BROADWAY	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6010744.0272	2118552.2837	37.797746150342604	-122.406881242638	(37.7977461503426, -122.406881242638)
171470	171470	140525	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1190 McAllister St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	Width 0ft		6003468.9224	2111772.2595	37.7787201566355	-122.43157080528799	(37.7787201566355, -122.431570805288)
74755	74755	199769	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1197 Thomas Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6016909.41	2092306.5247	37.726023933628895	-122.383718829233	(37.7260239336289, -122.383718829233)
178515	178515	142934	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1201 KEARNY ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6011088.1877	2119032.3	37.7990834099948	-122.40572417480699	(37.7990834099948, -122.405724174807)
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)
43462	43462	142119	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1208 Grove St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		6002005.9378	2110874.6586	37.776172539897296	-122.43656756597	(37.7761725398973, -122.43656756597)
52482	52482	245025	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1215 Oak St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6001121.5198	2109662.8083	37.772794805840704	-122.43954010678499	(37.7727948058407, -122.439540106785)
55308	55308	139484	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1216 FULTON ST	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 0ft		6001778.449	2111192.2794	37.7770317168845	-122.437377258879	(37.7770317168845, -122.437377258879)
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)
76841	76841	140576	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1219 McAllister St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6003302.4616	2111703.7722	37.7785226712194	-122.432141765433	(37.7785226712194, -122.432141765433)
67205	67205	142124	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1221 FULTON ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6001940.0404	2111161.7753	37.776957145428	-122.43681608077499	(37.776957145428, -122.436816080775)
130015	130015	142107	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1223 FULTON ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6001862.2998	2111151.4099	37.776924266063105	-122.437084266624	(37.7769242660631, -122.437084266624)
166925	166925	142506	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1223 KEARNY ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6011074.9884	2119120.527	37.7993249217375	-122.405776067035	(37.7993249217375, -122.405776067035)
74499	74499	199975	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1233 Shafter Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		6016858.7319	2092693.7716	37.7270844364031	-122.38392097441299	(37.7270844364031, -122.383920974413)
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)
172121	172121	142923	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1249 KEARNY ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		6011057.7598	2119245.0173	37.7996657782982	-122.40584445833099	(37.7996657782982, -122.405844458331)
58145	58145	183272	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1251 40th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		5983645.262999999	2106639.9345	37.7634847239936	-122.49976803825199	(37.7634847239936, -122.499768038252)
187140	187140	183273	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1251 40th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		5983646.3542	2106625.2038	37.7634443416971	-122.49976317535801	(37.7634443416971, -122.499763175358)
167397	167397	142113	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1270 GROVE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		6001736.8029	2110836.8034	37.7760533014164	-122.437495863249	(37.7760533014164, -122.437495863249)
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)
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)
68791	68791	141793	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1280 WEBSTER ST	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6003797.3488	2112989.7381	37.7820816595285	-122.430521544957	(37.7820816595285, -122.430521544957)
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)
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)
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)
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)
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)
46963	46963	139407	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1311 BAKER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6000207.9303	2113507.6319999998	37.7832996726996	-122.44297646838301	(37.7832996726996, -122.442976468383)
148225	148225	137640	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1319 McAllister St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6002813.9379	2111632.5778	37.778299479553105	-122.433826662886	(37.7782994795531, -122.433826662886)
170504	170504	245138	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1320 Page St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6000087.6508	2109218.0834	37.7715148081993	-122.443084420904	(37.7715148081993, -122.443084420904)
72332	72332	182039	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1323 23rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		5988935.747	2106319.8798	37.7629149697028	-122.481446720354	(37.7629149697028, -122.481446720354)
172304	172304	248308	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1327 Waller St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		5999347.2972	2108376.4732	37.76916171869029	-122.445584804207	(37.7691617186903, -122.445584804207)
71407	71407	140492	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1330 TURK ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6003634.4941	2112489.009	37.7806975555682	-122.431049198514	(37.7806975555682, -122.431049198514)
168121	168121	248309	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1333 Waller St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		5999321.5567	2108373.142	37.769151102475	-122.445673599246	(37.769151102475, -122.445673599246)
38684	38684	137659	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1334 MCALLISTER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6002765.4317	2111672.0138	37.778405008308795	-122.43399728327101	(37.7784050083088, -122.433997283271)
146640	146640	142920	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1339 KEARNY ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6011019.5196	2119515.0732	37.800405147287	-122.405995819069	(37.800405147287, -122.405995819069)
175857	175857	140293	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	135 CLAYTON ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		5998254.8738	2110151.3644	37.773972687525	-122.449491324786	(37.773972687525, -122.449491324786)
169792	169792	246387	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1356 Waller St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		5999191.1888	2108399.0339	37.7692147510646	-122.446126395439	(37.7692147510646, -122.446126395439)
39156	39156	248312	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1375 Waller St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5999157.272000001	2108349.6728	37.769077281031606	-122.44624016016199	(37.7690772810316, -122.446240160162)
156171	156171	246039	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1378 Waller St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		5999138.4966	2108392.6745	37.7691942805388	-122.446308196721	(37.7691942805388, -122.446308196721)
183831	183831	246038	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1378 Waller St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		5999156.0607	2108395.7028	37.7692035985916	-122.446247661551	(37.7692035985916, -122.446247661551)
151317	151317	245078	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1387 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6000393.4407	2109556.4466	37.7724612989944	-122.442050971779	(37.7724612989944, -122.442050971779)

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