Street_Tree_List

Data source: data.sfgov.org

333 rows where SiteOrder = 2 and qSpecies = 82 sorted by YCoord

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
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
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
13405	13405	30592	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	269 Walter St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/26/1995 12:00:00 AM			Permit Number 34561
161987	161987	179331	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	21 Drake St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6001453.95042	2086881.4918	37.7102615738952	-122.43675911853501	(37.7102615738952, -122.436759118535)
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)
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)
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)
118181	118181	179285	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	93 Delta St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6010162.36149	2089750.0772799999	37.7186291998585	-122.40686296837099	(37.7186291998585, -122.406862968371)
69823	69823	213978	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	250 Faxon Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5994758.88079	2090253.13715	37.7191365451831	-122.460142594324	(37.7191365451831, -122.460142594324)
138436	138436	114384	Significant Tree 6	Pyrus kawakamii :: Evergreen Pear 82	418X SERRANO DR	2	Front Yard : Yard 7	Tree 1	Private 1			6			5988379.0	2090615.0	37.7197611043299	-122.48222163222201	(37.7197611043299, -122.482221632222)
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)
81776	81776	114391	Significant Tree 6	Pyrus kawakamii :: Evergreen Pear 82	23x PINTO AVE	2	Front Yard : Yard 7	Tree 1	Private 1			7			5988521.0	2090808.0	37.720299292258794	-122.481744923362	(37.7202992922588, -122.481744923362)
148185	148185	202038	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	75 Crane St	2	: 4	Tree 1	Private 1			2	Width 3ft		6012275.87253	2090920.17769	37.7219600944649	-122.39963948420099	(37.7219600944649, -122.399639484201)
151351	151351	213953	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	360 Faxon Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		5994770.431919999	2090973.1015700002	37.7211140599462	-122.460154799032	(37.7211140599462, -122.460154799032)
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)
154173	154173	213963	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	621 Holloway Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		5994830.12755	2091215.05246	37.7217818326369	-122.45996596837	(37.7217818326369, -122.45996596837)
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)
59413	59413	70593	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	314 Athens St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/06/1994 12:00:00 AM	10			6004216.40489	2091443.51048	37.722944495983	-122.427536307463	(37.722944495983, -122.427536307463)
149933	149933	179329	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	381 Madrid St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6003114.67783	2091636.05117	37.7234107926576	-122.43135848642599	(37.7234107926576, -122.431358486426)
29146	29146	179293	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	180 Edinburgh St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6004018.855	2092658.23186	37.7262686762461	-122.428305729646	(37.7262686762461, -122.428305729646)
47463	47463	70412	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1817 Silliman St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/21/1994 12:00:00 AM	4			6005464.04095	2092680.05814	37.7264102753879	-122.423311341054	(37.7264102753879, -122.423311341054)
174554	174554	85486	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	380 Bacon St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/05/2007 12:00:00 AM	5		Permit Number 49676	6010415.33133	2092799.63405	37.7270168024731	-122.406203288666	(37.7270168024731, -122.406203288666)
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)
88425	88425	49885	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	59@ WILDWOOD Eastwood Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/01/2003 12:00:00 AM			Permit Number 46658	5995617.4906105995	2092991.57857678	37.726705001321996	-122.457372735726	(37.726705001322, -122.457372735726)
173991	173991	179297	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	326 Peru Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6004358.252069999	2093034.47753	37.7273209621682	-122.427159238819	(37.7273209621682, -122.427159238819)
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)
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)
72873	72873	213944	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	98 Westwood Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 2ft		5995156.984180001	2093277.67362	37.7274640883802	-122.458985387177	(37.7274640883802, -122.458985387177)
119496	119496	199666	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1901 Keith St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		6015268.2608	2093490.7724	37.72918478862329	-122.389474894337	(37.7291847886233, -122.389474894337)
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)
13142	13142	27250	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	747 Silver Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	2X3		6006299.28886	2093605.00165	37.728997072755206	-122.420489547272	(37.7289970727552, -122.420489547272)
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)
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)
182525	182525	179291	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	65 Badger St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 2ft		6002393.53271	2094418.30005	37.731009322903	-122.434050139316	(37.731009322903, -122.434050139316)
68861	68861	197140	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	53 Pomona St	2	: 4	Tree 1	Private 1			3	Width 5ft		6014151.58684	2094423.9633799999	37.7316851643341	-122.39340063984	(37.7316851643341, -122.39340063984)
183076	183076	179287	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	97 Still St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 2ft		6002285.23223	2094449.03286	37.7310875612396	-122.43442674840799	(37.7310875612396, -122.434426748408)
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)
99327	99327	16156	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	400X Monterey Blvd	2	Median : Cutout 11	Tree 1	DPW 2			3	5		5999414.3973652	2094721.8518035999	37.731673280479	-122.44437128480699	(37.731673280479, -122.444371284807)
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)
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)
87293	87293	52908	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	295 Gaven St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/27/2006 12:00:00 AM		3x3	Permit Number 48898	6009070.24444642	2094849.33610342	37.732569516932294	-122.41099796146001	(37.7325695169323, -122.41099796146)
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)
37187	37187	179321	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	6 Merrill St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6009462.15792	2094931.0044	37.732815729946	-122.409648778469	(37.732815729946, -122.409648778469)
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)
152868	152868	179319	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	2 Merrill St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6009450.87811	2094957.47714	37.7328877863362	-122.409689643667	(37.7328877863362, -122.409689643667)
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)
183412	183412	197149	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	58 Whitney Young Cir	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6017152.11734	2094978.18509	37.7333732007951	-122.38306566055401	(37.7333732007951, -122.383065660554)
54424	54424	197151	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	99 Whitney Young Cir	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 4ft		6016637.91847	2095129.63156	37.7337606161438	-122.384853953468	(37.7337606161438, -122.384853953468)
118962	118962	51439	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	779 Andover St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/19/2004 12:00:00 AM			Permit Number 47759	6007378.77949872	2095187.90508456	37.7334041569913	-122.416869758383	(37.7334041569913, -122.416869758383)
168763	168763	213992	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	20 Mangels Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 5ft		6001188.39506	2095218.69175	37.733138545197704	-122.43827381338801	(37.7331385451977, -122.438273813388)
16295	16295	27141	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	1775 Silver Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	2X3		6011398.088769999	2095346.30396	37.7340643486912	-122.402984937921	(37.7340643486912, -122.402984937921)
160606	160606	247566	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	318 Alemany Blvd	2	: 4	Tree 1	Private 1			4	Width 4ft		6008741.21767	2095435.4350400001	37.7341603621059	-122.41217689865101	(37.7341603621059, -122.412176898651)
44172	44172	247564	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	316 Alemany Blvd	2	: 4	Tree 1	Private 1			7	Width 4ft		6008777.64172	2095456.26862	37.7342196103425	-122.412052440585	(37.7342196103425, -122.412052440585)
60939	60939	197154	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	18 Hawkins Ln	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6017001.63224	2095478.16332	37.734737725070204	-122.383620731122	(37.7347377250702, -122.383620731122)
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)
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)
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)
105262	105262	11462	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	41X HAWKINS LN	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		09/11/1992 12:00:00 AM	6	3X3		6016935.0	2095578.0	37.7350081734808	-122.38385805308201	(37.7350081734808, -122.383858053082)
14147	14147	11467	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	39X Hawkins Ln	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/25/1992 12:00:00 AM	8	3X3		6016799.4589	2095596.1573400002	37.7350505362442	-122.384327935502	(37.7350505362442, -122.384327935502)
168340	168340	197156	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	70 Hawkins Ln	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6016728.211	2095612.50382	37.73509148057529	-122.38457540555001	(37.7350914805753, -122.38457540555)
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)
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)
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)
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)
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)
97965	97965	24186	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	55X Whitney Young Cir	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/11/2006 12:00:00 AM	3	4x3		6016412.1769872	2096105.6107163997	37.736427970914	-122.38570241578998	(37.736427970914, -122.38570241579)
110618	110618	18636	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	20 Reuel Ct	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/19/2000 12:00:00 AM	3	3X3		6017095.3922155	2096110.4018038001	37.736478907812	-122.38334056309999	(37.736478907812, -122.3833405631)
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)
95631	95631	18654	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	85 Reuel Ct	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/04/1998 12:00:00 AM	3	3X4		6017364.7700717	2096131.8258237	37.7365526173752	-122.382410690517	(37.7365526173752, -122.382410690517)
113449	113449	18638	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	25 Reuel Ct	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/04/1998 12:00:00 AM	3	3X4		6017121.136185501	2096199.8633465	37.736725974033604	-122.383257779638	(37.7367259740336, -122.383257779638)
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)
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)
56227	56227	197135	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	901 Newhall St	2	: 4	Tree 1	Private 1			5	Width 3ft		6015262.92854	2096819.7411099998	37.738325167482294	-122.389725749154	(37.7383251674823, -122.389725749154)
98703	98703	88464	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	955X Newhall St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/11/2008 12:00:00 AM	4	3x3	Permit Number 51410	6015306.946426	2096847.395831	37.7384035424873	-122.389575486471	(37.7384035424873, -122.389575486471)
115748	115748	15637	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	3620 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/19/1999 12:00:00 AM	3	3X3		6005316.03868	2097071.29075	37.7384592699819	-122.42413513415899	(37.7384592699819, -122.424135134159)
14937	14937	16560	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	702X Newhall St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/03/1992 12:00:00 AM	12	3X3		6015615.61867	2097370.07413	37.7398558207833	-122.38854471268299	(37.7398558207833, -122.388544712683)
58478	58478	240187	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	84 Chenery St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6004879.89291	2097658.89878	37.7400480733545	-122.425684927129	(37.7400480733545, -122.425684927129)
14424	14424	6845	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	595X Newhall St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/16/1992 12:00:00 AM	6	3x3		6015936.9719	2097716.00593	37.7408234823092	-122.38745772460899	(37.7408234823092, -122.387457724609)
114300	114300	112865	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	750 VICENTE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5990595.0	2097751.0	37.7394834085128	-122.475082436927	(37.7394834085128, -122.475082436927)
69527	69527	31227	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	2598 14th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	04/04/1995 12:00:00 AM	4		Permit Number 34913	5992091.019830001	2097838.61761	37.7398105749846	-122.46991627883301	(37.7398105749846, -122.469916278833)
78120	78120	16551	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	500X Newhall St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/12/1998 12:00:00 AM	3	3x3		6016006.287148001	2097894.9109735	37.74131855784729	-122.387230532448	(37.7413185578473, -122.387230532448)
139811	139811	6418	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	350X Eugenia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		08/17/2016 12:00:00 AM	6	3X3		6006767.0052256	2097982.925376	37.7410442330982	-122.41918303237	(37.7410442330982, -122.41918303237)
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)
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)
65359	65359	213940	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	2526 14th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		5992077.65136	2098235.486	37.7408995020175	-122.46999139020599	(37.7408995020175, -122.469991390206)
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)
97467	97467	33438	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	193 Coleridge St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/20/1996 12:00:00 AM			Permit Number 37541	6006477.65745838	2098616.29315883	37.74276701964221	-122.420228434519	(37.7427670196422, -122.420228434519)
123759	123759	38869	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	2439 29th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/02/1998 12:00:00 AM			Permit Number 40694	5987327.75302366	2098677.68678111	37.7418379454862	-122.486447023752	(37.7418379454862, -122.486447023752)
157386	157386	49548	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	2434@ TARAVAL 21st Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2003 12:00:00 AM	1		Permit Number 46439	5989857.9655	2098790.1552	37.742293916006	-122.47770669165199	(37.742293916006, -122.477706691652)
63430	63430	239351	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	530 29th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6003095.45527	2098933.62242	37.7434471743571	-122.43194577520201	(37.7434471743571, -122.431945775202)
137145	137145	213941	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	173 Merced Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 4ft		5994356.4044699995	2099261.98747	37.743849483363206	-122.46218679288799	(37.7438494833632, -122.462186792888)
102226	102226	22817	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	57 Turquoise Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/21/2008 12:00:00 AM	3	2X2		5999134.8661569	2099418.6659097997	37.7445536617332	-122.445675315466	(37.7445536617332, -122.445675315466)
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)
141691	141691	112080	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1901x SANTIAGO ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	3x3		5986971.0	2099566.0	37.744256215511896	-122.487745790198	(37.7442562155119, -122.487745790198)
35976	35976	181801	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1919 Santiago St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5986905.9682	2099586.0566	37.744307492185	-122.487972126615	(37.744307492185, -122.487972126615)
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)
90917	90917	96064	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	2 Prospect Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/03/2011 12:00:00 AM		3x3	Permit Number 767689	6007344.9	2099669.6	37.7457079931938	-122.417304374627	(37.7457079931938, -122.417304374627)
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)
26202	26202	239326	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	26 Mullen Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009380.8265	2099841.0915200002	37.746293204883706	-122.41027651786001	(37.7462932048837, -122.41027651786)

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