Street_Tree_List

Data source: data.sfgov.org

14,663 rows where search matches "cherry" sorted by TreeID descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qCareAssistant

Link rowid TreeID ▲ qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
2651 2651 253156 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 654 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 40826 6010070.0 2105228.0 37.7611230643779 -122.40827330718099 (37.7611230643779, -122.408273307181)
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)
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)
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)
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)
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)
186216 186216 250997 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 415 44th Ave 1 : 4 Tree 1 Private 1     5 Width 3ft   5982186.75835 2112941.64621 37.7807016980586 -122.505279538125 (37.7807016980586, -122.505279538125)
30707 30707 250995 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 453 44th Ave 2 : 4 Tree 1 Private 1     5 Width 3ft   5982194.00965 2112744.27477 37.780160200984604 -122.505239820464 (37.7801602009846, -122.505239820464)
57812 57812 250934 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 259 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5987104.958930001 2114216.89652 37.7844913413477 -122.48835908522699 (37.7844913413477, -122.488359085227)
69256 69256 250924 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 279 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5987109.1755800005 2114089.0974 37.7841406875769 -122.488335102104 (37.7841406875769, -122.488335102104)
126747 126747 250902 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 266 29th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 4ft   5986843.33005 2114156.49339 37.7843102232907 -122.489259776936 (37.7843102232907, -122.489259776936)
70024 70024 250882 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 154 29th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 4ft   5986822.39512 2114740.35297 37.7859121118945 -122.48937514824699 (37.7859121118945, -122.489375148247)
172451 172451 250881 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 154 29th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5986823.250630001 2114733.9114599996 37.78589447530229 -122.489371714655 (37.7858944753023, -122.489371714655)
56077 56077 250876 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 30th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5986468.29527 2114661.08637 37.7856737915584 -122.490594385245 (37.7856737915584, -122.490594385245)
166433 166433 250875 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 30th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5986467.14332 2114671.0752 37.7857011507179 -122.490599105783 (37.7857011507179, -122.490599105783)
71891 71891 250874 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5986467.3841 2114682.3933599996 37.7857322411853 -122.490599105779 (37.7857322411853, -122.490599105779)
166651 166651 250870 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 133 30th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5986470.3680300005 2114630.24299 37.7855892256034 -122.490584944137 (37.7855892256034, -122.490584944137)
180995 180995 250869 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 133 30th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5986468.30668 2114640.25117 37.785616584774104 -122.490592812307 (37.7856165847741, -122.490592812307)
132130 132130 250868 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 133 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5986468.4993 2114649.30576 37.7856414573183 -122.490592812321 (37.7856414573183, -122.490592812321)
75705 75705 250820 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 60 Sea View Ter 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5986182.97775 2114165.47247 37.7842963089586 -122.49154499381599 (37.7842963089586, -122.491544993816)
153946 153946 250819 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 60 Sea View Ter 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5986191.04243 2114164.9353 37.7842953053345 -122.49151705368999 (37.7842953053345, -122.49151705369)
41962 41962 250796 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 290 31st Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5986226.25026 2113990.91468 37.7838195522695 -122.49138243596201 (37.7838195522695, -122.491382435962)
168487 168487 250795 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 290 31st Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5986226.21568 2113977.7713599997 37.7837834624768 -122.491381587892 (37.7837834624768, -122.491381587892)
40407 40407 250787 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 277 32nd Ave 1 : 4 Tree 1 Private 1     2 Width 3ft   5985873.31121 2114054.8468299997 37.7839744613866 -122.49260816604601 (37.7839744613866, -122.492608166046)
134897 134897 250785 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 270 32nd Ave 1 : 4 Tree 1 Private 1     5 Width 3ft   5985911.734180001 2114095.33531 37.784087877591794 -122.492478221206 (37.7840878775918, -122.492478221206)
147077 147077 250761 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 228 32nd Ave 2 : 4 Tree 1 Private 1     6 Width 3ft   5985903.37202 2114379.41265 37.7848673829594 -122.49252807871001 (37.7848673829594, -122.49252807871)
73215 73215 250760 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 228 32nd Ave 1 : 4 Tree 1 Private 1     3 Width 3ft   5985903.61307 2114361.31306 37.7848177008131 -122.492525911365 (37.7848177008131, -122.492525911365)
170118 170118 250758 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 214 32nd Ave 1 : 4 Tree 1 Private 1     6 Width 3ft   5985901.94322 2114466.62788 37.785106767213705 -122.49253944703699 (37.7851067672137, -122.492539447037)
66286 66286 250757 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 206 32nd Ave 1 : 4 Tree 1 Private 1     8 Width 3ft   5985901.09635 2114492.32613 37.785177277657496 -122.492544270121 (37.7851772776575, -122.492544270121)
178867 178867 250677 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 735 El Camino Del Mar 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5986302.66224 2114812.53014 37.78607993617911 -122.49117856955 (37.7860799361791, -122.49117856955)
40381 40381 250676 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 735 El Camino Del Mar 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5986293.297259999 2114811.88275 37.786077611448 -122.49121092176 (37.786077611448, -122.49121092176)
135875 135875 250645 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2610 Lake St 6 : 4 Tree 1 Private 1     1 Width 3ft   5987300.52243 2114656.77456 37.78571052885479 -122.48771483877199 (37.7857105288548, -122.487714838772)
39473 39473 250644 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2610 Lake St 5 : 4 Tree 1 Private 1     4 Width 3ft   5987312.1046400005 2114657.5756599996 37.785713403992 -122.487674827026 (37.785713403992, -122.487674827026)
132655 132655 250524 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 95 26th Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   5987685.45058 2115374.99193 37.7877049922276 -122.486435864334 (37.7877049922276, -122.486435864334)
26752 26752 250523 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 95 26th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   5987685.92853 2115397.50584 37.78776683682629 -122.48643586433998 (37.7877668368263, -122.48643586434)
39369 39369 250521 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 95 26th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   5987685.5238 2115445.0256 37.787897288863796 -122.48644075485201 (37.7878972888638, -122.486440754852)
27074 27074 250328 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 161 27th Ave 3 : 4 Tree 1 Private 1     4 Width 3ft   5987394.32135 2114885.37066 37.7863436587784 -122.487407123146 (37.7863436587784, -122.487407123146)
53803 53803 250309 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 12 Redfield Aly 1 Side Yard : Yard 17 Tree 1 Private 1     5 Width 0ft   6008474.46022 2119519.71704 37.800275226579 -122.414803097987 (37.800275226579, -122.414803097987)
183681 183681 250308 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 10 Redfield Aly 1 Back Yard : Yard 13 Tree 1 Private 1     4 Width 0ft   6008483.77451 2119506.40025 37.8002391853351 -122.41476992380801 (37.8002391853351, -122.414769923808)
35008 35008 250159 Undocumented 2 Prunus x yedoensis :: Yoshino Cherry 237 2500 Lyon St 6 Side Yard : Yard 17 Tree 1 Private 1     8     5999252.38937 2117479.90418 37.79415196309329 -122.44656813112302 (37.7941519630933, -122.446568131123)
178599 178599 250158 Undocumented 2 Prunus x yedoensis :: Yoshino Cherry 237 2500 Lyon St 5 Side Yard : Yard 17 Tree 1 Private 1     7     5999254.28786 2117464.37854 37.794109442247404 -122.446560444632 (37.7941094422474, -122.446560444632)
162632 162632 250157 Undocumented 2 Prunus x yedoensis :: Yoshino Cherry 237 2500 Lyon St 4 Side Yard : Yard 17 Tree 1 Private 1     7     5999256.81946 2117443.6781200003 37.7940527489909 -122.446550195053 (37.7940527489909, -122.446550195053)
132167 132167 250156 Undocumented 2 Prunus x yedoensis :: Yoshino Cherry 237 2500 Lyon St 3 Side Yard : Yard 17 Tree 1 Private 1     5     5999256.55789 2117425.58205 37.7940030470443 -122.44654979756201 (37.7940030470443, -122.446549797562)
174728 174728 250155 Undocumented 2 Prunus x yedoensis :: Yoshino Cherry 237 2500 Lyon St 2 Side Yard : Yard 17 Tree 1 Private 1     6     5999259.65981 2117410.03204 37.7939605280209 -122.44653794537099 (37.7939605280209, -122.446537945371)
64471 64471 250154 Undocumented 2 Prunus x yedoensis :: Yoshino Cherry 237 2500 Lyon St 1 Side Yard : Yard 17 Tree 1 Private 1     9     5999263.267440001 2117392.55411 37.793912744324395 -122.446524204627 (37.7939127443244, -122.446524204627)
45545 45545 250151 Undocumented 2 Prunus x yedoensis :: Yoshino Cherry 237 2501 Lyon St 6 Front Yard : Yard 7 Tree 1 Private 1     6     5999220.87756 2117406.8173700003 37.7939494861264 -122.446671903881 (37.7939494861264, -122.446671903881)
146477 146477 250150 Undocumented 2 Prunus x yedoensis :: Yoshino Cherry 237 2501 Lyon St 5 Front Yard : Yard 7 Tree 1 Private 1     8     5999218.59352 2117421.61343 37.7939899817095 -122.446680871938 (37.7939899817095, -122.446680871938)
135104 135104 250149 Undocumented 2 Prunus x yedoensis :: Yoshino Cherry 237 2501 Lyon St 4 Front Yard : Yard 7 Tree 1 Private 1     6     5999215.63832 2117439.7417 37.794039588317 -122.446692402146 (37.794039588317, -122.446692402146)
70262 70262 250148 Undocumented 2 Prunus x yedoensis :: Yoshino Cherry 237 2501 Lyon St 3 Front Yard : Yard 7 Tree 1 Private 1     6     5999211.58041 2117458.2617099998 37.7940902075462 -122.44670777604799 (37.7940902075462, -122.446707776048)
133128 133128 250147 Undocumented 2 Prunus x yedoensis :: Yoshino Cherry 237 2501 Lyon St 2 Front Yard : Yard 7 Tree 1 Private 1     7     5999210.3991 2117472.66602 37.794129690476105 -122.446712900392 (37.7941296904761, -122.446712900392)
177400 177400 250146 Undocumented 2 Prunus x yedoensis :: Yoshino Cherry 237 2501 Lyon St 1 Front Yard : Yard 7 Tree 1 Private 1     4     5999207.44391 2117490.79429 37.79417929707979 -122.446724430609 (37.7941792970798, -122.446724430609)
27269 27269 250005 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 232 Filbert St 3 Side Yard : Yard 17 Tree 1 Private 1     8 Width 0ft   6011493.8796 2120090.77159 37.802012393927 -122.404394879735 (37.802012393927, -122.404394879735)
158284 158284 250003 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 232 Filbert St 1 Side Yard : Yard 17 Tree 1 Private 1     11 Width 0ft   6011516.941380001 2120107.55399 37.802059763016096 -122.404316256511 (37.8020597630161, -122.404316256511)
159690 159690 249982 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 224 Filbert St 3 Front Yard : Yard 7 Tree 1 Private 1     12 Width 0ft   6011639.74764 2120113.25639 37.8020822820333 -122.403891687471 (37.8020822820333, -122.403891687471)
173495 173495 249974 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 28 Napier Ln 1 Front Yard : Yard 7 Tree 1 Private 1     18 Width 0ft   6011652.50252 2120258.9240099997 37.802482962378704 -122.403857805517 (37.8024829623787, -122.403857805517)
159363 159363 249970 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 213 Filbert St 1 Back Yard : Yard 13 Tree 1 Private 1     31 Width 0ft   6011737.037830001 2120086.51138 37.802014281606205 -122.403553132272 (37.8020142816062, -122.403553132272)
28833 28833 249969 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 213 Filbert St 2 Back Yard : Yard 13 Tree 1 Private 1     28 Width 0ft   6011730.79134 2120085.86253 37.802012151107704 -122.403574702535 (37.8020121511077, -122.403574702535)
182162 182162 249963 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 271 Filbert St 1 Front Yard : Yard 7 Tree 1 Private 1     10 Width 0ft   6011592.60874 2120072.38059 37.8019674134157 -122.404051933175 (37.8019674134157, -122.404051933175)
76837 76837 249945 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 325 Filbert St 1 Front Yard : Yard 7 Tree 1 Private 1     24 Width 0ft   6011292.48387 2120026.50548 37.8018246784261 -122.40508728037399 (37.8018246784261, -122.405087280374)
171242 171242 249941 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 331 Filbert St 3 Front Yard : Yard 7 Tree 1 Private 1     13 Width 0ft   6011275.707669999 2120025.2952 37.8018204174494 -122.40514524887199 (37.8018204174494, -122.405145248872)
132944 132944 249940 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 331 Filbert St 2 Front Yard : Yard 7 Tree 1 Private 1     4 Width 0ft   6011278.90186 2120029.10977 37.80183106989429 -122.40513446418801 (37.8018310698943, -122.405134464188)
184115 184115 249937 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 339 Filbert St 2 Front Yard : Yard 7 Tree 1 Private 1     7 Width 0ft   6011248.56733 2120031.66705 37.8018363956996 -122.405239616532 (37.8018363956996, -122.405239616532)
116481 116481 249933 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 345 Filbert St 2 Front Yard : Yard 7 Tree 1 Private 1     7 Width 0ft   6011225.47356 2120026.31802 37.801820417444 -122.405319155254 (37.801820417444, -122.405319155254)
58002 58002 249931 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 345 Filbert St 5 : 4 Tree 1 Private 1     5 Width 0ft   6011214.74621 2120016.06231 37.801791658008106 -122.405355554416 (37.8017916580081, -122.405355554416)
51583 51583 249891 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 230 Greenwich St 27 Back Yard : Yard 13 Tree 1 Private 1     15 Width 0ft   6011455.072819999 2120426.06234 37.8029308517393 -122.404552786308 (37.8029308517393, -122.404552786308)
37934 37934 249882 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 230 Greenwich St 18 Back Yard : Yard 13 Tree 1 Private 1     27 Width 0ft   6011509.072430001 2120419.3733099997 37.8029155030083 -122.40436544761499 (37.8029155030083, -122.404365447615)
171246 171246 249875 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 230 Greenwich St 11 Back Yard : Yard 13 Tree 1 Private 1     19 Width 0ft   6011656.00691 2120465.5569700003 37.803050521838706 -122.40386022737499 (37.8030505218387, -122.403860227375)
131807 131807 249873 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 230 Greenwich St 9 Back Yard : Yard 13 Tree 1 Private 1     26 Width 0ft   6011670.78297 2120474.23594 37.8030751776447 -122.403809705266 (37.8030751776447, -122.403809705266)
64904 64904 249855 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 241 Greenwich St 1 Front Yard : Yard 7 Tree 1 Private 1     3 Width 0ft   6011547.42399 2120404.90985 37.802877932936504 -122.40423171211901 (37.8028779329365, -122.404231712119)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");
Powered by Datasette · Query took 2880.754ms · Data source: data.sfgov.org