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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44349 | 44349 | 124423 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 207 Cherry St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 5996107.9721800005 | 2115471.34233 | 37.78845688642 | -122.45730271274401 | (37.78845688642, -122.457302712744) | |||
52941 | 52941 | 197880 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 7ft | 6015641.85781 | 2101940.61128 | 37.752407021878 | -122.388772976792 | (37.752407021878, -122.388772976792) | |||
58653 | 58653 | 197884 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 7ft | 6015678.84769 | 2101942.9496400002 | 37.7524154925876 | -122.388645221797 | (37.7524154925876, -122.388645221797) | |||
60619 | 60619 | 197886 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6015689.86816 | 2101943.47037 | 37.7524175331559 | -122.388607147206 | (37.7524175331559, -122.388607147206) | |||
74939 | 74939 | 135892 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 323 Marina Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6001823.0897 | 2121828.5954400003 | 37.8062388262166 | -122.437984887306 | (37.8062388262166, -122.437984887306) | |||
132071 | 132071 | 238045 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 38 Dolores St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 7ft | 6004739.1194 | 2107851.95841 | 37.7680278762037 | -122.426897421898 | (37.7680278762037, -122.426897421898) | |||
154029 | 154029 | 124424 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 207 Cherry St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5996110.10232 | 2115455.34422 | 37.788413082259105 | -122.45729418503599 | (37.7884130822591, -122.457294185036) | |||
160988 | 160988 | 202147 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1979 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 6012955.252309999 | 2093506.82348 | 37.72910034549879 | -122.397472339298 | (37.7291003454988, -122.397472339298) | |||
167126 | 167126 | 196128 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2098 20th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6011883.81228 | 2104698.03976 | 37.7597693110244 | -122.401962817046 | (37.7597693110244, -122.401962817046) | |||
173545 | 173545 | 197882 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6015650.38756 | 2101941.3683 | 37.752409573246396 | -122.388743532098 | (37.7524095732464, -122.388743532098) | |||
174594 | 174594 | 197878 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6015630.33926 | 2101939.54612 | 37.7524034587597 | -122.388812735827 | (37.7524034587597, -122.388812735827) | |||
176610 | 176610 | 135908 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 405 Vallejo St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6011535.18315 | 2119025.39151 | 37.7990894272815 | -122.40417692455 | (37.7990894272815, -122.40417692455) | |||
179436 | 179436 | 135891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2398 North Point St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 7ft | 5999308.28669 | 2120504.72693 | 37.802460509893606 | -122.44659245147301 | (37.8024605098936, -122.446592451473) | |||
181397 | 181397 | 197883 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 7ft | 6015671.68668 | 2101942.82757 | 37.752414760540105 | -122.388669977447 | (37.7524147605401, -122.388669977447) | |||
186864 | 186864 | 197885 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 7ft | 6015684.0853699995 | 2101943.48621 | 37.7524172561691 | -122.388627146329 | (37.7524172561691, -122.388627146329) | |||
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) | |
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) | |||
23638 | 23638 | 179012 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 575 Lisbon St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6001860.73543 | 2090148.2767900003 | 37.719254552441704 | -122.435586742551 | (37.7192545524417, -122.435586742551) | |||
24085 | 24085 | 212387 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 95 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5991919.26492 | 2095494.2164099999 | 37.7333635115101 | -122.47033944313499 | (37.7333635115101, -122.470339443135) | |||
24513 | 24513 | 213290 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 155 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5994132.71522 | 2090951.16156 | 37.721017116620004 | -122.46235759304399 | (37.72101711662, -122.462357593044) | |||
26387 | 26387 | 212392 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 65 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5991914.22227 | 2095632.90127 | 37.733744013755796 | -122.470366973162 | (37.7337440137558, -122.470366973162) | |||
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) | |||
27606 | 27606 | 201518 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 501 Griffith St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6019207.673780001 | 2094338.78719 | 37.7317309074526 | -122.37591462936199 | (37.7317309074526, -122.375914629362) | |||
27665 | 27665 | 215220 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 2020 09th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 6ft | 5993507.89159 | 2101745.37647 | 37.7506193459188 | -122.465301081296 | (37.7506193459188, -122.465301081296) | |||
29834 | 29834 | 215244 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 290 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5991718.94325 | 2090452.86708 | 37.7195096334551 | -122.470664935645 | (37.7195096334551, -122.470664935645) | |||
30249 | 30249 | 212644 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 385 Vernon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5992447.09906 | 2090440.19057 | 37.7195169071729 | -122.46814706775 | (37.7195169071729, -122.46814706775) | |||
30287 | 30287 | 214298 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 268 Pacheco St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994394.90516 | 2100680.9533 | 37.7477478232146 | -122.4621565532 | (37.7477478232146, -122.4621565532) | |||
31098 | 31098 | 212655 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 494 Victoria St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5993275.23376 | 2090421.34929 | 37.7195129663325 | -122.46528316408998 | (37.7195129663325, -122.46528316409) | |||
32271 | 32271 | 237025 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Octavia St | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 6ft | 6005760.04076 | 2109480.81274 | 37.7725579925006 | -122.423481975714 | (37.7725579925006, -122.423481975714) | |||
34179 | 34179 | 197887 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1493 Kansas St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 6ft | 6011776.638040001 | 2101418.39447 | 37.7507581436897 | -122.40210291074699 | (37.7507581436897, -122.402102910747) | |||
35376 | 35376 | 179161 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 233 Naylor St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6002647.79999 | 2086739.6543400001 | 37.7099398962889 | -122.432622809119 | (37.7099398962889, -122.432622809119) | |||
36554 | 36554 | 120353 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2240 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 5988483.640819999 | 2114700.0523900003 | 37.7858982939261 | -122.48362481032801 | (37.7858982939261, -122.483624810328) | |||
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) | |||
40197 | 40197 | 236681 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 756 Grand View Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 6ft | 6000049.04538 | 2100790.98488 | 37.7483738718507 | -122.442612790472 | (37.7483738718507, -122.442612790472) | |||
40688 | 40688 | 136600 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 2298 Beach St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5999337.17722 | 2120854.21997 | 37.8034217736525 | -122.44651763508999 | (37.8034217736525, -122.44651763509) | |||
41037 | 41037 | 179678 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 242 San Juan Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6000584.20911 | 2092761.60072 | 37.726357558039204 | -122.440186503209 | (37.7263575580392, -122.440186503209) | |||
41930 | 41930 | 212393 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 55 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5991911.35138 | 2095658.6383099998 | 37.7338145152114 | -122.470378772281 | (37.7338145152114, -122.470378772281) | |||
42127 | 42127 | 234920 | Undocumented 2 | Prunus spp :: Cherry 84 | 501 York St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6009827.75137 | 2105874.2614 | 37.7628839834388 | -122.409156748587 | (37.7628839834388, -122.409156748587) | |||
42217 | 42217 | 237026 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Octavia St | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 6ft | 6005759.75569 | 2109493.68206 | 37.7725933124646 | -122.423483876889 | (37.7725933124646, -122.423483876889) | |||
42756 | 42756 | 237448 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4609 25th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 6ft | 6000549.980269999 | 2101082.72419 | 37.7492034604754 | -122.440901499304 | (37.7492034604754, -122.440901499304) | |||
42900 | 42900 | 212547 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 149 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993748.79509 | 2096657.2738700002 | 37.736662588108395 | -122.464098699394 | (37.7366625881084, -122.464098699394) | |||
43286 | 43286 | 212542 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 155 Terrace Walk | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993830.43125 | 2096581.14739 | 37.736458268419206 | -122.46381092625799 | (37.7364582684192, -122.463810926258) | |||
43287 | 43287 | 196091 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 972 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 6ft | 6015230.48964 | 2104060.4129 | 37.7582047379774 | -122.390343661653 | (37.7582047379774, -122.390343661653) | |||
43446 | 43446 | 179679 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 242 San Juan Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6000569.78695 | 2092772.13999 | 37.726385675350706 | -122.44023711527001 | (37.7263856753507, -122.44023711527) | |||
43648 | 43648 | 239467 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1285 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 6ft | 5997501.9107 | 2105032.0283 | 37.7598731953164 | -122.451726570432 | (37.7598731953164, -122.451726570432) | |||
43716 | 43716 | 136598 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 2298 Beach St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 6ft | 5999341.14558 | 2120854.69423 | 37.803423302506 | -122.446503936615 | (37.803423302506, -122.446503936615) | |||
44659 | 44659 | 237153 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 758 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 6ft | 6010110.83147 | 2104756.28299 | 37.759830122280704 | -122.408098819429 | (37.7598301222807, -122.408098819429) | |||
44715 | 44715 | 236866 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1275 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 5997490.26756 | 2105115.32098 | 37.7601012292087 | -122.451772846854 | (37.7601012292087, -122.451772846854) | |||
46558 | 46558 | 237027 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Octavia St | 8 | : 4 | Tree 1 | Private 1 | 5 | Width 6ft | 6005758.332230001 | 2109504.65873 | 37.772623371413495 | -122.423489581302 | (37.7726233714135, -122.423489581302) | |||
46577 | 46577 | 212879 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1856 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 5990966.76984 | 2102771.704 | 37.7532904996754 | -122.474163276836 | (37.7532904996754, -122.474163276836) | |||
46831 | 46831 | 212390 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 75 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5991915.799819999 | 2095563.7675400001 | 37.733554281107395 | -122.47035648617799 | (37.7335542811074, -122.470356486178) | |||
47543 | 47543 | 201520 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 501 Griffith St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6019241.773440001 | 2094383.32833 | 37.7318550858427 | -122.37579982552 | (37.7318550858427, -122.37579982552) | |||
48616 | 48616 | 212398 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 35 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5991908.4162 | 2095789.3482700002 | 37.7341732422018 | -122.470398435959 | (37.7341732422018, -122.470398435959) | |||
49076 | 49076 | 213002 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1684 09th Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 6ft | 5993433.63561 | 2104037.38887 | 37.756908339163104 | -122.46572436788401 | (37.7569083391631, -122.465724367884) | |||
49350 | 49350 | 237136 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1346 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 6ft | 6010061.84572 | 2101335.33586 | 37.7504342222613 | -122.40802698336901 | (37.7504342222613, -122.408026983369) | |||
50013 | 50013 | 212549 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 145 Terrace Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993701.90804 | 2096690.99952 | 37.7367524879351 | -122.464263254655 | (37.7367524879351, -122.464263254655) | |||
50661 | 50661 | 212551 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 141 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993669.9732800005 | 2096714.1081700001 | 37.7368140977904 | -122.464375343461 | (37.7368140977904, -122.464375343461) | |||
50935 | 50935 | 212388 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 95 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5991917.7194 | 2095510.8633700002 | 37.733409130525295 | -122.470345998274 | (37.7334091305253, -122.470345998274) | |||
51164 | 51164 | 196547 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 970 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 6ft | 6012751.3239400005 | 2103003.6751599996 | 37.7551653352247 | -122.398843585967 | (37.7551653352247, -122.398843585967) | |||
51378 | 51378 | 212397 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 35 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5991907.97112 | 2095768.2121400002 | 37.7341151819682 | -122.47039843596201 | (37.7341151819682, -122.470398435962) | |||
51598 | 51598 | 117842 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 620x 39th Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 5983810.65643 | 2111554.107 | 37.7769873385843 | -122.499559205901 | (37.7769873385843, -122.499559205901) | |||
53150 | 53150 | 179680 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 242 San Juan Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6000544.18408 | 2092789.8537599999 | 37.726432855581 | -122.440326892784 | (37.726432855581, -122.440326892784) | |||
53262 | 53262 | 238586 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 991 San Bruno Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 6011096.081069999 | 2103736.7001400003 | 37.7570856908704 | -122.40461953036501 | (37.7570856908704, -122.404619530365) | |||
53380 | 53380 | 214420 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 466 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 5993273.262130001 | 2090266.31835 | 37.7190871751261 | -122.465278724129 | (37.7190871751261, -122.465278724129) | |||
55195 | 55195 | 212395 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 45 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5991910.09704 | 2095725.12141 | 37.7339969885736 | -122.47038794896099 | (37.7339969885736, -122.470387948961) | |||
57154 | 57154 | 212375 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 350x Kensington Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 6ft | 5994268.67075 | 2099029.19032 | 37.743205228833205 | -122.46247327105101 | (37.7432052288332, -122.462473271051) | |||
57338 | 57338 | 237123 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1049 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 6ft | 6008643.89723 | 2102440.9012700003 | 37.7533903648753 | -122.41300853052799 | (37.7533903648753, -122.413008530528) | |||
58235 | 58235 | 212544 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 153 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5993803.69689 | 2096613.4466900001 | 37.7365454136427 | -122.46390570131099 | (37.7365454136427, -122.463905701311) | |||
58523 | 58523 | 215221 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1992 09th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5993500.77479 | 2101935.78141 | 37.7511417387208 | -122.465339521014 | (37.7511417387208, -122.465339521014) | |||
58846 | 58846 | 212555 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 135 Terrace Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5993610.86329 | 2096757.02043 | 37.736928516744 | -122.464582826036 | (37.736928516744, -122.464582826036) | |||
58909 | 58909 | 212556 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 129 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993583.13225 | 2096772.2561400002 | 37.736968751513295 | -122.46467980981899 | (37.7369687515133, -122.464679809819) | |||
59060 | 59060 | 178841 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 856 Prague St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6002067.276880001 | 2086921.00065 | 37.710404894347704 | -122.434642162998 | (37.7104048943477, -122.434642162998) | |||
59257 | 59257 | 212550 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 141 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993683.09574 | 2096704.06961 | 37.7367872908056 | -122.46432924510599 | (37.7367872908056, -122.464329245106) | |||
59577 | 59577 | 214297 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 268 Pacheco St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994416.06125 | 2100657.44777 | 37.747684501052206 | -122.462081692735 | (37.7476845010522, -122.462081692735) | |||
60070 | 60070 | 124587 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3991 Washington St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 5995618.65925 | 2115459.66963 | 37.7883967207528 | -122.458994801868 | (37.7883967207528, -122.458994801868) | |||
60634 | 60634 | 117841 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 600x 39th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 5983809.68656 | 2111621.06726 | 37.7771711351486 | -122.499567510814 | (37.7771711351486, -122.499567510814) | |||
61128 | 61128 | 214484 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1868 17th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 5990968.36883 | 2102715.12154 | 37.753135231722396 | -122.47415361899598 | (37.7531352317224, -122.474153618996) | |||
61650 | 61650 | 212481 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 459 Pacheco St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993828.6402 | 2101727.40952 | 37.7505885054617 | -122.464190611023 | (37.7505885054617, -122.464190611023) | |||
62016 | 62016 | 124588 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3991 Washington St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 5995581.59623 | 2115458.0775 | 37.788390218589 | -122.459122917803 | (37.788390218589, -122.459122917803) | |||
62751 | 62751 | 136028 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 701 Buchanan St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 6ft | 6004477.21749 | 2110912.17552 | 37.7764156757853 | -122.428021412563 | (37.7764156757853, -122.428021412563) | |||
62918 | 62918 | 235752 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 172 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6006048.38845 | 2099234.02907 | 37.7444389853836 | -122.421756594908 | (37.7444389853836, -122.421756594908) | |||
63220 | 63220 | 135844 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1155 Greenwich St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6007360.5897 | 2119841.38777 | 37.801095804879395 | -122.418680361323 | (37.8010958048794, -122.418680361323) | |||
65928 | 65928 | 238009 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1269 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 5997476.9069 | 2105200.1672799997 | 37.7603334305535 | -122.45182517571199 | (37.7603334305535, -122.451825175712) | |||
66086 | 66086 | 212400 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 25 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5991904.93528 | 2095858.14347 | 37.73436193525671 | -122.470415478999 | (37.7343619352567, -122.470415478999) | |||
66594 | 66594 | 178716 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 551 Lisbon St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 6001935.516559999 | 2090267.4815 | 37.719586109087295 | -122.435336775094 | (37.7195861090873, -122.435336775094) | |||
67129 | 67129 | 213001 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1684 09th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 6ft | 5993433.46083 | 2104046.51042 | 37.75693337449479 | -122.465725635034 | (37.7569333744948, -122.465725635034) | |||
68530 | 68530 | 212541 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 165 Terrace Walk | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5993840.6864 | 2096565.82049 | 37.73641677551571 | -122.463774358027 | (37.7364167755157, -122.463774358027) | |||
69187 | 69187 | 212543 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 155 Terrace Walk | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993816.76239 | 2096598.14857 | 37.7365041617454 | -122.463859418574 | (37.7365041617454, -122.463859418574) | |||
69355 | 69355 | 212394 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 55 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5991912.09607 | 2095675.99201 | 37.7338622071685 | -122.47037746106301 | (37.7338622071685, -122.470377461063) | |||
69786 | 69786 | 212402 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5991904.19278 | 2095912.91043 | 37.734512268621295 | -122.470422033273 | (37.7345122686213, -122.470422033273) | |||
71219 | 71219 | 214483 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1868 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 5990967.174319999 | 2102702.6319999998 | 37.7531008695265 | -122.47415683856899 | (37.7531008695265, -122.474156838569) | |||
75496 | 75496 | 213000 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1624 09th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 6ft | 5993419.01621 | 2104404.96618 | 37.757916767851 | -122.465801633144 | (37.757916767851, -122.465801633144) | |||
76574 | 76574 | 124586 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3991 Washington St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 5995636.20396 | 2115462.0086 | 37.7884041514593 | -122.458934269795 | (37.7884041514593, -122.458934269795) | |||
81147 | 81147 | 212391 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 75 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5991916.69552 | 2095588.29265 | 37.7336216726882 | -122.470355174951 | (37.7336216726882, -122.470355174951) | |||
128112 | 128112 | 179649 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 567 Lisbon St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 6001885.830580001 | 2090189.0326 | 37.7193678841138 | -122.43550291222601 | (37.7193678841138, -122.435502912226) | |||
129214 | 129214 | 196119 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1236 De Haro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6012213.24295 | 2102617.02873 | 37.754073692255 | -122.400677278457 | (37.754073692255, -122.400677278457) | |||
129749 | 129749 | 237029 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Octavia St | 10 | : 4 | Tree 1 | Private 1 | 3 | Width 6ft | 6005753.2097 | 2109536.23847 | 37.7727097926437 | -122.423509546241 | (37.7727097926437, -122.423509546241) | |||
131462 | 131462 | 179011 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 579 Lisbon St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6001850.91399 | 2090131.7943 | 37.71920873736379 | -122.435619512955 | (37.7192087373638, -122.435619512955) | |||
132194 | 132194 | 124229 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 219 Stanyan St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5996620.976869999 | 2111333.86588 | 37.7771259241055 | -122.45522868869499 | (37.7771259241055, -122.455228688695) | |||
132642 | 132642 | 212559 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 121 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5993518.68842 | 2096812.9908200002 | 37.7370768832988 | -122.464905576542 | (37.7370768832988, -122.464905576542) |
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");