Street_Tree_List

Data source: data.sfgov.org

9,170 rows where qSiteInfo = 2 sorted by qCaretaker descending

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, PlantType, qCaretaker, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker ▲	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
9947	9947	11824	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	14	Sidewalk: Curb side : Yard 2	Tree 1	PUC 13		03/13/2013 12:00:00 AM	2	3		5991432.171815401	2088660.0347764	37.7145703669544	-122.47152561846501	(37.7145703669544, -122.471525618465)
114303	114303	11822	Permitted Site 1	Metrosideros excelsa :: New Zealand Xmas Tree 2	1299X Junipero Serra Blvd	16	Sidewalk: Curb side : Yard 2	Tree 1	PUC 13			10	3		5991432.171815401	2088660.0347764	37.7145703669544	-122.47152561846501	(37.7145703669544, -122.471525618465)
89093	89093	116527	DPW Maintained 3	Olea europaea :: Olive Tree 41	5732 GEARY BLVD	1	Sidewalk: Curb side : Yard 2	Tree 1	MTA 6	DPW for City Agency 2			3x3		5989254.0	2112678.0	37.780391116482	-122.480811519646	(37.780391116482, -122.480811519646)
455	455	234501	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	2423 Market St	2	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2			12	Width 8ft		6002117.5892	2105782.84009	37.7621980066439	-122.435816935712	(37.7621980066439, -122.435816935712)
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)
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)
9934	9934	102961	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	4	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9935	9935	102960	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9936	9936	102965	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	9	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9937	9937	102966	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	10	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9939	9939	102963	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	6	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9940	9940	102969	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	12	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9941	9941	102968	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	11	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9943	9943	102967	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	13	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9944	9944	11821	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2	3		5991432.171815401	2088660.0347764	37.7145703669544	-122.47152561846501	(37.7145703669544, -122.471525618465)
9945	9945	102971	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	18	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
50152	50152	113698	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	80 LINARES AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2						5994154.8	2102090.7	37.75160480205479	-122.46308908916401	(37.7516048020548, -122.463089089164)
64865	64865	111721	DPW Maintained 3	Populus spp :: Poplar Spp 276	950X Beach St	2	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2						6005896.0	2121751.0	37.8062565433008	-122.42388434548401	(37.8062565433008, -122.423884345484)
86010	86010	111722	DPW Maintained 3	Populus spp :: Poplar Spp 276	950X Beach St	3	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2						6005896.0	2121751.0	37.8062565433008	-122.42388434548401	(37.8062565433008, -122.423884345484)
87978	87978	102959	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1299X Junipero Serra Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
88506	88506	98722	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	701X Brotherhood Way	1	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2						5991112.8	2087998.1	37.7127343737121	-122.472581254687	(37.7127343737121, -122.472581254687)
91005	91005	102964	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	8	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
91241	91241	111724	DPW Maintained 3	Populus spp :: Poplar Spp 276	950X Beach St	5	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2						6005896.0	2121751.0	37.8062565433008	-122.42388434548401	(37.8062565433008, -122.423884345484)
98926	98926	357	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	3690X 19th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2	2		5990489.74295	2091103.38095	37.7212246253626	-122.474961247113	(37.7212246253626, -122.474961247113)
100349	100349	111723	DPW Maintained 3	Populus spp :: Poplar Spp 276	950X Beach St	4	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2						6005896.0	2121751.0	37.8062565433008	-122.42388434548401	(37.8062565433008, -122.423884345484)
108864	108864	102970	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1299X Junipero Serra Blvd	17	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
114274	114274	110143	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1130X PORTOLA DR	3	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2				3x3		5994964.0	2098019.0	37.7404715144277	-122.459995857341	(37.7404715144277, -122.459995857341)
125197	125197	110465	DPW Maintained 3	Acacia melanoxylon :: Blackwood Acacia 5	1485 FAIRFAX AVE	2	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2			9	3x3		6016296.0	2097688.0	37.7407664622153	-122.38621437638201	(37.7407664622153, -122.386214376382)
2	2	232565	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	940 Elizabeth St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		03/20/2017 12:00:00 AM	3	Width 4ft	Permit Number 779625	6000396.48544	2101998.8644	37.7517102172731	-122.441498017841	(37.7517102172731, -122.441498017841)
27	27	244214	Private 5	Tree(s) :: 17	342 Scott St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		03/20/2017 12:00:00 AM	3	Width 0ft	Permit Number 779666	6002262.2202	2109717.5413	37.7730099442883	-122.43559821674499	(37.7730099442883, -122.435598216745)
35	35	183515	Undocumented 2	Myoporum laetum :: Myoporum 1	2562 26th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		03/21/2017 12:00:00 AM	3	Width 0ft	Permit Number 779639	5988336.7554	2097879.9474	37.7397063254514	-122.482899813956	(37.7397063254514, -122.482899813956)
50	50	138938	Private 5	Tree(s) :: 17	632 HAYES ST	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		03/21/2017 12:00:00 AM	3	Width 0ft	Permit Number 779650	6004797.9634	2110922.1515	37.7764612085261	-122.426912572117	(37.7764612085261, -122.426912572117)
168	168	179480	Undocumented 2	Schinus terebinthifolius :: Brazilian Pepper 25	100 Serrano Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11			5989599.0	2090767.0	37.7202493457345	-122.478015677124	(37.7202493457345, -122.478015677124)
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)
608	608	233928	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	8 Octavia St Frontage East	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			29	Width 8ft		6005775.18179	2109348.30824	37.77219502161479	-122.423420179704	(37.7721950216148, -122.423420179704)
721	721	183636	Planning Code 138.1 required 4	Pittosporum crassifolium :: Karo Tree 108	1478 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	3x9		5981570.9282	2105017.3718	37.7589076903569	-122.506822015648	(37.7589076903569, -122.506822015648)
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)
1001	1001	238568	Permitted Site 1	Prunus cerasifera :: Cherry Plum 16	1300 Noe St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		04/27/2017 12:00:00 AM	3	Width 5ft	Permit Number 779731	6003218.5106	2100626.90187	37.7481035005842	-122.431641146931	(37.7481035005842, -122.431641146931)
1006	1006	232567	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	947 Elizabeth St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 4ft		6000330.76798	2101953.15424	37.751580964011204	-122.441721996685	(37.7515809640112, -122.441721996685)
1009	1009	223537	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	1300 Noe St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 5ft		6003218.0959	2100594.3408	37.7480140720016	-122.431640256605	(37.7480140720016, -122.431640256605)
1103	1103	211013	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	500 Junipero Serra Blvd	44	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5991332.59313	2093509.69784	37.727880584217	-122.47222310103399	(37.727880584217, -122.472223101034)
1368	1368	141257	Undocumented 2	Rhaphiolepis indica :: India Hawthorn 144	51 COMMONWEALTH AVE	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 0ft		5996492.2734	2114210.7856	37.7850177994523	-122.455881936455	(37.7850177994523, -122.455881936455)
1370	1370	141258	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	51 COMMONWEALTH AVE	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5996495.6576	2114088.9538	37.7846834760254	-122.455861417999	(37.7846834760254, -122.455861417999)
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)
1857	1857	251765	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	23 Seville St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1				Width 6ft		6001915.0	2087651.0	37.7124006661461	-122.435220643728	(37.7124006661461, -122.435220643728)
1870	1870	251767	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	23 Seville St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1				Width 6ft		6001915.0	2087651.0	37.7124006661461	-122.435220643728	(37.7124006661461, -122.435220643728)
1871	1871	176854	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	23 Seville St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 6ft		6001915.0	2087651.0	37.7124006661461	-122.435220643728	(37.7124006661461, -122.435220643728)
1876	1876	251766	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	23 Seville St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1				Width 6ft		6001915.0	2087651.0	37.7124006661461	-122.435220643728	(37.7124006661461, -122.435220643728)
1878	1878	251764	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	187 Seville St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1				Width 6ft		6001178.343719999	2087386.3168	37.7116320444605	-122.43774780171302	(37.7116320444605, -122.437747801713)
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)
2180	2180	251495	Significant Tree 6	Tree(s) :: 17	2448 Clay St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		06/28/2017 12:00:00 AM	3	10x10	Permit Number 780000	6003026.0	2116224.0	37.7909183964794	-122.433421252488	(37.7909183964794, -122.433421252488)
2211	2211	188595	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	1301 Rhode Island St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		07/05/2017 12:00:00 AM	3	Width 7ft		6011997.611930001	2102271.8897	37.7531139870419	-122.401398733477	(37.7531139870419, -122.401398733477)
2383	2383	201821	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	100 Friedell St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		07/12/2017 12:00:00 AM	3	Width 4ft		6021045.51426	2093266.4470799998	37.7288874606638	-122.369486691782	(37.7288874606638, -122.369486691782)
2387	2387	201822	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	100 Friedell St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		07/12/2017 12:00:00 AM	3	Width 4ft		6021035.49669	2093250.0299200001	37.72884183267921	-122.36952018972299	(37.7288418326792, -122.369520189723)
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)
2408	2408	201820	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	100 Friedell St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		07/12/2017 12:00:00 AM	3	Width 4ft		6021056.53291	2093279.09213	37.728922786051506	-122.369449472416	(37.7289227860515, -122.369449472416)
2417	2417	201819	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	100 Friedell St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		07/12/2017 12:00:00 AM	3	Width 4ft		6021071.50009	2093300.7706900002	37.7289831323462	-122.369399226393	(37.7289831323462, -122.369399226393)
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)
2567	2567	252819	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	407 Miguel St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		07/19/2017 12:00:00 AM	3		Permit Number 780051	6004479.0	2096413.0	37.736604456337105	-122.426982337456	(37.7366044563371, -122.426982337456)
2611	2611	248770	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Cuesta Ct	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 8ft		5999726.1375	2101744.56242	37.7509737525388	-122.44379789365499	(37.7509737525388, -122.443797893655)
2614	2614	248773	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Cuesta Ct	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 8ft		5999776.82694	2101824.96428	37.751197407653706	-122.44362838043999	(37.7511974076537, -122.44362838044)
2625	2625	248771	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Cuesta Ct	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 8ft		5999742.36883	2101773.9828	37.751055459558394	-122.4437438777	(37.7510554595584, -122.4437438777)
2626	2626	248769	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Cuesta Ct	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 8ft		5999705.100819999	2101709.8291	37.7508771833507	-122.443868145114	(37.7508771833507, -122.443868145114)
2629	2629	248772	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Cuesta Ct	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			27	Width 8ft		5999759.8487	2101799.49731	37.7511265131926	-122.443685263491	(37.7511265131926, -122.443685263491)
2702	2702	175365	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	18	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 5ft		5993296.25394	2087788.76232	37.712285726578	-122.465019407322	(37.712285726578, -122.465019407322)
2703	2703	175367	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	23	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5993394.31846	2087754.15211	37.7121963492565	-122.464677958129	(37.7121963492565, -122.464677958129)
2705	2705	175366	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	22	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		5993316.47827	2087783.2739799998	37.7122718230516	-122.464949108223	(37.7122718230516, -122.464949108223)
2708	2708	175370	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	26	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5993448.13741	2087722.6413599998	37.712112930839	-122.464489658971	(37.712112930839, -122.464489658971)
2709	2709	175364	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	15	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5993263.021319999	2087797.41727	37.7123075747038	-122.465134896479	(37.7123075747038, -122.465134896479)
2716	2716	175362	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 5ft		5993185.52762	2087808.44828	37.7123333942447	-122.46540353654	(37.7123333942447, -122.46540353654)
2720	2720	175369	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	25	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5993431.63462	2087732.39125	37.7121387503812	-122.46454740445101	(37.7121387503812, -122.464547404451)
2721	2721	175371	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	27	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5993471.88559	2087712.01586	37.712085124705204	-122.464406808033	(37.7120851247052, -122.464406808033)
2722	2722	175368	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	24	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5993415.10175	2087740.6954	37.7121605985029	-122.464605149022	(37.7121605985029, -122.464605149022)
2760	2760	251575	Significant Tree 6	Pinus radiata :: Monterey Pine 3	300 Sussex St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		08/02/2017 12:00:00 AM	3	3x3	Permit Number 780395	6001194.0	2096647.0	37.737060666835205	-122.438356728037	(37.7370606668352, -122.438356728037)
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)
2934	2934	250407	Permitted Site 1	Metrosideros excelsa :: New Zealand Xmas Tree 2	25 Seacliff Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/16/1997 12:00:00 AM	12	Width 4ft	Permit Number 38521	5987994.17396	2115794.4903599997	37.78887480516529	-122.485398549405	(37.7888748051653, -122.485398549405)
2940	2940	250421	Permitted Site 1	Metrosideros excelsa :: New Zealand Xmas Tree 2	49 Seacliff Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		5987880.27353	2115792.69032	37.788863226412296	-122.485792492053	(37.7888632264123, -122.485792492053)
2983	2983	250419	Permitted Site 1	Metrosideros excelsa :: New Zealand Xmas Tree 2	49 Seacliff Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		07/14/1997 12:00:00 AM	8	Width 4ft	Permit Number 38081	5987849.1846199995	2115791.00757	37.7888567944531	-122.48589993045601	(37.7888567944531, -122.485899930456)
2985	2985	250408	Permitted Site 1	Metrosideros excelsa :: New Zealand Xmas Tree 2	25 Seacliff Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 4ft		5988046.91633	2115796.65095	37.7888838100916	-122.485216228949	(37.7888838100916, -122.485216228949)
2987	2987	250422	Permitted Site 1	Metrosideros excelsa :: New Zealand Xmas Tree 2	49 Seacliff Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 4ft		5987891.12003	2115793.8659200002	37.7888670862959	-122.48575505145399	(37.7888670862959, -122.485755051454)
3017	3017	250423	Permitted Site 1	Metrosideros excelsa :: New Zealand Xmas Tree 2	49 Seacliff Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 4ft		5987905.22883	2115793.56651	37.7888670863011	-122.485706215587	(37.7888670863011, -122.485706215587)
3028	3028	191362	Undocumented 2	Umbellularia californica :: California Bay 195	999 Key Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			27			6013336.3333	2089743.8780099999	37.718789267498295	-122.39589132571999	(37.7187892674983, -122.39589132572)
3029	3029	193472	Undocumented 2	Prunus persica nectarina :: Flowering Nectarine Tree 196	1059 Jamestown Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8			6013665.43892	2089838.8488900003	37.719068342415596	-122.39476037791599	(37.7190683424156, -122.394760377916)
3033	3033	253285	Undocumented 2	Cordyline australis :: Dracena Palm 141	8245 Geary Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		08/15/2017 12:00:00 AM	3			5981372.0	2112274.0	37.7788205636315	-122.50804856364901	(37.7788205636315, -122.508048563649)
3040	3040	189089	Undocumented 2	Acer negundo :: Box Elder 74	1033 Le Conte Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6			6012956.43123	2089677.63232	37.718586227543504	-122.397199861797	(37.7185862275435, -122.397199861797)
3041	3041	182178	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	1799X Lawton St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 0ft		5988865.0	2104441.0	37.7577519603078	-122.48155379203999	(37.7577519603078, -122.48155379204)
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)
3382	3382	122965	Undocumented 2	Cordyline australis :: Dracena Palm 141	98 09th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5993050.799269999	2114904.9128799997	37.786725565514004	-122.467838745487	(37.786725565514, -122.467838745487)

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