Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3813 | 3813 | 43299 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 615 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 7 | Permit Number 43068 | 6011854.0 | 2105476.0 | 37.761903752987706 | -122.402120617661 | (37.7619037529877, -122.402120617661) | |
| 3815 | 3815 | 43300 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 615 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 10 | Permit Number 43068 | 6011854.0 | 2105476.0 | 37.761903752987706 | -122.402120617661 | (37.7619037529877, -122.402120617661) | |
| 4164 | 4164 | 57912 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1653 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 6 | Permit Number 16870 | 6006600.1246 | 2116572.8469 | 37.7920783685385 | -122.42107969148998 | (37.7920783685385, -122.42107969149) | |
| 4905 | 4905 | 44497 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1531 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 10 | Permit Number 43799 | 6006322.0 | 2092922.0 | 37.727122979083205 | -122.420362574607 | (37.7271229790832, -122.420362574607) | |
| 5124 | 5124 | 56265 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 15 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2006 12:00:00 AM | Permit Number 12391 | 6006208.27079513 | 2104027.08283356 | 37.7576086269531 | -122.42154409690501 | (37.7576086269531, -122.421544096905) | ||
| 7819 | 7819 | 74571 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1055 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/2014 12:00:00 AM | 3 | Permit Number 774207 | 6008908.989 | 2115950.0282799997 | 37.7904981444129 | -122.413046908194 | (37.7904981444129, -122.413046908194) | |
| 8916 | 8916 | 44823 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2440 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2016 12:00:00 AM | 3 | Permit Number 778318 | 6001806.8581 | 2114669.8819999998 | 37.7865819462822 | -122.43752808228201 | (37.7865819462822, -122.437528082282) | |
| 9815 | 9815 | 40304 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 276 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | 10 | Permit Number 46688 | 6006675.32022229 | 2104512.13520977 | 37.7589667921547 | -122.419963267076 | (37.7589667921547, -122.419963267076) | |
| 10275 | 10275 | 32464 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99x Deming St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | Permit Number 36974 | 5999085.33670349 | 2105174.9537063 | 37.7603561904001 | -122.446260575093 | (37.7603561904001, -122.446260575093) | ||
| 15732 | 15732 | 49838 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 630 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/2016 12:00:00 AM | 3 | Permit Number 46621 | 6010947.62469 | 2105199.0558700003 | 37.7610926949039 | -122.405235926615 | (37.7610926949039, -122.405235926615) | |
| 17908 | 17908 | 45501 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3070 23rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | Permit Number 44273 | 5989380.64559271 | 2094892.34202186 | 37.731563814981605 | -122.47907204836399 | (37.7315638149816, -122.479072048364) | ||
| 17914 | 17914 | 66442 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 263 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 772183 | 6006122.56808708 | 2096124.40877 | 37.73590484821929 | -122.421279320467 | (37.7359048482193, -122.421279320467) | |
| 18921 | 18921 | 32751 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 98X LOBOS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37130 | 5996424.0 | 2088680.0 | 37.71491271306979 | -122.45427337935101 | (37.7149127130698, -122.454273379351) | ||
| 19059 | 19059 | 43844 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2736 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/28/2003 12:00:00 AM | Permit Number 43466 | 5985584.65410627 | 2096702.64202879 | 37.7363132411039 | -122.492328600224 | (37.7363132411039, -122.492328600224) | ||
| 19106 | 19106 | 45210 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 600-698X Bowdoin St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2001 12:00:00 AM | Permit Number 44051 | 6008935.27610714 | 2093040.15073148 | 37.7275943109827 | -122.41133681828501 | (37.7275943109827, -122.411336818285) | ||
| 19353 | 19353 | 49110 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1411 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46250 | 5995842.78355552 | 2093401.69932097 | 37.7278440321398 | -122.456623556012 | (37.7278440321398, -122.456623556012) | ||
| 19470 | 19470 | 31542 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 150 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35092 | 5998688.18134384 | 2112713.18488923 | 37.7810315633484 | -122.44817695027099 | (37.7810315633484, -122.448176950271) | ||
| 19784 | 19784 | 31175 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 230 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34873 | 5993424.36409325 | 2089864.86318911 | 37.7179935887517 | -122.464727290106 | (37.7179935887517, -122.464727290106) | ||
| 19804 | 19804 | 48657 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 601 Moraga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45947 | 5992474.12537509 | 2103859.88961246 | 37.7563655794475 | -122.469029766101 | (37.7563655794475, -122.469029766101) | ||
| 20267 | 20267 | 45221 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 801-899X Felton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2001 12:00:00 AM | Permit Number 44054 | 6008510.16746889 | 2093128.34888408 | 37.7278126322854 | -122.412812661196 | (37.7278126322854, -122.412812661196) | ||
| 20375 | 20375 | 36345 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 94 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39307 | 5995648.40057371 | 2093261.73046409 | 37.727448548862 | -122.45728541654199 | (37.727448548862, -122.457285416542) | ||
| 20376 | 20376 | 49064 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 820 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | Permit Number 46228 | 5995441.21926362 | 2094283.33319861 | 37.7302417218115 | -122.45807554192699 | (37.7302417218115, -122.458075541927) | ||
| 23676 | 23676 | 52550 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1527 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | 0 | Permit Number 49093 | 5984635.73167971 | 2104787.38586659 | 37.7584562156449 | -122.49620568519501 | (37.7584562156449, -122.496205685195) | |
| 24765 | 24765 | 68220 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 277 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/2000 12:00:00 AM | 4 | Permit Number 32007 | 5990853.35695 | 2113538.0406299997 | 37.78284538159139 | -122.475341463071 | (37.7828453815914, -122.475341463071) | |
| 25081 | 25081 | 37199 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1501 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 7 | Permit Number 39766 | 5986185.9989 | 2104971.5764 | 37.7590526389001 | -122.490857797213 | (37.7590526389001, -122.490857797213) | |
| 25398 | 25398 | 48029 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 320 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45747 | 5992060.97145669 | 2097299.95564023 | 37.738329808716294 | -122.46998096184299 | (37.7383298087163, -122.469980961843) | ||
| 25468 | 25468 | 44463 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1600 Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 7 | Permit Number 43782 | 6006251.1656 | 2092487.67845 | 37.7259264347478 | -122.420576631331 | (37.7259264347478, -122.420576631331) | |
| 25826 | 25826 | 78305 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4435 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 14 | 5984852.19199 | 2111745.44954 | 37.777573766565396 | -122.49597038603301 | (37.7775737665654, -122.495970386033) | ||
| 26509 | 26509 | 78220 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1168 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 11 | 6009637.32407 | 2090762.2749400001 | 37.7213790919536 | -122.408749187543 | (37.7213790919536, -122.408749187543) | ||
| 26917 | 26917 | 84611 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2626 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2006 12:00:00 AM | 6 | 5987424.009980001 | 2110533.0833099997 | 37.7743952434606 | -122.486984660428 | (37.7743952434606, -122.486984660428) | ||
| 27108 | 27108 | 47884 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1422 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2002 12:00:00 AM | 5 | Permit Number 45630 | 5982179.6052 | 2105409.3092 | 37.7600196636967 | -122.504746003202 | (37.7600196636967, -122.504746003202) | |
| 27331 | 27331 | 117477 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1999X Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 14 | Permit Number 778454 | 6004121.651819999 | 2117991.3278099997 | 37.7958331278375 | -122.429756453008 | (37.7958331278375, -122.429756453008) | ||
| 27482 | 27482 | 41214 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2526 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 11 | Permit Number 41922 | 5999213.18355 | 2119788.9581400002 | 37.8004897688328 | -122.446870019146 | (37.8004897688328, -122.446870019146) | |
| 27700 | 27700 | 46652 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 352 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | 8 | Permit Number 767859 | 5990608.27157 | 2113041.98207 | 37.7814691334051 | -122.476153103488 | (37.7814691334051, -122.476153103488) | |
| 27801 | 27801 | 45230 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 901-999X Felton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2001 12:00:00 AM | 8 | Permit Number 44057 | 6008203.911069999 | 2093035.9367799999 | 37.7275416935775 | -122.41386486498699 | (37.7275416935775, -122.413864864987) | |
| 27907 | 27907 | 42155 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 519 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 5 | Permit Number 42450 | 5989365.15047 | 2111778.31526 | 37.7779272929593 | -122.480361131189 | (37.7779272929593, -122.480361131189) | |
| 28222 | 28222 | 68960 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2115 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/16/1996 12:00:00 AM | 8 | Permit Number 32949 | 5988984.02499 | 2111212.07904 | 37.7763504110658 | -122.481638080092 | (37.7763504110658, -122.481638080092) | |
| 28242 | 28242 | 72839 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2466 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 3 | 5989244.3793 | 2098568.7958 | 37.7416504931176 | -122.479812066514 | (37.7416504931176, -122.479812066514) | ||
| 28259 | 28259 | 52567 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1571 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 6 | Permit Number 48664 | 5983720.4322 | 2104461.3413 | 37.757507331453795 | -122.49934705559099 | (37.7575073314538, -122.499347055591) | |
| 28409 | 28409 | 52286 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 68 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48444 | 6005456.52418218 | 2099358.34755357 | 37.7447469414441 | -122.423811979701 | (37.7447469414441, -122.423811979701) | ||
| 28643 | 28643 | 72844 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2474 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 8 | 5989246.9405 | 2098504.7662 | 37.741474833316005 | -122.47979852661899 | (37.741474833316, -122.479798526619) | ||
| 28693 | 28693 | 72007 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1919 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 9 | 5986594.8133 | 2102174.9289 | 37.7513976822301 | -122.489238323994 | (37.7513976822301, -122.489238323994) | ||
| 28924 | 28924 | 36448 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1270 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39350 | 5995753.99208011 | 2092527.19640407 | 37.725437758382796 | -122.456867284631 | (37.7254377583828, -122.456867284631) | ||
| 29335 | 29335 | 38897 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 125 Parker Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 10 | Permit Number 40711 | 5996844.4013 | 2113598.7498 | 37.783357514917704 | -122.454619461278 | (37.7833575149177, -122.454619461278) | |
| 29342 | 29342 | 78567 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 40 Sears St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 0 | 5996717.44875 | 2086996.04025 | 37.7103057728767 | -122.453137611232 | (37.7103057728767, -122.453137611232) | ||
| 29722 | 29722 | 46645 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 329 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | 8 | Permit Number 44777 | 5990864.95756 | 2113183.37502 | 37.781872240560105 | -122.47527542879801 | (37.7818722405601, -122.475275428798) | |
| 29801 | 29801 | 39865 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 55 Laurel St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 11 | Permit Number 41168 | 5997960.261419999 | 2116228.24387 | 37.7906413479758 | -122.450948714408 | (37.7906413479758, -122.450948714408) | |
| 29806 | 29806 | 79006 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3010 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/31/2001 12:00:00 AM | 4 | 5988598.81631 | 2095123.01531 | 37.73215174969361 | -122.48179184262 | (37.7321517496936, -122.48179184262) | ||
| 29935 | 29935 | 68653 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 218 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2012 12:00:00 AM | 10 | Permit Number 768874 | 5993704.111880001 | 2114020.8946700003 | 37.7843359956366 | -122.465514212776 | (37.7843359956366, -122.465514212776) | |
| 30207 | 30207 | 43802 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 626 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 12 | Permit Number 43432 | 5988815.3597099995 | 2111031.7516799998 | 37.7758454732565 | -122.482208318964 | (37.7758454732565, -122.482208318964) | |
| 30544 | 30544 | 33244 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2595 25th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1996 12:00:00 AM | Permit Number 37425 | 5988605.01014938 | 2097676.97317707 | 37.7391646162219 | -122.481957449606 | (37.7391646162219, -122.481957449606) | ||
| 30546 | 30546 | 42330 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 640 Edna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45706 | 5998596.9019044 | 2094811.5025333 | 37.7318727635975 | -122.447203968283 | (37.7318727635975, -122.447203968283) | ||
| 30603 | 30603 | 78249 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 722 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 14 | 6002553.6088 | 2089304.67959 | 37.7169775508513 | -122.433131500725 | (37.7169775508513, -122.433131500725) | ||
| 30681 | 30681 | 71169 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2286 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 12 | 5988269.5036 | 2099757.2232 | 37.7448569176428 | -122.48326991258101 | (37.7448569176428, -122.483269912581) | ||
| 30893 | 30893 | 81813 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1419 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 5988645.6741 | 2105641.5626 | 37.7610356250119 | -122.482400266833 | (37.7610356250119, -122.482400266833) | |||
| 30895 | 30895 | 72325 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1024 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 17 | 5995456.74462 | 2112185.6673 | 37.7793978796409 | -122.459317808209 | (37.7793978796409, -122.459317808209) | ||
| 30974 | 30974 | 38188 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 467 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | 13 | Permit Number 40317 | 6010993.92767 | 2092626.8959400002 | 37.7265748468264 | -122.40419092789101 | (37.7265748468264, -122.404190927891) | |
| 31327 | 31327 | 74456 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1600 Cabrillo St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/1997 12:00:00 AM | 1 | 5990434.64458 | 2110641.0438200003 | 37.774866749948394 | -122.47657830845199 | (37.7748667499484, -122.476578308452) | ||
| 31350 | 31350 | 32756 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 548 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 11 | Permit Number 37134 | 5995923.97988 | 2088945.4822 | 37.7156129780405 | -122.456020830504 | (37.7156129780405, -122.456020830504) | |
| 31406 | 31406 | 78981 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3010 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/31/2001 12:00:00 AM | 6 | 5988598.26688 | 2095139.6319 | 37.7321973426185 | -122.481794958792 | (37.7321973426185, -122.481794958792) | ||
| 32279 | 32279 | 50237 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1201 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | 1 | Permit Number 47607 | 5985808.2714 | 2106970.4182 | 37.764518829398604 | -122.492311327523 | (37.7645188293986, -122.492311327523) | |
| 32600 | 32600 | 30981 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2327 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 3 | Permit Number 34768 | 6004137.322380001 | 2116809.32877 | 37.7925885474784 | -122.42961788815201 | (37.7925885474784, -122.429617888152) | |
| 32825 | 32825 | 44438 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 531 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | 11 | Permit Number 43771 | 6002563.3537099995 | 2087475.55199 | 37.7119557212594 | -122.432967211681 | (37.7119557212594, -122.432967211681) | |
| 32917 | 32917 | 42267 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1431 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 11 | Permit Number 46938 | 5987406.4873 | 2105538.1578 | 37.7606795409708 | -122.48667842785801 | (37.7606795409708, -122.486678427858) | |
| 32950 | 32950 | 67967 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3233 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2010 12:00:00 AM | 4 | Permit Number 53767 | 5988573.93418 | 2111880.53339 | 37.77816194510179 | -122.483105688312 | (37.7781619451018, -122.483105688312) | |
| 33481 | 33481 | 47801 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 45 Escondido Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2002 12:00:00 AM | 7 | Permit Number 45571 | 5986306.477999999 | 2096108.0259999998 | 37.7347227558266 | -122.489789272211 | (37.7347227558266, -122.489789272211) | |
| 33484 | 33484 | 75118 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1335 Griffith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1998 12:00:00 AM | 9 | 6017861.446 | 2092515.1377 | 37.7266493234609 | -122.38044215870701 | (37.7266493234609, -122.380442158707) | ||
| 34212 | 34212 | 51272 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 442 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 10 | Permit Number 47647 | 5990630.5302099995 | 2112359.86559 | 37.7795975210663 | -122.476026266779 | (37.7795975210663, -122.476026266779) | |
| 34657 | 34657 | 35360 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 948 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 8 | Permit Number 38822 | 6011854.55892 | 2104004.68665 | 37.757863884136 | -122.40201524752199 | (37.757863884136, -122.402015247522) | |
| 34659 | 34659 | 42262 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1570 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 9 | Permit Number 42503 | 5988104.0896 | 2104611.0781 | 37.7581746751805 | -122.48419777491999 | (37.7581746751805, -122.48419777492) | |
| 35017 | 35017 | 75005 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 751 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 9 | 5991294.36984 | 2110367.2976 | 37.7741649440769 | -122.473584395208 | (37.7741649440769, -122.473584395208) | ||
| 35025 | 35025 | 38349 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1675 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/1998 12:00:00 AM | 7 | Permit Number 40416 | 5981884.0826 | 2103708.5586 | 37.7553324970038 | -122.505641978834 | (37.7553324970038, -122.505641978834) | |
| 35600 | 35600 | 44400 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1127 Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 12 | Permit Number 43754 | 6001650.52714 | 2087033.38345 | 37.7106898049515 | -122.43609057243 | (37.7106898049515, -122.43609057243) | |
| 35749 | 35749 | 44460 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1543 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774159 | 6006374.3577 | 2092477.5987 | 37.7259056999789 | -122.420150048693 | (37.7259056999789, -122.420150048693) | |
| 35765 | 35765 | 51268 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 754 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 6 | Permit Number 47643 | 5991340.2204 | 2110277.65197 | 37.773921456767 | -122.473419251606 | (37.773921456767, -122.473419251606) | |
| 35797 | 35797 | 73756 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 350 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/1996 12:00:00 AM | 10 | 6012331.43076 | 2118154.70555 | 37.7967431913899 | -122.40136040075899 | (37.7967431913899, -122.401360400759) | ||
| 35950 | 35950 | 78250 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 719 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 15 | 6002605.65384 | 2089306.22007 | 37.716984732838895 | -122.432951716346 | (37.7169847328389, -122.432951716346) | ||
| 35996 | 35996 | 63211 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3515 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 4 | Permit Number 23754 | 5984549.109130001 | 2113139.52213 | 37.7813837305386 | -122.497121763929 | (37.7813837305386, -122.497121763929) | |
| 36195 | 36195 | 39856 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 462 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 7 | Permit Number 41163 | 5992834.400669999 | 2112304.93765 | 37.7795742464055 | -122.468398200084 | (37.7795742464055, -122.468398200084) | |
| 36293 | 36293 | 71578 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 94X De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 13 | 5994610.40755 | 2086820.2353700001 | 37.709702067873 | -122.460407199135 | (37.709702067873, -122.460407199135) | ||
| 36411 | 36411 | 52946 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 25 Ruth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 4 | Permit Number 48933 | 6001610.069619999 | 2091593.3651700001 | 37.723208199685395 | -122.43655657684201 | (37.7232081996854, -122.436556576842) | |
| 37045 | 37045 | 43860 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500 Crestlake Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 2 | Permit Number 43480 | 5986156.5709 | 2096489.2942 | 37.7357608636081 | -122.490335583477 | (37.7357608636081, -122.490335583477) | |
| 37129 | 37129 | 45047 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1854 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2001 12:00:00 AM | 4 | Permit Number 43933 | 5988175.8497 | 2102683.93 | 37.7528874240165 | -122.483808298799 | (37.7528874240165, -122.483808298799) | |
| 37193 | 37193 | 72676 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 203 04th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/02/1997 12:00:00 AM | 9 | 5994586.88347 | 2114134.74364 | 37.784699468818204 | -122.46246841458901 | (37.7846994688182, -122.462468414589) | ||
| 38195 | 38195 | 69034 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1378 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 3 | Permit Number 33040 | 5984339.0634 | 2105797.9538 | 37.7612135700499 | -122.497306281565 | (37.7612135700499, -122.497306281565) | |
| 38300 | 38300 | 60552 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 542 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 2 | Permit Number 20162 | 5985055.50705 | 2112151.6276599998 | 37.778700920741 | -122.49529702328199 | (37.778700920741, -122.495297023282) | |
| 38496 | 38496 | 34651 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1814 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 12 | Permit Number 38330 | 5988878.9314 | 2105836.9442 | 37.761585656021296 | -122.481607850901 | (37.7615856560213, -122.481607850901) | |
| 38537 | 38537 | 47194 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 362 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 12 | Permit Number 45153 | 5986866.72615 | 2113495.91652 | 37.7824978340262 | -122.489130254123 | (37.7824978340262, -122.489130254123) | |
| 38660 | 38660 | 47802 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 50 Escondido Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2002 12:00:00 AM | 8 | Permit Number 45572 | 5986259.2506 | 2096136.1501 | 37.7347972195515 | -122.489954619078 | (37.7347972195515, -122.489954619078) | |
| 38726 | 38726 | 43599 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2343 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 6 | Permit Number 43257 | 5986688.1938 | 2099310.0736 | 37.743537010398 | -122.488704852475 | (37.743537010398, -122.488704852475) | |
| 38813 | 38813 | 62143 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 156 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/06/1985 12:00:00 AM | 1 | Permit Number 22254 | 6001281.15051 | 2092297.21418 | 37.725122112579605 | -122.43774396971399 | (37.7251221125796, -122.437743969714) | |
| 38923 | 38923 | 78450 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2930 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 10 | 5990007.36558 | 2095749.13449 | 37.73395272482529 | -122.47696796099702 | (37.7339527248253, -122.476967960997) | ||
| 39500 | 39500 | 69296 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 839 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1994 12:00:00 AM | 8 | Permit Number 33369 | 6000971.5398 | 2111598.7615 | 37.7781019079344 | -122.440197757934 | (37.7781019079344, -122.440197757934) | |
| 39718 | 39718 | 74869 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 751 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 4 | 5991293.21229 | 2110325.51656 | 37.7740501576748 | -122.473585351012 | (37.7740501576748, -122.473585351012) | ||
| 39825 | 39825 | 83498 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1840 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5987237.7366 | 2102721.865 | 37.752936928713495 | -122.48705521280199 | (37.7529369287135, -122.487055212802) | |||
| 39964 | 39964 | 50209 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 779@ BALBOA 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 7 | Permit Number 46917 | 5987541.74855 | 2110671.7198099997 | 37.77478276451 | -122.486587567337 | (37.77478276451, -122.486587567337) | |
| 40290 | 40290 | 32745 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 148 Montana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 8 | Permit Number 37127 | 5995448.12919 | 2089342.0569999998 | 37.7166745548685 | -122.45769425390101 | (37.7166745548685, -122.457694253901) | |
| 40419 | 40419 | 31625 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2479 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | 7 | Permit Number 35142 | 5982380.9303 | 2098242.6913 | 37.740353975903 | -122.503519026665 | (37.740353975903, -122.503519026665) | |
| 40915 | 40915 | 47800 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 45 Escondido Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2002 12:00:00 AM | 5 | Permit Number 45571 | 5986290.5586 | 2096106.9647 | 37.734718912259396 | -122.48984423223699 | (37.7347189122594, -122.489844232237) | |
| 41117 | 41117 | 71607 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 190 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 11 | 5994457.91424 | 2086560.2946 | 37.708979557936104 | -122.46091541234199 | (37.7089795579361, -122.460915412342) |
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");