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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7944 | 7944 | 114576 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3600 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6x7 | 5997488.7199800005 | 2115765.45327 | 37.7893436424566 | -122.452546800688 | (37.7893436424566, -122.452546800688) | |||
| 8086 | 8086 | 106947 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2710 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2014 12:00:00 AM | 1 | 3x3 | 5999608.44981 | 2118168.47191 | 37.796062919022205 | -122.445385661119 | (37.7960629190222, -122.445385661119) | ||
| 8099 | 8099 | 2468 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1860 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 3 | 4X4 | 6003974.6503 | 2114875.8941 | 37.787270613481205 | -122.430042754186 | (37.7872706134812, -122.430042754186) | ||
| 8129 | 8129 | 57513 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1534 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1976 12:00:00 AM | 20 | 3x3 | Permit Number 16366 | 6000152.6691 | 2114258.7858 | 37.7853589960394 | -122.443221617032 | (37.7853589960394, -122.443221617032) | |
| 8304 | 8304 | 121239 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 91 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2016 12:00:00 AM | 3 | 3x5 | Permit Number 778926 | 5996501.0724 | 2113967.4603 | 37.7843501979957 | -122.455833899065 | (37.7843501979957, -122.455833899065) | |
| 8328 | 8328 | 49474 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2612 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2003 12:00:00 AM | 3 | Permit Number 778382 | 6001188.38101 | 2117426.72551 | 37.7941163409457 | -122.43986559183399 | (37.7941163409457, -122.439865591834) | ||
| 8381 | 8381 | 71797 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2033 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 6 | 5998131.4502 | 2109940.9744 | 37.7733879494567 | -122.44990310006399 | (37.7733879494567, -122.449903100064) | ||
| 8644 | 8644 | 34950 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1928 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1997 12:00:00 AM | 8 | 3x3 | Permit Number 38548 | 6001980.6841 | 2115210.0928 | 37.7880751079735 | -122.43696537665501 | (37.7880751079735, -122.436965376655) | |
| 8653 | 8653 | 115708 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 778 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2016 12:00:00 AM | 3 | 3x3 | 6009816.75461 | 2118837.78852 | 37.798478147295 | -122.410110041641 | (37.798478147295, -122.410110041641) | ||
| 8834 | 8834 | 113406 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2120 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6006433.268180001 | 2118140.51551 | 37.796373386588606 | -122.42176841830201 | (37.7963733865886, -122.421768418302) | |||
| 9510 | 9510 | 46857 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2002 12:00:00 AM | Permit Number 44926 | |||||||||
| 9777 | 9777 | 88104 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1247 46th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 4x10 | Permit Number 51108 | 5981754.7 | 2106590.8 | 37.763238693975296 | -122.50630313344999 | (37.7632386939753, -122.50630313345) | |||
| 9798 | 9798 | 32469 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 124 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2016 12:00:00 AM | 3 | Permit Number 779287 | 6000593.0 | 2105649.0 | 37.7617437934708 | -122.441080293978 | (37.7617437934708, -122.441080293978) | |
| 9952 | 9952 | 39131 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 774 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | 2.5x3 | Permit Number 40811 | 6007313.40469967 | 2102804.1822591 | 37.7543130741871 | -122.417635411147 | (37.7543130741871, -122.417635411147) | |
| 10051 | 10051 | 122896 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 263 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2017 12:00:00 AM | 3 | Permit Number 779289 | 6004832.0 | 2098951.0 | 37.7435931826557 | -122.42594247475901 | (37.7435931826557, -122.425942474759) | ||
| 10053 | 10053 | 62845 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 263 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2017 12:00:00 AM | 3 | Permit Number 779289 | 6004872.17430855 | 2098981.93904651 | 37.7436804045703 | -122.425805763528 | (37.7436804045703, -122.425805763528) | ||
| 10056 | 10056 | 122897 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 263 29th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2017 12:00:00 AM | 3 | Permit Number 779289 | 6004872.17430855 | 2098981.93904651 | 37.7436804045703 | -122.425805763528 | (37.7436804045703, -122.425805763528) | ||
| 10122 | 10122 | 173861 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4618 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000547.0 | 2104681.0 | 37.7590832830794 | -122.441169935678 | (37.7590832830794, -122.441169935678) | ||||
| 10952 | 10952 | 43297 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1501 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2000 12:00:00 AM | Permit Number 43066 | ||||||||
| 11218 | 11218 | 68392 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 240 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779249 | 6001623.41455 | 2093933.0441299998 | 37.7296331848184 | -122.43667784142099 | (37.7296331848184, -122.436677841421) |
| 11228 | 11228 | 27092 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 717 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X3 | 6006103.20931 | 2093594.9436599999 | 37.728958403708894 | -122.42116669629699 | (37.7289584037089, -122.421166696297) | |||
| 11578 | 11578 | 27091 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 717 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X3 | 6006120.2550800005 | 2093595.10299 | 37.7289598021321 | -122.42110777902398 | (37.7289598021321, -122.421107779024) | |||
| 11708 | 11708 | 27702 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1140 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2000 12:00:00 AM | 6 | 2X3 | 6008343.29575 | 2093842.41085 | 37.729763925549506 | -122.41344002075701 | (37.7297639255495, -122.413440020757) | ||
| 11795 | 11795 | 31846 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 11987 | 11987 | 50020 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1208 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 4 | 2.5x4 | Permit Number 46754 | 6009698.1958800005 | 2090561.7050599998 | 37.7208317780481 | -122.408524628629 | (37.7208317780481, -122.408524628629) |
| 12256 | 12256 | 26978 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 532 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004762.815690001 | 2093485.8585299999 | 37.7285832245248 | -122.42579277741001 | (37.7285832245248, -122.42579277741) | |||
| 12530 | 12530 | 51006 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1262 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2004 12:00:00 AM | 3 | 3x3 | Permit Number 770221 | 5987105.8451 | 2106709.4716 | 37.7638781152555 | -122.48780425862302 | (37.7638781152555, -122.487804258623) | |
| 12580 | 12580 | 108559 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 247 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773718 | 6001785.96966 | 2094072.85918 | 37.7300263216596 | -122.43612587350701 | (37.7300263216596, -122.436125873507) |
| 12968 | 12968 | 35485 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1518 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/1998 12:00:00 AM | 5 | 3x3 | Permit Number 38896 | 5985922.1706 | 2104864.8854 | 37.7587442786876 | -122.49176237341999 | (37.7587442786876, -122.49176237342) | |
| 13011 | 13011 | 121633 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 715 Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778948 | 6002248.64047 | 2088586.4317299998 | 37.7149880967002 | -122.43413431136001 | (37.7149880967002, -122.43413431136) | |
| 13223 | 13223 | 33083 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 13393 | 13393 | 39264 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 540 Delancey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 8 | 3x3 | Permit Number 41406 | 6015215.52427 | 2113624.4278599997 | 37.7844645829043 | -122.39106388910601 | (37.7844645829043, -122.391063889106) |
| 13533 | 13533 | 116188 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1751 Carroll Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6013460.33766 | 2092361.8798900002 | 37.725984673034795 | -122.395646018568 | (37.7259846730348, -122.395646018568) | |||
| 13588 | 13588 | 26008 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1625 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6014811.10476 | 2095618.3620200001 | 37.7350013613099 | -122.391203993568 | (37.7350013613099, -122.391203993568) | |||
| 13630 | 13630 | 49513 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1648@3rd ST Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/2003 12:00:00 AM | Permit Number 46418 | 6014785.81315318 | 2094304.60337815 | 37.731392643231295 | -122.391199634158 | (37.7313926432313, -122.391199634158) | |||
| 14318 | 14318 | 17462 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2022 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6012632.03621 | 2096963.3752099997 | 37.7385733165067 | -122.398832221241 | (37.7385733165067, -122.398832221241) | |||
| 14563 | 14563 | 116184 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1751 Carroll Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013385.98536 | 2092427.1118400001 | 37.7261596505439 | -122.395907620544 | (37.7261596505439, -122.395907620544) | |||
| 14659 | 14659 | 117454 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 236 Shipley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776408 | 6011523.8482099995 | 2111775.6168299997 | 37.7791826325214 | -122.403705761636 | (37.7791826325214, -122.403705761636) | |
| 14764 | 14764 | 31856 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 44 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | 3x3 | Permit Number 35302 | 6009920.26283 | 2110981.2883599997 | 37.7769118830094 | -122.40919717941401 | (37.7769118830094, -122.409197179414) |
| 14881 | 14881 | 33084 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 14896 | 14896 | 100885 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 91 Welsh St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013481.274680001 | 2111873.9835900003 | 37.779561876626296 | -122.396941070175 | (37.7795618766263, -122.396941070175) | |||
| 14998 | 14998 | 44032 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 96 Lafayette St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2014 12:00:00 AM | 1 | 3x3 | Permit Number 43568 | 6007703.80848 | 2109483.89132 | 37.7726759646606 | -122.41675848404199 | (37.7726759646606, -122.416758484042) | |
| 15282 | 15282 | 39266 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 540 Delancey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 8 | 3x3 | Permit Number 41406 | 6015200.60575 | 2113640.87265 | 37.784508908704 | -122.39111665233101 | (37.784508908704, -122.391116652331) |
| 15400 | 15400 | 51397 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 20 Ringold St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | 5 | 2x3 | Permit Number 47723 | 6009698.00166 | 2110029.82687 | 37.77428693821211 | -122.409898870931 | (37.7742869382121, -122.409898870931) |
| 15470 | 15470 | 116187 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1751 Carroll Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013439.38211 | 2092375.3069099998 | 37.7260203752154 | -122.395719401447 | (37.7260203752154, -122.395719401447) | |||
| 15502 | 15502 | 119264 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1243 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6013843.6616400005 | 2105220.96082 | 37.7613143247043 | -122.39522124448798 | (37.7613143247043, -122.395221244488) | |||
| 15547 | 15547 | 100883 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 91 Welsh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013382.01151 | 2111778.63358 | 37.779294541435796 | -122.397277778167 | (37.7792945414358, -122.397277778167) | |||
| 15827 | 15827 | 100893 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 91 Welsh St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013651.46361 | 2112030.89517 | 37.7800021918959 | -122.396363310639 | (37.7800021918959, -122.396363310639) | |||
| 16101 | 16101 | 100887 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 91 Welsh St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013527.06662 | 2111917.77164 | 37.7796846574549 | -122.39678572578899 | (37.7796846574549, -122.396785725789) | |||
| 16275 | 16275 | 116186 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1751 Carroll Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6013421.91014 | 2092392.0296900002 | 37.726065320631896 | -122.39578097261699 | (37.7260653206319, -122.395780972617) | |||
| 16551 | 16551 | 116185 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1751 Carroll Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013402.92261 | 2092407.9070599999 | 37.7261078603777 | -122.395847723887 | (37.7261078603777, -122.395847723887) | |||
| 16625 | 16625 | 100886 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 91 Welsh St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013501.81999 | 2111894.49362 | 37.7796193360911 | -122.396871432992 | (37.7796193360911, -122.396871432992) | |||
| 16626 | 16626 | 39265 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 540 Delancey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 8 | 3x3 | Permit Number 41406 | 6015189.334319999 | 2113651.1602 | 37.78453653049 | -122.391156367288 | (37.78453653049, -122.391156367288) |
| 16805 | 16805 | 25996 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1773 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 3 | 3X3 | 6014137.90687 | 2096120.20835 | 37.7363419456235 | -122.39356660700899 | (37.7363419456235, -122.393566607009) | ||
| 16872 | 16872 | 42242 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 546x Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | 6 | 2x2 | Permit Number 42491 | 6010065.33098 | 2111880.30804 | 37.779388506222 | -122.408758782403 | (37.779388506222, -122.408758782403) | |
| 17119 | 17119 | 32210 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 85 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2016 12:00:00 AM | 3 | 3x6 | Permit Number 778854 | 6009682.7318 | 2099892.2355400003 | 37.746450553849705 | -122.40923616951599 | (37.7464505538497, -122.409236169516) | |
| 17368 | 17368 | 31107 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 237 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | 12 | 2x9 | Permit Number 34836 | 5998741.10559 | 2093696.6729599999 | 37.7288199422639 | -122.44662524706101 | (37.7288199422639, -122.446625247061) | |
| 17693 | 17693 | 5140 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2922 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2011 12:00:00 AM | 3 | 3x3 | 6002319.208819999 | 2095185.9682200002 | 37.7331129460068 | -122.43436195314399 | (37.7331129460068, -122.434361953144) | ||
| 17729 | 17729 | 10111 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 817 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2x2 | 6005691.67507 | 2104204.22323 | 37.758065870971706 | -122.423343289458 | (37.7580658709717, -122.423343289458) | |||
| 17839 | 17839 | 45141 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1300 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2001 12:00:00 AM | Permit Number 43998 | 6000329.1714268 | 2109256.8846269 | 37.7716351145449 | -122.442251776367 | (37.7716351145449, -122.442251776367) | ||
| 17861 | 17861 | 36571 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 193 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1998 12:00:00 AM | Permit Number 39434 | 6006550.67564365 | 2097394.54535781 | 37.739416487692 | -122.41988928119801 | (37.739416487692, -122.419889281198) | ||
| 17879 | 17879 | 68381 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 42 Uranus Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32206 | 5999268.74613245 | 2105519.44927205 | 37.76131256253829 | -122.445651023552 | (37.7613125625383, -122.445651023552) | ||
| 17951 | 17951 | 22845 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Turquoise Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1997 12:00:00 AM | 16 | 1X1 | 5999785.45831 | 2099029.41993 | 37.7435220087408 | -122.44339775201401 | (37.7435220087408, -122.443397752014) | ||
| 18134 | 18134 | 28387 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1271 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2003 12:00:00 AM | 3 | 3X3 | 6004513.78886 | 2101505.14883 | 37.7505882968197 | -122.427224669004 | (37.7505882968197, -122.427224669004) | ||
| 18253 | 18253 | 4301 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4374 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001502.87912 | 2100307.76951 | 37.7471298441855 | -122.43755087718 | (37.7471298441855, -122.43755087718) | |||
| 18482 | 18482 | 50084 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 163 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46816 | 5992385.51984068 | 2098065.73695017 | 37.7404512063716 | -122.468914554715 | (37.7404512063716, -122.468914554715) | ||
| 18542 | 18542 | 31283 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2574 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2016 12:00:00 AM | 3 | Permit Number 778680 | 5991125.83447 | 2097900.24985 | 37.7399239615173 | -122.47325794369199 | (37.7399239615173, -122.473257943692) | |
| 18701 | 18701 | 22848 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Turquoise Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 1X1 | 5999801.2823 | 2099039.75864 | 37.743551298748 | -122.44334377921601 | (37.743551298748, -122.443343779216) | |||
| 18838 | 18838 | 43257 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 400 Burrows St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43041 | 6010158.39254276 | 2093206.15154528 | 37.728118638728105 | -122.407120168437 | (37.7281186387281, -122.407120168437) | ||
| 18880 | 18880 | 25589 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1380X Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6009160.7320011 | 2097455.9675674997 | 37.7397318376167 | -122.410869155933 | (37.7397318376167, -122.410869155933) | |||
| 18974 | 18974 | 10193 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1170 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2x2 | 6005736.259869999 | 2102154.58599 | 37.752440559408896 | -122.42304341594699 | (37.7524405594089, -122.423043415947) | |||
| 19048 | 19048 | 10142 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 915 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2x2 | 6005723.61297 | 2103645.6305400003 | 37.7565339082426 | -122.42319312877599 | (37.7565339082426, -122.423193128776) | |||
| 19102 | 19102 | 48673 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 420 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2002 12:00:00 AM | Permit Number 45956 | 6002102.91710872 | 2103385.70582138 | 37.7556152218159 | -122.43569617174101 | (37.7556152218159, -122.435696171741) | |||
| 19412 | 19412 | 68594 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1776 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32496 | 5991255.24615708 | 2103348.30667764 | 37.754890406441895 | -122.47320772508499 | (37.7548904064419, -122.473207725085) | ||
| 19495 | 19495 | 40538 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 384 San Benito Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1999 12:00:00 AM | Permit Number 41587 | 5992631.08642927 | 2094049.19194754 | 37.7294369636011 | -122.46777343904101 | (37.7294369636011, -122.467773439041) | |||
| 19736 | 19736 | 121676 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 65 Sotelo Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993867.0 | 2101351.0 | 37.7495571916966 | -122.464030639739 | (37.7495571916966, -122.464030639739) | ||||
| 19737 | 19737 | 43124 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 306 Elsie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2000 12:00:00 AM | Permit Number 42942 | 6006590.61283403 | 2097446.1617064998 | 37.7395604645493 | -122.41975485718001 | (37.7395604645493, -122.41975485718) | |||
| 19803 | 19803 | 40552 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 380 San Leandro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 41594 | 5992231.83033974 | 2094391.07598337 | 37.7303526300924 | -122.46917856626301 | (37.7303526300924, -122.469178566263) | ||
| 19839 | 19839 | 46807 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 170 San Felipe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44891 | 5994047.88467272 | 2095052.68932043 | 37.7322740285646 | -122.46294824520201 | (37.7322740285646, -122.462948245202) | ||
| 19854 | 19854 | 22847 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Turquoise Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 1X1 | 5999792.57079 | 2099032.92975 | 37.7435320514679 | -122.44337341096 | (37.7435320514679, -122.44337341096) | |||
| 19941 | 19941 | 28386 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2749 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 9 | 3X3 | 6009842.67473 | 2101317.3868299997 | 37.750372664569504 | -122.408783629764 | (37.7503726645695, -122.408783629764) | ||
| 20053 | 20053 | 5099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2621 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002328.495730001 | 2096416.0838900001 | 37.736491088285796 | -122.434417765086 | (37.7364910882858, -122.434417765086) | |||
| 20385 | 20385 | 39056 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009422.123 | 2105494.394 | 37.7618182216771 | -122.410532856099 | (37.7618182216771, -122.410532856099) | ||
| 20484 | 20484 | 39027 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009258.495 | 2105867.224 | 37.7628327529372 | -122.41112511890101 | (37.7628327529372, -122.411125118901) | ||
| 20490 | 20490 | 68099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 9 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31844 | 6006420.25408514 | 2099944.49896622 | 37.7464107382986 | -122.42052117977501 | (37.7464107382986, -122.420521179775) | ||
| 20623 | 20623 | 39050 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009499.38 | 2105599.429 | 37.762110954787005 | -122.410273070025 | (37.762110954787, -122.410273070025) | ||
| 20911 | 20911 | 50946 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1134 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2014 12:00:00 AM | 3 | Permit Number 773916 | 6007565.24376916 | 2118876.40998362 | 37.7984577381814 | -122.417903725033 | (37.7984577381814, -122.417903725033) | ||
| 20981 | 20981 | 40426 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 572 Wildwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41522 | 5994442.84312797 | 2093351.87569512 | 37.7276267513816 | -122.46145953493901 | (37.7276267513816, -122.461459534939) | ||
| 21103 | 21103 | 10099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 750 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1995 12:00:00 AM | 30 | 2x2 | 6005606.10854 | 2104557.89173 | 37.7590321322447 | -122.423664360924 | (37.7590321322447, -122.423664360924) | ||
| 21203 | 21203 | 47373 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 800 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | Permit Number 45290 | 5991938.31220881 | 2089883.64331253 | 37.7179593670507 | -122.469865242758 | (37.7179593670507, -122.469865242758) | |||
| 21241 | 21241 | 41670 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 500 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42131 | 5999528.76445246 | 2104225.15584588 | 37.7577735947767 | -122.44465870166599 | (37.7577735947767, -122.444658701666) | ||
| 21320 | 21320 | 10210 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1306 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/1992 12:00:00 AM | 18 | 2X2 | 6005782.73241 | 2101317.8159 | 37.7501456037461 | -122.42282324301901 | (37.7501456037461, -122.422823243019) | ||
| 21476 | 21476 | 16622 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 133 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002888.88219 | 2107504.60291 | 37.766969331884 | -122.433272362446 | (37.766969331884, -122.433272362446) | |||
| 21684 | 21684 | 10064 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 512 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/1991 12:00:00 AM | 30 | 3X3 | 6005527.25593 | 2105966.68025 | 37.762895882361 | -122.42403725491 | (37.762895882361, -122.42403725491) | ||
| 21899 | 21899 | 24817 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 400X Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2015 12:00:00 AM | 4 | 3x3 | 6007985.05958 | 2094993.5090299998 | 37.7329044714678 | -122.41475991886101 | (37.7329044714678, -122.414759918861) | ||
| 22170 | 22170 | 17373 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1050X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5999390.9816 | 2109231.8772 | 37.771512935512796 | -122.44549522045601 | (37.7715129355128, -122.445495220456) | |||
| 22284 | 22284 | 196235 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 474 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010444.82065 | 2112504.83625 | 37.781124561999995 | -122.407490004484 | (37.781124562, -122.407490004484) | |||
| 22288 | 22288 | 237856 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 636 30th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 6ft | 6002455.57988 | 2098272.49197 | 37.7415955682714 | -122.434111048608 | (37.7415955682714, -122.434111048608) | |||
| 22376 | 22376 | 2581 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1671 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1990 12:00:00 AM | 12 | 4X4 | 6005533.42791 | 2115131.9638 | 37.7880618747142 | -122.42466793237699 | (37.7880618747142, -122.424667932377) | ||
| 22815 | 22815 | 237464 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4255 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001532.2528099995 | 2101727.17835 | 37.7510288729044 | -122.437550937446 | (37.7510288729044, -122.437550937446) |
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");