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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
113240 | 113240 | 67948 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 491 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 6 | ex3 | Permit Number 31662 | 5988736.13806 | 2111981.42447 | 37.778448401356705 | -122.48255196765498 | (37.7784484013567, -122.482551967655) |
36320 | 36320 | 212934 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1964 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 9ft | 5990996.330519999 | 2102040.26003 | 37.751283858566104 | -122.47400768869801 | (37.7512838585661, -122.474007688698) | |||
39187 | 39187 | 178946 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 25 Madison St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 9ft | 6005433.25 | 2093389.63985 | 37.7283568930528 | -122.42346820799 | (37.7283568930528, -122.42346820799) | |||
55435 | 55435 | 131324 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 400 Cherry St | 14 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 9ft | 5996252.06992 | 2114879.22587 | 37.7868393686989 | -122.456761319676 | (37.7868393686989, -122.456761319676) | |||
56547 | 56547 | 129893 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 400 Cherry St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 9ft | 5996283.0892 | 2114624.04425 | 37.78614048933979 | -122.45663553961701 | (37.7861404893398, -122.456635539617) | |||
59450 | 59450 | 196470 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950 Newcomb Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 9ft | 6013295.589480001 | 2097174.20298 | 37.7391891560441 | -122.39655273032899 | (37.7391891560441, -122.396552730329) | |||
66177 | 66177 | 131322 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 400 Cherry St | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 9ft | 5996256.90517 | 2114854.47123 | 37.786771676724 | -122.45674279995501 | (37.786771676724, -122.456742799955) | |||
129709 | 129709 | 131323 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 400 Cherry St | 12 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 9ft | 5996254.50366 | 2114867.62545 | 37.7868076567964 | -122.456752060266 | (37.7868076567964, -122.456752060266) | |||
146780 | 146780 | 214408 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Idora Ave | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 9ft | 5995751.653580001 | 2099314.25679 | 37.7440732391823 | -122.457366158726 | (37.7440732391823, -122.457366158726) | |||
148511 | 148511 | 212576 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100x Idora Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 9ft | 5995353.74805 | 2099410.49817 | 37.74431463161879 | -122.458748984199 | (37.7443146316188, -122.458748984199) | |||
161733 | 161733 | 196296 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 383 Arkansas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 9ft | 6012973.423830001 | 2105290.2988400003 | 37.7614562764103 | -122.398235915848 | (37.7614562764103, -122.398235915848) | |||
167759 | 167759 | 196407 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 301 Pennsylvania Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6014364.2295 | 2105674.4780599996 | 37.7625885210619 | -122.393452545091 | (37.7625885210619, -122.393452545091) | |||
174694 | 174694 | 214258 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 501 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 9ft | 5997049.83244 | 2095507.43022 | 37.7336950951374 | -122.452602689063 | (37.7336950951374, -122.452602689063) | |||
181872 | 181872 | 124180 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8X Almaden Ct | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 9ft | 5995876.0 | 2112606.0 | 37.7805760973259 | -122.457897862346 | (37.7805760973259, -122.457897862346) | |||
25266 | 25266 | 215207 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 160 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 8ft | 5993414.72395 | 2095618.6966 | 37.7337916535606 | -122.465178304956 | (37.7337916535606, -122.465178304956) | |||
25772 | 25772 | 179691 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 425 Pioche St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6005621.06817 | 2093204.8072799998 | 37.72785998252721 | -122.422805780863 | (37.7278599825272, -122.422805780863) | |||
25908 | 25908 | 214251 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 470 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5998963.14193 | 2095000.98839 | 37.7324139668331 | -122.445951428216 | (37.7324139668331, -122.445951428216) | |||
26039 | 26039 | 236674 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4301 26th St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6001900.9288 | 2100573.2486400004 | 37.747881410301 | -122.436193451291 | (37.747881410301, -122.436193451291) | |||
27714 | 27714 | 237848 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 21 Addison St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | Width 8ft | 6003593.08721 | 2096850.61715 | 37.7377559191042 | -122.430076526206 | (37.7377559191042, -122.430076526206) | |||
30557 | 30557 | 215212 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 165 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 8ft | 5993408.7609 | 2095708.9649099999 | 37.7340391640776 | -122.465205475246 | (37.7340391640776, -122.465205475246) | |||
30789 | 30789 | 236735 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2235 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | Width 8ft | 6002728.24168 | 2098985.0046599996 | 37.7435674334864 | -122.433219176525 | (37.7435674334864, -122.433219176525) | |||
30957 | 30957 | 212587 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 147 Edna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5998729.2739699995 | 2093442.0374900002 | 37.7281200970646 | -122.446647836227 | (37.7281200970646, -122.446647836227) | |||
31790 | 31790 | 215217 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 133 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5993392.21356 | 2095932.78503 | 37.7346527642991 | -122.465278936386 | (37.7346527642991, -122.465278936386) | |||
31907 | 31907 | 246740 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 132 Ripley St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 8ft | 6008857.53269 | 2099073.06292 | 37.7441550208325 | -122.41203174448201 | (37.7441550208325, -122.412031744482) | |||
34688 | 34688 | 239029 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 26 Harry St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003326.300869999 | 2097748.91757 | 37.740207332512796 | -122.431063031234 | (37.7402073325128, -122.431063031234) | |||
35447 | 35447 | 215218 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 133 San Buenaventura Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 8ft | 5993390.45214 | 2095959.7776 | 37.734726777609296 | -122.465286986206 | (37.7347267776093, -122.465286986206) | |||
36090 | 36090 | 124683 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 3899 Jackson St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5995553.12452 | 2115771.60073 | 37.789249431740295 | -122.459244137371 | (37.7892494317403, -122.459244137371) | |||
36107 | 36107 | 215203 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 120 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 5993362.10241 | 2095871.1002099998 | 37.7344816565847 | -122.465378560574 | (37.7344816565847, -122.465378560574) | |||
36378 | 36378 | 178800 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 426 Princeton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6008027.45015 | 2091896.60863 | 37.7244034301488 | -122.41439431206699 | (37.7244034301488, -122.414394312067) | |||
36595 | 36595 | 196340 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 8ft | 6015958.58897 | 2099937.15281 | 37.7469234920398 | -122.387537900079 | (37.7469234920398, -122.387537900079) | |||
40064 | 40064 | 136617 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1075 Francisco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6006167.26583 | 2120699.80075 | 37.803385530067104 | -122.422870825248 | (37.8033855300671, -122.422870825248) | |||
40224 | 40224 | 215216 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 133 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 8ft | 5993391.28977 | 2095902.6603400002 | 37.7345699961108 | -122.465279942742 | (37.7345699961108, -122.465279942742) | |||
40633 | 40633 | 179692 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 425 Pioche St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6005640.05215 | 2093208.69537 | 37.7278717294828 | -122.42274042892299 | (37.7278717294828, -122.422740428923) | |||
40814 | 40814 | 212668 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 162 Ramsell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 5992987.499559999 | 2088299.56272 | 37.713670454102896 | -122.46612364171101 | (37.7136704541029, -122.466123641711) | |||
41280 | 41280 | 124684 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 3899 Jackson St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5995566.4285 | 2115772.64492 | 37.7892530636592 | -122.459198183151 | (37.7892530636592, -122.459198183151) | |||
41647 | 41647 | 246741 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 132 Ripley St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 8ft | 6008870.15252 | 2099074.1430099998 | 37.7441586945704 | -122.41198818403099 | (37.7441586945704, -122.411988184031) | |||
43020 | 43020 | 238528 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 28 Harry St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6003301.9628099995 | 2097731.40275 | 37.740157861699295 | -122.431145932563 | (37.7401578616993, -122.431145932563) | |||
43256 | 43256 | 215267 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 144 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 6000534.409630001 | 2095247.93227 | 37.7331816146194 | -122.44053690695499 | (37.7331816146194, -122.440536906955) | |||
45976 | 45976 | 212870 | Undocumented 2 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 51 Monticello St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5991652.84437 | 2089051.91325 | 37.7156591339399 | -122.470791419899 | (37.7156591339399, -122.470791419899) | |||
46274 | 46274 | 215268 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 441 Congo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 8ft | 6000072.9793 | 2095175.00854 | 37.7329550970048 | -122.44212695871401 | (37.7329550970048, -122.442126958714) | |||
49528 | 49528 | 212863 | Undocumented 2 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 51 Monticello St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5991651.701230001 | 2089132.7478900002 | 37.7158810200719 | -122.470801255781 | (37.7158810200719, -122.470801255781) | |||
49691 | 49691 | 196149 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 502 Missouri St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 8ft | 6013503.97316 | 2104707.95515 | 37.759886826325705 | -122.39636013421301 | (37.7598868263257, -122.396360134213) | |||
49695 | 49695 | 215215 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 135 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 8ft | 5993391.6514800005 | 2095878.3056299998 | 37.734503144986796 | -122.46527692371299 | (37.7345031449868, -122.465276923713) | |||
50366 | 50366 | 178762 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 239 Cotter St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 8ft | 6001593.80864 | 2093905.46248 | 37.7295557693705 | -122.436778218343 | (37.7295557693705, -122.436778218343) | |||
51179 | 51179 | 215231 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 218 Congo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 8ft | 6000116.88517 | 2094489.86017 | 37.731076341301105 | -122.441926006083 | (37.7310763413011, -122.441926006083) | |||
51919 | 51919 | 178799 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 426 Princeton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6008025.38045 | 2091906.1751599999 | 37.7244295815351 | -122.41440214334601 | (37.7244295815351, -122.414402143346) | |||
53144 | 53144 | 215210 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 175 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 8ft | 5993443.73697 | 2095631.67692 | 37.7338289673255 | -122.46507894154101 | (37.7338289673255, -122.465078941541) | |||
53713 | 53713 | 215272 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 320 Congo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6000122.7569699995 | 2094814.1561099999 | 37.731967117070205 | -122.441928973853 | (37.7319671170702, -122.441928973853) | |||
54218 | 54218 | 215213 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 165 San Buenaventura Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 8ft | 5993401.22415 | 2095752.02074 | 37.7341569500769 | -122.465234658272 | (37.7341569500769, -122.465234658272) | |||
54914 | 54914 | 179171 | Undocumented 2 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 424 Ellington Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5998427.605819999 | 2087535.4733799999 | 37.711884799823295 | -122.44726577840599 | (37.7118847998233, -122.447265778406) | |||
54919 | 54919 | 237847 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 21 Addison St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | Width 8ft | 6003573.70242 | 2096850.7481 | 37.7377551807635 | -122.430143558104 | (37.7377551807635, -122.430143558104) | |||
56912 | 56912 | 212871 | Undocumented 2 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 51 Monticello St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5991640.98496 | 2088998.4603 | 37.7155116793019 | -122.47082851964198 | (37.7155116793019, -122.470828519642) | |||
65481 | 65481 | 215206 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 160 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 8ft | 5993391.84031 | 2095665.5531400002 | 37.73391899035779 | -122.465260822253 | (37.7339189903578, -122.465260822253) | |||
67654 | 67654 | 215214 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 135 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 8ft | 5993392.86665 | 2095839.1505 | 37.7343957048025 | -122.465269879313 | (37.7343957048025, -122.465269879313) | |||
68703 | 68703 | 178875 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 190 Foote Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5998646.9675199995 | 2088361.56482 | 37.7141655911394 | -122.446567002474 | (37.7141655911394, -122.446567002474) | |||
70402 | 70402 | 215201 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 100 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | Width 8ft | 5993358.68485 | 2095957.8363599998 | 37.7347196153991 | -122.46539667472601 | (37.7347196153991, -122.465396674726) | |||
71309 | 71309 | 212868 | Undocumented 2 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 51 Monticello St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5991651.55425 | 2089037.47957 | 37.715619427959 | -122.47079482833999 | (37.715619427959, -122.47079482834) | |||
72197 | 72197 | 215209 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 170 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 5993450.93036 | 2095568.66163 | 37.7336563577529 | -122.465049496831 | (37.7336563577529, -122.465049496831) | |||
73641 | 73641 | 212866 | Undocumented 2 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 51 Monticello St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5991652.15629 | 2089084.13687 | 37.7157475723637 | -122.470796144046 | (37.7157475723637, -122.470796144046) | |||
77008 | 77008 | 215208 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 170 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 8ft | 5993433.56613 | 2095587.2868599999 | 37.7337064967398 | -122.465110881879 | (37.7337064967398, -122.465110881879) | |||
129879 | 129879 | 212867 | Undocumented 2 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 51 Monticello St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5991651.866909999 | 2089070.39712 | 37.715709829619996 | -122.470796144023 | (37.71570982962, -122.470796144023) | |||
131981 | 131981 | 215211 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 165 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 8ft | 5993424.832330001 | 2095670.3673599998 | 37.733934111557204 | -122.46514710927299 | (37.7339341115572, -122.465147109273) | |||
132578 | 132578 | 196273 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6018678.54669 | 2093695.28939 | 37.729934846200294 | -122.377699306103 | (37.7299348462003, -122.377699306103) | |||
133182 | 133182 | 212869 | Undocumented 2 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 51 Monticello St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 5991651.55375 | 2089014.04601 | 37.715555085077604 | -122.470793124129 | (37.7155550850776, -122.470793124129) | |||
133292 | 133292 | 215271 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 320 Congo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 6000123.057519999 | 2094800.74897 | 37.7319303213134 | -122.44192697284599 | (37.7319303213134, -122.441926972846) | |||
135125 | 135125 | 178874 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 190 Foote Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5998666.63351 | 2088343.6345099998 | 37.7141174818994 | -122.446497740299 | (37.7141174818994, -122.446497740299) | |||
136910 | 136910 | 212862 | Undocumented 2 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 51 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5991653.11039 | 2089152.8460099997 | 37.7159362861084 | -122.47079784824498 | (37.7159362861084, -122.470797848245) | |||
149541 | 149541 | 212864 | Undocumented 2 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 51 Monticello St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5991651.360169999 | 2089116.5547 | 37.7158365377914 | -122.470801255775 | (37.7158365377914, -122.470801255775) | |||
152139 | 152139 | 196275 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6018699.22943 | 2093690.01585 | 37.729921505667 | -122.37762743678101 | (37.729921505667, -122.377627436781) | |||
153533 | 153533 | 117710 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 477 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5983117.17834 | 2112671.33055 | 37.7800141944428 | -122.502040811752 | (37.7800141944428, -122.502040811752) | |||
153801 | 153801 | 196274 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6018690.35337 | 2093691.67274 | 37.7299255661145 | -122.377658237655 | (37.7299255661145, -122.377658237655) | |||
154192 | 154192 | 214784 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 222 Fowler Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 50 | Width 8ft | 5997118.36808 | 2099147.53648 | 37.7436938709906 | -122.45262836023399 | (37.7436938709906, -122.452628360234) | |||
154255 | 154255 | 247009 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 401 Valley St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | Width 8ft | 6003278.48209 | 2099193.13161 | 37.744170100676996 | -122.431331435716 | (37.744170100677, -122.431331435716) | |||
157565 | 157565 | 215250 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 520 Arch St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5992758.1847 | 2090664.5283599999 | 37.720150845563396 | -122.46708806925501 | (37.7201508455634, -122.467088069255) | |||
157870 | 157870 | 215205 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 130 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 8ft | 5993367.47996 | 2095754.56333 | 37.7341619853887 | -122.465351506265 | (37.7341619853887, -122.465351506265) | |||
163799 | 163799 | 237426 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4301 26th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6001882.89987 | 2100571.76133 | 37.747876302159796 | -122.436255687975 | (37.7478763021598, -122.436255687975) | |||
169862 | 169862 | 214472 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 249 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6000443.47619 | 2094924.07855 | 37.732287209190396 | -122.44082806428499 | (37.7322872091904, -122.440828064285) | |||
170080 | 170080 | 237063 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 132 27th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 8ft | 6005626.63256 | 2100241.78482 | 37.7471822602654 | -122.423286564723 | (37.7471822602654, -122.423286564723) | |||
170977 | 170977 | 196272 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6018667.18531 | 2093699.9533900002 | 37.7299470266284 | -122.377738907749 | (37.7299470266284, -122.377738907749) | |||
172449 | 172449 | 212865 | Undocumented 2 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 51 Monticello St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5991651.98385 | 2089099.3592599998 | 37.7157893593682 | -122.470797848251 | (37.7157893593682, -122.470797848251) | |||
172732 | 172732 | 215266 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 144 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 8ft | 6000556.38371 | 2095246.8523 | 37.7331799005214 | -122.44046085939199 | (37.7331799005214, -122.440460859392) | |||
175560 | 175560 | 214826 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Judson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5999324.23026 | 2093457.23325 | 37.728195788502795 | -122.444592150628 | (37.7281957885028, -122.444592150628) | |||
175710 | 175710 | 124184 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Almaden Ct | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 5995890.93647 | 2112594.82496 | 37.780546271753295 | -122.457845381425 | (37.7805462717533, -122.457845381425) | |||
176380 | 176380 | 136618 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1075 Francisco St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 8ft | 6006192.108580001 | 2120703.43748 | 37.8033969172965 | -122.422785114443 | (37.8033969172965, -122.422785114443) | |||
176683 | 176683 | 179153 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 412 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 8ft | 6001969.08964 | 2086773.8202799999 | 37.7099951946836 | -122.434970999229 | (37.7099951946836, -122.434970999229) | |||
178374 | 178374 | 215202 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 100 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 5993358.65821 | 2095928.85229 | 37.7346400308107 | -122.465394662057 | (37.7346400308107, -122.465394662057) | |||
179258 | 179258 | 196339 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 8ft | 6015967.11689 | 2099936.1121799997 | 37.7469211070262 | -122.387508338452 | (37.7469211070262, -122.387508338452) | |||
181976 | 181976 | 136014 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Havens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 6007575.68988 | 2119392.2209400004 | 37.7998746136871 | -122.417904161874 | (37.7998746136871, -122.417904161874) | |||
185688 | 185688 | 214285 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 209 Edna St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5998729.83895 | 2093556.15177 | 37.728433460428 | -122.44665409012501 | (37.728433460428, -122.446654090125) | |||
185796 | 185796 | 214455 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 449 Baden St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 8ft | 6000738.084840001 | 2095503.40232 | 37.733894671806 | -122.439851058803 | (37.733894671806, -122.439851058803) | |||
186331 | 186331 | 215204 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 120 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 5993362.71827 | 2095845.00098 | 37.734410030100996 | -122.465374536105 | (37.734410030101, -122.465374536105) | |||
186895 | 186895 | 196150 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 502 Missouri St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 8ft | 6013505.49575 | 2104693.9882799997 | 37.7598485610787 | -122.396353889321 | (37.7598485610787, -122.396353889321) | |||
187914 | 187914 | 135943 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2056 Jefferson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5999351.778519999 | 2121203.50658 | 37.8043816542415 | -122.446492250814 | (37.8043816542415, -122.446492250814) | |||
32816 | 32816 | 202152 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1951 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 6013046.17664 | 2093441.4035900002 | 37.7289257780866 | -122.397153419018 | (37.7289257780866, -122.397153419018) | |||
36337 | 36337 | 235746 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 175 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 7ft | 6005414.222019999 | 2100184.87924 | 37.7470140204997 | -122.424017018376 | (37.7470140204997, -122.424017018376) | |||
41059 | 41059 | 196515 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 2075 Palou Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 6012358.51021 | 2097085.95445 | 37.7388946487629 | -122.399786553923 | (37.7388946487629, -122.399786553923) | |||
41368 | 41368 | 197881 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 7ft | 6015646.32257 | 2101941.32655 | 37.75240923331361 | -122.38875758671101 | (37.7524092333136, -122.388757586711) | |||
41580 | 41580 | 197879 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6015633.716580001 | 2101939.6096099997 | 37.752403820278396 | -122.388801060829 | (37.7524038202784, -122.388801060829) | |||
43068 | 43068 | 196481 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2075 Palou Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 6012348.976530001 | 2097093.78891 | 37.738915629056 | -122.399820067148 | (37.738915629056, -122.399820067148) | |||
43842 | 43842 | 197877 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6015625.5144 | 2101938.71923 | 37.7524009208729 | -122.388829363409 | (37.7524009208729, -122.388829363409) |
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");