Street_Tree_List

Data source: data.sfgov.org

2,323 rows where qSpecies = 46 sorted by SiteOrder descending

Search:

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

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

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder ▲	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
182744	182744	242401	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1201 San Jose Ave	35	Front Yard : Yard 7	Tree 1	Private 1			3			6004422.12829	2096026.22682	37.7355392485419	-122.427151426394	(37.7355392485419, -122.427151426394)
176511	176511	242400	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1201 San Jose Ave	34	Front Yard : Yard 7	Tree 1	Private 1			5			6004412.57648	2096019.13863	37.7355192458083	-122.427183945908	(37.7355192458083, -122.427183945908)
72683	72683	137053	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	900 Green St	28	Front Yard : Yard 7	Tree 1	Private 1			8			6008580.77711	2119003.85777	37.7988647784329	-122.414398677364	(37.7988647784329, -122.414398677364)
178916	178916	198666	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1670 Owen St	27	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 8ft		6013864.8595	2107478.20715	37.7675134055349	-122.39530605864901	(37.7675134055349, -122.395306058649)
169845	169845	198665	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1670 Owen St	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 8ft		6013878.81115	2107466.84131	37.767482973376396	-122.395257005115	(37.7674829733764, -122.395257005115)
132426	132426	198664	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1670 Owen St	23	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 8ft		6013893.51882	2107448.48806	37.7674333973606	-122.39520484712	(37.7674333973606, -122.39520484712)
100034	100034	97852	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	900 Minnesota St	21	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						6015215.2	2103967.9	37.757949869225	-122.39039007649099	(37.757949869225, -122.390390076491)
169909	169909	198663	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1670 Owen St	21	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 8ft		6013906.856240001	2107433.3805400003	37.7673926571763	-122.395157656112	(37.7673926571763, -122.395157656112)
82060	82060	97851	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	900 Minnesota St	20	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						6015215.2	2103967.9	37.757949869225	-122.39039007649099	(37.757949869225, -122.390390076491)
166998	166998	198452	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	500 Mariposa St	20	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 6ft		6015213.79848	2106277.63642	37.7642918298343	-122.390556317147	(37.7642918298343, -122.390556317147)
41617	41617	198662	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1670 Owen St	19	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 8ft		6013921.99886	2107418.77263	37.767353389178204	-122.395104256175	(37.7673533891782, -122.395104256175)
85459	85459	97850	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	900 Minnesota St	19	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						6015215.2	2103967.9	37.757949869225	-122.39039007649099	(37.757949869225, -122.390390076491)
151556	151556	198451	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	500 Mariposa St	19	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 6ft		6015235.48199	2106278.14685	37.764294434263704	-122.390481355047	(37.7642944342637, -122.390481355047)
62501	62501	198450	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	500 Mariposa St	18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 6ft		6015258.23224	2106279.65666	37.7642998419001	-122.390402773191	(37.7642998419001, -122.390402773191)
141852	141852	97849	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	900 Minnesota St	18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						6015215.2	2103967.9	37.757949869225	-122.39039007649099	(37.757949869225, -122.390390076491)
25133	25133	198661	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1670 Owen St	17	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 8ft		6013934.2668	2107404.04412	37.7673136301584	-122.39506079103	(37.7673136301584, -122.39506079103)
50386	50386	198449	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	500 Mariposa St	17	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 6ft		6015277.30133	2106281.40363	37.764305696480896	-122.39033694009599	(37.7643056964809, -122.390336940096)
96743	96743	97848	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	900 Minnesota St	17	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						6015215.2	2103967.9	37.757949869225	-122.39039007649099	(37.757949869225, -122.390390076491)
10729	10729	17592	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			50	3x3		6003646.11767	2090408.41073	37.7200700675728	-122.42943389227699	(37.7200700675728, -122.429433892277)
77339	77339	198448	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	500 Mariposa St	16	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 6ft		6015301.86752	2106280.10819	37.764303502138794	-122.390251881336	(37.7643035021388, -122.390251881336)
120594	120594	97847	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	900 Minnesota St	16	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						6015215.2	2103967.9	37.757949869225	-122.39039007649099	(37.757949869225, -122.390390076491)
11996	11996	17591	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	15	Sidewalk: Property side : Cutout 5	Tree 1	DPW 2			30	3x3		6003659.63671	2090407.2266799998	37.7200675818369	-122.42938707716299	(37.7200675818369, -122.429387077163)
25485	25485	198641	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	419 Mission Bay Blvd North	15	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			6015975.52657	2108754.29642	37.7711344286414	-122.388094538146	(37.7711344286414, -122.388094538146)
59621	59621	138397	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	2445 PINE ST	15	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6002370.6113	2115041.6133	37.787634661222604	-122.43560424075301	(37.7876346612226, -122.435604240753)
61396	61396	198447	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	500 Mariposa St	15	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 6ft		6015324.46824	2106281.29518	37.7643080149349	-122.390173794086	(37.7643080149349, -122.390173794086)
81580	81580	97846	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	900 Minnesota St	15	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/24/2015 12:00:00 AM	3		Permit Number 775024	6015215.2	2103967.9	37.757949869225	-122.39039007649099	(37.757949869225, -122.390390076491)
114063	114063	16452	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1395 Newcomb Ave	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/01/2000 12:00:00 AM	3	3x3		6016285.996927	2094866.0167389999	37.733017311739104	-122.386052291775	(37.7330173117391, -122.386052291775)
126170	126170	198626	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	454 Mission Bay Blvd South	15	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			6015680.34741	2108616.56793	37.770739897870605	-122.38910596427601	(37.7707398978706, -122.389105964276)
186900	186900	198660	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1670 Owen St	15	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 8ft		6013952.391369999	2107385.9793599998	37.767265036187204	-122.39499683484101	(37.7672650361872, -122.394996834841)
10554	10554	17590	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			30	3x3		6003668.70994	2090393.5126599998	37.720030439842	-122.429354736658	(37.720030439842, -122.429354736658)
67701	67701	198625	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	454 Mission Bay Blvd South	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			6015702.76358	2108617.6361	37.770744073418896	-122.38902850026001	(37.7707440734189, -122.38902850026)
72973	72973	198446	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	500 Mariposa St	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 6ft		6015345.15707	2106282.1860700003	37.7643116086136	-122.39010229888399	(37.7643116086136, -122.390102298884)
86501	86501	16431	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1390X Newcomb Ave	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			10	3x3		6016292.5361	2094929.44377	37.7331918315913	-122.386034103828	(37.7331918315913, -122.386034103828)
110613	110613	97845	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	900 Minnesota St	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						6015215.2	2103967.9	37.757949869225	-122.39039007649099	(37.757949869225, -122.390390076491)
115097	115097	97234	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1380X Newcomb Ave	14	Median : Cutout 11	Tree 1	DPW 2			8	15x200		6016360.63733	2094893.94179	37.7330981190079	-122.38579618360501	(37.7330981190079, -122.385796183605)
163940	163940	198640	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	419 Mission Bay Blvd North	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6			6015953.105690001	2108752.97494	37.771129557912204	-122.388172001232	(37.7711295579122, -122.388172001232)
183804	183804	198502	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	900x Carolina St	14	Median : Yard 3	Tree 1	DPW 2			9			6012462.6007	2103568.62023	37.75670045906929	-122.399881750743	(37.7567004590693, -122.399881750743)
11319	11319	17589	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	13	Sidewalk: Property side : Cutout 5	Tree 1	DPW 2			18	3x3		6003683.23846	2090394.91559	37.720035114503006	-122.42930461652	(37.720035114503, -122.42930461652)
15940	15940	97233	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1300X Newcomb Ave	13	Median : Cutout 11	Tree 1	DPW 2			6	15x200		6016357.8982	2094854.1147	37.7329886101989	-122.385802878589	(37.7329886101989, -122.385802878589)
28275	28275	198639	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	419 Mission Bay Blvd North	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			6015936.8101699995	2108752.54325	37.7711274696967	-122.38822833839	(37.7711274696967, -122.38822833839)
30111	30111	198501	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	900x Carolina St	13	Median : Yard 3	Tree 1	DPW 2			15			6012463.03254	2103576.30053	37.7567215715659	-122.399880796574	(37.7567215715659, -122.399880796574)
65548	65548	100582	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	900 Folsom St	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						6011458.7	2112074.6	37.7799999312698	-122.403952182873	(37.7799999312698, -122.403952182873)
98160	98160	100626	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	900 Folsom St	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						6011458.7	2112074.6	37.7799999312698	-122.403952182873	(37.7799999312698, -122.403952182873)
102056	102056	16430	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1390X Newcomb Ave	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6016278.2308330005	2094877.1898669999	37.733047561100896	-122.386079920066	(37.7330475611009, -122.386079920066)
123489	123489	198445	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	500 Mariposa St	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 6ft		6015364.886609999	2106281.79771	37.764311636502704	-122.39003403224702	(37.7643116365027, -122.390034032247)
139312	139312	97844	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	900 Minnesota St	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						6015215.2	2103967.9	37.757949869225	-122.39039007649099	(37.757949869225, -122.390390076491)
161482	161482	198659	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1670 Owen St	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 8ft		6013968.57822	2107369.74118	37.7672213498189	-122.39493970902001	(37.7672213498189, -122.39493970902)
177478	177478	198624	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	454 Mission Bay Blvd South	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			6015725.44924	2108619.45871	37.7707503353808	-122.38895015673701	(37.7707503353808, -122.388950156737)
1201	1201	119839	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	12	Median : Cutout 11	Tree 1	DPW 2						2110475.0	6005532.0	47.2700470263222	-138.279303834774	(47.2700470263222, -138.279303834774)
1233	1233	119757	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	12	Median : Cutout 11	Tree 1	DPW 2						2109793.0	6005627.0	47.2699510709683	-138.28203408065	(47.2699510709683, -138.28203408065)
12573	12573	17588	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			30	3x3		6003687.80932	2090380.0219599998	37.7199944786431	-122.429287755146	(37.7199944786431, -122.429287755146)
40192	40192	246545	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1x Octavia St	12	Median : Yard 3	Tree 1	DPW 2			8	Width 8ft		6005664.26886	2109539.08097	37.7727125769595	-122.423817404855	(37.7727125769595, -122.423817404855)
42949	42949	244310	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	300x Octavia St	12	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005563.2696	2110605.957	37.77563625821271	-122.424242664251	(37.7756362582127, -122.424242664251)
46975	46975	198638	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	419 Mission Bay Blvd North	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			6015910.558069999	2108750.53892	37.7711205116333	-122.388319006239	(37.7711205116333, -122.388319006239)
48814	48814	198592	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	980 16th St	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 4ft		6013452.45897	2107129.35079	37.766532578853	-122.396708048633	(37.766532578853, -122.396708048633)
56778	56778	198623	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	454 Mission Bay Blvd South	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			6015749.91564	2108621.24573	37.7707565982691	-122.38886565105	(37.7707565982691, -122.38886565105)
66611	66611	244468	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	12	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005635.3174	2109670.3256	37.7730713086411	-122.423926885709	(37.7730713086411, -122.423926885709)
95172	95172	100581	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	900 Folsom St	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						6011458.7	2112074.6	37.7799999312698	-122.403952182873	(37.7799999312698, -122.403952182873)
110953	110953	119719	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	102x Octavia St Frontage East	12	Median : Cutout 11	Tree 1	DPW 2						2109802.0	6005691.0	47.2701255040516	-138.282046982267	(47.2701255040516, -138.282046982267)
116938	116938	109163	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	6x Octavia St Frontage West	12	Median : Cutout 11	Tree 1	DPW 2				3x20		2109337.0	6005692.0	47.2698908128932	-138.283860688311	(47.2698908128932, -138.283860688311)
120847	120847	100625	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	900 Folsom St	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						6011458.7	2112074.6	37.7799999312698	-122.403952182873	(37.7799999312698, -122.403952182873)
122435	122435	119792	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	202x Octavia St Frontage East	12	Median : Cutout 11	Tree 1	DPW 2						2110143.0	6005643.0	47.270172161735	-138.280681481725	(47.270172161735, -138.280681481725)
122887	122887	16449	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1395 Newcomb Ave	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/20/2008 12:00:00 AM	12	3x3		6016285.996927	2094866.0167389999	37.733017311739104	-122.386052291775	(37.7330173117391, -122.386052291775)
127815	127815	119816	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	302x Octavia St Frontage East	12	Median : Cutout 11	Tree 1	DPW 2						2110484.0	6005595.0	47.27021880585	-138.279315979183	(47.27021880585, -138.279315979183)
131321	131321	138394	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	2445 PINE ST	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6002278.9059	2115030.4127	37.7875986981409	-122.435920721296	(37.7875986981409, -122.435920721296)
159657	159657	198444	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	500 Mariposa St	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 6ft		6015385.264330001	2106283.84094	37.7643183769187	-122.38996369358802	(37.7643183769187, -122.389963693588)
164108	164108	244401	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	12	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005612.7252	2110260.2263	37.7746897578806	-122.424046993197	(37.7746897578806, -122.424046993197)
168860	168860	97843	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	900 Minnesota St	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18			6015209.9181699995	2104379.39414	37.7590794509666	-122.39043709491399	(37.7590794509666, -122.390437094914)
172502	172502	242403	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1201 Treat Ave	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 4ft		6008707.95248	2101269.88955	37.75017862504279	-122.412704235035	(37.7501786250428, -122.412704235035)
1191	1191	119838	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	11	Median : Cutout 11	Tree 1	DPW 2						2110475.0	6005532.0	47.2700470263222	-138.279303834774	(47.2700470263222, -138.279303834774)
1208	1208	119803	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	11	Median : Cutout 11	Tree 1	DPW 2						2110122.0	6005581.0	47.2699969117914	-138.280716869623	(47.2699969117914, -138.280716869623)
1235	1235	119756	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	11	Median : Cutout 11	Tree 1	DPW 2						2109793.0	6005627.0	47.2699510709683	-138.28203408065	(47.2699510709683, -138.28203408065)
12852	12852	17587	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	11	Sidewalk: Property side : Cutout 5	Tree 1	DPW 2			35	3X3		6003703.481380001	2090378.19842	37.7199903588363	-122.42923345225901	(37.7199903588363, -122.429233452259)
25458	25458	244288	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	11	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005589.8116	2110006.6495	37.7739922036556	-122.42410821881201	(37.7739922036556, -122.424108218812)
52763	52763	198591	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	980 16th St	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 4ft		6013476.96853	2107132.95858	37.766543849139204	-122.39662352676399	(37.7665438491392, -122.396623526764)
55243	55243	244309	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	300x Octavia St	11	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005567.5189	2110582.8218	37.7755729745028	-122.42422631910499	(37.7755729745028, -122.424226319105)
56268	56268	16448	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1395 Newcomb Ave	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/20/2008 12:00:00 AM	12	3x3		6016285.996927	2094866.0167389999	37.733017311739104	-122.386052291775	(37.7330173117391, -122.386052291775)
68766	68766	244467	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	11	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005631.8918	2109690.1946	37.7731256707262	-122.423940148458	(37.7731256707262, -122.423940148458)
69759	69759	244364	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	11	Median : Cutout 11	Tree 1	DPW 2			8	Width 0ft		6005534.4686	2110345.8041	37.774920315184396	-122.424323786781	(37.7749203151844, -122.424323786781)
73680	73680	198611	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	456 Mission Bay Blvd South	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8			6016143.32489	2108643.38282	37.7708391794209	-122.38750637344101	(37.7708391794209, -122.387506373441)
78899	78899	100580	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	900 Folsom St	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						6011458.7	2112074.6	37.7799999312698	-122.403952182873	(37.7799999312698, -122.403952182873)
79474	79474	16428	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1390X Newcomb Ave	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6016278.2308330005	2094877.1898669999	37.733047561100896	-122.386079920066	(37.7330475611009, -122.386079920066)
92952	92952	119827	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	302x Octavia St Frontage East	11	Median : Cutout 11	Tree 1	DPW 2						2110484.0	6005595.0	47.27021880585	-138.279315979183	(47.27021880585, -138.279315979183)
99403	99403	109164	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	6x Octavia St Frontage West	11	Median : Cutout 11	Tree 1	DPW 2				3x20		2109337.0	6005692.0	47.2698908128932	-138.283860688311	(47.2698908128932, -138.283860688311)
108319	108319	119791	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	202x Octavia St Frontage East	11	Median : Cutout 11	Tree 1	DPW 2						2110143.0	6005643.0	47.270172161735	-138.280681481725	(47.270172161735, -138.280681481725)
122353	122353	119718	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	102x Octavia St Frontage East	11	Median : Cutout 11	Tree 1	DPW 2						2109802.0	6005691.0	47.2701255040516	-138.282046982267	(47.2701255040516, -138.282046982267)
129866	129866	138393	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	2445 PINE ST	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6002260.0048	2115027.6125	37.7875899357719	-122.43598591483101	(37.7875899357719, -122.435985914831)
136512	136512	244331	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	11	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005661.6953	2109906.0133	37.7737199393103	-122.423852403284	(37.7737199393103, -122.423852403284)
145979	145979	100624	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	900 Folsom St	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						6011458.7	2112074.6	37.7799999312698	-122.403952182873	(37.7799999312698, -122.403952182873)
148333	148333	198443	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	500 Mariposa St	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 6ft		6015407.0439	2106284.7052599997	37.7643219580036	-122.38988842391501	(37.7643219580036, -122.389888423915)
151969	151969	246544	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1x Octavia St	11	Median : Yard 3	Tree 1	DPW 2			4	Width 8ft		6005666.89387	2109521.5509099998	37.7726645918273	-122.42380707793998	(37.7726645918273, -122.42380707794)
153528	153528	198652	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	421 Mission Bay Blvd North	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8			6016352.81609	2108774.30794	37.771210272076104	-122.38679086381501	(37.7712102720761, -122.386790863815)
155394	155394	244400	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	11	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005615.7803	2110234.2576	37.774618626605296	-122.42403457786301	(37.7746186266053, -122.424034577863)
157554	157554	198658	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1670 Owen St	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 8ft		6013985.93072	2107349.0106	37.767165393099205	-122.39487823676001	(37.7671653930992, -122.39487823676)
164022	164022	97842	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	900 Minnesota St	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14			6015209.65715	2104398.1625200002	37.7591309704315	-122.390439309039	(37.7591309704315, -122.390439309039)
169733	169733	198637	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	419 Mission Bay Blvd North	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4			6015891.9528	2108749.14049	37.7711156409024	-122.388383265478	(37.7711156409024, -122.388383265478)
183346	183346	198622	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	454 Mission Bay Blvd South	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4			6015766.21634	2108621.9300599997	37.7707593807704	-122.388809313913	(37.7707593807704, -122.388809313913)
1222	1222	119837	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	10	Median : Cutout 11	Tree 1	DPW 2						2110475.0	6005532.0	47.2700470263222	-138.279303834774	(47.2700470263222, -138.279303834774)
11095	11095	17586	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6003709.25966	2090367.0753099998	37.7199601443381	-122.42921268601499	(37.7199601443381, -122.429212686015)
28480	28480	198590	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	980 16th St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 4ft		6013501.44813	2107135.10099	37.766551094088996	-122.39653900576599	(37.766551094089, -122.396539005766)

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