Street_Tree_List

Data source: data.sfgov.org

220 rows where qSiteInfo = 4 and qSpecies = 12 sorted by rowid descending

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
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)
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)
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)
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)
188245	188245	204128	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	93	: 4	Tree 1	Private 1			8	Width 0ft		5991254.18034	2092103.55707	37.72401513347929	-122.472391707724	(37.7240151334793, -122.472391707724)
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)
187533	187533	175341	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	18 Rhine St	2	: 4	Tree 1	Private 1			7	Width 3ft		5994500.0272699995	2086747.2122099998	37.709495213017	-122.460783401753	(37.709495213017, -122.460783401753)
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)
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)
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)
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)
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)
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)
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)
185929	185929	201502	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1099 Innes Ave	2	: 4	Tree 1	Private 1			11	Width 2ft		6018234.7860900005	2095166.37786	37.733949706701004	-122.37933560007299	(37.733949706701, -122.379335600073)
185902	185902	204107	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	400 Junipero Serra Blvd	19	: 4	Tree 1	Private 1			5	Width 0ft		5991377.14521	2094057.78597	37.7293880754752	-122.472109018414	(37.7293880754752, -122.472109018414)
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)
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)
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)
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)
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)
183079	183079	247607	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	900 Tompkins Ave	12	: 4	Tree 1	Private 1			5	Width 3ft		6009408.85262	2096398.8232099998	37.736843057761504	-122.409936649663	(37.7368430577615, -122.409936649663)
182925	182925	250695	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	880 El Camino Del Mar	3	: 4	Tree 1	Private 1			6	Width 4ft		5985648.066930001	2115011.43689	37.786587807629296	-122.49345792196002	(37.7865878076293, -122.49345792196)
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)
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)
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)
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)
181502	181502	187527	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	151 Mary Teresa St	3	: 4	Tree 1	Private 1			5	Width 1ft		6012489.4847099995	2087971.9174	37.713876668655296	-122.398694278718	(37.7138766686553, -122.398694278718)
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)
180927	180927	204075	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	216 Arch St	4	: 4	Tree 1	Private 1			4	Width 3ft		5992726.79414	2088633.01861	37.7145709992182	-122.46704895504101	(37.7145709992182, -122.467048955041)
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)
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)
178282	178282	188064	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1630 La Salle Ave	2	: 4	Tree 1	Private 1			8	Width 3ft		6015400.35958	2096292.57482	37.7368852962249	-122.389213775914	(37.7368852962249, -122.389213775914)
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)
177536	177536	204083	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	681 Head St	3	: 4	Tree 1	Private 1			7	Width 3ft		5993496.80112	2090400.5748599998	37.719468699905	-122.464515785199	(37.719468699905, -122.464515785199)
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)
177342	177342	204149	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	154	: 4	Tree 1	Private 1			6	Width 0ft		5991212.71454	2091446.3716400003	37.722208265075004	-122.47248715816299	(37.722208265075, -122.472487158163)
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)
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)
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)
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)
173186	173186	247603	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	900 Tompkins Ave	8	: 4	Tree 1	Private 1			14	Width 3ft		6009280.38775	2096410.63742	37.736868296341704	-122.41038164502399	(37.7368682963417, -122.410381645024)
172666	172666	247608	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	900 Tompkins Ave	13	: 4	Tree 1	Private 1			9	Width 3ft		6009430.72052	2096395.0816	37.7368340096763	-122.409860778348	(37.7368340096763, -122.409860778348)
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)
172096	172096	204121	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	65	: 4	Tree 1	Private 1			4	Width 0ft		5991270.79215	2092345.4595299999	37.7246802990344	-122.472351910019	(37.7246802990344, -122.472351910019)
171798	171798	204141	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	122	: 4	Tree 1	Private 1			5	Width 0ft		5991228.41386	2091783.5857799998	37.723135080309	-122.472457461666	(37.723135080309, -122.472457461666)
170289	170289	187511	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1888 Geneva Ave	11	: 4	Tree 1	Private 1			5	Width 3ft		6004958.741090001	2086695.30162	37.7099488984891	-122.42463259891599	(37.7099488984891, -122.424632598916)
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)
170045	170045	204116	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	500 Junipero Serra Blvd	72	: 4	Tree 1	Private 1			5	Width 0ft		5991324.66318	2093228.93526	37.727109221303294	-122.472230057288	(37.7271092213033, -122.472230057288)
169712	169712	246889	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	811 Stanyan St	2	: 4	Tree 1	Private 1			12	Width 3ft		5997112.0473	2107697.03496	37.7671682898089	-122.45326730965701	(37.7671682898089, -122.453267309657)
169561	169561	175385	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	3001 Ocean Ave	5	: 4	Tree 1	Private 1			6	Width 3ft		5989548.38351	2095227.0801799998	37.7324926601934	-122.478516621472	(37.7324926601934, -122.478516621472)
169556	169556	204082	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	681 Head St	2	: 4	Tree 1	Private 1			5	Width 3ft		5993496.5476	2090413.80426	37.7195050100316	-122.464517621588	(37.7195050100316, -122.464517621588)
169545	169545	187506	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1888 Geneva Ave	6	: 4	Tree 1	Private 1			9	Width 3ft		6004893.16086	2086772.3737400002	37.7101568181467	-122.424864736445	(37.7101568181467, -122.424864736445)
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)
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)
167990	167990	204143	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	127	: 4	Tree 1	Private 1			4	Width 0ft		5991229.50143	2091740.19596	37.7230160055595	-122.47245054047801	(37.7230160055595, -122.472450540478)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
164843	164843	187510	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1888 Geneva Ave	10	: 4	Tree 1	Private 1			5	Width 3ft		6004948.81965	2086709.68307	37.709987826555704	-122.424667911703	(37.7099878265557, -122.424667911703)
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)
164787	164787	188046	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1500 22nd St	3	: 4	Tree 1	Private 1			8	Width 3ft		6013506.07902	2103847.53296	37.75752441163671	-122.396292544776	(37.7575244116367, -122.396292544776)
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)
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)
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)
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)
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)
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)
161668	161668	204120	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	60	: 4	Tree 1	Private 1			6	Width 0ft		5991274.407240001	2092398.22017	37.724825375875604	-122.472343257638	(37.7248253758756, -122.472343257638)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
154404	154404	175342	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	18 Rhine St	3	: 4	Tree 1	Private 1			11	Width 3ft		5994489.11096	2086733.7148099998	37.7094575242209	-122.46082015254801	(37.7094575242209, -122.460820152548)
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)
153430	153430	187509	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1888 Geneva Ave	9	: 4	Tree 1	Private 1			5	Width 3ft		6004937.85944	2086722.41778	37.7100221743453	-122.424706697651	(37.7100221743453, -122.424706697651)
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)
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)
152452	152452	175339	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	248 Wilson St	3	: 4	Tree 1	Private 1			8	Width 3ft		5994341.375580001	2086670.8513099998	37.709276414241295	-122.46132619294399	(37.7092764142413, -122.461326192944)
152438	152438	188076	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2001 Revere Ave	17	: 4	Tree 1	Private 1			6	Width 4ft		6012348.2973	2096415.13527	37.737052151020706	-122.39977477549499	(37.7370521510207, -122.399774775495)
152326	152326	175384	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	3001 Ocean Ave	4	: 4	Tree 1	Private 1			6	Width 3ft		5989533.01366	2095227.55715	37.7324930774849	-122.47856979297899	(37.7324930774849, -122.478569792979)

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