Street_Tree_List

Data source: data.sfgov.org

1,136 rows where qCaretaker = 1 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, PlotSize

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)
147652	147652	64012	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	10 Loyola Ter	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/08/1987 12:00:00 AM	10		Permit Number 24766	5998456.7381	2110792.4322	37.7757444404433	-122.44883923078999	(37.7757444404433, -122.44883923079)
22132	22132	28299	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	100 Broad St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	3X3		5995861.9776	2088092.909	37.713268452474104	-122.45617353106701	(37.7132684524741, -122.456173531067)
6737	6737	17678	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1016 Pierce St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3X3		6002420.6118	2112080.0342	37.7795057550774	-122.435219334932	(37.7795057550774, -122.435219334932)
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)
5730	5730	4720	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1040 Columbus Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	5x5		6008353.7979	2120870.8765	37.8039783914932	-122.415316341899	(37.8039783914932, -122.415316341899)
6233	6233	4722	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1040 Columbus Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			22	4x4		6008317.4743	2120903.2884	37.804065344872704	-122.415444338519	(37.8040653448727, -122.415444338519)
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)
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)
1873	1873	20151	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1043 Steiner St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/13/2016 12:00:00 AM	3	3x3	Permit Number 778996	6002888.3687	2111863.5194	37.7789378108444	-122.433585688352	(37.7789378108444, -122.433585688352)
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)
5637	5637	4723	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1050 Columbus Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			36	5x5		6008295.1213	2120922.8472	37.804117792011795	-122.41552307845801	(37.8041177920118, -122.415523078458)
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)
7263	7263	4725	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1050 Columbus Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			30	4x4		6008238.1211	2120976.4945	37.8042618899237	-122.415724133248	(37.8042618899237, -122.415724133248)
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)
63452	63452	54834	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	109 Ashbury St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/09/1972 12:00:00 AM	17		Permit Number 10688	5998714.6082	2110323.5588	37.7744717777818	-122.447913432558	(37.7744717777818, -122.447913432558)
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)
24888	24888	45611	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1100 Fillmore St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/06/2001 12:00:00 AM	16		Permit Number 44335	6003449.1823	2112117.4289	37.7796667869975	-122.43166374401001	(37.7796667869975, -122.43166374401)
131817	131817	45603	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1100 Fillmore St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/06/2001 12:00:00 AM	14		Permit Number 44335	6003434.2619	2112117.4289	37.779665941263104	-122.43171536011101	(37.7796659412631, -122.431715360111)
19595	19595	7021	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1105 Fell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3X3		6002080.4157	2110140.9294	37.7741621348105	-122.43625740553301	(37.7741621348105, -122.436257405533)
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)
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)
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)
5526	5526	99210	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1111 Columbus Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3x3		6007993.4855	2121112.3432	37.8046211410646	-122.416580345595	(37.8046211410646, -122.416580345595)
6213	6213	99229	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1111 Columbus Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	2x2		6008022.9494	2121084.5162	37.804546392141496	-122.416476410342	(37.8045463921415, -122.416476410342)
6739	6739	99228	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1111 Columbus Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	2x2		6008013.4555	2121093.6827	37.8045710271276	-122.416509914664	(37.8045710271276, -122.416509914664)
8148	8148	99230	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1111 Columbus Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	2x2		6008035.3898	2121073.3853	37.8045165290969	-122.416432570152	(37.8045165290969, -122.416432570152)
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)
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)
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)
26086	26086	59151	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	112 Pfeiffer St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/02/1980 12:00:00 AM	13		Permit Number 18460	6010290.1497	2121142.971	37.8048341329685	-122.408634644798	(37.8048341329685, -122.408634644798)
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)
18114	18114	27413	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1125 Fell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3X3		6002017.7522	2110131.5591	37.774132845741704	-122.436473498525	(37.7741328457417, -122.436473498525)
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)
23414	23414	64062	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1205 Kearny St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/07/1995 12:00:00 AM	7		Permit Number 29268	6011082.0743	2119072.3147	37.799192938755	-122.405748149412	(37.799192938755, -122.405748149412)
18281	18281	17048	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1205 Oak St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3X3		6001170.7121	2109662.4759	37.7727966927365	-122.43936992159401	(37.7727966927365, -122.439369921594)
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)
156324	156324	77283	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1210 Grove St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/04/1982 12:00:00 AM	16			6001986.2323	2110871.5472	37.7761628769629	-122.436635509753	(37.7761628769629, -122.436635509753)
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)
53528	53528	65955	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1234 Grove St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/21/1990 12:00:00 AM	13		Permit Number 28976	6001892.8907	2110857.546	37.7761191282962	-122.436957400422	(37.7761191282962, -122.436957400422)
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)
157150	157150	43881	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1245 47th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/03/2000 12:00:00 AM	3		Permit Number 43494	5981473.1113	2106617.2091	37.7632946239394	-122.507278997702	(37.7632946239394, -122.507278997702)
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)

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