Street_Tree_List

Data source: data.sfgov.org

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

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
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)
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)
39699	39699	175336	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	114 De Long St	3	: 4	Tree 1	Private 1			9	Width 3ft		5994472.9026	2086825.04671	37.709707367568996	-122.460882785837	(37.709707367569, -122.460882785837)
31818	31818	175337	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	114 De Long St	4	: 4	Tree 1	Private 1			14	Width 3ft		5994455.45704	2086824.9295299998	37.7097060419823	-122.46094307188801	(37.7097060419823, -122.460943071888)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
150929	150929	187505	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1888 Geneva Ave	5	: 4	Tree 1	Private 1			9	Width 3ft		6004874.161669999	2086793.27995	37.710213148986504	-122.42493188792	(37.7102131489865, -122.42493188792)
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)
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)
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)
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)
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)
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)
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)
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)
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)
54859	54859	187528	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	151 Mary Teresa St	4	: 4	Tree 1	Private 1			6	Width 1ft		6012472.93884	2087982.00491	37.7139034450734	-122.398752175284	(37.7139034450734, -122.398752175284)
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)
73954	73954	188039	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Madera St	4	: 4	Tree 1	Private 1			12	Width 3ft		6012947.35937	2103279.6507900003	37.7559340253584	-122.398184994452	(37.7559340253584, -122.398184994452)
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)
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)
134332	134332	188042	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	50 Sierra St	3	: 4	Tree 1	Private 1			6	Width 3ft		6013628.373819999	2104148.89583	37.7583586929149	-122.39589071418001	(37.7583586929149, -122.39589071418)
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)
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)
75579	75579	188047	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1500 22nd St	5	: 4	Tree 1	Private 1			7	Width 3ft		6013488.543409999	2103846.93228	37.7575217865193	-122.396353148306	(37.7575217865193, -122.396353148306)
42095	42095	188048	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1500 22nd St	6	: 4	Tree 1	Private 1			8	Width 3ft		6013469.80822	2103846.3555900003	37.7575191604874	-122.396417902174	(37.7575191604874, -122.396417902174)
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)
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)
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)
135812	135812	188057	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2177 Jerrold Ave	3	: 4	Tree 1	Private 1			5	Width 3ft		6012331.191980001	2099204.96166	37.7447114700542	-122.400029778274	(37.7447114700542, -122.400029778274)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
37689	37689	188071	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2001 Revere Ave	3	: 4	Tree 1	Private 1			5	Width 4ft		6012207.53103	2096519.7102400002	37.7373314435832	-122.400268813564	(37.7373314435832, -122.400268813564)
43025	43025	188072	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2001 Revere Ave	5	: 4	Tree 1	Private 1			5	Width 4ft		6012236.0848900005	2096497.99437	37.737273408537504	-122.400168564334	(37.7372734085375, -122.400168564334)
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)
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)
130621	130621	188075	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2001 Revere Ave	15	: 4	Tree 1	Private 1			5	Width 4ft		6012333.35727	2096426.0066099998	37.7370811685632	-122.39982719337799	(37.7370811685632, -122.399827193378)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
34857	34857	204074	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	216 Arch St	3	: 4	Tree 1	Private 1			8	Width 3ft		5992726.806	2088618.3095900002	37.714530612473105	-122.46704784529699	(37.7145306124731, -122.467047845297)
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)
41338	41338	204076	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	216 Arch St	5	: 4	Tree 1	Private 1			9	Width 3ft		5992727.09649	2088647.4013599998	37.7146105082406	-122.467048955052	(37.7146105082406, -122.467048955052)
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)
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)
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)

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