Street_Tree_List

Data source: data.sfgov.org

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

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, qSiteInfo, PlotSize, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude ▼	Location
12993	12993	19985	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100 STAIRWAY46	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	40
16163	16163	26637	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	400X Winfield St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/12/1998 12:00:00 AM	6	3X3
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
102460	102460	11630	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	400X Junipero Serra Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	4x4		5991380.578	2094219.03	37.7298310098579	-122.47210889946501	(37.7298310098579, -122.472108899465)
85950	85950	1325	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	4051X Alemany Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			15	3X3		5991764.76245	2086963.37686	37.709930989883496	-122.47025258193399	(37.7099309898835, -122.470252581934)
109476	109476	19301	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100X Balboa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		5995247.10654	2111496.409	37.7774933045144	-122.459993084378	(37.7774933045144, -122.459993084378)
78358	78358	1208	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	3141 Alemany Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			25	3x3		5995992.87885	2086942.4061599998	37.7101169521706	-122.455637985173	(37.7101169521706, -122.455637985173)
11281	11281	1166	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2900 Alemany Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/22/2008 12:00:00 AM	25	3X3		5997012.91474	2087625.1618700002	37.7120501257788	-122.45216178836	(37.7120501257788, -122.45216178836)
140379	140379	14496	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	345 Masonic Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	3X4		5998988.10277	2111568.3775400002	37.7779053592654	-122.44705696740499	(37.7779053592654, -122.447056967405)
21400	21400	14591	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1221 Masonic Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		08/09/2011 12:00:00 AM	3	3x3		5999412.7083	2108624.4902	37.7698464448905	-122.445376387082	(37.7698464448905, -122.445376387082)
20352	20352	14598	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1247 Masonic Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2016 12:00:00 AM	45	3X3		5999428.6068	2108510.475	37.7695342955042	-122.445313195872	(37.7695342955042, -122.445313195872)
2806	2806	18057	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2882 Pine St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			16	3X3		6000155.2064	2114785.6979	37.7868059046739	-122.443250696948	(37.7868059046739, -122.443250696948)
1270	1270	18055	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2872 Pine St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6000192.328	2114789.41	37.786818213822706	-122.443122531996	(37.7868182138227, -122.443122531996)
127	127	18052	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2840 Pine St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6000317.799	2114808.7133	37.7868783690408	-122.442689819484	(37.7868783690408, -122.442689819484)
16950	16950	25174	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	3062 Market St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			100	3X3		6000130.8652	2105433.23803	37.761125030928895	-122.44266313540199	(37.7611250309289, -122.442663135402)
9754	9754	25175	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	3066 Market St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			40	9x9	Permit Number 772559	6000144.4461106	2105441.7794376	37.7611492576992	-122.44261677830299	(37.7611492576992, -122.442616778303)
18446	18446	25173	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	3062 Market St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			80	3X3		6000161.42067	2105438.6168299997	37.761141541560505	-122.44255784368	(37.7611415415605, -122.44255784368)
8226	8226	18032	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2801 Pine St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6000470.3136	2114777.4747	37.7868012889701	-122.44215991241501	(37.7868012889701, -122.442159912415)

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