Street_Tree_List

Data source: data.sfgov.org

333 rows where SiteOrder = 2 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, qSiteInfo, qCaretaker, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
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
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)
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)
19725	19725	114507	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	10 LOMBARD ST	2	Back Yard : Cutout 16	Tree 1	Port 9				4x4		6011932.0	2120995.0	37.8045196580749	-122.402942401468	(37.8045196580749, -122.402942401468)
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)
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)
665	665	239151	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	100 Octavia St	2	: 4	Tree 1	DPW 2		04/15/2017 01:58:00 PM	3	Width 4ft		6005731.03459	2109700.90805	37.7731606839629	-122.423597962203	(37.7731606839629, -122.423597962203)
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)
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)
98801	98801	14783	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	1037 McAllister St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6004216.0719046	2111827.8420520998	37.7789150924062	-122.42899008807801	(37.7789150924062, -122.428990088078)
87312	87312	24482	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	103X Sussex St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		6002240.5138934	2096668.0977393002	37.7371780656004	-122.434739971035	(37.7371780656004, -122.434739971035)
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)
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)
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)
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)
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)
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)
175020	175020	197153	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	11 Jakey Ct	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6016721.84036	2095568.4819	37.734970252878796	-122.384594365947	(37.7349702528788, -122.384594365947)
45950	45950	197160	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	11 Mabrey Ct	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6016488.26571	2095902.24457	37.7358737783612	-122.385425174944	(37.7358737783612, -122.385425174944)
185144	185144	239317	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1100 Hampshire St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 6ft		6010240.72628	2102744.15996	37.7543125548829	-122.407507713025	(37.7543125548829, -122.407507713025)
90598	90598	43924	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1100X HAMPSHIRE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/10/2000 12:00:00 AM			Permit Number 43515	6010276.0	2102522.0	37.7537045273505	-122.407370066225	(37.7537045273505, -122.407370066225)
64389	64389	197077	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1101 23rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 4ft		6014934.55258	2102947.77391	37.7551332492083	-122.391289372524	(37.7551332492083, -122.391289372524)
18932	18932	30938	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1106 Plymouth Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/10/2015 12:00:00 AM	8	3x3	Permit Number 772469	5995956.71997	2091289.90864	37.722052099618104	-122.456077064214	(37.7220520996181, -122.456077064214)
94122	94122	81726	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1111X 23rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/06/2012 12:00:00 AM	5	3x3	Permit Number 768902	6015016.9034833005	2102945.53994176	37.7551316851739	-122.39100442062201	(37.7551316851739, -122.391004420622)
171035	171035	179335	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1119 Athens St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 6ft		6001959.57443	2087726.76645	37.7126112352992	-122.435071996701	(37.7126112352992, -122.435071996701)
70248	70248	100361	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1135 Green St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	3x3		6007562.69285	2118825.76087	37.7983185248271	-122.417908959744	(37.7983185248271, -122.417908959744)
8596	8596	115210	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	115 Spruce St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	3x3		5997031.37665	2115893.5791	37.789669227607604	-122.45413840466298	(37.7896692276076, -122.454138404663)
28850	28850	110361	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1155 Pine St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9			6008381.52689	2115877.48528	37.790269335318996	-122.41486676369699	(37.790269335319, -122.414866763697)
128443	128443	85636	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	1161 Quesada Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/30/2007 12:00:00 AM	3	3x3		6017631.370144	2092826.6872430001	37.727492079674896	-122.381259184857	(37.7274920796749, -122.381259184857)
4111	4111	159295	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	118 Whipple Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/05/2017 02:16:00 PM	3	Width 0ft		5998136.03876	2087321.1199900003	37.7112795695727	-122.448258085851	(37.7112795695727, -122.448258085851)
142371	142371	92268	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	119 Madrone Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/24/2009 12:00:00 AM		3x3	Permit Number 52719	5992767.0	2098334.0	37.7412098217915	-122.46761506147101	(37.7412098217915, -122.467615061471)
96891	96891	41132	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	11X Belvedere St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/05/2016 12:00:00 AM	3	3x3	Permit Number 53576	5998162.17039542	2108554.54786356	37.769582935081296	-122.449696907216	(37.7695829350813, -122.449696907216)
14701	14701	11464	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	12 Jakey Ct	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/22/1992 12:00:00 AM	6	3X3		6016788.858519999	2095545.6720200002	37.734911327499205	-122.384361070118	(37.7349113274992, -122.384361070118)
4050	4050	159297	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	120 Whipple Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/05/2017 01:53:00 PM	3	Width 0ft		5998096.339240001	2087362.0634299999	37.711389721237104	-122.448398243388	(37.7113897212371, -122.448398243388)
92125	92125	85615	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	1200X Quesada Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/30/2007 12:00:00 AM	3	3x3		6017380.895351999	2093063.294675	37.7281279271047	-122.38214153905899	(37.7281279271047, -122.382141539059)
16642	16642	85639	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	1201X Quesada Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/30/2007 12:00:00 AM	3	3x3		6017307.7565	2093058.1427	37.7281097410693	-122.382394026885	(37.7281097410693, -122.382394026885)
160675	160675	213914	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1205 04th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 5ft		5994821.63869	2107263.01718	37.7658450462296	-122.46115797296999	(37.7658450462296, -122.46115797297)
165345	165345	52196	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1205 Filbert St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/19/2013 12:00:00 AM	2		Permit Number 770878	6007126.92706	2119460.55943	37.800036988073295	-122.419461903656	(37.8000369880733, -122.419461903656)
105821	105821	36824	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1220 Fitzgerald Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/02/2006 12:00:00 AM			Permit Number 49072	6014575.87209861	2090621.86928293	37.7212689399964	-122.39166805396799	(37.7212689399964, -122.391668053968)
62773	62773	213916	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1221 07th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		5993897.35256	2107155.07888	37.7654954419723	-122.46434702200199	(37.7654954419723, -122.464347022002)
14888	14888	24090	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	125X Whitney Young Cir	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/07/1997 12:00:00 AM	6	3x3		6016342.364159999	2095991.2568	37.736110114791	-122.3859358217	(37.736110114791, -122.3859358217)
47443	47443	96053	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	130 Coso Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/03/2011 12:00:00 AM		3x3	Permit Number 767681	6007306.3	2099659.0	37.745676716208	-122.417437096994	(37.745676716208, -122.417437096994)
137452	137452	197161	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	130 Whitney Young Cir	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6016392.6723	2096037.13258	37.7362388644345	-122.38576508091299	(37.7362388644345, -122.385765080913)
180097	180097	239245	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1300 Hampshire St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6010304.47179	2101582.19148	37.75112561476529	-122.40720536003799	(37.7511256147653, -122.407205360038)
176770	176770	239360	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1301 Sanchez St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 2ft		6003913.69662	2100667.88359	37.7482554068595	-122.429240140544	(37.7482554068595, -122.429240140544)
157966	157966	136202	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1337 Francisco St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6004913.0684	2120534.02336	37.8028595013299	-122.427199210075	(37.8028595013299, -122.427199210075)
113962	113962	48861	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	135 Wawona St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/29/2003 12:00:00 AM			Permit Number 46853	5992938.7152954005	2098174.1666423	37.7407808726579	-122.46700971886699	(37.7407808726579, -122.467009718867)
54566	54566	141886	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1355 EDDY ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6004027.64	2112849.1164	37.7817085903995	-122.429714809344	(37.7817085903995, -122.429714809344)
18626	18626	5933	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	1355 Eddy St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/28/1990 12:00:00 AM	3	4X4		6004029.334559999	2112693.29822	37.781280848415	-122.42969783017901	(37.781280848415, -122.429697830179)
33676	33676	136238	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1378 Pacific Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6007522.032000001	2117818.3708599997	37.7955501948379	-122.41797820753901	(37.7955501948379, -122.417978207539)
109779	109779	116919	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1390x TENNESSEE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/22/2016 12:00:00 AM	3	5x5		6015390.0	2102613.0	37.754239296938295	-122.389690908339	(37.7542392969383, -122.389690908339)
3810	3810	193325	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1398 Tennessee St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6015584.15702	2102639.39931	37.754322548171395	-122.389021302106	(37.7543225481714, -122.389021302106)
128988	128988	10416	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1399 Haight St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	3X3		5999442.73592	2108734.00442	37.7701488573322	-122.44528039770799	(37.7701488573322, -122.445280397708)
185841	185841	120256	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	140 24th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		5988368.86327	2114963.36268	37.7866145875471	-122.48404121988199	(37.7866145875471, -122.484041219882)
28124	28124	239362	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1400 Sanchez St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6003888.14228	2100073.30368	37.7466213818866	-122.429286114783	(37.7466213818866, -122.429286114783)
18752	18752	10423	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1401 Haight St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			25	3x3		5999371.8264	2108722.9096	37.7701143458549	-122.44552487423	(37.7701143458549, -122.44552487423)
65075	65075	240148	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1407 Cole St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 4ft		5998258.05957	2105587.56322	37.761441831488	-122.44915145438601	(37.761441831488, -122.449151454386)
108781	108781	48863	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	141 Wawona St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/29/2003 12:00:00 AM			Permit Number 46854	5992914.37939707	2098147.89875638	37.740707342979995	-122.467091953195	(37.74070734298, -122.467091953195)
160245	160245	123627	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	142 02nd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5995231.45698	2114622.12535	37.786074785036504	-122.46027374413099	(37.7860747850365, -122.460273744131)
179989	179989	136255	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1422 Vallejo St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 2ft		6006750.35587	2118407.27559	37.797123718848	-122.42069017253999	(37.797123718848, -122.42069017254)
155377	155377	136236	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1451 Taylor St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6008853.84836	2117876.7398200002	37.795785327084495	-122.413374006003	(37.7957853270845, -122.413374006003)
38610	38610	213996	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	146 Flood Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5999758.63525	2094089.70358	37.7299571835696	-122.44313580558399	(37.7299571835696, -122.443135805584)
55248	55248	197103	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1468 25th St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 5ft		6014438.05571	2102040.91433	37.7526156394141	-122.392942972153	(37.7526156394141, -122.392942972153)
84861	84861	53148	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1499@ LANE Thomas Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/02/2006 12:00:00 AM			Permit Number 49076	6015286.17606683	2093519.24782482	37.7292639697355	-122.389414946979	(37.7292639697355, -122.389414946979)
35501	35501	197166	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	15 Baldwin Ct	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6017812.186480001	2093598.1535200002	37.729620355985205	-122.380687698389	(37.7296203559852, -122.380687698389)
149879	149879	197163	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	15 Reuel Ct	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6017071.14695	2096120.91017	37.7365064217414	-122.383425121372	(37.7365064217414, -122.383425121372)
28239	28239	120254	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	150 24th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5988369.36546	2114920.76145	37.7864976459369	-122.4840363573	(37.7864976459369, -122.4840363573)
160235	160235	246010	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1509 Haight St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5998926.3648	2108660.5268	37.7699176174446	-122.447061224692	(37.7699176174446, -122.447061224692)
37696	37696	32199	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1516 Alabama St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/22/1995 12:00:00 AM	9		Permit Number 35524	6009302.4465	2100450.1305	37.7479610974423	-122.410590548539	(37.7479610974423, -122.410590548539)
172651	172651	71391	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1531 Kirkwood Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/21/1988 12:00:00 AM	4			6015562.7322	2096452.7948	37.737334227876396	-122.388663558077	(37.7373342278764, -122.388663558077)
148850	148850	137687	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1543 MCALLISTER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6001767.7027	2111487.4536	37.7778415800419	-122.437435575789	(37.7778415800419, -122.437435575789)
41805	41805	81939	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1567 Pacific Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/04/2008 12:00:00 AM		3x3	Permit Number 50642	6006641.29456006	2117646.14573466	37.7950276999422	-122.421013482861	(37.7950276999422, -122.421013482861)
169613	169613	200039	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1598 Lane St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6015308.9321	2094726.0259999998	37.7325788017835	-122.38942051753	(37.7325788017835, -122.38942051753)
44437	44437	120251	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	160 24th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 6ft		5988366.40775	2114885.43189	37.7864004688283	-122.48404399839899	(37.7864004688283, -122.484043998399)
80993	80993	85086	Significant Tree 6	Pyrus kawakamii :: Evergreen Pear 82	1600 Chestnut St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 49476	6004108.1	2120157.9	37.8017812094321	-122.429957968303	(37.8017812094321, -122.429957968303)
125168	125168	85089	Significant Tree 6	Pyrus kawakamii :: Evergreen Pear 82	1600 Chestnut St	2	Sidewalk: Property side : Cutout 5	Tree 1	Private 1						6004108.1	2120157.9	37.8017812094321	-122.429957968303	(37.8017812094321, -122.429957968303)
107582	107582	30615	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1600 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/30/1995 12:00:00 AM			Permit Number 34576	6008169.65081501	2108823.23186566	37.7708881396338	-122.415100307898	(37.7708881396338, -122.415100307898)
111056	111056	88488	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1600 Quesada Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/18/2008 12:00:00 AM		3x3	Permit Number 51434	6015245.7	2094684.2	37.732460450023495	-122.38963620788401	(37.7324604500235, -122.389636207884)
149898	149898	239324	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1614 Alabama St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6009260.8666	2099960.33429	37.7466138941099	-122.41069974602101	(37.7466138941099, -122.410699746021)
9255	9255	24072	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	161X Whitney Young Cir	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/11/2006 12:00:00 AM	3	3X3		6016395.7853594	2095946.5828375	37.735990405317004	-122.385748008424	(37.735990405317, -122.385748008424)
95467	95467	49612	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1626 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/13/2003 12:00:00 AM			Permit Number 46477	6008114.57908688	2108709.83276472	37.7705736773564	-122.415282774124	(37.7705736773564, -122.415282774124)
159802	159802	244178	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1628 Page St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		5998757.1914	2109033.6603	37.770932480068105	-122.447673254342	(37.7709324800681, -122.447673254342)
142494	142494	88263	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1630 Page St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/08/2008 12:00:00 AM		3x3	Permit Number 51249	5998765.0	2109030.0	37.7709228760915	-122.44764598076401	(37.7709228760915, -122.447645980764)
77045	77045	120249	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	164 24th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 6ft		5988365.91336	2114852.64965	37.786310429345704	-122.48404330399599	(37.7863104293457, -122.484043303996)
132492	132492	138547	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1640 SCOTT ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6001637.8568	2114160.6327	37.785174068245894	-122.438076291996	(37.7851740682459, -122.438076291996)
88949	88949	70620	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1644 Washington St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/13/1994 12:00:00 AM	12	3x3		6006824.13924708	2117065.21920464	37.793442925898105	-122.42033955937599	(37.7934429258981, -122.420339559376)
56000	56000	30618	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1645 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/30/1995 12:00:00 AM	5		Permit Number 34580	6008139.305	2108622.0896	37.7703341448356	-122.41519103466601	(37.7703341448356, -122.415191034666)
82753	82753	96048	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1653 Alabama St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/03/2011 12:00:00 AM		3x3	Permit Number 767679	6009324.0	2099841.0	37.7462897680072	-122.410473011409	(37.7462897680072, -122.410473011409)
180761	180761	200726	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1660 Quesada Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		6014855.123	2094958.2582	37.7331912931628	-122.39100568396299	(37.7331912931628, -122.391005683963)
158433	158433	200739	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1667 Quesada Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		6014860.3556	2094879.7682	37.7329760658991	-122.39098210937901	(37.7329760658991, -122.390982109379)
131718	131718	106807	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	167 Commonwealth Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2			5996526.1156	2113238.8382	37.78235103251139	-122.45569457348499	(37.7823510325114, -122.455694573485)
148156	148156	136240	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1679 Washington St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6006640.65595	2116994.76492	37.7932391350289	-122.420969421921	(37.7932391350289, -122.420969421921)
177889	177889	239322	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1682 Alabama St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6009287.32125	2099523.77754	37.7454166887246	-122.410577445415	(37.7454166887246, -122.410577445415)
15334	15334	30635	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1690 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/30/1995 12:00:00 AM	3	3x3	Permit Number 34583	6008075.6555	2108643.1391	37.770388364567104	-122.41541268929899	(37.7703883645671, -122.415412689299)
59563	59563	136228	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1695 North Point St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6002671.67342	2120917.48858	37.8037853875576	-122.43498301955401	(37.8037853875576, -122.434983019554)
46752	46752	121094	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	1697 McAllister St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		4	3x3		6001082.7006	2111393.2018	37.777543821113206	-122.43979847194099	(37.7775438211132, -122.439798471941)
87188	87188	85655	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	1699X Quesada Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/30/2007 12:00:00 AM	3	3x3		6014788.408146	2094944.7735630001	37.7331505648623	-122.39123539488199	(37.7331505648623, -122.391235394882)
139854	139854	111907	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1699x WASHINGTON ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6006657.0	2116952.0	37.7931226344993	-122.42090983270799	(37.7931226344993, -122.420909832708)
100023	100023	4364	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	16X Burnside Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/23/2012 12:00:00 AM	3	3x3		6001221.764219999	2095989.4346900003	37.7352567246132	-122.43821364238701	(37.7352567246132, -122.438213642387)

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