Street_Tree_List

Data source: data.sfgov.org

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

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
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)
1185	1185	119832	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2						2110475.0	6005532.0	47.2700470263222	-138.279303834774	(47.2700470263222, -138.279303834774)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
1211	1211	119836	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	9	Median : Cutout 11	Tree 1	DPW 2						2110475.0	6005532.0	47.2700470263222	-138.279303834774	(47.2700470263222, -138.279303834774)
1212	1212	119828	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	1	Median : Cutout 11	Tree 1	DPW 2						2110475.0	6005532.0	47.2700470263222	-138.279303834774	(47.2700470263222, -138.279303834774)
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)
1219	1219	119829	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2						2110475.0	6005532.0	47.2700470263222	-138.279303834774	(47.2700470263222, -138.279303834774)
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)
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)
1226	1226	119830	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	3	Median : Cutout 11	Tree 1	DPW 2						2110475.0	6005532.0	47.2700470263222	-138.279303834774	(47.2700470263222, -138.279303834774)
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)
1228	1228	119831	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2						2110475.0	6005532.0	47.2700470263222	-138.279303834774	(47.2700470263222, -138.279303834774)
1230	1230	119834	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	7	Median : Cutout 11	Tree 1	DPW 2						2110475.0	6005532.0	47.2700470263222	-138.279303834774	(47.2700470263222, -138.279303834774)
1231	1231	119833	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	6	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)
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)
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)
84832	84832	119681	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2x Octavia St Frontage East	7	Median : Cutout 11	Tree 1	DPW 2						2109501.0	6005733.0	47.2700833275765	-138.283252028036	(47.2700833275765, -138.283252028036)
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)
85315	85315	119826	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	302x Octavia St Frontage East	10	Median : Cutout 11	Tree 1	DPW 2						2110484.0	6005595.0	47.27021880585	-138.279315979183	(47.27021880585, -138.279315979183)
85972	85972	119818	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	302x Octavia St Frontage East	2	Median : Cutout 11	Tree 1	DPW 2						2110484.0	6005595.0	47.27021880585	-138.279315979183	(47.27021880585, -138.279315979183)
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)
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)
91533	91533	119820	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	302x Octavia St Frontage East	4	Median : Cutout 11	Tree 1	DPW 2						2110484.0	6005595.0	47.27021880585	-138.279315979183	(47.27021880585, -138.279315979183)
92481	92481	119675	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2x Octavia St Frontage East	1	Median : Cutout 11	Tree 1	DPW 2						2109501.0	6005733.0	47.2700833275765	-138.283252028036	(47.2700833275765, -138.283252028036)
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)
93091	93091	119824	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	302x Octavia St Frontage East	8	Median : Cutout 11	Tree 1	DPW 2						2110484.0	6005595.0	47.27021880585	-138.279315979183	(47.27021880585, -138.279315979183)
93922	93922	119676	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2x Octavia St Frontage East	2	Median : Cutout 11	Tree 1	DPW 2						2109501.0	6005733.0	47.2700833275765	-138.283252028036	(47.2700833275765, -138.283252028036)
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)
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)
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)
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)
105805	105805	119677	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2x Octavia St Frontage East	3	Median : Cutout 11	Tree 1	DPW 2						2109501.0	6005733.0	47.2700833275765	-138.283252028036	(47.2700833275765, -138.283252028036)
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)
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)
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)
110275	110275	119680	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2x Octavia St Frontage East	6	Median : Cutout 11	Tree 1	DPW 2						2109501.0	6005733.0	47.2700833275765	-138.283252028036	(47.2700833275765, -138.283252028036)
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)
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)
113138	113138	119682	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2x Octavia St Frontage East	8	Median : Cutout 11	Tree 1	DPW 2						2109501.0	6005733.0	47.2700833275765	-138.283252028036	(47.2700833275765, -138.283252028036)
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)
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)
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)
122930	122930	119817	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	302x Octavia St Frontage East	1	Median : Cutout 11	Tree 1	DPW 2						2110484.0	6005595.0	47.27021880585	-138.279315979183	(47.27021880585, -138.279315979183)
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)
125886	125886	119679	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2x Octavia St Frontage East	5	Median : Cutout 11	Tree 1	DPW 2						2109501.0	6005733.0	47.2700833275765	-138.283252028036	(47.2700833275765, -138.283252028036)
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)
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)
128474	128474	119819	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	302x Octavia St Frontage East	3	Median : Cutout 11	Tree 1	DPW 2						2110484.0	6005595.0	47.27021880585	-138.279315979183	(47.27021880585, -138.279315979183)
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)
139301	139301	119823	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	302x Octavia St Frontage East	7	Median : Cutout 11	Tree 1	DPW 2						2110484.0	6005595.0	47.27021880585	-138.279315979183	(47.27021880585, -138.279315979183)
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)
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)
142143	142143	119825	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	302x Octavia St Frontage East	9	Median : Cutout 11	Tree 1	DPW 2						2110484.0	6005595.0	47.27021880585	-138.279315979183	(47.27021880585, -138.279315979183)
143889	143889	119821	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	302x Octavia St Frontage East	5	Median : Cutout 11	Tree 1	DPW 2						2110484.0	6005595.0	47.27021880585	-138.279315979183	(47.27021880585, -138.279315979183)
143969	143969	119822	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	302x Octavia St Frontage East	6	Median : Cutout 11	Tree 1	DPW 2						2110484.0	6005595.0	47.27021880585	-138.279315979183	(47.27021880585, -138.279315979183)
144605	144605	119782	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	202x Octavia St Frontage East	2	Median : Cutout 11	Tree 1	DPW 2						2110143.0	6005643.0	47.270172161735	-138.280681481725	(47.270172161735, -138.280681481725)
144933	144933	119701	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	6x Octavia St Frontage West	3	Median : Cutout 11	Tree 1	DPW 2						2109337.0	6005692.0	47.2698908128932	-138.283860688311	(47.2698908128932, -138.283860688311)
145037	145037	119787	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	202x Octavia St Frontage East	7	Median : Cutout 11	Tree 1	DPW 2						2110143.0	6005643.0	47.270172161735	-138.280681481725	(47.270172161735, -138.280681481725)
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)
146012	146012	119781	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	202x Octavia St Frontage East	1	Median : Cutout 11	Tree 1	DPW 2						2110143.0	6005643.0	47.270172161735	-138.280681481725	(47.270172161735, -138.280681481725)
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)
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)
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)
120892	120892	3749	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	934 Carolina St	3	Median : Cutout 11	Tree 1	DPW 2			3	18		6012421.507139799	2103592.6632765	37.756764184951	-122.40002555654199	(37.756764184951, -122.400025556542)
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)
78159	78159	109162	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	51x OCTAVIA ST	1	Median : Cutout 11	Tree 1	DPW 2			6	3x20		6005650.4	2109419.7	37.772384002649005	-122.42385688843399	(37.772384002649, -122.423856888434)
81045	81045	109169	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	6x Octavia St Frontage West	6	Median : Cutout 11	Tree 1	DPW 2				3x20		2109337.0	6005692.0	47.2698908128932	-138.283860688311	(47.2698908128932, -138.283860688311)
83700	83700	109168	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	6x Octavia St Frontage West	7	Median : Cutout 11	Tree 1	DPW 2				3x20		2109337.0	6005692.0	47.2698908128932	-138.283860688311	(47.2698908128932, -138.283860688311)
97204	97204	109171	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	6x Octavia St Frontage West	4	Median : Cutout 11	Tree 1	DPW 2				3x20		2109337.0	6005692.0	47.2698908128932	-138.283860688311	(47.2698908128932, -138.283860688311)
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)
99764	99764	109166	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	51x OCTAVIA ST	5	Median : Cutout 11	Tree 1	DPW 2				3x20		6005650.4	2109419.7	37.772384002649005	-122.42385688843399	(37.772384002649, -122.423856888434)
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)
121401	121401	109167	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	6x Octavia St Frontage West	8	Median : Cutout 11	Tree 1	DPW 2				3x20		2109337.0	6005692.0	47.2698908128932	-138.283860688311	(47.2698908128932, -138.283860688311)
126070	126070	109170	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	6x Octavia St Frontage West	5	Median : Cutout 11	Tree 1	DPW 2				3x20		2109337.0	6005692.0	47.2698908128932	-138.283860688311	(47.2698908128932, -138.283860688311)
143024	143024	109165	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	51x OCTAVIA ST	4	Median : Cutout 11	Tree 1	DPW 2				3x20		6005650.4	2109419.7	37.772384002649005	-122.42385688843399	(37.772384002649, -122.423856888434)
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)
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)
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)
27441	27441	244317	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005516.527000001	2110492.6418	37.775322482765205	-122.42439629699699	(37.7753224827652, -122.424396296997)
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)
29153	29153	244356	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	300x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005588.2934	2110426.5412	37.775145038872104	-122.424143338216	(37.7751450388721, -122.424143338216)

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