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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
108981 | 108981 | 103959 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 460X Lily St | 1 | unknown : Pot 31 | Tree 1 | Private 1 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | |||||
29380 | 29380 | 196093 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 01st St | 25 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014406.1146599995 | 2105887.9731 | 37.763177058994 | -122.39332261913601 | (37.763177058994, -122.393322619136) | ||||
30029 | 30029 | 196074 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 7 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014974.36324 | 2102149.68411 | 37.7529440736099 | -122.391095913948 | (37.7529440736099, -122.391095913948) | ||||
31996 | 31996 | 237002 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 199 Franconia St | 11 | : Yard 23 | Tree 1 | Private 1 | 12 | Width 3ft | 6010115.457330001 | 2099644.6115099997 | 37.745794866235 | -122.40772238927 | (37.745794866235, -122.40772238927) | |||
33649 | 33649 | 196072 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 4 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014990.91174 | 2102121.65719 | 37.7528680359305 | -122.391036726872 | (37.7528680359305, -122.391036726872) | ||||
37053 | 37053 | 218147 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 33 Ashton Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 8 | 5994130.90264 | 2090096.18725 | 37.7186694580143 | -122.462301880921 | (37.7186694580143, -122.462301880921) | ||||
37555 | 37555 | 237003 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 199 Franconia St | 14 | : Yard 23 | Tree 1 | Private 1 | 9 | Width 3ft | 6010106.165469999 | 2099668.32603 | 37.7458594609566 | -122.40775619120001 | (37.7458594609566, -122.4077561912) | |||
37605 | 37605 | 237004 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 199 Franconia St | 15 | : Yard 23 | Tree 1 | Private 1 | 8 | Width 3ft | 6010095.49496 | 2099684.36191 | 37.7459028946219 | -122.40779421904101 | (37.7459028946219, -122.407794219041) | |||
66873 | 66873 | 196280 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 11 | : Yard 23 | Tree 1 | Private 1 | 12 | 6015022.69172 | 2102195.1938 | 37.7530717153135 | -122.39093196394501 | (37.7530717153135, -122.390931963945) | ||||
74692 | 74692 | 196073 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 5 | : Yard 23 | Tree 1 | Private 1 | 9 | 6014983.580569999 | 2102134.9117099997 | 37.752904023218605 | -122.391063005979 | (37.7529040232186, -122.391063005979) | ||||
130300 | 130300 | 196281 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 12 | : Yard 23 | Tree 1 | Private 1 | 12 | 6015018.372359999 | 2102200.19302 | 37.7530852024401 | -122.39094725063102 | (37.7530852024401, -122.390947250631) | ||||
130498 | 130498 | 196075 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 17 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014963.469190001 | 2102214.24517 | 37.753120740043705 | -122.391138100256 | (37.7531207400437, -122.391138100256) | ||||
132015 | 132015 | 196092 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 01st St | 24 | : Yard 23 | Tree 1 | Private 1 | 10 | 6014425.82588 | 2105887.0502299997 | 37.7631756200823 | -122.393254379501 | (37.7631756200823, -122.393254379501) | ||||
132022 | 132022 | 196279 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 6 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014984.46572 | 2102135.07494 | 37.7529045205317 | -122.39105995634701 | (37.7529045205317, -122.391059956347) | ||||
133863 | 133863 | 196076 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 18 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014971.87416 | 2102223.03647 | 37.753145345506795 | -122.39110964840401 | (37.7531453455068, -122.391109648404) | ||||
137606 | 137606 | 196282 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 13 | : Yard 23 | Tree 1 | Private 1 | 12 | 6015015.25562 | 2102205.64875 | 37.75310000977571 | -122.39095841029499 | (37.7531000097757, -122.390958410295) | ||||
151585 | 151585 | 196077 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 19 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014960.28506 | 2102234.79181 | 37.7531769800583 | -122.391150547759 | (37.7531769800583, -122.391150547759) | ||||
152443 | 152443 | 196094 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 01st St | 26 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014400.8809 | 2105882.83985 | 37.7631626734333 | -122.393340361863 | (37.7631626734333, -122.393340361863) | ||||
154821 | 154821 | 237005 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 199 Franconia St | 16 | : Yard 23 | Tree 1 | Private 1 | 9 | Width 3ft | 6010090.49979 | 2099699.0653 | 37.7459429872721 | -122.40781252834101 | (37.7459429872721, -122.407812528341) | |||
119612 | 119612 | 96804 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200X Revere Ave | 1 | Median : 22 | Tree 1 | DPW 2 | 6017205.4 | 2092876.1 | 37.7276042330013 | -122.38273521775801 | (37.7276042330013, -122.382735217758) | |||||
52627 | 52627 | 98408 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 24 19th Ave | 2 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 02/09/2012 12:00:00 AM | 3 | Permit Number 768590 | 5989918.49451 | 2114923.36913 | 37.7865948726066 | -122.478677005621 | (37.7865948726066, -122.478677005621) | ||
155501 | 155501 | 98407 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 24 19th Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 02/09/2012 12:00:00 AM | 3 | Permit Number 768590 | 5989919.44776 | 2114906.64899 | 37.7865490191546 | -122.47867248440201 | (37.7865490191546, -122.478672484402) | ||
176682 | 176682 | 98235 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 42 19th Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 01/09/2012 12:00:00 AM | 3 | Permit Number 768620 | 5989920.54745 | 2114876.2625700003 | 37.7864656504451 | -122.47866645673 | (37.7864656504451, -122.47866645673) | ||
86739 | 86739 | 86757 | Permitted Site 1 | Prunus spp :: Cherry 84 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
3601 | 3601 | 246904 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 491 Frederick St | 2 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 6 | Width 3ft | 5997307.10356 | 2107397.6585 | 37.7663574565623 | -122.452571034738 | (37.7663574565623, -122.452571034738) | |||
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 | ||||||||||
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 | ||||||||||
23934 | 23934 | 248050 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 38 Rutledge St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6010496.13368 | 2099436.61391 | 37.7452450531093 | -122.406391405264 | (37.7452450531093, -122.406391405264) | ||||
25114 | 25114 | 249640 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2400 Lyon St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999291.5931400005 | 2117167.12216 | 37.79329538582 | -122.446409970041 | (37.79329538582, -122.446409970041) | ||||
25256 | 25256 | 238433 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 272 Corbett Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 3ft | 5999629.6727599995 | 2105348.1757099996 | 37.7608628875441 | -122.444390425487 | (37.7608628875441, -122.444390425487) | |||
25273 | 25273 | 237871 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 200 Corbin Pl | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6000061.7105 | 2105723.34521 | 37.761917651093704 | -122.44292314469 | (37.7619176510937, -122.44292314469) | |||
25566 | 25566 | 214228 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 714 Detroit St | 16 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5999467.5472800005 | 2095443.9032 | 37.733658896535 | -122.444239403229 | (37.733658896535, -122.444239403229) | ||||
26362 | 26362 | 196123 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2300 20th St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 4ft | 6011242.42693 | 2104654.95461 | 37.7596151915071 | -122.404178032517 | (37.7596151915071, -122.404178032517) | |||
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) | |||
28786 | 28786 | 214229 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 714 Detroit St | 17 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5999467.99685 | 2095449.76583 | 37.7336750195872 | -122.444238270085 | (37.7336750195872, -122.444238270085) | ||||
29648 | 29648 | 196372 | Undocumented 2 | Prunus spp :: Cherry 84 | 1700 Armstrong Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6013890.9677099995 | 2092887.97335 | 37.7274531643304 | -122.394194162931 | (37.7274531643304, -122.394194162931) | ||||
30197 | 30197 | 196336 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 1750 22nd St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6012821.16046 | 2103795.98592 | 37.757344738798 | -122.398657667323 | (37.757344738798, -122.398657667323) | ||||
30408 | 30408 | 248049 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 38 Rutledge St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010499.7614 | 2099438.0486 | 37.7452491953942 | -122.40637896223 | (37.7452491953942, -122.40637896223) | ||||
31357 | 31357 | 237945 | Undocumented 2 | Prunus spp :: Cherry 84 | 99 Aztec St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6007968.29609 | 2099608.22097 | 37.7455745134701 | -122.415144412305 | (37.7455745134701, -122.415144412305) | ||||
31814 | 31814 | 196480 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1499 Rankin St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6012679.65409 | 2096682.3113 | 37.737804227083004 | -122.39864786201001 | (37.737804227083, -122.39864786201) | |||
32496 | 32496 | 248112 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 108 Brewster St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010381.20708 | 2099441.9489 | 37.745253272029096 | -122.406789179892 | (37.7452532720291, -122.406789179892) | ||||
32768 | 32768 | 248178 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 218 Esmeralda Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6007415.21428 | 2098671.9184 | 37.7429725382626 | -122.416990561277 | (37.7429725382626, -122.416990561277) | ||||
34244 | 34244 | 196191 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1700 Armstrong Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6013892.03543 | 2092881.8479400002 | 37.727436404540796 | -122.39419004313 | (37.7274364045408, -122.39419004313) | ||||
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) | ||||
37251 | 37251 | 136604 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 3798 Webster St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 2ft | 6002548.10466 | 2121650.0452 | 37.8057897776435 | -122.435463071378 | (37.8057897776435, -122.435463071378) | |||
37530 | 37530 | 249638 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2400 Lyon St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 5999293.71803 | 2117149.90797 | 37.7932482415769 | -122.446401378842 | (37.7932482415769, -122.446401378842) | ||||
38374 | 38374 | 136055 | Undocumented 2 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 1114 Greenwich St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6007559.35658 | 2119902.6850400004 | 37.8012753005604 | -122.417996888269 | (37.8012753005604, -122.417996888269) | ||||
38547 | 38547 | 196063 | Undocumented 2 | Prunus spp :: Cherry 84 | 1751 22nd St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 5ft | 6012868.1198 | 2103766.18767 | 37.757265535503 | -122.39849317144501 | (37.757265535503, -122.398493171445) | |||
39076 | 39076 | 123168 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 598 10th Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5992809.72377 | 2111438.2053099996 | 37.7771930089585 | -122.468420491782 | (37.7771930089585, -122.468420491782) | ||||
46734 | 46734 | 214372 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1500 16th Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5991179.13729 | 2105098.7165599996 | 37.759692162681 | -122.473598605112 | (37.759692162681, -122.473598605112) | ||||
48369 | 48369 | 179631 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 184 Mount Vernon Ave | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 5998932.987869999 | 2089405.3609099998 | 37.7170479506817 | -122.445653426162 | (37.7170479506817, -122.445653426162) | ||||
49284 | 49284 | 196125 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2300 20th St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 4ft | 6011177.05787 | 2104649.1602 | 37.7595956285643 | -122.40440370476101 | (37.7595956285643, -122.404403704761) | |||
52420 | 52420 | 136605 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 3798 Webster St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 4ft | 6002548.49635 | 2121661.6698 | 37.805821717964605 | -122.43546254797701 | (37.8058217179646, -122.435462547977) | |||
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) | |||
59767 | 59767 | 179661 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 287 Hester Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6012216.37842 | 2087780.43205 | 37.7133356679799 | -122.399624805455 | (37.7133356679799, -122.399624805455) | ||||
63837 | 63837 | 234919 | Undocumented 2 | Prunus spp :: Cherry 84 | 200 Saint Marys Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 4ft | 6003932.02563 | 2095971.19882 | 37.735360426449105 | -122.428841975603 | (37.7353604264491, -122.428841975603) | |||
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) | ||||
68012 | 68012 | 136610 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 3798 Webster St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 4ft | 6002559.08771 | 2121673.9848 | 37.805856133210895 | -122.43542677652 | (37.8058561332109, -122.43542677652) | |||
70823 | 70823 | 237870 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 200 Corbin Pl | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6000061.78033 | 2105726.70817 | 37.7619268889309 | -122.442923144685 | (37.7619268889309, -122.442923144685) | |||
71454 | 71454 | 249847 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 289 Greenwich St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6011426.79495 | 2120392.20909 | 37.8028363185975 | -122.40464825831002 | (37.8028363185975, -122.40464825831) | |||
72627 | 72627 | 136608 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 3798 Webster St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 4ft | 6002554.72948 | 2121670.19367 | 37.8058454762555 | -122.435441587454 | (37.8058454762555, -122.435441587454) | |||
73767 | 73767 | 249636 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2400 Lyon St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 5999299.542640001 | 2117085.0893099997 | 37.7930705993714 | -122.446376560233 | (37.7930705993714, -122.446376560233) | ||||
73968 | 73968 | 187552 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 2 Beeman Ln | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6012028.620569999 | 2088183.9402700001 | 37.7144331529482 | -122.400302089394 | (37.7144331529482, -122.400302089394) | ||||
75463 | 75463 | 136607 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 3798 Webster St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 5ft | 6002552.02607 | 2121667.51893 | 37.8058379785924 | -122.435450751546 | (37.8058379785924, -122.435450751546) | |||
76444 | 76444 | 196479 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1499 Rankin St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 3ft | 6012661.099719999 | 2096663.01157 | 37.737750200312206 | -122.39871065986601 | (37.7377502003122, -122.398710659866) | |||
129644 | 129644 | 214463 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 714 Detroit St | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5999453.46925 | 2095428.5374599998 | 37.733615902639706 | -122.44428697109 | (37.7336159026397, -122.44428697109) | ||||
130601 | 130601 | 179660 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 287 Hester Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6012212.84494 | 2087789.77212 | 37.7133611169841 | -122.399637673848 | (37.7133611169841, -122.399637673848) | ||||
131205 | 131205 | 196298 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2198 Revere Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6011933.586759999 | 2096785.03715 | 37.738044695904605 | -122.40123461080799 | (37.7380446959046, -122.401234610808) | ||||
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) | ||||
137004 | 137004 | 196478 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1499 Rankin St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 3ft | 6012656.37794 | 2096656.5486400002 | 37.7377321913814 | -122.39872653201799 | (37.7377321913814, -122.398726532018) | |||
149621 | 149621 | 196124 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2300 20th St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 4ft | 6011192.22551 | 2104649.1364599997 | 37.7595964109771 | -122.40435124553998 | (37.7595964109771, -122.40435124554) | |||
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) | |||
155365 | 155365 | 196193 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2198 Revere Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6011935.59565 | 2096781.31623 | 37.73803459111979 | -122.401227403639 | (37.7380345911198, -122.401227403639) | ||||
156569 | 156569 | 247882 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 387 Mayflower St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6009927.8842 | 2098400.72535 | 37.7423689240761 | -122.40828327575701 | (37.7423689240761, -122.408283275757) | ||||
156969 | 156969 | 248056 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 17 Rutledge St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010671.1144 | 2099351.76088 | 37.7450218521921 | -122.405780372559 | (37.7450218521921, -122.405780372559) | ||||
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) | |||
162408 | 162408 | 213702 | Undocumented 2 | Prunus spp :: Cherry 84 | 714 Detroit St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 5999450.30082 | 2095402.17977 | 37.7335433498509 | -122.444296031758 | (37.7335433498509, -122.444296031758) | ||||
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) | ||||
164280 | 164280 | 247909 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 582 Esmeralda Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009857.303669999 | 2098747.94229 | 37.743318353655 | -122.408551810625 | (37.743318353655, -122.408551810625) | ||||
169682 | 169682 | 179659 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 287 Hester Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6012208.68796 | 2087783.6774 | 37.7133441503725 | -122.39965161424801 | (37.7133441503725, -122.399651614248) | ||||
169728 | 169728 | 249848 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 289 Greenwich St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6011433.333 | 2120390.12785 | 37.8028309694274 | -122.404625486584 | (37.8028309694274, -122.404625486584) | |||
172744 | 172744 | 196477 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1499 Rankin St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 3ft | 6012648.615180001 | 2096647.7620400002 | 37.7377076327033 | -122.39875275533501 | (37.7377076327033, -122.398752755335) | |||
173692 | 173692 | 237872 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 200 Corbin Pl | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6000053.4214699995 | 2105717.34957 | 37.7619007159651 | -122.44295138252 | (37.7619007159651, -122.44295138252) | |||
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) | ||||
177483 | 177483 | 196062 | Undocumented 2 | Prunus spp :: Cherry 84 | 1751 22nd St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 5ft | 6012859.76673 | 2103766.08005 | 37.757264774654395 | -122.398522052264 | (37.7572647746544, -122.398522052264) | |||
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) | ||||
179334 | 179334 | 136052 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1114 Greenwich St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6007569.13805 | 2119905.68389 | 37.801284085155004 | -122.41796325270201 | (37.801284085155, -122.417963252702) | ||||
179533 | 179533 | 249637 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2400 Lyon St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999297.09837 | 2117106.84322 | 37.7931301902456 | -122.4463865832 | (37.7931301902456, -122.4463865832) | ||||
180928 | 180928 | 248055 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 17 Rutledge St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010658.86611 | 2099354.83953 | 37.745029620524605 | -122.405822941986 | (37.7450296205246, -122.405822941986) | ||||
184390 | 184390 | 178694 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 184 Mount Vernon Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5998957.82756 | 2089383.479 | 37.7169892861082 | -122.44556599497801 | (37.7169892861082, -122.445565994978) | ||||
184976 | 184976 | 214230 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 714 Detroit St | 20 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999463.98385 | 2095461.59315 | 37.7337072656774 | -122.444252993784 | (37.7337072656774, -122.444252993784) | ||||
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) | |||
186195 | 186195 | 196068 | Undocumented 2 | Prunus spp :: Cherry 84 | 1700 Armstrong Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6013885.20395 | 2092887.6121599998 | 37.727451852204204 | -122.39421406314399 | (37.7274518522042, -122.394214063144) | ||||
187449 | 187449 | 196192 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2198 Revere Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6011951.07495 | 2096769.0187900001 | 37.7380016885201 | -122.40117301982 | (37.7380016885201, -122.40117301982) | ||||
188021 | 188021 | 136609 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 3798 Webster St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 4ft | 6002557.10875 | 2121672.73918 | 37.805852600677795 | -122.435433535844 | (37.8058526006778, -122.435433535844) | |||
188746 | 188746 | 136606 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 3798 Webster St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 5ft | 6002550.09467 | 2121664.33857 | 37.8058291364749 | -122.43545720778799 | (37.8058291364749, -122.435457207788) | |||
3513 | 3513 | 247938 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 29 Joy St | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 9 | Permit Number 775404 | 6010254.90659 | 2098918.71089 | 37.7438095066969 | -122.407189031056 | (37.7438095066969, -122.407189031056) | |||
85877 | 85877 | 103517 | Permitted Site 1 | Prunus spp :: Cherry 84 | 55X MacOndray Ln | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | Permit Number 770452 | 6008432.0 | 2119159.0 | 37.7992824016355 | -122.41492448290899 | (37.7992824016355, -122.414924482909) | ||||
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) | |||
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) |
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");