Street_Tree_List

Data source: data.sfgov.org

288 rows where DBH = 2 and qSpecies = 18 sorted by qAddress

Search:

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by TreeID Sort by qLegalStatus Sort by qSpecies Sort by qAddress Sort by SiteOrder Sort by qSiteInfo Sort by PlantType Sort by qCaretaker Sort by qCareAssistant Sort by PlantDate Sort by DBH Sort by PlotSize Sort by PermitNotes Sort by XCoord Sort by YCoord Sort by Latitude Sort by Longitude Sort by Location

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
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)
50305	50305	213569	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	10 Merced Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5995296.87532	2100197.80172	37.7464731016692	-122.459002630776	(37.7464731016692, -122.459002630776)
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)
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)
45242	45242	213576	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	100 Pacheco St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5994554.1980800005	2099981.39248	37.7458361756945	-122.46155502007299	(37.7458361756945, -122.461555020073)
3084	3084	238169	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1018 Noe St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/24/1989 12:00:00 AM	2	Width 4ft	Permit Number 27197	6003120.08624	2102266.16095	37.7525989407879	-122.432098539422	(37.7525989407879, -122.432098539422)
76252	76252	136003	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1043 Mason St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009481.94772	2116801.23595	37.7928675009884	-122.411124650506	(37.7928675009884, -122.411124650506)
83146	83146	121562	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1046 Sanchez St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		6003754.0	2102204.0	37.7524641810183	-122.42990192261499	(37.7524641810183, -122.429901922615)
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)
69153	69153	237112	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1101 San Jose Ave	16	Front Yard : Yard 7	Tree 1	Private 1			2			6004834.0708099995	2096408.3013799998	37.736611626213495	-122.425754370088	(37.7366116262135, -122.425754370088)
89616	89616	237113	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1101 San Jose Ave	17	Front Yard : Yard 7	Tree 1	Private 1			2			6004838.14282	2096415.36394	37.7366312485184	-122.425740793928	(37.7366312485184, -122.425740793928)
130170	130170	237114	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1101 San Jose Ave	18	Front Yard : Yard 7	Tree 1	Private 1			2			6004844.31996	2096418.97753	37.736641519684504	-122.425719694004	(37.7366415196845, -122.425719694004)
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)
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)
33954	33954	214718	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	120 Westgate Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993393.66752	2093805.3618400001	37.7288114697568	-122.465119441606	(37.7288114697568, -122.465119441606)
135163	135163	214514	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1201 Irving St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991913.63923	2106558.50977	37.7637428782486	-122.471164705988	(37.7637428782486, -122.471164705988)
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)
87590	87590	91928	DPW Maintained 3	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1201X IRVING ST	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/19/2009 12:00:00 AM	2	3x3		5992070.0	2106573.0	37.7637917074669	-122.470624962715	(37.7637917074669, -122.470624962715)
98111	98111	91929	DPW Maintained 3	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1201X IRVING ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/11/2014 12:00:00 AM	2	3x3		5992070.0	2106573.0	37.7637917074669	-122.470624962715	(37.7637917074669, -122.470624962715)
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)
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)
76027	76027	213474	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	125 Dorantes Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5993866.67958	2099897.14622	37.7455652594364	-122.463926229234	(37.7455652594364, -122.463926229234)
47651	47651	214645	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1256 08th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		5993641.37954	2106958.7171099996	37.764941526166396	-122.46521810353201	(37.7649415261664, -122.465218103532)
38000	38000	214644	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1256 09th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5993333.17302	2106942.2711	37.764878591599704	-122.466282908025	(37.7648785915997, -122.466282908025)
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)
152222	152222	179105	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	126 Trumbull St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6004219.82639	2094286.1611799998	37.7307499773192	-122.427726920565	(37.7307499773192, -122.427726920565)
26031	26031	238323	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	129 Danvers St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5999937.71667	2105097.48598	37.7601921263874	-122.443307034709	(37.7601921263874, -122.443307034709)
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)
31599	31599	218216	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	130 Lenox Way	1	: 4	Tree 1	Private 1			2	Width 2ft		5993396.63989	2098589.94545	37.7419489172986	-122.465456597447	(37.7419489172986, -122.465456597447)
39340	39340	238493	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1314 Castro St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6002509.40645	2101693.40172	37.750991638256295	-122.434169431668	(37.7509916382563, -122.434169431668)
26159	26159	238177	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1333 Castro St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6002578.9962	2101606.95929	37.7507582372102	-122.43392260556999	(37.7507582372102, -122.43392260557)
49350	49350	237136	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1346 York St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 6ft		6010061.84572	2101335.33586	37.7504342222613	-122.40802698336901	(37.7504342222613, -122.408026983369)
32494	32494	179102	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	135 Craut St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004051.16086	2094125.98713	37.730300632864896	-122.428298612397	(37.7303006328649, -122.428298612397)
154120	154120	179104	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	135 Craut St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004049.57525	2094157.9447400002	37.730388291584504	-122.42830637085	(37.7303882915845, -122.42830637085)
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)
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)
34079	34079	239451	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	135 Swiss Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6001309.11459	2096395.72955	37.736377283592	-122.437940733303	(37.736377283592, -122.437940733303)
130055	130055	239453	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	135 Swiss Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6001276.15885	2096445.71033	37.7365126450403	-122.438058253984	(37.7365126450403, -122.438058253984)
50571	50571	214615	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1381 09th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5993310.7573	2106091.15894	37.7625403677758	-122.466298577838	(37.7625403677758, -122.466298577838)
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)
49337	49337	213548	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	140 Colon Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5996162.65905	2093980.6549	37.729452065849294	-122.455559574538	(37.7294520658493, -122.455559574538)
44011	44011	214579	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1409 Irving St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991361.73298	2106537.8564299997	37.7636542311812	-122.473072054748	(37.7636542311812, -122.473072054748)
27648	27648	214621	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1415 12th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992391.88162	2105788.8525099996	37.7616572533136	-122.469454599246	(37.7616572533136, -122.469454599246)
125280	125280	47314	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1420 Hampshire St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/10/2002 12:00:00 AM	2		Permit Number 45244	6010384.18455371	2100995.83638931	37.7495200736312	-122.406888381765	(37.7495200736312, -122.406888381765)
62678	62678	214627	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1448 11th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992756.23431	2105602.64255	37.7611670193557	-122.46818091553699	(37.7611670193557, -122.468180915537)
41067	41067	239466	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1476 Willard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5996878.53195	2106155.72843	37.762922869208495	-122.453963675406	(37.7629228692085, -122.453963675406)
36774	36774	69416	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	148 Seville St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/09/1994 12:00:00 AM	2		Permit Number 33521	6001460.481240001	2087339.3254900002	37.7115190554232	-122.436769298869	(37.7115190554232, -122.436769298869)
154072	154072	238127	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	149 29th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6005567.2086	2099023.8959999997	37.7438348612885	-122.423405482081	(37.7438348612885, -122.423405482081)
137004	137004	196478	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1499 Rankin St	2	Side Yard : Yard 17	Tree 1	Private 1			2	Width 3ft		6012656.37794	2096656.5486400002	37.7377321913814	-122.39872653201799	(37.7377321913814, -122.398726532018)
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)
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)
50816	50816	214567	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1550 Irving St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5990896.39166	2106586.0775	37.763759680286604	-122.47468502841299	(37.7637596802866, -122.474685028413)
66290	66290	214629	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1552 08th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993710.5818300005	2104918.8610799997	37.7593446043956	-122.464830603648	(37.7593446043956, -122.464830603648)
45985	45985	84283	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	156 Tioga Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/05/2008 12:00:00 AM	2	3x3	Permit Number 50701	6010175.00365	2089148.86152	37.7169790922895	-122.40677692123501	(37.7169790922895, -122.406776921235)
153524	153524	84212	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	156 Tioga Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/05/2008 12:00:00 AM	2	3x3	Permit Number 50701	6010164.59248	2089152.68925	37.7169890199119	-122.406813177404	(37.7169890199119, -122.406813177404)
72745	72745	213369	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1563 Funston Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992113.9889	2104807.12798	37.7589456327602	-122.47034421221599	(37.7589456327602, -122.470344212216)
31074	31074	237092	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1600 15th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6006640.82063	2107331.42339	37.766705953729	-122.420282681595	(37.766705953729, -122.420282681595)
53796	53796	237094	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1600 15th St	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6006486.26316	2107324.29875	37.7666776808499	-122.420816764707	(37.7666776808499, -122.420816764707)
68328	68328	237091	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1600 15th St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6006652.5626300005	2107332.55511	37.7667097228027	-122.42024214826598	(37.7667097228027, -122.420242148266)
134644	134644	237087	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1600 15th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6006704.33245	2107335.9547099997	37.7667219742591	-122.420063326182	(37.7667219742591, -122.420063326182)
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)
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)
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)
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)
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)
23681	23681	237227	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	165 Grattan St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		5997877.39625	2106473.17188	37.763851709710394	-122.450531852572	(37.7638517097104, -122.450531852572)
74442	74442	237228	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	165 Grattan St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5997909.873980001	2106480.5106	37.7638737188236	-122.450420051547	(37.7638737188236, -122.450420051547)
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)
150376	150376	238216	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	168 Clipper St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004032.07486	2101029.71976	37.7492556256447	-122.428856584177	(37.7492556256447, -122.428856584177)
110438	110438	12424	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1701X Laguna St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/23/2015 12:00:00 AM	2	4X4		6004421.35326	2114759.5543400003	37.7869764624576	-122.428488960967	(37.7869764624576, -122.428488960967)
29079	29079	238214	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	173 Clipper St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004038.9586	2100983.92112	37.7491302628649	-122.428829515491	(37.7491302628649, -122.428829515491)
74731	74731	238217	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	176 Clipper St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6003968.73895	2101027.68461	37.749246452563604	-122.42907545578699	(37.7492464525636, -122.429075455787)
146355	146355	202308	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	178 Orsi Cir	1	: 4	Tree 1	Private 1			2	Width 2ft		6013012.36975	2092926.2043	37.7275092640335	-122.39723417993099	(37.7275092640335, -122.397234179931)
153765	153765	213679	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	179 Brompton Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6002057.4367	2095052.6356900001	37.7327319832836	-122.435257434207	(37.7327319832836, -122.435257434207)
41298	41298	179046	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	179 Santa Rosa Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6001233.0942400005	2093248.7296099998	37.727732024306796	-122.437978219718	(37.7277320243068, -122.437978219718)
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)
137048	137048	124183	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	18 Almaden Ct	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5995879.71577	2112592.37489	37.7805388998707	-122.45788402155199	(37.7805388998707, -122.457884021552)
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)
52836	52836	213657	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	18 Edgehill Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5994715.35615	2099021.32381	37.7432093423507	-122.46092819170099	(37.7432093423507, -122.460928191701)
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)
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)
57276	57276	213677	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	182 Lippard Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6001809.23817	2095209.0401400002	37.7331473360722	-122.43612670538	(37.7331473360722, -122.43612670538)
154842	154842	213386	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1846 10th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993160.52883	2102907.84462	37.7537911459483	-122.466586765563	(37.7537911459483, -122.466586765563)
149087	149087	123798	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1900 Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992773.6819	2112088.5545	37.7789766097312	-122.468592502086	(37.7789766097312, -122.468592502086)
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)
140542	140542	121578	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	192X Upper Ter	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		5999692.0	2106609.0	37.7643283535961	-122.44426547040001	(37.7643283535961, -122.4442654704)
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)
39978	39978	196453	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1950 Cesar Chavez St	7	: 4	Tree 1	Private 1			2	Width 3ft		6012987.92898	2101021.89129	37.749736965294794	-122.39788632150601	(37.7497369652948, -122.397886321506)
154793	154793	135930	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1960 Beach St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6000826.2402099995	2120988.3379599997	37.8038749654115	-122.441374316075	(37.8038749654115, -122.441374316075)
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)
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)
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)
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)
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)
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)
154208	154208	196449	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	2 Madera St	3	: 4	Tree 1	Private 1			2	Width 3ft		6012958.79837	2103280.94306	37.7559382107998	-122.398145525023	(37.7559382107998, -122.398145525023)
29090	29090	238061	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	2 Montezuma St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6007362.55888	2099757.0495599997	37.7459491035629	-122.417249508474	(37.7459491035629, -122.417249508474)
43992	43992	238062	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	2 Montezuma St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6007370.57854	2099757.5498	37.745950928290604	-122.417221812951	(37.7459509282906, -122.417221812951)
40213	40213	213483	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	200 Magellan Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5994968.55628	2100619.47305	37.74761202648929	-122.460168457927	(37.7476120264893, -122.460168457927)
37368	37368	213397	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	2011 15th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5991583.99315	2101696.28864	37.7503734254013	-122.47195043737301	(37.7503734254013, -122.471950437373)

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