Street_Tree_List

Data source: data.sfgov.org

288 rows where DBH = 2 and qSpecies = 18 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: SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize

Link	rowid ▲	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
188604	188604	237088	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1600 15th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6006692.25312	2107335.17282	37.7667191467912	-122.420105051126	(37.7667191467912, -122.420105051126)
188584	188584	214655	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1797 10th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993099.09717	2103293.8568599997	37.754847490535795	-122.466827267677	(37.7548474905358, -122.466827267677)
187732	187732	214729	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	620 Faxon Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5994877.75254	2092392.95175	37.725018800251796	-122.459886624766	(37.7250188002518, -122.459886624766)
186977	186977	213378	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1222 09th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993325.39992	2107141.02877	37.7654238793266	-122.466324239095	(37.7654238793266, -122.466324239095)
185988	185988	239387	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	418 Jersey St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6002328.89544	2101520.5865700003	37.750506882090704	-122.434781298937	(37.7505068820907, -122.434781298937)
185970	185970	237122	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	2957 26th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 6ft		6009722.71045	2101009.1052200003	37.749519471442206	-122.40917672522	(37.7495194714422, -122.40917672522)
185153	185153	135917	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	2350 Green St	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 3ft		6001679.33795	2118057.34258	37.7958757853901	-122.438212029083	(37.7958757853901, -122.438212029083)
185071	185071	179122	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	62 Girard Rd	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6010416.60856	2094359.22813	37.731299191484105	-122.406308712574	(37.7312991914841, -122.406308712574)
185017	185017	237143	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	817 York St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009936.213819999	2104293.7676	37.7585503807153	-122.40867011015	(37.7585503807153, -122.40867011015)
184502	184502	237093	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1600 15th St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6006628.38963	2107330.3055	37.7667021837902	-122.420325599041	(37.7667021837902, -122.420325599041)
183766	183766	196475	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	58 Ceres St	1	: 4	Tree 1	Private 1			2	Width 3ft		6013844.58264	2093878.5960799998	37.730170634955705	-122.39442385069401	(37.7301706349557, -122.394423850694)
183720	183720	237359	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1398 Treat Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008689.76614	2100834.9062	37.748983237187296	-122.412736376802	(37.7489832371873, -122.412736376802)
182463	182463	214521	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	945 Irving St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992776.19936	2106588.69627	37.763875616381895	-122.468183598193	(37.7638756163819, -122.468183598193)
182102	182102	103454	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	284 24th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		5988396.696330001	2114118.88325	37.7842975073391	-122.48388298077101	(37.7842975073391, -122.483882980771)
181843	181843	120426	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	667 22nd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5989088.891559999	2110781.28528	37.7751736683191	-122.48124376819099	(37.7751736683191, -122.481243768191)
181338	181338	213606	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	153 Vasquez Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5994943.30534	2099473.46779	37.7444639307591	-122.460172759368	(37.7444639307591, -122.460172759368)
180364	180364	237255	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	294 Upper Ter	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5999333.68495	2106005.63165	37.762651205614205	-122.44546138854601	(37.7626512056142, -122.445461388546)
179988	179988	123298	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	727 05th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5994403.21402	2110559.5838200003	37.7748724608847	-122.462844385609	(37.7748724608847, -122.462844385609)
179631	179631	213662	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	40 Edgehill Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5994703.12273	2098951.8229900002	37.7430178065176	-122.46096545511101	(37.7430178065176, -122.460965455111)
179032	179032	213338	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	280 Ralston St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 4ft		5992226.7586	2089761.9448900002	37.7176418818408	-122.46885936766701	(37.7176418818408, -122.468859367667)
178919	178919	179098	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	115 Ney St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004160.23558	2094047.68925	37.7300918156881	-122.42791594906299	(37.7300918156881, -122.427915949063)
178641	178641	70480	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	919 Avalon Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/07/2011 12:00:00 AM	2	3x3	Permit Number 767510	6005011.406280001	2092024.56337	37.724584874666206	-122.42482946681001	(37.7245848746662, -122.42482946681)
178337	178337	213614	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	245 Brentwood Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5995052.144090001	2095276.4230000002	37.7329461415325	-122.45949251308201	(37.7329461415325, -122.459492513082)
178173	178173	88272	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	518 Utah St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/09/2008 12:00:00 AM	2	3x3	Permit Number 51258	6010632.7883	2105837.1165299998	37.7628270590352	-122.40636977475599	(37.7628270590352, -122.406369774756)
177794	177794	237345	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	95 Jarboe Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6009109.05137	2096909.7474200001	37.738229137875294	-122.411009275572	(37.7382291378753, -122.411009275572)
177133	177133	214642	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1290 09th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5993336.037169999	2106757.3858	37.764371110454604	-122.466259564335	(37.7643711104546, -122.466259564335)
176951	176951	48912	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1930 Vallejo St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/22/2002 12:00:00 AM	2	3x3	Permit Number 46107	6004309.09705	2118070.5094	37.796061152762796	-122.429113506091	(37.7960611527628, -122.429113506091)
176702	176702	214506	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1961 11th Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5992841.4998699995	2102207.4204	37.7518495465294	-122.46763909649201	(37.7518495465294, -122.467639096492)
176272	176272	239419	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	2220 Castro St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6002666.0925199995	2099026.39747	37.7436775626798	-122.43343703011999	(37.7436775626798, -122.43343703012)
176034	176034	214504	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1961 11th Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5992841.74564	2102234.5173	37.7519239618198	-122.467640217025	(37.7519239618198, -122.467640217025)
175612	175612	118209	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	574 35th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 3ft		5985058.9891	2111965.86595	37.7781910764099	-122.495271274867	(37.7781910764099, -122.495271274867)
175242	175242	237430	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1120 Diamond St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6001920.37973	2100752.7732599997	37.748375447487	-122.43613903599	(37.748375447487, -122.43613903599)
174956	174956	237089	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1600 15th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6006678.09953	2107334.09058	37.7667153777448	-122.420153929277	(37.7667153777448, -122.420153929277)
174646	174646	135972	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	2304 Vallejo St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6002483.01544	2117812.37138	37.795248833821894	-122.43541362484301	(37.7952488338219, -122.435413624843)
174598	174598	238509	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	306 Arlington St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6004358.32259	2096414.3474700002	37.7366013316931	-122.427399667156	(37.7366013316931, -122.427399667156)
173780	173780	179103	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	135 Craut St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004050.55138	2094143.07968	37.730347530692605	-122.428301937189	(37.7303475306926, -122.428301937189)
173587	173587	95934	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	674 28th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/29/2011 12:00:00 AM	2	3x3	Permit Number 767631	5987254.50705	2111348.9878700003	37.7766256032795	-122.487630947058	(37.7766256032795, -122.487630947058)
173198	173198	214478	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1668 18th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5990610.731369999	2104039.3841	37.7567505828021	-122.475487070766	(37.7567505828021, -122.475487070766)
172980	172980	50792	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	2740 Union St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2		Permit Number 47317	5999864.3976	2118141.20218	37.7960026509676	-122.444498073449	(37.7960026509676, -122.444498073449)
172699	172699	214507	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1961 11th Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5992840.594380001	2102195.17889	37.7518158822179	-122.467641337597	(37.7518158822179, -122.467641337597)
172657	172657	214805	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	820 Rockdale Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5996900.78784	2098298.33611	37.74134970533439	-122.45331940017599	(37.7413497053344, -122.453319400176)
172558	172558	214640	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1259 09th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5993284.58174	2106894.2296	37.7647438785383	-122.46644747949301	(37.7647438785383, -122.466447479493)
172393	172393	179099	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	135 Craut St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004053.41682	2094064.32583	37.730131452391504	-122.428286420292	(37.7301314523915, -122.428286420292)
172211	172211	179008	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	600 Edinburgh St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6002499.6579	2090233.80705	37.7195256683641	-122.433384339735	(37.7195256683641, -122.433384339735)
172041	172041	135929	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1960 Beach St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6000857.17484	2120992.84894	37.8038891135616	-122.44126758904	(37.8038891135616, -122.44126758904)
171902	171902	213658	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	18 Edgehill Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5994707.10173	2098998.8404	37.7431471335475	-122.460955103903	(37.7431471335475, -122.460955103903)
171494	171494	179009	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	600 Edinburgh St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6002484.54609	2090211.4480599998	37.71946341819061	-122.433434978747	(37.7194634181906, -122.433434978747)
170377	170377	238441	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	701 Waller St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6002300.89062	2108786.03692	37.7704544602248	-122.43539780488899	(37.7704544602248, -122.435397804889)
170214	170214	201292	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	82 Lydia Ave	1	: 4	Tree 1	Private 1			2	Width 2ft		6012604.14806	2093027.6922900002	37.7277651940081	-122.398652533104	(37.7277651940081, -122.398652533104)
170124	170124	179016	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	70 Curtis St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		6000604.90599	2088146.70208	37.713687269620706	-122.439784232863	(37.7136872696207, -122.439784232863)
169968	169968	246593	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	22 Waller St	4	: 4	Tree 1	Private 1			2	Width 3ft		6005556.53311	2109286.77456	37.7720137218797	-122.424172128036	(37.7720137218797, -122.424172128036)
169854	169854	214671	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	2472 15th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991737.91746	2098617.8202400003	37.741929649338495	-122.47119390160299	(37.7419296493385, -122.471193901603)
169844	169844	238041	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	38 Dolores St	7	: 4	Tree 1	Private 1			2	Width 4ft		6004732.58551	2107964.8947400004	37.7683376027325	-122.426928066278	(37.7683376027325, -122.426928066278)
169494	169494	179106	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	180 Trumbull St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004534.83526	2094298.9310700002	37.730802854758295	-122.426638793939	(37.7308028547583, -122.426638793939)
169219	169219	124346	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	804 Balboa St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993044.54414	2111416.29684	37.777146414825204	-122.467606586696	(37.7771464148252, -122.467606586696)
169127	169127	213485	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	266 Magellan Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5994672.963719999	2100339.90318	37.74682739138329	-122.46117033057301	(37.7468273913833, -122.461170330573)
168858	168858	117913	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	893 40th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5983541.21756	2109770.57795	37.7720744705229	-122.500359367665	(37.7720744705229, -122.500359367665)
168168	168168	213448	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	4 Cortes Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5993184.39566	2099612.1282900004	37.7447433294416	-122.46626473273199	(37.7447433294416, -122.466264732732)
167375	167375	213574	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	401 Dewey Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5995184.75747	2100395.85805	37.747010469052206	-122.45940466010201	(37.7470104690522, -122.459404660102)
167291	167291	238435	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	288 States St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6000346.17489	2106832.48905	37.76497929947371	-122.442018912365	(37.7649792994737, -122.442018912365)
166971	166971	238063	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	100 Manchester St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008227.615119999	2099350.5643599997	37.7448816154881	-122.414229497799	(37.7448816154881, -122.414229497799)
166772	166772	237090	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1600 15th St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6006663.587230001	2107332.32887	37.766709722802	-122.420203999914	(37.766709722802, -122.420203999914)
166746	166746	117912	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	889 40th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		5983541.524809999	2109784.94999	37.772113950042794	-122.50035936764999	(37.7721139500428, -122.50035936765)
166664	166664	179032	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	33 Tucker Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6010961.719880001	2088492.90138	37.7152219465056	-122.40401147266199	(37.7152219465056, -122.404011472662)
166643	166643	213570	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	10 Merced Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5995304.50078	2100206.2944900002	37.7464968590373	-122.458976877776	(37.7464968590373, -122.458976877776)
166392	166392	237098	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	494 14th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6005544.2957	2107858.77307	37.768092081506	-122.4241128861	(37.768092081506, -122.4241128861)
166312	166312	68274	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	530 Bowdoin St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/09/1993 12:00:00 AM	2		Permit Number 32081	6008779.93848	2093554.1542200001	37.7289969414408	-122.411910130973	(37.7289969414408, -122.411910130973)
166199	166199	237155	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	2633 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6010233.89727	2104544.53715	37.7592556056806	-122.407658263141	(37.7592556056806, -122.407658263141)
166051	166051	64856	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	18 Almaden Ct	1	Sidewalk: Property side : Cutout 5	Tree 1	Private 1	FUF 1	02/03/1989 12:00:00 AM	2		Permit Number 25872	5995898.09877	2112568.97781	37.7804757138181	-122.45781873289499	(37.7804757138181, -122.457818732895)
165923	165923	178982	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	38 Whipple Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5998252.81183	2087192.10261	37.7109319923872	-122.447845208002	(37.7109319923872, -122.447845208002)
165767	165767	135928	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1960 Beach St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6000881.44205	2120995.2314	37.8038970374844	-122.44118378211901	(37.8038970374844, -122.441183782119)
165739	165739	178983	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	38 Whipple Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5998242.85384	2087202.59008	37.710960219414794	-122.447880379569	(37.7109602194148, -122.447880379569)
165506	165506	95992	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	858 31st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/29/2011 12:00:00 AM	2	3x3	Permit Number 767644	5986371.40114	2110056.12968	37.7730242344515	-122.490590683906	(37.7730242344515, -122.490590683906)
165401	165401	237217	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1534 Sanchez St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6003930.11412	2099322.52853	37.7445623031129	-122.429087459028	(37.7445623031129, -122.429087459028)
165191	165191	213480	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	270 San Leandro Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992360.2599	2095044.9531599998	37.7321554342216	-122.46878213389401	(37.7321554342216, -122.468782133894)
164612	164612	214512	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1201 Irving St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991834.49252	2106555.8498	37.7637309964006	-122.47143825366501	(37.7637309964006, -122.471438253665)
163656	163656	214755	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	91 Eastwood Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5995604.814669999	2093235.4981099998	37.72737401768921	-122.457434195154	(37.7273740176892, -122.457434195154)
163545	163545	238531	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	32 Gough St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6006504.27757	2109384.99653	37.7723368824788	-122.420900775765	(37.7723368824788, -122.420900775765)
161742	161742	238071	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	23 Newman St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6007048.14172	2096819.42753	37.7378653549101	-122.41812849593501	(37.7378653549101, -122.418128495935)
161728	161728	179021	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	5642 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5998317.810930001	2087173.37189	37.7108842770725	-122.447619209286	(37.7108842770725, -122.447619209286)
161354	161354	213697	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	123 Staples Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5999258.3191599995	2093769.35408	37.7290490382604	-122.44484243372601	(37.7290490382604, -122.444842433726)
161006	161006	123799	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1900 Anza St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992759.08391	2112088.12025	37.7789745741229	-122.468642970342	(37.7789745741229, -122.468642970342)
160605	160605	237095	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1600 15th St	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6006471.77901	2107323.9095799997	37.7666757958826	-122.42086683535801	(37.7666757958826, -122.420866835358)
160563	160563	213398	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	621 Quintara St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5991517.42633	2101098.4611299997	37.7487280941444	-122.472137056592	(37.7487280941444, -122.472137056592)
160182	160182	214715	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	106 Aptos Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993029.000080001	2094275.40431	37.7300810552916	-122.466414259408	(37.7300810552916, -122.466414259408)
159334	159334	196508	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	97 Whitney Young Cir	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6016637.34398	2094986.73553	37.7333682203685	-122.38484598815901	(37.7333682203685, -122.384845988159)
159082	159082	196493	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	728 Brannan St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6012209.40916	2110147.41872	37.7747502473676	-122.401219664968	(37.7747502473676, -122.401219664968)
158895	158895	92228	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	819 38th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/10/2009 12:00:00 AM	2	3x3	Permit Number 52552	5984148.0757	2110235.49072	37.77338659024161	-122.498294572929	(37.7733865902416, -122.498294572929)
157988	157988	96028	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	730 Larkin St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/02/2011 12:00:00 AM	2	3x3	Permit Number 767669	6007516.24853	2113853.8784	37.784664348435605	-122.417717077682	(37.7846643484356, -122.417717077682)
157289	157289	178971	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	509 Sunnydale Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6010024.16897	2086365.7166900001	37.7093287026266	-122.407102219496	(37.7093287026266, -122.407102219496)
157195	157195	96899	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	334 28th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/05/2011 12:00:00 AM	2	4x4	Permit Number 768036	5987170.52326	2113675.9123	37.783009778520004	-122.488092492463	(37.78300977852, -122.488092492463)
157025	157025	239438	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	221 Mateo St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		6003961.12868	2096293.81528	37.7362479053017	-122.428764347015	(37.7362479053017, -122.428764347015)
156931	156931	48689	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	455 Raymond Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/12/2002 12:00:00 AM	2		Permit Number 45968	6008469.24313	2088342.73235	37.714670039767	-122.412615977341	(37.714670039767, -122.412615977341)
156694	156694	123031	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	722 Funston Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991970.8857	2110474.96476	37.7744997243223	-122.47125207498101	(37.7744997243223, -122.471252074981)
156389	156389	237422	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	4301 Cesar Chavez St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6001870.20267	2100293.29373	37.747110974593895	-122.436279668393	(37.7471109745939, -122.436279668393)
156360	156360	213359	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	95 Beachmont Dr	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 4ft		5990836.58141	2095246.30718	37.7326201579899	-122.474064462004	(37.7326201579899, -122.474064462004)
156323	156323	213482	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1 Sola Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5994974.838219999	2100674.05314	37.7477622510295	-122.460150689121	(37.7477622510295, -122.460150689121)
156020	156020	95931	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	691 27th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/29/2011 12:00:00 AM	2	3x3	Permit Number 767628	5987521.80961	2111256.95198	37.7763884852693	-122.486699521672	(37.7763884852693, -122.486699521672)
155866	155866	237367	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	825 South Van Ness Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6007577.28198	2104824.61202	37.7598755560284	-122.41686598986901	(37.7598755560284, -122.416865989869)
155672	155672	214505	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1961 11th Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5992842.05434	2102218.37849	37.751879666633	-122.46763797592399	(37.751879666633, -122.467637975924)

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