Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, qAddress, SiteOrder, PlantDate, PlotSize, XCoord, YCoord, Latitude, Longitude, Location
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5751 | 5751 | 1741 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 5 | 6010277.5688 | 2121623.6186 | 37.8061531673047 | -122.408712111835 | (37.8061531673047, -122.408712111835) | |||
8258 | 8258 | 1740 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 5 | 6010239.3355 | 2121619.2312 | 37.8061389791251 | -122.408844115422 | (37.8061389791251, -122.408844115422) | |||
8654 | 8654 | 1742 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 5 | 6010362.8102 | 2121638.0345 | 37.8061975236724 | -122.408418135849 | (37.8061975236724, -122.408418135849) | |||
15365 | 15365 | 29858 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1700X Evans Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 4X4 | 6014689.41423 | 2099276.62431 | 37.7450394402319 | -122.391880446552 | (37.7450394402319, -122.391880446552) | |||
27174 | 27174 | 24392 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 699X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/21/1995 12:00:00 AM | 12 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | ||
49592 | 49592 | 11636 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 499X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | |||
77867 | 77867 | 12494 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 307 Lake Merced Blvd | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
78443 | 78443 | 12480 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
80752 | 80752 | 24398 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/01/2000 12:00:00 AM | 12 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
84240 | 84240 | 12484 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
84989 | 84989 | 24399 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/15/1995 12:00:00 AM | 12 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
86056 | 86056 | 11659 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 699X Junipero Serra Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | |||
86802 | 86802 | 11655 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 699X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | |||
86822 | 86822 | 114840 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2455x HYDE ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3x3 | 6006980.0 | 2120877.0 | 37.803917898432395 | -122.42007090461901 | (37.8039178984324, -122.420070904619) | ||||
87807 | 87807 | 17661 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | |||
91597 | 91597 | 12475 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
92392 | 92392 | 24401 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/17/2001 12:00:00 AM | 12 | 3X3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
93732 | 93732 | 11634 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 499X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | |||
95471 | 95471 | 24391 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 699X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/21/1995 12:00:00 AM | 12 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | ||
96684 | 96684 | 12468 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
96901 | 96901 | 12482 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
97364 | 97364 | 1754 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 5 | 6010168.4492363 | 2121611.1016263003 | 37.8061126865638 | -122.409088856241 | (37.8061126865638, -122.409088856241) | |||
97827 | 97827 | 1726 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
97919 | 97919 | 11876 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1501X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | |||
97990 | 97990 | 11657 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 699X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | |||
98709 | 98709 | 12472 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
100151 | 100151 | 27800 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 799X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/17/2001 12:00:00 AM | 12 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
105606 | 105606 | 11715 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/15/1995 12:00:00 AM | 12 | 3X3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
108860 | 108860 | 24456 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/22/1995 12:00:00 AM | 12 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
110250 | 110250 | 24414 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/23/1995 12:00:00 AM | 12 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
111936 | 111936 | 11787 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
111984 | 111984 | 12478 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
112455 | 112455 | 11817 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 5991184.5559808 | 2089595.7938424998 | 37.7171254042551 | -122.47244964923901 | (37.7171254042551, -122.472449649239) | |||
113404 | 113404 | 12479 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
115085 | 115085 | 12473 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
115308 | 115308 | 1723 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
117411 | 117411 | 17659 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | |||
117588 | 117588 | 11721 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 899X Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | |||
117787 | 117787 | 24405 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 999X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/28/2000 12:00:00 AM | 12 | 3X3 | 5991260.9047733005 | 2090529.2081036 | 37.719692749400394 | -122.47225375374799 | (37.7196927494004, -122.472253753748) | ||
118144 | 118144 | 11649 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 699X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | |||
118813 | 118813 | 12477 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
118852 | 118852 | 11820 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1299X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991432.171815401 | 2088660.0347764 | 37.7145703669544 | -122.47152561846501 | (37.7145703669544, -122.471525618465) | |||
119036 | 119036 | 1755 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 5 | 6010168.4492363 | 2121611.1016263003 | 37.8061126865638 | -122.409088856241 | (37.8061126865638, -122.409088856241) | |||
124190 | 124190 | 11727 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/15/1995 12:00:00 AM | 12 | 3X3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
124901 | 124901 | 12497 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 42 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
125491 | 125491 | 17660 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | |||
125704 | 125704 | 11772 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/23/1995 12:00:00 AM | 12 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
126259 | 126259 | 1728 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3x9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
126959 | 126959 | 12498 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
127942 | 127942 | 24412 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/23/1995 12:00:00 AM | 12 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
139267 | 139267 | 11650 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 699X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | |||
144393 | 144393 | 11724 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/17/2001 12:00:00 AM | 12 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
144673 | 144673 | 26172 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3x3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
145316 | 145316 | 12476 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) |
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");