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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3043 | 3043 | 244994 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 231 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | 4 | Width 0ft | Permit Number 45013 | 6005396.3109 | 2110099.8972 | 37.774237312156295 | -122.4247842062 | (37.7742373121563, -122.4247842062) | |
3084 | 3084 | 238169 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1018 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1989 12:00:00 AM | 2 | Width 4ft | Permit Number 27197 | 6003120.08624 | 2102266.16095 | 37.7525989407879 | -122.432098539422 | (37.7525989407879, -122.432098539422) | |
3100 | 3100 | 124475 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 336 Willard St North | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 1 | Width 3ft | Permit Number 51142 | 5996295.75285 | 2110564.44719 | 37.7749946376288 | -122.456298087251 | (37.7749946376288, -122.456298087251) | |
3103 | 3103 | 238168 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1010 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1989 12:00:00 AM | 14 | Width 4ft | Permit Number 27196 | 6003119.41534 | 2102323.30502 | 37.7527558068522 | -122.432104939916 | (37.7527558068522, -122.432104939916) | |
3165 | 3165 | 214224 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 421 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2002 12:00:00 AM | 8 | Width 2ft | Permit Number 45666 | 6000080.90634 | 2095085.6574799998 | 37.7327102116098 | -122.44209314151001 | (37.7327102116098, -122.44209314151) | |
3169 | 3169 | 213107 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 133 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1988 12:00:00 AM | 4 | Width 3ft | Permit Number 25333 | 5995889.82515 | 2096226.1637400002 | 37.7356020292943 | -122.456665111108 | (37.7356020292943, -122.456665111108) | |
3171 | 3171 | 214225 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 421 Congo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2002 12:00:00 AM | 7 | Width 2ft | Permit Number 45666 | 6000080.6032300005 | 2095071.0529599998 | 37.7326700937324 | -122.44209314147899 | (37.7326700937324, -122.442093141479) | |
3188 | 3188 | 213685 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 428 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/2002 12:00:00 AM | 9 | Width 2ft | Permit Number 45997 | 6000116.1968 | 2095121.7561599999 | 37.7328113412593 | -122.44197372410801 | (37.7328113412593, -122.441973724108) | |
3194 | 3194 | 253362 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1737 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
3195 | 3195 | 253357 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1705 Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
3197 | 3197 | 253348 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1728 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
3199 | 3199 | 253365 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1745 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
3200 | 3200 | 253352 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1756 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
3205 | 3205 | 253356 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1705 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
3207 | 3207 | 253355 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1705 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
3209 | 3209 | 253364 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1741 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
3215 | 3215 | 253360 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1723 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
3217 | 3217 | 253347 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
3218 | 3218 | 139416 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1701 POST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2014 12:00:00 AM | 3 | Width 0ft | 6004006.3401 | 2114230.9234 | 37.7855014808051 | -122.429887091087 | (37.7855014808051, -122.429887091087) | ||
3221 | 3221 | 253361 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1737 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
3224 | 3224 | 253358 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1715 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
3225 | 3225 | 253351 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1756 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
3226 | 3226 | 138479 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | 2 | Width 0ft | Permit Number 47204 | 6004045.5542 | 2114285.9086 | 37.7856546769882 | -122.429755345095 | (37.7856546769882, -122.429755345095) | |
3229 | 3229 | 253353 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1705 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
3233 | 3233 | 253345 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
3234 | 3234 | 253359 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1723 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
3236 | 3236 | 253349 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1756 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
3238 | 3238 | 253363 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1741 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
3242 | 3242 | 253354 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1705 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
3244 | 3244 | 253350 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1756 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
3245 | 3245 | 138485 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | 2 | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | |
3246 | 3246 | 253346 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
3251 | 3251 | 214594 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 352 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2017 12:00:00 AM | 3 | Width 2ft | 5993402.37378 | 2105988.92272 | 37.7622649396058 | -122.465974283195 | (37.7622649396058, -122.465974283195) | ||
3324 | 3324 | 113956 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1441 Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2016 12:00:00 AM | 3 | 3x3 | 6009720.54591 | 2118583.26701 | 37.7977739007953 | -122.410424973449 | (37.7977739007953, -122.410424973449) | ||
3396 | 3396 | 253424 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | ||||
3398 | 3398 | 245004 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1201 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000727.3724 | 2109263.3505 | 37.7716755548589 | -122.44087484303499 | (37.7716755548589, -122.440874843035) | |||
3403 | 3403 | 19880 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 100 STAIRWAY33 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
3412 | 3412 | 117560 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2304 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 4x4 | Permit Number 778613 | 6002499.39832 | 2117814.1104 | 37.7952545391263 | -122.435357062003 | (37.7952545391263, -122.435357062003) | |
3446 | 3446 | 245003 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1201 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6000711.7175 | 2109261.453 | 37.771669453199294 | -122.440928858006 | (37.7716694531993, -122.440928858006) | |||
3472 | 3472 | 47233 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 260 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 9 | 3x3 | Permit Number 45176 | 6009527.90676 | 2093167.0180900001 | 37.7279758826708 | -122.40929702843701 | (37.7279758826708, -122.409297028437) |
3528 | 3528 | 13088 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 722 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6008925.6016 | 2120449.3844 | 37.802853199751794 | -122.413307745784 | (37.8028531997518, -122.413307745784) | |||
3541 | 3541 | 253472 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 134 Lunado Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5991633.0 | 2092401.0 | 37.7248537561355 | -122.471103859098 | (37.7248537561355, -122.471103859098) | ||||
3548 | 3548 | 253473 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 134 Lunado Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5991633.0 | 2092401.0 | 37.7248537561355 | -122.471103859098 | (37.7248537561355, -122.471103859098) | ||||
3592 | 3592 | 236822 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 12 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1988 12:00:00 AM | 10 | Width 3ft | Permit Number 25632 | 5997059.6674 | 2106561.87629 | 37.764048431899205 | -122.453366518365 | (37.7640484318992, -122.453366518365) | |
3600 | 3600 | 246903 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 491 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997265.5984 | 2107392.9739200003 | 37.7663422157406 | -122.452714254467 | (37.7663422157406, -122.452714254467) | |||
3617 | 3617 | 196400 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 380x Clara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6011308.09655 | 2111275.91215 | 37.7777985048225 | -122.404416956276 | (37.7777985048225, -122.404416956276) | |||
3629 | 3629 | 103766 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101X Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006706.11036 | 2115484.69473 | 37.7890965465282 | -122.420635698799 | (37.7890965465282, -122.420635698799) | ||
3644 | 3644 | 196082 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 701 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015721.57305 | 2103923.0720900004 | 37.7578548576382 | -122.388635680008 | (37.7578548576382, -122.388635680008) | |||
3674 | 3674 | 32468 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2017 12:00:00 AM | 3 | Permit Number 36977 | 6000626.3294 | 2105651.6556 | 37.7617529834407 | -122.44096521177099 | (37.7617529834407, -122.440965211771) | |
3675 | 3675 | 237732 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4059 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001898.0 | 2105817.0 | 37.7622793253591 | -122.436578855242 | (37.7622793253591, -122.436578855242) | |||
3712 | 3712 | 196122 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 714 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | Width 3ft | 6011517.6969 | 2105021.50044 | 37.7606370219096 | -122.40325179104299 | (37.7606370219096, -122.403251791043) | ||
3739 | 3739 | 237154 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 861 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1992 12:00:00 AM | 5 | Width 6ft | Permit Number 30833 | 6010197.69553 | 2104230.40256 | 37.7583910361238 | -122.407761316458 | (37.7583910361238, -122.407761316458) | |
3846 | 3846 | 239484 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 725 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2017 12:00:00 AM | 8 | Width 3ft | Permit Number 779370 | 6007401.15098 | 2095467.39415 | 37.7341728312175 | -122.416812207728 | (37.7341728312175, -122.416812207728) | |
3874 | 3874 | 239439 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 131 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4x9 | 6004683.2193 | 2097236.31541 | 37.7388766398495 | -122.426334864463 | (37.7388766398495, -122.426334864463) | |||
3951 | 3951 | 20035 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
4001 | 4001 | 96367 | Permitted Site 1 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 1326 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2011 12:00:00 AM | 10 | 3x3 | Permit Number 767927 | 6006638.67124 | 2118739.19153 | 37.798028781266 | -122.42110020940399 | (37.798028781266, -122.421100209404) | |
4106 | 4106 | 20001 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 100 STAIRWAY46 | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2 | ||||||||
4125 | 4125 | 135979 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006900.63841 | 2115164.21663 | 37.788227554109504 | -122.419939904112 | (37.7882275541095, -122.419939904112) | ||
4128 | 4128 | 135978 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006877.42 | 2115159.3392 | 37.788212853775896 | -122.420019889812 | (37.7882128537759, -122.420019889812) | ||
4141 | 4141 | 135981 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | Width 4ft | 6006885.98637 | 2115183.79121 | 37.7882804756017 | -122.419991987453 | (37.7882804756017, -122.419991987453) | ||
4143 | 4143 | 135982 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Fern St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | Width 4ft | 6006867.714380001 | 2115184.1661400003 | 37.788280475609795 | -122.420055232261 | (37.7882804756098, -122.420055232261) | ||
4145 | 4145 | 113403 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2052 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006463.2485 | 2117908.2188 | 37.7957372487994 | -122.42164817262501 | (37.7957372487994, -122.421648172625) | |||
4158 | 4158 | 253614 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1959x Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006418.0 | 2117595.0 | 37.794874677003605 | -122.421782481899 | (37.7948746770036, -122.421782481899) | ||||
4162 | 4162 | 135980 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006900.58425 | 2115187.77482 | 37.7882922360442 | -122.419941763898 | (37.7882922360442, -122.419941763898) | ||
4166 | 4166 | 143128 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2052 POLK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6006467.2287 | 2117887.8753 | 37.795681615093 | -122.421632954779 | (37.795681615093, -122.421632954779) | |||
4179 | 4179 | 23894 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1581 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 09:37:00 AM | 3 | 3X3 | 6003529.5219 | 2114142.2135 | 37.7852308919409 | -122.431530405312 | (37.7852308919409, -122.431530405312) | ||
4250 | 4250 | 139410 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1500 GEARY BLVD | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/2017 10:27:00 AM | 3 | Width 0ft | 6004177.291 | 2114035.4814 | 37.78497452552379 | -122.429281709952 | (37.7849745255238, -122.429281709952) | ||
4281 | 4281 | 139414 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1500 GEARY BLVD | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 10:29:00 AM | 3 | Width 0ft | 6004053.5092 | 2114020.2427 | 37.7849256755107 | -122.42970886814301 | (37.7849256755107, -122.429708868143) | ||
4309 | 4309 | 1910 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 47 Beideman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001514.9606 | 2113070.1349 | 37.782172849750296 | -122.43842331734601 | (37.7821728497503, -122.438423317346) | |||
4328 | 4328 | 28085 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2255 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6002770.4091 | 2114749.1272 | 37.786854268374796 | -122.43420010239201 | (37.7868542683748, -122.434200102392) | |||
4329 | 4329 | 239457 | Planning Code 138.1 required 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 165 Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780743 | 6001959.66963 | 2096487.1672 | 37.7366653238346 | -122.435698035437 | (37.7366653238346, -122.435698035437) | |
4351 | 4351 | 36746 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 5555 Woodward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39516 | ||||||||
4404 | 4404 | 239458 | Planning Code 138.1 required 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 165 Sussex St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780743 | 6001977.4736 | 2096494.97635 | 37.7366877772239 | -122.435637038029 | (37.7366877772239, -122.435637038029) | |
4409 | 4409 | 114730 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2536 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780830 | 6002593.47602 | 2116148.5251 | 37.790686613557504 | -122.43491236523899 | (37.7906866135575, -122.434912365239) | |
4456 | 4456 | 103803 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98X Hemlock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007001.17193 | 2114849.4881599997 | 37.7873690504995 | -122.419569735969 | (37.7873690504995, -122.419569735969) | ||
4486 | 4486 | 235699 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 301 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004133.22198 | 2109878.38027 | 37.773557659984895 | -122.42913766099 | (37.7735576599849, -122.42913766099) | |||
4504 | 4504 | 8092 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 762 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004291.3267 | 2111546.8391 | 37.778147787093 | -122.428709714706 | (37.778147787093, -122.428709714706) | ||
4533 | 4533 | 214732 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 Faxon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1999 12:00:00 AM | 8 | Width 2ft | Permit Number 41499 | 5994886.41967 | 2092806.74885 | 37.7261554857857 | -122.459886624766 | (37.7261554857857, -122.459886624766) | |
4537 | 4537 | 214730 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1999 12:00:00 AM | 8 | Width 2ft | Permit Number 41499 | 5994894.76005 | 2092775.8058599997 | 37.7260710034609 | -122.459855552309 | (37.7260710034609, -122.459855552309) | |
4542 | 4542 | 214731 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1999 12:00:00 AM | 8 | Width 2ft | Permit Number 41499 | 5994889.57203 | 2092796.33348 | 37.7261270689877 | -122.459874973176 | (37.7261270689877, -122.459874973176) | |
4558 | 4558 | 142520 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 301 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 7 | Width 0ft | 6009467.3323 | 2121175.1455 | 37.8048763586912 | -122.411484377145 | (37.8048763586912, -122.411484377145) | |||
4600 | 4600 | 103784 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 103X Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006741.56415 | 2115141.24736 | 37.788155522905505 | -122.420488644345 | (37.7881555229055, -122.420488644345) | ||
4605 | 4605 | 142542 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 301 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 8 | Width 0ft | 6009433.8643 | 2121170.962 | 37.8048629945672 | -122.411599901453 | (37.8048629945672, -122.411599901453) | |||
4611 | 4611 | 142519 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 301 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | Width 0ft | 6009452.9889 | 2121171.5596 | 37.804865708173104 | -122.411533760714 | (37.8048657081731, -122.411533760714) | |||
4622 | 4622 | 142543 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 301 FRANCISCO ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | Width 0ft | 6009503.7886 | 2121178.1337 | 37.8048866083098 | -122.411358426924 | (37.8048866083098, -122.411358426924) | |||
4696 | 4696 | 236340 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 60 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1993 12:00:00 AM | 11 | Width 3ft | Permit Number 31569 | 6005504.459869999 | 2099359.7250599996 | 37.7447534297269 | -122.423646325024 | (37.7447534297269, -122.423646325024) | |
4704 | 4704 | 253666 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 578 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5993791.71774 | 2111566.05198 | 37.7776007134003 | -122.465032776868 | (37.7776007134003, -122.465032776868) | ||||
4731 | 4731 | 237544 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 25 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 7x8 | 6003442.2831 | 2105633.6495 | 37.76186352451221 | -122.43122467539801 | (37.7618635245122, -122.431224675398) | |||
4753 | 4753 | 98088 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2X Frank Norris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6007178.15894 | 2115574.08384 | 37.7893685797349 | -122.41900880992901 | (37.7893685797349, -122.419008809929) | ||
4841 | 4841 | 88280 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3261 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778851 | 5999200.48769 | 2115630.5359099996 | 37.789071121774796 | -122.446614594592 | (37.7890711217748, -122.446614594592) | |
4845 | 4845 | 38140 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 423 Burrows St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1998 12:00:00 AM | 2 | Permit Number 40297 | 6010109.0 | 2093148.0 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | |
4846 | 4846 | 76677 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 423 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 3 | 6010109.0 | 2093148.0 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | ||
4918 | 4918 | 43245 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 150 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 9 | Permit Number 43034 | 6010460.0 | 2093774.0 | 37.729694705520004 | -122.40611748494 | (37.72969470552, -122.40611748494) | |
5189 | 5189 | 50319 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 207 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Permit Number 780459 | 5994858.57459 | 2113511.06459 | 37.7830026560888 | -122.461483229537 | (37.7830026560888, -122.461483229537) | ||
5249 | 5249 | 243309 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 780 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 6007491.9091300005 | 2105126.68883 | 37.760700186689796 | -122.41718265916799 | (37.7607001866898, -122.417182659168) | |||
5254 | 5254 | 253839 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 94 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6006239.0 | 2097690.0 | 37.740210176126794 | -122.42098789234 | (37.7402101761268, -122.42098789234) | ||||
5269 | 5269 | 8090 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 762 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004349.2473 | 2111557.1689 | 37.7781794280627 | -122.428510082803 | (37.7781794280627, -122.428510082803) | ||
5302 | 5302 | 35167 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 240 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1998 12:00:00 AM | Permit Number 38700 | ||||||||
5325 | 5325 | 40088 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1999 12:00:00 AM | Permit Number 41311 | |||||||||
5333 | 5333 | 26937 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1529 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6002019.9705 | 2111862.8998 | 37.7788867994939 | -122.436589775324 | (37.7788867994939, -122.436589775324) |
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");