Street_Tree_List

Data source: data.sfgov.org

559 rows where qLegalStatus = 3 and qSpecies = 46 sorted by DBH

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: SiteOrder, PlotSize, PermitNotes

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)
22840	22840	251107	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1700X Quesada Ave	1	Median : Yard 3	Tree 1	DPW 2
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)
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)
85133	85133	104447	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2490X Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2	Rec/Park 7			3x3		6008214.39649	2104163.7525299997	37.7580968032353	-122.41461574816002	(37.7580968032353, -122.41461574816)
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)
87248	87248	104450	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2490X Folsom St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2	Rec/Park 7			3x3		6008214.39649	2104163.7525299997	37.7580968032353	-122.41461574816002	(37.7580968032353, -122.41461574816)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
219	219	138804	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2375 PINE ST	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			1	Width 0ft		6002587.4194	2115073.5588	37.787734687268795	-122.43485641346001	(37.7877346872688, -122.43485641346)
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)
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)
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)
17323	17323	7553	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2896 Folsom St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			2	3X3		6008325.6957	2101595.54831	37.751051348745996	-122.41404914235001	(37.751051348746, -122.41404914235)
31383	31383	244306	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	300x Octavia St	8	Median : Cutout 11	Tree 1	DPW 2			2	Width 0ft		6005576.9618	2110512.9441	37.7753816404734	-122.42418868303001	(37.7753816404734, -122.42418868303)
57780	57780	246553	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	20x Octavia St	7	Median : Yard 3	Tree 1	DPW 2			2	Width 8ft		6005726.464930001	2109532.06592	37.7726968262309	-122.42360176272699	(37.7726968262309, -122.423601762727)
1003	1003	14837	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1306 McAllister St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/10/2011 12:00:00 AM	3	3x3		6002857.7118	2111688.5769	37.7784557229826	-122.43367923622401	(37.7784557229826, -122.433679236224)
2076	2076	14859	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1368 McAllister St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/10/2011 12:00:00 AM	3	3x3		6002639.2367	2111656.2394	37.7783545332764	-122.434432710417	(37.7783545332764, -122.434432710417)
4237	4237	14843	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1320 McAllister St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/10/2011 12:00:00 AM	3	3x3		6002817.8815	2111683.4502	37.7784393862348	-122.433816657579	(37.7784393862348, -122.433816657579)
6048	6048	14856	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1360 McAllister St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/10/2011 12:00:00 AM	3	3x3		6002668.0249	2111660.9717	37.7783691610679	-122.434333459849	(37.7783691610679, -122.434333459849)
8034	8034	17992	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2619 Pine St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/14/2012 12:00:00 AM	3	3X3		6001295.2434	2114888.6615	37.787153557687795	-122.439313827621	(37.7871535576878, -122.439313827621)
8354	8354	14848	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1341 McAllister St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/10/2011 12:00:00 AM	3	3x3		6002736.8406	2111618.9725	37.778257747549894	-122.434092397831	(37.7782577475499, -122.434092397831)
8552	8552	14851	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1350 McAllister St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/10/2011 12:00:00 AM	3	3x3		6002705.0947	2111666.0984	37.778385341741206	-122.434205588327	(37.7783853417412, -122.434205588327)

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