Street_Tree_List

Data source: data.sfgov.org

220 rows where qSiteInfo = 4 and qSpecies = 12 sorted by SiteOrder

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

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder ▼	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
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)
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)
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)
27724	27724	204090	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	520 Garfield St	1	: 4	Tree 1	Private 1			5	Width 3ft		5992622.63923	2090513.2598299999	37.7197276740608	-122.46754560564501	(37.7197276740608, -122.467545605645)
30393	30393	175390	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	3087 22nd Ave	1	: 4	Tree 1	Private 1			10	Width 2ft		5989889.400330001	2094791.98233	37.7313177849745	-122.477305871364	(37.7313177849745, -122.477305871364)
30639	30639	188038	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	811 Rhode Island St	1	: 4	Tree 1	Private 1			6	Width 6ft		6011881.03364	2104580.1042400002	37.7594453311486	-122.401964136345	(37.7594453311486, -122.401964136345)
30953	30953	204049	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	6 Geneva Ave	1	: 4	Tree 1	Private 1			9	Width 3ft		5997346.16193	2091404.9638200002	37.7224476691055	-122.451282424964	(37.7224476691055, -122.451282424964)
32964	32964	204055	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	66 Margaret Ave	1	: 4	Tree 1	Private 1			10	Width 3ft		5997041.30119	2089782.6592599999	37.71797573986029	-122.45221925324199	(37.7179757398603, -122.452219253242)
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)
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)
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)
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)
38548	38548	204079	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	517 Victoria St	1	: 4	Tree 1	Private 1			10	Width 3ft		5993238.7635699995	2090626.4258	37.7200739535406	-122.46542411665001	(37.7200739535406, -122.46542411665)
45577	45577	247774	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	222 30th St	1	: 4	Tree 1	Private 1			7	Width 3ft		6005147.38191	2098466.01095	37.7422793318144	-122.424817464458	(37.7422793318144, -122.424817464458)
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)
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)
49371	49371	204089	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	558 Bright St	1	: 4	Tree 1	Private 1			6	Width 3ft		5993794.816819999	2090859.7407	37.7207466338444	-122.463518967621	(37.7207466338444, -122.463518967621)
50731	50731	204059	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	254 Monticello St	1	: 4	Tree 1	Private 1			9	Width 3ft		5991705.974830001	2090211.6163	37.71884646795999	-122.470692199481	(37.71884646796, -122.470692199481)
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)
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)
59462	59462	204053	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	114 Majestic Ave	1	: 4	Tree 1	Private 1			5	Width 3ft		5997084.51167	2089384.1805200002	37.7168840852152	-122.452041160489	(37.7168840852152, -122.452041160489)
61218	61218	246967	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	298 Noe St	1	: 4	Tree 1	Private 1			5	Width 4ft		6002884.61538	2106587.50238	37.764450954977605	-122.433221584021	(37.7644509549776, -122.433221584021)
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)
66551	66551	201656	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	748 Innes Ave	1	: 4	Tree 1	Private 1			5	Width 3ft		6020105.93205	2093842.3371599999	37.7304171562079	-122.37277477954099	(37.7304171562079, -122.372774779541)
67849	67849	204096	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	21 Sargent St	1	: 4	Tree 1	Private 1			7	Width 3ft		5993896.88715	2089161.0094599999	37.7160882058709	-122.46304295648599	(37.7160882058709, -122.463042956486)
68566	68566	204098	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	33 Sargent St	1	: 4	Tree 1	Private 1			7	Width 3ft		5993844.91578	2089161.3386400002	37.7160861158451	-122.46322261673201	(37.7160861158451, -122.463222616732)
69693	69693	204087	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	783 Head St	1	: 4	Tree 1	Private 1			12	Width 3ft		5993505.41903	2091013.45112	37.72115200684679	-122.464530473801	(37.7211520068468, -122.464530473801)
70182	70182	204056	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	201 Lakeview Ave	1	: 4	Tree 1	Private 1			8	Width 3ft		5997069.70996	2089426.6640700002	37.7169998873021	-122.452095385989	(37.7169998873021, -122.452095385989)
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)
135064	135064	175383	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	3001 Ocean Ave	1	: 4	Tree 1	Private 1			8	Width 3ft		5989487.94212	2095224.7734	37.7324828171076	-122.478725410769	(37.7324828171076, -122.478725410769)
136195	136195	188065	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	38 Flora St	1	: 4	Tree 1	Private 1			9	Width 3ft		6013873.38288	2094548.1497400003	37.73201069372529	-122.394371145919	(37.7320106937253, -122.394371145919)
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)
146772	146772	247782	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	274 30th St	1	: 4	Tree 1	Private 1			6	Width 3ft		6004804.71628	2098445.98307	37.7422049794818	-122.426000872448	(37.7422049794818, -122.426000872448)
150288	150288	204099	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	45 Sargent St	1	: 4	Tree 1	Private 1			9	Width 3ft		5993811.31376	2089162.80485	37.716088205875394	-122.46333886672	(37.7160882058754, -122.46333886672)
150745	150745	250693	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	880 El Camino Del Mar	1	: 4	Tree 1	Private 1			5	Width 4ft		5985657.4589	2115013.3530200003	37.7865936181467	-122.493425569734	(37.7865936181467, -122.493425569734)
151687	151687	204050	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	8 Geneva Ave	1	: 4	Tree 1	Private 1			9	Width 3ft		5997375.66754	2091389.92574	37.7224080674645	-122.45117934737499	(37.7224080674645, -122.451179347375)
152925	152925	204085	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	763 Head St	1	: 4	Tree 1	Private 1			11	Width 3ft		5993502.27941	2090889.21428	37.7208107015456	-122.46453231021401	(37.7208107015456, -122.464532310214)
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)
157604	157604	204080	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	225 Victoria St	1	: 4	Tree 1	Private 1			9	Width 3ft		5993216.93955	2088773.98493	37.714986338524206	-122.465365061769	(37.7149863385242, -122.465365061769)
157675	157675	187525	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	151 Mary Teresa St	1	: 4	Tree 1	Private 1			5	Width 1ft		6012522.296569999	2087951.2705599999	37.7138218046169	-122.398579419997	(37.7138218046169, -122.398579419997)
157677	157677	188059	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1241 Evans Ave	1	: 4	Tree 1	Private 1			5	Width 3ft		6017496.48371	2097099.74121	37.73921759440329	-122.38202260437599	(37.7392175944033, -122.382022604376)
158544	158544	250490	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	246 El Camino Del Mar	1	: 4	Tree 1	Private 1			7	Width 3ft		5987788.79254	2115350.25129	37.787643084702	-122.486076508742	(37.787643084702, -122.486076508742)
159002	159002	188063	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1630 La Salle Ave	1	: 4	Tree 1	Private 1			5	Width 3ft		6015422.30134	2096277.6142	37.7368454337733	-122.38913686859101	(37.7368454337733, -122.389136868591)
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)
159671	159671	175338	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	248 Wilson St	1	: 4	Tree 1	Private 1			10	Width 3ft		5994374.45478	2086640.5688599998	37.709195169503005	-122.461209673184	(37.709195169503, -122.461209673184)
160643	160643	247775	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	226 30th St	1	: 4	Tree 1	Private 1			12	Width 3ft		6005119.5309	2098464.40515	37.7422733495371	-122.42491365056999	(37.7422733495371, -122.42491365057)
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)
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)
165696	165696	204093	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	22 Sargent St	1	: 4	Tree 1	Private 1			5	Width 3ft		5993932.401430001	2089196.0396599998	37.716186436122605	-122.462922743188	(37.7161864361226, -122.462922743188)
165900	165900	204094	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Sargent St	1	: 4	Tree 1	Private 1			12	Width 3ft		5993976.27625	2089155.91875	37.7160788007751	-122.462768183016	(37.7160788007751, -122.462768183016)
168216	168216	188069	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2001 Revere Ave	1	: 4	Tree 1	Private 1			5	Width 4ft		6012175.97702	2096542.9963200002	37.7373936227068	-122.40037954618799	(37.7373936227068, -122.400379546188)
170158	170158	204081	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	681 Head St	1	: 4	Tree 1	Private 1			7	Width 3ft		5993497.95379	2090430.17226	37.71955003367329	-122.464513948782	(37.7195500336733, -122.464513948782)
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)
173204	173204	201501	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1099 Innes Ave	1	: 4	Tree 1	Private 1			10	Width 2ft		6018217.02471	2095179.1389799998	37.733983766719	-122.379397893394	(37.733983766719, -122.379397893394)
175236	175236	204088	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	554 Bright St	1	: 4	Tree 1	Private 1			4	Width 3ft		5993796.400719999	2090834.18687	37.720676560449704	-122.463511639061	(37.7206765604497, -122.463511639061)
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)
177587	177587	204095	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	24 Sargent St	1	: 4	Tree 1	Private 1			5	Width 3ft		5993902.945830001	2089194.7546400002	37.7161812110757	-122.463024461917	(37.7161812110757, -122.463024461917)
178375	178375	201528	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Innes Ave	1	: 4	Tree 1	Private 1			10	Width 3ft		6020307.12095	2093692.07813	37.7300156278056	-122.372068839601	(37.7300156278056, -122.372068839601)
180370	180370	175388	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	3000 25th Ave	1	: 4	Tree 1	Private 1			6	Width 2ft		5988851.70703	2095164.55725	37.73228051643029	-122.48092059382	(37.7322805164303, -122.48092059382)
180941	180941	204061	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	238 Byxbee St	1	: 4	Tree 1	Private 1			8	Width 3ft		5991965.696690001	2090114.3483099998	37.718594409584206	-122.469787374509	(37.7185944095842, -122.469787374509)
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)
181990	181990	204052	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	109 Louisburg St	1	: 4	Tree 1	Private 1			4	Width 3ft		5997885.310880001	2091050.18574	37.721504387299795	-122.449393169677	(37.7215043872998, -122.449393169677)
182114	182114	175386	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	3299 Ocean Ave	1	: 4	Tree 1	Private 1			7	Width 3ft		5988885.34541	2095203.56247	37.7323895700127	-122.480807154223	(37.7323895700127, -122.480807154223)
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)
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)
185827	185827	204097	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	27 Sargent St	1	: 4	Tree 1	Private 1			7	Width 3ft		5993869.3414900005	2089159.6844099998	37.716082980832205	-122.46313807056002	(37.7160829808322, -122.46313807056)
186035	186035	175334	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	114 De Long St	1	: 4	Tree 1	Private 1			12	Width 3ft		5994510.66891	2086823.77253	37.709706041981704	-122.460752167376	(37.7097060419817, -122.460752167376)
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)
187124	187124	175340	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	18 Rhine St	1	: 4	Tree 1	Private 1			4	Width 3ft		5994510.0494800005	2086755.6303299998	37.7095189038466	-122.460749373209	(37.7095189038466, -122.460749373209)
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)
187413	187413	204048	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	4 Geneva Ave	1	: 4	Tree 1	Private 1			9	Width 3ft		5997298.98464	2091430.55111	37.7225152243894	-122.451447349841	(37.7225152243894, -122.451447349841)
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)
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)
189122	189122	204102	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2690 Ocean Ave	1	: 4	Tree 1	Private 1			7	Width 3ft		5990691.67687	2095162.7954	37.7323824608655	-122.474559334655	(37.7323824608655, -122.474559334655)
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)
25808	25808	188041	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	50 Sierra St	2	: 4	Tree 1	Private 1			5	Width 3ft		6013648.115680001	2104149.40965	37.758361202031494	-122.39582247362301	(37.7583612020315, -122.395822473623)
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)
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)
51346	51346	187526	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	151 Mary Teresa St	2	: 4	Tree 1	Private 1			7	Width 1ft		6012506.68997	2087960.4481099998	37.713846134852794	-122.398634006175	(37.7138461348528, -122.398634006175)
59918	59918	201657	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	748 Innes Ave	2	: 4	Tree 1	Private 1			5	Width 3ft		6020084.79381	2093857.53228	37.7304577174311	-122.372848909746	(37.7304577174311, -122.372848909746)
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)
75343	75343	250694	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	880 El Camino Del Mar	2	: 4	Tree 1	Private 1			6	Width 4ft		5985651.502	2115013.05675	37.786592456228796	-122.49344615702101	(37.7865924562288, -122.493446157021)
76336	76336	201530	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	724 Innes Ave	2	: 4	Tree 1	Private 1			11	Width 3ft		6020205.16729	2093768.9038799999	37.7302209753954	-122.37242662498899	(37.7302209753954, -122.372426624989)
108622	108622	204086	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	779 Head St	2	: 4	Tree 1	Private 1			8	Width 3ft		5993504.875109999	2090987.54432	37.7210808416867	-122.464530473824	(37.7210808416867, -122.464530473824)
129619	129619	175391	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	3087 22nd Ave	2	: 4	Tree 1	Private 1			10	Width 2ft		5989891.445180001	2094780.55539	37.7312865281501	-122.477297967228	(37.7312865281501, -122.477297967228)
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)
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)
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)
160390	160390	204073	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	216 Arch St	2	: 4	Tree 1	Private 1			6	Width 3ft		5992727.7538	2088602.30188	37.7144867138609	-122.467043406235	(37.7144867138609, -122.467043406235)
162197	162197	175387	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	3299 Ocean Ave	2	: 4	Tree 1	Private 1			5	Width 3ft		5988944.43237	2095205.9021400001	37.73239942837721	-122.480603050396	(37.7323994283772, -122.480603050396)
164915	164915	204051	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	8 Geneva Ave	2	: 4	Tree 1	Private 1			9	Width 3ft		5997395.095430001	2091381.8849099998	37.722387101563	-122.45111161040701	(37.722387101563, -122.451111610407)
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)
166302	166302	175335	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	114 De Long St	2	: 4	Tree 1	Private 1			10	Width 3ft		5994496.623790001	2086824.0668400002	37.7097060419715	-122.46080073078699	(37.7097060419715, -122.460800730787)
168242	168242	204091	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	18 Sargent St	2	: 4	Tree 1	Private 1			11	Width 3ft		5993976.66026	2089192.4471099998	37.7161791210507	-122.462769504124	(37.7161791210507, -122.462769504124)

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