Street_Tree_List

Data source: data.sfgov.org

214 rows where SiteOrder = 2 and qLegalStatus = 6 sorted by DBH

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: qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH ▼	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
118	118	251217	Significant Tree 6	Myoporum laetum :: Myoporum 1	399X Townsend St	2	Sidewalk: Property side : Cutout 5	Tree 1	Private 1				3x3		6013957.0	2110872.0	37.776837125863	-122.39522511301901	(37.776837125863, -122.395225113019)
300	300	251263	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3630x 19th Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 779147
595	595	119606	Significant Tree 6	Myoporum laetum :: Myoporum 1	299x Avalon Ave	2	Front Yard : Yard 7	Tree 1	Private 1
1025	1025	251425	Significant Tree 6	Pittosporum spp :: Pittosporum spp 128	5016 Diamond Heights Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1						5999555.0	2100128.0	37.7465253005744	-122.444273545879	(37.7465253005744, -122.444273545879)
1409	1409	251514	Significant Tree 6	Pinus radiata :: Monterey Pine 3	99x Mountview Ct	2	Back Yard : Yard 13	Tree 1	Private 1				3x3		5997620.0	2100449.0	37.7472961010623	-122.450987675073	(37.7472961010623, -122.450987675073)
1608	1608	251603	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	44R Amber Dr	2	Back Yard : Yard 13	Tree 1	Private 1						5999509.0	2100035.0	37.746267320465705	-122.444425925791	(37.7462673204657, -122.444425925791)
1609	1609	251630	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	8R Amethyst Way	2	Back Yard : Yard 13	Tree 1	Private 1						5999237.0	2100032.0	37.7462435599048	-122.44536624972099	(37.7462435599048, -122.445366249721)
1611	1611	251605	Significant Tree 6	Pittosporum crassifolium :: Karo Tree 108	48R Amber Dr	2	Back Yard : Yard 13	Tree 1	Private 1						5999482.0	2100041.0	37.7462822544405	-122.444519719345	(37.7462822544405, -122.444519719345)
1616	1616	251607	Significant Tree 6	Pinus radiata :: Monterey Pine 3	52R Amber Dr	2	Back Yard : Yard 13	Tree 1	Private 1						5999455.0	2100046.0	37.7462944425817	-122.44461344107401	(37.7462944425817, -122.444613441074)
1623	1623	251613	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	60R Amber Dr	2	Back Yard : Yard 13	Tree 1	Private 1						5999394.0	2100048.0	37.7462964530913	-122.444824514752	(37.7462964530913, -122.444824514752)
1637	1637	251619	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	72R Amber Dr	2	Back Yard : Yard 13	Tree 1	Private 1						5999318.0	2100030.0	37.746242691915	-122.445086018875	(37.746242691915, -122.445086018875)
1646	1646	251633	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	14R Amethyst Way	2	Back Yard : Yard 13	Tree 1	Private 1						5999202.0	2100044.0	37.746274510978395	-122.445488137723	(37.7462745109784, -122.445488137723)
1651	1651	251609	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	56R Amber Dr	2	Back Yard : Yard 13	Tree 1	Private 1						5999423.0	2100048.0	37.7462981080439	-122.44472423658002	(37.7462981080439, -122.44472423658)
1702	1702	251658	Significant Tree 6	Olea europaea :: Olive Tree 41	1050 North Point St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				6x6		6005628.0	2121390.0	37.8052501972152	-122.424786108187	(37.8052501972152, -122.424786108187)
1950	1950	252823	Significant Tree 6	Maytenus boaria :: Mayten 22	3852 17th St	2	Front Yard : Yard 7	Tree 1	Private 1						6003330.0	2106021.0	37.7629207320267	-122.43164067381399	(37.7629207320267, -122.431640673814)
2196	2196	119600	Significant Tree 6	Cupressocyparis leylandii :: Leyland Cypress 34	4357x Mission St	2	Front Yard : Yard 7	Tree 1	Private 1					Permit Number 774415
2712	2712	253178	Significant Tree 6	Washingtonia filifera :: California Fan Palm 189	4450 24th St	2	Front Yard : Cutout 8	Tree 1	Private 1				Width 0ft		6000289.52403	2101701.02913	37.7508863393389	-122.441846529398	(37.7508863393389, -122.441846529398)
2848	2848	253255	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	270 Castenada Ave	2	Front Yard : Yard 7	Tree 1	Private 1				10x10		5994049.0	2100330.0	37.746764271907	-122.46332720271201	(37.746764271907, -122.463327202712)
2859	2859	253251	Significant Tree 6	Pinus radiata :: Monterey Pine 3	99X Lopez Ave	2	Front Yard : Yard 7	Tree 1	Private 1				10x10		5994049.0	2100330.0	37.746764271907	-122.46332720271201	(37.746764271907, -122.463327202712)
3549	3549	253470	Significant Tree 6	Juniperus chinensis :: Juniper 19	3 Valletta Ct	2	Side Yard : Cutout 18	Tree 1	Private 1				6x10		5999319.0	2096479.0	37.736492551957895	-122.44482735214198	(37.7364925519579, -122.444827352142)
4553	4553	253637	Significant Tree 6	Pinus radiata :: Monterey Pine 3	701 Noe St	2	Front Yard : Yard 7	Tree 1	Private 1				Width 3ft		6003144.80454	2104133.37104	37.757727257313704	-122.43214639144101	(37.7577272573137, -122.432146391441)
4659	4659	253652	Significant Tree 6	Pinus radiata :: Monterey Pine 3	131 Font Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1				10x10		5990844.0	2088883.0	37.7151485301311	-122.473574812248	(37.7151485301311, -122.473574812248)
5055	5055	253765	Significant Tree 6	Acacia baileyana :: Bailey's Acacia 42	1366 Guerrero St	2	Front Yard : Yard 7	Tree 1	Private 1				3X3		6005800.0848900005	2101007.6677599996	37.7492949871928	-122.422741198761	(37.7492949871928, -122.422741198761)
5112	5112	253808	Significant Tree 6	Pinus radiata :: Monterey Pine 3	2 Garfield St	2	Side Yard : Yard 17	Tree 1	Private 1				10x10		5993976.0	2090624.0	37.7201097842726	-122.462875584037	(37.7201097842726, -122.462875584037)
9684	9684	173630	Significant Tree 6	Myoporum laetum :: Myoporum 1	2699x OCEAN AVE	2	Sidewalk: Property side : Cutout 5	Tree 1	MTA 6	DPW 4			3x3		5990602.0	2095184.0	37.7324354869182	-122.47487091251001	(37.7324354869182, -122.47487091251)
9750	9750	173672	Significant Tree 6	Crataegus phaenopyrum :: Washington Hawthorn 135	299x Beale St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6014575.0	2115523.0	37.789642061391	-122.39341281176901	(37.789642061391, -122.393412811769)
9987	9987	173779	Significant Tree 6	Ficus macrophylla :: Morton Bay Fig 148	99X Cleveland St	2	Side Yard : Yard 17	Tree 1	Private 1				3x6		6010549.0	2110746.0	37.7763010397716	-122.40700558704799	(37.7763010397716, -122.407005587048)
10190	10190	173887	Significant Tree 6	Washingtonia robusta :: Mexican Fan Palm 75	2931 20th St	2	Front Yard : Yard 7	Tree 1	Private 1						6009454.0	2104482.0	37.759040204703496	-122.41035112011801	(37.7590402047035, -122.410351120118)
11212	11212	103658	Significant Tree 6	Tree(s) :: 17	350X Hickory St	2	Front Yard : Yard 7	Tree 1	DPW for City Agency 10	DPW 4	06/07/2013 12:00:00 AM			Permit Number 770306
13271	13271	187638	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	875 El Camino Del Mar	2	Side Yard : Yard 17	Tree 1	Private 1				10x10		5985641.0	2114972.0	37.786479112006	-122.493479464676	(37.786479112006, -122.493479464676)
17858	17858	121173	Significant Tree 6	Tree(s) :: 17	950 Duncan St	2	Front Yard : Yard 7	Tree 1	Private 1				3x3		6000333.0	2099683.0	37.7453477932295	-122.44155138616101	(37.7453477932295, -122.441551386161)
18835	18835	114526	Significant Tree 6	Pinus radiata :: Monterey Pine 3	1 TIOGA AVE	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						6011351.0	2088602.0	37.715543251319204	-122.402673611341	(37.7155432513192, -122.402673611341)
19360	19360	105328	Significant Tree 6	Tree(s) :: 17	2051 03rd St	2	Back Yard : Yard 13	Tree 1	Private 1					Permit Number 771015	6015779.9	2106081.5	37.7637846705736	-122.388584622631	(37.7637846705736, -122.388584622631)
23001	23001	251172	Significant Tree 6	Pinus radiata :: Monterey Pine 3	363 Jersey St	2	Front Yard : Yard 7	Tree 1	Private 1						6002784.74363	2101501.25508	37.750479672211	-122.433203561601	(37.750479672211, -122.433203561601)
23162	23162	251173	Significant Tree 6	Washingtonia robusta :: Mexican Fan Palm 75	367 Jersey St	2	Front Yard : Yard 7	Tree 1	Private 1				Width 3ft		6002770.52649	2101500.0126900002	37.7504754543841	-122.43325263672399	(37.7504754543841, -122.433252636724)
28447	28447	116579	Significant Tree 6	Shrub :: Shrub 98	3000x 19TH AVE	2	Sidewalk: Property side : Cutout 5	Tree 1	MTA 6	DPW 4			3x3		5990602.0	2095184.0	37.7324354869182	-122.47487091251001	(37.7324354869182, -122.47487091251)
45605	45605	119614	Significant Tree 6	Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125	2X Sutter St	2	Sidewalk: Property side : Cutout 5	Tree 1	Private 1				3x3		6012582.0	2115890.0	37.7905388243453	-122.400334219916	(37.7905388243453, -122.400334219916)
49634	49634	112391	Significant Tree 6	Eucalyptus Spp :: Eucalyptus 40	2201X LYON ST	2	Sidewalk: Property side : Cutout 5	Tree 1	Private 1				3x12		5999307.0	2116423.0	37.7912531030346	-122.446303107227	(37.7912531030346, -122.446303107227)
50075	50075	113043	Significant Tree 6	Pinus radiata :: Monterey Pine 3	500 RAYMOND AVE	2	Front Yard : Cutout 8	Tree 1	Private 1		10/06/2015 12:00:00 AM		3x3		6008527.0	2088690.0	37.7156268060035	-122.412440877248	(37.7156268060035, -122.412440877248)
58944	58944	100194	Significant Tree 6	Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191	361 Dellbrook Ave	2	Front Yard : Yard 7	Tree 1	Private 1						5997322.2	2102403.9	37.7526467193673	-122.45215846969	(37.7526467193673, -122.45215846969)
79494	79494	105555	Significant Tree 6	Maytenus boaria :: Mayten 22	410 Elizabeth St	2	Front Yard : Yard 7	Tree 1	Private 1					Permit Number 772516	6003623.1	2102191.9	37.7524235434098	-122.430353733326	(37.7524235434098, -122.430353733326)
79722	79722	93222	Significant Tree 6	Tree(s) :: 17	85 Santa Rita Ave	2	Front Yard : Yard 7	Tree 1	Private 1		02/26/2010 12:00:00 AM			Permit Number 53213	5993788.0	2100441.0	37.7470540096767	-122.46423776520399	(37.7470540096767, -122.464237765204)
80520	80520	116010	Significant Tree 6	Syzygium paniculatum :: Brush Cherry 198	199x SAN BUENAVENTURA WAY	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5993547.0	2095667.0	37.7339319096844	-122.464724497297	(37.7339319096844, -122.464724497297)
80993	80993	85086	Significant Tree 6	Pyrus kawakamii :: Evergreen Pear 82	1600 Chestnut St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 49476	6004108.1	2120157.9	37.8017812094321	-122.429957968303	(37.8017812094321, -122.429957968303)
81189	81189	98546	Significant Tree 6	Acacia melanoxylon :: Blackwood Acacia 5	555@Rio Teresita Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1						5999006.5	2097247.3	37.7385842819574	-122.445963035448	(37.7385842819574, -122.445963035448)
81752	81752	116834	Significant Tree 6	Corymbia ficifolia :: Red Flowering Gum 60	1750 Geneva Ave	2	Front Yard : Yard 7	Tree 1	Private 1						6004521.4	2087037.7	37.710864341935	-122.42616849363998	(37.710864341935, -122.42616849364)
82967	82967	107186	Significant Tree 6	Pinus radiata :: Monterey Pine 3	945 Sacramento St	2	Front Yard : Yard 7	Tree 1	Private 1					Permit Number 773422	6010352.63458	2116759.0624	37.7928004918921	-122.40810904235501	(37.7928004918921, -122.408109042355)
83219	83219	108097	Significant Tree 6	Tree(s) :: 17	3370 Washington St	2	Front Yard : Cutout 8	Tree 1	Private 1						5998663.3699	2115944.3199400003	37.789901994506	-122.44849555223101	(37.789901994506, -122.448495552231)
84141	84141	120594	Significant Tree 6	Pinus radiata :: Monterey Pine 3	499x Ocean Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	MTA 6				3x3		5998874.0	2091543.0	37.722914047867604	-122.446010982458	(37.7229140478676, -122.446010982458)
84673	84673	110840	Significant Tree 6	Tree(s) :: 17	2037 TURK BLVD	2	Front Yard : Yard 7	Tree 1	Private 1						6000252.0	2111948.0	37.779019836036206	-122.442711981138	(37.7790198360362, -122.442711981138)
84676	84676	105867	Significant Tree 6	Corymbia ficifolia :: Red Flowering Gum 60	3555 Cesar Chavez St	2	Front Yard : Yard 7	Tree 1	Private 1						6006336.4	2100501.8	37.7479362343406	-122.420850697466	(37.7479362343406, -122.420850697466)
85050	85050	106251	Significant Tree 6	Tree(s) :: 17	580 De Haro St	2	Front Yard : Yard 7	Tree 1	Private 1					Permit Number 770844	6012025.9	2105717.4	37.7625761768628	-122.401543046462	(37.7625761768628, -122.401543046462)
85138	85138	103617	Significant Tree 6	Pittosporum undulatum :: Victorian Box 26	201X Haight St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6004725.0	2109149.0	37.7715884407354	-122.427038651796	(37.7715884407354, -122.427038651796)
85374	85374	114726	Significant Tree 6	:: 54	520 Townsend St	2	Front Yard : Yard 7	Tree 1	Private 1						6012508.1	2109575.3	37.7731959986981	-122.40014623691201	(37.7731959986981, -122.400146236912)
85674	85674	113134	Significant Tree 6	Populus nigra 'Italica' :: Lombardy Poplar 86	50 03rd St	2	Front Yard : Yard 7	Tree 1	Private 1		09/09/2015 12:00:00 AM		10x10	Permit Number 775860	6011822.9	2114512.2	37.7867133521926	-122.402863731968	(37.7867133521926, -122.402863731968)
86608	86608	85093	Significant Tree 6	Tree(s) :: 17	100 32nd Ave	2	Front Yard : Yard 7	Tree 1	Private 1		12/18/2009 12:00:00 AM			Permit Number 53112	5985781.7	2114962.8	37.786462080845396	-122.49299200677	(37.7864620808454, -122.49299200677)
86717	86717	108022	Significant Tree 6	Grevillea robusta :: Silk Oak Tree 145	455X Ivy St	2	Front Yard : Cutout 8	Tree 1	Private 1						6005179.30837	2111099.83336	37.776970634543	-122.42560603936	(37.776970634543, -122.42560603936)
86911	86911	87150	Significant Tree 6	Sequoia sempervirens :: Coast Redwood 116	4 Bellair Pl	2	Back Yard : Yard 13	Tree 1	Private 1					Permit Number 50135	6010093.0	2120950.0	37.8042932388788	-122.409303278994	(37.8042932388788, -122.409303278994)
87608	87608	87240	Significant Tree 6	Tree(s) :: 17	233 Arbor St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		02/14/2008 12:00:00 AM			Permit Number 50269	6001330.0	2096776.0	37.737422605415205	-122.43789575270901	(37.7374226054152, -122.437895752709)
87905	87905	100771	Significant Tree 6	Pittosporum crassifolium :: Karo Tree 108	450 Hayes St	2	Back Yard : Yard 13	Tree 1	Private 1					Permit Number 768934	6005678.7	2111113.4	37.7770360905223	-122.423879452899	(37.7770360905223, -122.423879452899)
88059	88059	88281	Significant Tree 6	Prunus cerasifera :: Cherry Plum 16	935 Ulloa St	2	Front Yard : Yard 7	Tree 1	Private 1		07/09/2008 12:00:00 AM		3x3	Permit Number 51275	5993125.0	2098282.0	37.7410877064311	-122.466373457073	(37.7410877064311, -122.466373457073)
88091	88091	87157	Significant Tree 6	Ligustrum lucidum :: Glossy Privet 55	237 Rivoli St	2	Front Yard : Yard 7	Tree 1	Private 1					Permit Number 50138	5997662.0	2105892.0	37.762243628012705	-122.451234923187	(37.7622436280127, -122.451234923187)
88225	88225	104494	Significant Tree 6	Acer circinatum :: Vine Maple 379	171 SAN MARCOS AVE	2	Front Yard : Yard 7	Tree 1	Private 1					Permit Number 770388	5993514.0	2100282.0	37.7466016393389	-122.465173679454	(37.7466016393389, -122.465173679454)
88432	88432	99828	Significant Tree 6	Juniperus chinensis :: Juniper 19	2398 Broadway	2	Front Yard : Yard 7	Tree 1	Private 1						6002195.8	2117442.8	37.7942177709498	-122.436380971376	(37.7942177709498, -122.436380971376)
89364	89364	100695	Significant Tree 6	Liriodendron tulipifera :: Tulip Tree 85	200X 01st St	2	Front Yard : Yard 7	Tree 1	Private 1		09/05/2012 12:00:00 AM			Permit Number 768932	6013804.4	2114954.0	37.7880368749487	-122.396039137137	(37.7880368749487, -122.396039137137)
89893	89893	111037	Significant Tree 6	Magnolia spp :: Magnolia 89	3991-3997 Washington St	2	Front Yard : Yard 7	Tree 1	Private 1						5995610.3	2115419.4	37.7882856707006	-122.459020806409	(37.7882856707006, -122.459020806409)
90158	90158	108211	Significant Tree 6	Juniperus chinensis :: Juniper 19	524 45th Ave	2	Front Yard : Yard 7	Tree 1	Private 1					Permit Number 773704	5981973.192319999	2112153.30127	37.778524566445206	-122.505959887315	(37.7785245664452, -122.505959887315)
90287	90287	104680	Significant Tree 6	Pittosporum undulatum :: Victorian Box 26	33 08th St	2	Front Yard : Yard 7	Tree 1	Private 1					Permit Number 770764	6008457.3	2111569.1	37.7784438055662	-122.414299630615	(37.7784438055662, -122.414299630615)
91612	91612	104867	Significant Tree 6	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	411 Holladay Ave	2	Front Yard : Yard 7	Tree 1	Private 1					Permit Number 770735	6010309.7	2098610.5	37.7429662928376	-122.406977848202	(37.7429662928376, -122.406977848202)
91613	91613	88453	Significant Tree 6	Myoporum laetum :: Myoporum 1	2801 Oakdale Ave	2	Front Yard : Cutout 8	Tree 1	Private 1				3x3	Permit Number 51417	6011007.5	2098422.1	37.742488010089005	-122.40455177544202	(37.742488010089, -122.404551775442)
91632	91632	87216	Significant Tree 6	Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 502	500 Cortland Ave	2	Back Yard : Yard 13	Tree 1	Private 1		02/08/2008 12:00:00 AM		3x3	Permit Number 50224	6007640.7	2097187.4	37.7389090609704	-122.416105779709	(37.7389090609704, -122.416105779709)
91819	91819	122638	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3630X 19th Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x8		5990614.0	2091411.0	37.7220764711857	-122.47455416918999	(37.7220764711857, -122.47455416919)
93221	93221	106514	Significant Tree 6	Tree(s) :: 17	190 EUCALYPTUS DR	2	Front Yard : Yard 7	Tree 1	Private 1						5990695.4	2094728.8	37.7311910349726	-122.474514801842	(37.7311910349726, -122.474514801842)
93355	93355	111359	Significant Tree 6	Platanus x hispanica :: Sycamore: London Plane 15	1637 OAK ST	2	Front Yard : Yard 7	Tree 1	Private 1				3x15		5999143.0	2109364.0	37.771861551181395	-122.44636250519699	(37.7718615511814, -122.446362505197)
93451	93451	112482	Significant Tree 6	Pittosporum undulatum :: Victorian Box 26	1275 Columbus Ave	2	Front Yard : Yard 7	Tree 1	Private 1		08/03/2015 12:00:00 AM				6007539.6	2121483.9	37.8056158049656	-122.418177422209	(37.8056158049656, -122.418177422209)
95122	95122	91107	Significant Tree 6	Tree(s) :: 17	2650 Turk Blvd	2	Front Yard : Yard 7	Tree 1	Private 1		01/12/2009 12:00:00 AM		On campus	Permit Number 51996	5995208.0	2110277.0	37.774142880877704	-122.46004000497801	(37.7741428808777, -122.460040004978)
96425	96425	116863	Significant Tree 6	Pinus radiata :: Monterey Pine 3	262X OAK PARK DR	2	Back Yard : Cutout 16	Tree 1	Private 1				10x10		5995091.0	2103085.0	37.7543887826633	-122.459923632558	(37.7543887826633, -122.459923632558)
98270	98270	107984	Significant Tree 6	Podocarpus gracilor :: Fern Pine 13	2401x SCOTT ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6001096.0	2116670.0	37.792033311180504	-122.440130949989	(37.7920333111805, -122.440130949989)
98898	98898	117252	Significant Tree 6	Pinus pinea :: Italian Stone Pine 143	2500x 34TH AVE	2	Side Yard : Yard 17	Tree 1	SFUSD 4				3x3		5985829.0	2097874.0	37.73954376030179	-122.491570003273	(37.7395437603018, -122.491570003273)
99011	99011	115564	Significant Tree 6	Prunus serrulata :: Ornamental Cherry 35	3524 Jackson St	2	Front Yard : Cutout 8	Tree 1	Private 1				5x10		5997387.02929021	2116081.37513577	37.790205252620794	-122.452921449726	(37.7902052526208, -122.452921449726)
99170	99170	100432	Significant Tree 6	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	200X Stonecrest Dr	2	Front Yard : Yard 7	Tree 1	Private 1						5990724.7	2093134.9	37.7268162840874	-122.47429724264	(37.7268162840874, -122.47429724264)
100317	100317	113359	Significant Tree 6	Sequoia sempervirens :: Coast Redwood 116	702 Foerster St	2	Sidewalk: Property side : Cutout 5	Tree 1	Private 1						5998153.40008835	2095558.62470631	37.733898832504295	-122.448791034412	(37.7338988325043, -122.448791034412)
100567	100567	103612	Significant Tree 6	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	200X Buchanan St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6004748.9	2109266.8	37.7719132424086	-122.426964371637	(37.7719132424086, -122.426964371637)
100647	100647	121134	Significant Tree 6	Pinus radiata :: Monterey Pine 3	1050 North Point St	2	Front Yard : Yard 7	Tree 1	Private 1				3x10		6005628.0	2121390.0	37.8052501972152	-122.424786108187	(37.8052501972152, -122.424786108187)
102204	102204	107137	Significant Tree 6	Pittosporum undulatum :: Victorian Box 26	700X Stevenson St	2	Front Yard : Yard 7	Tree 1	Private 1		07/31/2014 12:00:00 AM			Permit Number 769156	6008444.340419999	2111440.4280000003	37.778089774899705	-122.41433535624701	(37.7780897748997, -122.414335356247)
102570	102570	94295	Significant Tree 6	Ficus nitida :: Laurel Fig 43	1150X Fillmore St	2	Sidewalk: Property side : Cutout 5	Tree 1	Rec/Park 3						6003451.3	2112195.3	37.7798807216656	-122.431661979156	(37.7798807216656, -122.431661979156)
102605	102605	121181	Significant Tree 6	Myoporum laetum :: Myoporum 1	1000x Duncan St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3	Permit Number 775289	5999834.0	2099740.0	37.7454758595085	-122.44328093408899	(37.7454758595085, -122.443280934089)
103164	103164	109415	Significant Tree 6	Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10	4 GUY PL	2	Front Yard : Yard 7	Tree 1	Private 1						6014378.1	2114502.6	37.786829336844605	-122.394022608955	(37.7868293368446, -122.394022608955)
103243	103243	116088	Significant Tree 6	Acacia melanoxylon :: Blackwood Acacia 5	98x WOODWARD ST	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3		6006422.0	2107919.0	37.7683069672649	-122.421081271108	(37.7683069672649, -122.421081271108)
103510	103510	92813	Significant Tree 6	Tree(s) :: 17	365 Fulton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				3x3	Permit Number 53020	6006011.0	2111744.0	37.7787863189721	-122.42277474798	(37.7787863189721, -122.42277474798)
104153	104153	121416	Significant Tree 6	Washingtonia robusta :: Mexican Fan Palm 75	366 San Carlos St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6006692.0	2103986.0	37.757523086513096	-122.419868246156	(37.7575230865131, -122.419868246156)
104230	104230	96185	Significant Tree 6	Tree(s) :: 17	333 Harrison St	2	Sidewalk: Property side : 26	Tree 1	Private 1					Permit Number 767224	6015127.7	2114620.1	37.7871935976335	-122.39143736362	(37.7871935976335, -122.39143736362)
104314	104314	105082	Significant Tree 6	:: 54	344 Fulton St	2	Front Yard : Yard 7	Tree 1	Private 1						6006101.8	2111789.5	37.778916373563206	-122.42246386857201	(37.7789163735632, -122.422463868572)
105419	105419	100550	Significant Tree 6	Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193	4443 19th St	2	Front Yard : Yard 7	Tree 1	Private 1						6001193.1	2104609.9	37.7589248414166	-122.43893032447399	(37.7589248414166, -122.438930324474)
105444	105444	105416	Significant Tree 6	Acacia melanoxylon :: Blackwood Acacia 5	1450X McAllister St	2	Front Yard : Yard 7	Tree 1	Private 1						6002220.7882900005	2111575.67932	37.7781095739995	-122.43587451144501	(37.7781095739995, -122.435874511445)
105471	105471	101436	Significant Tree 6	Metrosideros excelsa :: New Zealand Xmas Tree 2	600X Grant Ave	2	Front Yard : Yard 7	Tree 1	Private 1						6010995.6	2116632.0	37.7924875884206	-122.40587538693701	(37.7924875884206, -122.405875386937)
105747	105747	113638	Significant Tree 6	Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124	1X Russ St	2	Sidewalk: Property side : Cutout 5	Tree 1	Private 1						6009949.394180001	2111947.85897	37.7795674908256	-122.40916462626801	(37.7795674908256, -122.409164626268)
106567	106567	106109	Significant Tree 6	Magnolia champaca :: Champa 170	135 MENDOSA AVE	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1		04/23/2014 12:00:00 AM			Permit Number 772704	5992893.2	2100790.2	37.747961208182	-122.467357269235	(37.747961208182, -122.467357269235)
106634	106634	121195	Significant Tree 6	Myoporum laetum :: Myoporum 1	255x Red Rock Way	2	Front Yard : Yard 7	Tree 1	Private 1				3x3	Permit Number 775289	5999917.0	2099808.0	37.7456673038035	-122.442998816589	(37.7456673038035, -122.442998816589)
107216	107216	121169	Significant Tree 6	Acacia spp :: Acacia Spp 176	900x Duncan St	2	Front Yard : Yard 7	Tree 1	Private 1				3x3	Permit Number 775289	6000584.0	2099647.0	37.745263242779004	-122.44068088983101	(37.745263242779, -122.440680889831)

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