Street_Tree_List

Data source: data.sfgov.org

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

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
96	96	251196	Significant Tree 6	Pinus radiata :: Monterey Pine 3	900X 14th St	2	Front Yard : Cutout 8	Tree 1	Private 1		03/22/2017 12:00:00 AM	3			6002515.0	2107976.0	37.768242455454995	-122.43459927073098	(37.768242455455, -122.434599270731)
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)
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)
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
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
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)
20656	20656	107549	Significant Tree 6	Tree(s) :: 17	198X Jennings St	2	Front Yard : Yard 7	Tree 1	DPW 2		11/12/2014 12:00:00 AM	3		Permit Number 774049	6018784.70414	2097136.12526	37.739388557233205	-122.377570991407	(37.7393885572332, -122.377570991407)
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)
23610	23610	107057	Significant Tree 6	Pittosporum undulatum :: Victorian Box 26	601X Davis St	2	Front Yard : Yard 7	Tree 1	Private 1		07/23/2014 12:00:00 AM	9		Permit Number 771755	6013145.32204	2118507.86888	37.7977582696821	-122.398568926718	(37.7977582696821, -122.398568926718)
49231	49231	114226	Significant Tree 6	Acacia longifolia :: Golden Wattle 140	99x FONT BLVD	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20			5990948.0	2088640.0	37.71448733391829	-122.473197635313	(37.7144873339183, -122.473197635313)
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)
60806	60806	96274	Significant Tree 6	Olea europaea :: Olive Tree 41	55@ Alemany Trumbull St	2	Back Yard : Yard 13	Tree 1	Private 1			2			6004001.3006	2094332.0064299998	37.7308634942567	-122.428485665086	(37.7308634942567, -122.428485665086)
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)
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)
81776	81776	114391	Significant Tree 6	Pyrus kawakamii :: Evergreen Pear 82	23x PINTO AVE	2	Front Yard : Yard 7	Tree 1	Private 1			7			5988521.0	2090808.0	37.720299292258794	-122.481744923362	(37.7202992922588, -122.481744923362)
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)
84454	84454	103564	Significant Tree 6	Juniperus chinensis :: Juniper 19	878 14th St	2	Front Yard : Yard 7	Tree 1	Private 1			13		Permit Number 770193	6002986.0	2107714.0	37.767549794195205	-122.432951409123	(37.7675497941952, -122.432951409123)
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)
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)
86745	86745	115730	Significant Tree 6	Acer rubrum :: Red Maple 6	10x Yerba Buena Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/24/2016 12:00:00 AM	3		Permit Number 776540	5993642.277480001	2097056.1949900002	37.7377517864641	-122.46449593033	(37.7377517864641, -122.46449593033)
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)
86962	86962	114103	Significant Tree 6	Liquidambar styraciflua :: American Sweet Gum 62	5 ACEVEDO AVE	2	Front Yard : Yard 7	Tree 1	Private 1			15			5987903.0	2090420.0	37.7191979850677	-122.483852684784	(37.7191979850677, -122.483852684784)
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)
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)
90919	90919	112420	Significant Tree 6	Picea Spp :: Spruce Spp 357	268 Lily St	2	Back Yard : Yard 13	Tree 1	Private 1		07/29/2015 12:00:00 AM	3			6005334.87738	2110100.0463	37.7742342515583	-122.42499672664302	(37.7742342515583, -122.424996726643)
91565	91565	114074	Significant Tree 6	Betula pendula :: European White Birch 146	18x HIGUERA AVE	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			5988029.0	2090212.0	37.718634203797706	-122.483401916227	(37.7186342037977, -122.483401916227)
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)
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)
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)
94649	94649	112577	Significant Tree 6	Magnolia grandiflora :: Southern Magnolia 21	3326 23RD ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24		Permit Number 775776	6006851.0	2102663.4	37.753900487576296	-122.419224541208	(37.7539004875763, -122.419224541208)
97871	97871	115124	Significant Tree 6	Lophostemon confertus :: Brisbane Box 11	499X MAIN ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8			6015842.0	2114626.0	37.7872494168956	-122.388966430338	(37.7872494168956, -122.388966430338)
98089	98089	110427	Significant Tree 6	Pinus radiata :: Monterey Pine 3	1860 09TH AVE	2	Front Yard : Yard 7	Tree 1	Private 1		05/12/2015 12:00:00 AM	3		Permit Number 775447	5993494.0	2102835.0	37.7536103714224	-122.465428263995	(37.7536103714224, -122.465428263995)
98300	98300	94851	Significant Tree 6	Acacia melanoxylon :: Blackwood Acacia 5	1107 Bowdoin St	2	Front Yard : Yard 7	Tree 1	Private 1		11/17/2010 12:00:00 AM	12		Permit Number 774691	6009593.0	2091048.0	37.7221611506882	-122.408922553301	(37.7221611506882, -122.408922553301)
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)
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)
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)
103313	103313	115731	Significant Tree 6	Acer rubrum :: Red Maple 6	15 Yerba Buena Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/24/2016 12:00:00 AM	3		Permit Number 776556	5993468.8	2097225.0	37.7382052810266	-122.465107977902	(37.7382052810266, -122.465107977902)
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)
107199	107199	112376	Significant Tree 6	Eucalyptus sideroxylon :: Red Ironbark 36	801 ULLOA ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	MTA 6			24			5993401.0	2098089.0	37.7405736985828	-122.46540514019699	(37.7405736985828, -122.465405140197)
107622	107622	104691	Significant Tree 6	Tree(s) :: 17	1435X La Salle Ave	2	Front Yard : Yard 7	Tree 1	Private 1		10/31/2013 12:00:00 AM			Permit Number 770699	6016460.43075	2095036.9864400001	37.733496412822205	-122.385461132957	(37.7334964128222, -122.385461132957)
108061	108061	104751	Significant Tree 6	Acacia melanoxylon :: Blackwood Acacia 5	13X JUAN BAUTISTA CIR	2	Front Yard : Yard 7	Tree 1	Private 1						5989494.0	2090180.0	37.7186314952818	-122.47833572411999	(37.7186314952818, -122.47833572412)
109308	109308	103590	Significant Tree 6	Juniperus chinensis :: Juniper 19	55X Laguna St	2	Front Yard : Yard 7	Tree 1	Private 1						6005242.6	2108960.5	37.7711001201992	-122.42523482670799	(37.7711001201992, -122.425234826708)
109347	109347	104937	Significant Tree 6	Liquidambar styraciflua :: American Sweet Gum 62	839 Gonzalez Dr	2	Front Yard : Yard 7	Tree 1	Private 1						5990419.0	2090610.0	37.7198658237335	-122.475169782631	(37.7198658237335, -122.475169782631)
109474	109474	98302	Significant Tree 6	Lophostemon confertus :: Brisbane Box 11	6 Locksley Ave	2	Front Yard : Yard 7	Tree 1	Private 1						5994194.0	2104902.7	37.7593280901784	-122.463157548093	(37.7593280901784, -122.463157548093)
111685	111685	107343	Significant Tree 6	Sequoia sempervirens :: Coast Redwood 116	110 JULIAN AVE	2	Back Yard : Yard 13	Tree 1	Private 1			15			6006340.8	2107214.1	37.7663669011591	-122.421312071366	(37.7663669011591, -122.421312071366)
111788	111788	106871	Significant Tree 6	Pittosporum undulatum :: Victorian Box 26	38 08th St	2	Front Yard : Cutout 8	Tree 1	Private 1		07/31/2014 12:00:00 AM			Permit Number 769156	6008506.93846	2111466.3623599997	37.7781645006636	-122.41412064163201	(37.7781645006636, -122.414120641632)
111867	111867	112057	Significant Tree 6	Liquidambar styraciflua :: American Sweet Gum 62	762 FUNSTON AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		12			5991999.0	2110277.0	37.773957792878704	-122.47114039751001	(37.7739577928787, -122.47114039751)
112529	112529	104716	Significant Tree 6	Juniperus chinensis :: Juniper 19	3618 22nd St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 770676	6004228.3	2103103.8	37.7549616692716	-122.42832583872601	(37.7549616692716, -122.428325838726)
113067	113067	104750	Significant Tree 6	Pinus radiata :: Monterey Pine 3	1X Junipero Serra Blvd Off Ramp	2	Front Yard : Yard 7	Tree 1	Private 1		08/30/2016 12:00:00 AM	3		Permit Number 770709	5991326.15861	2088181.65405	37.7132507161795	-122.47185719553998	(37.7132507161795, -122.47185719554)
114111	114111	112626	Significant Tree 6	Lophostemon confertus :: Brisbane Box 11	3430X 23rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12			6006285.0	2102686.4	37.753931748244604	-122.421183538041	(37.7539317482446, -122.421183538041)
114812	114812	100474	Significant Tree 6	Pinus halepensis :: Allepo Pine 164	930 Monterey Blvd	2	Front Yard : Yard 7	Tree 1	Private 1						5995794.4	2094643.4	37.7312506649165	-122.45688058924699	(37.7312506649165, -122.456880589247)
116788	116788	101979	Significant Tree 6	Schinus terebinthifolius :: Brazilian Pepper 25	25X Tiffany Ave	2	Front Yard : Yard 7	Tree 1	Private 1						6006415.7	2099833.4	37.7461054290546	-122.42052904239901	(37.7461054290546, -122.420529042399)
117349	117349	105754	Significant Tree 6	Tree(s) :: 17	1899X Eddy St	2	Front Yard : Yard 7	Tree 1	Private 1		02/21/2014 12:00:00 AM			Permit Number 772599	6001374.8	2112478.6	37.7805406719806	-122.438865805362	(37.7805406719806, -122.438865805362)
117755	117755	107142	Significant Tree 6	Aesculus californica :: California Buckeye 338	2694 MCALLISTER ST	2	Front Yard : Yard 7	Tree 1	Private 1			48			5996297.4	2110789.6	37.7756129427938	-122.45630867288999	(37.7756129427938, -122.45630867289)
118056	118056	99734	Significant Tree 6	Pyrus calleryana :: Ornamental Pear 9	145 Irving St	2	Front Yard : Yard 7	Tree 1	Private 1		08/21/2012 12:00:00 AM			Permit Number 768746	5995340.8	2106458.8	37.76366673695	-122.45930407086	(37.76366673695, -122.45930407086)
118284	118284	115091	Significant Tree 6	Tree(s) :: 17	121 Topaz Way	2	Front Yard : Yard 7	Tree 1	Private 1		01/11/2016 12:00:00 AM			Permit Number 776934	6001846.4	2098050.0	37.740950064786794	-122.436201464472	(37.7409500647868, -122.436201464472)
118401	118401	114145	Significant Tree 6	Acacia longifolia :: Golden Wattle 140	1200x JUNIPERO SERRA BLVD	2	Front Yard : Yard 7	Tree 1	Private 1			6			5991123.0	2089585.0	37.7170922039834	-122.47266163030399	(37.7170922039834, -122.472661630304)
118550	118550	104037	Significant Tree 6	Tree(s) :: 17	520X Oak Park Dr	2	Front Yard : Yard 7	Tree 1	Private 1						5995008.5	2103700.7	37.756074592877496	-122.46025354267599	(37.7560745928775, -122.460253542676)
118949	118949	114101	Significant Tree 6	Betula pendula :: European White Birch 146	21x ACEVEDO AVE	2	Front Yard : Yard 7	Tree 1	Private 1			7			5988027.0	2090598.0	37.7196939458216	-122.48343711113998	(37.7196939458216, -122.48343711114)
119511	119511	104899	Significant Tree 6	Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193	314 Gonzalez Dr	2	Front Yard : Yard 7	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
122098	122098	101203	Significant Tree 6	Tree(s) :: 17	7070 California St	2	Front Yard : 25	Tree 1	Private 1		10/03/2012 12:00:00 AM			Permit Number 769231	5985659.5	2114437.4	37.7850123376907	-122.49337605842699	(37.7850123376907, -122.493376058427)
122848	122848	96328	Significant Tree 6	Cordyline australis :: Dracena Palm 141	296 Randall St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 767829	6003708.0	2097940.0	37.7407536226533	-122.429756895294	(37.7407536226533, -122.429756895294)
124187	124187	104433	Significant Tree 6	Corymbia ficifolia :: Red Flowering Gum 60	1601X PORTOLA DR	2	Front Yard : Yard 7	Tree 1	Private 1			16			5991823.0	2096240.0	37.73540567927029	-122.47072655808	(37.7354056792703, -122.47072655808)

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