Street_Tree_List

Data source: data.sfgov.org

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

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
1878	1878	251764	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	187 Seville St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1				Width 6ft		6001178.343719999	2087386.3168	37.7116320444605	-122.43774780171302	(37.7116320444605, -122.437747801713)
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)
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)
27130	27130	125607	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	3598 Clay St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5997695.059280001	2115464.41968	37.7885289043451	-122.45181116876002	(37.7885289043451, -122.45181116876)
31119	31119	222045	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	201 Treat Ave	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 6ft		6008941.81103	2107754.9472	37.7679982408485	-122.412353856457	(37.7679982408485, -122.412353856457)
32910	32910	219662	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	101 Carmel St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5998188.58572	2105343.5098200003	37.7607677482651	-122.449374149901	(37.7607677482651, -122.449374149901)
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)
70348	70348	175268	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	17 Curtis St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		6000541.31656	2088471.1421	37.7145744894882	-122.440027270142	(37.7145744894882, -122.440027270142)
118385	118385	250922	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	282 28th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5987155.11745	2114076.2326	37.784108044888	-122.488175216114	(37.784108044888, -122.488175216114)
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)
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)
147087	147087	204950	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	135 Santa Paula Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 6ft		5994024.2821	2096935.7591799998	37.73744311331011	-122.463166429792	(37.7374431133101, -122.463166429792)
172997	172997	250921	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	282 28th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5987155.66741	2114065.86584	37.784079612815795	-122.488172551429	(37.7840796128158, -122.488172551429)
174509	174509	204957	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	460 Pacheco St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 6ft		5993693.78698	2101896.46232	37.7510449078018	-122.464669214927	(37.7510449078018, -122.464669214927)
177173	177173	219663	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	101 Carmel St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5998207.34442	2105345.19067	37.760773436477706	-122.449309393328	(37.7607734364777, -122.449309393328)
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)
188930	188930	250562	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	445 El Camino Del Mar	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5987191.81534	2115294.08526	37.7874540598079	-122.488137777348	(37.7874540598079, -122.488137777348)
2722	2722	175368	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	24	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5993415.10175	2087740.6954	37.7121605985029	-122.464605149022	(37.7121605985029, -122.464605149022)
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)
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)
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)
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)
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)
30613	30613	175346	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5993589.7174	2087738.26685	37.712163995237105	-122.464001454798	(37.7121639952371, -122.464001454798)
31719	31719	218144	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	74 Ridge Ln	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5997132.65616	2090034.31598	37.7186719635242	-122.451921626186	(37.7186719635242, -122.451921626186)
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)
35642	35642	175347	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5993550.997219999	2087766.5420799998	37.712239400706395	-122.464137333384	(37.7122394007064, -122.464137333384)
39282	39282	218139	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	75 Ridge Ln	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		5997090.61313	2090037.45955	37.7186781868339	-122.452067177859	(37.7186781868339, -122.452067177859)
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)
42937	42937	204954	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	155 Santa Paula Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		5994039.534469999	2096838.00818	37.7371755919718	-122.463106605104	(37.7371755919718, -122.463106605104)
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)
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)
46663	46663	250563	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	445 El Camino Del Mar	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5987212.15224	2115286.60227	37.787434700087104	-122.488066866688	(37.7874347000871, -122.488066866688)
59659	59659	218140	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	73 Ridge Ln	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		5997108.39408	2090030.57207	37.7186602939243	-122.452005219979	(37.7186602939243, -122.452005219979)
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)
129800	129800	175351	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5993236.647480001	2087885.91358	37.7125490435751	-122.465232475607	(37.7125490435751, -122.465232475607)
135404	135404	117969	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	414 38th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5984091.66198	2113022.12438	37.7810345721966	-122.49869560869	(37.7810345721966, -122.49869560869)
135636	135636	117968	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	414 38th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5984091.8335	2113030.1543400004	37.781056630188104	-122.498695608696	(37.7810566301881, -122.498695608696)
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)
150936	150936	125586	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1570 Greenwich St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		6005351.57668	2119600.69848	37.800321618997295	-122.425615279117	(37.8003216189973, -122.425615279117)
151357	151357	219778	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	929 Elizabeth St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		6000431.24087	2101957.7943700003	37.751599428891204	-122.44137488264201	(37.7515994288912, -122.441374882642)
171715	171715	175349	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5993438.390819999	2087824.9996200001	37.7123934203956	-122.4645307733	(37.7123934203956, -122.4645307733)
185082	185082	188203	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	251 Executive Park Blvd	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		6014389.30237	2087003.03012	37.7113219591221	-122.39206003394399	(37.7113219591221, -122.392060033944)
185937	185937	175354	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5992875.91855	2087892.32357	37.712545834802604	-122.46647972197901	(37.7125458348026, -122.466479721979)
186888	186888	175547	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	348 Chicago Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		6002373.36986	2086487.8856799998	37.709233027364995	-122.433553309758	(37.709233027365, -122.433553309758)
188924	188924	218143	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	72 Ridge Ln	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5997148.20318	2090029.45832	37.718659516001	-122.451867536453	(37.718659516001, -122.451867536453)
2709	2709	175364	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	15	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5993263.021319999	2087797.41727	37.7123075747038	-122.465134896479	(37.7123075747038, -122.465134896479)
2720	2720	175369	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	25	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5993431.63462	2087732.39125	37.7121387503812	-122.46454740445101	(37.7121387503812, -122.464547404451)
2721	2721	175371	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	27	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5993471.88559	2087712.01586	37.712085124705204	-122.464406808033	(37.7120851247052, -122.464406808033)
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)
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)
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)
36519	36519	204953	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	155 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5994037.68152	2096854.65097	37.737221182201	-122.463114218756	(37.737221182201, -122.463114218756)
42315	42315	204952	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	155 Santa Paula Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5994033.93494	2096871.02037	37.7372659126841	-122.463128359687	(37.7372659126841, -122.463128359687)
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)
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)
50211	50211	123359	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	746 04th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5994762.8096900005	2110492.85226	37.7747099388562	-122.46159563840901	(37.7747099388562, -122.461595638409)
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)
51176	51176	117772	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	401 38th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5984041.4273	2113087.33396	37.7812106723648	-122.498874211765	(37.7812106723648, -122.498874211765)
51413	51413	118535	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	7915 Geary Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5982438.45196	2112345.43604	37.7790794873063	-122.50436464200199	(37.7790794873063, -122.504364642002)
68418	68418	222043	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	201 Treat Ave	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		6008927.7427199995	2107720.51685	37.7679029136253	-122.412400083419	(37.7679029136253, -122.412400083419)
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)
129213	129213	204947	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	111 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5994012.76503	2097046.5891200001	37.737746761309296	-122.463214289036	(37.7377467613093, -122.463214289036)
133215	133215	118534	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	7915 Geary Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5982448.31014	2112345.83773	37.7790811700363	-122.504330568895	(37.7790811700363, -122.504330568895)
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)
137855	137855	250452	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	190 Seacliff Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5987230.75462	2115760.09761	37.7887358671233	-122.48803731227301	(37.7887358671233, -122.488037312273)
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)
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)
165131	165131	175348	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5993488.42633	2087804.6670900001	37.7123404763923	-122.464356361476	(37.7123404763923, -122.464356361476)
170049	170049	204946	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	101 Santa Paula Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5994008.44212	2097065.4765599999	37.7377983724866	-122.463230605425	(37.7377983724866, -122.463230605425)
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)
177411	177411	250451	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	190 Seacliff Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5987248.64548	2115760.65458	37.788738440071	-122.48797545423099	(37.788738440071, -122.487975454231)
177515	177515	117771	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	401 38th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5984040.463409999	2113093.42371	37.781227336507705	-122.498877996337	(37.7812273365077, -122.498877996337)
184907	184907	188201	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	251 Executive Park Blvd	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		6014503.81395	2086993.06554	37.711300955448706	-122.39166355343399	(37.7113009554487, -122.391663553434)
2705	2705	175366	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	22	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		5993316.47827	2087783.2739799998	37.7122718230516	-122.464949108223	(37.7122718230516, -122.464949108223)
24520	24520	250561	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	445 El Camino Del Mar	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5987169.29864	2115304.2119400003	37.7874805511254	-122.488216423958	(37.7874805511254, -122.488216423958)
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)
25544	25544	125658	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	481 Polk St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		6007176.96722	2112501.79124	37.7809327473806	-122.418794957434	(37.7809327473806, -122.418794957434)
28433	28433	175352	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		5993139.4707	2087896.7194400001	37.7125731094281	-122.46556913053301	(37.7125731094281, -122.465569130533)
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)
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)
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)
41398	41398	250560	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	445 El Camino Del Mar	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5987155.2626	2115310.07668	37.78749583512	-122.48826541631901	(37.78749583512, -122.488265416319)
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)

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