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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 188440 | 188440 | 72308 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3496 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 15 | 5997591.22599 | 2116109.01981 | 37.7902928570799 | -122.452216943753 | (37.7902928570799, -122.452216943753) | ||
| 188273 | 188273 | 72327 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2776 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 16 | 5996291.43938 | 2111269.30989 | 37.776929758019904 | -122.456363986751 | (37.7769297580199, -122.456363986751) | ||
| 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) | |
| 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) |
| 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) | |
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 185618 | 185618 | 78542 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 918 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 11 | 5996973.29255 | 2086886.4307 | 37.710019470088206 | -122.452245463059 | (37.7100194700882, -122.452245463059) | ||
| 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) | |
| 185198 | 185198 | 72010 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1962 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 8 | 5986644.1013 | 2101904.8719 | 37.7506590557334 | -122.489048031087 | (37.7506590557334, -122.489048031087) | ||
| 185152 | 185152 | 83161 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1773-1775 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/24/2005 12:00:00 AM | 4 | 6014330.67048 | 2095268.0803900003 | 37.734012885882 | -122.392840540274 | (37.734012885882, -122.392840540274) | ||
| 185122 | 185122 | 84071 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1639 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5986834.2299 | 2104106.3182 | 37.756714724552104 | -122.488552342602 | (37.7567147245521, -122.488552342602) | |||
| 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) | |
| 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) | |
| 184576 | 184576 | 80734 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 70 Tucker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/16/2002 12:00:00 AM | 2 | 6010673.12959 | 2088678.9601200002 | 37.7157166977341 | -122.405022064239 | (37.7157166977341, -122.405022064239) | ||
| 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) | |
| 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) | |
| 183539 | 183539 | 70108 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2059 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 14 | 5987239.8218 | 2101265.4744 | 37.7489381940905 | -122.486941055856 | (37.7489381940905, -122.486941055856) | ||
| 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) | |
| 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) | |
| 181816 | 181816 | 75489 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2048 Jones St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/1997 12:00:00 AM | 12 | 6008179.24775 | 2119559.02881 | 37.8003665752162 | -122.41582743750799 | (37.8003665752162, -122.415827437508) | ||
| 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) | |
| 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) |
| 180979 | 180979 | 75157 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1350 Santiago St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 10 | 5x9 | 5988640.5527 | 2099701.3205 | 37.744725010437705 | -122.481982814963 | (37.7447250104377, -122.481982814963) | |
| 180943 | 180943 | 83574 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 194-194 Connecticut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 1 | 6013135.88002 | 2106202.3185099997 | 37.7639695289884 | -122.39773801610399 | (37.7639695289884, -122.397738016104) | ||
| 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) | |
| 180534 | 180534 | 80675 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 245 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 6009985.12224 | 2094065.2976 | 37.7304679742101 | -122.407779728251 | (37.7304679742101, -122.407779728251) | |||
| 180379 | 180379 | 78545 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 110 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/2000 12:00:00 AM | 7 | 5987422.7656 | 2115217.03849 | 37.78725598224489 | -122.487333085464 | (37.7872559822449, -122.487333085464) | ||
| 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) | |
| 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) | |
| 178560 | 178560 | 72842 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2658 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 7 | 5988669.6092 | 2097236.6843 | 37.7379594543884 | -122.481701857718 | (37.7379594543884, -122.481701857718) | ||
| 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) | |
| 177853 | 177853 | 74266 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1600 Cabrillo St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/1997 12:00:00 AM | 10 | 5990415.76389 | 2110639.6115 | 37.774861722089604 | -122.47664351536501 | (37.7748617220896, -122.476643515365) | ||
| 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) |
| 177498 | 177498 | 83768 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2207 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5986660.4861 | 2100216.6072 | 37.7460244920213 | -122.488867282426 | (37.7460244920213, -122.488867282426) | |||
| 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) | |
| 177131 | 177131 | 78415 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3070 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 6 | 5989117.40627 | 2094920.1200599999 | 37.731624795548896 | -122.479984139664 | (37.7316247955489, -122.479984139664) | ||
| 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) | |
| 176737 | 176737 | 82969 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 243 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 8 | 6002566.256709999 | 2092290.10285 | 37.7251755754681 | -122.43330098875 | (37.7251755754681, -122.43330098875) | ||
| 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) | |
| 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) |
| 175852 | 175852 | 71171 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2159 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 17 | 5987574.8362 | 2100606.2995 | 37.7471478031555 | -122.48573421706499 | (37.7471478031555, -122.485734217065) | ||
| 175552 | 175552 | 72009 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1954 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 7 | 5986645.6415 | 2101955.1867 | 37.7507972964546 | -122.489046403549 | (37.7507972964546, -122.489046403549) | ||
| 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) | |
| 175192 | 175192 | 70089 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3226 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/1992 12:00:00 AM | 8 | 5988610.07597 | 2111937.01448 | 37.778319129444604 | -122.482984802914 | (37.7783191294446, -122.482984802914) | ||
| 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) |
| 174883 | 174883 | 75553 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2048 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/1997 12:00:00 AM | 5 | 6008181.17324 | 2119540.92663 | 37.8003169794008 | -122.415819491999 | (37.8003169794008, -122.415819491999) | ||
| 174882 | 174882 | 71606 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 182 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 13 | 5994495.515430001 | 2086527.6412 | 37.708892062899 | -122.460783093263 | (37.708892062899, -122.460783093263) | ||
| 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) | |
| 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) | |
| 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) | |
| 172241 | 172241 | 74613 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1600 Cabrillo St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/1997 12:00:00 AM | 11 | 5990470.39839 | 2110643.18829 | 37.7748747117366 | -122.476454786513 | (37.7748747117366, -122.476454786513) | ||
| 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) | |
| 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) |
| 171282 | 171282 | 65110 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 140 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/2000 12:00:00 AM | 10 | Permit Number 27079 | 5989003.85631 | 2114418.82743 | 37.785156396067 | -122.481804422909 | (37.785156396067, -122.481804422909) | |
| 170956 | 170956 | 69401 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1158 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 9 | Permit Number 33505 | 6001276.42619 | 2087727.4959 | 37.71257442335379 | -122.43743321887501 | (37.7125744233538, -122.437433218875) | |
| 170880 | 170880 | 95743 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 587 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767489 | 6001815.52493 | 2090073.0284099998 | 37.7190453692361 | -122.43573763709401 | (37.7190453692361, -122.435737637094) |
| 170471 | 170471 | 94717 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 497 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53855 | 5993415.931469999 | 2112151.43646 | 37.7791863457452 | -122.466375292882 | (37.7791863457452, -122.466375292882) |
| 170439 | 170439 | 43819 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2820 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/2005 12:00:00 AM | 4 | Permit Number 43449 | 5985888.33 | 2096214.1549 | 37.7349897339382 | -122.491242740777 | (37.7349897339382, -122.491242740777) | |
| 170312 | 170312 | 44447 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 59 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 5 | Permit Number 43776 | 6002676.42201 | 2086971.7309400002 | 37.7105787512666 | -122.432540451876 | (37.7105787512666, -122.432540451876) | |
| 170273 | 170273 | 45505 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2951 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | 8 | Permit Number 44275 | 5989055.6947 | 2095601.0222900002 | 37.7334907925729 | -122.480247303776 | (37.7334907925729, -122.480247303776) | |
| 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) | |
| 169479 | 169479 | 44804 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1575 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 10 | Permit Number 43898 | 5987749.4562 | 2104586.1580000003 | 37.7580855968477 | -122.485422406584 | (37.7580855968477, -122.485422406584) | |
| 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) |
| 168247 | 168247 | 72402 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 770 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 6 | 5991347.32011 | 2110175.26 | 37.7736407273773 | -122.473387223074 | (37.7736407273773, -122.473387223074) | ||
| 167767 | 167767 | 74913 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1600 Cabrillo St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/1997 12:00:00 AM | 2 | 5990592.63982 | 2110647.77936 | 37.7748944063775 | -122.476032267507 | (37.7748944063775, -122.476032267507) | ||
| 167741 | 167741 | 72897 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2460 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 7 | 5989865.649 | 2098609.4089 | 37.7417980794693 | -122.477666915977 | (37.7417980794693, -122.477666915977) | ||
| 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) | |
| 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) |
| 166723 | 166723 | 48428 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2350 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2002 12:00:00 AM | 10 | Permit Number 45806 | 6001726.18635 | 2118402.88065 | 37.796827206972 | -122.43807468911001 | (37.796827206972, -122.43807468911) | |
| 166511 | 166511 | 38102 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1325 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 13 | Permit Number 40273 | 5987693.4941 | 2106273.0076 | 37.7627139647452 | -122.48573974790399 | (37.7627139647452, -122.485739747904) | |
| 166508 | 166508 | 35371 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 634 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 8 | Permit Number 38830 | 6010949.10035 | 2105147.0158 | 37.7609498870429 | -122.40522715823099 | (37.7609498870429, -122.405227158231) |
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");