Street_Tree_List

Data source: data.sfgov.org

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

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
12646	12646	115976	Planning Code 138.1 required 4	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2x Olmstead St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	3x3		6011653.53869	2091254.58415	37.7228435956385	-122.401814242757	(37.7228435956385, -122.401814242757)
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)
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)
26519	26519	115980	Planning Code 138.1 required 4	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2x Olmstead St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	3x3		6011593.71434	2091235.60939	37.722788156028706	-122.402019710862	(37.7227881560287, -122.402019710862)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
36033	36033	177437	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	93 Karen Ct	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6010115.68283	2091447.6223799998	37.72328769526371	-122.407143912081	(37.7232876952637, -122.407143912081)
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)
37487	37487	177439	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	79 Karen Ct	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6010188.86492	2091471.00105	37.7233559834822	-122.406892581232	(37.7233559834822, -122.406892581232)
37514	37514	193348	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2501 18th St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6010227.27367	2105486.95448	37.7618429003376	-122.407747622459	(37.7618429003376, -122.407747622459)
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)
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)
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)
40529	40529	230283	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	626 Potrero Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6010353.7895	2105370.3020900004	37.761529680867	-122.40730182853201	(37.761529680867, -122.407301828532)
41960	41960	177441	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	71 Karen Ct	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6010258.66598	2091491.8701799999	37.7234171913236	-122.406652760812	(37.7234171913236, -122.406652760812)
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)
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)
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)
45125	45125	193342	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	401 Texas St	4	: 4	Tree 1	Private 1			1	Width 3ft		6013812.69862	2105193.07398	37.7612360315304	-122.39532637971901	(37.7612360315304, -122.395326379719)
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)
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)
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)
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)
48794	48794	193328	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	900 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		6015574.56777	2102562.74505	37.7541115402303	-122.389049112743	(37.7541115402303, -122.389049112743)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)

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