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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19644 | 19644 | 44410 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1201 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2001 12:00:00 AM | Permit Number 43761 | 6001148.59414975 | 2087417.50046792 | 37.711715976255796 | -122.437852856075 | (37.7117159762558, -122.437852856075) | |||
| 19683 | 19683 | 4263 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4140 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2013 12:00:00 AM | 3 | 3X3 | Permit Number 769862 | 6002917.9994804 | 2100386.7174123 | 37.7474269722522 | -122.43266314833201 | (37.7474269722522, -122.432663148332) | |
| 19748 | 19748 | 42907 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2666 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | 3x3 | Permit Number 42820 | 6010104.02523077 | 2104001.6158371996 | 37.757757594938 | -122.40806913661801 | (37.757757594938, -122.408069136618) | |
| 19762 | 19762 | 26871 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2869 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6009006.88793 | 2101785.17049 | 37.7516102450284 | -122.41170689855 | (37.7516102450284, -122.41170689855) | |||
| 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) | ||
| 19818 | 19818 | 195 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 290X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2011 12:00:00 AM | 3 | 3x3 | 6002892.1169 | 2106583.9788 | 37.7644417056271 | -122.433195386565 | (37.7644417056271, -122.433195386565) | ||
| 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) | ||
| 20298 | 20298 | 115181 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2166 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775165 | 5981753.9 | 2100346.3 | 37.7460930178281 | -122.505842927008 | (37.7460930178281, -122.505842927008) | |||
| 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) | ||
| 21239 | 21239 | 84843 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1201 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/16/2007 12:00:00 AM | Permit No. 49246 | 6008311.7 | 2086994.1 | 37.7109581313437 | -122.41306521032699 | (37.7109581313437, -122.413065210327) | |||
| 21289 | 21289 | 19338 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 415 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2005 12:00:00 AM | 3 | 3X3 | 5992879.00654 | 2089828.9932799998 | 37.717863642070796 | -122.466609731553 | (37.7178636420708, -122.466609731553) | ||
| 21818 | 21818 | 2157 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1155 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2000 12:00:00 AM | 3 | 3X3 | 6000865.74472 | 2095769.5448 | 37.7346327031434 | -122.43942877221599 | (37.7346327031434, -122.439428772216) | ||
| 21864 | 21864 | 26482 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 142 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1997 12:00:00 AM | 8 | 3x3 | 6001066.31762 | 2098677.26441 | 37.7426280331709 | -122.43894363745501 | (37.7426280331709, -122.438943637455) | ||
| 21962 | 21962 | 85270 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000 Edinburgh St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49560 | ||||||||
| 22967 | 22967 | 109038 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1646 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773238 | 5985355.0 | 2103995.9 | 37.7563251201532 | -122.49365984919201 | (37.7563251201532, -122.493659849192) |
| 23631 | 23631 | 71784 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 335 London St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 7 | 3x3 | Permit Number 767514 | 6002237.25937 | 2091765.2641200002 | 37.723715816608504 | -122.43440079037902 | (37.7237158166085, -122.434400790379) |
| 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) | |
| 23979 | 23979 | 82809 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2466 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50725 | 5983047.875 | 2098352.5376 | 37.7406947715348 | -122.501221156521 | (37.7406947715348, -122.501221156521) | |
| 24063 | 24063 | 62130 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54059 | 6001174.82097 | 2092290.03948 | 37.72509636588129 | -122.438111025319 | (37.7250963658813, -122.438111025319) |
| 24303 | 24303 | 41575 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 19 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2000 12:00:00 AM | 6 | 3x3 | Permit Number 42089 | 5990803.38242 | 2114908.67177 | 37.7866058560396 | -122.475614467386 | (37.7866058560396, -122.475614467386) | |
| 24415 | 24415 | 81736 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 750 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49985 | 5983554.83693 | 2110677.77903 | 37.774566182445604 | -122.500379343502 | (37.7745661824456, -122.500379343502) | |
| 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) | |
| 24802 | 24802 | 95573 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 420 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767364 | 5986881.29994 | 2113082.68575 | 37.781364070981496 | -122.489049447076 | (37.7813640709815, -122.489049447076) | |
| 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) | |
| 25161 | 25161 | 60987 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 338 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 8 | 3x3 | Permit Number 767515 | 6002192.00153 | 2091772.7683700002 | 37.7237338525093 | -122.434557775148 | (37.7237338525093, -122.434557775148) |
| 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) | ||
| 25439 | 25439 | 85269 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000 Edinburgh St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49560 | ||||||||
| 25447 | 25447 | 93712 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1200 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53299 | 6008749.68248 | 2094028.5729200002 | 37.7302978962326 | -122.412048242529 | (37.7302978962326, -122.412048242529) | |
| 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) | |
| 25547 | 25547 | 95902 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1849 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767604 | 5989055.5587 | 2102725.7124 | 37.7530533181544 | -122.48076919458201 | (37.7530533181544, -122.480769194582) |
| 26186 | 26186 | 81258 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 287 Avila St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 8 | 3x3 | Permit Number 50831 | 6000919.15191 | 2120907.25979 | 37.8036576388633 | -122.441046970049 | (37.8036576388633, -122.441046970049) | |
| 26553 | 26553 | 67031 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2033 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53355 | 5999867.08314 | 2115982.05957 | 37.79007436769211 | -122.44433353976801 | (37.7900743676921, -122.444333539768) | |
| 26695 | 26695 | 50432 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3015 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2003 12:00:00 AM | 11 | Permit Number 47085 | 5999679.7052 | 2116676.00552 | 37.791969068380496 | -122.445031758116 | (37.7919690683805, -122.445031758116) | ||
| 26889 | 26889 | 92288 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2444 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52736 | 5989860.8925 | 2098710.0267 | 37.7420740738089 | -122.477690715305 | (37.7420740738089, -122.477690715305) |
| 26980 | 26980 | 41489 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3045 Santiago St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2000 12:00:00 AM | 3 | Permit Number 42908 | 5983374.5023 | 2099465.1182 | 37.743768788744894 | -122.500174051432 | (37.7437687887449, -122.500174051432) | ||
| 27060 | 27060 | 92454 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2343 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 0 | 3x3 | Permit Number 52844 | 5981710.4 | 2099132.4 | 37.742757425745204 | -122.50590336010201 | (37.7427574257452, -122.505903360102) |
| 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) | ||
| 27420 | 27420 | 82197 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1921 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49866 | 5988312.6138 | 2103710.6163 | 37.7557143891131 | -122.48341060663401 | (37.7557143891131, -122.483410606634) | |
| 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) | |
| 27632 | 27632 | 50304 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 371@ CLEMENT 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/2003 12:00:00 AM | 9 | Permit Number 47014 | 5987440.79756 | 2113480.9282 | 37.782490171237995 | -122.48714314118901 | (37.782490171238, -122.487143141189) | ||
| 27656 | 27656 | 92540 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1374 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52885 | 5985267.5978 | 2105858.806 | 37.7614350294385 | -122.49409940828501 | (37.7614350294385, -122.494099408285) | |
| 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) | |
| 27958 | 27958 | 60797 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 255 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/1983 12:00:00 AM | 1 | Permit Number 20473 | 5998486.3358 | 2112322.5828 | 37.7799475306539 | -122.44884708767799 | (37.7799475306539, -122.448847087678) | ||
| 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) | |
| 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) | |
| 28300 | 28300 | 95760 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 207 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767497 | 6004854.06205 | 2091888.4438900002 | 37.7242022320271 | -122.425363703668 | (37.7242022320271, -122.425363703668) |
| 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) | ||
| 28436 | 28436 | 114703 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 225 Woolsey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774054 | 6011021.11321 | 2091977.2455400003 | 37.724792560511105 | -122.40405124876601 | (37.7247925605111, -122.404051248766) | ||
| 28918 | 28918 | 96490 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2900 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2011 12:00:00 AM | Permit Number 58758 | 5994435.0 | 2110169.0 | 37.7738018521651 | -122.462706092013 | (37.7738018521651, -122.462706092013) | |||
| 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) | |
| 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) | |
| 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) | |
| 30310 | 30310 | 35925 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2660 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/1998 12:00:00 AM | 17 | 3x3 | Permit Number 773492 | 6001407.31616 | 2116967.4221799998 | 37.7928676736556 | -122.439075121022 | (37.7928676736556, -122.439075121022) | |
| 30508 | 30508 | 106556 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 767 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | 1 | 3x4 | Permit Number 773118 | 5988800.09905 | 2110110.4626 | 37.7733149816569 | -122.482193597345 | (37.7733149816569, -122.482193597345) | |
| 30522 | 30522 | 43194 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 Colby St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52486 | 6007869.54574833 | 2094250.5524237 | 37.7308579825995 | -122.41510671041901 | (37.7308579825995, -122.415106710419) | ||
| 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) | ||
| 30630 | 30630 | 30845 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1525 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | 15 | Permit Number 34694 | 6002896.94795 | 2121295.66679 | 37.8048365538189 | -122.434230497442 | (37.8048365538189, -122.434230497442) | ||
| 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) | |
| 30983 | 30983 | 92534 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1565 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52879 | 5985577.1955 | 2104566.0616 | 37.757903622799894 | -122.492933427514 | (37.7579036227999, -122.492933427514) | |
| 31233 | 31233 | 51584 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 21 Loyola Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2005 12:00:00 AM | 5 | Permit Number 47877 | 5998414.2801 | 2110851.9683 | 37.775905483115295 | -122.448990392708 | (37.7759054831153, -122.448990392708) | ||
| 31303 | 31303 | 57950 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 18 Byron Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2010 12:00:00 AM | 7 | Permit Number 53675 | 5999217.95376 | 2086673.30833 | 37.7095626181023 | -122.44447220083099 | (37.7095626181023, -122.444472200831) | ||
| 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) | |
| 31461 | 31461 | 84605 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1370 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52697 | 5985578.1412 | 2105889.2671 | 37.761536833498894 | -122.49302762699399 | (37.7615368334989, -122.493027626994) | |
| 31838 | 31838 | 62456 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1750 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/1985 12:00:00 AM | 1 | Permit Number 22623 | 5999582.8926 | 2114900.6379 | 37.787088848683794 | -122.44523902864401 | (37.7870888486838, -122.445239028644) | ||
| 32227 | 32227 | 85092 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 73 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51392 | 5996497.3497 | 2114054.7732 | 37.784589722316106 | -122.455853092183 | (37.7845897223161, -122.455853092183) | |
| 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) | |
| 32343 | 32343 | 93709 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 419 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53298 | 6008716.54523 | 2093918.1895400002 | 37.7299929478118 | -122.412155004647 | (37.7299929478118, -122.412155004647) | |
| 32535 | 32535 | 95892 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1500X Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767600 | 5989616.6165 | 2103814.8649 | 37.7560764357046 | -122.47890862495701 | (37.7560764357046, -122.478908624957) |
| 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) | |
| 32836 | 32836 | 96072 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 575 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767698 | 5985634.97945 | 2111987.83926 | 37.778285115395704 | -122.49328036205601 | (37.7782851153957, -122.493280362056) |
| 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) | |
| 33469 | 33469 | 103896 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 17 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770198 | 5990493.20289 | 2114947.47881 | 37.786694422761705 | -122.47669043796499 | (37.7866944227617, -122.476690437965) | |
| 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) | |
| 33525 | 33525 | 88586 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 815 24th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51529 | 5988483.68185 | 2110405.40991 | 37.7741064155227 | -122.483309739734 | (37.7741064155227, -122.483309739734) | ||
| 33934 | 33934 | 101013 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 322 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769279 | 6009407.6242 | 2088321.60488 | 37.714664649220296 | -122.409371044461 | (37.7146646492203, -122.409371044461) | |
| 33968 | 33968 | 92541 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1374 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52885 | 5985268.135 | 2105882.9799 | 37.7615014356617 | -122.494099332102 | (37.7615014356617, -122.494099332102) | |
| 34103 | 34103 | 88390 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 258 22nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51368 | 5989033.92216 | 2113597.32101 | 37.7829025195026 | -122.48164021539301 | (37.7829025195026, -122.481640215393) | ||
| 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) | |
| 34234 | 34234 | 56172 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 672 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 5 | Permit Number 12280 | 5990997.33421 | 2110822.85065 | 37.775398561836205 | -122.47464513846201 | (37.7753985618362, -122.474645138462) | ||
| 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) | |
| 34737 | 34737 | 54046 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3545 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/1972 12:00:00 AM | 6 | Permit Number 767245 | 6002612.039030001 | 2120815.15788 | 37.8035010282129 | -122.435182063824 | (37.8035010282129, -122.435182063824) | ||
| 34749 | 34749 | 82669 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3501 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 9 | 3x3 | Permit Number 50840 | 6000241.87041 | 2120304.09273 | 37.8019629042194 | -122.443347380076 | (37.8019629042194, -122.443347380076) | |
| 34899 | 34899 | 82116 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 471 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49834 | 5995281.66389903 | 2095825.83537331 | 37.7344678883998 | -122.45873877023199 | (37.7344678883998, -122.458738770232) | ||
| 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) | |
| 35547 | 35547 | 45762 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3320 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2001 12:00:00 AM | 5 | Permit Number 44409 | 5998356.66105 | 2116212.9599099997 | 37.790622067404996 | -122.449576098055 | (37.790622067405, -122.449576098055) | ||
| 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) |
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");