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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
135119 | 135119 | 175224 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 762 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002402.88459 | 2087125.99028 | 37.710986797965 | -122.43349687280899 | (37.710986797965, -122.433496872809) | |||
137427 | 137427 | 118234 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 590 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5984132.17313 | 2111832.6704599997 | 37.7777710528241 | -122.498467578545 | (37.7777710528241, -122.498467578545) | |||
137574 | 137574 | 203600 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 200 Minerva St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994977.66041 | 2089033.8898200002 | 37.7158013626108 | -122.45929811561399 | (37.7158013626108, -122.459298115614) | |||
138740 | 138740 | 69064 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1359 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | Permit Number 773642 | 5992377.26935607 | 2106205.46978928 | 37.7628003299421 | -122.469535465436 | (37.7628003299421, -122.469535465436) | |
140457 | 140457 | 108526 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1677 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773677 | 5990566.2613699995 | 2103985.48594 | 37.7566000147891 | -122.47563692717699 | (37.7566000147891, -122.475636927177) |
141314 | 141314 | 114969 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 200X MINERVA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5994532.0 | 2089023.0 | 37.7157458289959 | -122.460837724068 | (37.7157458289959, -122.460837724068) | |||
143315 | 143315 | 101003 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2801X Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2012 12:00:00 AM | 3x3 | Permit Number 769246 | 6003500.6 | 2117942.3 | 37.795663322696704 | -122.43190190430201 | (37.7956633226967, -122.431901904302) | ||
144567 | 144567 | 109033 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2120 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772816 | 5987671.1 | 2103767.6 | 37.755833493421704 | -122.48563331933 | (37.7558334934217, -122.48563331933) |
145912 | 145912 | 203606 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1570 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992477.77859 | 2104773.12978 | 37.7588733092773 | -122.46908359384199 | (37.7588733092773, -122.469083593842) | |||
146397 | 146397 | 221963 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 4086 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002569.41757 | 2102410.84038 | 37.7529649603686 | -122.434013186153 | (37.7529649603686, -122.434013186153) | |||
146428 | 146428 | 123227 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 790 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 5993222.74872 | 2110119.7569 | 37.7735967518389 | -122.46689584772301 | (37.7735967518389, -122.466895847723) | |||
146524 | 146524 | 189229 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1459 Rhode Island St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6012049.051519999 | 2101579.4163599997 | 37.7512154759161 | -122.40117218884899 | (37.7512154759161, -122.401172188849) | ||||
147451 | 147451 | 203591 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1677 18th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990564.22398 | 2103984.5948 | 37.7565974498416 | -122.475643908062 | (37.7565974498416, -122.475643908062) | |||
148279 | 148279 | 221942 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 133 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6007406.60903 | 2096997.58914 | 37.738374717426204 | -122.41690171544501 | (37.7383747174262, -122.416901715445) | |||
149824 | 149824 | 203603 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 533 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995027.64484 | 2088883.389 | 37.7153909965718 | -122.459114456087 | (37.7153909965718, -122.459114456087) | |||
150141 | 150141 | 125560 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 20 Mallorca Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001979.154630001 | 2119935.63772 | 37.8010501391173 | -122.437309169106 | (37.8010501391173, -122.437309169106) | |||
150491 | 150491 | 204746 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 624 Congo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6000138.084559999 | 2095837.9726 | 37.734779151424796 | -122.441949441533 | (37.7347791514248, -122.441949441533) | |||
150529 | 150529 | 189236 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1700 Bancroft Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6013792.02021 | 2092615.53995 | 37.7266996169689 | -122.39451715893499 | (37.7266996169689, -122.394517158935) | |||
150968 | 150968 | 203605 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 556 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5993274.01352 | 2090867.72296 | 37.720738530042205 | -122.46531978898999 | (37.7207385300422, -122.46531978899) | |||
153354 | 153354 | 203597 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 50 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995113.8822800005 | 2091909.7950400002 | 37.723705745105796 | -122.45903538769 | (37.7237057451058, -122.45903538769) | |||
156150 | 156150 | 203608 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2007 15th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5991583.6607 | 2101714.46197 | 37.7504233054064 | -122.471952911395 | (37.7504233054064, -122.471952911395) | |||
157767 | 157767 | 125567 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2809 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6003482.8439 | 2118067.55033 | 37.7960062212666 | -122.431972291689 | (37.7960062212666, -122.431972291689) | |||
159483 | 159483 | 221944 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 375 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6007244.42247 | 2096286.76622 | 37.7364138302231 | -122.417412117593 | (37.7364138302231, -122.417412117593) | |||
159774 | 159774 | 175225 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 762 Prague St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002385.00148 | 2087111.8293299999 | 37.7109469004454 | -122.43355766966299 | (37.7109469004454, -122.433557669663) | |||
160500 | 160500 | 189234 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1919 22nd St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6012405.15003 | 2103734.72302 | 37.757153337862206 | -122.400092102164 | (37.7571533378622, -122.400092102164) | |||
160726 | 160726 | 37181 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2519 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1998 12:00:00 AM | 7 | Permit Number 39755 | 6001865.38269 | 2116985.0366700003 | 37.792942091651796 | -122.437491453568 | (37.7929420916518, -122.437491453568) | ||
161097 | 161097 | 125566 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2809 Buchanan St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6003481.18787 | 2118079.55095 | 37.7960390779962 | -122.431978879228 | (37.7960390779962, -122.431978879228) | |||
163497 | 163497 | 108895 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 666 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | 1 | 3x3 | Permit Number 774994 | 5987872.85836 | 2111424.89012 | 37.7768700551182 | -122.48549748779399 | (37.7768700551182, -122.485497487794) | |
165489 | 165489 | 125564 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 165 Marina Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 7ft | 6002712.8181 | 2121563.83713 | 37.805562426341 | -122.434886887435 | (37.805562426341, -122.434886887435) | |||
168365 | 168365 | 221947 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 689 Ogden Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6007672.8407 | 2096154.7937900003 | 37.7360755583335 | -122.41592154886101 | (37.7360755583335, -122.415921548861) | |||
168407 | 168407 | 189237 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1700 Bancroft Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6013775.5681 | 2092627.0535099998 | 37.726730316242296 | -122.394574839671 | (37.7267303162423, -122.394574839671) | |||
169286 | 169286 | 221958 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 779 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008100.58194 | 2095693.3071 | 37.7348324551576 | -122.414410025905 | (37.7348324551576, -122.414410025905) | |||
169684 | 169684 | 81047 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 961 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 2 | 6001634.7016900005 | 2086773.55642 | 37.7099754779527 | -122.436126687404 | (37.7099754779527, -122.436126687404) | ||
171871 | 171871 | 175222 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 300 Gaven St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6008975.9211800005 | 2094875.47718 | 37.7326360049484 | -122.411325907078 | (37.7326360049484, -122.411325907078) | |||
174263 | 174263 | 221950 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 31 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006097.6775 | 2099053.5817299997 | 37.7439462971915 | -122.421573349947 | (37.7439462971915, -122.421573349947) | |||
174756 | 174756 | 203615 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 240 Colon Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5996037.383230001 | 2094398.48179 | 37.7305921283128 | -122.45602285758899 | (37.7305921283128, -122.456022857589) | |||
176518 | 176518 | 189232 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1919 22nd St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6012390.797040001 | 2103733.87239 | 37.7571502019395 | -122.40014168090799 | (37.7571502019395, -122.400141680908) | |||
176692 | 176692 | 203607 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2007 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5991582.5756 | 2101730.87003 | 37.750468294886296 | -122.471957859468 | (37.7504682948863, -122.471957859468) | |||
177564 | 177564 | 221940 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 168 Tiffany Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6006049.87669 | 2099255.63478 | 37.7444983936957 | -122.421752983209 | (37.7444983936957, -122.421752983209) | |||
177619 | 177619 | 203602 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 601 Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5995030.39824 | 2089062.5673099998 | 37.7158831361758 | -122.45911790587799 | (37.7158831361758, -122.459117905878) | |||
177821 | 177821 | 175217 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1601 San Jose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6001607.87231 | 2094169.8653099998 | 37.7302825582951 | -122.436748518241 | (37.7302825582951, -122.436748518241) | ||||
177938 | 177938 | 70277 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 481 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/06/2012 12:00:00 AM | 2 | Permit Number 768624 | 5985297.751569999 | 2112660.9809 | 37.78011363845471 | -122.49449657583901 | (37.7801136384547, -122.494496575839) | |
178785 | 178785 | 125565 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1907 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 5999924.7797300005 | 2115560.6496599996 | 37.7889205779801 | -122.44410362179501 | (37.7889205779801, -122.444103621795) | |||
179068 | 179068 | 175218 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 93 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6001014.57653 | 2087970.42853 | 37.713226572126295 | -122.43835564452101 | (37.7132265721263, -122.438355644521) | |||
180257 | 180257 | 189221 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1310 Indiana St | 14 | : Yard 23 | Tree 1 | Private 1 | 1 | 6015010.96324 | 2102373.3642599997 | 37.7535602828051 | -122.39098497537901 | (37.7535602828051, -122.390984975379) | ||||
180671 | 180671 | 221948 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 633 Capp St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6007312.78593 | 2103619.1206099996 | 37.75655067338779 | -122.417695309584 | (37.7565506733878, -122.417695309584) | |||
181110 | 181110 | 203599 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 200 Minerva St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994990.6649400005 | 2089034.05641 | 37.715802567698105 | -122.459253178313 | (37.7158025676981, -122.459253178313) | |||
182032 | 182032 | 121978 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 200 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5991208.0697800005 | 2113958.75361 | 37.7840210969883 | -122.474145024774 | (37.7840210969883, -122.474145024774) | |||
182579 | 182579 | 189230 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1919 22nd St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6012335.96177 | 2103730.27512 | 37.7571372669841 | -122.400331070924 | (37.7571372669841, -122.400331070924) | |||
183483 | 183483 | 99289 | Significant Tree 6 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 845 Marina Blvd | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/05/2012 12:00:00 AM | 1 | Permit Number 768788 | 5998887.79124 | 2121333.18312 | 37.8047111982366 | -122.448107254257 | (37.8047111982366, -122.448107254257) | ||
184134 | 184134 | 221954 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 10 Mateo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003651.78928 | 2096634.4220599998 | 37.737165621192204 | -122.42985814834101 | (37.7371656211922, -122.429858148341) | |||
187046 | 187046 | 203611 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 146 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992953.888809999 | 2101207.94105 | 37.7491117215315 | -122.467177780245 | (37.7491117215315, -122.467177780245) | |||
188961 | 188961 | 203619 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 624 Congo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6000138.382019999 | 2095835.3347200002 | 37.7347719253748 | -122.441948223841 | (37.7347719253748, -122.441948223841) |
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");