trees
494 rows where qSpecies_id = 243 sorted by Supervisor Districts
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts ▼ | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2950 | 19885 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 STAIRWAY33 | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
5748 | 115724 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 250x Octavia St | 1 | Side Yard : Yard | Tree | Dept of Real Estate 7 | |||||||||||||||
6530 | 20001 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 STAIRWAY46 | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2 | |||||||||||||
7827 | 115725 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 250X Octavia St | 2 | Side Yard : Yard | Tree | Dept of Real Estate 7 | |||||||||||||||
15870 | 19880 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 STAIRWAY33 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
8030 | 136599 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2298 Beach St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5999338.92824 | 2120854.31751 | 37.8034221414854 | -122.44651158266 | (37.8034221414854, -122.44651158266) | 13 | 9 | 1 | 57 | 17 | |||
10501 | 136602 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3698 Beach St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 6002136.39741 | 2121144.63129 | 37.8043786541109 | -122.436851639901 | (37.8043786541109, -122.436851639901) | 13 | 9 | 1 | 57 | 17 | |||
26649 | 136624 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1120 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6006955.61886 | 2120188.67307 | 37.8020265537335 | -122.42010639829 | (37.8020265537335, -122.42010639829) | 5 | 1 | 1 | 28858 | 32 | |||
32487 | 136610 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3798 Webster St | 7 | Side Yard : Yard | Tree | Private 2 | 15 | Width 4ft | 6002559.08771 | 2121673.9848 | 37.8058561332109 | -122.43542677652 | (37.8058561332109, -122.43542677652) | 13 | 9 | 1 | 57 | 17 | |||
32797 | 136609 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3798 Webster St | 6 | Side Yard : Yard | Tree | Private 2 | 7 | Width 4ft | 6002557.10875 | 2121672.73918 | 37.8058526006778 | -122.435433535844 | (37.8058526006778, -122.435433535844) | 13 | 9 | 1 | 57 | 17 | |||
33418 | 138663 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1722 LYON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5999590.4442 | 2114811.9884 | 37.7868458713434 | -122.44520652592 | (37.7868458713434, -122.44520652592) | 15 | 6 | 1 | 29490 | 31 | |||
44306 | 136626 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1120 Lombard St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6006933.58689 | 2120186.44007 | 37.8020191811091 | -122.420182480954 | (37.8020191811091, -122.420182480954) | 5 | 1 | 1 | 28858 | 32 | |||
49651 | 136601 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1900 Jefferson St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6000030.07826 | 2121297.63981 | 37.8046788379311 | -122.444151713048 | (37.8046788379311, -122.444151713048) | 13 | 9 | 1 | 57 | 17 | |||
52219 | 136618 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1075 Francisco St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 6006192.10858 | 2120703.43748 | 37.8033969172965 | -122.422785114443 | (37.8033969172965, -122.422785114443) | 5 | 9 | 1 | 28858 | 32 | |||
55198 | 136607 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3798 Webster St | 4 | Side Yard : Yard | Tree | Private 2 | 11 | Width 5ft | 6002552.02607 | 2121667.51893 | 37.8058379785924 | -122.435450751546 | (37.8058379785924, -122.435450751546) | 13 | 9 | 1 | 57 | 17 | |||
64047 | 136628 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 35 Havens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6007442.68945 | 2119347.67651 | 37.7997448199195 | -122.418361234195 | (37.7997448199195, -122.418361234195) | 5 | 1 | 1 | 28858 | 32 | |||
64480 | 136608 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3798 Webster St | 5 | Side Yard : Yard | Tree | Private 2 | 14 | Width 4ft | 6002554.72948 | 2121670.19367 | 37.8058454762555 | -122.435441587454 | (37.8058454762555, -122.435441587454) | 13 | 9 | 1 | 57 | 17 | |||
79343 | 136600 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2298 Beach St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5999337.17722 | 2120854.21997 | 37.8034217736525 | -122.44651763509 | (37.8034217736525, -122.44651763509) | 13 | 9 | 1 | 57 | 17 | |||
80003 | 136587 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2900 Steiner St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 1ft | 6002061.91311 | 2118175.42459 | 37.7962217590896 | -122.436896706732 | (37.7962217590896, -122.436896706732) | 13 | 9 | 1 | 57 | 17 | |||
80605 | 99830 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398@Steiner Broadway | 1 | Front Yard : Cutout | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
83662 | 136620 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2415 Larkin St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 6006670.95016 | 2119505.50719 | 37.800134710195 | -122.421042954093 | (37.800134710195, -122.421042954093) | 13 | 9 | 1 | 28858 | 32 | |||
87445 | 136625 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1120 Lombard St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6006949.37366 | 2120187.56184 | 37.8020231507021 | -122.420127930783 | (37.8020231507021, -122.420127930783) | 5 | 1 | 1 | 28858 | 32 | |||
91005 | 136619 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2415 Larkin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 1ft | 6006670.13205 | 2119511.58433 | 37.8001513503665 | -122.42104621681 | (37.8001513503665, -122.42104621681) | 5 | 9 | 1 | 28858 | 32 | |||
96094 | 136623 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2415 Larkin St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 6006672.19437 | 2119490.54976 | 37.8000937110129 | -122.42103758603 | (37.8000937110129, -122.42103758603) | 13 | 9 | 1 | 28858 | 32 | |||
99458 | 136594 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3751 Broderick St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5999588.78948 | 2121434.95784 | 37.8050306913842 | -122.445688711975 | (37.8050306913842, -122.445688711975) | 13 | 9 | 1 | 57 | 17 | |||
100759 | 99832 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398@Steiner Broadway | 3 | Front Yard : Cutout | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
108058 | 136604 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3798 Webster St | 1 | Side Yard : Yard | Tree | Private 2 | 2 | Width 2ft | 6002548.10466 | 2121650.0452 | 37.8057897776435 | -122.435463071378 | (37.8057897776435, -122.435463071378) | 13 | 9 | 1 | 57 | 17 | |||
109269 | 136597 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3801 Divisadero St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000090.23448 | 2121338.29249 | 37.8047938908823 | -122.443946459857 | (37.8047938908823, -122.443946459857) | 13 | 9 | 1 | 57 | 17 | |||
110001 | 136611 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1630 Bay St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 1ft | 6002977.37772 | 2120668.13454 | 37.8031180797974 | -122.433907279317 | (37.8031180797974, -122.433907279317) | 13 | 9 | 1 | 57 | 17 | |||
110254 | 138682 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1825 SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6001513.5804 | 2114720.8868 | 37.7867053138938 | -122.438546405155 | (37.7867053138938, -122.438546405155) | 13 | 6 | 1 | 29490 | 27 | |||
110633 | 136585 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2900 Steiner St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 1ft | 6002071.0497 | 2118131.41015 | 37.7961014261857 | -122.436861939849 | (37.7961014261857, -122.436861939849) | 13 | 9 | 1 | 57 | 17 | |||
112921 | 136593 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3751 Broderick St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5999588.18576 | 2121438.86805 | 37.8050413932949 | -122.445691082582 | (37.8050413932949, -122.445691082582) | 13 | 9 | 1 | 57 | 17 | |||
117577 | 136630 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1101 Greenwich St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6007480.48999 | 2119873.18384 | 37.8011898586792 | -122.418267709195 | (37.8011898586792, -122.418267709195) | 5 | 1 | 1 | 28858 | 32 | ||||
124036 | 136589 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3160 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5999030.62414 | 2119679.22674 | 37.8001780449472 | -122.447493842871 | (37.8001780449472, -122.447493842871) | 13 | 9 | 1 | 57 | 17 | |||
124794 | 136586 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2900 Steiner St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 1ft | 6002062.37894 | 2118168.81121 | 37.7962036269473 | -122.436894621186 | (37.7962036269473, -122.436894621186) | 13 | 9 | 1 | 57 | 17 | |||
127383 | 136622 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2415 Larkin St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 1ft | 6006671.5897 | 2119494.68123 | 37.8001050208988 | -122.421039971933 | (37.8001050208988, -122.421039971933) | 13 | 9 | 1 | 28858 | 32 | |||
131594 | 136598 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2298 Beach St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 6ft | 5999341.14558 | 2120854.69423 | 37.803423302506 | -122.446503936615 | (37.803423302506, -122.446503936615) | 13 | 9 | 1 | 57 | 17 | |||
138141 | 136590 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3160 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5999027.50225 | 2119697.94121 | 37.8002292514403 | -122.447505993613 | (37.8002292514403, -122.447505993613) | 13 | 9 | 1 | 57 | 17 | |||
144169 | 136605 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3798 Webster St | 2 | Side Yard : Yard | Tree | Private 2 | 10 | Width 4ft | 6002548.49635 | 2121661.6698 | 37.8058217179646 | -122.435462547977 | (37.8058217179646, -122.435462547977) | 13 | 9 | 1 | 57 | 17 | |||
147991 | 136606 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3798 Webster St | 3 | Side Yard : Yard | Tree | Private 2 | 8 | Width 5ft | 6002550.09467 | 2121664.33857 | 37.8058291364749 | -122.435457207788 | (37.8058291364749, -122.435457207788) | 13 | 9 | 1 | 57 | 17 | |||
150680 | 136629 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 35 Havens St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6007448.32601 | 2119348.57827 | 37.7997476132167 | -122.418341793545 | (37.7997476132167, -122.418341793545) | 5 | 1 | 1 | 28858 | 32 | |||
154180 | 136596 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3801 Divisadero St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6000089.42959 | 2121343.88156 | 37.8048091910506 | -122.443949647073 | (37.8048091910506, -122.443949647073) | 13 | 9 | 1 | 57 | 17 | |||
157089 | 136591 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2601 Francisco St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 5999048.72994 | 2119707.60778 | 37.800257006315 | -122.447433233964 | (37.800257006315, -122.447433233964) | 13 | 9 | 1 | 57 | 17 | |||
159946 | 136603 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1490 Jefferson St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6002078.64435 | 2121585.74714 | 37.8055865587436 | -122.437083100219 | (37.8055865587436, -122.437083100219) | 13 | 9 | 1 | 57 | 17 | |||
170614 | 136627 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1120 Lombard St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6006926.93981 | 2120185.95678 | 37.8020174795836 | -122.420205448732 | (37.8020174795836, -122.420205448732) | 5 | 1 | 1 | 28858 | 32 | |||
172489 | 136588 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3130 Lyon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5999060.51104 | 2119533.48952 | 37.7997795976177 | -122.447379927554 | (37.7997795976177, -122.447379927554) | 13 | 9 | 1 | 57 | 17 | |||
173993 | 136595 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3801 Divisadero St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6000087.86823 | 2121359.44111 | 37.804851824321 | -122.443956168945 | (37.804851824321, -122.443956168945) | 13 | 9 | 1 | 57 | 17 | |||
174836 | 136617 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1075 Francisco St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6006167.26583 | 2120699.80075 | 37.8033855300671 | -122.422870825248 | (37.8033855300671, -122.422870825248) | 5 | 9 | 1 | 28858 | 32 | |||
178919 | 136592 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 3751 Broderick St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5999587.94478 | 2121442.35116 | 37.8050509432145 | -122.445692167157 | (37.8050509432145, -122.445692167157) | 13 | 9 | 1 | 57 | 17 | |||
179996 | 58736 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 222 Cherry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1979 12:00:00 AM | 13 | Permit Number 17973 | 5996179.66894 | 2115408.17618 | 37.7882875667675 | -122.45705008391 | (37.7882875667675, -122.45705008391) | 11 | 6 | 1 | 54 | 31 | ||
184201 | 99827 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398 Broadway | 1 | Front Yard : Yard | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
187077 | 99831 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398@Steiner Broadway | 2 | Front Yard : Cutout | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
187375 | 136621 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2415 Larkin St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 1ft | 6006671.45973 | 2119496.74342 | 37.8001106758244 | -122.421040568183 | (37.8001106758244, -122.421040568183) | 13 | 9 | 1 | 28858 | 32 | |||
4139 | 143087 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 480 FILBERT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010585.232 | 2119982.0381 | 37.8016630194804 | -122.407531575883 | (37.8016630194804, -122.407531575883) | 3 | 1 | 10 | 308 | 23 | |||
10511 | 142965 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 111 Pfeiffer St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6010321.3688 | 2121130.7743 | 37.8048023922739 | -122.408525746416 | (37.8048023922739, -122.408525746416) | 3 | 1 | 10 | 308 | 23 | |||
25387 | 249848 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 289 Greenwich St | 2 | Side Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6011433.333 | 2120390.12785 | 37.8028309694274 | -122.404625486584 | (37.8028309694274, -122.404625486584) | 3 | 1 | 10 | 308 | 23 | |||
25750 | 253293 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 840x Sacramento St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6010611 | 2116923 | 37.7932650877933 | -122.407226643637 | (37.7932650877933, -122.407226643637) | 3 | 1 | 10 | 28857 | 4 | |||||
27104 | 136613 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1163 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008339.99161 | 2115873.76917 | 37.7902567978586 | -122.415010210055 | (37.7902567978586, -122.415010210055) | 5 | 1 | 10 | 28858 | 21 | |||
28381 | 136612 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1697 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006706.3991 | 2116349.10339 | 37.7914700147761 | -122.420696089151 | (37.7914700147761, -122.420696089151) | 13 | 9 | 10 | 28858 | 21 | |||
41381 | 142963 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 119 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6010263.5377 | 2121122.3795 | 37.8047761033373 | -122.408725285275 | (37.8047761033373, -122.408725285275) | 3 | 1 | 10 | 308 | 23 | |||
62698 | 249782 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 115 Pfeiffer St | 1 | Back Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6010481.39254 | 2121146.06325 | 37.8048533324903 | -122.407973043817 | (37.8048533324903, -122.407973043817) | 3 | 1 | 10 | 308 | 23 | |||
85746 | 253294 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 840x Sacramento St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6010611 | 2116923 | 37.7932650877933 | -122.407226643637 | (37.7932650877933, -122.407226643637) | 3 | 1 | 10 | 28857 | 4 | |||||
88216 | 136632 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 745 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010322.48557 | 2116149.01885 | 37.7911237712979 | -122.408170315501 | (37.7911237712979, -122.408170315501) | 5 | 1 | 10 | 28857 | 21 | |||
115328 | 136616 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1200 Jackson St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6008322.00574 | 2117598.96331 | 37.7949927464615 | -122.415194612455 | (37.7949927464615, -122.415194612455) | 5 | 1 | 10 | 28858 | 21 | |||
131204 | 121327 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 405 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6010952.0953 | 2119641.7196 | 37.8007491161502 | -122.406238063211 | (37.8007491161502, -122.406238063211) | 3 | 1 | 10 | 308 | 23 | |||
142419 | 142964 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 115 Pfeiffer St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6010284.5248 | 2121125.6441 | 37.8047862425651 | -122.408652887366 | (37.8047862425651, -122.408652887366) | 3 | 1 | 10 | 308 | 23 | |||
143066 | 142968 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 123 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6010234.1558 | 2121117.7157 | 37.8047616520024 | -122.408826635586 | (37.8047616520024, -122.408826635586) | 3 | 1 | 10 | 308 | 23 | |||
155379 | 136614 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1146 Leavenworth St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6008130.23973 | 2116469.59662 | 37.7918810049628 | -122.415778145656 | (37.7918810049628, -122.415778145656) | 5 | 1 | 10 | 28858 | 21 | |||
155877 | 39869 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1305 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | 3 | Permit Number 41169 | 6011434.7217 | 2119842.62284 | 37.8013277319434 | -122.404582116778 | (37.8013277319434, -122.404582116778) | 3 | 1 | 10 | 308 | 23 | |
171117 | 136631 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 745 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6010305.76726 | 2116145.08386 | 37.7911120306413 | -122.408227882917 | (37.7911120306413, -122.408227882917) | 5 | 1 | 10 | 28857 | 21 | |||
184966 | 136615 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1152 Leavenworth St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6008127.50267 | 2116494.06688 | 37.7919480404173 | -122.415789349395 | (37.7919480404173, -122.415789349395) | 5 | 1 | 10 | 28858 | 21 | |||
189350 | 249783 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 115 Pfeiffer St | 2 | Back Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6010478.38783 | 2121144.55662 | 37.8048490274321 | -122.407983335672 | (37.8048490274321, -122.407983335672) | 3 | 1 | 10 | 308 | 23 | |||
22724 | 138531 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1660 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6001633.4592 | 2114193.0647 | 37.7852628681266 | -122.438093830321 | (37.7852628681266, -122.438093830321) | 13 | 6 | 11 | 29490 | 13 | |||
87193 | 241016 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 42 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5998455.64477 | 2106908.99141 | 37.7650814399822 | -122.448563264508 | (37.7650814399822, -122.448563264508) | 15 | 5 | 11 | 29492 | 9 | |||
87703 | 245196 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 141 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001304.6046 | 2109213.22 | 37.7715707670273 | -122.438874572714 | (37.7715707670273, -122.438874572714) | 15 | 5 | 11 | 29492 | 9 | |||
120579 | 138530 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1650 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6001636.2077 | 2114181.5211 | 37.7852313286636 | -122.438083494179 | (37.7852313286636, -122.438083494179) | 13 | 6 | 11 | 29490 | 13 | |||
128428 | 241018 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1312 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997804.09627 | 2106075.19943 | 37.7627547823317 | -122.45075667768 | (37.7627547823317, -122.45075667768) | 15 | 5 | 11 | 29492 | 9 | |||
165620 | 139522 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 715 CENTRAL AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999600.0854 | 2110958.1291 | 37.7762647192657 | -122.444896033282 | (37.7762647192657, -122.444896033282) | 15 | 5 | 11 | 29492 | 16 | |||
169373 | 241017 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 833 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5999113.42542 | 2107452.79441 | 37.7666121751429 | -122.446327294483 | (37.7666121751429, -122.446327294483) | 15 | 5 | 11 | 29492 | 9 | |||
7239 | 117920 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 727 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5983191.607 | 2110832.41366 | 37.7749694365706 | -122.501647249063 | (37.7749694365706, -122.501647249063) | 11 | 6 | 2 | 55 | 26 | |||
22855 | 122252 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1600 Clement St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5990423.37327 | 2113418.93453 | 37.7824934165268 | -122.476820305635 | (37.7824934165268, -122.476820305635) | 11 | 6 | 2 | 55 | 26 | |||
31668 | 123333 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 737 04th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5994714.05712 | 2110527.69086 | 37.7748027900674 | -122.461766808811 | (37.7748027900674, -122.461766808811) | 11 | 6 | 2 | 54 | 11 | |||
40395 | 122250 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1600 Clement St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5990504.56786 | 2113419.1912 | 37.7824988308057 | -122.476539429393 | (37.7824988308057, -122.476539429393) | 11 | 6 | 2 | 55 | 26 | |||
50773 | 119519 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 774 31st Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5986356.00779 | 2110632.67523 | 37.7746063664364 | -122.490686358973 | (37.7746063664364, -122.490686358973) | 11 | 6 | 2 | 55 | 26 | |||
62986 | 141667 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 EWING TER | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998723.4884 | 2112384.3231 | 37.7801306125765 | -122.448031120952 | (37.7801306125765, -122.448031120952) | 15 | 6 | 2 | 54 | 16 | |||
64370 | 122249 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1600 Clement St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5990532.83595 | 2113421.55221 | 37.7825069529614 | -122.476441807648 | (37.7825069529614, -122.476441807648) | 11 | 6 | 2 | 55 | 26 | |||
76109 | 120010 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 758 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5986965.57983 | 2110744.12081 | 37.7749479533293 | -122.488585949642 | (37.7749479533293, -122.488585949642) | 11 | 6 | 2 | 55 | 26 | |||
85082 | 141561 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 8 Loyola Ter | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5998458.6357 | 2110769.1871 | 37.7756807239054 | -122.448830991825 | (37.7756807239054, -122.448830991825) | 15 | 6 | 2 | 29492 | 16 | |||
90095 | 120001 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 773 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5986923.31758 | 2110672.03772 | 37.7747475672882 | -122.488726842297 | (37.7747475672882, -122.488726842297) | 11 | 6 | 2 | 55 | 26 | |||
100576 | 141559 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 4 Loyola Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998461.482 | 2110754.0065 | 37.7756392046576 | -122.448820052115 | (37.7756392046576, -122.448820052115) | 15 | 6 | 2 | 29492 | 16 | |||
111968 | 120218 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 366 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5988110.64493 | 2113522.23122 | 37.7826426136883 | -122.484828820519 | (37.7826426136883, -122.484828820519) | 11 | 6 | 2 | 55 | 26 | |||
113066 | 60783 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 Ewing Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1983 12:00:00 AM | 5 | Permit Number 20453 | 5998776.2822 | 2112393.1221 | 37.7801577900357 | -122.447849117584 | (37.7801577900357, -122.447849117584) | 15 | 6 | 2 | 54 | 16 | |
133506 | 119520 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 774 31st Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5986359.0703 | 2110632.17303 | 37.7746051664305 | -122.490675728333 | (37.7746051664305, -122.490675728333) | 11 | 6 | 2 | 55 | 26 | |||
144426 | 103548 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 551 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5989061.72146 | 2111564.53658 | 37.7773226790144 | -122.481395127114 | (37.7773226790144, -122.481395127114) | 11 | 6 | 2 | 55 | 26 | |||
150970 | 141666 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 100 EWING TER | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998741.7631 | 2112389.0611 | 37.7801446665071 | -122.447968241937 | (37.7801446665071, -122.447968241937) | 15 | 6 | 2 | 54 | 16 | |||
155477 | 141560 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 6 Loyola Ter | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998459.5845 | 2110762.5456 | 37.7756625423159 | -122.448827231212 | (37.7756625423159, -122.448827231212) | 15 | 6 | 2 | 29492 | 16 | |||
173403 | 59077 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1116 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1987 12:00:00 AM | 6 | Permit Number 24969 | 5992117.03655 | 2111383.31137 | 37.7770022506148 | -122.470812695486 | (37.7770022506148, -122.470812695486) | 11 | 6 | 2 | 54 | 11 | |
180212 | 141562 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 8 Loyola Ter | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5998458.1613 | 2110776.3029 | 37.7757002349295 | -122.448833145551 | (37.7757002349295, -122.448833145551) | 15 | 6 | 2 | 29492 | 16 | |||
185638 | 119518 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 774 31st Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5986356.81834 | 2110650.14553 | 37.7746543822833 | -122.490684840834 | (37.7746543822833, -122.490684840834) | 11 | 6 | 2 | 55 | 26 | |||
194141 | 141558 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2 Loyola Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5998461.482 | 2110747.8394 | 37.77562227139 | -122.448819607803 | (37.77562227139, -122.448819607803) | 15 | 6 | 2 | 29492 | 16 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );