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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2932 | 2932 | 142166 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1477 GROVE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6000715.4928 | 2110652.1954 | 37.7754882965725 | -122.44101558938699 | (37.7754882965725, -122.441015589387) | |||
18000 | 18000 | 62553 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 932 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22750 | 6002100.93353536 | 2109504.64892618 | 37.77241623268171 | -122.436140888716 | (37.7724162326817, -122.436140888716) | ||
19615 | 19615 | 62550 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 851 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22746 | 6002504.62213879 | 2109507.36231307 | 37.7724466097716 | -122.43474468696999 | (37.7724466097716, -122.43474468697) | ||
20389 | 20389 | 62561 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 263 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22761 | 6002735.54596737 | 2109434.34982555 | 37.7722592430025 | -122.433940680004 | (37.7722592430025, -122.433940680004) | ||
66111 | 66111 | 54159 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 262 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | 13 | Permit Number 9894 | 6012942.04708 | 2095291.8384200002 | 37.7340008934128 | -122.397643138528 | (37.7340008934128, -122.397643138528) | ||
78422 | 78422 | 87313 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 230 Broderick St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2008 12:00:00 AM | 3x3 | Permit Number 768785 | 6005882.0 | 2110375.0 | 37.775020098006294 | -122.423123675956 | (37.7750200980063, -122.423123675956) | ||
82102 | 82102 | 101131 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1477 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000788.3 | 2110635.6 | 37.775446876390205 | -122.44076254186001 | (37.7754468763902, -122.44076254186) | ||||
82454 | 82454 | 63210 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 3601 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | Permit Number 23753 | 5984371.56597884 | 2113133.02236934 | 37.7813554779566 | -122.497735487323 | (37.7813554779566, -122.497735487323) | ||
82824 | 82824 | 86923 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 195 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49881 | 6004763.0 | 2102539.0 | 37.7534411018365 | -122.426436480741 | (37.7534411018365, -122.426436480741) | |||
83308 | 83308 | 85506 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1 Nebraska St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
85992 | 85992 | 62564 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 401 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22765 | 6001708.19271751 | 2109769.06982879 | 37.7731199456311 | -122.437518353384 | (37.7731199456311, -122.437518353384) | ||
86806 | 86806 | 23658 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 302 Virginia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1997 12:00:00 AM | 8 | 3X3 | 6006870.1278442005 | 2098321.8073815 | 37.7419805343744 | -122.418850499491 | (37.7419805343744, -122.418850499491) | ||
87896 | 87896 | 85505 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1 Nebraska St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | |||||
88830 | 88830 | 56310 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 178 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1984 12:00:00 AM | Permit Number 21650 | 5993077.11990526 | 2114307.36148956 | 37.7850863731263 | -122.467704208587 | (37.7850863731263, -122.467704208587) | ||
89303 | 89303 | 64732 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 259 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/28/1988 12:00:00 AM | Permit Number 25691 | 6001783.83117373 | 2109148.55885484 | 37.77142047705029 | -122.43721227336701 | (37.7714204770503, -122.437212273367) | ||
90517 | 90517 | 44253 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1375 Evans Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2001 12:00:00 AM | Permit Number 43687 | 6016852.68384064 | 2097573.05225711 | 37.7404816352752 | -122.38428155142701 | (37.7404816352752, -122.384281551427) | |||
91149 | 91149 | 62544 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 251 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22739 | 6001803.31467833 | 2109086.42479932 | 37.771250979895704 | -122.43714042967301 | (37.7712509798957, -122.437140429673) | ||
93125 | 93125 | 12858 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 2455 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 5987787.46088 | 2114620.72752 | 37.7856399434951 | -122.486027545007 | (37.7856399434951, -122.486027545007) | |||
93509 | 93509 | 62552 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 925 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22749 | 6002145.34756636 | 2109458.3701838003 | 37.7722916859717 | -122.435983944483 | (37.7722916859717, -122.435983944483) | ||
95422 | 95422 | 65918 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1346 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | Permit Number 28933 | 5994594.09113824 | 2106359.56698751 | 37.763351309716604 | -122.46187948930901 | (37.7633513097166, -122.461879489309) | ||
97823 | 97823 | 44252 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1375 Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2001 12:00:00 AM | Permit Number 43687 | 6016852.68384064 | 2097573.05225711 | 37.7404816352752 | -122.38428155142701 | (37.7404816352752, -122.384281551427) | |||
100519 | 100519 | 62546 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 324 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22741 | 6001810.43023006 | 2109526.13327918 | 37.7724587144958 | -122.43714730421101 | (37.7724587144958, -122.437147304211) | ||
104319 | 104319 | 100365 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 450X Baker St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 769344 | 6000745.0 | 2110655.0 | 37.7754976778855 | -122.44091371844 | (37.7754976778855, -122.44091371844) | ||||
104461 | 104461 | 30294 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 2705 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1956 12:00:00 AM | Permit Number 137 | 6003541.5840662 | 2117604.65844184 | 37.7947385690082 | -122.43173597331999 | (37.7947385690082, -122.43173597332) | |||
104616 | 104616 | 63746 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 963 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24418 | 6001968.69414602 | 2109433.58921739 | 37.772213606480605 | -122.43659322947201 | (37.7722136064806, -122.436593229472) | ||
104951 | 104951 | 62548 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 364 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22743 | 6001791.89658849 | 2109658.78296356 | 37.7728218839519 | -122.437220913321 | (37.7728218839519, -122.437220913321) | ||
107394 | 107394 | 59644 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 865 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22747 | 6002440.7343378 | 2109498.78550878 | 37.772419432694505 | -122.434965067297 | (37.7724194326945, -122.434965067297) | ||
108904 | 108904 | 62556 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1009 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22755 | 6001742.0 | 2109408.0 | 37.7721304598957 | -122.437375549988 | (37.7721304598957, -122.437375549988) | ||
109120 | 109120 | 30340 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 175 Granville Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/1956 12:00:00 AM | Permit Number 26 | 5994414.04695782 | 2098601.44324242 | 37.7420391129783 | -122.461939590962 | (37.7420391129783, -122.461939590962) | |||
109306 | 109306 | 62558 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 240 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1992 12:00:00 AM | Permit Number 30458 | 6002321.70129221 | 2109304.4334506 | 37.771879030768 | -122.43536290851999 | (37.771879030768, -122.43536290852) | ||
109387 | 109387 | 65122 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 328 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | Permit Number 27092 | 5989675.82756959 | 2113141.97698014 | 37.7816895771658 | -122.47938619127399 | (37.7816895771658, -122.479386191274) | ||
112106 | 112106 | 35038 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 955 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/16/1998 12:00:00 AM | Permit Number 38604 | 6002005.88434069 | 2109438.80626308 | 37.772230044530396 | -122.436464959051 | (37.7722300445304, -122.436464959051) | ||
113489 | 113489 | 34853 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 85 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/01/1997 12:00:00 AM | Permit Number 38476 | 6001445.41488356 | 2093713.29123004 | 37.7290196763486 | -122.437277475077 | (37.7290196763486, -122.437277475077) | ||
115717 | 115717 | 30311 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 860 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 9 | 5983275.48572939 | 2109941.19024403 | 37.7725273211727 | -122.50129116256599 | (37.7725273211727, -122.501291162566) | ||||
116604 | 116604 | 40632 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1385 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1999 12:00:00 AM | Permit Number 41908 | 5999539.52102625 | 2107847.36223217 | 37.7677198855431 | -122.44488187524901 | (37.7677198855431, -122.444881875249) | |||
118552 | 118552 | 62554 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 950 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22751 | 6002017.25559301 | 2109492.91057277 | 37.772379247666 | -122.436429497983 | (37.772379247666, -122.436429497983) | ||
118783 | 118783 | 12824 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 2201 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 5 | 5988584.5219 | 2114647.3917900003 | 37.785759574315705 | -122.48327193233 | (37.7857595743157, -122.48327193233) | |||
118915 | 118915 | 62557 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 231 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22756 | 6002274.80033002 | 2109264.35337792 | 37.7717663171547 | -122.435522274291 | (37.7717663171547, -122.435522274291) | ||
120126 | 120126 | 63217 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 3621 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | Permit Number 23761 | 5984312.74399006 | 2113130.81658791 | 37.78134597315321 | -122.497938816629 | (37.7813459731532, -122.497938816629) | ||
121421 | 121421 | 61492 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 171 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/1984 12:00:00 AM | Permit Number 21441 | 5989584.76357215 | 2114231.48161607 | 37.7846757617561 | -122.479780973493 | (37.7846757617561, -122.479780973493) | ||
121534 | 121534 | 62547 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 339 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22742 | 6001725.06048849 | 2109561.60697562 | 37.772551263359 | -122.43744514665 | (37.772551263359, -122.43744514665) | ||
121565 | 121565 | 63206 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 3641 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | Permit Number 23748 | 5984253.92200128 | 2113128.61080648 | 37.7813364679992 | -122.498142145884 | (37.7813364679992, -122.498142145884) | ||
125223 | 125223 | 65914 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 431 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | Permit Number 28924 | 5994447.75768828 | 2106990.5338514 | 37.7650753550186 | -122.462431373492 | (37.7650753550186, -122.462431373492) | ||
125545 | 125545 | 62551 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 873 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22748 | 6002404.22700345 | 2109493.88447514 | 37.7724039027427 | -122.435090998906 | (37.7724039027427, -122.435090998906) | ||
127934 | 127934 | 30293 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 2101 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1956 12:00:00 AM | Permit Number 136 | 6003511.17021246 | 2117907.12338032 | 37.795567335959 | -122.43186281655198 | (37.795567335959, -122.431862816552) | |||
137750 | 137750 | 53938 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 178 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1972 12:00:00 AM | 13 | Permit Number 9652 | 5993071.23757 | 2114298.66075 | 37.7850621436327 | -122.467723926434 | (37.7850621436327, -122.467723926434) | ||
138273 | 138273 | 34992 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 829 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/17/2000 12:00:00 AM | Permit Number 38570 | 5998631.01806421 | 2107405.55103252 | 37.7664548933778 | -122.447992448577 | (37.7664548933778, -122.447992448577) | ||
139830 | 139830 | 101135 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1477 Grove St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000788.3 | 2110635.6 | 37.775446876390205 | -122.44076254186001 | (37.7754468763902, -122.44076254186) | ||||
140069 | 140069 | 36668 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 973 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1998 12:00:00 AM | Permit Number 39474 | 6001922.20638095 | 2109427.06790723 | 37.7721930587125 | -122.436753567493 | (37.7721930587125, -122.436753567493) | ||
141389 | 141389 | 61500 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 155 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1984 12:00:00 AM | Permit Number 21453 | 5989580.98367675 | 2114335.37160458 | 37.784960794856 | -122.47980165523799 | (37.784960794856, -122.479801655238) | ||
141880 | 141880 | 45128 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 232 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2001 12:00:00 AM | Permit Number 43985 | 6004034.46486858 | 2105728.24125402 | 37.7621567917777 | -122.429183297925 | (37.7621567917777, -122.429183297925) | |||
142959 | 142959 | 62555 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 968 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22753 | 6001933.57765066 | 2109481.17221936 | 37.7723422619436 | -122.43671810696199 | (37.7723422619436, -122.436718106962) | ||
143512 | 143512 | 53569 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 718 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/1988 12:00:00 AM | Permit Number 6489 | 6002262.08955542 | 2108831.48537983 | 37.7705770468004 | -122.435535269571 | (37.7705770468004, -122.435535269571) |
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");