Street_Tree_List

Data source: data.sfgov.org

220 rows where qSiteInfo = 4 and qSpecies = 12

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)
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)
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)
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)
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)
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)
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)
29593	29593	204122	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	72	: 4	Tree 1	Private 1			5	Width 0ft		5991266.86488	2092279.49348	37.7244989453441	-122.472360679302	(37.7244989453441, -122.472360679302)
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)
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)
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)
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)
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)
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)
32909	32909	204147	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	143	: 4	Tree 1	Private 1			8	Width 0ft		5991215.11855	2091556.56269	37.7225109615814	-122.47248687756	(37.7225109615814, -122.47248687756)
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)
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)
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)
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)
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)
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)
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)
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)
38682	38682	204129	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	96	: 4	Tree 1	Private 1			6	Width 0ft		5991250.64251	2092078.2102299999	37.723945332582105	-122.472402090391	(37.7239453325821, -122.472402090391)
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)
39401	39401	246890	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	811 Stanyan St	3	: 4	Tree 1	Private 1			14	Width 3ft		5997132.88901	2107561.88685	37.766798402263206	-122.453185464141	(37.7667984022632, -122.453185464141)
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)
41191	41191	204126	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	82	: 4	Tree 1	Private 1			7	Width 0ft		5991258.86268	2092183.21278	37.7242341192967	-122.472381325945	(37.7242341192967, -122.472381325945)
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)
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)
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)
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)
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)
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)
44167	44167	204151	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	161	: 4	Tree 1	Private 1			6	Width 0ft		5991207.7087199995	2091371.2859599998	37.722001808625706	-122.47249899053499	(37.7220018086257, -122.472498990535)
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)
44766	44766	204146	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	136	: 4	Tree 1	Private 1			7	Width 0ft		5991223.21581	2091608.2334599998	37.7226533053988	-122.472462652551	(37.7226533053988, -122.472462652551)
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)
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)
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)
51196	51196	247602	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	900 Tompkins Ave	7	: 4	Tree 1	Private 1			9	Width 3ft		6009221.28588	2096416.1799299999	37.7368802015456	-122.410586378377	(37.7368802015456, -122.410586378377)
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)
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)
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)
55041	55041	219842	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	200 Portola Dr	7	: 4	Tree 1	Private 1			6	Width 3ft		5999537.02176	2100424.88588	37.747339451848795	-122.44435704444099	(37.7473394518488, -122.444357044441)
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)
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)
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)
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)
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)
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)
63674	63674	204145	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	135	: 4	Tree 1	Private 1			5	Width 0ft		5991223.03412	2091647.11797	37.722760062121104	-122.472466114031	(37.7227600621211, -122.472466114031)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
69170	69170	204084	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	681 Head St	4	: 4	Tree 1	Private 1			7	Width 3ft		5993496.99915	2090384.7018099998	37.7194251277541	-122.46451394876699	(37.7194251277541, -122.464513948767)
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)
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)
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)
72185	72185	247606	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	900 Tompkins Ave	11	: 4	Tree 1	Private 1			11	Width 3ft		6009370.581230001	2096400.99182	37.7368468672911	-122.410069124308	(37.7368468672911, -122.410069124308)
73592	73592	204117	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	40	: 4	Tree 1	Private 1			7	Width 0ft		5991283.0301	2092546.08035	37.7252318622439	-122.472324223488	(37.7252318622439, -122.472324223488)
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)
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)
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)
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)
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)
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)
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)
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)
130029	130029	219841	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	200 Portola Dr	6	: 4	Tree 1	Private 1			5	Width 3ft		5999547.8979	2100446.48985	37.747399391666995	-122.44432098793999	(37.747399391667, -122.44432098794)
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)
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)
130653	130653	204150	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	158	: 4	Tree 1	Private 1			7	Width 0ft		5991209.7349	2091396.16713	37.722070243443206	-122.47249379964799	(37.7220702434432, -122.472493799648)
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)

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