Street_Tree_List

Data source: data.sfgov.org

142 rows where DBH = 1 and qSpecies = 88 sorted by rowid 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

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

Link	rowid ▲	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
187472	187472	193345	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1133 19th St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 3ft		6014171.26133	2105242.63423	37.7613920486234	-122.394089723782	(37.7613920486234, -122.394089723782)
185939	185939	193350	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1752 Quesada Ave	1	: 4	Tree 1	Private 1			1	Width 4ft		6014471.5284	2095248.21375	37.7339661589078	-122.39235215802799	(37.7339661589078, -122.392352158028)
185429	185429	177428	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	274 Ney St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6005170.17326	2094055.30176	37.7301698012868	-122.42442500480499	(37.7301698012868, -122.424425004805)
182454	182454	193375	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	778 Tehama St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6008954.62424	2110209.1337900003	37.774737583109705	-122.41248303597901	(37.7747375831097, -122.412483035979)
182271	182271	130978	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2801 Webster St	9	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			1	Width 2ft		6002959.932159999	2118244.90398	37.7964635301195	-122.433794348725	(37.7964635301195, -122.433794348725)
182061	182061	115977	Planning Code 138.1 required 4	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2x Olmstead St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	3x3		6011639.0005	2091249.90123	37.722829925953896	-122.40186416949	(37.7228299259539, -122.40186416949)
181671	181671	230338	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	31 Walter St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6003171.4913099995	2108119.01737	37.7686723924455	-122.43233874923	(37.7686723924455, -122.43233874923)
181254	181254	208834	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1669 18th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 3ft		5990551.61783	2104055.61326	37.756791716882404	-122.47569268998699	(37.7567917168824, -122.475692689987)
181142	181142	208857	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1 Gennessee St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 8ft		5997408.7613699995	2093610.5667299998	37.7285073190505	-122.451225020336	(37.7285073190505, -122.451225020336)
180726	180726	230329	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	33 Prospect Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6007181.85452	2099302.37672	37.7446905059706	-122.417842137412	(37.7446905059706, -122.417842137412)
180284	180284	105250	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	500 36th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/08/2014 12:00:00 AM	1		Permit Number 771049	5984731.6893	2112357.9141599997	37.7792483592825	-122.496432443475	(37.7792483592825, -122.496432443475)
179928	179928	94708	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	696 12th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/28/2010 12:00:00 AM	1	3x3	Permit Number 53846	5992270.38847	2110735.82166	37.775233286679104	-122.470235046427	(37.7752332866791, -122.470235046427)
176873	176873	230285	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	112 27th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		6005732.266	2100246.49817	37.7472011631029	-122.422921627052	(37.7472011631029, -122.422921627052)
176498	176498	230339	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	65 Chenery St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6004912.08615	2097855.70847	37.7405902872201	-122.425587619594	(37.7405902872201, -122.425587619594)
176355	176355	177438	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	83 Karen Ct	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6010165.7616	2091462.99776	37.723332715313894	-122.406971881647	(37.7233327153139, -122.406971881647)
174665	174665	177435	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	99 Karen Ct	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6010088.68836	2091439.3296700001	37.72326341446679	-122.407236642978	(37.7232634144668, -122.407236642978)
174129	174129	193351	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1752 Quesada Ave	2	: 4	Tree 1	Private 1			1	Width 4ft		6014452.02014	2095263.45344	37.734006920685204	-122.392420670182	(37.7340069206852, -122.392420670182)
173728	173728	87489	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	496 38th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/16/2008 12:00:00 AM	1	3x3	Permit Number 50390	5984109.09334	2112519.44129	37.7796553729161	-122.498598162167	(37.7796553729161, -122.498598162167)
172623	172623	115978	Planning Code 138.1 required 4	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2x Olmstead St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	3x3		6011623.9012	2091244.95295	37.7228154963084	-122.40191601721001	(37.7228154963084, -122.40191601721)
172445	172445	121908	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	320 17th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5990601.2313	2113229.42539	37.781983392499704	-122.476191154353	(37.7819833924997, -122.476191154353)
171865	171865	114755	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	89 Karen Ct	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/04/2015 12:00:00 AM	1		Permit Number 777135	6010155.72688	2091460.8073900002	37.723326139481294	-122.407006415641	(37.7233261394813, -122.407006415641)
171742	171742	115979	Planning Code 138.1 required 4	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2x Olmstead St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	3x3		6011610.19593	2091240.25279	37.722801825729604	-122.401963063449	(37.7228018257296, -122.401963063449)
171597	171597	105251	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	500 36th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/08/2014 12:00:00 AM	1		Permit Number 771049	5984733.08187	2112389.43293	37.779334982299794	-122.496429952441	(37.7793349822998, -122.496429952441)
171575	171575	230321	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1297 Sanchez St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		6003909.46951	2100753.0320099997	37.748488965296204	-122.42926082853901	(37.7484889652962, -122.429260828539)
170923	170923	230330	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	38 Bonview St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6007670.81289	2099114.19378	37.744201302652705	-122.416138084916	(37.7442013026527, -122.416138084916)
168110	168110	230355	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	397 30th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6004002.34815	2098351.08289	37.7418990256315	-122.428768448829	(37.7418990256315, -122.428768448829)
167402	167402	193327	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1398 Tennessee St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6015585.429769999	2102602.25227	37.7542206208044	-122.38901430715799	(37.7542206208044, -122.389014307158)
165837	165837	101128	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	295X 16th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/01/2012 12:00:00 AM	1	3x3	Permit Number 769229	5990852.62725	2113482.2447900004	37.782692139400204	-122.47533991256701	(37.7826921394002, -122.475339912567)
165491	165491	193346	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1133 19th St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 3ft		6014187.49963	2105244.21667	37.761397296172	-122.394033672633	(37.761397296172, -122.394033672633)
165446	165446	230327	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	204 27th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6005133.403419999	2100215.61494	37.747082555133	-122.42499025209999	(37.747082555133, -122.4249902521)
165176	165176	114986	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1028 Prague St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/29/2015 12:00:00 AM	1		Permit Number 770492	6001259.4385	2086848.65908	37.7101603659725	-122.437429040618	(37.7101603659725, -122.437429040618)
163844	163844	123126	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	771 11th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		5992555.29457	2110202.5485900003	37.773785530078605	-122.469210678659	(37.7737855300786, -122.469210678659)
160542	160542	130984	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2200 Beach St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 4ft		5999592.955130001	2120888.49408	37.803530487293	-122.445634974783	(37.803530487293, -122.445634974783)
160433	160433	177442	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	67 Karen Ct	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6010267.21749	2091493.9064200001	37.723423260860706	-122.40662334309799	(37.7234232608607, -122.406623343098)
157255	157255	230354	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	531 30th St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 8ft		6003165.5903900005	2098301.47872	37.7417154299181	-122.431658143201	(37.7417154299181, -122.431658143201)
155447	155447	118202	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	744 35th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		5985103.04881	2110791.51915	37.774969236334	-122.495032243047	(37.774969236334, -122.495032243047)
154138	154138	177445	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	15 Karen Ct	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6010506.33995	2091553.32971	37.723599800462296	-122.405800920297	(37.7235998004623, -122.405800920297)
153849	153849	193344	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1133 19th St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 3ft		6014141.435	2105240.8231200003	37.761385417914205	-122.394192754591	(37.7613854179142, -122.394192754591)
153587	153587	95071	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	319 17th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/04/2011 12:00:00 AM	1	3x3	Permit Number 767740	5990554.377	2113243.49278	37.7820193005134	-122.476354274932	(37.7820193005134, -122.476354274932)
153325	153325	43146	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	243 Gambier St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/01/2015 12:00:00 AM	1		Permit Number 774635	6005976.40354	2092622.5546099998	37.7262812865364	-122.421536041574	(37.7262812865364, -122.421536041574)
153254	153254	230343	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	65 Chenery St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6004910.0558400005	2097921.66035	37.7407712613889	-122.42559933235	(37.7407712613889, -122.42559933235)
152854	152854	208839	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	131 Wawona St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5992959.48741	2098205.81206	37.74086896193	-122.466940197353	(37.74086896193, -122.466940197353)
151933	151933	230309	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3668 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6005328.964269999	2101978.057	37.7519328597144	-122.424439358013	(37.7519328597144, -122.424439358013)
151720	151720	193376	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	778 Tehama St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6008940.991169999	2110196.43665	37.7747019546579	-122.41252929798999	(37.7747019546579, -122.41252929799)
150867	150867	230315	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	131 Peralta Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6010141.9244099995	2100150.42012	37.7471851875523	-122.407666527004	(37.7471851875523, -122.407666527004)
150105	150105	230317	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	609 Precita Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6009667.55833	2100362.09801	37.74773984264029	-122.40932179038799	(37.7477398426403, -122.409321790388)
149661	149661	95133	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	450@ Wayland Somerset St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/04/2010 12:00:00 AM	1	3x3	Permit Number 54066	6010089.84133	2092358.2905700002	37.725786753837	-122.407297408351	(37.725786753837, -122.407297408351)
149654	149654	47068	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	604 Webster St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/28/2012 12:00:00 AM	1		Permit Number 768780	6004042.80919	2110860.8938	37.7762502823647	-122.429520495178	(37.7762502823647, -122.429520495178)
149083	149083	177440	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	71 Karen Ct	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6010238.57006	2091486.2001099999	37.7234004981218	-122.406721829644	(37.7234004981218, -122.406721829644)
148326	148326	208833	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1655 18th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5990561.21502	2104064.77483	37.75681742851079	-122.47566016868299	(37.7568174285108, -122.475660168683)
147660	147660	230340	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	65 Chenery St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6004910.8116	2097869.74707	37.7406287620114	-122.425593025396	(37.7406287620114, -122.425593025396)
146648	146648	230316	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	131 Peralta Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6010129.26175	2100145.52723	37.7471710439032	-122.407709968747	(37.7471710439032, -122.407709968747)
140795	140795	70259	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	613 York St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/24/2014 12:00:00 AM	1	3x5	Permit Number 771047	6009849.60881533	2105419.99624628	37.761637898995104	-122.409049096462	(37.7616378989951, -122.409049096462)
137500	137500	208837	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1958 17th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		5990984.78596	2102065.3313	37.7513520289909	-122.474049439736	(37.7513520289909, -122.474049439736)
135931	135931	193323	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1189 Tennessee St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6015597.773159999	2103545.2289400003	37.7568105190107	-122.38903745483299	(37.7568105190107, -122.389037454833)
135826	135826	99539	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	801X Central Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/16/2012 12:00:00 AM	1	3x3	Permit Number 768631	5999563.7	2111218.2	37.776976730821794	-122.445040600733	(37.7769767308218, -122.445040600733)
134885	134885	102443	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	514 Missouri St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/07/2013 12:00:00 AM	1		Permit Number 770339	6013518.76597	2104573.81866	37.7595193399709	-122.396299571184	(37.7595193399709, -122.396299571184)
133786	133786	230312	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2901 20th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6009544.39548	2104509.50944	37.759120806308204	-122.41004043054701	(37.7591208063082, -122.410040430547)
132678	132678	120242	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	288 24th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5988397.89946	2114035.20565	37.7840678224086	-122.483872680677	(37.7840678224086, -122.483872680677)
132124	132124	193349	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2501 18th St	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6010309.72434	2105489.81742	37.761855376635104	-122.407462658778	(37.7618553766351, -122.407462658778)
130079	130079	193365	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	260 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		6013979.60171	2116214.89575	37.7915087476865	-122.39552133835899	(37.7915087476865, -122.395521338359)
120994	120994	95216	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3623 18th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	3x3	Magnolia planted in Fall; 2010 without permit; to replace Acacia baileyana; which there was no permit for planting or removing.	6005441.0	2105452.0	37.761477821729706	-122.424298976847	(37.7614778217297, -122.424298976847)
117870	117870	17877	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2189 Pine St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			1	3X3		6003478.4464424	2115194.6078963	37.7881176060092	-122.431782277912	(37.7881176060092, -122.431782277912)
117109	117109	105717	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	409 26th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	3x3		5987766.351369999	2113121.02315	37.7815209517603	-122.485990454458	(37.7815209517603, -122.485990454458)
102284	102284	109757	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3590 20TH ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/01/2015 12:00:00 AM	1	3x3	Permit Number 772584	6006354.0	2104372.0	37.75856390529879	-122.421064595152	(37.7585639052988, -122.421064595152)
87725	87725	105693	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2523 HARRISON ST		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	3x3		6008930.3	2103627.5	37.7566645705002	-122.41210193949699	(37.7566645705002, -122.412101939497)
81426	81426	105758	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2523 HARRISON ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		1	3x3		6008930.3	2103627.5	37.7566645705002	-122.41210193949699	(37.7566645705002, -122.412101939497)
79119	79119	105692	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2523 HARRISON ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		1	3x3		6008930.3	2103627.5	37.7566645705002	-122.41210193949699	(37.7566645705002, -122.412101939497)
77021	77021	32342	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	130 Lexington St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/20/1998 12:00:00 AM	1		Permit Number 770451	6006450.269730001	2105316.80145	37.761163536302206	-122.420798725186	(37.7611635363022, -122.420798725186)
76764	76764	108377	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	226 Munich St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		1	3x3	Permit Number 773810	6004631.19295	2091083.0586299999	37.7219782266077	-122.42607682199801	(37.7219782266077, -122.426076821998)
75167	75167	177436	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	99 Karen Ct	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6010107.2934	2091444.47715	37.7232785896114	-122.40717269128099	(37.7232785896114, -122.407172691281)
74610	74610	230333	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	629 28th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6001808.677069999	2099403.33262	37.7446638554471	-122.436428732821	(37.7446638554471, -122.436428732821)
74564	74564	177429	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	278 Ney St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6005195.233080001	2094056.1980299999	37.7301736773527	-122.42433843338699	(37.7301736773527, -122.424338433387)
72706	72706	112523	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	195 02nd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/09/2015 12:00:00 AM	1	3x3	Permit Number 776238	5995199.36548	2114291.31706	37.7851646286632	-122.46036079357799	(37.7851646286632, -122.460360793578)
71293	71293	208847	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	422 Grafton Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5995505.44933	2090582.5246599999	37.7200838784427	-122.457585828931	(37.7200838784427, -122.457585828931)
71256	71256	52791	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	955@ MOSCOW Excelsior Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/25/2006 12:00:00 AM	1		Permit Number 48832	6004754.52241	2091271.3997400003	37.7225023397811	-122.425663900979	(37.7225023397811, -122.425663900979)
70176	70176	94709	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	739 12th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/28/2010 12:00:00 AM	1	3x3	Permit Number 53847	5992236.9095	2110392.30167	37.7742881380791	-122.47032583467899	(37.7742881380791, -122.470325834679)
69222	69222	68687	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	133 12th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/06/2014 12:00:00 AM	1	6x6	Permit Number 771044	5992088.87095	2114507.13587	37.7855777876584	-122.471137767056	(37.7855777876584, -122.471137767056)
68243	68243	87490	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	496 38th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/16/2008 12:00:00 AM	1	3x3	Permit Number 50390	5984109.08074	2112532.5405200003	37.77969133885821	-122.498599173652	(37.7796913388582, -122.498599173652)
68109	68109	112522	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	195 02nd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/09/2015 12:00:00 AM	1	3x3	Permit Number 776238	5995198.14893	2114301.9969900004	37.7851938828924	-122.460365776533	(37.7851938828924, -122.460365776533)
66302	66302	61318	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1419 Kansas St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/02/2014 12:00:00 AM	1		Permit Number 772899	6011764.55732	2101642.9103	37.751373940974204	-122.402160470048	(37.7513739409742, -122.402160470048)
65862	65862	130969	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	95 Heather Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1			5997355.4901	2113891.63765	37.7841910082488	-122.452872452398	(37.7841910082488, -122.452872452398)
65368	65368	230328	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	518 Banks St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6008539.17549	2096369.5184099998	37.7367138134929	-122.41294144560601	(37.7367138134929, -122.412941445606)
65070	65070	78191	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	680 Tennessee St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/05/2002 12:00:00 AM	1			6015407.71241	2105894.14692	37.7632496064147	-122.389858829046	(37.7632496064147, -122.389858829046)
64511	64511	177400	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1112 Russia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6003994.8137	2089359.3172799998	37.7172092225078	-122.428153843121	(37.7172092225078, -122.428153843121)
61056	61056	85039	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	740 Natoma St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/26/2007 12:00:00 AM	1	3x3	Permit Number 49387	6008855.33926	2110725.28618	37.776149243538796	-122.41286298423901	(37.7761492435388, -122.412862984239)
60469	60469	80737	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	186 Allison St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/22/2003 12:00:00 AM	1			6000043.5525400005	2087718.3093599998	37.7124790304587	-122.44169374357	(37.7124790304587, -122.44169374357)
60143	60143	72252	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	531 Madrid St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/06/1996 12:00:00 AM	1			6002585.93283	2090796.9641	37.7210768666757	-122.43312633500601	(37.7210768666757, -122.433126335006)
60128	60128	250187	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	665 Parker Ave	4	: 4	Tree 1	Private 1			1	Width 4ft		5997222.68042	2110871.6887	37.7758914096851	-122.453113845732	(37.7758914096851, -122.453113845732)
59077	59077	118718	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	818 44th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5982331.02075	2110159.51383	37.7730712650544	-122.504574285424	(37.7730712650544, -122.504574285424)
57558	57558	230352	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	136 Moffitt St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6002654.78135	2096839.9013099999	37.7376733091617	-122.433319933881	(37.7376733091617, -122.433319933881)
56984	56984	38711	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2000 McAllister St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/16/2012 12:00:00 AM	1		Permit Number 768631	5999529.3553	2111223.7902	37.7769901198015	-122.44515981121201	(37.7769901198015, -122.445159811212)
56518	56518	177443	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	63 Karen Ct	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6010306.59987	2091507.00491	37.7234614298874	-122.40648812732799	(37.7234614298874, -122.406488127328)
56377	56377	193374	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	778 Tehama St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6008975.96564	2110229.86919	37.7747957152898	-122.412410677425	(37.7747957152898, -122.412410677425)
55977	55977	230279	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	529 Buchanan St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 6ft		6004554.65684	2110370.74902	37.774933432055	-122.42771494250499	(37.774933432055, -122.427714942505)
55956	55956	246808	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	162 Brewster St	1	: 4	Tree 1	Private 1			1	Width 2ft		6010230.46229	2099004.5054099998	37.744043711743004	-122.407279600877	(37.744043711743, -122.407279600877)
55251	55251	130983	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2200 Beach St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 4ft		5999604.2907300005	2120890.91469	37.8035377808009	-122.44559592174	(37.8035377808009, -122.44559592174)
54565	54565	177434	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	131 Brussels St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		6010258.4147	2094004.87757	37.7303173692474	-122.40683065573099	(37.7303173692474, -122.406830655731)
53809	53809	98842	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	313 Maple St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/14/2012 12:00:00 AM	1		Permit Number 768890	5996633.94495	2115242.03804	37.7878574732038	-122.455466360678	(37.7878574732038, -122.455466360678)
53694	53694	109906	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1415 Howard St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			1	3x3		6008272.88194	2109795.90835	37.773564680997296	-122.41481207772199	(37.7735646809973, -122.414812077722)

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