Street_Tree_List

Data source: data.sfgov.org

2,305 rows where PlotSize = "Width 3ft" and qSiteInfo = 2 sorted by qCareAssistant

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: qLegalStatus, qCaretaker, PlantDate, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant ▼	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
539	539	206615	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	198 Vasquez Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft	Permit Number 779324	5994758.52704	2099346.29484	37.7441041156281	-122.460802465585	(37.7441041156281, -122.460802465585)
553	553	206616	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	198 Vasquez Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft	Permit Number 779324	5994742.56026	2099334.6803900003	37.7440713065495	-122.460856833195	(37.7440713065495, -122.460856833195)
565	565	206617	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	198 Garcia Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5994686.63181	2099351.09779	37.7441131663853	-122.461051409618	(37.7441131663853, -122.461051409618)
571	571	206618	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	198 Garcia Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft	Permit Number 779324	5994673.79551	2099409.87557	37.7442738167873	-122.461100053935	(37.7442738167873, -122.461100053935)
789	789	175382	DPW Maintained 3	Ulmus pumila :: Siberian Elm 53	80x Junipero Serra Blvd	19	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2			2	Width 3ft		5991305.518069999	2089124.29272	37.7158377779634	-122.471997198511	(37.7158377779634, -122.471997198511)
854	854	203901	DPW Maintained 3	Acacia melanoxylon :: Blackwood Acacia 5	3794 19th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2			12	Width 3ft		5990470.121669999	2090714.3108400002	37.720155198286	-122.475000685058	(37.720155198286, -122.475000685058)
892	892	251400	Undocumented 2	Celtis sinensis :: Chinese Hackberry 111	101 Rhine St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1				Width 3ft		5994375.43496	2086552.5575599999	37.7089535675334	-122.461199910156	(37.7089535675334, -122.461199910156)
1785	1785	228278	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	2050 15th St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		6003817.0	2107261.0	37.7663530653237	-122.430044770651	(37.7663530653237, -122.430044770651)
2066	2066	252868	Undocumented 2	Shrub :: Shrub 98	15 Foerster St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1				Width 3ft		5998080.65269	2093664.7185	37.7286944544712	-122.44890616611099	(37.7286944544712, -122.448906166111)
2092	2092	196948	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	3536 Jennings St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		6013049.3063900005	2089480.54762	37.718050242412296	-122.39686501810199	(37.7180502424123, -122.396865018102)
2094	2094	252881	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	3536 Jennings St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1				Width 3ft		6013049.3063900005	2089480.54762	37.718050242412296	-122.39686501810199	(37.7180502424123, -122.396865018102)
2102	2102	196505	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	3536 Jennings St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		6013064.418880001	2089502.0027700001	37.7181099951501	-122.39681428375299	(37.7181099951501, -122.396814283753)
2402	2402	201606	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	598 Innes Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		07/12/2017 12:00:00 AM	1	Width 3ft		6020954.32481	2093200.4635700001	37.7287012794353	-122.36979738594101	(37.7287012794353, -122.369797385941)
2465	2465	201607	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	598 Innes Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		07/12/2017 12:00:00 AM	1	Width 3ft		6020934.32673	2093214.8340900003	37.7287396409072	-122.36986751418699	(37.7287396409072, -122.369867514187)
2814	2814	241583	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	38X Java St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5999751.0	2107467.0	37.7666875731096	-122.444123063419	(37.7666875731096, -122.444123063419)
2837	2837	241584	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	38X Java St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5999751.0	2107467.0	37.7666875731096	-122.444123063419	(37.7666875731096, -122.444123063419)
2841	2841	241585	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	38X Java St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5999751.0	2107467.0	37.7666875731096	-122.444123063419	(37.7666875731096, -122.444123063419)
3065	3065	175836	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	101 Rhine St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994366.585519999	2086543.72285	37.70892880020671	-122.46122985488998	(37.7089288002067, -122.46122985489)
3254	3254	244746	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	98 12th St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		6007069.86029	2109755.10428	37.7733849739584	-122.418970623803	(37.7733849739584, -122.418970623803)
3678	3678	208759	Permitted Site 1	Magnolia grandiflora :: Southern Magnolia 21	300 Dorantes Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/24/2005 12:00:00 AM	2	Width 3ft	Permit Number 48287	5993126.46853	2099702.60224	37.7449884054972	-122.466471606489	(37.7449884054972, -122.466471606489)
3683	3683	213464	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	300 Dorantes Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/24/2005 12:00:00 AM	2	Width 3ft	Permit Number 48287	5993110.29995	2099700.9644	37.7449829754007	-122.46652739502701	(37.7449829754007, -122.466527395027)
3768	3768	228283	Section 143 8	Ginkgo biloba :: Maidenhair Tree 44	2036X 15th St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		6003817.0	2107261.0	37.7663530653237	-122.430044770651	(37.7663530653237, -122.430044770651)
3773	3773	228285	Section 143 8	Ginkgo biloba :: Maidenhair Tree 44	2036X 15th St	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		6003817.0	2107261.0	37.7663530653237	-122.430044770651	(37.7663530653237, -122.430044770651)
3775	3775	228281	Section 143 8	Ginkgo biloba :: Maidenhair Tree 44	2036X 15th St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		6003817.0	2107261.0	37.7663530653237	-122.430044770651	(37.7663530653237, -122.430044770651)
3776	3776	228280	Section 143 8	Ginkgo biloba :: Maidenhair Tree 44	2036X 15th St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		6003817.0	2107261.0	37.7663530653237	-122.430044770651	(37.7663530653237, -122.430044770651)
3780	3780	228286	Section 143 8	Ginkgo biloba :: Maidenhair Tree 44	2036X 15th St	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		6003817.0	2107261.0	37.7663530653237	-122.430044770651	(37.7663530653237, -122.430044770651)
3781	3781	228284	Section 143 8	Ginkgo biloba :: Maidenhair Tree 44	2036X 15th St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		6003817.0	2107261.0	37.7663530653237	-122.430044770651	(37.7663530653237, -122.430044770651)
3791	3791	228279	Section 143 8	Ginkgo biloba :: Maidenhair Tree 44	2036X 15th St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		6003817.0	2107261.0	37.7663530653237	-122.430044770651	(37.7663530653237, -122.430044770651)
3795	3795	228282	Section 143 8	Ginkgo biloba :: Maidenhair Tree 44	2036X 15th St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		6003817.0	2107261.0	37.7663530653237	-122.430044770651	(37.7663530653237, -122.430044770651)
3800	3800	213446	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	530 Magellan Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5993033.55222	2099443.36305	37.744271238444206	-122.46677405027799	(37.7442712384442, -122.466774050278)
3812	3812	253561	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	530 Magellan Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1				Width 3ft		5993033.55222	2099443.36305	37.744271238444206	-122.46677405027799	(37.7442712384442, -122.466774050278)
3816	3816	219559	Undocumented 2	Ulmus americana :: American Elm 119	4 Cortes Ave	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 3ft		5993189.55754	2099585.29183	37.7446699411581	-122.46624493416799	(37.7446699411581, -122.466244934168)
3822	3822	253559	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	4 Cortes Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1				Width 3ft		5993184.39566	2099612.1282900004	37.7447433294416	-122.46626473273199	(37.7447433294416, -122.466264732732)
3920	3920	216755	Undocumented 2	Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73	115 Harold Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/04/2017 01:38:00 PM	3	Width 3ft		5996789.877280001	2090654.02957	37.720353912480995	-122.453151180205	(37.720353912481, -122.453151180205)
4006	4006	216739	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	11 Brighton Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/05/2017 08:12:00 AM	3	Width 3ft		5996185.57101	2089978.26988	37.7184637821573	-122.4551912491	(37.7184637821573, -122.4551912491)
4129	4129	216706	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	231 Faxon Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/06/2017 08:40:00 AM	3	Width 3ft		5994712.86869	2090137.86358	37.718817384787606	-122.460293291921	(37.7188173847876, -122.460293291921)
4146	4146	216707	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	230 Faxon Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/06/2017 08:46:00 AM	3	Width 3ft		5994758.05727	2090129.91465	37.7187981581945	-122.460136518501	(37.7187981581945, -122.460136518501)
4150	4150	216749	Undocumented 2	Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73	26 Granada Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/06/2017 08:25:00 AM	3	Width 3ft		5995639.9781599995	2090086.85434	37.7187306119189	-122.45708497580699	(37.7187306119189, -122.457084975807)
4152	4152	216685	Undocumented 2	Olea europaea 'Fruitless' :: Fruitless Olive 80	111 Ashton Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/06/2017 08:11:00 AM	3	Width 3ft		5994133.1609	2090669.8719900001	37.720244788744104	-122.46233566126101	(37.7202447887441, -122.462335661261)
4153	4153	216751	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	31 Granada Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/06/2017 08:38:00 AM	3	Width 3ft		5995599.77101	2090122.1597400003	37.718825243070604	-122.45722650749799	(37.7188252430706, -122.457226507498)
4163	4163	216683	Undocumented 2	Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77	129 Ashton Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/06/2017 08:06:00 AM	3	Width 3ft		5994135.07503	2090797.4570099998	37.7205952167724	-122.462338293592	(37.7205952167724, -122.462338293592)
4293	4293	216862	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	272 Sadowa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/10/2017 08:43:00 AM	3	Width 3ft		5994260.82584	2087785.69998	37.7123328897311	-122.461685361516	(37.7123328897311, -122.461685361516)
4315	4315	216902	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	174 Bright St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/11/2017 11:02:00 AM	3	Width 3ft		5993764.72474	2088364.55203	37.7138937098892	-122.46344200363899	(37.7138937098892, -122.463442003639)
4400	4400	251729	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	35 Bruce Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/11/2017 10:39:00 AM	3	Width 3ft		5997172.50242	2091270.81822	37.7220693917577	-122.45187305021099	(37.7220693917577, -122.451873050211)
4415	4415	216758	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	35 Bruce Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/11/2017 10:35:00 AM	3	Width 3ft		5997172.50242	2091270.81822	37.7220693917577	-122.45187305021099	(37.7220693917577, -122.451873050211)
4451	4451	216718	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	978 Capitol Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/13/2017 11:36:00 AM	3	Width 3ft		5995057.03199	2090421.24862	37.7196152839906	-122.45912417326299	(37.7196152839906, -122.459124173263)
4467	4467	216711	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	922 Capitol Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/13/2017 12:14:00 PM	3	Width 3ft		5995050.42243	2090071.97473	37.7186558809545	-122.45912174238998	(37.7186558809545, -122.45912174239)
4488	4488	216714	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	934 Capitol Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/13/2017 11:10:00 AM	3	Width 3ft		5995052.942530001	2090158.7504099999	37.7188942912315	-122.459119311509	(37.7188942912315, -122.459119311509)
4797	4797	214559	DPW Maintained 3	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1342 Irving St	1	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		02/18/2009 12:00:00 AM	3	Width 3ft		5991532.56497	2106606.32246	37.7638521099028	-122.472486197695	(37.7638521099028, -122.472486197695)
4821	4821	214558	DPW Maintained 3	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1340 Irving St	1	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		02/18/2009 12:00:00 AM	4	Width 3ft		5991564.93185	2106609.34919	37.7638622938456	-122.472374472204	(37.7638622938456, -122.472374472204)
4903	4903	239064	DPW Maintained 3	Pyrus calleryana :: Ornamental Pear 9	68 12th St	3	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		10/31/2016 12:00:00 AM	3	Width 3ft		6007045.28032	2109725.44965	37.77330216528821	-122.41905354577699	(37.7733021652882, -122.419053545777)
5245	5245	205593	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	30 Vasquez Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5995699.652000001	2100090.8564	37.746202601761105	-122.45760214624201	(37.7462026017611, -122.457602146242)
22816	22816	208166	Undocumented 2	Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328	15 Santa Rita Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5993909.69845	2100938.88006	37.7484280758139	-122.463853078355	(37.7484280758139, -122.463853078355)
22912	22912	210552	Undocumented 2	Myoporum laetum :: Myoporum 1	414 Dewey Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 3ft		5995155.65345	2100448.38141	37.7471530116111	-122.459509101961	(37.7471530116111, -122.459509101961)
23367	23367	208982	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	320 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			45	Width 3ft		5993096.565780001	2095876.3159599998	37.7344806601409	-122.46629697974501	(37.7344806601409, -122.466296979745)
23375	23375	218050	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	72 San Rafael Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5991878.2117099995	2095609.0189900002	37.7336763568794	-122.470489732417	(37.7336763568794, -122.470489732417)
23387	23387	213501	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	787 Faxon Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5994873.7468	2093233.8423799998	37.7273274525845	-122.459961359351	(37.7273274525845, -122.459961359351)
23396	23396	218586	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	3666 19th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 3ft		5990534.77048	2091965.7217599999	37.7235950079882	-122.474868513494	(37.7235950079882, -122.474868513494)
23409	23409	218091	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	62 Eastwood Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5995658.864080001	2092992.02847	37.726708612908	-122.45722974236601	(37.726708612908, -122.457229742366)
23425	23425	236043	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	821 Duboce Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 3ft		6001824.27489	2108233.40905	37.768910001429	-122.43700684760701	(37.768910001429, -122.437006847607)
23431	23431	213073	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	50 Castenada Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5994467.524230001	2101712.07423	37.7505832012692	-122.46198020334299	(37.7505832012692, -122.461980203343)
23485	23485	206309	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	226 Sadowa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 3ft		5994744.569130001	2087779.6169999999	37.712344021541796	-122.46001297051599	(37.7123440215418, -122.460012970516)
23538	23538	213933	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	2176 16th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5991344.08373	2100608.05246	37.7473715261751	-122.472700716564	(37.7473715261751, -122.472700716564)
23557	23557	213451	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	4 Cortes Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 3ft		5993177.52134	2099659.6696900004	37.7448734694269	-122.466291957027	(37.7448734694269, -122.466291957027)
23592	23592	218660	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	70 Eastwood Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 3ft		5995653.32428	2093064.51564	37.726907327111	-122.45725413468901	(37.726907327111, -122.457254134689)
23652	23652	210826	Undocumented 2	Olea europaea :: Olive Tree 41	62 Castenada Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 3ft		5994426.39557	2101510.85772	37.7500283438364	-122.462107837801	(37.7500283438364, -122.462107837801)
23775	23775	250341	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	26 25th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 3ft		5988236.1256800005	2115814.85446	37.7889448119981	-122.48456293444599	(37.7889448119981, -122.484562934446)
23876	23876	218979	Undocumented 2	Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10	551 Junipero Serra Blvd	18	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5991462.95986	2093729.88952	37.7284927194476	-122.47178846497101	(37.7284927194476, -122.471788464971)
23888	23888	209236	Undocumented 2	Maytenus boaria :: Mayten 22	32 Malta Dr	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 3ft		5999655.9462	2095979.13545	37.735139265160704	-122.443626491896	(37.7351392651607, -122.443626491896)
23989	23989	206572	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	51 Cortes Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5993215.16949	2099646.04946	37.7448382439064	-122.466160788211	(37.7448382439064, -122.466160788211)
24024	24024	206902	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	901 Monterey Blvd	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5996057.83075	2094626.65779	37.7312198182223	-122.45596865725	(37.7312198182223, -122.45596865725)
24050	24050	209682	Undocumented 2	Maytenus boaria :: Mayten 22	1849 15th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5991553.31162	2102854.2151599997	37.7535510143851	-122.472140928188	(37.7535510143851, -122.472140928188)
24094	24094	118130	Undocumented 2	Cordyline australis :: Dracena Palm 141	3329 Balboa St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5985237.75106	2111079.5821	37.775768059624504	-122.494587526681	(37.7757680596245, -122.494587526681)
24193	24193	127237	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1600 Broadway	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 3ft		6001081.5481199995	2117269.05753	37.7936773440867	-122.440223932108	(37.7936773440867, -122.440223932108)
24227	24227	203475	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	2357 16th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5991280.398630001	2099387.14513	37.7440155431828	-122.472831922275	(37.7440155431828, -122.472831922275)
24235	24235	217813	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	198 Lee Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5996579.91933	2091952.01212	37.7239058307663	-122.453970623549	(37.7239058307663, -122.453970623549)
24238	24238	223314	Undocumented 2	Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197	737 Sanchez St	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		6003692.0750400005	2104158.0805900004	37.7578261171073	-122.43025546792101	(37.7578261171073, -122.430255467921)
24330	24330	205383	Undocumented 2	Cordyline australis :: Dracena Palm 141	64 Ventura Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5994182.66644	2101796.2621	37.750797955763396	-122.46297136414101	(37.7507979557634, -122.462971364141)
24365	24365	177331	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	230 Mansell St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		6011147.98766	2090617.26897	37.7210654327147	-122.403517019111	(37.7210654327147, -122.403517019111)
24378	24378	124854	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	55 Casa Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		6001534.02589	2121572.74926	37.8055198982766	-122.438966893034	(37.8055198982766, -122.438966893034)
24381	24381	205069	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	851 Junipero Serra Blvd	17	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5991341.17231	2091818.7337900002	37.723238113832004	-122.472070242354	(37.723238113832, -122.472070242354)
24385	24385	221202	Undocumented 2	Betula spp :: Birch 95	612 Douglass St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		6001183.09453	2102793.98455	37.75393820848979	-122.438834798788	(37.7539382084898, -122.438834798788)
24438	24438	118836	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	600 46th Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			30	Width 3ft		5981651.25866	2111619.12831	37.77703893001029	-122.50703392298401	(37.7770389300103, -122.507033922984)
24441	24441	213456	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	305 Dorantes Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 3ft		5993116.56669	2099668.45247	37.7448940675206	-122.46650336333799	(37.7448940675206, -122.466503363338)
24464	24464	124319	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	125 Jordan Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 3ft		5996196.09521	2113578.46254	37.783264606053294	-122.456860862891	(37.7832646060533, -122.456860862891)
24473	24473	250486	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	220 El Camino Del Mar	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5987923.25995	2115358.25633	37.7876728999176	-122.485611871313	(37.7876728999176, -122.485611871313)
24498	24498	210813	Undocumented 2	Olea europaea :: Olive Tree 41	486 Dewey Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994698.943	2100017.50065	37.745943650072704	-122.46105713288401	(37.7459436500727, -122.461057132884)
24504	24504	241043	Undocumented 2	Syzygium paniculatum :: Brush Cherry 198	300 Virginia Ave	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		6006909.48713	2098350.81017	37.742062385665605	-122.418716463718	(37.7420623856656, -122.418716463718)
24597	24597	206648	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	180 Castenada Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5994513.85188	2100887.12446	37.748320765087	-122.46176019139799	(37.748320765087, -122.461760191398)
24602	24602	208981	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	310 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			43	Width 3ft		5993092.40274	2095921.0497	37.7346032476459	-122.466314622626	(37.7346032476459, -122.466314622626)
24629	24629	208390	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	151 Elmwood Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		5994957.667859999	2092685.59829	37.725826932848705	-122.459631554564	(37.7258269328487, -122.459631554564)
24653	24653	178297	Undocumented 2	Pinus radiata :: Monterey Pine 3	654 Brotherhood Way	20	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5989773.99422	2088725.52612	37.7146541208759	-122.47726167241001	(37.7146541208759, -122.47726167241)
24725	24725	206493	Undocumented 2	Crateagus spp :: Hawthorn 160	1473 16th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 3ft		5991137.15941	2105390.2414599997	37.7604901815048	-122.47376505163	(37.7604901815048, -122.47376505163)
24730	24730	222027	Undocumented 2	Araucaria heterophylla :: Norfolk Island Pine 24	310 Liberty St	60	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		6003716.8909599995	2103932.15667	37.7572071892775	-122.430153527076	(37.7572071892775, -122.430153527076)
24777	24777	123037	Undocumented 2	Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197	598 Funston Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5991936.90153	2111420.91872	37.777095091129105	-122.471438573307	(37.7770950911291, -122.471438573307)
24784	24784	232225	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	4 Germania St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		6004247.320040001	2108919.60304	37.7709315496771	-122.42867461895099	(37.7709315496771, -122.428674618951)
24912	24912	208332	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	3688 19th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5990508.376069999	2091529.5417099998	37.7223958366684	-122.47492792990299	(37.7223958366684, -122.474927929903)
24993	24993	205648	Undocumented 2	Brugmansia spp :: Angel trumpet 137	146 Forest Hill Path	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5994467.18853	2101084.43805	37.7488598520055	-122.461935856854	(37.7488598520055, -122.461935856854)
25069	25069	219107	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1950 08th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 3ft		5993858.1687	2102183.92132	37.751843672172704	-122.464121636607	(37.7518436721727, -122.464121636607)
25078	25078	238351	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	737 Sanchez St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		6003693.255030001	2104105.37257	37.7576814602529	-122.43024762673001	(37.7576814602529, -122.43024762673)

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