Street_Tree_List

Data source: data.sfgov.org

220 rows where qSiteInfo = 4 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: DBH

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH ▼	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
28877	28877	188060	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1241 Evans Ave	2	: 4	Tree 1	Private 1			1	Width 4ft		6017512.496169999	2097088.9484700002	37.7391888439962	-122.381966489387	(37.7391888439962, -122.381966489387)
39264	39264	204069	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	8	: 4	Tree 1	Private 1			1	Width 2ft		5991925.79364	2089647.35065	37.7173098413624	-122.469891319037	(37.7173098413624, -122.469891319037)
39356	39356	204071	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	10	: 4	Tree 1	Private 1			1	Width 2ft		5991926.528080001	2089611.9892799999	37.7172127901068	-122.469886207299	(37.7172127901068, -122.469886207299)
41931	41931	204135	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	114	: 4	Tree 1	Private 1			1	Width 0ft		5991224.97526	2091857.93043	37.72333901327	-122.47247476549299	(37.72333901327, -122.472474765493)
64961	64961	202040	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	350 Salinas Ave	3	: 4	Tree 1	Private 1			1	Width 3ft		6012278.04252	2090758.61512	37.7215165973918	-122.399620645181	(37.7215165973918, -122.399620645181)
69075	69075	204067	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	6	: 4	Tree 1	Private 1			1	Width 2ft		5991926.95794	2089679.2355799999	37.717397456914796	-122.469889614813	(37.7173974569148, -122.469889614813)
70012	70012	204132	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	110	: 4	Tree 1	Private 1			1	Width 0ft		5991228.632230001	2091912.6848400002	37.7234895669738	-122.47246611402001	(37.7234895669738, -122.47246611402)
73826	73826	188066	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1766 Revere Ave	1	: 4	Tree 1	Private 1			1	Width 3ft		6014246.7994	2095052.7708599998	37.7334170310536	-122.39311545041599	(37.7334170310536, -122.393115450416)
132631	132631	204077	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	207 Arch St	1	: 4	Tree 1	Private 1			1	Width 3ft		5992694.39377	2088603.9622	37.7144893470695	-122.46715883152599	(37.7144893470695, -122.467158831526)
133469	133469	250983	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	145 Seal Rock Dr	1	: 4	Tree 1	Private 1			1	Width 3ft		5981179.0028800005	2112933.49353	37.780619963167204	-122.508765181767	(37.7806199631672, -122.508765181767)
134590	134590	204065	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	4	: 4	Tree 1	Private 1			1	Width 2ft		5991927.94965	2089726.34257	37.71752685855721	-122.469889614814	(37.7175268585572, -122.469889614814)
136989	136989	247605	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	900 Tompkins Ave	10	: 4	Tree 1	Private 1			1	Width 3ft		6009347.11446	2096403.2051099997	37.7368516291864	-122.410150415814	(37.7368516291864, -122.410150415814)
148168	148168	188078	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2001 Revere Ave	28	: 4	Tree 1	Private 1			1	Width 3ft		6012505.18891	2096292.6832	37.7367246682956	-122.399223733893	(37.7367246682956, -122.399223733893)
150832	150832	204103	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	300 Junipero Serra Blvd	14	: 4	Tree 1	Private 1			1	Width 0ft		5991407.75535	2094527.8682	37.7306805748458	-122.472037446768	(37.7306805748458, -122.472037446768)
154655	154655	188079	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2001 Revere Ave	29	: 4	Tree 1	Private 1			1	Width 3ft		6012534.30778	2096270.76721	37.73666611435429	-122.399121518759	(37.7366661143543, -122.399121518759)
161329	161329	204155	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	900 Junipero Serra Blvd	103	: 4	Tree 1	Private 1			1	Width 0ft		5991146.25454	2090417.6717700001	37.7193798621823	-122.47264192698	(37.7193798621823, -122.47264192698)
162914	162914	204064	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	3	: 4	Tree 1	Private 1			1	Width 2ft		5991927.921680001	2089748.4341799999	37.717587515118	-122.46989131904499	(37.717587515118, -122.469891319045)
164810	164810	188062	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1649 La Salle Ave	1	: 4	Tree 1	Private 1			1	Width 5ft		6015099.661859999	2096448.66175	37.737297204609106	-122.390264331527	(37.7372972046091, -122.390264331527)
165588	165588	204070	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	9	: 4	Tree 1	Private 1			1	Width 2ft		5991926.35575	2089627.2113400002	37.7172545762149	-122.469887910622	(37.7172545762149, -122.469887910622)
165761	165761	204063	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	2	: 4	Tree 1	Private 1			1	Width 2ft		5991928.61684	2089804.8745400002	37.71774252677329	-122.469893023248	(37.7177425267733, -122.469893023248)
167766	167766	204134	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	112	: 4	Tree 1	Private 1			1	Width 0ft		5991228.00205	2091882.78985	37.7234074462669	-122.472466114014	(37.7234074462669, -122.472466114014)
172323	172323	204078	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	516 Ramsell St	1	: 4	Tree 1	Private 1			1	Width 3ft		5993011.249	2090617.45713	37.7200362035765	-122.466209899293	(37.7200362035765, -122.466209899293)
173476	173476	202039	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	350 Salinas Ave	2	: 4	Tree 1	Private 1			1	Width 3ft		6012297.61112	2090750.98182	37.721496728686	-122.39955246577601	(37.721496728686, -122.399552465776)
175436	175436	204152	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	900 Junipero Serra Blvd	37	: 4	Tree 1	Private 1			1	Width 0ft		5991169.92245	2090751.38969	37.7202975393725	-122.472584434247	(37.7202975393725, -122.472584434247)
177462	177462	204058	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	247 Monticello St	1	: 4	Tree 1	Private 1			1	Width 3ft		5991672.76031	2090179.42511	37.718756158047206	-122.470804664228	(37.7187561580472, -122.470804664228)
182072	182072	204153	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	900 Junipero Serra Blvd	52	: 4	Tree 1	Private 1			1	Width 0ft		5991161.67549	2090655.1387900002	37.720032780762104	-122.47260592714198	(37.7200327807621, -122.472605927142)
184601	184601	204062	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	1	: 4	Tree 1	Private 1			1	Width 2ft		5991928.03433	2089824.0323400002	37.71779509575	-122.469896430779	(37.71779509575, -122.469896430779)
186725	186725	247729	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	39 Broderick St	1	: 4	Tree 1	Private 1			1	Width 5ft		6001344.58941	2108869.46097	37.770629165242894	-122.438711626759	(37.7706291652429, -122.438711626759)
188232	188232	204068	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	7	: 4	Tree 1	Private 1			1	Width 2ft		5991927.09954	2089662.54158	37.7173516274427	-122.46988791059499	(37.7173516274427, -122.469887910595)
188457	188457	204057	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	60 Monticello St	1	: 4	Tree 1	Private 1			1	Width 3ft		5991692.74622	2089138.75635	37.7158998914375	-122.47065982389299	(37.7158998914375, -122.470659823893)
24574	24574	250326	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 27th Ave	1	: 4	Tree 1	Private 1			2	Width 3ft		5987393.53331	2114913.8058	37.786421687562104	-122.487411939018	(37.7864216875621, -122.487411939018)
24687	24687	188070	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2001 Revere Ave	2	: 4	Tree 1	Private 1			2	Width 4ft		6012192.04216	2096531.53608	37.737363051155796	-122.400323196466	(37.7373630511558, -122.400323196466)
25051	25051	204106	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	400 Junipero Serra Blvd	15	: 4	Tree 1	Private 1			2	Width 0ft		5991380.91771	2094122.22642	37.7295652311304	-122.47210067183399	(37.7295652311304, -122.472100671834)
33928	33928	219839	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	200 Portola Dr	1	: 4	Tree 1	Private 1			2	Width 3ft		5999574.1233	2100571.41335	37.7477438976585	-122.444239278237	(37.7477438976585, -122.444239278237)
34026	34026	204127	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	91	: 4	Tree 1	Private 1			2	Width 0ft		5991259.14537	2092125.38495	37.7240753547864	-122.472376135061	(37.7240753547864, -122.472376135061)
37923	37923	219846	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1397 Clayton St	1	: 4	Tree 1	Private 1			2	Width 3ft		5999123.67326	2104550.2809900003	37.7586431835444	-122.446083054815	(37.7586431835444, -122.446083054815)
41648	41648	204157	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	900 Junipero Serra Blvd	109	: 4	Tree 1	Private 1			2	Width 0ft		5991141.76494	2090345.5990099998	37.7191817082419	-122.47265219366899	(37.7191817082419, -122.472652193669)
56338	56338	247803	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	478 30th St	1	: 4	Tree 1	Private 1			2	Width 3ft		6003525.080469999	2098369.64012	37.741922955671896	-122.430420008791	(37.7419229556719, -122.430420008791)
61374	61374	204137	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	117	: 4	Tree 1	Private 1			2	Width 0ft		5991221.343090001	2091828.09873	37.7232568925832	-122.472485147293	(37.7232568925832, -122.472485147293)
68648	68648	204125	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	81	: 4	Tree 1	Private 1			2	Width 0ft		5991261.30507	2092204.0965	37.724291602167895	-122.472374404752	(37.7242916021679, -122.472374404752)
129874	129874	204123	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	73	: 4	Tree 1	Private 1			2	Width 0ft		5991264.39886	2092255.8714400001	37.7244339423611	-122.47236748268101	(37.7244339423611, -122.472367482681)
130626	130626	204118	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	42	: 4	Tree 1	Private 1			2	Width 0ft		5991251.557569999	2092525.31005	37.72517301061529	-122.47243150632	(37.7251730106153, -122.47243150632)
134489	134489	204131	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	107	: 4	Tree 1	Private 1			2	Width 0ft		5991246.04706	2091955.1858	37.723607272029604	-122.472409011575	(37.7236072720296, -122.472409011575)
137269	137269	219847	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1391 Clayton St	1	: 4	Tree 1	Private 1			2	Width 3ft		5999007.4175	2104658.45695	37.7589335683475	-122.446492901049	(37.7589335683475, -122.446492901049)
150795	150795	204124	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	77	: 4	Tree 1	Private 1			2	Width 0ft		5991262.393519999	2092231.98748	37.7243682468726	-122.47237267447201	(37.7243682468726, -122.472372674472)
155050	155050	250327	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 27th Ave	2	: 4	Tree 1	Private 1			2	Width 3ft		5987392.49904	2114897.88557	37.7863779148594	-122.487414347421	(37.7863779148594, -122.487414347421)
161220	161220	219845	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1395 Clayton St	1	: 4	Tree 1	Private 1			2	Width 3ft		5999065.80316	2104568.48584	37.7586898646717	-122.44628450473999	(37.7586898646717, -122.44628450474)
167615	167615	204139	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	120	: 4	Tree 1	Private 1			2	Width 0ft		5991219.21165	2091798.23539	37.7231747718824	-122.47249033908501	(37.7231747718824, -122.472490339085)
167783	167783	188077	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2001 Revere Ave	20	: 4	Tree 1	Private 1			2	Width 4ft		6012366.41561	2096402.12355	37.7370174335949	-122.3997112186	(37.7370174335949, -122.3997112186)
183959	183959	204136	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	115	: 4	Tree 1	Private 1			2	Width 0ft		5991237.83729	2091850.68057	37.7233198514003	-122.472429776026	(37.7233198514003, -122.472429776026)
188378	188378	204066	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	5	: 4	Tree 1	Private 1			2	Width 2ft		5991927.82266	2089696.89032	37.7174459825143	-122.469887910592	(37.7174459825143, -122.469887910592)
188747	188747	188045	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	649 Arkansas St	1	: 4	Tree 1	Private 1			2	Width 3ft		6013032.41115	2104053.24106	37.7580628726303	-122.39794512008301	(37.7580628726303, -122.397945120083)
25562	25562	204156	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	900 Junipero Serra Blvd	106	: 4	Tree 1	Private 1			3	Width 0ft		5991140.12525	2090380.53407	37.719277536403496	-122.472660407165	(37.7192775364035, -122.472660407165)
26935	26935	204142	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	126	: 4	Tree 1	Private 1			3	Width 0ft		5991215.491640001	2091740.4912900003	37.7230160055721	-122.47249899053001	(37.7230160055721, -122.47249899053)
27118	27118	219852	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	160 Saint Germain Ave	1	: 4	Tree 1	Private 1			3	Width 3ft		5997608.48937	2104144.50247	37.7574423754904	-122.451293958747	(37.7574423754904, -122.451293958747)
31270	31270	204114	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	500 Junipero Serra Blvd	61	: 4	Tree 1	Private 1			3	Width 0ft		5991316.326090001	2093291.62937	37.727280881195604	-122.472263446404	(37.7272808811956, -122.472263446404)
34579	34579	247609	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	900 Tompkins Ave	14	: 4	Tree 1	Private 1			3	Width 3ft		6009461.2827	2096390.64245	37.736823533478706	-122.40975479775801	(37.7368235334787, -122.409754797758)
44251	44251	204144	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	131	: 4	Tree 1	Private 1			3	Width 0ft		5991226.84892	2091709.3466	37.7229311473308	-122.47245746165599	(37.7229311473308, -122.472457461656)
45020	45020	204113	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	500 Junipero Serra Blvd	60	: 4	Tree 1	Private 1			3	Width 0ft		5991329.44333	2093302.97472	37.7273127918355	-122.472218927258	(37.7273127918355, -122.472218927258)
46219	46219	246939	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	289 Frederick St	1	: 4	Tree 1	Private 1			3	Width 3ft		5998674.663240001	2107589.15907	37.7669615293729	-122.44785470843901	(37.7669615293729, -122.447854708439)
50819	50819	204109	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	400 Junipero Serra Blvd	24	: 4	Tree 1	Private 1			3	Width 0ft		5991367.8639400005	2093922.92982	37.7290172571279	-122.472131278448	(37.7290172571279, -122.472131278448)
54034	54034	204119	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	43	: 4	Tree 1	Private 1			3	Width 0ft		5991263.55519	2092524.5586400002	37.725171641833	-122.47238997742599	(37.725171641833, -122.472389977426)
57729	57729	204130	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	105	: 4	Tree 1	Private 1			3	Width 0ft		5991232.43649	2091974.41455	37.7236592816427	-122.47245746163901	(37.7236592816427, -122.472457461639)
64842	64842	218249	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2715 14th Ave	2	: 4	Tree 1	Private 1			3	Width 4ft		5992216.53189	2097263.0156400003	37.7382373720581	-122.46944042685699	(37.7382373720581, -122.469440426857)
66487	66487	204111	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	500 Junipero Serra Blvd	30	: 4	Tree 1	Private 1			3	Width 0ft		5991347.410519999	2093620.7950099998	37.728186486813	-122.47217997225	(37.728186486813, -122.47217997225)
67179	67179	204154	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	900 Junipero Serra Blvd	96	: 4	Tree 1	Private 1			3	Width 0ft		5991156.52869	2090538.7202700002	37.7197128262716	-122.47261523421001	(37.7197128262716, -122.47261523421)
68593	68593	204115	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	500 Junipero Serra Blvd	71	: 4	Tree 1	Private 1			3	Width 0ft		5991313.39141	2093228.77227	37.7271081214352	-122.472269011404	(37.7271081214352, -122.472269011404)
128099	128099	204108	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	400 Junipero Serra Blvd	21	: 4	Tree 1	Private 1			3	Width 0ft		5991375.05495	2094034.9872599998	37.7293253549616	-122.47211458342501	(37.7293253549616, -122.472114583425)
134146	134146	204110	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	500 Junipero Serra Blvd	24	: 4	Tree 1	Private 1			3	Width 0ft		5991353.72908	2093672.3585599998	37.728328433101794	-122.472161885976	(37.7283284331018, -122.472161885976)
135372	135372	188073	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2001 Revere Ave	10	: 4	Tree 1	Private 1			3	Width 4ft		6012282.35335	2096466.63669	37.7371898866961	-122.40000639049299	(37.7371898866961, -122.400006390493)
152667	152667	204138	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	118	: 4	Tree 1	Private 1			3	Width 0ft		5991222.04967	2091814.1267099997	37.723218569775796	-122.47248168668001	(37.7232185697758, -122.47248168668)
154168	154168	219844	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	971 Burnett Ave	1	: 4	Tree 1	Private 1			3	Width 3ft		5999416.09842	2100391.78343	37.7472416604899	-122.444772808228	(37.7472416604899, -122.444772808228)
156443	156443	219853	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	160 Saint Germain Ave	2	: 4	Tree 1	Private 1			3	Width 3ft		5997587.19645	2104142.8709299997	37.7574366764665	-122.45136748012	(37.7574366764665, -122.45136748012)
159009	159009	188056	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	349 Mississippi St	1	: 4	Tree 1	Private 1			3	Width 3ft		6014084.185190001	2105377.8006700003	37.7617583461041	-122.394400350518	(37.7617583461041, -122.394400350518)
159265	159265	219851	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Aquavista Way	2	: 4	Tree 1	Private 1			3	Width 3ft		5997982.15762	2101832.44705	37.75111543354561	-122.449835051543	(37.7511154335456, -122.449835051543)
167367	167367	204104	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	300 Junipero Serra Blvd	18	: 4	Tree 1	Private 1			3	Width 0ft		5991407.12299	2094497.8635	37.73059815287271	-122.472037446779	(37.7305981528727, -122.472037446779)
181775	181775	188049	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	635 Connecticut St	1	: 4	Tree 1	Private 1			3	Width 3ft		6013311.69986	2104124.51343	37.7582741215595	-122.396984210649	(37.7582741215595, -122.396984210649)
184366	184366	188061	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1241 Evans Ave	4	: 4	Tree 1	Private 1			3	Width 3ft		6017553.88932	2097055.79305	37.739100091683895	-122.381821063598	(37.7391000916839, -122.381821063598)
184910	184910	204054	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	116 Majestic Ave	1	: 4	Tree 1	Private 1			3	Width 3ft		5997034.58686	2089315.10144	37.7166915502611	-122.45220874374901	(37.7166915502611, -122.452208743749)
186048	186048	204140	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	121	: 4	Tree 1	Private 1			3	Width 0ft		5991218.48026	2091787.2847	37.7231446616675	-122.472492069365	(37.7231446616675, -122.472492069365)
187020	187020	204105	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	300 Junipero Serra Blvd	40	: 4	Tree 1	Private 1			3	Width 0ft		5991399.0300199995	2094388.9297200001	37.7302985797068	-122.47205748816499	(37.7302985797068, -122.472057488165)
187147	187147	204072	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	216 Arch St	1	: 4	Tree 1	Private 1			3	Width 3ft		5992726.8230099995	2088588.5716900001	37.714448960336206	-122.46704562576299	(37.7144489603362, -122.467045625763)
23494	23494	219849	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	72 Skyview Way	1	: 4	Tree 1	Private 1			4	Width 3ft		5997939.73785	2101790.86322	37.7509988274335	-122.449978746126	(37.7509988274335, -122.449978746126)
30679	30679	188074	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2001 Revere Ave	13	: 4	Tree 1	Private 1			4	Width 4ft		6012318.61445	2096437.2512599998	37.7371112221076	-122.399878955661	(37.7371112221076, -122.399878955661)
32350	32350	246968	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	298 Noe St	2	: 4	Tree 1	Private 1			4	Width 4ft		6002885.77984	2106576.3697599997	37.764420453563105	-122.43321676096201	(37.7644204535631, -122.433216760962)
34235	34235	188054	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	226 Missouri St	1	: 4	Tree 1	Private 1			4	Width 3ft		6013429.19635	2105999.0041	37.7634276020221	-122.39670926094999	(37.7634276020221, -122.39670926095)
34312	34312	219850	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Aquavista Way	1	: 4	Tree 1	Private 1			4	Width 3ft		5997954.10401	2101824.32027	37.751091514263294	-122.449931477763	(37.7510915142633, -122.449931477763)
37167	37167	246477	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	322 Duncan St	1	: 4	Tree 1	Private 1			4	Width 3ft		6004283.15075	2099877.42945	37.7461059111665	-122.42790626157	(37.7461059111665, -122.42790626157)
37867	37867	246985	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	46 Clipper St	1	: 4	Tree 1	Private 1			4	Width 3ft		6004835.9859	2101075.53534	37.749426893431604	-122.426079904889	(37.7494268934316, -122.426079904889)
38517	38517	188040	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	50 Sierra St	1	: 4	Tree 1	Private 1			4	Width 3ft		6013665.83046	2104151.79248	37.758368730239205	-122.39576137460699	(37.7583687302392, -122.395761374607)
42574	42574	204112	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	500 Junipero Serra Blvd	50	: 4	Tree 1	Private 1			4	Width 0ft		5991337.23651	2093405.4040700002	37.727594488284	-122.472199449765	(37.727594488284, -122.472199449765)
45622	45622	204092	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	20 Sargent St	1	: 4	Tree 1	Private 1			4	Width 3ft		5993952.38646	2089201.3292900003	37.71620211130279	-122.46285404939199	(37.7162021113028, -122.462854049392)
55830	55830	219848	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	47 Clarendon Ave	1	: 4	Tree 1	Private 1			4	Width 3ft		5998024.44262	2104629.5149	37.758797906506096	-122.44989038683599	(37.7587979065061, -122.449890386836)
64315	64315	247204	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	20 Alpine Ter	1	: 4	Tree 1	Private 1			4	Width 3ft		6001601.5903199995	2108602.69661	37.7699113137874	-122.437803549804	(37.7699113137874, -122.437803549804)
64385	64385	175389	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	3060 23rd Ave	1	: 4	Tree 1	Private 1			4	Width 2ft		5989371.121730001	2094927.29938	37.731659245859205	-122.479107529986	(37.7316592458592, -122.479107529986)
162335	162335	219843	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	200 Portola Dr	8	: 4	Tree 1	Private 1			4	Width 3ft		5999523.61181	2100409.78432	37.747297221497	-122.444402329811	(37.747297221497, -122.444402329811)
162385	162385	187507	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1888 Geneva Ave	7	: 4	Tree 1	Private 1			4	Width 3ft		6004913.95724	2086749.2623400001	37.7100945337938	-122.424791216847	(37.7100945337938, -122.424791216847)
162646	162646	187512	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1888 Geneva Ave	12	: 4	Tree 1	Private 1			4	Width 3ft		6004972.0075900005	2086680.68467	37.7099095126929	-122.424585708258	(37.7099095126929, -122.424585708258)
162792	162792	204133	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	111	: 4	Tree 1	Private 1			4	Width 0ft		5991241.7215	2091892.4700799999	37.723434819851704	-122.47241939423401	(37.7234348198517, -122.472419394234)
166169	166169	219840	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	200 Portola Dr	4	: 4	Tree 1	Private 1			4	Width 3ft		5999567.441790001	2100499.89651	37.7475471484975	-122.444257243986	(37.7475471484975, -122.444257243986)

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