trees
494 rows where qSpecies_id = 243 sorted by Zip Codes
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 | |||||||||||||
| 39423 | 197875 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1022 Harrison St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 0ft | 6011232.56794 | 2110864.16266 | 37.7766637150973 | -122.40464924399 | (37.7766637150973, -122.40464924399) | 14 | 2 | 9 | 28853 | 34 | |||
| 87023 | 246330 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1735 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6006778.1145 | 2108370.5185 | 37.7695667985634 | -122.419881546362 | (37.7695667985634, -122.419881546362) | 8 | 4 | 7 | 28853 | 19 | |||
| 88858 | 197876 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1022 Harrison St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 0ft | 6011218.09567 | 2110851.71403 | 37.7766287251786 | -122.404698431509 | (37.7766287251786, -122.404698431509) | 14 | 2 | 9 | 28853 | 34 | |||
| 89478 | 241012 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1340 Bryant St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 6009364.22558 | 2107957.61703 | 37.7685784204757 | -122.410907081104 | (37.7685784204757, -122.410907081104) | 8 | 4 | 7 | 28853 | 19 | |||
| 117280 | 241015 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 211 13th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6006837.66171 | 2108488.60883 | 37.7698944011251 | -122.419683954356 | (37.7698944011251, -122.419683954356) | 8 | 4 | 7 | 28853 | 19 | |||
| 118338 | 241013 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1340 Bryant St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6009364.37303 | 2107955.02129 | 37.7685713014421 | -122.410906387729 | (37.7685713014421, -122.410906387729) | 8 | 4 | 7 | 28853 | 19 | |||
| 144903 | 241014 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1340 Bryant St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6009365.12145 | 2107942.64044 | 37.7685373484578 | -122.410902924446 | (37.7685373484578, -122.410902924446) | 8 | 4 | 7 | 28853 | 19 | |||
| 146904 | 15337 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1727 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006899.73269 | 2108343.28494 | 37.7694988724824 | -122.419458940293 | (37.7694988724824, -122.419458940293) | 8 | 4 | 7 | 28853 | 19 | |||
| 41499 | 197887 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1493 Kansas St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 6ft | 6011776.63804 | 2101418.39447 | 37.7507581436897 | -122.402102910747 | (37.7507581436897, -122.402102910747) | 10 | 3 | 8 | 28856 | 29 | |||
| 44245 | 110874 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 800 INDIANA ST | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
| 51547 | 197881 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 9 | Median : Yard | Tree | DPW 1 | 11 | Width 7ft | 6015646.32257 | 2101941.32655 | 37.7524092333136 | -122.388757586711 | (37.7524092333136, -122.388757586711) | 10 | 3 | 8 | 28856 | 1 | |||
| 52884 | 197877 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 14 | Median : Yard | Tree | DPW 1 | 10 | Width 7ft | 6015625.5144 | 2101938.71923 | 37.7524009208729 | -122.388829363409 | (37.7524009208729, -122.388829363409) | 10 | 3 | 8 | 28856 | 1 | |||
| 56675 | 197879 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 12 | Median : Yard | Tree | DPW 1 | 10 | Width 7ft | 6015633.71658 | 2101939.60961 | 37.7524038202784 | -122.388801060829 | (37.7524038202784, -122.388801060829) | 10 | 3 | 8 | 28856 | 1 | |||
| 59176 | 197884 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 3 | Median : Yard | Tree | DPW 1 | 3 | Width 7ft | 6015678.84769 | 2101942.94964 | 37.7524154925876 | -122.388645221797 | (37.7524154925876, -122.388645221797) | 10 | 3 | 8 | 28856 | 1 | |||
| 65096 | 197886 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 1 | Median : Yard | Tree | DPW 1 | 9 | Width 7ft | 6015689.86816 | 2101943.47037 | 37.7524175331559 | -122.388607147206 | (37.7524175331559, -122.388607147206) | 10 | 3 | 8 | 28856 | 1 | |||
| 65999 | 110868 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 800 INDIANA ST | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
| 67831 | 197880 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 10 | Median : Yard | Tree | DPW 1 | 3 | Width 7ft | 6015641.85781 | 2101940.61128 | 37.752407021878 | -122.388772976792 | (37.752407021878, -122.388772976792) | 10 | 3 | 8 | 28856 | 1 | |||
| 99283 | 110872 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 800 INDIANA ST | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
| 152953 | 197878 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 13 | Median : Yard | Tree | DPW 1 | 10 | Width 7ft | 6015630.33926 | 2101939.54612 | 37.7524034587597 | -122.388812735827 | (37.7524034587597, -122.388812735827) | 10 | 3 | 8 | 28856 | 1 | |||
| 157902 | 197882 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 8 | Median : Yard | Tree | DPW 1 | 9 | Width 7ft | 6015650.38756 | 2101941.3683 | 37.7524095732464 | -122.388743532098 | (37.7524095732464, -122.388743532098) | 10 | 3 | 8 | 28856 | 1 | |||
| 180820 | 197883 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 4 | Median : Yard | Tree | DPW 1 | 7 | Width 7ft | 6015671.68668 | 2101942.82757 | 37.7524147605401 | -122.388669977447 | (37.7524147605401, -122.388669977447) | 10 | 3 | 8 | 28856 | 1 | |||
| 181192 | 110873 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 800 INDIANA ST | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
| 192762 | 197885 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1498x Tennessee St | 2 | Median : Yard | Tree | DPW 1 | 7 | Width 7ft | 6015684.08537 | 2101943.48621 | 37.7524172561691 | -122.388627146329 | (37.7524172561691, -122.388627146329) | 10 | 3 | 8 | 28856 | 1 | |||
| 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 | |||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 12365 | 261369 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 48 Bache St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007159 | 2095436 | 37.7340730065148 | -122.41764717788 | (37.7340730065148, -122.41764717788) | 2 | 7 | 7 | 28859 | 2 | ||||
| 25328 | 241047 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 156 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005501.90776 | 2099064.47249 | 37.7439425892855 | -122.423634161688 | (37.7439425892855, -122.423634161688) | 2 | 7 | 5 | 28859 | 22 | |||
| 33409 | 241044 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 300 Virginia Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6006926.17772 | 2098328.2002 | 37.7420012434536 | -122.418657149801 | (37.7420012434536, -122.418657149801) | 2 | 7 | 7 | 28859 | 2 | |||
| 38456 | 241046 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2868 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6009024.96675 | 2103353.45753 | 37.7559174229641 | -122.411755183159 | (37.7559174229641, -122.411755183159) | 2 | 4 | 7 | 28859 | 19 | |||
| 57970 | 241020 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 305 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 2ft | 6008973.83234 | 2096817.19459 | 37.7379674243488 | -122.411470260845 | (37.7379674243488, -122.411470260845) | 10 | 7 | 7 | 28859 | 2 | |||
| 112482 | 15466 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2458 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6006917.684 | 2104048.5382 | 37.7577075136236 | -122.419092174143 | (37.7577075136236, -122.419092174143) | 2 | 4 | 7 | 28859 | 19 | |||
| 116217 | 241043 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 300 Virginia Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 6006909.48713 | 2098350.81017 | 37.7420623856656 | -122.418716463718 | (37.7420623856656, -122.418716463718) | 2 | 7 | 7 | 28859 | 2 | |||
| 141013 | 24296 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 320 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 6006596.85891 | 2097923.1306 | 37.7408704664957 | -122.419767095772 | (37.7408704664957, -122.419767095772) | 2 | 7 | 7 | 28859 | 2 | |||
| 143798 | 241021 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 81 Nebraska St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6009293.69668 | 2097607.83749 | 37.7401562941659 | -122.410420139577 | (37.7401562941659, -122.410420139577) | 10 | 7 | 7 | 28859 | 2 | |||
| 154014 | 107677 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 305 NEVADA ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 3x12 | 6008988.2 | 2096819.7 | 37.7379751095359 | -122.411420761527 | (37.7379751095359, -122.411420761527) | 10 | 7 | 7 | 28859 | 2 | |||
| 158790 | 15469 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2460 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x2 | 6006920.5729 | 2104029.0381 | 37.7576541335378 | -122.419080799991 | (37.7576541335378, -122.419080799991) | 2 | 4 | 7 | 28859 | 19 | |||
| 180252 | 241019 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 305 Nevada St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 2ft | 6008974.79401 | 2096823.76777 | 37.7379855268132 | -122.411467400123 | (37.7379855268132, -122.411467400123) | 10 | 7 | 7 | 28859 | 2 | |||
| 184182 | 241045 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 313 Virginia Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 6006931.5072 | 2098259.45718 | 37.7418127905307 | -122.418633848399 | (37.7418127905307, -122.418633848399) | 2 | 7 | 7 | 28859 | 2 | |||
| 5366 | 179679 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 498x San Juan Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6000569.78695 | 2092772.13999 | 37.7263856753507 | -122.44023711527 | (37.7263856753507, -122.44023711527) | 9 | 7 | 6 | 28861 | 25 | |||
| 6959 | 179678 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 498x San Juan Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6000584.20911 | 2092761.60072 | 37.7263575580392 | -122.440186503209 | (37.7263575580392, -122.440186503209) | 9 | 7 | 6 | 28861 | 25 | |||
| 10806 | 179754 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6004870.43826 | 2094360.42789 | 37.730990679074 | -122.42548293491 | (37.730990679074, -122.42548293491) | 9 | 7 | 6 | 28861 | 5 | |||
| 12366 | 179680 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 498x San Juan Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6000544.18408 | 2092789.85376 | 37.726432855581 | -122.440326892784 | (37.726432855581, -122.440326892784) | 9 | 7 | 6 | 28861 | 25 | |||
| 13186 | 215278 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 179 Staples Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5998891.37241 | 2093762.83604 | 37.7290101929567 | -122.446110523694 | (37.7290101929567, -122.446110523694) | 9 | 7 | 4 | 28861 | 40 | |||
| 19097 | 179681 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 498x San Juan Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6000538.34703 | 2092794.14032 | 37.7264442931449 | -122.44034737844 | (37.7264442931449, -122.44034737844) | 9 | 7 | 6 | 28861 | 25 | |||
| 19691 | 215239 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 490 Faxon Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5994798.71482 | 2091830.48976 | 37.7234698691262 | -122.46011911753 | (37.7234698691262, -122.46011911753) | 9 | 8 | 4 | 28861 | 24 | |||
| 22938 | 179742 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6004901.02549 | 2094358.92727 | 37.7309882868812 | -122.425377082885 | (37.7309882868812, -122.425377082885) | 9 | 7 | 6 | 28861 | 5 | |||
| 23365 | 179763 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 6004845.97197 | 2094361.80258 | 37.7309930712551 | -122.425567616849 | (37.7309930712551, -122.425567616849) | 9 | 7 | 6 | 28861 | 5 | |||
| 24220 | 179638 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 286 Foote Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 5998314.38547 | 2088719.36109 | 37.7151290150634 | -122.447742271601 | (37.7151290150634, -122.447742271601) | 9 | 7 | 6 | 28861 | 25 | |||
| 25752 | 179781 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 62 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 6004781.59903 | 2094368.78968 | 37.7310086187399 | -122.425790662224 | (37.7310086187399, -122.425790662224) | 9 | 7 | 6 | 28861 | 5 | |||
| 26471 | 179720 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 4ft | 6004978.66043 | 2094360.05268 | 37.730995762948 | -122.42510876568 | (37.730995762948, -122.42510876568) | 9 | 7 | 6 | 28861 | 5 | |||
| 28433 | 179761 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6004848.16693 | 2094362.1927 | 37.7309942664614 | -122.425560056251 | (37.7309942664614, -122.425560056251) | 9 | 7 | 6 | 28861 | 5 | |||
| 31347 | 215281 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 262 Judson Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998329.72097 | 2093571.17707 | 37.7284518524518 | -122.448038393164 | (37.7284518524518, -122.448038393164) | 9 | 7 | 4 | 28861 | 40 | ||||
| 31458 | 179784 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 65 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6004770.67322 | 2094369.23235 | 37.7310092167841 | -122.425828466117 | (37.7310092167841, -122.425828466117) | 9 | 7 | 6 | 28861 | 5 | ||||
| 31815 | 179630 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 290 Foote Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5998313.80825 | 2088717.96768 | 37.7151251560878 | -122.447744166462 | (37.7151251560878, -122.447744166462) | 9 | 7 | 6 | 28861 | 25 | |||
| 32092 | 179650 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 567 Lisbon St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 6001888.79555 | 2090193.80134 | 37.719381146405 | -122.435493004403 | (37.719381146405, -122.435493004403) | 9 | 7 | 6 | 28861 | 5 | |||
| 32605 | 179683 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 443 Peru Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6004745.82241 | 2092849.57746 | 37.7268351771866 | -122.425806252864 | (37.7268351771866, -122.425806252864) | 9 | 7 | 6 | 28861 | 5 | |||
| 34112 | 179641 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1101 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6000468.15764 | 2090746.71388 | 37.72081853103 | -122.440443242589 | (37.72081853103, -122.440443242589) | 9 | 7 | 6 | 28861 | 25 | |||
| 35860 | 179747 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6004888.75202 | 2094357.65549 | 37.7309841014177 | -122.425419423893 | (37.7309841014177, -122.425419423893) | 9 | 7 | 6 | 28861 | 5 | |||
| 36253 | 16409 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1186X Munich St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | TR | 6001094.97043 | 2087182.82135 | 37.7110685499383 | -122.438021394384 | (37.7110685499383, -122.438021394384) | 9 | 7 | 6 | 28861 | 5 | |||
| 36453 | 179748 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6004886.15105 | 2094358.79772 | 37.730987090773 | -122.425428497145 | (37.730987090773, -122.425428497145) | 9 | 7 | 6 | 28861 | 5 | |||
| 41481 | 179741 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6004901.63647 | 2094356.73695 | 37.7309823072691 | -122.425374814811 | (37.7309823072691, -122.425374814811) | 9 | 7 | 6 | 28861 | 5 | |||
| 42214 | 114819 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 1 | Median : Cutout | Tree | DPW 1 | 8 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | |||
| 44118 | 179637 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 120 Farragut Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5997385.09042 | 2087337.68892 | 37.7112821038472 | -122.450854733483 | (37.7112821038472, -122.450854733483) | 9 | 7 | 6 | 28861 | 25 | |||
| 44787 | 179729 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6004942.13253 | 2094358.51707 | 37.7309894829579 | -122.425234939651 | (37.7309894829579, -122.425234939651) | 9 | 7 | 6 | 28861 | 5 | |||
| 44987 | 179658 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 579 Madrid St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6002445.72289 | 2090555.63899 | 37.7204062871908 | -122.433593761257 | (37.7204062871908, -122.433593761257) | 9 | 7 | 6 | 28861 | 5 | |||
| 45753 | 179777 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 58 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6004790.57095 | 2094369.04032 | 37.731009813945 | -122.425759662593 | (37.731009813945, -122.425759662593) | 9 | 7 | 6 | 28861 | 5 | |||
| 45972 | 215224 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 400x Miramar Ave | 5 | Median : Yard | Tree | DPW 1 | 29 | 5995369.41897 | 2092571.16571 | 37.7255363969609 | -122.458199891431 | (37.7255363969609, -122.458199891431) | 9 | 7 | 4 | 28861 | 40 | ||||
| 48412 | 179688 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 376 Trumbull St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6005640.73705 | 2094230.00919 | 37.7306760710471 | -122.422810613826 | (37.7306760710471, -122.422810613826) | 9 | 7 | 6 | 28861 | 5 | |||
| 48868 | 179640 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1101 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6000461.77381 | 2090733.06087 | 37.7207806794643 | -122.440464330785 | (37.7207806794643, -122.440464330785) | 9 | 7 | 6 | 28861 | 25 | |||
| 49407 | 179631 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 184 Mount Vernon Ave | 11 | Side Yard : Yard | Tree | Private 2 | 10 | 5998932.98787 | 2089405.36091 | 37.7170479506817 | -122.445653426162 | (37.7170479506817, -122.445653426162) | 9 | 7 | 6 | 28861 | 25 | ||||
| 50822 | 179642 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 2 Valerton Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6001010.15104 | 2091331.02147 | 37.7224537539105 | -122.438611586159 | (37.7224537539105, -122.438611586159) | 9 | 7 | 6 | 28861 | 25 | |||
| 51201 | 179728 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 4ft | 6004946.07219 | 2094358.65382 | 37.7309900810101 | -122.4252213293 | (37.7309900810101, -122.4252213293) | 9 | 7 | 6 | 28861 | 5 | |||
| 51759 | 114834 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 16 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 52812 | 179687 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 376 Trumbull St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 3ft | 6005637.05769 | 2094231.72899 | 37.7306805856367 | -122.422823456132 | (37.7306805856367, -122.422823456132) | 9 | 7 | 6 | 28861 | 5 |
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) );