Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSpecies, SiteOrder, qCaretaker, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | ||||
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) | ||||
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) | |||
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) | |||
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) | ||||
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) | ||||
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) | |||
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 | ||||||||||
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) | ||||
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) | ||||
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) | ||||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | ||||
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) | |||
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) | ||||
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) | ||||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | |||
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) | ||||
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) | ||||
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) | |||
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) | |||
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) | ||||
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) | ||||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | ||||
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) | ||||
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) | ||||
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) | |||
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) | ||||
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) | ||||
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) | |||
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) | ||||
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) | ||||
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) | ||||
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) | |||
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) | ||||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) |
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");