Street_Tree_List

Data source: data.sfgov.org

232 rows where DBH = 3 and qSpecies = 88 sorted by TreeID

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

Link	rowid	TreeID ▼	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
119795	119795	450	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	700x 23rd Ave	10	Median : Cutout 11	Tree 1	DPW 2		05/29/2015 01:42:00 PM	3			5988819.93055	2110324.8097900003	37.773904673102	-122.48214070454901	(37.773904673102, -122.482140704549)
103588	103588	1922	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	66 Berkeley Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/08/2016 02:50:00 PM	3	3x3		6001235.3932896	2097346.6778621003	37.7389841732277	-122.43826372276199	(37.7389841732277, -122.438263722762)
22057	22057	5393	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	347 Dolores St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/10/2014 12:00:00 AM	3	6x7		6004928.4905	2106245.9446799997	37.7636288523174	-122.426128059965	(37.7636288523174, -122.426128059965)
84429	84429	5717	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1647 Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/14/2008 12:00:00 AM	3	3X3		6005332.0180626	2098744.9227683996	37.7430555871926	-122.424198880257	(37.7430555871926, -122.424198880257)
505	505	6741	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1300X Fairfax Ave	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/10/2017 01:50:00 PM	3	3x3		6016924.03316	2097256.8815900004	37.739617439282604	-122.38401284003099	(37.7396174392826, -122.384012840031)
500	500	6742	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1300X Fairfax Ave	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/10/2017 01:53:00 PM	3	3x3		6016901.500630001	2097278.26947	37.7396749203573	-122.384092237585	(37.7396749203573, -122.384092237585)
9836	9836	6755	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1215 Fairfax Ave	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/03/2017 06:41:00 AM	3	3x3		6017521.099066501	2096743.3718321999	37.7382404347673	-122.381912713319	(37.7382404347673, -122.381912713319)
143719	143719	8223	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1500X Galvez Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/10/2015 08:24:00 AM	3	3x3		6016396.247314	2097296.3974116	37.739696749128896	-122.385840466933	(37.7396967491289, -122.385840466933)
81549	81549	8225	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1500X Galvez Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/10/2015 08:37:00 AM	3	3x3		6016396.247314	2097296.3974116	37.739696749128896	-122.385840466933	(37.7396967491289, -122.385840466933)
116957	116957	8230	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1500X Galvez Ave	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/10/2015 08:33:00 AM	3	3x3		6016396.247314	2097296.3974116	37.739696749128896	-122.385840466933	(37.7396967491289, -122.385840466933)
101009	101009	12725	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1544 Lake St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/07/2003 12:00:00 AM	3	3X3		5990592.796680001	2114771.31925	37.7862165141869	-122.476332998319	(37.7862165141869, -122.476332998319)
4168	4168	13059	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	583 Lombard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/28/2015 07:23:00 AM	3	2x2		6009557.0524	2120495.5376	37.8030153566132	-122.41112585507	(37.8030153566132, -122.41112585507)
143305	143305	13238	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2322 Lombard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/15/1998 12:00:00 AM	3	3X3		6001219.43305	2119376.81704	37.7994725475626	-122.439898035919	(37.7994725475626, -122.439898035919)
6628	6628	17981	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2583 Pine St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/28/2014 12:00:00 AM	3	3x3		6001557.63	2114929.1565	37.7872796746141	-122.438408931359	(37.7872796746141, -122.438408931359)
90740	90740	18413	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	799X Potrero Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/05/2013 12:00:00 AM	3	4X4		6010481.346466599	2104567.7087473	37.759333078347105	-122.406804093165	(37.7593330783471, -122.406804093165)
89613	89613	24369	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	134 Duboce Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		07/19/2016 04:44:00 AM	3	3x3		6005829.420761799	2108507.0022787	37.7698880583785	-122.42317275016899	(37.7698880583785, -122.423172750169)
116356	116356	26561	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	430 Bay Shore Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/10/2007 12:00:00 AM	3	3X3		6010306.750370901	2097855.6706051	37.740893529599106	-122.406934857164	(37.7408935295991, -122.406934857164)
84281	84281	26689	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1295X Pierce St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	4X4		6002245.89461	2112942.9215	37.7818651028046	-122.435885513106	(37.7818651028046, -122.435885513106)
2326	2326	32310	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	600 Kansas St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/11/2017 12:00:00 AM	3	3x3	Permit Number 780021	6011490.21346	2105535.41825	37.762046590490705	-122.40338299943899	(37.7620465904907, -122.403382999439)
173281	173281	32337	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2626 Fulton St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/03/1996 12:00:00 AM	3		Permit Number 36899	5995236.946330001	2110306.39824	37.7742252654946	-122.459942005265	(37.7742252654946, -122.459942005265)
16526	16526	33774	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	77 Beale St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/05/2015 12:00:00 AM	3	3x3	Permit Number 774395	6013834.28126	2116198.48682	37.791455608540396	-122.396022998165	(37.7914556085404, -122.396022998165)
14755	14755	33779	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	77 Beale St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/05/2015 12:00:00 AM	3	3x3	Permit Number 774395	6013803.37475	2116233.23226	37.79154929181811	-122.396132371028	(37.7915492918181, -122.396132371028)
13895	13895	33780	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	77 Beale St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/05/2015 12:00:00 AM	3	3x3	Permit Number 774395	6013824.14126	2116210.79912	37.7914888510795	-122.39605894586	(37.7914888510795, -122.39605894586)
16231	16231	33782	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	77 Beale St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/05/2015 12:00:00 AM	3	3x3	Permit Number 774395	6013852.02109	2116179.41654	37.7914042329729	-122.395960281264	(37.7914042329729, -122.395960281264)
14247	14247	33783	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	77 Beale St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/05/2015 12:00:00 AM	3	3x3	Permit Number 774395	6013842.9233800005	2116188.62598	37.7914290137913	-122.395992405042	(37.7914290137913, -122.395992405042)
13642	13642	33785	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	77 Beale St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/05/2015 12:00:00 AM	3	3x3	Permit Number 774395	6013812.6799	2116223.3583	37.7915226979635	-122.39609948281701	(37.7915226979635, -122.396099482817)
16533	16533	33792	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	77 Beale St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/05/2015 12:00:00 AM	3	3x3	Permit Number 774395	6013856.54517	2116173.60161	37.7913885182281	-122.395944220262	(37.7913885182281, -122.395944220262)
14233	14233	33800	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	77 Beale St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/05/2015 12:00:00 AM	3	3x3	Permit Number 774395	6013865.37275	2116161.97621	37.7913570887062	-122.39591286179899	(37.7913570887062, -122.395912861799)
172672	172672	34927	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2625 Baker St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/31/2012 12:00:00 AM	3		Permit Number 768761	5999601.94789	2117876.9745400003	37.7952621734732	-122.44538718908301	(37.7952621734732, -122.445387189083)
106292	106292	43751	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	255 15th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/24/2015 12:00:00 AM	3		Permit Number 773834	5991170.79793	2113718.28394	37.7833586747671	-122.474256417664	(37.7833586747671, -122.474256417664)
103390	103390	49736	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	251 28th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/04/2003 12:00:00 AM	3	3x12	Permit Number 46536	5987104.42255848	2114202.9919751	37.7844531321546	-122.488359918659	(37.7844531321546, -122.488359918659)
90183	90183	49737	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	251 28th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/04/2003 12:00:00 AM	3	3x12	Permit Number 46536	5987104.42255848	2114202.9919751	37.7844531321546	-122.488359918659	(37.7844531321546, -122.488359918659)
153237	153237	50024	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1704 Felton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/28/2003 12:00:00 AM	3		Permit Number 46757	6005953.2164199995	2092396.45471	37.725659158041104	-122.421600147046	(37.7256591580411, -122.421600147046)
60907	60907	50426	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	250 Howth St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/12/2014 12:00:00 AM	3		Permit Number 773627	5997303.25557645	2090612.9654569	37.7202705700793	-122.45137364778	(37.7202705700793, -122.45137364778)
118340	118340	52314	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	4284 23rd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/12/2008 12:00:00 AM	3	3x3	Permit Number 50258	6001331.50265799	2102347.48483234	37.7527206699479	-122.438289584359	(37.7527206699479, -122.438289584359)
2327	2327	53079	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	600 Kansas St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/11/2017 12:00:00 AM	3	3x3	Permit Number 780021	6011490.70702	2105522.9440900004	37.7620123668039	-122.4033804148	(37.7620123668039, -122.4033804148)
110256	110256	57018	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	73 Henry St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/16/1974 12:00:00 AM	3	3x3	Permit Number 14277	6003050.12162516	2107377.07151823	37.766628307485	-122.43270555008101	(37.766628307485, -122.432705550081)
14678	14678	59614	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1014 Tennessee St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/2011 12:00:00 AM	3	3x3	Permit Number 767137	6015492.62077	2104343.80938	37.7589974211239	-122.389456881532	(37.7589974211239, -122.389456881532)
156259	156259	61491	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	178 20th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/11/1990 12:00:00 AM	3		Permit Number 28869	5989634.7512	2114171.8446400003	37.784514919234205	-122.47960366993601	(37.7845149192342, -122.479603669936)
181883	181883	62233	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	120 Capistrano Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/30/1985 12:00:00 AM	3		Permit Number 22359	6001435.36273	2093541.49048	37.728547379336206	-122.437299929461	(37.7285473793362, -122.437299929461)
82388	82388	63744	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	690 Page St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/24/2014 12:00:00 AM	3	3x3	Permit Number 773423	6003267.19349485	2109664.80045569	37.772922159977	-122.43211812531901	(37.772922159977, -122.432118125319)
142880	142880	64577	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3500 19th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/06/2011 12:00:00 AM	3	4x4 1/2	Permit Number 767979	6006252.59051018	2104959.36998238	37.7601709691535	-122.42145702923	(37.7601709691535, -122.42145702923)
63085	63085	65128	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	184 20th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/31/2008 12:00:00 AM	3	3x3	Permit Number 50320	5989636.73328	2114131.59369	37.7844045165702	-122.47959386665	(37.7844045165702, -122.47959386665)
164298	164298	66134	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3259 Baker St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/17/2011 12:00:00 AM	3		Permit Number 768243	5999299.78945	2120070.84719	37.8012687076388	-122.446590621369	(37.8012687076388, -122.446590621369)
179311	179311	67205	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	123 25th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/13/1992 12:00:00 AM	3		Permit Number 30659	5987996.0292	2115149.70283	37.7871045112839	-122.485344797558	(37.7871045112839, -122.485344797558)
66893	66893	69450	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	438 33rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/16/1994 12:00:00 AM	3		Permit Number 33560	5985645.83858	2112922.4758599997	37.780851994355004	-122.493311672832	(37.780851994355, -122.493311672832)
125226	125226	70167	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	831 45th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/12/2015 12:00:00 AM	3		Permit Number 773700	5981976.78091	2110066.45395	37.772794906459	-122.505792724366	(37.772794906459, -122.505792724366)
88121	88121	71505	Private 5	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	328 San Carlos St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/18/2015 12:00:00 AM	3	3x3	Permit Number 774557	6006691.32680411	2104197.11487977	37.758102721165706	-122.41988555479601	(37.7581027211657, -122.419885554796)
97135	97135	72366	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	706 15th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/21/2014 12:00:00 AM	3	3x3	Permit Number 772932	5991332.62885	2110561.58816	37.7747006286591	-122.473466226319	(37.7747006286591, -122.473466226319)
11033	11033	83366	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	618 Athens St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/01/2009 12:00:00 AM	3	3x3	Permit Number 52311	6003144.474669999	2089738.5573200001	37.718202383405206	-122.43112011482701	(37.7182023834052, -122.431120114827)
80419	80419	83398	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	4244X 19th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Rec/Park 3		06/12/2008 12:00:00 AM	3	3x3	Permit Number 50813	6001912.0	2104709.0	37.7592378221466	-122.43645112889901	(37.7592378221466, -122.436451128899)
11429	11429	83565	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	647 Athens St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/27/2012 12:00:00 AM	3	3x3	Permit Number 769747	6003095.84203	2089582.30789	37.7177706009018	-122.43127706988199	(37.7177706009018, -122.431277069882)
10886	10886	83673	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	618 Athens St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/01/2009 12:00:00 AM	3	3x3	Permit Number 52311	6003154.7737300005	2089756.30482	37.7182516977425	-122.43108578140499	(37.7182516977425, -122.431085781405)
97637	97637	83771	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	924 Rutland St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/19/2008 12:00:00 AM	3	3x3	Permit Number 50981	6009720.30690757	2087000.33290755	37.7110542204407	-122.408197148869	(37.7110542204407, -122.408197148869)
49125	49125	84779	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	224 Mississippi St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/18/2007 12:00:00 AM	3		Permit No. 49287	6013986.61648	2106050.38487	37.7635996908854	-122.394784908699	(37.7635996908854, -122.394784908699)
77791	77791	85870	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2310 Folsom St	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/22/2007 12:00:00 AM	3	3x3		6008150.982530001	2104964.863142	37.760292906427296	-122.41489175995599	(37.7602929064273, -122.414891759956)
38918	38918	87076	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2565 Larkin St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/18/2007 12:00:00 AM	3	3x3	Permit Number 50014	6006601.66741	2120051.34913	37.8016295480248	-122.421321483111	(37.8016295480248, -122.421321483111)
76542	76542	87077	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2565 Larkin St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/18/2007 12:00:00 AM	3	3x3	Permit Number 50014	6006603.98041	2120038.0860099997	37.8015932612686	-122.421312536668	(37.8015932612686, -122.421312536668)
82853	82853	88479	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1751 Newcomb Ave		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/18/2008 12:00:00 AM	3	3x3	Permit Number 51431	6014386.0	2096253.8	37.7367225430205	-122.392718181551	(37.7367225430205, -122.392718181551)
155904	155904	93189	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	651 24th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/18/2010 12:00:00 AM	3	3x3	Permit Number 53197	5988441.61799	2111543.24899	37.77722815601879	-122.483538678985	(37.7772281560188, -122.483538678985)
144432	144432	94054	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	185 Haight St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/22/2010 12:00:00 AM	3	3x9		6005268.81764	2109524.34557	37.7726497850887	-122.425184266439	(37.7726497850887, -122.425184266439)
105507	105507	94055	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	179 Haight St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/22/2010 12:00:00 AM	3	3x9		6005293.287409999	2109516.64513	37.7726300238656	-122.42509907481	(37.7726300238656, -122.42509907481)
188017	188017	94885	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2010 Quesada Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/23/2010 12:00:00 AM	3	3x3	Permit Number 53951	6013050.0613	2096298.0841299999	37.736769849332	-122.39734023878599	(37.736769849332, -122.397340238786)
2247	2247	95100	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2200 Beach St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/25/2014 12:00:00 AM	3	3x3	Permit Number 773992	5999642.14759	2120895.8486200003	37.8035534892505	-122.445465271815	(37.8035534892505, -122.445465271815)
15812	15812	95581	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3881 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/01/2017 12:00:00 AM	3	3x3	Permit Number 779561	6003940.0	2101864.0	37.7515411523314	-122.429234461777	(37.7515411523314, -122.429234461777)
40091	40091	95676	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	232 Goettingen St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/08/2011 12:00:00 AM	3	3x3	Permit Number 767428	6010063.65694	2093465.1071400002	37.7288243741431	-122.407465923318	(37.7288243741431, -122.407465923318)
126977	126977	95932	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	218 28th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/29/2011 12:00:00 AM	3	3x3	Permit Number 767629	5987170.3	2114494.3	37.7852568239907	-122.488153421892	(37.7852568239907, -122.488153421892)
106722	106722	96167	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1325X San Jose Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/08/2011 12:00:00 AM	3	3x3	Permit Number 767799	6003578.5	2095430.2	37.7338549505754	-122.430025664845	(37.7338549505754, -122.430025664845)
63323	63323	96333	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	11 Robblee Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/28/2011 12:00:00 AM	3	3x3	Permit Number 767342	6012676.77436	2095976.0416	37.7358647977189	-122.398608271155	(37.7358647977189, -122.398608271155)
6714	6714	97108	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1472 Pacific Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/12/2011 12:00:00 AM	3	3x3	Permit Number 768373	6007110.8589699995	2117762.02293	37.795372327823	-122.419396941128	(37.795372327823, -122.419396941128)
125633	125633	99307	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	59 Lundy's Ln	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/06/2016 12:00:00 AM	3	3x3	Permit Number 777839	6006944.8	2099028.3	37.7439246092205	-122.418642395457	(37.7439246092205, -122.418642395457)
124045	124045	99576	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	301X Noe St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/21/2012 12:00:00 AM	3	3x3	768682	6002944.2	2106475.3	37.7641462544056	-122.433007480488	(37.7641462544056, -122.433007480488)
82995	82995	99875	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1301X San Jose Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	3x3		6003616.3	2095455.7	37.733927108519204	-122.429896797189	(37.7339271085192, -122.429896797189)
141933	141933	99876	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1295X San Jose Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	3x3		6003506.1	2095452.4	37.733911806121895	-122.43027755668899	(37.7339118061219, -122.430277556689)
2310	2310	102805	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	600 Kansas St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/11/2017 12:00:00 AM	3	3x3	Permit Number 780021	6011492.26434	2105507.65774	37.7619704808857	-122.403373953167	(37.7619704808857, -122.403373953167)
90280	90280	103767	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1323 Polk St	1	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006757.0	2115467.0	37.7890508291132	-122.42045837028401	(37.7890508291132, -122.420458370284)
22965	22965	103768	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1323 Polk St	2	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006757.0	2115467.0	37.7890508291132	-122.42045837028401	(37.7890508291132, -122.420458370284)
127048	127048	103773	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1288 Polk St	3	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3			6006856.2	2115250.5	37.7884619632914	-122.420099779635	(37.7884619632914, -122.420099779635)
105089	105089	103774	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1288 Polk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006856.2	2115250.5	37.7884619632914	-122.420099779635	(37.7884619632914, -122.420099779635)
88285	88285	103775	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1288 Polk St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006856.2	2115250.5	37.7884619632914	-122.420099779635	(37.7884619632914, -122.420099779635)
129307	129307	103781	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1237 Polk St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/2009 12:00:00 AM	3	3x3		6006764.1	2115217.5	37.7883661638156	-122.420416088533	(37.7883661638156, -122.420416088533)
83122	83122	103782	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1237 Polk St	2	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006764.1	2115217.5	37.7883661638156	-122.420416088533	(37.7883661638156, -122.420416088533)
127702	127702	103787	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1217 Polk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006790.1	2115111.0	37.7880752061995	-122.42031857060101	(37.7880752061995, -122.420318570601)
125759	125759	103800	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1157 Polk St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/2009 12:00:00 AM	3	3x3		6006858.38304	2114906.78358	37.787518325661296	-122.42006782447201	(37.7875183256613, -122.420067824472)
125634	125634	103801	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1157 Polk St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/2009 12:00:00 AM	3	3x3		6006858.38304	2114906.78358	37.787518325661296	-122.42006782447201	(37.7875183256613, -122.420067824472)
143836	143836	103802	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1157 Polk St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/2009 12:00:00 AM	3	3x3		6006858.38304	2114906.78358	37.787518325661296	-122.42006782447201	(37.7875183256613, -122.420067824472)
145707	145707	103809	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1145 Polk St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006819.8	2114898.5	37.7874934070669	-122.42020072617599	(37.7874934070669, -122.420200726176)
98614	98614	103810	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1145 Polk St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006819.8	2114898.5	37.7874934070669	-122.42020072617599	(37.7874934070669, -122.420200726176)
144400	144400	103811	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1145 Polk St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006819.8	2114898.5	37.7874934070669	-122.42020072617599	(37.7874934070669, -122.420200726176)
22953	22953	103852	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1507 Polk St	1	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006614.6	2116113.6	37.7908182067111	-122.420996984718	(37.7908182067111, -122.420996984718)
22940	22940	103859	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1475 Polk St	3	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006677.0	2115920.4	37.7902912446707	-122.420767361582	(37.7902912446707, -122.420767361582)
22958	22958	103860	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1475 Polk St	4	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006677.0	2115920.4	37.7902912446707	-122.420767361582	(37.7902912446707, -122.420767361582)
122302	122302	103861	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1436 Polk St	1	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006766.2	2115894.4	37.7902248822442	-122.42045688909701	(37.7902248822442, -122.420456889097)
105404	105404	103863	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1435 Polk St	1	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006674.8	2115856.4	37.790115392534	-122.42077042798	(37.790115392534, -122.42077042798)
112678	112678	103864	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1435 Polk St	2	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006674.8	2115856.4	37.790115392534	-122.42077042798	(37.790115392534, -122.42077042798)
91623	91623	103865	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1424 Polk St	1	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006775.0	2115831.4	37.790052395748404	-122.420421968076	(37.7900523957484, -122.420421968076)
103601	103601	103866	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1411 Polk St	1	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006684.9	2115784.5	37.7899185422019	-122.42073037630101	(37.7899185422019, -122.420730376301)
122862	122862	103867	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1411 Polk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006684.9	2115784.5	37.7899185422019	-122.42073037630101	(37.7899185422019, -122.420730376301)
115999	115999	103868	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1411 Polk St	3	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006684.9	2115784.5	37.7899185422019	-122.42073037630101	(37.7899185422019, -122.420730376301)
86852	86852	103869	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1411 Polk St	4	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006684.9	2115784.5	37.7899185422019	-122.42073037630101	(37.7899185422019, -122.420730376301)

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