Street_Tree_List

Data source: data.sfgov.org

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

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

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude ▼	Longitude	Location
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)
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)
132141	132141	175546	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	298 Cordova St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 8ft		6001847.622269999	2087157.43402	37.7110416161394	-122.435418236567	(37.7110416161394, -122.435418236567)
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)
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)
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)
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)
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)
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)
65186	65186	175545	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	187 Seville St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 6ft		6001219.37593	2087363.7539	37.7115724247979	-122.437604368864	(37.7115724247979, -122.437604368864)
134460	134460	175544	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	187 Seville St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 6ft		6001192.72242	2087375.86302	37.7116041582787	-122.437697356964	(37.7116041582787, -122.437697356964)
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)
178179	178179	204100	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5993729.19042	2087617.8937400002	37.7118415163357	-122.46351066868	(37.7118415163357, -122.46351066868)
56647	56647	175274	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	19 Brunswick St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 5ft		6001024.26555	2087488.4047299998	37.7119035929554	-122.438287644984	(37.7119035929554, -122.438287644984)
146365	146365	204101	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		5993659.00835	2087684.8091799999	37.712021206289	-122.46375808926099	(37.712021206289, -122.463758089261)
188007	188007	175344	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5993634.16802	2087703.44428	37.7120709424008	-122.463845295648	(37.7120709424008, -122.463845295648)
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)
2708	2708	175370	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	26	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5993448.13741	2087722.6413599998	37.712112930839	-122.464489658971	(37.712112930839, -122.464489658971)
175356	175356	175345	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		5993607.01879	2087723.8804799998	37.7121254907785	-122.463940612974	(37.7121254907785, -122.463940612974)
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)
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)
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)
2703	2703	175367	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	23	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5993394.31846	2087754.15211	37.7121963492565	-122.464677958129	(37.7121963492565, -122.464677958129)
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)
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)
2702	2702	175365	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	18	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 5ft		5993296.25394	2087788.76232	37.712285726578	-122.465019407322	(37.712285726578, -122.465019407322)
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)
2716	2716	175362	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 5ft		5993185.52762	2087808.44828	37.7123333942447	-122.46540353654	(37.7123333942447, -122.46540353654)
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)
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)
77205	77205	175350	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5993275.80872	2087878.6636599998	37.7125313952921	-122.46509659705099	(37.7125313952921, -122.465096597051)
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)
152811	152811	175355	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 5ft		5992860.6815599995	2087893.2281099998	37.7125474391986	-122.46653245101001	(37.7125474391986, -122.46653245101)
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)
54006	54006	175353	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5992903.53374	2087894.08049	37.712552252365796	-122.466384403718	(37.7125522523658, -122.466384403718)
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)
157133	157133	175298	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1498 Geneva Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 4ft		6002915.8546400005	2087711.61866	37.712623896842295	-122.431765713815	(37.7126238968423, -122.431765713815)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
188874	188874	175294	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	760 Mansell St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		6009619.4023	2090150.4820700001	37.7196982320664	-122.408767998643	(37.7196982320664, -122.408767998643)
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)
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)
184782	184782	204025	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	345 Grafton Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5995726.34615	2090539.6194900002	37.7199787576063	-122.456819166779	(37.7199787576063, -122.456819166779)
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)
151763	151763	175286	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	325 Olmstead St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		6010711.19323	2090926.76022	37.721890824193004	-122.405048677871	(37.721890824193, -122.405048677871)
71622	71622	175285	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	350 Olmstead St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 4ft		6010704.73668	2090949.18251	37.7219520302409	-122.40507257466001	(37.7219520302409, -122.40507257466)
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)
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)
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)
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)
180888	180888	205071	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	751 Junipero Serra Blvd	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5991360.7446800005	2092152.3739200002	37.7241553395843	-122.472026891444	(37.7241553395843, -122.472026891444)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
42548	42548	204951	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	145 Santa Paula Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 6ft		5994031.745019999	2096886.09513	37.7373071780787	-122.463137024673	(37.7373071780787, -122.463137024673)
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)

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