Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCareAssistant, DBH
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5807 | 5807 | 47379 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4453 Manzanita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | Permit Number 45296 | ||||||||
10621 | 10621 | 52188 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 76 Camona Av | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2005 12:00:00 AM | Permit Number 48379 | ||||||||
15164 | 15164 | 51415 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 7121 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2004 12:00:00 AM | Permit Number 47739 | ||||||||
108782 | 108782 | 15977 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5937 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1995 12:00:00 AM | 6 | 3X3 | 5996505.5077599995 | 2086284.06053 | 37.7083386912237 | -122.453818737586 | (37.7083386912237, -122.453818737586) | ||
84568 | 84568 | 15970 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5919X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1995 12:00:00 AM | 6 | 3X3 | 5996671.773019999 | 2086351.2464599998 | 37.708532699460896 | -122.45324895592199 | (37.7085326994609, -122.453248955922) | ||
110307 | 110307 | 117181 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 8 KNOTT CT | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000120.0 | 2086463.0 | 37.7090365866676 | -122.44133950250601 | (37.7090365866676, -122.441339502506) | ||||
144893 | 144893 | 117180 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 8 KNOTT CT | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000120.0 | 2086463.0 | 37.7090365866676 | -122.44133950250601 | (37.7090365866676, -122.441339502506) | |||
9415 | 9415 | 15943 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5810X MISSION ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 5997175.0 | 2086632.0 | 37.7093324147693 | -122.451529986796 | (37.7093324147693, -122.451529986796) | |||
79600 | 79600 | 15934 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5775 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5997641.29025 | 2086713.63365 | 37.7095832536665 | -122.449924299561 | (37.7095832536665, -122.449924299561) | ||
26854 | 26854 | 103532 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 130 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2014 12:00:00 AM | 1 | Permit Number 770957 | 6003118.601980001 | 2086861.7562 | 37.7103018500205 | -122.431004337903 | (37.7103018500205, -122.431004337903) | ||
36031 | 36031 | 103531 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 130 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2014 12:00:00 AM | 1 | Permit Number 770957 | 6003099.91342 | 2086880.6888299999 | 37.7103527759382 | -122.43107027978901 | (37.7103527759382, -122.431070279789) | ||
87032 | 87032 | 1201 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3099X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5996220.7283 | 2087044.1157099998 | 37.7104092959015 | -122.454857840965 | (37.7104092959015, -122.454857840965) | |||
95862 | 95862 | 1202 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3099X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5996220.7283 | 2087044.1157099998 | 37.7104092959015 | -122.454857840965 | (37.7104092959015, -122.454857840965) | |||
141065 | 141065 | 1200 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3099X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5996220.7283 | 2087044.1157099998 | 37.7104092959015 | -122.454857840965 | (37.7104092959015, -122.454857840965) | |||
81227 | 81227 | 42741 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 295 Tocoloma Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2002 12:00:00 AM | Permit Number 45864 | 6012649.44440777 | 2087097.71305381 | 37.711485187600495 | -122.39808010272101 | (37.7114851876005, -122.398080102721) | ||
77816 | 77816 | 52055 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 199 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2005 12:00:00 AM | Permit Number 48255 | 6009975.44300852 | 2087511.82859192 | 37.712472966599705 | -122.407351368495 | (37.7124729665997, -122.407351368495) | |||
81081 | 81081 | 52056 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 199 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2005 12:00:00 AM | Permit Number 48255 | 6009975.44300852 | 2087511.82859192 | 37.712472966599705 | -122.407351368495 | (37.7124729665997, -122.407351368495) | |||
97908 | 97908 | 52053 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 199 Leland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2005 12:00:00 AM | Permit Number 48255 | 6009975.44300852 | 2087511.82859192 | 37.712472966599705 | -122.407351368495 | (37.7124729665997, -122.407351368495) | |||
124729 | 124729 | 52057 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 199 Leland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2005 12:00:00 AM | Permit Number 48255 | 6009975.44300852 | 2087511.82859192 | 37.712472966599705 | -122.407351368495 | (37.7124729665997, -122.407351368495) | |||
148867 | 148867 | 44382 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1257 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | 10 | Permit Number 43744 | 6001457.21112 | 2087559.6242799999 | 37.71212376138379 | -122.43679636128901 | (37.7121237613838, -122.436796361289) | |
69123 | 69123 | 180485 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1222 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6001620.509380001 | 2087598.74128 | 37.712240447503 | -122.436234753557 | (37.712240447503, -122.436234753557) | |||
85331 | 85331 | 115871 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 84X Cordova St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/29/2016 12:00:00 AM | 3 | Permit Number 775902. On Athens St frontage | 6001679.7 | 2087642.4 | 37.712363687575795 | -122.43603329568501 | (37.7123636875758, -122.436033295685) | ||
103491 | 103491 | 85333 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 179 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/2007 12:00:00 AM | Permit Number 49613 | 5995212.0 | 2087736.0 | 37.7122511325681 | -122.458394244156 | (37.7122511325681, -122.458394244156) | |||
10028 | 10028 | 161764 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 142 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779227 | 6000990.7389 | 2087787.91218 | 37.7127240669257 | -122.43842496696001 | (37.7127240669257, -122.43842496696) | |
79471 | 79471 | 26094 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 21 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5996391.73364 | 2088029.79177 | 37.71312554209 | -122.454337965939 | (37.71312554209, -122.454337965939) | ||
98063 | 98063 | 29947 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 203 Broad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 3 | 3x3 | 5994985.99771987 | 2088049.72518423 | 37.7130995578919 | -122.45919807332301 | (37.7130995578919, -122.459198073323) | ||
97339 | 97339 | 85212 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 229 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2007 12:00:00 AM | 3 | 3x3 | maintenance agreement through 7/2/2010 | 5994738.0 | 2088050.0 | 37.7130860517587 | -122.46005525076299 | (37.7130860517587, -122.460055250763) | |
76812 | 76812 | 26075 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 279 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2003 12:00:00 AM | 12 | 3X3 | 5994244.197480001 | 2088053.67853 | 37.7130677382333 | -122.46176225203001 | (37.7130677382333, -122.46176225203) | ||
19942 | 19942 | 26077 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 261 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 02:44:00 PM | 3 | 3X3 | 5994378.441000001 | 2088053.8388 | 37.7130759052536 | -122.461298276453 | (37.7130759052536, -122.461298276453) | ||
79330 | 79330 | 26039 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 32 Broad St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2015 12:00:00 AM | 6 | 3X3 | 5996279.3875 | 2088089.20515 | 37.713282233928 | -122.454730559713 | (37.713282233928, -122.454730559713) | ||
107773 | 107773 | 26043 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 32 Broad St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2015 12:00:00 AM | 3 | 3X3 | 5996178.64561 | 2088089.5286700001 | 37.7132773431944 | -122.455078779743 | (37.7132773431944, -122.455078779743) | ||
98617 | 98617 | 26044 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 32 Broad St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/1997 12:00:00 AM | 7 | 3X3 | 5996138.5208 | 2088089.89027 | 37.7132760340232 | -122.45521749021002 | (37.7132760340232, -122.45521749021) | ||
83999 | 83999 | 26042 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 32 Broad St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2003 12:00:00 AM | 10 | 3X3 | 5996190.731819999 | 2088089.91613 | 37.7132791004475 | -122.455037033861 | (37.7132791004475, -122.455037033861) | ||
113312 | 113312 | 26041 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 32 Broad St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/1997 12:00:00 AM | 9 | 3X3 | 5996239.04821 | 2088090.4012099998 | 37.7132832040965 | -122.454870071763 | (37.7132832040965, -122.454870071763) | ||
78942 | 78942 | 29941 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 200 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 3 | 3x3 | 5995006.35114609 | 2088101.46141456 | 37.7132427835292 | -122.459131469448 | (37.7132427835292, -122.459131469448) | ||
113119 | 113119 | 26066 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 252 Broad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | 12 | 3X3 | 5994485.32272 | 2088110.77616 | 37.7132383925183 | -122.46093298415701 | (37.7132383925183, -122.460932984157) | ||
113738 | 113738 | 26400 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 272 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5994293.52025 | 2088114.03225 | 37.7132362944599 | -122.46159615030899 | (37.7132362944599, -122.461596150309) | ||
128289 | 128289 | 112742 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 156 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/2014 12:00:00 AM | Permit Number 774175 | 5995316.4 | 2088116.5 | 37.7133018954425 | -122.45806092895701 | (37.7133018954425, -122.458060928957) | ||
125649 | 125649 | 15854 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5319 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5999668.720480001 | 2088318.36983 | 37.714105297270606 | -122.443032341019 | (37.7141052972706, -122.443032341019) | ||
142815 | 142815 | 15859 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5367 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5999657.0 | 2088324.0 | 37.7141200881786 | -122.44307325545601 | (37.7141200881786, -122.443073255456) | ||
88818 | 88818 | 18610 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 615 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778725 | 5992407.5548851 | 2088503.1314627 | 37.7141959284164 | -122.468142922603 | (37.7141959284164, -122.468142922603) | |
86022 | 86022 | 17243 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10X Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2003 12:00:00 AM | 6 | 3X34 | 5993969.30173 | 2088537.74626 | 37.7143810447114 | -122.462747471174 | (37.7143810447114, -122.462747471174) | ||
77490 | 77490 | 25459 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2003 12:00:00 AM | 3 | 3X3 | 5993585.96467 | 2088543.99773 | 37.714376124024504 | -122.464072878916 | (37.7143761240245, -122.464072878916) | ||
92289 | 92289 | 25458 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2003 12:00:00 AM | 3 | 3X3 | 5993547.93552 | 2088545.97374 | 37.7143793578368 | -122.464204465034 | (37.7143793578368, -122.464204465034) | ||
20624 | 20624 | 25466 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 446 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2015 12:00:00 AM | 6 | 3X3 | 5992823.9205 | 2088555.2969999998 | 37.714363200126904 | -122.466707603629 | (37.7143632001269, -122.466707603629) | ||
2079 | 2079 | 181058 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5258 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 5999890.56935 | 2088656.9040700002 | 37.7150474825255 | -122.442289836724 | (37.7150474825255, -122.442289836724) | |||
13082 | 13082 | 15846 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5256 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2015 12:00:00 AM | 6 | 3x3 | Permit Number 775938 | 5999899.043409999 | 2088666.4410599999 | 37.7150741519211 | -122.442261231071 | (37.7150741519211, -122.442261231071) | |
91430 | 91430 | 51896 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 109 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48107 | 5995812.81263218 | 2088671.52692975 | 37.7148543797151 | -122.45638527464199 | (37.7148543797151, -122.456385274642) | |||
102622 | 102622 | 51895 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 109 Lobos St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48107 | 5995812.81263218 | 2088671.52692975 | 37.7148543797151 | -122.45638527464199 | (37.7148543797151, -122.456385274642) | |||
83771 | 83771 | 50148 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 875@ ITALY Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2003 12:00:00 AM | Permit Number 46868 | 6002211.52493718 | 2088672.10084916 | 37.7152212186066 | -122.43426871923 | (37.7152212186066, -122.43426871923) | |||
85512 | 85512 | 50146 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 875@ ITALY Vienna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2003 12:00:00 AM | Permit Number 46868 | 6002211.52493718 | 2088672.10084916 | 37.7152212186066 | -122.43426871923 | (37.7152212186066, -122.43426871923) | |||
99670 | 99670 | 50145 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 875@ ITALY Vienna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2003 12:00:00 AM | Permit Number 46868 | 6002211.52493718 | 2088672.10084916 | 37.7152212186066 | -122.43426871923 | (37.7152212186066, -122.43426871923) | |||
102299 | 102299 | 50147 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 875@ ITALY Vienna St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2003 12:00:00 AM | Permit Number 46868 | 6002211.52493718 | 2088672.10084916 | 37.7152212186066 | -122.43426871923 | (37.7152212186066, -122.43426871923) | |||
109473 | 109473 | 50144 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 875@ ITALY Vienna St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2003 12:00:00 AM | Permit Number 46868 | 6002211.52493718 | 2088672.10084916 | 37.7152212186066 | -122.43426871923 | (37.7152212186066, -122.43426871923) | |||
119919 | 119919 | 50142 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 875@ ITALY Vienna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2003 12:00:00 AM | Permit Number 46868 | 6002211.52493718 | 2088672.10084916 | 37.7152212186066 | -122.43426871923 | (37.7152212186066, -122.43426871923) | |||
81791 | 81791 | 115420 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 248 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 772989 | 5994528.8 | 2089058.5 | 37.7158431194451 | -122.46085135599199 | (37.7158431194451, -122.460851355992) | ||
130663 | 130663 | 52526 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 143 Rome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 3 | Permit Number 48626 | 5998907.21488 | 2089072.37485 | 37.7161321755247 | -122.445718577547 | (37.7161321755247, -122.445718577547) | |
79748 | 79748 | 52609 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 900 Gilman Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2006 12:00:00 AM | Permit Number 48695 | 6016118.74890568 | 2089125.97967621 | 37.717247040692 | -122.386230482369 | (37.717247040692, -122.386230482369) | |||
101940 | 101940 | 52610 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 900 Gilman Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2006 12:00:00 AM | Permit Number 48695 | 6016118.74890568 | 2089125.97967621 | 37.717247040692 | -122.386230482369 | (37.717247040692, -122.386230482369) | |||
110588 | 110588 | 52611 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 900 Gilman Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2006 12:00:00 AM | Permit Number 48695 | 6016118.74890568 | 2089125.97967621 | 37.717247040692 | -122.386230482369 | (37.717247040692, -122.386230482369) | |||
119803 | 119803 | 52612 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 900 Gilman Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2006 12:00:00 AM | Permit Number 48695 | 6016118.74890568 | 2089125.97967621 | 37.717247040692 | -122.386230482369 | (37.717247040692, -122.386230482369) | |||
121183 | 121183 | 52603 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 900 Gilman Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2006 12:00:00 AM | Permit Number 48695 | 6016118.74890568 | 2089125.97967621 | 37.717247040692 | -122.386230482369 | (37.717247040692, -122.386230482369) | |||
51240 | 51240 | 50511 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 758 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | Permit Number 47146 | 6002437.29594714 | 2089127.99525636 | 37.71648581608179 | -122.433520918153 | (37.7164858160818, -122.433520918153) | ||
95018 | 95018 | 84916 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 179 Josiah Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2007 12:00:00 AM | Permit Number 49337 | 5996552.2 | 2089341.7 | 37.7167369380148 | -122.453878025955 | (37.7167369380148, -122.453878025955) | |||
113141 | 113141 | 84917 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 179 Josiah Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2007 12:00:00 AM | Permit Number 49337 | 5996552.2 | 2089341.7 | 37.7167369380148 | -122.453878025955 | (37.7167369380148, -122.453878025955) | |||
114422 | 114422 | 84915 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 179 Josiah Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2007 12:00:00 AM | Permit Number 49337 | 5996552.2 | 2089341.7 | 37.7167369380148 | -122.453878025955 | (37.7167369380148, -122.453878025955) | |||
126153 | 126153 | 84914 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 180 Summit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2007 12:00:00 AM | Permit Number 49336 | 5996559.7 | 2089341.7 | 37.7167373680222 | -122.453852102309 | (37.7167373680222, -122.453852102309) | |||
102935 | 102935 | 52959 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 466 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | Permit Number 48946 | 5994050.21194488 | 2089542.24597124 | 37.71714382118439 | -122.462540634725 | (37.7171438211844, -122.462540634725) | ||
106130 | 106130 | 43719 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 318 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43359 | 5996886.95704145 | 2089617.86839977 | 37.7175144196209 | -122.452740863555 | (37.7175144196209, -122.452740863555) | ||
91209 | 91209 | 43720 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 330 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43360 | 5996862.80956904 | 2089634.81461711 | 37.717559566270104 | -122.45282555230301 | (37.7175595662701, -122.452825552303) | ||
14801 | 14801 | 22531 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 6619 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2015 08:00:00 AM | 3 | 3X3 | 6012836.07271 | 2089639.80613 | 37.7184756630977 | -122.397613243265 | (37.7184756630977, -122.397613243265) | ||
4672 | 4672 | 160512 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 718 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:07:00 PM | 3 | Width 0ft | 6001887.21385 | 2089766.7884 | 37.7182085743334 | -122.43546794121 | (37.7182085743334, -122.43546794121) | |
64062 | 64062 | 82900 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 444 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49729 | 5996625.78326464 | 2089801.15487038 | 37.7180027123551 | -122.453656843967 | (37.7180027123551, -122.453656843967) | ||
82309 | 82309 | 109567 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 56 Seneca Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775012 | 6000375.8 | 2089821.0 | 37.7182714712375 | -122.440696127295 | (37.7182714712375, -122.440696127295) |
38922 | 38922 | 180401 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 450 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003847.76406 | 2089839.62189 | 37.7185197127976 | -122.428696343867 | (37.7185197127976, -122.428696343867) | |||
4720 | 4720 | 160434 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 401 France Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2017 12:17:00 PM | 3 | Width 0ft | 6002057.78511 | 2089843.09143 | 37.7184277715106 | -122.434883803643 | (37.7184277715106, -122.434883803643) | |
134417 | 134417 | 198415 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3310 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6013330.68803 | 2089861.99882 | 37.7191132896144 | -122.39591911208299 | (37.7191132896144, -122.395919112083) | |||
180988 | 180988 | 198416 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1062 Key Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013254.09143 | 2089864.5252900003 | 37.7191159651107 | -122.396184055957 | (37.7191159651107, -122.396184055957) | |||
90618 | 90618 | 45343 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2001 12:00:00 AM | Permit Number 44173 | 5992459.1856169 | 2089877.0607820998 | 37.7179713877014 | -122.46806434863701 | (37.7179713877014, -122.468064348637) | |||
144136 | 144136 | 45344 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600 Shields St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2001 12:00:00 AM | Permit Number 44173 | 5992459.1856169 | 2089877.0607820998 | 37.7179713877014 | -122.46806434863701 | (37.7179713877014, -122.468064348637) | |||
186062 | 186062 | 198417 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1062 Key Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013234.80615 | 2089878.55725 | 37.719153420980604 | -122.39625170116301 | (37.7191534209806, -122.396251701163) | |||
40939 | 40939 | 198418 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1062 Key Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013212.31335 | 2089895.25282 | 37.7191980120665 | -122.396330620284 | (37.7191980120665, -122.396330620284) | |||
67824 | 67824 | 198414 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3310 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6013355.178590001 | 2089895.60565 | 37.71920692974621 | -122.39583681063299 | (37.7192069297462, -122.395836810633) | |||
4732 | 4732 | 160902 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 687 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2017 03:13:00 PM | 3 | Width 0ft | 6002042.96964 | 2089934.48855 | 37.718677886450294 | -122.43494154733101 | (37.7186778864503, -122.434941547331) | |
57102 | 57102 | 198419 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 6504 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012953.87538 | 2089942.68055 | 37.7193138546205 | -122.397227272216 | (37.7193138546205, -122.397227272216) | |||
4637 | 4637 | 160693 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 700 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:34:00 PM | 3 | Width 0ft | 6003044.40323 | 2089957.59001 | 37.7187981275985 | -122.431481646786 | (37.7187981275985, -122.431481646786) | |
165814 | 165814 | 198420 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 6500 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012967.05358 | 2089962.4416099999 | 37.7193688481865 | -122.397183104734 | (37.7193688481865, -122.397183104734) | |||
118685 | 118685 | 47248 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1060 Key Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/2011 12:00:00 AM | Permit Number 767222 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.39676721011699 | (37.7194581178311, -122.396767210117) | ||
129319 | 129319 | 50491 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 331 Tara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/2003 12:00:00 AM | Permit Number 47127 | 5997676.24873212 | 2090066.17987565 | 37.7187905749127 | -122.450044950853 | (37.7187905749127, -122.450044950853) | ||
103458 | 103458 | 53388 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 279 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 768680 | 5994715.35324887 | 2090431.41259249 | 37.719623543280896 | -122.460305961134 | (37.7196235432809, -122.460305961134) | |||
77376 | 77376 | 49717 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1195 Fitzgerald Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2003 12:00:00 AM | Permit Number 46529 | 6014698.72785663 | 2090465.4227663002 | 37.7208461876659 | -122.39123244275801 | (37.7208461876659, -122.391232442758) | |||
83435 | 83435 | 49719 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1195 Fitzgerald Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2003 12:00:00 AM | Permit Number 46529 | 6014698.72785663 | 2090465.4227663002 | 37.7208461876659 | -122.39123244275801 | (37.7208461876659, -122.391232442758) | |||
87176 | 87176 | 49716 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1195 Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2003 12:00:00 AM | Permit Number 46529 | 6014698.72785663 | 2090465.4227663002 | 37.7208461876659 | -122.39123244275801 | (37.7208461876659, -122.391232442758) | |||
69282 | 69282 | 52955 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 516 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | Permit Number 48942 | 5993282.16384919 | 2090617.22186434 | 37.72005118470771 | -122.465273429637 | (37.7200511847077, -122.465273429637) | ||
93952 | 93952 | 108380 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 286 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773804 | 6004439.17229 | 2090775.7474099998 | 37.7211235626427 | -122.426718715963 | (37.7211235626427, -122.426718715963) |
4758 | 4758 | 161382 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 523 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2017 03:54:00 PM | 3 | Width 0ft | 6002614.99011 | 2090841.7835900001 | 37.721201579268495 | -122.43302909312901 | (37.7212015792685, -122.433029093129) | ||
53925 | 53925 | 68894 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 47 Exeter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 11 | Permit Number 32866 | 6012572.9149400005 | 2090991.6774900001 | 37.722172972090505 | -122.39861769156799 | (37.7221729720905, -122.398617691568) | |
4352 | 4352 | 178029 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 398x Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 10:03:00 AM | 3 | Width 3ft | 6003930.0 | 2091029.0 | 37.7217901378795 | -122.428496818895 | (37.7217901378795, -122.428496818895) | ||
185844 | 185844 | 68890 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 35 Exeter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 8 | Permit Number 32862 | 6012596.9510699995 | 2091063.5496200002 | 37.7223716575091 | -122.398539644797 | (37.7223716575091, -122.398539644797) | |
187797 | 187797 | 219451 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 51 Geneva Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998010.24374 | 2091127.2252200001 | 37.7217230655433 | -122.44896685955099 | (37.7217230655433, -122.448966859551) |
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");