Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 133964 | 133964 | 114471 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2351 Powell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009306.05236 | 2121599.3882299997 | 37.806032175519 | -122.41207250624599 | (37.806032175519, -122.412072506246) | |||
| 32498 | 32498 | 136953 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 685 North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6007628.69919 | 2121609.81563 | 37.8059665519739 | -122.41787801227 | (37.8059665519739, -122.41787801227) | |||
| 176525 | 176525 | 136952 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 685 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6007607.689119999 | 2121607.56476 | 37.8059591892382 | -122.417950561469 | (37.8059591892382, -122.417950561469) | |||
| 153111 | 153111 | 136951 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 685 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6007589.5511300005 | 2121604.68053 | 37.8059502490578 | -122.418013126415 | (37.8059502490578, -122.418013126415) | |||
| 73088 | 73088 | 136950 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 685 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6007570.27525 | 2121602.58608 | 37.805943413335 | -122.41807968522801 | (37.805943413335, -122.418079685228) | |||
| 168983 | 168983 | 68254 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3835 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32056 | 6000569.04912 | 2121537.58273 | 37.8053683895105 | -122.44230379238199 | (37.8053683895105, -122.442303792382) | |
| 186958 | 186958 | 136934 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 685 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5999739.15861 | 2121538.2964 | 37.805323015109 | -122.445175778246 | (37.805323015109, -122.445175778246) | |||
| 36902 | 36902 | 136926 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3835 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6000573.99959 | 2121502.15962 | 37.805271409309 | -122.442284116143 | (37.805271409309, -122.442284116143) | |||
| 71395 | 71395 | 136927 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3835 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6000575.8794 | 2121488.3697200003 | 37.8052336530829 | -122.44227662028 | (37.8052336530829, -122.44227662028) | |||
| 27116 | 27116 | 136928 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3835 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6000577.85991 | 2121479.43113 | 37.8052092229902 | -122.442269124421 | (37.8052092229902, -122.442269124421) | |||
| 163030 | 163030 | 136929 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3825 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6000583.85394 | 2121442.09911 | 37.8051070609006 | -122.442245699797 | (37.8051070609006, -122.442245699797) | |||
| 163334 | 163334 | 136930 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3825 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6000585.214790001 | 2121429.39855 | 37.8050722661295 | -122.442240078135 | (37.8050722661295, -122.442240078135) | |||
| 38435 | 38435 | 136931 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3825 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6000586.31642 | 2121417.2428200003 | 37.805038952541295 | -122.442235392672 | (37.8050389525413, -122.442235392672) | |||
| 37968 | 37968 | 136932 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3825 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6000587.38423 | 2121403.46977 | 37.8050011962985 | -122.442230708079 | (37.8050011962985, -122.442230708079) | |||
| 6649 | 6649 | 114581 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1501 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 3 | 3x3 | 6002967.5258 | 2121305.9196 | 37.8048687108976 | -122.433986988903 | (37.8048687108976, -122.433986988903) | ||
| 2218 | 2218 | 114579 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1501 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 3 | 3x3 | 6002950.36974 | 2121305.2817599997 | 37.8048659859314 | -122.43404631360701 | (37.8048659859314, -122.434046313607) | ||
| 182275 | 182275 | 136954 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 130 Chestnut St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011359.28517 | 2121128.07702 | 37.8048530581732 | -122.404933719313 | (37.8048530581732, -122.404933719313) | |||
| 152635 | 152635 | 136916 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1921 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6000038.63255 | 2121244.89177 | 37.804534494021794 | -122.444118317601 | (37.8045344940218, -122.444118317601) | |||
| 6827 | 6827 | 100292 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3701 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003061.81659 | 2121064.97367 | 37.804212487284005 | -122.43364345509701 | (37.804212487284, -122.433643455097) | |||
| 67087 | 67087 | 136917 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1921 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6000998.90013 | 2120967.06154 | 37.803826380442096 | -122.44077529025499 | (37.8038263804421, -122.440775290255) | |||
| 52023 | 52023 | 68238 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 290 Avila St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32036 | 6000949.5088599995 | 2120925.17442 | 37.8037085566624 | -122.440943204485 | (37.8037085566624, -122.440943204485) | |
| 136729 | 136729 | 136918 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001921.35919 | 2120601.2758299997 | 37.8028745199931 | -122.437556861278 | (37.8028745199931, -122.437556861278) | |||
| 37559 | 37559 | 35018 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 15 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1997 12:00:00 AM | 10 | Permit Number 38593 | 6001898.27273 | 2120571.24867 | 37.8027907607435 | -122.437634600462 | (37.8027907607435, -122.437634600462) | ||
| 27006 | 27006 | 35019 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 27 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1997 12:00:00 AM | 10 | Permit Number 38594 | 6001880.48988 | 2120550.7716599996 | 37.8027335251878 | -122.437694670695 | (37.8027335251878, -122.437694670695) | ||
| 135300 | 135300 | 136946 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2314 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007580.00557 | 2120367.1472 | 37.802551758716795 | -122.417958377487 | (37.8025517587168, -122.417958377487) | |||
| 84063 | 84063 | 95878 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 815 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3x3 | Permit Number 767594 | 6008458.0 | 2120343.0 | 37.8025348309413 | -122.414918358575 | (37.8025348309413, -122.414918358575) | |
| 96745 | 96745 | 95879 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 815 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3x3 | Permit Number 767594 | 6008458.0 | 2120343.0 | 37.8025348309413 | -122.414918358575 | (37.8025348309413, -122.414918358575) | |
| 36728 | 36728 | 136945 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 805 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008467.13732 | 2120338.97067 | 37.802524280839705 | -122.414886453447 | (37.8025242808397, -122.414886453447) | |||
| 175859 | 175859 | 136944 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 805 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008422.88956 | 2120335.2462 | 37.802511568003396 | -122.415039309443 | (37.8025115680034, -122.415039309443) | |||
| 149884 | 149884 | 68246 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3475 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32046 | 6001228.52061 | 2120448.06456 | 37.8024144268505 | -122.43994344164301 | (37.8024144268505, -122.439943441643) | |
| 153986 | 153986 | 68245 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3471 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32045 | 6001229.5729 | 2120436.05695 | 37.802381517044104 | -122.439938938746 | (37.8023815170441, -122.439938938746) | |
| 75885 | 75885 | 61991 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3248 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2009 12:00:00 AM | 3 | 3x3 | Permit Number 53013 | 6004180.24361 | 2120367.1099099996 | 37.80235973099071 | -122.429723248223 | (37.8023597309907, -122.429723248223) | |
| 23614 | 23614 | 41167 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 162 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52563 | 6001487.6244 | 2120266.34307 | 37.801930213864104 | -122.439033785505 | (37.8019302138641, -122.439033785505) |
| 58932 | 58932 | 40193 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3430 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41376 | 6000802.81629 | 2120169.1836 | 37.801624451566894 | -122.441396561715 | (37.8016244515669, -122.441396561715) | ||
| 156734 | 156734 | 93732 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 29 Toledo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53317 | 6001786.6027 | 2120087.22199 | 37.80145540150679 | -122.4379863442 | (37.8014554015068, -122.4379863442) | |
| 8240 | 8240 | 111918 | Section 143 8 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 41 Toledo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773012 | 6001705.38657 | 2120044.83908 | 37.801334410325104 | -122.438264349848 | (37.8013344103251, -122.438264349848) | |
| 29520 | 29520 | 32018 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 729 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | 11 | Permit Number 35411 | 6009321.52864 | 2119764.77649 | 37.800995657295395 | -122.41188922351101 | (37.8009956572954, -122.411889223511) | ||
| 6209 | 6209 | 91354 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2131 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 52063 | 6007623.63084 | 2119707.2305900003 | 37.8007422490107 | -122.417760608464 | (37.8007422490107, -122.417760608464) | |
| 187872 | 187872 | 136933 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2395 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999921.83043 | 2119840.52401 | 37.8006718131986 | -122.44442153123998 | (37.8006718131986, -122.44442153124) | |||
| 42471 | 42471 | 69532 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2395 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | 6 | Permit Number 38574 | 5999900.2494 | 2119838.00764 | 37.8006636725595 | -122.444496029289 | (37.8006636725595, -122.444496029289) | ||
| 39512 | 39512 | 106411 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2159 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2014 12:00:00 AM | 1 | Permit Number 772621 | 6001561.17582 | 2119720.78456 | 37.8004364390406 | -122.438740147849 | (37.8004364390406, -122.438740147849) | ||
| 26555 | 26555 | 86964 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1501 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49931 | 6005636.01311 | 2119594.66675 | 37.800321125284704 | -122.424630586241 | (37.8003211252847, -122.424630586241) | |
| 38531 | 38531 | 86963 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1501 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49931 | 6005615.529680001 | 2119592.0276 | 37.8003127220137 | -122.42470127923401 | (37.8003127220137, -122.424701279234) | |
| 130025 | 130025 | 86962 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1501 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49931 | 6005583.80887 | 2119587.99899 | 37.8002998689051 | -122.424810759115 | (37.8002998689051, -122.424810759115) | |
| 29107 | 29107 | 86900 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1515 Greenwich St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49845 | 6005565.12531 | 2119584.9629 | 37.8002904772924 | -122.424875195545 | (37.8002904772924, -122.424875195545) | |
| 24922 | 24922 | 86899 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1515 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49845 | 6005553.51523 | 2119583.04132 | 37.8002845453461 | -122.424915234248 | (37.8002845453461, -122.424915234248) | |
| 157463 | 157463 | 86898 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1515 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49845 | 6005535.39603 | 2119581.07384 | 37.8002781196847 | -122.424977793814 | (37.8002781196847, -122.424977793814) | |
| 129611 | 129611 | 86897 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1515 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49845 | 6005522.69818 | 2119578.99452 | 37.8002716931447 | -122.425021585387 | (37.8002716931447, -122.425021585387) | |
| 74657 | 74657 | 86896 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1515 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49845 | 6005504.575019999 | 2119576.847 | 37.8002647728594 | -122.42508414582 | (37.8002647728594, -122.42508414582) | |
| 60666 | 60666 | 55294 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1539 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50106 | 6005486.07569 | 2119573.98699 | 37.80025587497521 | -122.425147957212 | (37.8002558749752, -122.425147957212) | |
| 68773 | 68773 | 86912 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1555 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49877 | 6005411.55149 | 2119563.27815 | 37.800222261013495 | -122.42540507790501 | (37.8002222610135, -122.425405077905) | |
| 7427 | 7427 | 83207 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1630 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | Permit Number 772967 | 6005062.56265 | 2119560.0197 | 37.8001935906169 | -122.426612484272 | (37.8001935906169, -122.426612484272) | |
| 8700 | 8700 | 94740 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3208 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53872 | 6001386.25296 | 2119488.63139 | 37.799789054867794 | -122.439328800002 | (37.7997890548678, -122.439328800002) | |
| 159247 | 159247 | 96923 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3208 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767943 | 6001389.811290001 | 2119472.57497 | 37.7997451706686 | -122.439315335361 | (37.7997451706686, -122.439315335361) | |
| 23639 | 23639 | 51486 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2576 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2005 12:00:00 AM | 7 | Permit Number 47799 | 5999551.99541 | 2119490.69699 | 37.799690173532 | -122.445676136766 | (37.799690173532, -122.445676136766) | ||
| 66456 | 66456 | 51487 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2576 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2005 12:00:00 AM | 7 | Permit Number 47799 | 5999531.677519999 | 2119487.78648 | 37.7996810220155 | -122.44574623442101 | (37.7996810220155, -122.445746234421) | ||
| 62572 | 62572 | 96922 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3208 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767943 | 6001392.66231 | 2119445.8775400002 | 37.799672028811 | -122.43930355514 | (37.799672028811, -122.43930355514) | |
| 178966 | 178966 | 96921 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3208 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767943 | 6001394.57427 | 2119432.51874 | 37.799635457872704 | -122.43929598102501 | (37.7996354578727, -122.439295981025) | |
| 80373 | 80373 | 29737 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 644 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 6 | 3x3 | 6009876.05646 | 2119220.3393 | 37.7995318614036 | -122.409931857518 | (37.7995318614036, -122.409931857518) | ||
| 97282 | 97282 | 29732 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 3 | 3x3 | 6010124.763619999 | 2119212.75369 | 37.7995249687162 | -122.40907070216998 | (37.7995249687162, -122.40907070217) | ||
| 105817 | 105817 | 29733 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 622 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/19/2006 12:00:00 AM | 6 | 3x3 | 6010024.1062535 | 2119210.3696422 | 37.799512783441 | -122.409418845912 | (37.799512783441, -122.409418845912) | ||
| 147132 | 147132 | 68240 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3235 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32038 | 6000367.65651 | 2119408.48932 | 37.799510988101396 | -122.442847752719 | (37.7995109881014, -122.442847752719) | |
| 101263 | 101263 | 52730 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2015 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/2006 12:00:00 AM | Permit Number 48785 | 6003257.686389 | 2119258.9998921 | 37.7992648663558 | -122.43283653798599 | (37.7992648663558, -122.432836537986) | ||
| 102062 | 102062 | 52731 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2015 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2006 12:00:00 AM | Permit Number 48785 | 6003257.686389 | 2119258.9998921 | 37.7992648663558 | -122.43283653798599 | (37.7992648663558, -122.432836537986) | |||
| 77386 | 77386 | 29759 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 699X Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6009685.79902 | 2119118.10904 | 37.7992404975665 | -122.41058299614099 | (37.7992404975665, -122.410582996141) | |||
| 97843 | 97843 | 29758 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 699X Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6009685.79902 | 2119118.10904 | 37.7992404975665 | -122.41058299614099 | (37.7992404975665, -122.410582996141) | |||
| 110018 | 110018 | 29757 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 699X Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3 | 6009685.79902 | 2119118.10904 | 37.7992404975665 | -122.41058299614099 | (37.7992404975665, -122.410582996141) | |||
| 35277 | 35277 | 136947 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 915 Front St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6012726.66985 | 2119026.8860400002 | 37.799160033972 | -122.400054056345 | (37.799160033972, -122.400054056345) | |||
| 155949 | 155949 | 136948 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 915 Front St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6012731.24873 | 2118997.87566 | 37.7990806337212 | -122.400036173353 | (37.7990806337212, -122.400036173353) | |||
| 48703 | 48703 | 136949 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 915 Front St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6012733.733109999 | 2118974.78929 | 37.7990173826009 | -122.400025954359 | (37.7990173826009, -122.400025954359) | |||
| 158976 | 158976 | 136924 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000 Lyon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999084.005580001 | 2119171.9569 | 37.7987882686341 | -122.44727259345301 | (37.7987882686341, -122.447272593453) | |||
| 4984 | 4984 | 44099 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1880 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774618 | 6003969.398019999 | 2119063.44467 | 37.798768262294395 | -122.43035980995701 | (37.7987682622944, -122.430359809957) | |
| 76587 | 76587 | 136923 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999086.92676 | 2119150.62372 | 37.7987298603595 | -122.447260949053 | (37.7987298603595, -122.447260949053) | |||
| 129631 | 129631 | 136922 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999089.06765 | 2119133.9695599996 | 37.798684254832004 | -122.44725234164801 | (37.798684254832, -122.447252341648) | |||
| 5559 | 5559 | 98004 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1908 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/2015 12:00:00 AM | 14 | 5x5 | Permit Number 775450 | 6003753.55269 | 2119031.9849799997 | 37.79866965343071 | -122.43110445762301 | (37.7986696534307, -122.431104457623) | |
| 184889 | 184889 | 136921 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999088.66759 | 2119114.7453799997 | 37.798631447529296 | -122.447252341645 | (37.7986314475293, -122.447252341645) | |||
| 8183 | 8183 | 112515 | Section 143 8 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2646 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6000218.93903 | 2118886.7143900003 | 37.7980698532985 | -122.443324869154 | (37.7980698532985, -122.443324869154) | |||
| 43543 | 43543 | 58803 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2246 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2013 12:00:00 AM | 2 | Permit Number 769648 | 6002177.82636 | 2118813.48385 | 37.7979802907265 | -122.436541316255 | (37.7979802907265, -122.436541316255) | ||
| 8949 | 8949 | 38494 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1345 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/11/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774878 | 6006577.84973 | 2118679.48452 | 37.797861412034294 | -122.42130642757401 | (37.7978614120343, -122.421306427574) |
| 159394 | 159394 | 33106 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2953 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37345 | 5999975.52574 | 2118733.08238 | 37.7976341371664 | -122.444156101749 | (37.7976341371664, -122.444156101749) | |
| 179499 | 179499 | 136925 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2940 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000022.969330001 | 2118690.77856 | 37.7975206885925 | -122.44398889348601 | (37.7975206885925, -122.443988893486) | |||
| 172491 | 172491 | 63900 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2584 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1987 12:00:00 AM | 11 | Permit Number 24610 | 6000600.04945 | 2118593.6977 | 37.7972870321295 | -122.441985077154 | (37.7972870321295, -122.441985077154) | ||
| 163180 | 163180 | 101682 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2584 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1987 12:00:00 AM | 12 | Permit Number 24610 | 6000585.65494 | 2118590.7735099997 | 37.7972781827952 | -122.44203467567301 | (37.7972781827952, -122.442034675673) | ||
| 187335 | 187335 | 33110 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2626 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37348 | 6000381.41365 | 2118563.70291 | 37.7971922129921 | -122.442739455458 | (37.7971922129921, -122.442739455458) | |
| 119886 | 119886 | 42616 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1796 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42679 | 6004448.07660587 | 2118435.96794997 | 37.7970724747469 | -122.428658673872 | (37.7970724747469, -122.428658673872) | ||
| 90288 | 90288 | 42615 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1791 Green St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42678 | 6004482.657553299 | 2118388.26400306 | 37.7969434489311 | -122.428535613258 | (37.7969434489311, -122.428535613258) | |||
| 91702 | 91702 | 42611 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1791 Green St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42678 | 6004482.657553299 | 2118388.26400306 | 37.7969434489311 | -122.428535613258 | (37.7969434489311, -122.428535613258) | |||
| 106556 | 106556 | 42614 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1791 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42678 | 6004482.657553299 | 2118388.26400306 | 37.7969434489311 | -122.428535613258 | (37.7969434489311, -122.428535613258) | |||
| 145769 | 145769 | 42613 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1791 Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42678 | 6004482.657553299 | 2118388.26400306 | 37.7969434489311 | -122.428535613258 | (37.7969434489311, -122.428535613258) | |||
| 7392 | 7392 | 61776 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2939 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1993 12:00:00 AM | 6 | 3x3 | 6000507.69204 | 2118417.15605 | 37.7967970320012 | -122.44229197620001 | (37.7967970320012, -122.4422919762) | ||
| 171114 | 171114 | 136915 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2301 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001927.36855 | 2118383.65644 | 37.796785861541096 | -122.43737717584101 | (37.7967858615411, -122.437377175841) | |||
| 6718 | 6718 | 97922 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2939 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000509.433540001 | 2118403.315 | 37.7967591273891 | -122.442284956098 | (37.7967591273891, -122.442284956098) | |||
| 65259 | 65259 | 136914 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2325 Union St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001866.38234 | 2118375.10794 | 37.7967589223518 | -122.437587589309 | (37.7967589223518, -122.437587589309) | |||
| 57296 | 57296 | 47722 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2325 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/28/2002 12:00:00 AM | 8 | Permit Number 45805 | 6001852.4852599995 | 2118373.09609 | 37.796752608195796 | -122.437635532153 | (37.7967526081958, -122.437635532153) | |
| 56808 | 56808 | 47721 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2325 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/28/2002 12:00:00 AM | 8 | Permit Number 45805 | 6001839.98608 | 2118371.66878 | 37.7967479784971 | -122.437678679828 | (37.7967479784971, -122.437678679828) | |
| 77784 | 77784 | 66736 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2797 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52344 | 6003927.95408343 | 2118320.58823126 | 37.796726222154206 | -122.430450187693 | (37.7967262221542, -122.430450187693) | ||
| 8887 | 8887 | 97923 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2939 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000511.871719999 | 2118390.4696 | 37.7967239962744 | -122.442275596851 | (37.7967239962744, -122.442275596851) | |||
| 126394 | 126394 | 83230 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2795-99 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52344 | 6003928.86053053 | 2118314.0736934 | 37.7967083862541 | -122.430446586129 | (37.7967083862541, -122.430446586129) | ||
| 175743 | 175743 | 52767 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 125 Trenton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2006 12:00:00 AM | 4 | 1x2 | Permit Number 48809 | 6010066.728209999 | 2117984.84058 | 37.7961501685616 | -122.409184831728 | (37.7961501685616, -122.409184831728) | |
| 169983 | 169983 | 52768 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 125@ JACKSON Trenton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2006 12:00:00 AM | 4 | Permit Number 48809 | 6010068.15327 | 2117966.12844 | 37.796098869423496 | -122.40917857963801 | (37.7960988694235, -122.409178579638) |
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");