Street_Tree_List

Data source: data.sfgov.org

142 rows where DBH = 1 and qSpecies = 88 sorted by XCoord

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
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)
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)
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)
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)
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)
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)
53029	53029	118073	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	449 34th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5985293.2738	2112845.5441799997	37.7806201339604	-122.49452567585199	(37.7806201339604, -122.494525675852)
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)
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)
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)
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)
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)
30218	30218	208836	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1677 18th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 3ft		5990563.73281	2104000.71919	37.756641694668396	-122.47564678406499	(37.7566416946684, -122.475646784065)
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)
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)
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)
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)
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)
27994	27994	52460	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	682@ CABRILLO 12th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/27/2005 12:00:00 AM	1		Permit Number 48571	5992268.12798	2110826.06835	37.775480948973396	-122.470249439229	(37.7754809489734, -122.470249439229)
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)
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)
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)
31482	31482	53932	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	140 09th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/27/1972 12:00:00 AM	1		Permit Number 9646	5993064.176969999	2114524.47346	37.785681755762894	-122.46776478269899	(37.7856817557629, -122.467764782699)
37388	37388	123549	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	65 05th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		5994237.46417	2115165.09446	37.7875084040974	-122.46375209006099	(37.7875084040974, -122.463752090061)
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)
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)
42403	42403	124334	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	176 Palm Ave	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			1	Width 4ft		5995958.15323	2113125.95358	37.782008471168	-122.457651289636	(37.782008471168, -122.457651289636)
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)
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)
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)
32904	32904	130968	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	95 Heather Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1			5997356.6821800005	2113906.91877	37.7842330344764	-122.45286943159799	(37.7842330344764, -122.452869431598)
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)
48031	48031	130967	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	213 Walnut St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		5998523.7164	2115638.03819	37.7890530400256	-122.448956666639	(37.7890530400256, -122.448956666639)
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)
27791	27791	38712	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2000 McAllister St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/16/2012 12:00:00 AM	1		Permit Number 768631	5999544.5843	2111225.8207	37.7769965642688	-122.44510727559799	(37.7769965642688, -122.445107275598)
45916	45916	99538	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	801X Central Ave	1	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)
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)
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)
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)
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)
23977	23977	177421	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	0 Santa Ynez Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		6001079.38248	2091791.86287	37.7237230579705	-122.438405269984	(37.7237230579705, -122.438405269984)
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)
47177	47177	177448	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1022 Prague St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		6001291.58576	2086844.2282099999	37.7101500273691	-122.437317616421	(37.7101500273691, -122.437317616421)
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)
28727	28727	177449	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	324 Cordova St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6001907.3749400005	2086972.3844599999	37.7105369040276	-122.43519848992901	(37.7105369040276, -122.435198489929)
23545	23545	177395	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	715 Madrid St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6001937.656140001	2089768.77997	37.718216907458704	-122.435293726344	(37.7182169074587, -122.435293726344)
26535	26535	177420	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	121 Cotter St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 3ft		6001985.26237	2093449.7289900002	37.728326668619296	-122.435392337892	(37.7283266686193, -122.435392337892)
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)
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)
29718	29718	130970	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2801 Webster St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			1	Width 2ft		6002945.56276	2118345.7946599997	37.796739734404	-122.433851284829	(37.796739734404, -122.433851284829)
35821	35821	130973	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2801 Webster St	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			1	Width 2ft		6002952.36205	2118301.89076	37.796619571497104	-122.43382461811501	(37.7966195714971, -122.433824618115)
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)
44581	44581	177415	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	451 Edinburgh St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6003094.686869999	2091098.4419099998	37.7219335042119	-122.431389232421	(37.7219335042119, -122.431389232421)
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)
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)
27217	27217	230322	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	4089 26th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6003345.458190001	2100655.86235	37.7481902141138	-122.43120423378299	(37.7481902141138, -122.431204233783)
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)
34177	34177	177411	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	474 Munich St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6003775.47727	2089725.4167	37.7182020389599	-122.42893807173	(37.7182020389599, -122.42893807173)
38105	38105	177410	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	470 Munich St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6003782.11139	2089736.37793	37.718232511606296	-122.428915921448	(37.7182325116063, -122.428915921448)
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)
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)
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)
53463	53463	47067	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	604 Webster St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/28/2012 12:00:00 AM	1		Permit Number 768780	6004041.40702	2110873.30571	37.7762842830232	-122.429526231047	(37.7762842830232, -122.429526231047)
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)
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)
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)
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)
38961	38961	230341	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	65 Chenery St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6004909.36728	2097888.2006599996	37.7406793497697	-122.425599332346	(37.7406793497697, -122.425599332346)
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)
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)
44551	44551	230342	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	65 Chenery St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6004911.05921	2097907.1085200002	37.740731362062704	-122.42559482765499	(37.7407313620627, -122.425594827655)
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)
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)
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)
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)
28385	28385	230289	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3798 25th St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		6005260.07773	2101390.67485	37.750316153870294	-122.424635797817	(37.7503161538703, -122.424635797817)
46226	46226	230288	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3798 25th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		6005272.34355	2101391.85682	37.7503200920091	-122.424593465816	(37.7503200920091, -122.424593465816)
39226	39226	230287	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3798 25th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		6005284.60936	2101393.03847	37.750324029253505	-122.42455113382299	(37.7503240292535, -122.424551133823)
34364	34364	177430	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	294 Ney St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6005292.64234	2094059.9977799999	37.730189610640004	-122.424001946647	(37.73018961064, -122.424001946647)
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)
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)
48337	48337	230332	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	73 Leese St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6005526.20735	2096295.99594	37.736342348511	-122.423353372654	(37.736342348511, -122.423353372654)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
34741	34741	230311	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2901 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6009504.69694	2104506.09173	37.7591091969416	-122.41017748630101	(37.7591091969416, -122.410177486301)
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)

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