Street_Tree_List

Data source: data.sfgov.org

175 rows where qSiteInfo = 23 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

- 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: qLegalStatus, qAddress, qCaretaker, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude ▼	Location
108835	108835	113062	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2X Cranleigh Dr	3	: Yard 23	Tree 1	DPW 2		08/18/2016 09:59:00 AM	3			5991370.3	2095943.7	37.734565924896394	-122.472270103664	(37.7345659248964, -122.472270103664)
119367	119367	113063	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2X Cranleigh Dr	4	: Yard 23	Tree 1	DPW 2		08/18/2016 09:56:00 AM	3			5991370.3	2095943.7	37.734565924896394	-122.472270103664	(37.7345659248964, -122.472270103664)
37053	37053	218147	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	33 Ashton Ave	1	: Yard 23	Tree 1	Private 1			8			5994130.90264	2090096.18725	37.7186694580143	-122.462301880921	(37.7186694580143, -122.462301880921)
163941	163941	211530	Undocumented 2	Pittosporum tobira :: Japanese Mockorange 243	321 Melrose Ave	3	: Yard 23	Tree 1	Private 1			16			5997959.2212	2095523.47143	37.733791203898704	-122.44945983462699	(37.7337912038987, -122.449459834627)
164257	164257	205447	Undocumented 2	Cordyline australis :: Dracena Palm 141	321 Melrose Ave	2	: Yard 23	Tree 1	Private 1			2			5997960.43745	2095528.68593	37.7338055912481	-122.44945600530001	(37.7338055912481, -122.4494560053)
32540	32540	210191	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	321 Melrose Ave	1	: Yard 23	Tree 1	Private 1			12			5997966.64829	2095534.3479400002	37.7338214930658	-122.44943494048799	(37.7338214930658, -122.449434940488)
69201	69201	234493	Undocumented 2	Pinus Spp :: Pine Spp 105	3278 Market St	1	: Yard 23	Tree 1	Private 1			14	Width 3ft		5999564.06934	2104457.47233	37.758413493117104	-122.444553299888	(37.7584134931171, -122.444553299888)
156510	156510	233334	Undocumented 2	Pinus radiata :: Monterey Pine 3	91 Stanton St	1	: Yard 23	Tree 1	Private 1			15	Width 3ft		6000284.24588	2103856.40307	37.7568041715962	-122.442019473547	(37.7568041715962, -122.442019473547)
186405	186405	224262	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	91 Stanton St	2	: Yard 23	Tree 1	Private 1			22	Width 3ft		6000293.691000001	2103856.2070400002	37.7568041715846	-122.44198679486	(37.7568041715846, -122.44198679486)
39362	39362	214005	Undocumented 2	Quercus agrifolia :: Coast Live Oak 180	50 Circular Ave	2	: Yard 23	Tree 1	Private 1			17			6000114.23279	2093911.68117	37.7294886448689	-122.441893693449	(37.7294886448689, -122.441893693449)
44764	44764	205937	Undocumented 2	Ceanothus Sps :: California lilac 270	50 Circular Ave	1	: Yard 23	Tree 1	Private 1			6			6000127.5419	2093913.2935099998	37.7294938303644	-122.44184779835501	(37.7294938303644, -122.441847798355)
76142	76142	234859	Undocumented 2	Podocarpus macrophyllus :: Yew Pine 168	160 Carnelian Way	1	: Yard 23	Tree 1	Private 1			8			6000570.21064	2100519.3738	37.7476577875765	-122.44079113720801	(37.7476577875765, -122.440791137208)
150305	150305	234860	Undocumented 2	Podocarpus macrophyllus :: Yew Pine 168	160 Carnelian Way	2	: Yard 23	Tree 1	Private 1			6			6000574.359	2100517.55086	37.7476530184698	-122.44077666170799	(37.7476530184698, -122.440776661708)
46299	46299	233305	Undocumented 2	Pinus radiata :: Monterey Pine 3	170 Carnelian Way	1	: Yard 23	Tree 1	Private 1			17			6000606.984180001	2100509.57943	37.7476329887819	-122.44066327429199	(37.7476329887819, -122.440663274292)
187327	187327	233306	Undocumented 2	Pinus radiata :: Monterey Pine 3	174 Carnelian Way	1	: Yard 23	Tree 1	Private 1			26			6000631.47853	2100513.23992	37.7476444344533	-122.44057883696999	(37.7476444344533, -122.44057883697)
174541	174541	234949	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	176 Carnelian Way	1	: Yard 23	Tree 1	Private 1			21			6000647.81323	2100527.14319	37.74768353965921	-122.44052334968599	(37.7476835396592, -122.440523349686)
63043	63043	209019	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	33 Martha Ave	2	: Yard 23	Tree 1	Private 1			12			6000764.3171	2095528.5679900001	37.7339652640682	-122.43976216978201	(37.7339652640682, -122.439762169782)
153234	153234	209020	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	33 Martha Ave	4	: Yard 23	Tree 1	Private 1			12			6000767.68455	2095534.49854	37.7339817396554	-122.439750952547	(37.7339817396554, -122.439750952547)
185838	185838	209018	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	33 Martha Ave	3	: Yard 23	Tree 1	Private 1			38			6000767.57935	2095529.42368	37.733967799282	-122.439750952539	(37.733967799282, -122.439750952539)
28853	28853	209017	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	33 Martha Ave	1	: Yard 23	Tree 1	Private 1			25			6000774.79116	2095519.5815700002	37.7339411856303	-122.43972531378401	(37.7339411856303, -122.439725313784)
157410	157410	233500	Undocumented 2	Pistacia chinensis :: Chinese Pistache 150	4090 20th St	10	: Yard 23	Tree 1	Private 1			3	Width 3ft		6003098.24212	2104183.0577	37.7578610449587	-122.43231097188601	(37.7578610449587, -122.432310971886)
152563	152563	234500	Undocumented 2	Pinus muricata :: Bishop Pine 302	4090 20th St	8	: Yard 23	Tree 1	Private 1			9	Width 3ft		6003098.9698	2104154.51537	37.757782715804204	-122.43230641682699	(37.7577827158042, -122.432306416827)
164374	164374	222115	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	4090 20th St	9	: Yard 23	Tree 1	Private 1			15	Width 3ft		6003100.58415	2104168.90978	37.757822330949004	-122.432301861758	(37.757822330949, -122.432301861758)
74715	74715	234488	Undocumented 2	Pinus Spp :: Pine Spp 105	4090 20th St	7	: Yard 23	Tree 1	Private 1			16	Width 3ft		6003119.17834	2104176.3954	37.7578439389691	-122.43223808994101	(37.7578439389691, -122.432238089941)
178126	178126	224454	Undocumented 2	Eucalyptus Spp :: Eucalyptus 40	4090 20th St	6	: Yard 23	Tree 1	Private 1			12	Width 3ft		6003124.6046	2104168.08557	37.7578214298263	-122.432218730236	(37.7578214298263, -122.432218730236)
65367	65367	222666	Undocumented 2	Ceanothus Sps :: California lilac 270	4090 20th St	5	: Yard 23	Tree 1	Private 1			8	Width 3ft		6003140.83414	2104172.66898	37.7578349349576	-122.432162929082	(37.7578349349576, -122.432162929082)
48818	48818	222665	Undocumented 2	Ceanothus Sps :: California lilac 270	4090 20th St	4	: Yard 23	Tree 1	Private 1			8	Width 3ft		6003145.04093	2104185.04238	37.7578691478694	-122.432149263871	(37.7578691478694, -122.432149263871)
179643	179643	222664	Undocumented 2	Ceanothus Sps :: California lilac 270	4090 20th St	3	: Yard 23	Tree 1	Private 1			9	Width 3ft		6003149.42788	2104190.19818	37.7578835531891	-122.432134460156	(37.7578835531891, -122.432134460156)
146754	146754	240351	Undocumented 2	Quercus suber :: Cork Oak 76	4090 20th St	1	: Yard 23	Tree 1	Private 1			22	Width 3ft		6003153.88022	2104182.56452	37.7578628454134	-122.432118516979	(37.7578628454134, -122.432118516979)
172054	172054	222663	Undocumented 2	Ceanothus Sps :: California lilac 270	4090 20th St	2	: Yard 23	Tree 1	Private 1			9	Width 3ft		6003162.223809999	2104187.96649	37.7578781509761	-122.43209004713002	(37.7578781509761, -122.43209004713)
24928	24928	223320	Undocumented 2	Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197	4404 20th St	5	: Yard 23	Tree 1	Private 1			6	Width 3ft		6003607.3788	2104219.57182	37.7579901597246	-122.430552770305	(37.7579901597246, -122.430552770305)
38165	38165	223321	Undocumented 2	Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197	4404 20th St	6	: Yard 23	Tree 1	Private 1			6	Width 3ft		6003607.59341	2104210.2360400003	37.757964538052796	-122.430551361954	(37.7579645380528, -122.430551361954)
68242	68242	223322	Undocumented 2	Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197	4404 20th St	7	: Yard 23	Tree 1	Private 1			6	Width 3ft		6003609.4958	2104203.70513	37.757946713498704	-122.430544316686	(37.7579467134987, -122.430544316686)
167772	167772	245705	Undocumented 2	Cordyline australis :: Dracena Palm 141	4001 20th St	1	: Yard 23	Tree 1	Private 1			16	Width 3ft		6003616.02573	2104184.50188	37.757894355861396	-122.430520363245	(37.7578943558614, -122.430520363245)
151521	151521	223316	Undocumented 2	Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197	4404 20th St	1	: Yard 23	Tree 1	Private 1			3	Width 3ft		6003622.06269	2104228.7754599997	37.7580162625599	-122.430502643895	(37.7580162625599, -122.430502643895)
25470	25470	223317	Undocumented 2	Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197	4404 20th St	2	: Yard 23	Tree 1	Private 1			3	Width 3ft		6003628.73131	2104227.65103	37.7580135529078	-122.430479500748	(37.7580135529078, -122.430479500748)
132798	132798	245706	Undocumented 2	Cordyline australis :: Dracena Palm 141	4001 20th St	3	: Yard 23	Tree 1	Private 1			16	Width 3ft		6003635.70774	2104190.5874799998	37.7579121804175	-122.430452728819	(37.7579121804175, -122.430452728819)
156226	156226	223318	Undocumented 2	Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197	4404 20th St	3	: Yard 23	Tree 1	Private 1			6	Width 3ft		6003637.291809999	2104227.88023	37.75801466716629	-122.43044991126101	(37.7580146671663, -122.430449911261)
171294	171294	223319	Undocumented 2	Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197	4404 20th St	4	: Yard 23	Tree 1	Private 1			3	Width 3ft		6003647.0575	2104227.27295	37.7580135529116	-122.43041609403299	(37.7580135529116, -122.430416094033)
77285	77285	221965	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	4001 20th St	5	: Yard 23	Tree 1	Private 1			4	Width 3ft		6003646.65326	2104187.9271299997	37.7579054957544	-122.43041468480699	(37.7579054957544, -122.430414684807)
43379	43379	223787	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	4404 20th St	9	: Yard 23	Tree 1	Private 1			44	Width 3ft		6003650.35726	2104229.2336	37.75801912330729	-122.430404821951	(37.7580191233073, -122.430404821951)
44358	44358	245707	Undocumented 2	Cordyline australis :: Dracena Palm 141	4001 20th St	4	: Yard 23	Tree 1	Private 1			16	Width 3ft		6003651.76342	2104178.89616	37.7578809883279	-122.430396367393	(37.7578809883279, -122.430396367393)
75344	75344	233331	Undocumented 2	Pinus radiata :: Monterey Pine 3	4404 20th St	10	: Yard 23	Tree 1	Private 1			16	Width 3ft		6003656.39078	2104225.45781	37.7580090976571	-122.430383686085	(37.7580090976571, -122.430383686085)
158856	158856	177486	Undocumented 2	Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315	601 La Grande Ave	1	: Yard 23	Tree 1	Private 1			6			6004368.23495	2089081.7920799998	37.7164683196427	-122.42684334834999	(37.7164683196427, -122.42684334835)
122547	122547	176099	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	491 La Grande Ave	1	: Yard 23	Tree 1	Private 1			43			6004400.9540099995	2089156.27858	37.716674693347	-122.42673555649999	(37.716674693347, -122.4267355565)
162701	162701	176100	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	491 La Grande Ave	2	: Yard 23	Tree 1	Private 1			19			6004405.409030001	2089175.08917	37.7167265950249	-122.42672149649799	(37.7167265950249, -122.426721496498)
45680	45680	176101	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	491 La Grande Ave	3	: Yard 23	Tree 1	Private 1			26			6004411.36222	2089192.97967	37.716776055035794	-122.426702192554	(37.7167760550358, -122.426702192554)
26291	26291	178180	Undocumented 2	Pinus radiata :: Monterey Pine 3	491 La Grande Ave	4	: Yard 23	Tree 1	Private 1			20			6004422.927759999	2089235.71163	37.716894041605	-122.42666525741001	(37.716894041605, -122.42666525741)
123420	123420	178181	Undocumented 2	Pinus radiata :: Monterey Pine 3	491 La Grande Ave	5	: Yard 23	Tree 1	Private 1			23			6004429.890380001	2089255.59598	37.7169490333536	-122.42664260617501	(37.7169490333536, -122.426642606175)
129806	129806	234413	Undocumented 2	Phoenix dactylifera :: Date Palm 65	280 Justin Dr	1	: Yard 23	Tree 1	Private 1			26	Width 3ft		6005966.47626	2094899.24737	37.7325320253145	-122.42173199844	(37.7325320253145, -122.42173199844)
49162	49162	234414	Undocumented 2	Phoenix dactylifera :: Date Palm 65	280	2	: Yard 23	Tree 1	Private 1			23	Width 3ft		6005979.042880001	2094923.96665	37.7326006076366	-122.421690307661	(37.7326006076366, -122.421690307661)
151779	151779	241988	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	199 Franconia St	18	: Yard 23	Tree 1	Private 1			5	Width 3ft		6010085.85388	2099710.92257	37.745975284649	-122.40782942930299	(37.745975284649, -122.407829429303)
154821	154821	237005	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	199 Franconia St	16	: Yard 23	Tree 1	Private 1			9	Width 3ft		6010090.49979	2099699.0653	37.7459429872721	-122.40781252834101	(37.7459429872721, -122.407812528341)
37605	37605	237004	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	199 Franconia St	15	: Yard 23	Tree 1	Private 1			8	Width 3ft		6010095.49496	2099684.36191	37.7459028946219	-122.40779421904101	(37.7459028946219, -122.407794219041)
73122	73122	225894	Undocumented 2	Fremontodendron spp :: Flannel Bush Tree 331	199 Franconia St	17	: Yard 23	Tree 1	Private 1			7	Width 3ft		6010105.1921	2099680.51389	37.7458928716644	-122.407760416232	(37.7458928716644, -122.407760416232)
37555	37555	237003	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	199 Franconia St	14	: Yard 23	Tree 1	Private 1			9	Width 3ft		6010106.165469999	2099668.32603	37.7458594609566	-122.40775619120001	(37.7458594609566, -122.4077561912)
32348	32348	233229	Undocumented 2	Olea europaea :: Olive Tree 41	199 Franconia St	2	: Yard 23	Tree 1	Private 1			5	Width 3ft		6010110.29265	2099690.9553400003	37.745921827136996	-122.407743515268	(37.745921827137, -122.407743515268)
169576	169576	233228	Undocumented 2	Olea europaea :: Olive Tree 41	199 Franconia St	1	: Yard 23	Tree 1	Private 1			6	Width 3ft		6010113.61596	2099694.13241	37.7459307367175	-122.407732247644	(37.7459307367175, -122.407732247644)
25729	25729	233231	Undocumented 2	Olea europaea :: Olive Tree 41	199 Franconia St	4	: Yard 23	Tree 1	Private 1			6	Width 3ft		6010116.17645	2099679.88413	37.7458917573937	-122.407722389299	(37.7458917573937, -122.407722389299)
31996	31996	237002	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	199 Franconia St	11	: Yard 23	Tree 1	Private 1			12	Width 3ft		6010115.457330001	2099644.6115099997	37.745794866235	-122.40772238927	(37.745794866235, -122.40772238927)
161704	161704	225066	Undocumented 2	Ceratonia siliqua :: Carob 97	199 Franconia St	13	: Yard 23	Tree 1	Private 1			5	Width 3ft		6010116.17854	2099660.00965	37.745837186534295	-122.407720980957	(37.7458371865343, -122.407720980957)
173331	173331	233230	Undocumented 2	Olea europaea :: Olive Tree 41	199 Franconia St	3	: Yard 23	Tree 1	Private 1			5	Width 3ft		6010120.38838	2099686.6934	37.745910689944104	-122.407708305	(37.7459106899441, -122.407708305)
152462	152462	233605	Undocumented 2	Olea europaea :: Olive Tree 41	199 Franconia St	12	: Yard 23	Tree 1	Private 1			9	Width 3ft		6010122.88511	2099649.32748	37.745808231063705	-122.407697037414	(37.7458082310637, -122.407697037414)
156957	156957	233233	Undocumented 2	Olea europaea :: Olive Tree 41	199 Franconia St	6	: Yard 23	Tree 1	Private 1			9	Width 3ft		6010125.251569999	2099665.5030400003	37.745852778088	-122.407689994823	(37.745852778088, -122.407689994823)
70403	70403	233232	Undocumented 2	Olea europaea :: Olive Tree 41	199 Franconia St	5	: Yard 23	Tree 1	Private 1			10	Width 3ft		6010129.8045	2099669.06085	37.7458628019252	-122.407674502171	(37.7458628019252, -122.407674502171)
40295	40295	233234	Undocumented 2	Olea europaea :: Olive Tree 41	199 Franconia St	7	: Yard 23	Tree 1	Private 1			4	Width 3ft		6010136.86006	2099655.53222	37.7458260502241	-122.40764915121099	(37.7458260502241, -122.407649151211)
134356	134356	233602	Undocumented 2	Olea europaea :: Olive Tree 41	199 Franconia St	8	: Yard 23	Tree 1	Private 1			6	Width 3ft		6010143.5997	2099646.47131	37.7458015482156	-122.40762520763701	(37.7458015482156, -122.407625207637)
154537	154537	233603	Undocumented 2	Olea europaea :: Olive Tree 41	199 Franconia St	9	: Yard 23	Tree 1	Private 1			6	Width 3ft		6010152.72418	2099634.5230799997	37.7457692517475	-122.40759281407101	(37.7457692517475, -122.407592814071)
76157	76157	233604	Undocumented 2	Olea europaea :: Olive Tree 41	199 Franconia St	10	: Yard 23	Tree 1	Private 1			3	Width 3ft		6010160.0797	2099615.7154599996	37.7457180218657	-122.40756605383301	(37.7457180218657, -122.407566053833)
38615	38615	177876	Undocumented 2	Olea europaea :: Olive Tree 41	4117 San Bruno Ave	1	: Yard 23	Tree 1	Private 1			37	Width 10ft		6011467.53014	2087476.31968	37.7124588649577	-122.40219173226299	(37.7124588649577, -122.402191732263)
138227	138227	199545	Undocumented 2	Yucca gloriosa :: Spanish Dagger 224	1 01st St	1	: Yard 23	Tree 1	Private 1			12			6014356.43896	2105915.99545	37.7632512422621	-122.39349639336099	(37.7632512422621, -122.393496393361)
165472	165472	199546	Undocumented 2	Yucca gloriosa :: Spanish Dagger 224	1 01st St	2	: Yard 23	Tree 1	Private 1			8			6014366.09507	2105920.56167	37.7632643166198	-122.393463315392	(37.7632643166198, -122.393463315392)
166837	166837	199547	Undocumented 2	Yucca gloriosa :: Spanish Dagger 224	1 01st St	3	: Yard 23	Tree 1	Private 1			15			6014373.91679	2105917.88241	37.763257394541796	-122.39343607492201	(37.7632573945418, -122.393436074922)
137382	137382	189292	Undocumented 2	Cordyline australis :: Dracena Palm 141	1 01st St	33	: Yard 23	Tree 1	Private 1			5			6014376.229280001	2105886.6133	37.763171664875294	-122.393425888311	(37.7631716648753, -122.393425888311)
134605	134605	194275	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	1 01st St	34	: Yard 23	Tree 1	Private 1			8			6014376.659969999	2105881.88915	37.76315871732	-122.39342406806101	(37.76315871732, -122.393424068061)
171136	171136	199548	Undocumented 2	Yucca gloriosa :: Spanish Dagger 224	1 01st St	4	: Yard 23	Tree 1	Private 1			9			6014382.11605	2105919.95745	37.7632635477036	-122.39340786139499	(37.7632635477036, -122.393407861395)
58033	58033	189291	Undocumented 2	Cordyline australis :: Dracena Palm 141	1 01st St	31	: Yard 23	Tree 1	Private 1			5			6014386.77773	2105894.3895799997	37.7631936029157	-122.39338994869	(37.7631936029157, -122.39338994869)
59106	59106	189293	Undocumented 2	Cordyline australis :: Dracena Palm 141	1 01st St	35	: Yard 23	Tree 1	Private 1			8			6014389.3663800005	2105866.30731	37.7631166389548	-122.39337903001801	(37.7631166389548, -122.393379030018)
139126	139126	199549	Undocumented 2	Yucca gloriosa :: Spanish Dagger 224	1 01st St	5	: Yard 23	Tree 1	Private 1			9			6014392.26095	2105920.87265	37.7632666242892	-122.39337283731399	(37.7632666242892, -122.393372837314)
70245	70245	190636	Undocumented 2	Hakea suaveolens :: Sweet Hakea Tree 14	1 01st St	30	: Yard 23	Tree 1	Private 1			8			6014391.99798	2105898.86804	37.763206189822796	-122.393372206868	(37.7632061898228, -122.393372206868)
157392	157392	190908	Undocumented 2	Cotinus coggygria 'Royal Purple' :: Smoke tree 298	1 01st St	32	: Yard 23	Tree 1	Private 1			1			6014392.80706	2105893.3505	37.7631910848138	-122.393369022367	(37.7631910848138, -122.393369022367)
70813	70813	199550	Undocumented 2	Yucca gloriosa :: Spanish Dagger 224	1 01st St	6	: Yard 23	Tree 1	Private 1			15			6014401.0054	2105922.09622	37.7632704697749	-122.393342678542	(37.7632704697749, -122.393342678542)
152443	152443	196094	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1 01st St	26	: Yard 23	Tree 1	Private 1			8			6014400.8809	2105882.83985	37.7631626734333	-122.393340361863	(37.7631626734333, -122.393340361863)
38723	38723	191689	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	1 01st St	27	: Yard 23	Tree 1	Private 1			3			6014402.09171	2105890.67407	37.7631842517621	-122.393336722306	(37.7631842517621, -122.393336722306)
29380	29380	196093	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1 01st St	25	: Yard 23	Tree 1	Private 1			8			6014406.1146599995	2105887.9731	37.763177058994	-122.39332261913601	(37.763177058994, -122.393322619136)
73004	73004	190635	Undocumented 2	Hakea suaveolens :: Sweet Hakea Tree 14	1 01st St	28	: Yard 23	Tree 1	Private 1			9			6014407.37845	2105898.42582	37.7632058300952	-122.393318979581	(37.7632058300952, -122.393318979581)
41043	41043	199551	Undocumented 2	Yucca gloriosa :: Spanish Dagger 224	1 01st St	7	: Yard 23	Tree 1	Private 1			15			6014408.59689	2105921.94262	37.7632704697891	-122.39331641112899	(37.7632704697891, -122.393316411129)
56524	56524	191026	Undocumented 2	Cussonia spicata :: Cabbage tree 325	1 01st St	36	: Yard 23	Tree 1	Private 1			3			6014407.16325	2105848.78864	37.7630695252734	-122.39331625017	(37.7630695252734, -122.39331625017)
170055	170055	199552	Undocumented 2	Yucca gloriosa :: Spanish Dagger 224	1 01st St	8	: Yard 23	Tree 1	Private 1			15			6014417.3246	2105922.3261	37.7632720076265	-122.39328625146099	(37.7632720076265, -122.393286251461)
24708	24708	199517	Undocumented 2	Yucca elephantipes :: Giant Yucca 211	1 01st St	13	: Yard 23	Tree 1	Private 1			3			6014420.56618	2105901.8129	37.763215862946	-122.39327360428801	(37.763215862946, -122.393273604288)
76538	76538	199553	Undocumented 2	Yucca gloriosa :: Spanish Dagger 224	1 01st St	9	: Yard 23	Tree 1	Private 1			20			6014424.93308	2105923.01259	37.7632743152759	-122.393259984074	(37.7632743152759, -122.393259984074)
32102	32102	189290	Undocumented 2	Cordyline australis :: Dracena Palm 141	1 01st St	23	: Yard 23	Tree 1	Private 1			5			6014424.75736	2105899.2532900004	37.7632090676603	-122.39325892915501	(37.7632090676603, -122.393258929155)
132015	132015	196092	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1 01st St	24	: Yard 23	Tree 1	Private 1			10			6014425.82588	2105887.0502299997	37.7631756200823	-122.393254379501	(37.7631756200823, -122.393254379501)
28405	28405	199554	Undocumented 2	Yucca gloriosa :: Spanish Dagger 224	1 01st St	10	: Yard 23	Tree 1	Private 1			17			6014431.6868199995	2105923.15598	37.763275084200295	-122.39323663496599	(37.7632750842003, -122.393236634966)
147367	147367	194594	Undocumented 2	Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193	1 01st St	22	: Yard 23	Tree 1	Private 1			10			6014433.28496	2105898.16367	37.7632065495547	-122.393229358544	(37.7632065495547, -122.393229358544)
153814	153814	199510	Undocumented 2	Quercus engelmannii :: Engelmann oak 453	1 01st St	14	: Yard 23	Tree 1	Private 1			5			6014434.26374	2105920.54159	37.7632680488164	-122.39322753922801	(37.7632680488164, -122.393227539228)
134619	134619	199515	Undocumented 2	Yucca elephantipes :: Giant Yucca 211	1 01st St	11	: Yard 23	Tree 1	Private 1			3			6014438.12631	2105919.24405	37.7632647006382	-122.393214088968	(37.7632647006382, -122.393214088968)
48813	48813	199516	Undocumented 2	Yucca elephantipes :: Giant Yucca 211	1 01st St	12	: Yard 23	Tree 1	Private 1			3			6014441.55665	2105919.02201	37.7632642815347	-122.393202208925	(37.7632642815347, -122.393202208925)
177343	177343	199556	Undocumented 2	Yucca gloriosa :: Spanish Dagger 224	1 01st St	17	: Yard 23	Tree 1	Private 1			4			6014441.57524	2105911.35616	37.7632432338158	-122.39320160818599	(37.7632432338158, -122.393201608186)
182983	182983	194593	Undocumented 2	Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193	1 01st St	21	: Yard 23	Tree 1	Private 1			19			6014441.963140001	2105885.02123	37.763170945392496	-122.393198423694	(37.7631709453925, -122.393198423694)

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