Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2038 | 2038 | 23713 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 709 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 4X4 | 6003942.7402 | 2111225.1787 | 37.7772448524761 | -122.429892651683 | (37.7772448524761, -122.429892651683) | |||
2242 | 2242 | 23928 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1715 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6003464.0168 | 2114669.7894 | 37.7866757692841 | -122.431794715065 | (37.7866757692841, -122.431794715065) | |||
3202 | 3202 | 14513 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 501 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5999073.0679 | 2111076.7771 | 37.776560404910796 | -122.4467276636 | (37.7765604049108, -122.4467276636) | |||
4904 | 4904 | 23927 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1715 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6003460.7841 | 2114695.1886 | 37.7867453258178 | -122.43180771362199 | (37.7867453258178, -122.431807713622) | |||
6042 | 6042 | 14515 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 515 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 4X4 | 5999080.7636 | 2111027.2361 | 37.7764248176545 | -122.44669747668699 | (37.7764248176545, -122.446697476687) | |||
7093 | 7093 | 23752 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900X Webster St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 34 | 4X4 | 6003928.8061 | 2112053.0316 | 37.7795171425157 | -122.429999922728 | (37.7795171425157, -122.429999922728) | |||
7229 | 7229 | 23933 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1737 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4X4 | 6003453.8571 | 2114739.0598 | 37.7868653923719 | -122.431834813039 | (37.7868653923719, -122.431834813039) | |||
7253 | 7253 | 23719 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 780 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/21/1999 12:00:00 AM | 80 | 4X4 | 6004022.2052 | 2111346.6982 | 37.777583014840296 | -122.429626425718 | (37.7775830148403, -122.429626425718) | ||
7686 | 7686 | 23718 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 760 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/19/1992 12:00:00 AM | 12 | 4X4 | 6004031.4914 | 2111284.7902 | 37.7774135565599 | -122.429589885322 | (37.7774135565599, -122.429589885322) | ||
9527 | 9527 | 9961 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 700X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004044.3152 | 2111193.6969 | 37.777164162929 | -122.429539025484 | (37.777164162929, -122.429539025484) | |||
17342 | 17342 | 16656 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 200 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4X4 | 6002872.09203 | 2107040.69534 | 37.7656946022435 | -122.433297284454 | (37.7656946022435, -122.433297284454) | |||
17501 | 17501 | 16632 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 150 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002845.7066 | 2107359.01628 | 37.7665671370879 | -122.433411295115 | (37.7665671370879, -122.433411295115) | |||
17700 | 17700 | 4504 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1780 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 4X4 | 6004619.48057 | 2098494.87239 | 37.7423287477646 | -122.426644841002 | (37.7423287477646, -122.426644841002) | |||
19125 | 19125 | 28638 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 740 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 4X4 | 6004036.2280897 | 2111271.8185656 | 37.777378207850795 | -122.42957257421499 | (37.7773782078508, -122.429572574215) | |||
19858 | 19858 | 10411 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1160 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4X4 | 5999445.7253 | 2108826.6734 | 37.7704034735557 | -122.445276721272 | (37.7704034735557, -122.445276721272) | |||
20237 | 20237 | 16633 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 150 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002856.03732 | 2107366.99767 | 37.7665896381334 | -122.43337613341002 | (37.7665896381334, -122.43337613341) | |||
20745 | 20745 | 14359 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002945.74556 | 2106677.88542 | 37.7647025924854 | -122.433016609656 | (37.7647025924854, -122.433016609656) | |||
21343 | 21343 | 14358 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002934.58534 | 2106677.65284 | 37.764701320838796 | -122.43305519326599 | (37.7647013208388, -122.433055193266) | |||
80291 | 80291 | 21692 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1630X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 4X4 | 6003612.6236388 | 2114305.6361391004 | 37.7856843190794 | -122.431254568258 | (37.7856843190794, -122.431254568258) | |||
82530 | 82530 | 14583 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1159 Masonic Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 60 | 4X4 | 5999386.3171 | 2108834.4593 | 37.7704214603588 | -122.445482773554 | (37.7704214603588, -122.445482773554) | |||
83963 | 83963 | 23741 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 856 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4X4 | 6003980.765967 | 2111671.7236867 | 37.7784731079824 | -122.429792966614 | (37.7784731079824, -122.429792966614) | |||
86129 | 86129 | 4819 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 398X Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 4X4 | 6006006.1956778 | 2097849.2293648 | 37.7406342583881 | -122.42180414448299 | (37.7406342583881, -122.421804144483) | |||
87454 | 87454 | 23720 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 780 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6004017.263545 | 2111409.9612221 | 37.77775643966329 | -122.429648033671 | (37.7777564396633, -122.429648033671) | |||
87546 | 87546 | 23742 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 856 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4X4 | 6003980.765967 | 2111671.7236867 | 37.7784731079824 | -122.429792966614 | (37.7784731079824, -122.429792966614) | |||
89797 | 89797 | 23907 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1615 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 4X4 | 6003522.428263701 | 2114237.5945626 | 37.785492382250794 | -122.43156175891899 | (37.7854923822508, -122.431561758919) | |||
90407 | 90407 | 23715 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 740 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4X4 | 6004036.2280897 | 2111271.8185656 | 37.777378207850795 | -122.42957257421499 | (37.7773782078508, -122.429572574215) | |||
90802 | 90802 | 23739 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 848 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4X4 | 6003984.4734674 | 2111644.7647146 | 37.7783992952615 | -122.429778217597 | (37.7783992952615, -122.429778217597) | |||
92757 | 92757 | 23917 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1639 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 4X4 | 6003511.011206 | 2114320.0570948003 | 37.7857181564596 | -122.431607147924 | (37.7857181564596, -122.431607147924) | |||
92835 | 92835 | 21715 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1711X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6003474.1759741 | 2114557.4451345 | 37.7863678761913 | -122.431751542559 | (37.7863678761913, -122.431751542559) | |||
96482 | 96482 | 8109 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 790X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6004003.8918437995 | 2111454.7703146 | 37.7778787172016 | -122.429697487702 | (37.7778787172016, -122.429697487702) | |||
98046 | 98046 | 4434 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1246 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6004452.33203 | 2101636.8791292 | 37.7509465218336 | -122.427446575049 | (37.7509465218336, -122.427446575049) | |||
99128 | 99128 | 23906 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1605 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 4X4 | 6003542.7980522 | 2114194.1073783003 | 37.785374131922396 | -122.43148817988899 | (37.7853741319224, -122.431488179889) | |||
102303 | 102303 | 2686 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1785 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 4X4 | 6003432.16121 | 2114811.6647200002 | 37.787063517212296 | -122.431915062035 | (37.7870635172123, -122.431915062035) | |||
102845 | 102845 | 23717 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 755 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X4 | 6003929.8516061 | 2111310.486379 | 37.7774783563958 | -122.429943324105 | (37.7774783563958, -122.429943324105) | |||
103943 | 103943 | 23915 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1631 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 4X4 | 6003514.8324253 | 2114292.4573902 | 37.7856425912173 | -122.43159195647101 | (37.7856425912173, -122.431591956471) | |||
104204 | 104204 | 14512 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500X Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5999167.52145 | 2111070.84281 | 37.776549506017105 | -122.446400495731 | (37.7765495060171, -122.446400495731) | |||
112079 | 112079 | 23714 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 740 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X4 | 6004036.2280897 | 2111271.8185656 | 37.777378207850795 | -122.42957257421499 | (37.7773782078508, -122.429572574215) | |||
112090 | 112090 | 23724 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 802X Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6003990.015324599 | 2111477.493419 | 37.7779403234669 | -122.429747112563 | (37.7779403234669, -122.429747112563) | |||
113245 | 113245 | 21719 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1645 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4X4 | 6003301.0 | 2114333.0 | 37.7857417886053 | -122.432334651108 | (37.7857417886053, -122.432334651108) | |||
114151 | 114151 | 23765 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 911 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X4 | 6003870.64227 | 2111837.18218 | 37.778921179361504 | -122.430185733043 | (37.7789211793615, -122.430185733043) | |||
114713 | 114713 | 23916 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1639 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6003511.011206 | 2114320.0570948003 | 37.7857181564596 | -122.431607147924 | (37.7857181564596, -122.431607147924) | |||
115931 | 115931 | 23905 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1601 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/2008 12:00:00 AM | 45 | 4X4 | 6003552.240720401 | 2114183.8642161 | 37.7853465419578 | -122.431454779618 | (37.7853465419578, -122.431454779618) | ||
116208 | 116208 | 23716 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 740 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 4X4 | 6004036.2280897 | 2111271.8185656 | 37.777378207850795 | -122.42957257421499 | (37.7773782078508, -122.429572574215) | |||
123150 | 123150 | 14511 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500X Masonic Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5999167.52145 | 2111070.84281 | 37.776549506017105 | -122.446400495731 | (37.7765495060171, -122.446400495731) | |||
124375 | 124375 | 23910 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1620 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4X4 | 6003617.383911 | 2114271.2538834 | 37.785590183829996 | -122.43123564401199 | (37.78559018383, -122.431235644012) | |||
124648 | 124648 | 23721 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 802X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 4X4 | 6003990.015324599 | 2111477.493419 | 37.7779403234669 | -122.429747112563 | (37.7779403234669, -122.429747112563) | |||
126441 | 126441 | 23918 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1639 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 38 | 4X4 | 6003511.011206 | 2114320.0570948003 | 37.7857181564596 | -122.431607147924 | (37.7857181564596, -122.431607147924) | |||
127245 | 127245 | 165 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 185X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6002905.5013881 | 2107191.4781257 | 37.7661105103373 | -122.433192503539 | (37.7661105103373, -122.433192503539) | |||
127379 | 127379 | 23712 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 703 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X4 | 6003969.6344427 | 2111125.8223490003 | 37.7769735674529 | -122.42979252742599 | (37.7769735674529, -122.429792527426) | |||
129085 | 129085 | 8110 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 790X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4X4 | 6004003.8918437995 | 2111454.7703146 | 37.7778787172016 | -122.429697487702 | (37.7778787172016, -122.429697487702) | |||
140685 | 140685 | 23738 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 848 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X4 | 6003984.4734674 | 2111644.7647146 | 37.7783992952615 | -122.429778217597 | (37.7783992952615, -122.429778217597) | |||
143117 | 143117 | 21718 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1649X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 4X4 | 6003506.2579819 | 2114354.3884348 | 37.785812152244894 | -122.431626044652 | (37.7858121522449, -122.431626044652) | |||
143500 | 143500 | 23908 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1620 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4X4 | 6003617.383911 | 2114271.2538834 | 37.785590183829996 | -122.43123564401199 | (37.78559018383, -122.431235644012) | |||
145939 | 145939 | 10418 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1219X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5999402.57096 | 2108712.61162 | 37.7700878253378 | -122.445417788957 | (37.7700878253378, -122.445417788957) |
JSON shape: default, array, newline-delimited
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");