Street_Tree_List

Data source: data.sfgov.org

109 rows where DBH = 2 and qSpecies = 88

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

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
24130	24130	96862	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	387 29th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/02/2011 12:00:00 AM	2	3x3	Permit Number 768142	5986827.805480001	2113344.76478	37.7820805427479	-122.48925378416	(37.7820805427479, -122.48925378416)
24569	24569	230346	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1801 Church St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004582.48938	2098325.9035400003	37.74186270650671	-122.426760715042	(37.7418627065067, -122.426760715042)
25430	25430	113267	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	83 Exeter St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/16/2015 12:00:00 AM	2		Permit Number 774551	6012507.044369999	2090789.37208	37.7216138123142	-122.398831200496	(37.7216138123142, -122.398831200496)
28196	28196	88382	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	355 17th Ave		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/10/2008 12:00:00 AM	2	3x3	Permit Number 51360	5990561.77007	2113010.94096	37.7813812065074	-122.476311706446	(37.7813812065074, -122.476311706446)
29464	29464	230344	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1801 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004583.81865	2098292.85658	37.7417720422523	-122.426753765994	(37.7417720422523, -122.426753765994)
29955	29955	48772	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	766 28th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/22/2002 12:00:00 AM	2		Permit Number 46029	5987276.54902	2110739.79263	37.7749542102717	-122.48750993680099	(37.7749542102717, -122.487509936801)
30883	30883	119446	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	881 32nd Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 6ft		5986011.18097	2109924.94508	37.7726429911374	-122.49182705320801	(37.7726429911374, -122.491827053208)
32841	32841	193369	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	262 Mission St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6013943.1918	2116180.78279	37.791413056208704	-122.39564492587601	(37.7914130562087, -122.395644925876)
32960	32960	124335	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	176 Palm Ave	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 2ft		5995959.20478	2113110.98096	37.78196742074471	-122.457646568088	(37.7819674207447, -122.457646568088)
34714	34714	177431	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	268 Madison St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6005673.422730001	2092431.0022599997	37.7257382372047	-122.42256982665	(37.7257382372047, -122.42256982665)
35331	35331	193332	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1258 Minnesota St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6015304.05705	2102667.26372	37.7543835276007	-122.38999191341999	(37.7543835276007, -122.38999191342)
36826	36826	218387	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	50 San Marcos Ave	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5993857.52408	2100226.90247	37.746470159084396	-122.46398181990101	(37.7464701590844, -122.463981819901)
37460	37460	230298	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	613 York St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009857.38844	2105338.70025	37.761415114429795	-122.409016453452	(37.7614151144298, -122.409016453452)
38082	38082	131000	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	937 Lombard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6007889.3393	2120258.1981200003	37.8022700164033	-122.416880201885	(37.8022700164033, -122.416880201885)
43802	43802	65195	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	277 Lisbon St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/29/1989 12:00:00 AM	2		Permit Number 27179	6002900.88646	2091805.0724099998	37.723862768534104	-122.432109587587	(37.7238627685341, -122.432109587587)
44983	44983	250184	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	665 Parker Ave	1	: 4	Tree 1	Private 1			2	Width 4ft		5997216.13133	2110917.44789	37.7760166771611	-122.45313980466699	(37.7760166771611, -122.453139804667)
45211	45211	193377	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	250 10th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008648.26214	2109663.47426	37.773222132835706	-122.41350420897899	(37.7732221328357, -122.413504208979)
45272	45272	98453	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	518 Pennsylvania Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/15/2012 12:00:00 AM	2	3x3	Permit Number 768642	6014340.87186	2104676.4561900003	37.7598468721503	-122.393463482668	(37.7598468721503, -122.393463482668)
46349	46349	177433	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	439 Bowdoin St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008733.06168	2093861.6141400002	37.7298385306021	-122.412093908309	(37.7298385306021, -122.412093908309)
49507	49507	230314	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	31 Mullen Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009412.86003	2099877.13325	37.7463939631256	-122.41016829345301	(37.7463939631256, -122.410168293453)
50948	50948	85291	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	7350 Geary Blvd		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/24/2007 12:00:00 AM	2	4x72	Permit Number 49578	5984127.30348	2112512.4695	37.779637298343	-122.498534651264	(37.779637298343, -122.498534651264)
51630	51630	193333	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1258 Minnesota St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6015305.27356	2102653.19148	37.7543449556813	-122.389986723422	(37.7543449556813, -122.389986723422)
52541	52541	47432	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	432 42nd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/14/2002 12:00:00 AM	2		Permit Number 45343	5982855.38785	2112869.9347900003	37.7805441204791	-122.50296115463001	(37.7805441204791, -122.50296115463)
52684	52684	131002	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	937 Lombard St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6007919.06293	2120264.13988	37.802288002842396	-122.416777764577	(37.8022880028424, -122.416777764577)
52959	52959	208835	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1673 18th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5990563.36006	2104017.9082	37.7566888695243	-122.475649328274	(37.7566888695243, -122.475649328274)
53678	53678	193364	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	260 Mission St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6013990.639330001	2116225.4508599997	37.791538343481605	-122.395483887876	(37.7915383434816, -122.395483887876)
54081	54081	193373	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	61 Beale St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6013783.27133	2116255.65231	37.7916097334637	-122.39620350109699	(37.7916097334637, -122.396203501097)
54260	54260	177419	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	100 Capistrano Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6001443.854169999	2093560.7227900003	37.7286006695825	-122.437271950666	(37.7286006695825, -122.437271950666)
54394	54394	193368	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	262 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6013947.275280001	2116186.44855	37.79142884020779	-122.395631194149	(37.7914288402078, -122.395631194149)
54472	54472	230304	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3689 19th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6005034.41688	2104845.09352	37.7597884333033	-122.42566198362101	(37.7597884333033, -122.425661983621)
54895	54895	193335	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1260 Minnesota St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6015305.18557	2102619.11987	37.7542513973846	-122.389984647787	(37.7542513973846, -122.389984647787)
56993	56993	130971	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2801 Webster St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 2ft		6002947.99505	2118332.47012	37.7967032866916	-122.43384191568998	(37.7967032866916, -122.43384191569)
57463	57463	193356	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	60 Main St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6014000.33626	2116445.25726	37.7921424198756	-122.395465742269	(37.7921424198756, -122.395465742269)
57885	57885	230313	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	968 Hampshire St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6010194.52879	2103588.6082900004	37.756628635618604	-122.40772701540399	(37.7566286356186, -122.407727015404)
59160	59160	230296	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3500 19th St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6006123.351530001	2104947.42015	37.7601308699707	-122.421903157405	(37.7601308699707, -122.421903157405)
60313	60313	193334	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1258 Minnesota St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6015304.94166	2102636.75923	37.7542998178001	-122.38998672342	(37.7542998178001, -122.38998672342)
60673	60673	230347	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1801 Church St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004579.28935	2098353.48586	37.741938260334294	-122.42677374352199	(37.7419382603343, -122.426773743522)
62134	62134	96861	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	387 29th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/02/2011 12:00:00 AM	2	3x3	Permit Number 768142	5986826.57443	2113361.96386	37.7821276946473	-122.489259307913	(37.7821276946473, -122.489259307913)
63292	63292	177412	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	539 Moscow St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6003697.3420400005	2090030.0653	37.719034114214004	-122.42922986306401	(37.719034114214, -122.429229863064)
64180	64180	84410	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	745 10th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/04/2008 12:00:00 AM	2	3x3	Permit Number 51564	5992859.62349	2110370.66867	37.774264723280204	-122.468170197773	(37.7742647232802, -122.468170197773)
66770	66770	193362	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	246 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6014011.61838	2116245.86436	37.7915955610366	-122.39541273082399	(37.7915955610366, -122.395412730824)
68072	68072	250185	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	665 Parker Ave	2	: 4	Tree 1	Private 1			2	Width 4ft		5997218.614440001	2110901.95743	37.7759742867055	-122.453130096488	(37.7759742867055, -122.453130096488)
71813	71813	249952	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	303 Filbert St	3	Side Yard : Yard 17	Tree 1	Private 1			2	Width 0ft		6011371.46837	2120040.8031	37.801868351303796	-122.40481496294399	(37.8018683513038, -122.404814962944)
72299	72299	247777	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	240 30th St	1	: 4	Tree 1	Private 1			2	Width 3ft		6005014.994390001	2098457.52943	37.742248565111204	-122.42527461684799	(37.7422485651112, -122.425274616848)
72470	72470	130987	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1332 Bush St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6006981.766419999	2115388.7011599997	37.7888485036088	-122.419675148215	(37.7888485036088, -122.419675148215)
74024	74024	230292	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3500 19th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6006199.95177	2104950.54929	37.760143781519496	-122.42163845546499	(37.7601437815195, -122.421638455465)
74490	74490	230306	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	65 Oakwood St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6005267.4467	2105080.91438	37.7604491067472	-122.42487282493299	(37.7604491067472, -122.424872824933)
75357	75357	230307	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	316 San Carlos St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6006700.0483099995	2104252.32406	37.758254804122	-122.419859309575	(37.758254804122, -122.419859309575)
83616	83616	30531	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	100 20th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/02/1986 12:00:00 AM	2	3x3	Permit Number 34534	5989617.18715	2114630.7338900003	37.7857738797228	-122.479698023599	(37.7857738797228, -122.479698023599)
91260	91260	112553	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	35 DOLORES ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/28/2015 12:00:00 AM	2	3x3		6004913.0	2108042.0	37.7685595148495	-122.426309519551	(37.7685595148495, -122.426309519551)
97250	97250	96057	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	110 Lundy's Ln	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/03/2011 12:00:00 AM	2	3.5x6	Permit Number 767685	6006775.4	2098937.3	37.7436652048745	-122.419221689065	(37.7436652048745, -122.419221689065)
99368	99368	109089	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	218 28th Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		2	3x3		5987170.3	2114494.3	37.7852568239907	-122.488153421892	(37.7852568239907, -122.488153421892)
111710	111710	12532	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	120 Lake St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	6x7.4		5995061.5103400005	2114935.24706	37.7869247555074	-122.460884411661	(37.7869247555074, -122.460884411661)
112214	112214	230331	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	217 Montcalm St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 6ft		6009886.65194	2099610.71375	37.745688979177	-122.40851117835699	(37.745688979177, -122.408511178357)
126468	126468	105848	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	790 Tehama St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		6008900.0	2110136.0	37.774533709285706	-122.41266682187201	(37.7745337092857, -122.412666821872)
127114	127114	193361	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	246 Mission St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6014025.95999	2116259.22664	37.7916330483898	-122.39536404513599	(37.7916330483898, -122.395364045136)
129834	129834	208845	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	277 Granada Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5995629.339	2091829.15928	37.7235139565963	-122.457247722532	(37.7235139565963, -122.457247722532)
129880	129880	177446	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	323 Madrid St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6003320.62443	2091964.27953	37.7243237043587	-122.43066997803999	(37.7243237043587, -122.43066997804)
130198	130198	208841	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2134 09th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5993696.59277	2101147.8080700003	37.74898945599679	-122.46460515623001	(37.7489894559968, -122.46460515623)
131979	131979	230284	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1329 Florida St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009558.57595	2101226.99135	37.7501085417965	-122.409759687386	(37.7501085417965, -122.409759687386)
133388	133388	193370	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	262 Mission St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6013935.48002	2116174.11264	37.791394312559596	-122.39567114113001	(37.7913943125596, -122.39567114113)
134263	134263	193367	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	262 Mission St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6013957.97413	2116198.08841	37.791461395664896	-122.395594991931	(37.7914613956649, -122.395594991931)
134536	134536	193357	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	62 Main St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6014010.133090001	2116432.89008	37.7921090073852	-122.395430978058	(37.7921090073852, -122.395430978058)
135085	135085	246460	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	200 Duncan St	1	: 4	Tree 1	Private 1			2	Width 3ft		6005150.47679	2099924.83113	37.7462850938946	-122.42491052900299	(37.7462850938946, -122.424910529003)
136936	136936	120427	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	459 22nd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5989038.74655	2112201.43488	37.7790700882049	-122.481521260476	(37.7790700882049, -122.481521260476)
137932	137932	193330	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1258 Minnesota St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6015302.53629	2102695.98751	37.7544623126945	-122.389999179039	(37.7544623126945, -122.389999179039)
145807	145807	105847	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	790 Tehama St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		6008900.0	2110136.0	37.774533709285706	-122.41266682187201	(37.7745337092857, -122.412666821872)
146559	146559	208848	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	281 Lobos St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5994210.24416	2088699.7294	37.7148396860693	-122.46192642387501	(37.7148396860693, -122.461926423875)
147335	147335	95762	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	417 Moscow St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/07/2011 12:00:00 AM	2	3x3	Permit Number 767499	6004100.3891199995	2090668.84671	37.720810876907	-122.427882177716	(37.720810876907, -122.427882177716)
150941	150941	193359	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	208 Mission St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6014052.912819999	2116289.5789400004	37.7917178877279	-122.39527291503299	(37.7917178877279, -122.395272915033)
153633	153633	247755	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	52 Alpine Ter	1	: 4	Tree 1	Private 1			2	Width 3ft		6001613.95356	2108514.35375	37.7696694492075	-122.43775445760299	(37.7696694492075, -122.437754457603)
153672	153672	230305	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3689 19th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6005047.22841	2104845.66376	37.7597907229735	-122.42561771539499	(37.7597907229735, -122.425617715395)
156067	156067	193372	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	61 Beale St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6013792.54079	2116244.01793	37.791578303941705	-122.39617061288999	(37.7915783039417, -122.39617061289)
156468	156468	230290	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	59 Ramona Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6005216.74861	2107488.55744	37.76705705897071	-122.425219491113	(37.7670570589707, -122.425219491113)
156900	156900	102081	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	525 14th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/09/2009 12:00:00 AM	2	3x3	Permit Number 52509	5991566.610309999	2111852.8346	37.778259586012204	-122.472751014651	(37.7782595860122, -122.472751014651)
157233	157233	208838	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1450 16th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5991176.37038	2105519.1814900003	37.7608464875004	-122.47363884617799	(37.7608464875004, -122.473638846178)
158279	158279	124566	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3943 Sacramento St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 4ft		5995914.73243	2114852.9465900003	37.7867478376308	-122.457926519067	(37.7867478376308, -122.457926519067)
159964	159964	193358	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	62 Main St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6014021.3474	2116423.46881	37.79208376250261	-122.395391515812	(37.7920837625026, -122.395391515812)
160153	160153	193360	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	208 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6014042.14131	2116274.34783	37.7916754675957	-122.395309117238	(37.7916754675957, -122.395309117238)
161301	161301	230280	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	201 Webster St	3	: 4	Tree 1	Private 1			2	Width 3ft		6004189.92363	2109488.51079	37.772490383253896	-122.428913720795	(37.7724903832539, -122.428913720795)
161500	161500	230295	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3500 19th St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6006165.1210199995	2104950.71502	37.7601422724637	-122.42175893043199	(37.7601422724637, -122.421758930432)
161578	161578	230318	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	107 Valley St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		6005160.92225	2099293.15868	37.744551255839795	-122.424829478514	(37.7445512558398, -122.424829478514)
161633	161633	177444	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	15 Karen Ct	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6010486.61044	2091547.46792	37.7235826018289	-122.40586870937	(37.7235826018289, -122.40586870937)
161945	161945	109493	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1246 Bush St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		2			6007532.32765	2115464.28758	37.789087043373996	-122.417775637962	(37.789087043374, -122.417775637962)
161946	161946	193329	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1240 Minnesota St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6015301.017030001	2102739.65572	37.7545821320765	-122.390007483381	(37.7545821320765, -122.390007483381)
164978	164978	246941	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	269 Frederick St	1	: 4	Tree 1	Private 1			2	Width 3ft		5998752.122880001	2107600.5740099996	37.7669972990085	-122.447587610674	(37.7669972990085, -122.447587610674)
165212	165212	230294	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3500 19th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6006176.610669999	2104951.77673	37.760145835588006	-122.421719268545	(37.760145835588, -122.421719268545)
165271	165271	230308	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3795 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6005100.08631	2104263.85733	37.7581962060976	-122.42539350181801	(37.7581962060976, -122.425393501818)
165587	165587	208854	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	403 Baden St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6000738.2575199995	2095246.2380099997	37.7331885682037	-122.439832030035	(37.7331885682037, -122.439832030035)
165815	165815	230351	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	132 Moffitt St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6002667.4556599995	2096824.4771	37.737631676855294	-122.43327501094299	(37.7376316768553, -122.433275010943)
168503	168503	78302	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	575 35th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/17/2013 12:00:00 AM	2	3x3	Permit Number 770704	5985015.95011	2111950.61478	37.7781466811201	-122.49541903513	(37.7781466811201, -122.49541903513)
169196	169196	250186	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	665 Parker Ave	3	: 4	Tree 1	Private 1			2	Width 4ft		5997220.39466	2110886.1472400003	37.7759309780695	-122.4531227967	(37.7759309780695, -122.4531227967)
169527	169527	193363	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	246 Mission St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6014000.9996	2116238.17517	37.791573857707704	-122.39544893303801	(37.7915738577077, -122.395448933038)
169605	169605	193341	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1751 22nd St	6	Side Yard : Yard 17	Tree 1	Private 1			2	Width 4ft		6012847.48484	2103764.38864	37.757259446178104	-122.398564409431	(37.7572594461781, -122.398564409431)
171396	171396	123367	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	780 04th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5994765.802759999	2110367.1849	37.774365061862504	-122.461576171928	(37.7743650618625, -122.461576171928)
171677	171677	130989	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1000 Jones St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008668.89448	2116022.78913	37.790684447086605	-122.413882772283	(37.7906844470866, -122.413882772283)
172126	172126	193371	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	264 Mission St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6013926.2454699995	2116163.52102	37.791364716756	-122.395702350277	(37.791364716756, -122.395702350277)
174370	174370	71615	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	536 40th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/14/1995 12:00:00 AM	2			5983503.66193	2112151.1699	37.7786086821922	-122.500665338334	(37.7786086821922, -122.500665338334)
177901	177901	95101	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3601x Broderick St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/08/2008 12:00:00 AM	2			5999657.71874	2120941.08267	37.8036785786574	-122.445414641767	(37.8036785786574, -122.445414641767)
177912	177912	130966	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	99 Moulton St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6002966.56472	2119407.57255	37.7996562924699	-122.433854543963	(37.7996562924699, -122.433854543963)

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