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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15243 | 15243 | 109931 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2822 Moraga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775171 | |||||
181428 | 181428 | 34717 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 527 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 16 | Permit Number 38372 | 5981286.01571 | 2112124.00365 | 37.778403651193706 | -122.50833487486601 | (37.7784036511937, -122.508334874866) | |
145575 | 145575 | 47836 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 506 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | Permit Number 45598 | 5981328.87768988 | 2112285.52839896 | 37.778849676193296 | -122.508198593969 | (37.7788496761933, -122.508198593969) | ||
181935 | 181935 | 34723 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 33 Sutro Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/2000 12:00:00 AM | 7 | Permit Number 38378 | 5981457.29395 | 2111286.79163 | 37.7761150061979 | -122.50768022848601 | (37.7761150061979, -122.507680228486) | |
153495 | 153495 | 34724 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 33 Sutro Heights Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/2000 12:00:00 AM | 0 | Permit Number 38378 | 5981478.07972 | 2111286.72218 | 37.776116040031496 | -122.50760832105 | (37.7761160400315, -122.50760832105) | |
119741 | 119741 | 109189 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 482 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774830 | 5981625.7586 | 2112517.84773 | 37.7795050464814 | -122.507188823101 | (37.7795050464814, -122.507188823101) |
84823 | 84823 | 109188 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 482 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774830 | 5981628.45653 | 2112492.50566 | 37.7794356235543 | -122.507177609428 | (37.7794356235543, -122.507177609428) |
78512 | 78512 | 37091 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1322 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39691 | 5981539.4678591 | 2106068.94026925 | 37.7617931435706 | -122.507008823366 | (37.7617931435706, -122.507008823366) | ||
119503 | 119503 | 34705 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 636 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2002 12:00:00 AM | 10 | Permit Number 45853 | 5981667.05169 | 2111389.6356900004 | 37.776409740900505 | -122.506962263473 | (37.7764097409005, -122.506962263473) | |
148654 | 148654 | 37097 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1519 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 6 | Permit Number 39697 | 5981538.3257 | 2104728.8582 | 37.7581135944315 | -122.506913367496 | (37.7581135944315, -122.506913367496) | |
43234 | 43234 | 92450 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1418 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52841 | 5981557.2817 | 2105400.2784 | 37.7599582387991 | -122.506897613129 | (37.7599582387991, -122.506897613129) |
95332 | 95332 | 109135 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 730 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773524 | 5981688.65422 | 2110759.10113 | 37.774679750310504 | -122.506840755547 | (37.7746797503105, -122.506840755547) |
177021 | 177021 | 37098 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1526 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 6 | Permit Number 39698 | 5981582.6318 | 2104677.2186 | 37.757974415915704 | -122.506756310539 | (37.7579744159157, -122.506756310539) | |
118837 | 118837 | 39826 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2050 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41151 | 5981707.40217045 | 2101129.10059865 | 37.74823963248679 | -122.50606173823999 | (37.7482396324868, -122.50606173824) | ||
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) |
112075 | 112075 | 109252 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2443 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773556 | 5981723.0 | 2098451.0 | 37.7408872317264 | -122.505809288749 | (37.7408872317264, -122.505809288749) |
183386 | 183386 | 47822 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 734 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/2002 12:00:00 AM | 8 | Permit Number 45586 | 5981999.5406599995 | 2110743.7888 | 37.7746560097186 | -122.50576421992201 | (37.7746560097186, -122.505764219922) | |
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) | |
149334 | 149334 | 92447 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1691 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52838 | 5981885.7633 | 2103607.1079 | 37.755054041014496 | -122.505628646518 | (37.7550540410145, -122.505628646518) |
62223 | 62223 | 92448 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2079 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52839 | 5981971.4399 | 2100959.3723 | 37.7477891451677 | -122.50513614233401 | (37.7477891451677, -122.505136142334) |
184995 | 184995 | 34696 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 626 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 11 | Permit Number 38355 | 5982285.35898 | 2111475.04889 | 37.776680654232 | -122.504829731264 | (37.776680654232, -122.504829731264) | |
70533 | 70533 | 34697 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 626 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 14 | Permit Number 38355 | 5982286.66539 | 2111456.97442 | 37.7766311038854 | -122.504823872464 | (37.7766311038854, -122.504823872464) | |
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) | |
48569 | 48569 | 33851 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 869 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 1 | Permit Number 38356 | 5982297.1677 | 2109841.1575700003 | 37.7721951599998 | -122.504667792871 | (37.7721951599998, -122.504667792871) | |
164747 | 164747 | 79480 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 881 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2002 12:00:00 AM | 7 | 5982298.725380001 | 2109767.28551 | 37.7719924204152 | -122.50465693044599 | (37.7719924204152, -122.504656930446) | ||
186319 | 186319 | 92449 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2675 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52840 | 5982115.1 | 2096904.0638 | 37.7366628403304 | -122.504339004693 | (37.7366628403304, -122.504339004693) |
55482 | 55482 | 96112 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 7909 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767767 | 5982473.14559 | 2112346.12315 | 37.7790834143652 | -122.504244675585 | (37.7790834143652, -122.504244675585) |
155773 | 155773 | 34720 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 5208 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2012 12:00:00 AM | 2 | Permit Number 768608 | 5982492.22615 | 2111717.77987 | 37.7773592900989 | -122.50413211310301 | (37.7773592900989, -122.504132113103) | |
61976 | 61976 | 34694 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4201 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 11 | Permit Number 38353 | 5982506.5012300005 | 2110978.55667 | 37.775330438700706 | -122.504027964223 | (37.7753304387007, -122.504027964223) | |
148725 | 148725 | 78560 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2214 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 3 | 5982364.6255 | 2099997.6781 | 37.7451717266117 | -122.503705339024 | (37.7451717266117, -122.503705339024) | ||
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) | |
189088 | 189088 | 92444 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2643 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52835 | 5982411.0946 | 2097116.4843 | 37.737263493476 | -122.503331364341 | (37.737263493476, -122.503331364341) |
188945 | 188945 | 69003 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2063 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 5 | Permit Number 33004 | 5982592.2747 | 2101083.7423 | 37.7481671399171 | -122.502998568536 | (37.7481671399171, -122.502998568536) | |
131051 | 131051 | 34821 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 420 42nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1998 12:00:00 AM | 9 | Permit Number 38709 | 5982850.46473 | 2112964.10634 | 37.7808023985461 | -122.50298515940399 | (37.7808023985461, -122.502985159404) | |
167640 | 167640 | 34822 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 420 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1998 12:00:00 AM | 4 | Permit Number 38709 | 5982851.81214 | 2112946.0180599997 | 37.780752812635896 | -122.50297915864901 | (37.7807528126359, -122.502979158649) | |
170016 | 170016 | 34823 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 456 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1998 12:00:00 AM | 9 | Permit Number 38710 | 5982857.51901 | 2112741.1167099997 | 37.780190549097 | -122.502944242938 | (37.780190549097, -122.502944242938) | |
163272 | 163272 | 44735 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 566 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 2 | 3x3 | Permit Number 43851 | 5982889.14575 | 2111926.60569 | 37.7779559990764 | -122.502774523335 | (37.7779559990764, -122.502774523335) |
168634 | 168634 | 92438 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2290 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52828 | 5982689.0719 | 2099536.3342 | 37.7439240746075 | -122.502549337764 | (37.7439240746075, -122.502549337764) |
92585 | 92585 | 109274 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2471 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773741 | 5982670.2 | 2098312.5 | 37.7405626536351 | -122.502524028762 | (37.7405626536351, -122.502524028762) |
120230 | 120230 | 109273 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2471 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773741 | 5982670.2 | 2098312.5 | 37.7405626536351 | -122.502524028762 | (37.7405626536351, -122.502524028762) |
63404 | 63404 | 96078 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 442 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767702 | 5983166.63453 | 2112823.2290000003 | 37.7804341684029 | -122.50188096554501 | (37.7804341684029, -122.501880965545) |
53505 | 53505 | 96077 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 442 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767702 | 5983166.97254 | 2112802.17844 | 37.7803763895854 | -122.501878238244 | (37.7803763895854, -122.501878238244) |
159978 | 159978 | 37068 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1246 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 7 | Permit Number 39670 | 5983068.4485 | 2106652.21 | 37.763484564296 | -122.501763930735 | (37.763484564296, -122.501763930735) | |
155466 | 155466 | 37140 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1998 12:00:00 AM | 6 | Permit Number 39721 | 5983218.67012 | 2111364.16792 | 37.7764310689034 | -122.501592980917 | (37.7764310689034, -122.501592980917) | |
13187 | 13187 | 106199 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2107 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 3x4 | 5983225.8003 | 2100763.9337 | 37.74732624942661 | -122.500784246807 | (37.7473262494266, -122.500784246807) | ||
65483 | 65483 | 69153 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1242 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | 16 | Permit Number 33188 | 5983377.7924 | 2106670.0778 | 37.763551789960204 | -122.50069534772 | (37.7635517899602, -122.50069534772) | |
58760 | 58760 | 72570 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3841 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1996 12:00:00 AM | 13 | 5983527.11089 | 2113102.27119 | 37.7812215053692 | -122.500654568438 | (37.7812215053692, -122.500654568438) | ||
47822 | 47822 | 94818 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 606 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2009 12:00:00 AM | 9 | 3x3 | Permit Number 52675 | 5983521.262490001 | 2111637.40595 | 37.7771990690519 | -122.50056645357401 | (37.7771990690519, -122.500566453574) |
52068 | 52068 | 35214 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3835 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/1998 12:00:00 AM | 12 | Permit Number 38717 | 5983562.482969999 | 2113104.4986900003 | 37.7812296979394 | -122.500532365233 | (37.7812296979394, -122.500532365233) | |
67718 | 67718 | 35213 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3827 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1998 12:00:00 AM | 14 | Permit Number 38716 | 5983577.31985 | 2113105.12349 | 37.781232284414 | -122.500481083986 | (37.781232284414, -122.500481083986) | |
163640 | 163640 | 34846 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3821 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1998 12:00:00 AM | 3 | Permit Number 38715 | 5983608.71451 | 2113105.70876 | 37.7812357342542 | -122.50037251898199 | (37.7812357342542, -122.500372518982) | |
181947 | 181947 | 34845 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3821 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1998 12:00:00 AM | 15 | Permit Number 38715 | 5983624.32286 | 2113105.53205 | 37.7812361652298 | -122.500318509587 | (37.7812361652298, -122.500318509587) | |
182393 | 182393 | 34826 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3807 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1998 12:00:00 AM | 14 | Permit Number 38714 | 5983644.82089 | 2113105.40803 | 37.78123702785071 | -122.500247588479 | (37.7812370278507, -122.500247588479) | |
136496 | 136496 | 92460 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3445 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52849 | 5983500.4611 | 2104231.1385 | 37.7568623513494 | -122.500090774692 | (37.7568623513494, -122.500090774692) |
167506 | 167506 | 92462 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3445 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52849 | 5983536.8531 | 2104231.4754 | 37.7568654121682 | -122.499964944533 | (37.7568654121682, -122.499964944533) |
107469 | 107469 | 34827 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3807 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1998 12:00:00 AM | Permit Number 38714 | 5983728.21431829 | 2113108.89709572 | 37.7812515021912 | -122.499959350937 | (37.7812515021912, -122.499959350937) | ||
134327 | 134327 | 69461 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 432 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 3 | Permit Number 33573 | 5983785.31524 | 2112890.9665099997 | 37.7806564792559 | -122.499745700629 | (37.7806564792559, -122.499745700629) | |
115194 | 115194 | 43050 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2000 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | Permit Number 42904 | 5983558.17532527 | 2101519.50178416 | 37.7494203390776 | -122.499690770945 | (37.7494203390776, -122.499690770945) | ||
75385 | 75385 | 39811 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1990 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | 3 | Permit Number 42165 | 5983574.8824 | 2100918.7617 | 37.7477718530718 | -122.49958860602699 | (37.7477718530718, -122.499588606027) | |
50066 | 50066 | 73610 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 7 | 5983838.25211 | 2111373.73646 | 37.776493712426 | -122.49945041273001 | (37.776493712426, -122.49945041273) | ||
41391 | 41391 | 71613 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 9 | 5983838.80343 | 2111388.30802 | 37.7765337540591 | -122.49944958268499 | (37.7765337540591, -122.499449582685) | ||
44753 | 44753 | 71614 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 656 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 9 | 5983838.93625 | 2111360.81187 | 37.7764582653815 | -122.499447090774 | (37.7764582653815, -122.499447090774) | ||
160128 | 160128 | 73611 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 656 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 8 | 5983838.87483 | 2111346.70796 | 37.776419536522496 | -122.499446260711 | (37.7764195365225, -122.499446260711) | ||
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) | |
127165 | 127165 | 52575 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1726 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | Permit Number 48667 | 5983804.86974722 | 2103396.47641638 | 37.754588463383 | -122.49897636738301 | (37.754588463383, -122.498976367383) | ||
152081 | 152081 | 41493 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2920 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 8 | Permit Number 43483 | 5983785.0248 | 2099537.3934 | 37.7439913228244 | -122.498759922597 | (37.7439913228244, -122.498759922597) | |
130627 | 130627 | 71994 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 400 38th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1986 12:00:00 AM | 4 | 5984087.82115 | 2113103.7785400003 | 37.7812585454782 | -122.49871492967699 | (37.7812585454782, -122.498714929677) | ||
186553 | 186553 | 34813 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 400 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1998 12:00:00 AM | 4 | Permit Number 38704 | 5984088.07189 | 2113071.94778 | 37.7811711621882 | -122.498711710109 | (37.7811711621882, -122.498711710109) | |
84932 | 84932 | 63205 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3649 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42169 | 5984230.39319689 | 2113127.72849357 | 37.7813326658379 | -122.49822347760201 | (37.7813326658379, -122.498223477602) | ||
67229 | 67229 | 63208 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3627 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | 11 | Permit Number 42168 | 5984269.89164 | 2113129.76442 | 37.781340571817296 | -122.498086984815 | (37.7813405718173, -122.498086984815) | |
37015 | 37015 | 84220 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1622 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52818 | 5984087.6187 | 2104108.821 | 37.756560944522 | -122.498051164125 | (37.756560944522, -122.498051164125) |
64380 | 64380 | 52556 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1670 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 4 | Permit Number 48652 | 5984096.7167 | 2103806.2285 | 37.7557306432777 | -122.49799735571399 | (37.7557306432777, -122.497997355714) | |
187381 | 187381 | 71611 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 623 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 12 | 5984406.18035 | 2111579.9668900003 | 37.777093266380895 | -122.497501046096 | (37.7770932663809, -122.497501046096) | ||
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) | |
165420 | 165420 | 54145 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1466 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 1 | Permit Number 33046 | 5984360.8296 | 2105192.6939 | 37.759552971646706 | -122.497186322988 | (37.7595529716467, -122.497186322988) | |
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) | |
155504 | 155504 | 92419 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1522 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52812 | 5984373.4381 | 2104797.5351 | 37.758468714959605 | -122.49711354866501 | (37.7584687149596, -122.497113548665) |
187582 | 187582 | 92421 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1746 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52814 | 5984424.3211 | 2103274.5158 | 37.7542899093449 | -122.496825171857 | (37.7542899093449, -122.496825171857) |
58155 | 58155 | 35169 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 414 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1998 12:00:00 AM | 15 | Permit Number 38703 | 5984710.8202 | 2113038.7099599997 | 37.781116404946204 | -122.496554889246 | (37.7811164049462, -122.496554889246) | |
84439 | 84439 | 109266 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2215 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773453 | 5984472.3 | 2100083.9 | 37.7455321666577 | -122.496423834874 | (37.7455321666577, -122.496423834874) |
149802 | 149802 | 47417 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 651 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 7 | Permit Number 45329 | 5984722.39837 | 2111425.70139 | 37.776688227426206 | -122.496395779641 | (37.7766882274262, -122.496395779641) | |
151438 | 151438 | 47418 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 651 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 8 | Permit Number 45329 | 5984724.00442 | 2111406.6238 | 37.776635939935105 | -122.49638881590401 | (37.7766359399351, -122.496388815904) | |
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) | |
130921 | 130921 | 43042 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2314 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 2 | Permit Number 42897 | 5984559.2908 | 2099412.1791 | 37.7436928996609 | -122.49607349102699 | (37.7436928996609, -122.496073491027) | |
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) | ||
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) | |
45459 | 45459 | 78391 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 783 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 10 | 5985063.0218400005 | 2110568.54337 | 37.774354665252396 | -122.495154256721 | (37.7743546652524, -122.495154256721) | ||
159990 | 159990 | 84515 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2626 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5984786.4387 | 2096844.8835 | 37.73665709999079 | -122.49509880737101 | (37.7366570999908, -122.495098807371) | |||
112813 | 112813 | 37232 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1818 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | Permit Number 39796 | 5985065.19615098 | 2102813.85172963 | 37.753062583548996 | -122.494574938806 | (37.753062583549, -122.494574938806) | ||
159376 | 159376 | 79095 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2194 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52806 | 5985150.1929 | 2100276.5552 | 37.7461008350271 | -122.49409401743799 | (37.7461008350271, -122.494094017438) |
77468 | 77468 | 92413 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2194 36th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52806 | 5985172.2 | 2100288.5 | 37.7461349199107 | -122.49401880101101 | (37.7461349199107, -122.494018801011) | |
97881 | 97881 | 92410 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2194 36th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52806 | 5985172.2 | 2100288.5 | 37.7461349199107 | -122.49401880101101 | (37.7461349199107, -122.494018801011) | |
122627 | 122627 | 92408 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2194 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52806 | 5985172.2 | 2100288.5 | 37.7461349199107 | -122.49401880101101 | (37.7461349199107, -122.494018801011) | |
127297 | 127297 | 92411 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2194 36th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52806 | 5985172.2 | 2100288.5 | 37.7461349199107 | -122.49401880101101 | (37.7461349199107, -122.494018801011) | |
138934 | 138934 | 92412 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2194 36th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52806 | 5985172.2 | 2100288.5 | 37.7461349199107 | -122.49401880101101 | (37.7461349199107, -122.494018801011) | |
145580 | 145580 | 92409 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2194 36th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52806 | 5985172.2 | 2100288.5 | 37.7461349199107 | -122.49401880101101 | (37.7461349199107, -122.494018801011) | |
101039 | 101039 | 109137 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 782 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773540 | 5985421.668819999 | 2110563.91491 | 37.7743629473402 | -122.493913306929 | (37.7743629473402, -122.493913306929) |
94385 | 94385 | 37230 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1775 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39794 | 5985312.74626408 | 2103137.72310777 | 37.753966330942795 | -122.493742738719 | (37.7539663309428, -122.493742738719) | ||
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) |
42527 | 42527 | 45595 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1754 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2001 12:00:00 AM | 2 | Permit Number 44331 | 5985359.1796 | 2103281.8076 | 37.75436466375329 | -122.493592779572 | (37.7543646637533, -122.493592779572) |
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");