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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) |
188971 | 188971 | 55570 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 81 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/1973 12:00:00 AM | 5 | Permit Number 49713 | 5996815.9739 | 2114044.1129 | 37.7845787332894 | -122.45474999571998 | (37.7845787332894, -122.45474999572) | ||
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) | |
188729 | 188729 | 88433 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 484 09th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 8 | 3x3 | Permit Number 51378 | 5993148.8705 | 2112173.6098700003 | 37.7792318146847 | -122.46730077142901 | (37.7792318146847, -122.467300771429) | |
188192 | 188192 | 114813 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1315-- 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Permit Number 775040 | 5987054.5 | 2106285.6 | 37.7627112856961 | -122.487950697253 | (37.7627112856961, -122.487950697253) | |||
188137 | 188137 | 46822 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 571 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | 7 | Permit Number 44900 | 6003370.246180001 | 2090017.12379 | 37.7189800568605 | -122.430359583339 | (37.7189800568605, -122.430359583339) | |
188115 | 188115 | 31154 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 259 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 8 | Permit Number 34857 | 5998376.74156 | 2093783.98497 | 37.7290388606445 | -122.447891156156 | (37.7290388606445, -122.447891156156) | |
188076 | 188076 | 40714 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 634 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/2006 12:00:00 AM | 8 | Permit Number 48841 | 5994113.99611 | 2111184.89224 | 37.7765727285077 | -122.463890241988 | (37.7765727285077, -122.463890241988) | |
187984 | 187984 | 33233 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2616 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 4 | Permit Number 49352 | 5988969.8261 | 2097510.338 | 37.7387282896824 | -122.480683899813 | (37.7387282896824, -122.480683899813) | |
187727 | 187727 | 52853 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1334@ IRVING 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | Permit Number 48861 | 5983712.5574 | 2106045.4474 | 37.761856379175896 | -122.499491355681 | (37.7618563791759, -122.499491355681) | ||
187708 | 187708 | 96682 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 375@32nd Ave 32nd Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 5 | Permit Number 768040 | 5985880.71623 | 2113435.4542400003 | 37.7822742209113 | -122.492536917229 | (37.7822742209113, -122.492536917229) | ||
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) |
187573 | 187573 | 104823 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 641 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2013 12:00:00 AM | 2 | 3x3 | Permit Number 771081 | 5987509.53271 | 2111566.66512 | 37.7772381546113 | -122.48676473846001 | (37.7772381546113, -122.48676473846) | |
187467 | 187467 | 30971 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1918 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 21 | Permit Number 34762 | 6004982.43732 | 2117138.20342 | 37.79353937010811 | -122.426717189659 | (37.7935393701081, -122.426717189659) | |
187451 | 187451 | 44412 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 33 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 13 | Permit Number 43763 | 6002334.21635 | 2087134.94604 | 37.7110074922697 | -122.43373484600201 | (37.7110074922697, -122.433734846002) | |
187312 | 187312 | 88052 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1636 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51062 | 6014945.3864 | 2094540.9532 | 37.732050466410705 | -122.39066446510401 | (37.7320504664107, -122.390664465104) | |
187243 | 187243 | 95930 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 525 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767627 | 5987483.09565 | 2112350.67987 | 37.7793892963815 | -122.486913781541 | (37.7793892963815, -122.486913781541) |
186925 | 186925 | 92365 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1911 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52778 | 5985970.1405 | 2102197.0919999997 | 37.7514220529755 | -122.491400116824 | (37.7514220529755, -122.491400116824) |
186833 | 186833 | 30969 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1910 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 16 | Permit Number 34760 | 6005001.01631 | 2117138.70127 | 37.7935417874622 | -122.42665294030701 | (37.7935417874622, -122.426652940307) | |
186734 | 186734 | 96640 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1030 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2011 12:00:00 AM | 1 | 3x3 | Permit Number 58521 | 6014191.0963 | 2102328.42234 | 37.753391354137705 | -122.393817130265 | (37.7533913541377, -122.393817130265) | |
186706 | 186706 | 32282 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2001 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | 5 | Permit Number 36865 | 6004496.46738 | 2117350.5192299997 | 37.7940948480409 | -122.428413824545 | (37.7940948480409, -122.428413824545) | ||
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) | |
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) |
186129 | 186129 | 47806 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 81 Escondido Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2002 12:00:00 AM | 9 | Permit Number 45574 | 5986047.257999999 | 2096098.209 | 37.73468066215221 | -122.49068474985901 | (37.7346806621522, -122.490684749859) | |
186114 | 186114 | 114812 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1315-- 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2015 12:00:00 AM | 8 | Permit Number 775040 | 5987054.5 | 2106285.6 | 37.7627112856961 | -122.487950697253 | (37.7627112856961, -122.487950697253) | ||
185789 | 185789 | 32755 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 542 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 11 | Permit Number 37133 | 5995923.45936 | 2088920.5817599997 | 37.7155445773895 | -122.456020830506 | (37.7155445773895, -122.456020830506) | |
185510 | 185510 | 47808 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 86 Escondido Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2002 12:00:00 AM | 9 | Permit Number 45575 | 5986031.0734 | 2096127.1292 | 37.734759123950504 | -122.49074283196 | (37.7347591239505, -122.49074283196) | |
185393 | 185393 | 52945 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 88 Rudden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 10 | Permit Number 48932 | 6000012.5023 | 2092117.8854 | 37.7245574984177 | -122.442116674051 | (37.7245574984177, -122.442116674051) | |
185337 | 185337 | 98165 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 760 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2011 12:00:00 AM | 4 | 3x3 | Permit Number 768065 | 5987585.510559999 | 2110747.9701 | 37.7749946773759 | -122.48644178693998 | (37.7749946773759, -122.48644178694) | |
185241 | 185241 | 99254 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 250X Locust St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2014 12:00:00 AM | 1 | Permit Number 771748 | 5997615.93287 | 2115496.61123 | 37.7886127616243 | -122.45208725612801 | (37.7886127616243, -122.452087256128) | ||
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) | |
184939 | 184939 | 49672 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2235 NOTES) Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2003 12:00:00 AM | 7 | Permit Number 46511 | 5997280.0322 | 2109824.8458 | 37.773020337563295 | -122.45283987596301 | (37.7730203375633, -122.452839875963) | ||
184692 | 184692 | 63545 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1445 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2010 12:00:00 AM | 2 | Permit Number 53649 | 6000845.5770000005 | 2111011.6433 | 37.7764826579532 | -122.44059138546899 | (37.7764826579532, -122.440591385469) | |
184517 | 184517 | 38134 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 260 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1998 12:00:00 AM | 13 | Permit Number 40296 | 6010387.55898 | 2093430.59312 | 37.728747730299396 | -122.406343735772 | (37.7287477302994, -122.406343735772) | |
184385 | 184385 | 84817 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 745 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 4 | Permit No. 49248 | 5987845.994969999 | 2110882.11125 | 37.7753781714762 | -122.48555057282 | (37.7753781714762, -122.48555057282) | ||
184184 | 184184 | 91141 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 350 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52027 | 5985933.94552 | 2113551.49792 | 37.782595955530795 | -122.492361318151 | (37.7825959555308, -122.492361318151) | |
183664 | 183664 | 40006 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 930 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 12 | Permit Number 41259 | 6019126.39744 | 2094573.6221900003 | 37.7323712445238 | -122.376211900284 | (37.7323712445238, -122.376211900284) | |
183604 | 183604 | 45231 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 901-999X Felton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2001 12:00:00 AM | 6 | Permit Number 44058 | 6008234.49101 | 2093045.1093400002 | 37.727568596805895 | -122.41375979808399 | (37.7275685968059, -122.413759798084) | |
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) | |
183289 | 183289 | 44221 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2211 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 7 | Permit Number 43976 | 5987588.429 | 2100234.7436 | 37.7461284017404 | -122.48565995038099 | (37.7461284017404, -122.485659950381) | |
183019 | 183019 | 51765 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 570 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | 8 | Permit Number 48031 | 5983818.24355 | 2111949.18023 | 37.7780725402776 | -122.49956216494199 | (37.7780725402776, -122.499562164942) | ||
182951 | 182951 | 95575 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 420 29th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767364 | 5986881.0139 | 2113113.76746 | 37.781449395794 | -122.48905272232099 | (37.781449395794, -122.489052722321) | |
182468 | 182468 | 32035 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 647 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2004 12:00:00 AM | 3 | Permit Number 47322 | 6013311.96232 | 2104072.454 | 37.7581311923248 | -122.39697965289801 | (37.7581311923248, -122.396979652898) | |
182416 | 182416 | 81441 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1271 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52797 | 5985510.7412 | 2106582.5663 | 37.7634364978361 | -122.49331181219401 | (37.7634364978361, -122.493311812194) |
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) | |
182288 | 182288 | 95888 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1652 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767597 | 5989673.5494 | 2104088.1425 | 37.756830088921795 | -122.478731719422 | (37.7568300889218, -122.478731719422) |
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) | |
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) | |
181710 | 181710 | 78954 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1455 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52701 | 5985554.2212 | 2105321.6926 | 37.7599770326814 | -122.493068543647 | (37.7599770326814, -122.493068543647) | |
181698 | 181698 | 38207 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 769 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 7 | Permit Number 46759 | 6010826.16634 | 2091125.03762 | 37.7224416796263 | -122.404665194362 | (37.7224416796263, -122.404665194362) | |
181451 | 181451 | 62776 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 46 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | 4 | Permit Number 23131 | 6000604.71356 | 2093045.9120900002 | 37.7271393791645 | -122.440135999075 | (37.7271393791645, -122.440135999075) | |
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) | |
181388 | 181388 | 39992 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 744 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 10 | Permit Number 41250 | 6020175.81777 | 2093790.38567 | 37.7302783476475 | -122.372529577584 | (37.7302783476475, -122.372529577584) | |
181298 | 181298 | 97892 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 401x Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/02/2010 12:00:00 AM | 8 | 3x3 | Permit Number 55034 | 6002514.74306 | 2090342.41745 | 37.7198247442045 | -122.433339952791 | (37.7198247442045, -122.433339952791) | |
181274 | 181274 | 92249 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1382 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52698 | 5985580.0638 | 2105823.8988 | 37.76135746276721 | -122.493016162233 | (37.7613574627672, -122.493016162233) | |
181093 | 181093 | 95748 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 636 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767493 | 6001131.03467 | 2090095.7022099998 | 37.719068721911796 | -122.438105273239 | (37.7190687219118, -122.438105273239) |
181074 | 181074 | 50431 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3015 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2003 12:00:00 AM | 12 | Permit Number 47085 | 5999663.83751 | 2116673.7632299997 | 37.7919620059909 | -122.44508649896002 | (37.7919620059909, -122.44508649896) | ||
180805 | 180805 | 67206 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1475 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52888 | 5985246.6127 | 2105187.5503 | 37.7595907202078 | -122.494122510373 | (37.7595907202078, -122.494122510373) | |
180720 | 180720 | 44398 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1076 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 14 | Permit Number 43753 | 6002036.48794 | 2087189.47909 | 37.7111403293394 | -122.43476776231701 | (37.7111403293394, -122.434767762317) | |
180245 | 180245 | 44388 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 375 Chicago Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | 11 | Permit Number 43748 | 6002261.2315 | 2086392.26553 | 37.708964112084104 | -122.433934046742 | (37.7089641120841, -122.433934046742) | |
179604 | 179604 | 37624 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 675 17th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40046 | 5990638.90624 | 2110851.12514 | 37.7754554207664 | -122.475887077324 | (37.7754554207664, -122.475887077324) | ||
178852 | 178852 | 68655 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 224 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2008 12:00:00 AM | 10 | 3x3 | Permit Number 50631 | 5993706.0928 | 2113977.7160400003 | 37.7842175531194 | -122.465504221713 | (37.7842175531194, -122.465504221713) | |
178695 | 178695 | 40377 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1262 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767616 | 5987415.8819 | 2106684.6687 | 37.763828092777 | -122.486730127288 | (37.763828092777, -122.486730127288) |
178636 | 178636 | 30813 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 122 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 15 | Permit Number 34675 | 6001247.81391 | 2094960.1313900002 | 37.7324319775395 | -122.43804987230601 | (37.7324319775395, -122.438049872306) | |
178493 | 178493 | 45222 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 836 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2001 12:00:00 AM | 10 | Permit Number 44055 | 6008394.25579 | 2093141.80022 | 37.7278430600039 | -122.41321432238999 | (37.7278430600039, -122.41321432239) | |
178228 | 178228 | 88550 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 510 15th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51496 | 5991284.738609999 | 2111880.83878 | 37.7783201568365 | -122.473728146301 | (37.7783201568365, -122.473728146301) | ||
178069 | 178069 | 37628 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 675 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1998 12:00:00 AM | 5 | Permit Number 40046 | 5990635.06778 | 2110942.76821 | 37.7757068249456 | -122.47590704954901 | (37.7757068249456, -122.475907049549) | ||
177539 | 177539 | 93185 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3918 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53194 | 6011646.22498 | 2088249.7592900002 | 37.714592547886 | -122.40162843201901 | (37.714592547886, -122.401628432019) | |
177537 | 177537 | 92301 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2630 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52745 | 5989593.1907 | 2097437.9636 | 37.738565779135705 | -122.478523332026 | (37.7385657791357, -122.478523332026) |
177460 | 177460 | 85266 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1153 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | 6 | Permit Number 49560 | 6001485.8451 | 2088459.53327 | 37.714596339430706 | -122.43676177243499 | (37.7145963394307, -122.436761772435) | ||
177419 | 177419 | 62960 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1356 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1986 12:00:00 AM | 6 | Permit Number 23346 | 6007109.63431 | 2118120.3439 | 37.796356118702604 | -122.419426611558 | (37.7963561187026, -122.419426611558) | |
177280 | 177280 | 33262 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1421 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 4 | Permit Number 37437 | 5988564.5083506 | 2097603.21531438 | 37.7389597407729 | -122.48209208288 | (37.7389597407729, -122.48209208288) | |
177179 | 177179 | 41481 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3045 Santiago St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2000 12:00:00 AM | 3 | Permit Number 42908 | 5983495.2644 | 2099467.4861 | 37.7437823774698 | -122.499756666387 | (37.7437823774698, -122.499756666387) | ||
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) | |
176587 | 176587 | 45229 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 901-999X Felton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2001 12:00:00 AM | 5 | Permit Number 44057 | 6008179.058180001 | 2093028.82452 | 37.7275207690487 | -122.413950278985 | (37.7275207690487, -122.413950278985) | |
176321 | 176321 | 35738 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 363 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2009 12:00:00 AM | 4 | 3x3 | Permit Number 53096 | 6008748.13827 | 2094279.26862 | 37.7309861662564 | -122.412071291268 | (37.7309861662564, -122.412071291268) | |
176197 | 176197 | 72158 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 24 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51156 | 6000903.08392 | 2092942.4394200002 | 37.7268722490426 | -122.43909712563999 | (37.7268722490426, -122.43909712564) | |
176030 | 176030 | 42629 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1999X Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42684 | 6004109.92216 | 2117990.11253 | 37.7958291267766 | -122.42979695308901 | (37.7958291267766, -122.429796953089) | |
175867 | 175867 | 92289 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2444 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52736 | 5989860.1608 | 2098723.9303 | 37.7421122070231 | -122.47769426133699 | (37.7421122070231, -122.477694261337) |
175745 | 175745 | 88400 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 484 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 8 | 3x3 | Permit Number 51378 | 5993152.67361 | 2112124.53449 | 37.779097286521605 | -122.46728404568 | (37.7790972865216, -122.46728404568) | |
175388 | 175388 | 39916 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2107 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2005 12:00:00 AM | 4 | Permit Number 41193 | 6001859.33399 | 2115759.57552 | 37.78957694817429 | -122.437424588992 | (37.7895769481743, -122.437424588992) | |
175231 | 175231 | 81854 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 759 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2007 12:00:00 AM | 8 | 3x3 | Permit Number 49989 | 5983510.57514 | 2110642.3743 | 37.774466373094896 | -122.50052983286301 | (37.7744663730949, -122.500529832863) | |
175104 | 175104 | 44469 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1604 Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 14 | 6x6 | Permit Number 43783 | 6006190.30201 | 2092468.08646 | 37.7258692090916 | -122.420785642746 | (37.7258692090916, -122.420785642746) |
175025 | 175025 | 82344 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 274 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 9 | 3x3 | Permit Number 50645 | 6004360.68581 | 2091681.3945900002 | 37.7236058331362 | -122.42705449296699 | (37.7236058331362, -122.427054492967) | |
174928 | 174928 | 30333 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 601 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/1956 12:00:00 AM | 1 | Permit Number 24 | 6002580.56615 | 2098860.5485099996 | 37.7432173274264 | -122.433720908293 | (37.7432173274264, -122.433720908293) | ||
174789 | 174789 | 52951 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 769 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 11 | Permit Number 48938 | 6001359.06422 | 2092543.42417 | 37.725802579203894 | -122.437492253971 | (37.7258025792039, -122.437492253971) | |
174671 | 174671 | 114886 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 100x Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/2015 12:00:00 AM | 2 | 6014239.62744 | 2106569.15275 | 37.76503817809321 | -122.393946133513 | (37.7650381780932, -122.393946133513) | |||
174635 | 174635 | 56831 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1600 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2011 12:00:00 AM | 2 | 6x3 | Permit Number 768070 | 5989013.4826 | 2103128.5968 | 37.7541570854958 | -122.48094419570499 | (37.7541570854958, -122.480944195705) | |
174311 | 174311 | 52148 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1542 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 6 | Permit Number 48339 | 6015840.90736 | 2097015.91645 | 37.7388958583569 | -122.38774104790701 | (37.7388958583569, -122.387741047907) | |
174251 | 174251 | 84857 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1514 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 2 | Permit No. 49251 | 5986855.6079 | 2104922.1937 | 37.758956142866104 | -122.48853837343201 | (37.7589561428661, -122.488538373432) | ||
173010 | 173010 | 97265 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 438 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768026 | 5985026.35144 | 2112889.76682 | 37.7807259308617 | -122.49545233660601 | (37.7807259308617, -122.495452336606) | |
172655 | 172655 | 42871 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2555 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 3 | Permit Number 42794 | 5986429.7308 | 2097866.9531 | 37.739559500005605 | -122.489492447039 | (37.7395595000056, -122.489492447039) | |
172647 | 172647 | 67624 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1140 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 15 | Permit Number 31210 | 6008085.564669999 | 2118599.77366 | 37.797727432817794 | -122.41608364716801 | (37.7977274328178, -122.416083647168) | |
172524 | 172524 | 84860 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1555 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2007 12:00:00 AM | 4 | Permit No. 49265 | 5987436.0033 | 2104691.0776 | 37.7583554107844 | -122.486514150511 | (37.7583554107844, -122.486514150511) | ||
172470 | 172470 | 44066 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 641 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2005 12:00:00 AM | 2 | Permit Number 47823 | 6013311.6161400005 | 2104098.70686 | 37.7582032576849 | -122.396982690812 | (37.7582032576849, -122.396982690812) | ||
172081 | 172081 | 94367 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 5100@ Fulton Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2010 12:00:00 AM | 3 | Permit Number 53639 | 5987467.903969999 | 2109853.1131 | 37.77253079484171 | -122.486782882641 | (37.7725307948417, -122.486782882641) | ||
171832 | 171832 | 46593 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1500 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | 3 | Permit Number 44722 | 6016041.39566 | 2096866.9596 | 37.7384979569136 | -122.387037459737 | (37.7384979569136, -122.387037459737) | |
171548 | 171548 | 44395 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 106 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 16 | Permit Number 43751 | 6001724.925980001 | 2087542.0541599998 | 37.71209072926629 | -122.43586980595501 | (37.7120907292663, -122.435869805955) | |
171382 | 171382 | 33319 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2929 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1996 12:00:00 AM | 15 | Permit Number 37463 | 6004723.4328 | 2119639.75641 | 37.800393348939295 | -122.42779169063999 | (37.8003933489393, -122.42779169064) | ||
171347 | 171347 | 67368 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 720 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1992 12:00:00 AM | 5 | 6x6 | Permit Number 30861 | 5992280.48325 | 2110516.00698 | 37.774630318629605 | -122.470184116432 | (37.7746303186296, -122.470184116432) |
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");