Street_Tree_List

Data source: data.sfgov.org

170 rows where qSiteInfo = 11 and qSpecies = 46 sorted by qAddress

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, qAddress, SiteOrder, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
22362	22362	244426	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	6	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		6005680.8792	2109772.4112	37.773354183173396	-122.423776541571	(37.7733541831734, -122.423776541571)
25504	25504	244422	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005691.1562	2109690.8797	37.773130897486205	-122.423735193743	(37.7731308974862, -122.423735193743)
34532	34532	244424	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005686.3603	2109729.9326	37.7732378565997	-122.42375456071301	(37.7732378565997, -122.423754560713)
62865	62865	244423	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	3	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005687.7306	2109711.4339	37.7731871409862	-122.423748505092	(37.7731871409862, -122.423748505092)
68449	68449	244328	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	8	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005669.917	2109835.444	37.7735266371926	-122.423818944241	(37.7735266371926, -122.423818944241)
69750	69750	244330	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	10	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005665.121	2109878.6077	37.7736448835433	-122.42383860414199	(37.7736448835433, -122.423838604142)
76593	76593	244327	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	7	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005673.3426	2109802.5573	37.773436531636	-122.42380475570499	(37.773436531636, -122.423804755705)
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)
149269	149269	244421	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	1	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005693.2117	2109673.0661	37.773082101669296	-122.423726816669	(37.7730821016693, -122.423726816669)
152904	152904	244425	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005682.2494	2109755.2828	37.7733072300695	-122.423770583723	(37.7733072300695, -122.423770583723)
157190	157190	244329	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	9	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005667.8615	2109858.0536	37.773588601656996	-122.423827662517	(37.773588601657, -122.423827662517)
1192	1192	119753	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	8	Median : Cutout 11	Tree 1	DPW 2						2109793.0	6005627.0	47.2699510709683	-138.28203408065	(47.2699510709683, -138.28203408065)
1196	1196	119750	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2						2109793.0	6005627.0	47.2699510709683	-138.28203408065	(47.2699510709683, -138.28203408065)
1202	1202	119754	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	9	Median : Cutout 11	Tree 1	DPW 2						2109793.0	6005627.0	47.2699510709683	-138.28203408065	(47.2699510709683, -138.28203408065)
1204	1204	119749	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2						2109793.0	6005627.0	47.2699510709683	-138.28203408065	(47.2699510709683, -138.28203408065)
1213	1213	119747	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2						2109793.0	6005627.0	47.2699510709683	-138.28203408065	(47.2699510709683, -138.28203408065)
1223	1223	119752	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	7	Median : Cutout 11	Tree 1	DPW 2						2109793.0	6005627.0	47.2699510709683	-138.28203408065	(47.2699510709683, -138.28203408065)
1227	1227	119736	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	1	Median : Cutout 11	Tree 1	DPW 2						2109793.0	6005627.0	47.2699510709683	-138.28203408065	(47.2699510709683, -138.28203408065)
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)
1234	1234	119748	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	3	Median : Cutout 11	Tree 1	DPW 2						2109793.0	6005627.0	47.2699510709683	-138.28203408065	(47.2699510709683, -138.28203408065)
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)
28574	28574	244375	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005617.5038	2109823.1115	37.773489816144796	-122.423999372272	(37.7734898161448, -122.423999372272)
45981	45981	244376	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	6	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005617.5038	2109799.1317	37.7734239734056	-122.423997666684	(37.7734239734056, -122.423997666684)
56950	56950	244345	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005607.2268	2109894.3659	37.773684883292105	-122.424039990106	(37.7736848832921, -122.424039990106)
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)
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)
73396	73396	244466	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	10	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005631.2066	2109707.3231	37.7731726627699	-122.423943736898	(37.7731726627699, -122.423943736898)
129691	129691	244344	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	1	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005605.8565	2109917.6606	37.773748767543104	-122.424046387097	(37.7737487675431, -122.424046387097)
155187	155187	244456	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	8	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005624.3552	2109760.7639	37.773319011501705	-122.42397123777799	(37.7733190115017, -122.423971237778)
161664	161664	244455	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	7	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005622.2998	2109777.2072	37.7733640447919	-122.423979517231	(37.7733640447919, -122.423979517231)
174364	174364	244465	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	9	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005629.1512	2109732.6732	37.773242151986	-122.423952649806	(37.773242151986, -122.423952649806)
176821	176821	244373	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	3	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005612.0227	2109867.6455	37.7736117862994	-122.424021499783	(37.7736117862994, -122.424021499783)
187415	187415	244374	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005614.0781	2109847.0914	37.7735554657504	-122.42401292788901	(37.7735554657504, -122.424012927889)
91459	91459	119712	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	102x Octavia St Frontage East	5	Median : Cutout 11	Tree 1	DPW 2						2109802.0	6005691.0	47.2701255040516	-138.282046982267	(47.2701255040516, -138.282046982267)
101446	101446	119713	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	102x Octavia St Frontage East	6	Median : Cutout 11	Tree 1	DPW 2						2109802.0	6005691.0	47.2701255040516	-138.282046982267	(47.2701255040516, -138.282046982267)
103389	103389	119708	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	102x Octavia St Frontage East	1	Median : Cutout 11	Tree 1	DPW 2						2109802.0	6005691.0	47.2701255040516	-138.282046982267	(47.2701255040516, -138.282046982267)
108290	108290	119716	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	102x Octavia St Frontage East	9	Median : Cutout 11	Tree 1	DPW 2						2109802.0	6005691.0	47.2701255040516	-138.282046982267	(47.2701255040516, -138.282046982267)
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)
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)
124457	124457	119717	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	102x Octavia St Frontage East	10	Median : Cutout 11	Tree 1	DPW 2						2109802.0	6005691.0	47.2701255040516	-138.282046982267	(47.2701255040516, -138.282046982267)
128093	128093	119709	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	102x Octavia St Frontage East	2	Median : Cutout 11	Tree 1	DPW 2						2109802.0	6005691.0	47.2701255040516	-138.282046982267	(47.2701255040516, -138.282046982267)
128531	128531	119710	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	102x Octavia St Frontage East	3	Median : Cutout 11	Tree 1	DPW 2						2109802.0	6005691.0	47.2701255040516	-138.282046982267	(47.2701255040516, -138.282046982267)
141876	141876	119711	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	102x Octavia St Frontage East	4	Median : Cutout 11	Tree 1	DPW 2						2109802.0	6005691.0	47.2701255040516	-138.282046982267	(47.2701255040516, -138.282046982267)
145232	145232	119714	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	102x Octavia St Frontage East	7	Median : Cutout 11	Tree 1	DPW 2						2109802.0	6005691.0	47.2701255040516	-138.282046982267	(47.2701255040516, -138.282046982267)
99951	99951	119755	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	106x Octavia St Frontage West	10	Median : Cutout 11	Tree 1	DPW 2						2109793.0	6005627.0	47.2699510709683	-138.28203408065	(47.2699510709683, -138.28203408065)
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)
14093	14093	97435	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1300x Newcomb Ave	4	Median : Cutout 11	Tree 1	DPW 2		09/30/2011 12:00:00 AM	3			6016490.8874	2094837.7533	37.732951043415206	-122.385341956131	(37.7329510434152, -122.385341956131)
43571	43571	200600	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1300x Newcomb Ave	6	Median : Cutout 11	Tree 1	DPW 2			1	Width 0ft		6016471.5892	2094834.3971	37.7329407602926	-122.385408441845	(37.7329407602926, -122.385408441845)
46120	46120	200598	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1300x Newcomb Ave	3	Median : Cutout 11	Tree 1	DPW 2			1	Width 0ft		6016502.2145	2094839.4314	37.732956277793896	-122.385302911931	(37.7329562777939, -122.385302911931)
59826	59826	200635	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1300x Newcomb Ave	9	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6016404.4653	2094836.0752	37.7329416541175	-122.385640625637	(37.7329416541175, -122.385640625637)
173743	173743	200597	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1300x Newcomb Ave	2	Median : Cutout 11	Tree 1	DPW 2			1	Width 0ft		6016514.3807	2094844.0461	37.732969621897794	-122.38526117126301	(37.7329696218978, -122.385261171263)
188835	188835	200601	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1300x Newcomb Ave	7	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6016439.2859	2094833.5580000002	37.7329366690371	-122.385520065311	(37.7329366690371, -122.385520065311)
13974	13974	97229	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1301X Newcomb Ave	9	Median : Cutout 11	Tree 1	DPW 2			28	15x200		6016636.9425099995	2094930.8404400002	37.7332147213866	-122.38484348356701	(37.7332147213866, -122.384843483567)
15023	15023	97221	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1301X Newcomb Ave	1	Median : Cutout 11	Tree 1	DPW 2			5	15x200		6016689.53805	2094986.8063299998	37.733371301443	-122.38466554190701	(37.733371301443, -122.384665541907)
16597	16597	97225	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1301X Newcomb Ave	5	Median : Cutout 11	Tree 1	DPW 2		09/30/2011 12:00:00 AM	3	15x200		6016649.85073	2094946.9135099999	37.7332595687675	-122.38479997523599	(37.7332595687675, -122.384799975236)
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)
141737	141737	97434		Ulmus parvifolia :: Chinese Elm 46	1380x Newcomb Ave	5	Median : Cutout 11	Tree 1	DPW 2		09/30/2011 12:00:00 AM	3			6016360.63733	2094893.94179	37.7330981190079	-122.38579618360501	(37.7330981190079, -122.385796183605)
36550	36550	18546	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1700X Quesada Ave	1	Median : Cutout 11	Tree 1	DPW 2			9	19		6014682.66084	2095048.92479	37.7334306737717	-122.391608273909	(37.7334306737717, -122.391608273909)
32047	32047	244254	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	1	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005646.3317	2110018.1063	37.774026852262104	-122.423913520847	(37.7740268522621, -122.423913520847)
33227	33227	244397	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	8	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		6005625.7095	2110167.0444	37.7744346360097	-122.423995450078	(37.7744346360097, -122.423995450078)
38215	38215	244396	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	7	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		6005626.4733	2110143.3671	37.7743696669954	-122.42399112385799	(37.7743696669954, -122.423991123858)
51603	51603	244259	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	6	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005631.8198	2110120.4535	37.7743070536408	-122.423970999545	(37.7743070536408, -122.423970999545)
69418	69418	244398	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	9	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		6005622.6544	2110184.6115	37.7744826985313	-122.42400726776	(37.7744826985313, -122.42400726776)
132653	132653	244258	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005634.1112	2110100.5951	37.7742526566427	-122.42396166072399	(37.7742526566427, -122.423961660724)
147182	147182	244399	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	10	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005618.8355	2110208.2889	37.7745474953334	-122.424022162207	(37.7745474953334, -122.424022162207)
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)
156415	156415	244257	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005636.4025	2110083.7918	37.7742066482035	-122.42395253955699	(37.7742066482035, -122.423952539557)
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)
173527	173527	244256	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	3	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005639.4577	2110060.8783	37.7741439057581	-122.423940341347	(37.7741439057581, -122.423940341347)
186972	186972	244255	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005643.2766	2110040.2561	37.7740874977816	-122.423925664351	(37.7740874977816, -122.423925664351)
1183	1183	119797	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2						2110122.0	6005581.0	47.2699969117914	-138.280716869623	(47.2699969117914, -138.280716869623)
1187	1187	119794	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2						2110122.0	6005581.0	47.2699969117914	-138.280716869623	(47.2699969117914, -138.280716869623)
1189	1189	119798	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	6	Median : Cutout 11	Tree 1	DPW 2						2110122.0	6005581.0	47.2699969117914	-138.280716869623	(47.2699969117914, -138.280716869623)
1194	1194	119795	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	3	Median : Cutout 11	Tree 1	DPW 2						2110122.0	6005581.0	47.2699969117914	-138.280716869623	(47.2699969117914, -138.280716869623)
1199	1199	119799	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	7	Median : Cutout 11	Tree 1	DPW 2						2110122.0	6005581.0	47.2699969117914	-138.280716869623	(47.2699969117914, -138.280716869623)
1203	1203	119796	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2						2110122.0	6005581.0	47.2699969117914	-138.280716869623	(47.2699969117914, -138.280716869623)
1206	1206	119801	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	9	Median : Cutout 11	Tree 1	DPW 2						2110122.0	6005581.0	47.2699969117914	-138.280716869623	(47.2699969117914, -138.280716869623)
1207	1207	119793	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	1	Median : Cutout 11	Tree 1	DPW 2						2110122.0	6005581.0	47.2699969117914	-138.280716869623	(47.2699969117914, -138.280716869623)
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)
1209	1209	119800	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	8	Median : Cutout 11	Tree 1	DPW 2						2110122.0	6005581.0	47.2699969117914	-138.280716869623	(47.2699969117914, -138.280716869623)
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)
29250	29250	244237	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005569.1894	2110157.879	37.774406278899995	-122.42419031206998	(37.7744062789, -122.42419031207)
52888	52888	244411	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2			1	Width 0ft		6005560.024	2110238.8403	37.7746280615118	-122.424227776164	(37.7746280615118, -122.424227776164)
62806	62806	244235	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	3	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005565.3705	2110205.2337	37.774536087812	-122.424206890938	(37.774536087812, -122.424206890938)
67382	67382	244287	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	10	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005585.9927	2110033.3819999998	37.7740653890161	-122.424123330561	(37.7740653890161, -122.424123330561)
77107	77107	244284	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	9	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005583.7013	2110055.5318	37.774126077633206	-122.42413283246701	(37.7741260776332, -122.424132832467)
138143	138143	244478	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	7	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005577.5911	2110096.7762	37.7742389797832	-122.424156902562	(37.7742389797832, -122.424156902562)
149777	149777	244283	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	8	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005579.1186	2110077.6816	37.7741866368779	-122.424150260413	(37.7741866368779, -122.424150260413)
158186	158186	244477	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	6	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005574.5359	2110115.107	37.77428913922	-122.424168774988	(37.77428913922, -122.424168774988)
161575	161575	244236	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005567.6618	2110181.5564	37.774471205054496	-122.42419728060601	(37.7744712050545, -122.424197280606)
162148	162148	244410	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	1	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005558.4964	2110254.116	37.7746699186287	-122.424234147092	(37.7746699186287, -122.424234147092)
84934	84934	119788	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	202x Octavia St Frontage East	8	Median : Cutout 11	Tree 1	DPW 2						2110143.0	6005643.0	47.270172161735	-138.280681481725	(47.270172161735, -138.280681481725)
87810	87810	119785	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	202x Octavia St Frontage East	5	Median : Cutout 11	Tree 1	DPW 2						2110143.0	6005643.0	47.270172161735	-138.280681481725	(47.270172161735, -138.280681481725)
96137	96137	119790	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	202x Octavia St Frontage East	10	Median : Cutout 11	Tree 1	DPW 2						2110143.0	6005643.0	47.270172161735	-138.280681481725	(47.270172161735, -138.280681481725)
100873	100873	119784	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	202x Octavia St Frontage East	4	Median : Cutout 11	Tree 1	DPW 2						2110143.0	6005643.0	47.270172161735	-138.280681481725	(47.270172161735, -138.280681481725)
107228	107228	119786	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	202x Octavia St Frontage East	6	Median : Cutout 11	Tree 1	DPW 2						2110143.0	6005643.0	47.270172161735	-138.280681481725	(47.270172161735, -138.280681481725)
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)
112254	112254	119783	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	202x Octavia St Frontage East	3	Median : Cutout 11	Tree 1	DPW 2						2110143.0	6005643.0	47.270172161735	-138.280681481725	(47.270172161735, -138.280681481725)
118324	118324	119789	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	202x Octavia St Frontage East	9	Median : Cutout 11	Tree 1	DPW 2						2110143.0	6005643.0	47.270172161735	-138.280681481725	(47.270172161735, -138.280681481725)
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)

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