Street_Tree_List

Data source: data.sfgov.org

221 rows where qSiteInfo = 2 and qSpecies = 12 sorted by PlotSize

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, qCaretaker, PlantDate, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize ▼	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
4008	4008	216051	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	48 Lobos St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/05/2017 02:54:00 PM	3			5996419.4156599995	2088710.03455	37.7149949180514	-122.454291392827	(37.7149949180514, -122.454291392827)
4030	4030	216055	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	52 Lobos St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/05/2017 02:49:00 PM	3			5996381.618969999	2088696.9088599999	37.714956710372	-122.454421085891	(37.714956710372, -122.454421085891)
4092	4092	216045	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	36 Lobos St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/05/2017 03:04:00 PM	3			5996513.0629	2088696.2251900001	37.7149623706927	-122.45396671331999	(37.7149623706927, -122.45396671332)
4097	4097	216058	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	58 Lobos St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/05/2017 02:35:00 PM	3			5996320.31527	2088710.5585599998	37.7149906732676	-122.45463396169599	(37.7149906732676, -122.454633961696)
4103	4103	216046	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	38 Lobos St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/05/2017 03:02:00 PM	3			5996487.74032	2088710.41168	37.7149998715299	-122.454055262356	(37.7149998715299, -122.454055262356)
4117	4117	216048	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	40 Lobos St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/05/2017 02:58:00 PM	3			5996463.1782599995	2088711.43982	37.7150012861457	-122.45414023299999	(37.7150012861457, -122.454140233)
9934	9934	102961	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	4	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9935	9935	102960	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9936	9936	102965	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	9	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9937	9937	102966	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	10	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9939	9939	102963	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	6	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9940	9940	102969	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	12	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9941	9941	102968	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	11	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9943	9943	102967	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	13	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9945	9945	102971	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	18	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
50546	50546	175255	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	623 London St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7			6001218.45096	2090165.8751700001	37.7192663722334	-122.43780813275801	(37.7192663722334, -122.437808132758)
55457	55457	204035	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	90 Lobos St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			5995982.61422	2088710.65724	37.714971568951896	-122.455801199883	(37.7149715689519, -122.455801199883)
69036	69036	204033	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	90 Lobos St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11			5996016.24569	2088710.21208	37.7149722767379	-122.45568492382401	(37.7149722767379, -122.455684923824)
80442	80442	94324	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	501@ 28th Ave El Camino Del Mar	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		07/15/2010 12:00:00 AM			Permit Number 53625	5987118.0	2115378.0	37.7876801589176	-122.488399329426	(37.7876801589176, -122.488399329426)
91005	91005	102964	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	8	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
98037	98037	94322	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	501 El Camino Del Mar	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		07/15/2010 12:00:00 AM			Permit Number 53625	5987118.0	2115378.0	37.7876801589176	-122.488399329426	(37.7876801589176, -122.488399329426)
105503	105503	94325	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	501@ 28th Ave El Camino Del Mar	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		07/15/2010 12:00:00 AM			Permit Number 53625	5987118.0	2115378.0	37.7876801589176	-122.488399329426	(37.7876801589176, -122.488399329426)
108814	108814	94323	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	501@ 28th Ave El Camino Del Mar	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		07/15/2010 12:00:00 AM			Permit Number 53625	5987118.0	2115378.0	37.7876801589176	-122.488399329426	(37.7876801589176, -122.488399329426)
126914	126914	94321	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	501 El Camino Del Mar	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		07/15/2010 12:00:00 AM			Permit Number 53625	5987118.0	2115378.0	37.7876801589176	-122.488399329426	(37.7876801589176, -122.488399329426)
178749	178749	219643	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	453 Valley St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19			6003027.9388	2099186.49327	37.7441376711314	-122.432197284976	(37.7441376711314, -122.432197284976)
183782	183782	204034	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	90 Lobos St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			5995999.69668	2088710.81573	37.7149729844955	-122.455742167474	(37.7149729844955, -122.455742167474)
9944	9944	11821	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2	3		5991432.171815401	2088660.0347764	37.7145703669544	-122.47152561846501	(37.7145703669544, -122.471525618465)
9947	9947	11824	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	14	Sidewalk: Curb side : Yard 2	Tree 1	PUC 13		03/13/2013 12:00:00 AM	2	3		5991432.171815401	2088660.0347764	37.7145703669544	-122.47152561846501	(37.7145703669544, -122.471525618465)
25309	25309	184952	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	16	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5983556.4384	2101472.9274	37.749292356781794	-122.49969333533701	(37.7492923567818, -122.499693335337)
41231	41231	184943	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5983564.899	2101252.9532	37.7486888648876	-122.49964782319401	(37.7486888648876, -122.499647823194)
45706	45706	183641	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1484 47th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5981572.5337	2105003.3239	37.7588692133791	-122.50681542120701	(37.7588692133791, -122.506815421207)
49921	49921	140789	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	73 COMMONWEALTH AVE	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5996497.6882	2114040.8979	37.78455164386521	-122.455850917712	(37.7845516438652, -122.455850917712)
65600	65600	183836	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2217 28th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5987592.2696	2100164.3317	37.7459352931926	-122.485641503597	(37.7459352931926, -122.485641503597)
70157	70157	184950	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5983557.7921	2101427.5789	37.749167921775296	-122.499685303057	(37.7491679217753, -122.499685303057)
125056	125056	183143	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2315 38th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5984514.4702	2099409.3038	37.743682379514496	-122.49622825542	(37.7436823795145, -122.49622825542)
129935	129935	184951	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	15	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5983556.4384	2101452.6221	37.7492366040439	-122.49969183478001	(37.7492366040439, -122.49969183478)
134243	134243	184946	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5983561.8532	2101319.6223	37.7488717410938	-122.49966328209801	(37.7488717410938, -122.499663282098)
147983	147983	184948	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5983561.1763	2101354.4797	37.7489674101607	-122.49966819869101	(37.7489674101607, -122.499668198691)
148859	148859	181851	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2301 25th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5988541.8992	2099607.3772	37.744461328811	-122.482317054002	(37.744461328811, -122.482317054002)
149507	149507	245035	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	21 Baker St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 0ft		6000804.6982	2109205.0004	37.7715197437189	-122.44060318310899	(37.7715197437189, -122.440603183109)
154638	154638	184947	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5983560.8379	2101339.2508	37.7489255759542	-122.49966824346701	(37.7489255759542, -122.499668243467)
154783	154783	183727	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2255 35th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5985430.1991	2099855.1597	37.744960177470205	-122.493094769051	(37.7449601774702, -122.493094769051)
182404	182404	182722	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1723 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5985925.1892	2103477.2512	37.754934393373496	-122.49164978734801	(37.7549343933735, -122.491649787348)
184799	184799	184945	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5983563.2069	2101296.9480000003	37.7488095631642	-122.49965692549101	(37.7488095631642, -122.499656925491)
186739	186739	184949	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5983558.4689	2101406.2583	37.749109421016605	-122.499681387134	(37.7491094210166, -122.499681387134)
188784	188784	184377	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1521 Rivera St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 0ft		5988408.1936	2100317.5308	37.7464034445307	-122.48283140934299	(37.7464034445307, -122.482831409343)
188944	188944	184944	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5983563.2069	2101275.9659	37.748751952115505	-122.49965537495702	(37.7487519521155, -122.499655374957)
33674	33674	204896	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	764 Faxon Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 10ft		5994905.36147	2093121.02755	37.7270195085424	-122.459843899792	(37.7270195085424, -122.459843899792)
47608	47608	204897	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	764 Faxon Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 10ft		5994906.12199	2093130.5218200001	37.7270456212503	-122.459841958143	(37.7270456212503, -122.459841958143)
26486	26486	204793	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1998 16th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 2ft		5991300.85589	2101853.1475400003	37.7507877313777	-122.47294097314399	(37.7507877313777, -122.472940973144)
30300	30300	219757	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1335 Douglass St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 2ft		6001386.79678	2099806.89214	37.7457479531147	-122.43791640932601	(37.7457479531147, -122.437916409326)
32069	32069	204794	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1998 16th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 2ft		5991301.04243	2101880.01512	37.750861513549104	-122.47294228706998	(37.7508615135491, -122.47294228707)
33835	33835	188022	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1001 17th St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 2ft		6014182.1741	2106635.38485	37.7652168437069	-122.394149489126	(37.7652168437069, -122.394149489126)
43219	43219	188023	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1001 17th St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 2ft		6014199.363390001	2106636.17997	37.765219982328794	-122.39409009070101	(37.7652199823288, -122.394090090701)
57567	57567	188053	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1133 19th St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 2ft		6014102.5404900005	2105239.77863	37.7613803880171	-122.39432720234	(37.7613803880171, -122.39432720234)
130647	130647	204779	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1811 17th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 2ft		5990906.362980001	2103054.34687	37.754063063173	-122.4743927982	(37.754063063173, -122.4743927982)
163862	163862	218200	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	950 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 2ft		5993085.15224	2098374.09173	37.741338267754294	-122.466517926976	(37.7413382677543, -122.466517926976)
171033	171033	119594	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	3145 Cabrillo St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 2ft		5985824.5308	2110420.315	37.7739922254809	-122.492509174554	(37.7739922254809, -122.492509174554)
171665	171665	219756	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1335 Douglass St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 2ft		6001388.58619	2099788.88641	37.7456986154004	-122.43790893236601	(37.7456986154004, -122.437908932366)
181866	181866	188021	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1001 17th St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 2ft		6014166.75536	2106634.96887	37.7652148445035	-122.394202790137	(37.7652148445035, -122.394202790137)
5245	5245	205593	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	30 Vasquez Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5995699.652000001	2100090.8564	37.746202601761105	-122.45760214624201	(37.7462026017611, -122.457602146242)
24381	24381	205069	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	851 Junipero Serra Blvd	17	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5991341.17231	2091818.7337900002	37.723238113832004	-122.472070242354	(37.723238113832, -122.472070242354)
27670	27670	175373	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	10 Junipero Serra Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5991419.90979	2088711.03664	37.714709696259	-122.47157171488001	(37.714709696259, -122.47157171488)
29542	29542	204015	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	551 Junipero Serra Blvd	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5991438.06872	2093352.05067	37.7274538280107	-122.471846988354	(37.7274538280107, -122.471846988354)
37736	37736	204020	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	551 Junipero Serra Blvd	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5991454.51812	2093597.0788	37.728127565922705	-122.47180797308701	(37.7281275659227, -122.471807973087)
39744	39744	205073	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	751 Junipero Serra Blvd	19	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5991394.04021	2092661.17243	37.7255543006814	-122.47194886087601	(37.7255543006814, -122.471948860876)
41405	41405	204016	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	551 Junipero Serra Blvd	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5991440.790709999	2093391.9529099998	37.7275635471128	-122.471840485364	(37.7275635471128, -122.471840485364)
42037	42037	204175	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	415 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5995528.599640001	2098373.4321	37.7414771536607	-122.45806934943501	(37.7414771536607, -122.458069349435)
42441	42441	204851	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	601 Moraga St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5992413.95812	2103855.80191	37.7563508791033	-122.469237546073	(37.7563508791033, -122.469237546073)
48479	48479	175295	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	760 Mansell St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		6009602.37667	2090145.4297599997	37.719683405831596	-122.408826494165	(37.7196834058316, -122.408826494165)
49729	49729	188199	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	251 Executive Park Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		6014599.16354	2086984.8296400001	37.7112836335959	-122.39133342311399	(37.7112836335959, -122.391333423114)
50475	50475	175375	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	10 Junipero Serra Blvd	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5991400.23386	2088781.3625299998	37.714901655675995	-122.471644844135	(37.714901655676, -122.471644844135)
53202	53202	204856	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	107 Noriega St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5993700.38714	2103218.6773	37.7546757514867	-122.464742397259	(37.7546757514867, -122.464742397259)
53867	53867	204800	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	0 16th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5991281.57381	2102416.71556	37.752334025717296	-122.473048745206	(37.7523340257173, -122.473048745206)
54129	54129	175293	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	760 Mansell St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		6009631.71188	2090153.71455	37.719707797252	-122.408725676556	(37.719707797252, -122.408725676556)
55626	55626	175292	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	760 Mansell St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		6009643.78168	2090157.44944	37.7197187285063	-122.40868421872	(37.7197187285063, -122.40868421872)
57453	57453	175343	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	19 Rhine St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 3ft		5994542.86208	2086742.78517	37.709485521912605	-122.460635037876	(37.7094855219126, -122.460635037876)
58288	58288	205072	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	751 Junipero Serra Blvd	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5991383.28379	2092507.8006	37.7251325573133	-122.471974871051	(37.7251325573133, -122.471974871051)
60247	60247	188200	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	251 Executive Park Blvd	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		6014523.7676099995	2086992.1522	37.711299555189	-122.39159452417101	(37.711299555189, -122.391594524171)
64718	64718	205070	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	851 Junipero Serra Blvd	18	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5991342.25966	2091840.5648	37.723298119304204	-122.47206807409599	(37.7232981193042, -122.472068074096)
67782	67782	205074	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	751 Junipero Serra Blvd	25	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5991407.03171	2092831.35427	37.7260223294526	-122.471916348573	(37.7260223294526, -122.471916348573)
68705	68705	205067	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	851 Junipero Serra Blvd	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5991317.51036	2091469.56547	37.7222780146925	-122.472126597471	(37.7222780146925, -122.472126597471)
69802	69802	204021	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	551 Junipero Serra Blvd	17	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5991459.5718	2093688.12881	37.728377858931296	-122.471797135346	(37.7283778589313, -122.471797135346)
70311	70311	204799	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1908 16th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 3ft		5991285.361819999	2102398.09072	37.7522831060881	-122.473034287704	(37.7522831060881, -122.473034287704)
70564	70564	204018	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	551 Junipero Serra Blvd	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5991449.35065	2093530.38125	37.7279441320989	-122.47182097817699	(37.7279441320989, -122.471820978177)
71573	71573	204816	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1801 08th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5993723.6347	2103184.07069	37.7545820709068	-122.46465948875	(37.7545820709068, -122.46465948875)
73739	73739	175291	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	760 Mansell St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		6009654.09319	2090160.7223599998	37.7197282927946	-122.40864880611	(37.7197282927946, -122.40864880611)
75694	75694	205066	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	851 Junipero Serra Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5991309.913369999	2091317.3694799999	37.7218596824662	-122.472141769924	(37.7218596824662, -122.472141769924)
130948	130948	204852	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	601 Moraga St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5992428.45263	2103856.05172	37.7563524025705	-122.46918743764401	(37.7563524025705, -122.469187437644)
147559	147559	124079	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	701 Funston Ave	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5991941.58389	2110150.4186299997	37.7736069135372	-122.471329782846	(37.7736069135372, -122.471329782846)
148220	148220	175296	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	760 Mansell St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		6009588.23355	2090141.41392	37.7196715869614	-122.40887509890499	(37.7196715869614, -122.408875098905)
150513	150513	188202	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	251 Executive Park Blvd	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		6014410.24908	2087000.56675	37.711316358145794	-122.39198746407101	(37.7113163581458, -122.391987464071)
153053	153053	205075	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	751 Junipero Serra Blvd	28	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5991410.23162	2092923.6944900001	37.72627605788671	-122.471912013823	(37.7262760578867, -122.471912013823)
154011	154011	221012	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	675 Sanchez St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		6003707.3772	2104386.93833	37.7584553727299	-122.43021887361401	(37.7584553727299, -122.430218873614)
156853	156853	205068	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	851 Junipero Serra Blvd	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5991321.67962	2091578.12457	37.7225763324184	-122.47212009448799	(37.7225763324184, -122.472120094488)
157424	157424	204017	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	551 Junipero Serra Blvd	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5991443.38091	2093425.61385	37.727656121533705	-122.47183398327499	(37.7276561215337, -122.471833983275)
165533	165533	175297	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	800 Mansell St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		6009452.06912	2090099.6823599997	37.7195493726733	-122.409342829102	(37.7195493726733, -122.409342829102)
168337	168337	204795	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1964 16th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		5991296.36687	2102036.80057	37.7512917348225	-122.47296988727501	(37.7512917348225, -122.472969887275)
170322	170322	188198	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	251 Executive Park Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		6014615.61789	2086983.20072	37.711280074094205	-122.39127643847999	(37.7112800740942, -122.39127643848)
171931	171931	204019	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	551 Junipero Serra Blvd	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5991451.54656	2093545.31958	37.727985276083395	-122.47181447517	(37.7279852760834, -122.47181447517)

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