Street_Tree_List

Data source: data.sfgov.org

333 rows where SiteOrder = 2 and qSpecies = 82 sorted by rowid descending

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
188523	188523	248301	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	3175 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6006762.6824	2099881.3423	37.7462566162113	-122.419332619842	(37.7462566162113, -122.419332619842)
187865	187865	113165	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	3902 Clay St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	3x3		5996094.44333	2115248.19615	37.787843410013	-122.457333370439	(37.787843410013, -122.457333370439)
187068	187068	136217	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	2901 Steiner St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6001997.91666	2118237.1003900003	37.7963874672615	-122.43712256517999	(37.7963874672615, -122.43712256518)
187016	187016	239284	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	2750 18th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6009668.03436	2105500.1290599997	37.761847752195294	-122.409682747679	(37.7618477521953, -122.409682747679)
186161	186161	197074	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	2310 17th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6010495.70996	2106480.9898200002	37.7645873200617	-122.406889265436	(37.7645873200617, -122.406889265436)
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)
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)
184836	184836	240182	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	3399 16th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6004311.1947099995	2106557.83586	37.7644503218386	-122.42828532312299	(37.7644503218386, -122.428285323123)
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)
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)
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)
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)
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)
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)
179044	179044	248303	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	3165 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		6006799.1058	2099943.7824	37.7464301139591	-122.419211100336	(37.7464301139591, -122.419211100336)
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)
178735	178735	240140	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	401 27th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6003846.00586	2100095.72169	37.7466805509841	-122.429433416522	(37.7466805509841, -122.429433416522)
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)
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)
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)
176120	176120	138122	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1850 FILLMORE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		6003040.5439	2114556.1859999998	37.7863398290166	-122.433251707831	(37.7863398290166, -122.433251707831)
175096	175096	239364	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	3995 26th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 2ft		6003953.0649	2100692.52563	37.7483252967888	-122.429105762915	(37.7483252967888, -122.429105762915)
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)
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)
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)
173762	173762	124412	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	3900 Clay St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 4ft		5996120.28006	2115251.26489	37.787853319856794	-122.45724420279	(37.7878533198568, -122.45724420279)
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)
171756	171756	240130	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	3517 21st St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 4ft		6004936.2718	2103669.98473	37.756556314841	-122.425917770609	(37.756556314841, -122.425917770609)
171464	171464	141286	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	303 Anza St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5998281.8479	2112606.3279	37.7807149247435	-122.449574951116	(37.7807149247435, -122.449574951116)
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)
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)
169324	169324	118185	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	435 33rd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 2ft		5985597.25903	2112945.4232900003	37.7809121598048	-122.493481422073	(37.7809121598048, -122.493481422073)
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)
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)
168118	168118	123269	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	460 07th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5993762.13117	2112380.5079099997	37.779835284094204	-122.46519429844801	(37.7798352840942, -122.465194298448)
166708	166708	137981	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1940 FILLMORE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6002965.4976	2115097.1921	37.7878210367847	-122.433550025903	(37.7878210367847, -122.433550025903)
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)
164073	164073	97605	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	445 Hayes St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/27/2011 12:00:00 AM	2	3x3	Permit Number 768351	6005728.0342	2111001.8882	37.7767326912067	-122.42370085981301	(37.7767326912067, -122.423700859813)
162161	162161	91042	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	2998 Larkin St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/10/2008 12:00:00 AM	5	3x3	Permit Number 50399	6006462.588380001	2121409.81945	37.8053517187772	-122.421899314626	(37.8053517187772, -122.421899314626)
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)
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)
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)
160573	160573	213930	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	23 Hill Point Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5996333.00406	2106697.9920200002	37.7643804922005	-122.455889659002	(37.7643804922005, -122.455889659002)
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)
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)
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)
159656	159656	42168	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	525 05th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/21/2000 12:00:00 AM	9		Permit Number 42460	6012645.95751	2111148.5484599997	37.7775234660795	-122.399779856677	(37.7775234660795, -122.399779856677)
159587	159587	213922	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	28 Hill Point Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5996376.57374	2106740.0599	37.7644985003194	-122.45574200560499	(37.7644985003194, -122.455742005605)
158757	158757	72128	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	2012 23rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/25/1984 12:00:00 AM	11			6012399.20292	2102851.6444	37.7547282656006	-122.400050655116	(37.7547282656006, -122.400050655116)
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)
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)
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)
157108	157108	101338	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	600 Chestnut St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/1993 12:00:00 AM	3		Permit Number 32655	6008893.4466	2120790.6495	37.80378842303661	-122.413443168222	(37.8037884230366, -122.413443168222)
155537	155537	136195	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	2848 Scott St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6001082.7933	2118171.7538799997	37.796155982661396	-122.44028438991	(37.7961559826614, -122.44028438991)
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)
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)
153669	153669	142216	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	401 CENTRAL AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		5999738.1536	2109958.1912	37.7735270230304	-122.444346542631	(37.7735270230304, -122.444346542631)
153338	153338	197072	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	2300 17th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6010557.18002	2106482.58278	37.7645951333716	-122.406676768239	(37.7645951333716, -122.406676768239)
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)
152812	152812	143549	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	2245 UNION ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6002240.1517	2118427.2493	37.7969233328664	-122.436297997013	(37.7969233328664, -122.436297997013)
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)
150995	150995	140394	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1795 O'Farrell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6002772.8115	2113360.8016	37.783042414286	-122.43409250869	(37.783042414286, -122.43409250869)
150852	150852	197141	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	502 Beale St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 6ft		6015667.2078	2114177.54158	37.786008361852396	-122.38953984758801	(37.7860083618524, -122.389539847588)
150842	150842	136205	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	201 Locust St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 3ft		5997542.32225	2115652.46545	37.78903647900739	-122.452353187461	(37.7890364790074, -122.452353187461)
150726	150726	239269	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	27 Woodward St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 2ft		6006491.50571	2108328.68595	37.7694357855487	-122.420869947001	(37.7694357855487, -122.420869947001)
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)
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)
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)
149720	149720	239370	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	3545 21st St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6004734.2478	2103657.77197	37.7565113622207	-122.426615572568	(37.7565113622207, -122.426615572568)
149420	149420	136190	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	2914 Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 2ft		6002538.23525	2118203.76672	37.7963266398053	-122.43525056515499	(37.7963266398053, -122.435250565155)
149008	149008	120775	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	57 21st Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5989253.50277	2114844.1258799997	37.7863386601165	-122.48097188408	(37.7863386601165, -122.48097188408)
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)
148823	148823	99598	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	3001 Webster St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15		Permit Number 17057	6002874.08515	2118929.42484	37.7983381750246	-122.434140356598	(37.7983381750246, -122.434140356598)
148769	148769	50669	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	3130 Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/07/2004 12:00:00 AM	9		Permit Number 47247	6002419.67533	2119034.32922	37.798600414646295	-122.435720259485	(37.7986004146463, -122.435720259485)
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)
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)
147715	147715	138510	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1910 Post St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6002995.9377	2114140.5454	37.785196054628294	-122.433376321644	(37.7851960546283, -122.433376321644)
146318	146318	8938	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	4649X Geary Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	3X3		5992558.61151	2112698.79101	37.7806397269512	-122.469380940837	(37.7806397269512, -122.469380940837)
146269	146269	24686	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	6599X Geary Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	Rec/Park 3		03/15/2006 12:00:00 AM	3	3X3		5986563.55545	2112507.59289	37.77976647962429	-122.49010635929599	(37.7797664796243, -122.490106359296)
146104	146104	100411	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	201x Linden St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/16/2012 12:00:00 AM			Permit Number 767727	6006435.0	2110776.0	37.7761523386864	-122.421239206856	(37.7761523386864, -122.421239206856)
144934	144934	24470	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	50X Gough St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/07/1995 12:00:00 AM	16	3x3		6006161.54315	2109606.56692	37.7729259368552	-122.42210207116699	(37.7729259368552, -122.422102071167)
142781	142781	7328	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	2042 Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6002935.65629	2115353.59376	37.7885233572924	-122.43367160320801	(37.7885233572924, -122.433671603208)
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)
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)
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)
140729	140729	87847	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	2480 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/02/2008 12:00:00 AM		3x3	Permit Number 50600	6006948.0	2103912.0	37.757334318408	-122.41897764469499	(37.757334318408, -122.418977644695)
140642	140642	111867	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	3399x 16TH ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6004303.0	2106535.0	37.7643871563547	-122.428312038708	(37.7643871563547, -122.428312038708)
140172	140172	8112	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	810 Fulton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/14/2007 12:00:00 AM	1	3X3		6003674.72306	2111615.24723	37.778300702455894	-122.430847652747	(37.7783007024559, -122.430847652747)
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)
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)
139534	139534	35264	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	2316 Polk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/30/2009 12:00:00 AM		3x3	Permit Number 52291	6006351.546323201	2118737.5484062	37.7980080796095	-122.422093629292	(37.7980080796095, -122.422093629292)
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)
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)
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)
136988	136988	136224	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	3699 Divisadero St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6000162.1216	2120884.12041	37.8035509567753	-122.443665040422	(37.8035509567753, -122.443665040422)
136079	136079	72127	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	2110 23rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/25/1984 12:00:00 AM	10			6012120.035209999	2102839.43148	37.7546791626274	-122.401015240957	(37.7546791626274, -122.401015240957)
135839	135839	197070	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	2224 Mariposa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6010762.18372	2106028.80224	37.7633606223146	-122.40593574303301	(37.7633606223146, -122.405935743033)
135338	135338	34252	Permitted Site 1	Pyrus kawakamii :: Evergreen Pear 82	945 Bay St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/17/1998 12:00:00 AM	8		Permit Number 38731	6006224.9654	2121058.41971	37.804373461439795	-122.42269665353999	(37.8043734614398, -122.42269665354)
133160	133160	239292	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	900 York St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6009918.7268199995	2103885.22613	37.7574276383036	-122.40870176718799	(37.7574276383036, -122.408701767188)
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)

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