Street_Tree_List

Data source: data.sfgov.org

300 rows where SiteOrder = 2 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, 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
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
177466	177466	32291	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1400 Egbert Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/15/1996 12:00:00 AM	7		Permit Number 36872	6014236.59	2091225.7906	37.722908348540294	-122.39288309530001	(37.7229083485403, -122.3928830953)
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)
171052	171052	142473	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1429 Kearny St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		6010981.054	2119812.8124	37.8012205149436	-122.40614991427499	(37.8012205149436, -122.406149914275)
173380	173380	140446	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1435 EDDY ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6003632.9	2112791.8873	37.781529093472	-122.43107633714399	(37.781529093472, -122.431076337144)
92442	92442	37059	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1450 Sanchez St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/01/1998 12:00:00 AM		3x3	Permit Number 39663	6003906.83973736	2099821.31146391	37.745930528166596	-122.429203495744	(37.7459305281666, -122.429203495744)
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)
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)
156591	156591	141780	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1480 ELLIS ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6003842.3971	2113219.4567	37.7827149612606	-122.430382093414	(37.7827149612606, -122.430382093414)
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)
173043	173043	248359	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1485 Waller St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		5998647.9135	2108278.8108	37.768853609287206	-122.44799689076099	(37.7688536092872, -122.447996890761)
189100	189100	246130	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1486 Waller St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		5998621.8702	2108319.087	37.768962708792	-122.448089872703	(37.768962708792, -122.448089872703)
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)
168437	168437	244244	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	150 Page St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6005791.8047	2110016.6014	37.7740309317752	-122.423410197258	(37.7740309317752, -122.423410197258)
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)
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)
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)
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)
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)
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)
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)
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)
177206	177206	246136	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1556 Waller St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		5998150.3653	2108253.3731	37.768755310607	-122.449716033907	(37.768755310607, -122.449716033907)
167539	167539	248335	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1559 Waller St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		5998127.3503	2108207.3431	37.768627607196	-122.449792323102	(37.768627607196, -122.449792323102)
153908	153908	142950	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	156 Pfeiffer St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6010083.0275	2121115.7055	37.8047476663275	-122.409349490891	(37.8047476663275, -122.409349490891)
72403	72403	247348	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1563 Page St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		5999102.728999999	2109036.7578	37.7709607271706	-122.44647825803001	(37.7709607271706, -122.44647825803)
61042	61042	38609	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1570 Revere Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/15/2002 12:00:00 AM	6		Permit Number 45423	6015273.2073	2094293.4811	37.7313891398709	-122.38951383063	(37.7313891398709, -122.38951383063)
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)
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)
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)
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)
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)
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)
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)
176758	176758	138717	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1607 Lyon St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		5999600.5215	2114397.0591	37.7857071588413	-122.44514181900601	(37.7857071588413, -122.445141819006)
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)
165399	165399	32294	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1616 16th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/19/1996 12:00:00 AM	12		Permit Number 36875	6011626.7926	2107023.9767	37.7661414653506	-122.403015326989	(37.7661414653506, -122.403015326989)
159801	159801	247268	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1621 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		5999221.2905	2109393.9379	37.77194822419221	-122.44609384766501	(37.7719482241922, -122.446093847665)
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)
123931	123931	143348	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1651 UNION ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		6005062.5126	2118820.1040000003	37.7981619685874	-122.42655994117901	(37.7981619685874, -122.426559941179)
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)
169358	169358	138119	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1700 SUTTER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	6x7		6004323.0329	2114669.3641	37.786723258345	-122.42882269508002	(37.786723258345, -122.42882269508)
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)
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)
177880	177880	248404	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1713 Waller St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		5997468.9999	2108115.1317	37.768336729240296	-122.452062838629	(37.7683367292403, -122.452062838629)
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)
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)
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)
153054	153054	246152	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1720 Waller St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		5997446.2877	2108155.2565	37.7684456006596	-122.45214429305	(37.7684456006596, -122.45214429305)
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)
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)
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)
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)
183195	183195	138472	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1749 FILLMORE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6003013.5126	2114389.5238	37.785880683353	-122.433333315539	(37.785880683353, -122.433333315539)
68186	68186	143211	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	175 FRANCISCO ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6010376.5969	2121289.0448	37.8052400566335	-122.408345793229	(37.8052400566335, -122.408345793229)
184932	184932	142820	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1754 POLK ST	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			1	Width 0ft		6006598.3556	2116937.7026	37.793080071640894	-122.42111173056101	(37.7930800716409, -122.421111730561)
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)
177709	177709	142959	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	178 Pfeiffer St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6009960.8111	2121097.7677	37.8046915653635	-122.409771168052	(37.8046915653635, -122.409771168052)
72708	72708	138006	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1781 SUTTER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6004101.4738	2114584.9413	37.786478912061	-122.429583213622	(37.786478912061, -122.429583213622)
176578	176578	138502	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1799 Steiner St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6002532.1465	2114322.3247	37.7856688514425	-122.43499389896499	(37.7856688514425, -122.434993898965)
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)
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)
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)
168674	168674	138419	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1819 STEINER ST	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			14	Width 0ft		6002518.3631	2114471.7689	37.7860784045808	-122.435052277699	(37.7860784045808, -122.435052277699)
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)
162336	162336	217617	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1830 Ocean Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		5994396.9504	2092455.3654	37.7251625099423	-122.46155321589701	(37.7251625099423, -122.461553215897)
163884	163884	143342	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1836 UNION ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6004176.1641	2118743.4819	37.79790143670971	-122.42962150059401	(37.7979014367097, -122.429621500594)
130810	130810	143186	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	184 FRANCISCO ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6010406.8966	2121345.6921	37.805397292747	-122.40824493467501	(37.805397292747, -122.408244934675)
160908	160908	143377	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1851 UNION ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6004143.6971	2118693.4827	37.79776231335261	-122.429730277572	(37.7977623133526, -122.429730277572)

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