Street_Tree_List

Data source: data.sfgov.org

1,684 rows where qCaretaker = 1 and qSpecies = 82 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, PlantType, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
5893	5893	46201	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/31/2001 12:00:00 AM			Permit Number 44518
9250	9250	46200	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/31/2001 12:00:00 AM			Permit Number 44518
49521	49521	240131	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	0 Chattanooga St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6004671.7789900005	2103561.17999	37.7562426115098	-122.426824733295	(37.7562426115098, -122.426824733295)
75125	75125	240132	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	0 Chattanooga St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6004672.38894	2103545.66672	37.7562000502026	-122.42682151911801	(37.7562000502026, -122.426821519118)
154817	154817	240133	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	0 Chattanooga St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6004672.52486	2103529.70008	37.756156217245604	-122.426819912015	(37.7561562172456, -122.426819912015)
87818	87818	102145	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	0X Ford St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	3x3		6003601.0	2105679.0	37.7619970392507	-122.430678972901	(37.7619970392507, -122.430678972901)
103400	103400	102146	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	0X Ford St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3x3		6003601.0	2105679.0	37.7619970392507	-122.430678972901	(37.7619970392507, -122.430678972901)
114315	114315	102144	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	0X Ford St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3x3		6003601.0	2105679.0	37.7619970392507	-122.430678972901	(37.7619970392507, -122.430678972901)
123602	123602	120676	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1 Ford St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6003502.0	2105614.0	37.7618129556584	-122.43101673587799	(37.7618129556584, -122.431016735878)
63119	63119	213926	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1 Hill Point Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5996340.85636	2106804.33971	37.764672946334294	-122.45587018867501	(37.7646729463343, -122.455870188675)
131145	131145	213991	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1 Merced Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 3ft		5995344.90173	2100199.2685	37.7464798897511	-122.458836668093	(37.7464798897511, -122.458836668093)
70153	70153	179314	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	100 Hamilton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6009038.30764	2093734.4569599999	37.7295065063148	-122.411029655989	(37.7295065063148, -122.411029655989)
153317	153317	179315	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	100 Hamilton St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6009040.95061	2093717.83367	37.729461010514605	-122.411019345266	(37.7294610105146, -122.411019345266)
69300	69300	179323	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	100 Merrill St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6009520.85663	2094768.8785700002	37.7323738561678	-122.409434403484	(37.7323738561678, -122.409434403484)
179013	179013	179324	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	100 Merrill St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6009528.37304	2094747.8855599998	37.7323166349901	-122.409406936389	(37.7323166349901, -122.409406936389)
118366	118366	67075	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	100 Tompkins Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/09/1995 12:00:00 AM			Permit Number 30469	6007674.59209912	2096541.81182002	37.7371383234242	-122.41594289157601	(37.7371383234242, -122.415942891576)
178446	178446	179313	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	100 Yale St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6006918.398519999	2093488.03593	37.728710780776	-122.418340943684	(37.728710780776, -122.418340943684)
52058	52058	41522	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1001 Mariposa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/20/2000 12:00:00 AM	3		Permit Number 42063	6014186.00908	2106172.78785	37.763946866973704	-122.39410383682	(37.7639468669737, -122.39410383682)
50254	50254	213950	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1006 Capitol Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5995061.44128	2090626.04133	37.720177849497794	-122.459123753274	(37.7201778494978, -122.459123753274)
67006	67006	240153	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1008 Cole St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5998136.29263	2106764.45676	37.764666319205205	-122.449657403985	(37.7646663192052, -122.449657403985)
9197	9197	24149	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	100X Whitney Young Cir	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/11/2006 12:00:00 AM	3	3x3		6016357.373923	2096088.8828188	37.736379006835996	-122.385890729183	(37.736379006836, -122.385890729183)
9227	9227	24151	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	100X Whitney Young Cir	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/11/2006 12:00:00 AM	3	3x3		6016357.373923	2096088.8828188	37.736379006835996	-122.385890729183	(37.736379006836, -122.385890729183)
13371	13371	24145	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	100X Whitney Young Cir	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3x3		6016696.89665	2095171.76192	37.7338795595807	-122.384652980151	(37.7338795595807, -122.384652980151)
14904	14904	24147	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	100X Whitney Young Cir	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3x3		6016689.05107	2095205.54183	37.7339718785836	-122.384682457242	(37.7339718785836, -122.384682457242)
25564	25564	197127	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	101 Newhall St	13	: 4	Tree 1	Private 1			3	Width 3ft		6017303.080490001	2098110.9339400004	37.7419834431736	-122.382761660942	(37.7419834431736, -122.382761660942)
71194	71194	60642	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	101 Randall St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/12/1983 12:00:00 AM			Permit Number 20270	6004901.36876785	2097539.55337894	37.7397215914528	-122.425602180558	(37.7397215914528, -122.425602180558)
104065	104065	41900	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	101 Scott St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/20/2000 12:00:00 AM			Permit Number 42265	6002336.18060938	2108825.44123893	37.7705646588804	-122.43527855581301	(37.7705646588804, -122.435278555813)
152901	152901	239239	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	101 Scott St	1	: 4	Tree 1	Private 1			20	Width 6ft		6002329.06188	2108869.34471	37.7706848027038	-122.435306320439	(37.7706848027038, -122.435306320439)
167332	167332	136212	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	101 Spruce St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5997026.477630001	2115953.7993900003	37.7898342954728	-122.454159706	(37.7898342954728, -122.454159706)
178696	178696	136211	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	101 Spruce St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 3ft		5997026.34564	2115964.00812	37.7898623183414	-122.454160900321	(37.7898623183414, -122.454160900321)
3419	3419	252969	Private 5	Pyrus kawakamii :: Evergreen Pear 82	101 Whipple Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5998180.94106	2087280.50358	37.711170613109104	-122.448099970249	(37.7111706131091, -122.448099970249)
48422	48422	197116	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1015 Rhode Island St	1	: 4	Tree 1	Private 1			2	Width 3ft		6011950.215340001	2103491.63171	37.75646048668521	-122.40164836548	(37.7564604866852, -122.40164836548)
4061	4061	252970	Private 5	Pyrus kawakamii :: Evergreen Pear 82	101X Whipple Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/05/2017 12:21:00 PM	3
64108	64108	83143	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	101X Whitney Young Cir	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/17/2006 12:00:00 AM	1			6016637.512159999	2095504.68596	37.7347904181313	-122.384881478104	(37.7347904181313, -122.384881478104)
61184	61184	197150	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	102 Whitney Young Cir	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6016678.04362	2095528.85162	37.7348590139212	-122.38474302838999	(37.7348590139212, -122.38474302839)
181078	181078	239315	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1024 Hampshire St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6010214.49456	2103222.56761	37.7556246873555	-122.40763215850599	(37.7556246873555, -122.407632158506)
38315	38315	179295	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	103 Edinburgh St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6004297.98606	2093012.3139099998	37.727256697520204	-122.42736600014	(37.7272566975202, -122.42736600014)
170019	170019	141931	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1050 MCALLISTER ST	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		6004116.6344	2111867.0624	37.7790171527246	-122.42933687953999	(37.7790171527246, -122.42933687954)
185979	185979	141928	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1050 MCALLISTER ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6004234.8996	2111882.5726	37.779066434664294	-122.428928858602	(37.7790664346643, -122.428928858602)
40781	40781	101046	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1050 Sansome St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	3x3	Permit Number 774347	6012049.4869099995	2119300.00717	37.799872179210894	-122.40241656909201	(37.7998721792109, -122.402416569092)
87927	87927	101047	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1050 Sansome St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/18/2014 12:00:00 AM	3	3x3	Permit Number 774347	6012043.0	2119296.0	37.799860814363	-122.40243873444099	(37.799860814363, -122.402438734441)
114943	114943	61792	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1053 De Haro St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/26/1985 12:00:00 AM			Permit Number 21815	6012220.91982442	2103494.12981341	37.7564824480415	-122.400712343497	(37.7564824480415, -122.400712343497)
9055	9055	24107	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	105X Whitney Young Cir	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/11/2006 12:00:00 AM	3	3x3		6016397.2233978	2096041.0813580002	37.7362499588234	-122.385749620885	(37.7362499588234, -122.385749620885)
9206	9206	24109	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	105X Whitney Young Cir	16	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/11/2006 12:00:00 AM	3	3x3		6016397.2233978	2096041.0813580002	37.7362499588234	-122.385749620885	(37.7362499588234, -122.385749620885)
85171	85171	60613	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	106 Randall St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/12/1983 12:00:00 AM			Permit Number 20237	6004863.02785957	2097589.48802411	37.7398565341458	-122.425738300436	(37.7398565341458, -122.425738300436)
33428	33428	197157	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	106 Whitney Young Cir	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6016598.7871900005	2095669.6865	37.7352413346217	-122.385026857123	(37.7352413346217, -122.385026857123)
173068	173068	197158	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	106 Whitney Young Cir	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6016583.16711	2095682.22839	37.7352749081106	-122.385081735533	(37.7352749081106, -122.385081735533)
29544	29544	213971	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1061 Capitol Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		5995026.07265	2091112.6142099998	37.7215118291791	-122.459281227253	(37.7215118291791, -122.459281227253)
33788	33788	213974	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1061 Capitol Ave	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5995026.3935	2091022.299	37.7212638636298	-122.459273581222	(37.7212638636298, -122.459273581222)
36604	36604	213973	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1061 Capitol Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		5995027.24606	2091045.4090900002	37.721327367434604	-122.459272306869	(37.7213273674346, -122.459272306869)
59382	59382	213975	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1061 Capitol Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		5995024.51997	2091003.2487299999	37.7212114484221	-122.45927867859501	(37.7212114484221, -122.459278678595)
69936	69936	213969	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1061 Capitol Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		5995027.18674	2091165.82123	37.7216579869959	-122.459281227274	(37.7216579869959, -122.459281227274)
71421	71421	213970	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1061 Capitol Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5995027.09423	2091143.79671	37.721597507607996	-122.45927995292699	(37.721597507608, -122.459279952927)
124104	124104	213976	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1061 Capitol Ave	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		5995023.46765	2090970.5982400002	37.7211217374705	-122.459279952923	(37.7211217374705, -122.459279952923)
172877	172877	213968	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1061 Capitol Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		5995026.496169999	2091185.65951	37.7217124184688	-122.459285050266	(37.7217124184688, -122.459285050266)
177551	177551	213972	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1061 Capitol Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		5995029.65711	2091072.52436	37.721401958108295	-122.459265935174	(37.7214019581083, -122.459265935174)
30190	30190	136213	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	107 Spruce St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		5997027.70911	2115921.73522	37.78974632646779	-122.45415312837099	(37.7897463264678, -122.454153128371)
169703	169703	36194	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	107 Spruce St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10		Permit Number 39260	5997029.24357	2115938.23155	37.7897917089598	-122.454149011282	(37.7897917089598, -122.454149011282)
53523	53523	48812	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM	5		Permit Number 46042	6014467.053730001	2102353.10418	37.753474456898104	-122.392864530587	(37.7534744568981, -122.392864530587)
79486	79486	48797	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	17	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM			Permit Number 46042	6014495.63347758	2102077.94418173	37.7527205135809	-122.39274644691601	(37.7527205135809, -122.392746446916)
79749	79749	48808	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM			Permit Number 46042	6014495.63347758	2102077.94418173	37.7527205135809	-122.39274644691601	(37.7527205135809, -122.392746446916)
80482	80482	48805	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM			Permit Number 46042	6014495.63347758	2102077.94418173	37.7527205135809	-122.39274644691601	(37.7527205135809, -122.392746446916)
87368	87368	48795	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	15	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM			Permit Number 46042	6014495.63347758	2102077.94418173	37.7527205135809	-122.39274644691601	(37.7527205135809, -122.392746446916)
93668	93668	48814	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	24	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM			Permit Number 46042	6014495.63347758	2102077.94418173	37.7527205135809	-122.39274644691601	(37.7527205135809, -122.392746446916)
93881	93881	48807	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM			Permit Number 46042	6014495.63347758	2102077.94418173	37.7527205135809	-122.39274644691601	(37.7527205135809, -122.392746446916)
95001	95001	48798	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	20	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM			Permit Number 46042	6014495.63347758	2102077.94418173	37.7527205135809	-122.39274644691601	(37.7527205135809, -122.392746446916)
97538	97538	48793	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM			Permit Number 46042	6014495.63347758	2102077.94418173	37.7527205135809	-122.39274644691601	(37.7527205135809, -122.392746446916)
103218	103218	48813	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	19	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM			Permit Number 46042	6014495.63347758	2102077.94418173	37.7527205135809	-122.39274644691601	(37.7527205135809, -122.392746446916)
105017	105017	48796	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	16	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM			Permit Number 46042	6014495.63347758	2102077.94418173	37.7527205135809	-122.39274644691601	(37.7527205135809, -122.392746446916)
107290	107290	48806	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM			Permit Number 46042	6014495.63347758	2102077.94418173	37.7527205135809	-122.39274644691601	(37.7527205135809, -122.392746446916)
112016	112016	48804	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM			Permit Number 46042	6014495.63347758	2102077.94418173	37.7527205135809	-122.39274644691601	(37.7527205135809, -122.392746446916)
113270	113270	48802	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM			Permit Number 46042	6014495.63347758	2102077.94418173	37.7527205135809	-122.39274644691601	(37.7527205135809, -122.392746446916)
114793	114793	48794	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM			Permit Number 46042	6014495.63347758	2102077.94418173	37.7527205135809	-122.39274644691601	(37.7527205135809, -122.392746446916)
116610	116610	48792	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	23	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM			Permit Number 46042	6014495.63347758	2102077.94418173	37.7527205135809	-122.39274644691601	(37.7527205135809, -122.392746446916)
119141	119141	48803	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM			Permit Number 46042	6014495.63347758	2102077.94418173	37.7527205135809	-122.39274644691601	(37.7527205135809, -122.392746446916)
124980	124980	48800	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	21	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM			Permit Number 46042	6014495.63347758	2102077.94418173	37.7527205135809	-122.39274644691601	(37.7527205135809, -122.392746446916)
127193	127193	48801	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	22	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM			Permit Number 46042	6014495.63347758	2102077.94418173	37.7527205135809	-122.39274644691601	(37.7527205135809, -122.392746446916)
147265	147265	48809	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM	3		Permit Number 46042	6014468.625469999	2102279.9042599997	37.753273552832205	-122.392853974356	(37.7532735528322, -122.392853974356)
150866	150866	48811	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM	7		Permit Number 46042	6014468.770930001	2102318.37211	37.7533791854235	-122.392856162375	(37.7533791854235, -122.392856162375)
151589	151589	48815	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM	5		Permit Number 46042	6014467.97393	2102326.82142	37.7534023411579	-122.392859509671	(37.7534023411579, -122.392859509671)
151617	151617	48799	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM	5		Permit Number 46042	6014465.83632	2102364.69447	37.753506213741396	-122.392869551502	(37.7535062137414, -122.392869551502)
161197	161197	48810	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1082Street Pennsylvania Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/2002 12:00:00 AM	5		Permit Number 46042	6014469.89088	2102291.4479400003	37.753305319601495	-122.392850405821	(37.7533053196015, -122.392850405821)
41318	41318	240143	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	109 Cole St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 2ft		5998171.35185	2106192.58759	37.763098116497204	-122.449494935145	(37.7630981164972, -122.449494935145)
70424	70424	124324	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	109 Jordan Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 3ft		5996182.48161	2113700.3553299997	37.7835985094544	-122.45691677945	(37.7835985094544, -122.45691677945)
4074	4074	252967	Private 5	Pyrus kawakamii :: Evergreen Pear 82	109 Whipple Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/05/2017 01:55:00 PM	3			5998144.81293	2087318.48212	37.7112728281964	-122.448227570418	(37.7112728281964, -122.448227570418)
27161	27161	197088	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1098 Pennsylvania Ave	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 5ft		6014473.69906	2102184.6927400003	37.753012404101	-122.39282976818998	(37.753012404101, -122.39282976819)
36178	36178	197095	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1098 Pennsylvania Ave	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 5ft		6014479.30677	2102077.89395	37.7527194688438	-122.39280290452601	(37.7527194688438, -122.392802904526)
41596	41596	197086	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1098 Pennsylvania Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 5ft		6014471.44073	2102209.38753	37.7530800852958	-122.39283930551599	(37.7530800852958, -122.392839305516)
45418	45418	197094	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1098 Pennsylvania Ave	12	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 5ft		6014478.47867	2102089.9100099998	37.7527524163908	-122.392806608832	(37.7527524163908, -122.392806608832)
62833	62833	197084	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1098 Pennsylvania Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 5ft		6014468.76337	2102245.03022	37.753177803814	-122.39285105782801	(37.753177803814, -122.392851057828)
134469	134469	197089	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1098 Pennsylvania Ave	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 5ft		6014473.51573	2102162.27258	37.7529508329366	-122.39282883379101	(37.7529508329366, -122.392828833791)
149097	149097	197092	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1098 Pennsylvania Ave	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 5ft		6014476.97343	2102121.40509	37.752838811567	-122.392814017467	(37.752838811567, -122.392814017467)
157085	157085	197085	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1098 Pennsylvania Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 5ft		6014468.858580001	2102236.49554	37.7531543746906	-122.392850131521	(37.7531543746906, -122.392850131521)
160169	160169	197087	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1098 Pennsylvania Ave	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 5ft		6014472.10243	2102198.29911	37.753049675611	-122.39283624152	(37.753049675611, -122.39283624152)
170402	170402	197083	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1098 Pennsylvania Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 5ft		6014468.24915	2102256.69833	37.7532098133945	-122.392853652369	(37.7532098133945, -122.392853652369)
171068	171068	197090	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1098 Pennsylvania Ave	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 5ft		6014474.311480001	2102148.65752	37.752913493081294	-122.39282512948	(37.7529134930813, -122.39282512948)
181135	181135	197093	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1098 Pennsylvania Ave	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 5ft		6014477.98301	2102105.11898	37.7527941494528	-122.392809386851	(37.7527941494528, -122.392809386851)
181973	181973	197091	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1098 Pennsylvania Ave	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 5ft		6014475.63706	2102134.7648099996	37.7528754202862	-122.39281957348601	(37.7528754202862, -122.392819573486)
43382	43382	246032	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	11 Belvedere St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5998172.7746	2108470.8044	37.7693536035765	-122.44965419238501	(37.7693536035765, -122.449654192385)
36414	36414	136262	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	11 Filbert St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7			6012539.8548099995	2120210.2855	37.8023989459081	-122.400783688018	(37.8023989459081, -122.400783688018)

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