Data source: data.sfgov.org
This data as json, CSV (advanced)
qCaretaker ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
71 | 71 | 251206 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 270 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005145.0 | 2094297.0 | 37.7308320294825 | -122.424529217878 | (37.7308320294825, -122.424529217878) | ||||
1663 | 1663 | 251645 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 132 Shipley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011949.0 | 2112390.0 | 37.7808933270361 | -122.40227818697599 | (37.7808933270361, -122.402278186976) | ||||
1670 | 1670 | 251646 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 132 Shipley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011949.0 | 2112390.0 | 37.7808933270361 | -122.40227818697599 | (37.7808933270361, -122.402278186976) | ||||
1677 | 1677 | 251644 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 132 Shipley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011949.0 | 2112390.0 | 37.7808933270361 | -122.40227818697599 | (37.7808933270361, -122.402278186976) | ||||
1749 | 1749 | 251678 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1841 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989656.0 | 2102823.0 | 37.7533553254519 | -122.478699889248 | (37.7533553254519, -122.478699889248) | ||||
2489 | 2489 | 119760 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
2492 | 2492 | 119762 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
2501 | 2501 | 119761 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
2508 | 2508 | 119759 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
3013 | 3013 | 39333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
3068 | 3068 | 253294 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 840x Sacramento St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6010611.0 | 2116923.0 | 37.793265087793294 | -122.407226643637 | (37.7932650877933, -122.407226643637) | |||||
3072 | 3072 | 253293 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 840x Sacramento St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6010611.0 | 2116923.0 | 37.793265087793294 | -122.407226643637 | (37.7932650877933, -122.407226643637) | |||||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||||
3523 | 3523 | 253474 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 134 Lunado Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x2 | 5991633.0 | 2092401.0 | 37.7248537561355 | -122.471103859098 | (37.7248537561355, -122.471103859098) | ||||
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) | ||||
3610 | 3610 | 115725 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 250X Octavia St | 2 | Side Yard : Yard 17 | Tree 1 | Dept of Real Estate 5 | ||||||||||
3822 | 3822 | 253559 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4 Cortes Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5993184.39566 | 2099612.1282900004 | 37.7447433294416 | -122.46626473273199 | (37.7447433294416, -122.466264732732) | ||||
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) | ||||
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 | ||||||||
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) | ||||
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) | ||||
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 | |||||||||
5373 | 5373 | 31852 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1117 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35299 | ||||||||
5518 | 5518 | 39334 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
5746 | 5746 | 31847 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
6090 | 6090 | 105252 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1875 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770851 | 6004061.8803 | 2118683.0933 | 37.7977291534815 | -122.43001264475201 | (37.7977291534815, -122.430012644752) | ||||
6740 | 6740 | 39332 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
7293 | 7293 | 31848 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
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) | |||
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) | |
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) | ||||
10144 | 10144 | 173880 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1922 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998581.0 | 2110425.0 | 37.7747426714218 | -122.448382913575 | (37.7747426714218, -122.448382913575) | ||||
10200 | 10200 | 122374 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 95x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | |||
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 | ||||||||
11785 | 11785 | 31851 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1117 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35299 | ||||||||
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 | |||||||||
11986 | 11986 | 31849 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
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 | |||||||||
13302 | 13302 | 187656 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1548 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003789.0 | 2099328.0 | 37.744569337434 | -122.42957579341999 | (37.744569337434, -122.42957579342) | ||||
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) | |||
14197 | 14197 | 39331 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
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 | |||||||||
15743 | 15743 | 115724 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 250x Octavia St | 1 | Side Yard : Yard 17 | Tree 1 | Dept of Real Estate 5 | ||||||||||
15875 | 15875 | 31850 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
15956 | 15956 | 31845 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
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) | ||
17860 | 17860 | 101958 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200X Ripley St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/12/2013 12:00:00 AM | 3x3 | Permit Number 770180 | 6009339.0 | 2099105.0 | 37.744269714821 | -122.410369184032 | (37.744269714821, -122.410369184032) | ||
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) | ||
18032 | 18032 | 99798 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 723-725 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001735.0 | 2102034.0 | 37.7518828570558 | -122.43687178091899 | (37.7518828570558, -122.436871780919) | ||||
18075 | 18075 | 32820 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4231 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37179 | 6001652.66778496 | 2102313.08223681 | 37.7526444703409 | -122.43717647687599 | (37.7526444703409, -122.437176476876) | ||
18082 | 18082 | 62490 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 52 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | Permit Number 22661 | 6000842.2540014 | 2092843.5185791 | 37.7265971735996 | -122.439300325407 | (37.7265971735996, -122.439300325407) | ||
18086 | 18086 | 32173 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
18146 | 18146 | 47497 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 2550 Lyon St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.391583701 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | ||
18192 | 18192 | 64739 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 139 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51671 | 6002793.57505281 | 2109015.34015791 | 37.771112038694504 | -122.43371000005101 | (37.7711120386945, -122.433710000051) | ||
18366 | 18366 | 92323 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2595 27th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 3x3 | Permit Number 52755 | 5987970.2 | 2097662.1 | 37.739086838436606 | -122.484151218827 | (37.7390868384366, -122.484151218827) | |
18402 | 18402 | 48402 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 Wisconsin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/19/2010 12:00:00 AM | Permit Number 53935 | 6012689.64928807 | 2104214.1545054 | 37.7584856101735 | -122.399141839868 | (37.7584856101735, -122.399141839868) | |||
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) | ||
18485 | 18485 | 36424 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 300 Montecito Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39337 | 5996091.95170793 | 2094186.31684288 | 37.7300127063789 | -122.455818876187 | (37.7300127063789, -122.455818876187) | |||
18614 | 18614 | 63155 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1466 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1986 12:00:00 AM | Permit Number 23691 | 5992764.22387578 | 2105486.82086268 | 37.7608494648287 | -122.468144857754 | (37.7608494648287, -122.468144857754) | ||
18633 | 18633 | 41286 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 494 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52403 | 6005499.65147882 | 2107857.73967205 | 37.7680867232876 | -122.424267232407 | (37.7680867232876, -122.424267232407) | ||
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) | ||
18841 | 18841 | 64930 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2306 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1989 12:00:00 AM | Permit Number 25958 | 5991495.59202308 | 2099725.9184431 | 37.7449581828883 | -122.47211252761002 | (37.7449581828883, -122.47211252761) | ||
18879 | 18879 | 94134 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Nebraska St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53498 | 6009291.0 | 2097948.0 | 37.7410901551317 | -122.41045347697501 | (37.7410901551317, -122.410453476975) | |||
18883 | 18883 | 65715 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 735 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | Permit Number 28647 | 6009189.05467178 | 2115445.35577198 | 37.789128153830106 | -122.41204221421499 | (37.7891281538301, -122.412042214215) | ||
19061 | 19061 | 50930 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2287 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47426 | 5991460.4982554 | 2099833.27531374 | 37.745250926286396 | -122.47224169859699 | (37.7452509262864, -122.472241698597) | ||
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) | |||
19124 | 19124 | 59121 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 572 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2013 12:00:00 AM | Permit Number 770918 | 5992864.66737091 | 2111571.53492594 | 37.7775622694604 | -122.46824012776001 | (37.7775622694604, -122.46824012776) | |||
19155 | 19155 | 52324 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4119NOE ST. 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/2005 12:00:00 AM | Permit Number 48477 | 6002926.75349176 | 2104136.57118168 | 37.7577236789461 | -122.432900729778 | (37.7577236789461, -122.432900729778) | ||
19239 | 19239 | 40472 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 43 Lakeview Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | |||
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) | ||
19427 | 19427 | 51055 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 640 Rivera St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2004 12:00:00 AM | Permit Number 47524 | 5991199.18695168 | 2100466.01651136 | 37.746973143605 | -122.47319139748001 | (37.746973143605, -122.47319139748) | |||
19474 | 19474 | 51214 | Permitted Site 1 | Prunus spp :: Cherry 84 | 111 Mission St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2004 12:00:00 AM | Permit Number 47578 | 6014394.74626942 | 2116530.73461445 | 37.7923990500381 | -122.39410705418699 | (37.7923990500381, -122.394107054187) | |||
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) | |||
19557 | 19557 | 119842 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 350 Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
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) |
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");