Street_Tree_List

Data source: data.sfgov.org

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

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
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)
189	189	138807	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2355 PINE ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			13	Width 0ft		6002661.6347	2115086.2451	37.7877737339769	-122.434600550462	(37.7877737339769, -122.434600550462)
207	207	138805	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2355 PINE ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			11	Width 0ft		6002622.3069	2115079.2676	37.787752342886	-122.434736117903	(37.787752342886, -122.434736117903)
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)
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)
1243	1243	242621	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	3274 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			20	Width 3ft		6008442.97152	2099602.35151	37.745585061615294	-122.413502636934	(37.7455850616153, -122.413502636934)
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)
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)
4598	4598	18015	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2712 Pine St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6000819.3499	2114877.5272	37.7870958927498	-122.44095951208901	(37.7870958927498, -122.440959512089)
4811	4811	17931	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2416 Pine St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	5x6		6002234.6053	2115077.8001	37.7877262951282	-122.43607738468398	(37.7877262951282, -122.436077384684)
5698	5698	17917	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2370 Pine St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6002602.4145	2115123.2744	37.7878720449725	-122.43480808996	(37.7878720449725, -122.43480808996)
6069	6069	17933	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2418 Pine St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6002186.7609	2115068.0006	37.7876966699691	-122.43624221533301	(37.7876966699691, -122.436242215333)
6216	6216	18017	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2713 Pine St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6000875.2767	2114835.3915	37.786983384155505	-122.440762994582	(37.7869833841555, -122.440762994582)
6867	6867	18000	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2670 Pine St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			16	3X3		6001175.0601	2114930.6744	37.7872620743104	-122.43973264788299	(37.7872620743104, -122.439732647883)
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)
8639	8639	18001	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2673 Pine St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6001165.7528	2114873.8019	37.7871053873216	-122.439760770078	(37.7871053873216, -122.439760770078)
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)
10349	10349	17525	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	342 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			40	3x3		6002628.09189	2091001.6668200002	37.721641326157204	-122.43299522107401	(37.7216413261572, -122.432995221074)
10351	10351	17502	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	125 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6002131.248869999	2091360.1957200002	37.7225975717171	-122.434738297838	(37.7225975717171, -122.434738297838)
10537	10537	17602	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	912 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			45	3X3		6003897.46129	2090203.63126	37.7195220153206	-122.428550493605	(37.7195220153206, -122.428550493605)
10554	10554	17590	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			30	3x3		6003668.70994	2090393.5126599998	37.720030439842	-122.429354736658	(37.720030439842, -122.429354736658)
10722	10722	17551	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	601 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			50	3X3		6003191.74591	2090695.7695400002	37.720833355450104	-122.43102499890699	(37.7208333554501, -122.431024998907)
10729	10729	17592	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			50	3x3		6003646.11767	2090408.41073	37.7200700675728	-122.42943389227699	(37.7200700675728, -122.429433892277)
10866	10866	17524	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	311 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6002598.14463	2091067.38518	37.7218200754046	-122.433103433796	(37.7218200754046, -122.433103433796)
10894	10894	17530	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	418 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			15	3x3		6002769.64699	2090910.4417700002	37.72139887074	-122.432499390644	(37.72139887074, -122.432499390644)
10917	10917	17498	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101 Persia Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			50	2X2		6002093.54294	2091384.31052	37.72266164479	-122.43487036238501	(37.72266164479, -122.434870362385)
10940	10940	17528	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	400 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6002717.3851	2090942.2754900001	37.7214833152726	-122.432682318148	(37.7214833152726, -122.432682318148)
10957	10957	17580	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	4	Sidewalk: Property side : Cutout 5	Tree 1	DPW 2			18	3x3		6003780.63082	2090335.5596900003	37.719877649504205	-122.428963734788	(37.7198776495042, -122.428963734788)
10968	10968	17595	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	818 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			40	3x3		6003715.34966	2090318.2223099999	37.719826349498895	-122.42918815340401	(37.7198263494989, -122.429188153404)
10999	10999	17515	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	245X Persia Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6002425.76888	2091174.41595	37.7221041784351	-122.433706937351	(37.7221041784351, -122.433706937351)
11095	11095	17586	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6003709.25966	2090367.0753099998	37.7199601443381	-122.42921268601499	(37.7199601443381, -122.429212686015)
11152	11152	17582	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	6	Sidewalk: Property side : Cutout 5	Tree 1	DPW 2			18	3x3		6003762.13068	2090345.22062	37.7199031291015	-122.42902837176202	(37.7199031291015, -122.429028371762)
11164	11164	17617	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1042 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			40	3x3		6004228.49613	2089992.79688	37.7189618383998	-122.427391215355	(37.7189618383998, -122.427391215355)
11249	11249	17536	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	501X Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			50	3x3		6003012.06568	2090814.03767	37.72114791043521	-122.431654537837	(37.7211479104352, -122.431654537837)
11319	11319	17589	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	13	Sidewalk: Property side : Cutout 5	Tree 1	DPW 2			18	3x3		6003683.23846	2090394.91559	37.720035114503006	-122.42930461652	(37.720035114503, -122.42930461652)
11325	11325	17624	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1101 Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			50	3X3		6004341.89656	2089971.87372	37.7189108009657	-122.426997744874	(37.7189108009657, -122.426997744874)
11358	11358	17550	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	600 Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			14	3x3		6003170.84982	2090661.1447	37.7207370992233	-122.431094760237	(37.7207370992233, -122.431094760237)
11476	11476	17503	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	131 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6002145.061290001	2091350.8283900002	37.7225726352947	-122.434689881929	(37.7225726352947, -122.434689881929)
11534	11534	17549	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	600 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			14	3X3		6003191.593230001	2090648.1169	37.7207025031963	-122.431022127369	(37.7207025031963, -122.431022127369)
11538	11538	17585	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6003724.8526	2090366.56287	37.71995962001	-122.429158750084	(37.71995962001, -122.429158750084)
11558	11558	17522	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	307 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			14	3x3		6002546.66743	2091098.28956	37.7219020117492	-122.433283584179	(37.7219020117492, -122.433283584179)
11596	11596	17497	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101 Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			50	2X2		6002079.41309	2091392.13948	37.7226823390961	-122.43491976573401	(37.7226823390961, -122.434919765734)
11600	11600	17581	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6003766.7866400005	2090331.9281799998	37.7198668945342	-122.429011330508	(37.7198668945342, -122.429011330508)
11611	11611	17597	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	844 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6003772.37846	2090279.5258799999	37.71972332585371	-122.428988267402	(37.7197233258537, -122.428988267402)
11682	11682	17519	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	300X Persia Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			19	3x3		6002513.47081	2091072.78557	37.721830100172504	-122.433396514735	(37.7218301001725, -122.433396514735)
11871	11871	17518	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	300X Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6002537.724219999	2091058.53445	37.72179234573429	-122.433311659211	(37.7217923457343, -122.433311659211)
11883	11883	17495	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			20	3X3		6002027.05349	2091378.7208900002	37.722642521627996	-122.43509980193001	(37.722642521628, -122.43509980193)
11929	11929	17621	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1100 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			10	3X3		6004336.281690001	2089926.3148400001	37.7187853887157	-122.42701391015899	(37.7187853887157, -122.427013910159)
11996	11996	17591	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	15	Sidewalk: Property side : Cutout 5	Tree 1	DPW 2			30	3x3		6003659.63671	2090407.2266799998	37.7200675818369	-122.42938707716299	(37.7200675818369, -122.429387077163)
12017	12017	17554	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	620 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			30	3X3		6003227.93089	2090625.05216	37.7206412314956	-122.43089487419901	(37.7206412314956, -122.430894874199)
12027	12027	17535	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	501X Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			50	3x3		6003034.530590001	2090798.32089	37.721106028988295	-122.431575761713	(37.7211060289883, -122.431575761713)
12076	12076	17583	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6003749.1517199995	2090342.6567099998	37.7198953544779	-122.429073052804	(37.7198953544779, -122.429073052804)
12133	12133	17594	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	808 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			35	3x3		6003660.5889	2090352.7029799998	37.719917925661	-122.42937989966002	(37.719917925661, -122.42937989966)
12305	12305	17584	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	8	Sidewalk: Property side : Cutout 5	Tree 1	DPW 2			18	3x3		6003740.32149	2090358.06458	37.7199371612464	-122.42910467385201	(37.7199371612464, -122.429104673852)
12432	12432	17625	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1132 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			45	3x3		6004425.094930001	2089870.4961599999	37.7186371444562	-122.426702945308	(37.7186371444562, -122.426702945308)
12487	12487	17616	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1030 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6004194.38835	2090014.0443400003	37.719018250172	-122.42751062553499	(37.719018250172, -122.427510625535)
12573	12573	17588	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			30	3x3		6003687.80932	2090380.0219599998	37.7199944786431	-122.429287755146	(37.7199944786431, -122.429287755146)
12598	12598	17596	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	822 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			22	3X3		6003747.6295300005	2090297.4937	37.719771260609996	-122.429075096066	(37.71977126061, -122.429075096066)
12693	12693	17579	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6003783.82433	2090321.42028	37.7198390065544	-122.428951688396	(37.7198390065544, -122.428951688396)
12701	12701	17544	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	537 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			50	3X3		6003083.60804	2090766.94886	37.7210226699524	-122.431403876997	(37.7210226699524, -122.431403876997)
12769	12769	17578	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	2	Sidewalk: Property side : Cutout 5	Tree 1	DPW 2			18	3x3		6003799.63122	2090323.6743700001	37.7198460905006	-122.428897210135	(37.7198460905006, -122.428897210135)
12852	12852	17587	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	11	Sidewalk: Property side : Cutout 5	Tree 1	DPW 2			35	3X3		6003703.481380001	2090378.19842	37.7199903588363	-122.42923345225901	(37.7199903588363, -122.429233452259)
12929	12929	17531	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	444 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6002851.30461	2090860.81338	37.72126723246829	-122.43221358070299	(37.7212672324683, -122.432213580703)
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
13029	13029	17562	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	645 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			50	3x3		6003332.52001	2090606.8773	37.72059725284729	-122.43053204633001	(37.7205972528473, -122.43053204633)
13058	13058	17513	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	245X Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6002376.23219	2091204.63173	37.7221843332317	-122.433880332025	(37.7221843332317, -122.433880332025)
13153	13153	17626	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1135 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			50	3X3		6004454.014359999	2089904.4684	37.718732059816205	-122.42660540034099	(37.7187320598162, -122.426605400341)
13173	13173	17514	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	245X Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6002400.99383	2091189.1997099998	37.7221433654964	-122.433793634664	(37.7221433654964, -122.433793634664)
13231	13231	17623	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1101 Persia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			35	3X3		6004371.84322	2089954.8563599999	37.718865768324	-122.426893019707	(37.718865768324, -122.426893019707)
13679	13679	100568	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	868 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	3x3		6011788.1802	2112369.4793	37.780828003664	-122.40283310111	(37.780828003664, -122.40283310111)

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