Street_Tree_List

Data source: data.sfgov.org

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

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
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
152085	152085	204148	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	148	: 4	Tree 1	Private 1			5	Width 0ft		5991212.9902099995	2091479.34405	37.7222988151126	-122.472488607883	(37.7222988151126, -122.472488607883)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
134489	134489	204131	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	107	: 4	Tree 1	Private 1			2	Width 0ft		5991246.04706	2091955.1858	37.723607272029604	-122.472409011575	(37.7236072720296, -122.472409011575)
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)
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)
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)
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)
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)
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)
150795	150795	204124	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	77	: 4	Tree 1	Private 1			2	Width 0ft		5991262.393519999	2092231.98748	37.7243682468726	-122.47237267447201	(37.7243682468726, -122.472372674472)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
134146	134146	204110	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	500 Junipero Serra Blvd	24	: 4	Tree 1	Private 1			3	Width 0ft		5991353.72908	2093672.3585599998	37.728328433101794	-122.472161885976	(37.7283284331018, -122.472161885976)
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)
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)
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)
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)
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)
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)
150832	150832	204103	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	300 Junipero Serra Blvd	14	: 4	Tree 1	Private 1			1	Width 0ft		5991407.75535	2094527.8682	37.7306805748458	-122.472037446768	(37.7306805748458, -122.472037446768)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)

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