Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
838 | 838 | 19815 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY24 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 100ST | ||||||||
4452 | 4452 | 19593 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY4 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
5737 | 5737 | 20074 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY55 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 27X | ||||||||
6387 | 6387 | 19592 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY4 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
7219 | 7219 | 20014 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY47 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
7290 | 7290 | 19816 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY24 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 100ST | ||||||||
10060 | 10060 | 19578 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY4 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 8 | ||||||||
12451 | 12451 | 20015 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY47 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
12707 | 12707 | 107222 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 327 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2014 12:00:00 AM | 3 | 6x5 | Permit Number 773943 | 6003989.6035400005 | 2091508.12122 | 37.7231090719178 | -122.42832491578301 | (37.7231090719178, -122.428324915783) | |
13822 | 13822 | 20456 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 495X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
15735 | 15735 | 19811 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY24 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 100ST | ||||||||
20116 | 20116 | 2370 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 2516 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4PL | 6009703.1421 | 2102664.68486 | 37.7540642287015 | -122.40936121487499 | (37.7540642287015, -122.409361214875) | |||
22599 | 22599 | 2580 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 1668 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6005450.60125 | 2115176.6463599997 | 37.7881798837348 | -122.424957678647 | (37.7881798837348, -122.424957678647) | |||
27359 | 27359 | 240611 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 255 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003497.9531 | 2101542.75011 | 37.750634040826796 | -122.43074019171699 | (37.7506340408268, -122.430740191717) | |||
30053 | 30053 | 240601 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 609 28th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001917.090969999 | 2099400.07719 | 37.744661076553 | -122.43605362647301 | (37.744661076553, -122.436053626473) | |||
38099 | 38099 | 200496 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3239 Jennings St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6013542.8885 | 2090062.874 | 37.7196766561509 | -122.39519967454399 | (37.7196766561509, -122.395199674544) | |||
50051 | 50051 | 120239 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 288 24th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5988397.09206 | 2114077.36637 | 37.784183536793705 | -122.483878566436 | (37.7841835367937, -122.483878566436) | |||
50092 | 50092 | 372 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
60930 | 60930 | 52819 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 1327@ JUDAH 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Permit Number 48844 | 5987385.2929 | 2106232.8495 | 37.7625857382219 | -122.48680274332399 | (37.7625857382219, -122.486802743324) | |||
70873 | 70873 | 240602 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 609 28th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001920.90533 | 2099400.25112 | 37.7446617708226 | -122.436040449628 | (37.7446617708226, -122.436040449628) | |||
74221 | 74221 | 215021 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2624 14th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5992112.26225 | 2097456.03758 | 37.7387613350595 | -122.469814985494 | (37.7387613350595, -122.469814985494) | |||
75876 | 75876 | 240607 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 888 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6000718.67811 | 2102015.72187 | 37.751774854241795 | -122.44038504473 | (37.7517748542418, -122.44038504473) | |||
86905 | 86905 | 88838 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711 19th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3x3 | Permit Number 51718 | 5990297.3 | 2090806.0 | 37.7203969366505 | -122.475604756889 | (37.7203969366505, -122.475604756889) | ||
88885 | 88885 | 370 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
91300 | 91300 | 112804 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 219 UPPER TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 5999620.0 | 2106355.0 | 37.7636268249183 | -122.444496241129 | (37.7636268249183, -122.444496241129) | |||
92371 | 92371 | 118371 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 4808 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999981.0 | 2101110.0 | 37.7492459313263 | -122.44287099416799 | (37.7492459313263, -122.442870994168) | ||||
92695 | 92695 | 375 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
96847 | 96847 | 376 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
99767 | 99767 | 122496 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 69x Bonview St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6007716.0 | 2099172.0 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | ||||
101507 | 101507 | 381 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 16 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
102899 | 102899 | 373 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
104910 | 104910 | 24794 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 7633 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5983299.41691 | 2112375.1982400003 | 37.7792118059508 | -122.50138846508999 | (37.7792118059508, -122.50138846509) | |||
105060 | 105060 | 380 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 16 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
105545 | 105545 | 54448 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 425 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 3x5 | Permit Number 10233 | 6011220.56042251 | 2106374.73270267 | 37.764336094761 | -122.40437470921499 | (37.764336094761, -122.404374709215) | ||
106132 | 106132 | 97857 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 895 Indiana St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
107500 | 107500 | 54927 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 485 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1972 12:00:00 AM | 10 | Permit Number 10801 | 6003402.69319537 | 2099776.66443458 | 37.745779384936206 | -122.43094357883498 | (37.7457793849362, -122.430943578835) | ||
115004 | 115004 | 88839 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711 19th Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3x3 | Permit Number 51718 | 5990297.3 | 2090806.0 | 37.7203969366505 | -122.475604756889 | (37.7203969366505, -122.475604756889) | ||
115065 | 115065 | 87450 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 180 Castenada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2008 12:00:00 AM | 3x3 | Permit Number 50376 | 5994470.9 | 2100852.3 | 37.748222673270895 | -122.461906191942 | (37.7482226732709, -122.461906191942) | ||
116977 | 116977 | 371 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
117092 | 117092 | 113150 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 45 BRONTE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6009384.0 | 2097185.0 | 37.7390003361927 | -122.410078062228 | (37.7390003361927, -122.410078062228) | |||
117801 | 117801 | 27532 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
119676 | 119676 | 6389 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 40 Entrada Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60M | 5992282.41809 | 2092443.27672 | 37.725007378570105 | -122.468861992007 | (37.7250073785701, -122.468861992007) | |||
122391 | 122391 | 374 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
123802 | 123802 | 97853 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 895 Indiana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
124243 | 124243 | 378 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
125133 | 125133 | 377 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 12 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
129416 | 129416 | 379 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
137793 | 137793 | 53580 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 148 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1973 12:00:00 AM | 34 | Permit Number 12426 | 5993993.6857199995 | 2114568.59854 | 37.7858565385613 | -122.46455217907699 | (37.7858565385613, -122.464552179077) | ||
139938 | 139938 | 97854 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 895 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
142585 | 142585 | 121092 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 30X Grand View Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000475.0 | 2103841.0 | 37.756772747069604 | -122.44135867200701 | (37.7567727470696, -122.441358672007) | ||||
147227 | 147227 | 240599 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3229 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6006780.56286 | 2103771.69804 | 37.75693965177221 | -122.41954675558 | (37.7569396517722, -122.41954675558) | |||
148844 | 148844 | 240603 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 609 28th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001924.96846 | 2099400.16705 | 37.7446617708161 | -122.43602639412799 | (37.7446617708161, -122.436026394128) | |||
149631 | 149631 | 197584 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 851 Indiana St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 10ft | 6014983.28625 | 2104495.6281 | 37.7593860298711 | -122.391229027092 | (37.7593860298711, -122.391229027092) | |||
169341 | 169341 | 197582 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 851 Indiana St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 10ft | 6014984.28202 | 2104444.32589 | 37.7592452203005 | -122.39122199711399 | (37.7592452203005, -122.391221997114) | |||
175534 | 175534 | 39823 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 2190 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 1 | Permit Number 41149 | 5982046.2311 | 2100191.8316 | 37.7456860925771 | -122.50482065715099 | (37.7456860925771, -122.504820657151) | |
177016 | 177016 | 39822 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 2190 46th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 1 | Permit Number 41149 | 5982045.5543 | 2100206.3838 | 37.7457260090551 | -122.504824075497 | (37.7457260090551, -122.504824075497) | |
182822 | 182822 | 39824 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 2190 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 1 | Permit Number 41149 | 5982047.2464 | 2100175.5874 | 37.745641550250895 | -122.504815942994 | (37.7456415502509, -122.504815942994) | |
183468 | 183468 | 187562 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 136 Alpha St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6010924.81275 | 2088138.49847 | 37.714246765754105 | -122.40411411319401 | (37.7142467657541, -122.404114113194) |
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");