trees
494 rows where qSpecies_id = 243 sorted by Longitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 34829 | 179692 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 425 Pioche St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6005640.05215 | 2093208.69537 | 37.7278717294828 | -122.422740428923 | (37.7278717294828, -122.422740428923) | 9 | 7 | 7 | 309 | 5 | |||
| 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 | |||
| 157590 | 179690 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 376 Trumbull St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6005647.7504 | 2094229.86507 | 37.7306760710376 | -122.422786357328 | (37.7306760710376, -122.422786357328) | 9 | 7 | 6 | 28861 | 5 | |||
| 84945 | 179689 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 376 Trumbull St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6005644.40282 | 2094230.12153 | 37.7306765863412 | -122.42279794866 | (37.7306765863412, -122.42279794866) | 9 | 7 | 6 | 28861 | 5 | |||
| 184718 | 179691 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 425 Pioche St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 6005621.06817 | 2093204.80728 | 37.7278599825272 | -122.422805780863 | (37.7278599825272, -122.422805780863) | 9 | 7 | 7 | 309 | 5 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 57655 | 179693 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 452 Pioche St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6005528.42595 | 2093233.45059 | 37.7279334031803 | -122.423128082618 | (37.7279334031803, -122.423128082618) | 9 | 7 | 7 | 309 | 5 | |||
| 25640 | 179694 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 452 Pioche St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6005521.71663 | 2093231.02164 | 37.7279263551921 | -122.423151104361 | (37.7279263551921, -122.423151104361) | 9 | 7 | 7 | 309 | 5 | |||
| 158166 | 179695 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 452 Pioche St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6005492.33807 | 2093223.06878 | 37.7279028604203 | -122.423252101829 | (37.7279028604203, -122.423252101829) | 9 | 7 | 7 | 309 | 5 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 54834 | 114822 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 4 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 61799 | 114838 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 20 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 79852 | 114825 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 7 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 90165 | 114837 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 19 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 91635 | 114828 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 10 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 93366 | 114824 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 6 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 102078 | 114823 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 5 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 120628 | 114830 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 12 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 126627 | 114831 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 13 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 128177 | 114826 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 8 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 147592 | 114827 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 9 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 147593 | 114821 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 154903 | 114832 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 14 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 161168 | 114820 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 2 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 178799 | 114836 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 18 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 179206 | 114833 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 15 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 182055 | 114829 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 11 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 182265 | 114835 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 17 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 9 | 7 | 6 | 28861 | 5 | ||||
| 188045 | 114839 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 251x TRUMBULL ST | 21 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004998 | 2094336 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | 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 | |||
| 170109 | 179721 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6004972.55508 | 2094359.63328 | 37.7309942664727 | -122.42512984309 | (37.7309942664727, -122.42512984309) | 9 | 7 | 6 | 28861 | 5 | |||
| 191753 | 179722 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6004969.27594 | 2094359.70074 | 37.7309942664601 | -122.425141184436 | (37.7309942664601, -122.425141184436) | 9 | 7 | 6 | 28861 | 5 | |||
| 115181 | 179723 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6004965.77364 | 2094359.55499 | 37.7309936684124 | -122.425153282119 | (37.7309936684124, -122.425153282119) | 9 | 7 | 6 | 28861 | 5 | |||
| 158153 | 179724 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6004962.68183 | 2094358.09428 | 37.7309894829652 | -122.425163867137 | (37.7309894829652, -122.425163867137) | 9 | 7 | 6 | 28861 | 5 | |||
| 129747 | 179725 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6004961.19191 | 2094360.08487 | 37.7309948645139 | -122.425169159633 | (37.7309948645139, -122.425169159633) | 9 | 7 | 6 | 28861 | 5 | |||
| 84400 | 179726 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6004958.10458 | 2094358.84188 | 37.730991277129 | -122.425179744649 | (37.730991277129, -122.425179744649) | 9 | 7 | 6 | 28861 | 5 | |||
| 95028 | 179727 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 4ft | 6004951.54629 | 2094358.97681 | 37.7309912771199 | -122.425202427376 | (37.7309912771199, -122.425202427376) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 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 | |||
| 181680 | 112452 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1021 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6004875.37651 | 2091205.89933 | 37.7223293183158 | -122.42524147682 | (37.7223293183158, -122.42524147682) | 9 | 7 | 6 | 28861 | 5 | |||
| 192062 | 179719 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 1021 Excelsior Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6004873.15059 | 2091207.68365 | 37.7223340919162 | -122.425249298216 | (37.7223340919162, -122.425249298216) | 9 | 7 | 6 | 28861 | 5 | |||
| 175068 | 179730 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 4ft | 6004936.64946 | 2094357.75866 | 37.7309870907696 | -122.425253841613 | (37.7309870907696, -122.425253841613) | 9 | 7 | 6 | 28861 | 5 | |||
| 55212 | 179731 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6004933.37032 | 2094357.82613 | 37.7309870907725 | -122.425265182959 | (37.7309870907725, -122.425265182959) | 9 | 7 | 6 | 28861 | 5 | |||
| 54262 | 179733 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 6004930.36809 | 2094360.71906 | 37.7309948645031 | -122.425275767962 | (37.7309948645031, -122.425275767962) | 9 | 7 | 6 | 28861 | 5 | |||
| 102910 | 179732 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6004930.32778 | 2094358.75996 | 37.7309894829729 | -122.425275767965 | (37.7309894829729, -122.425275767965) | 9 | 7 | 6 | 28861 | 5 | |||
| 107200 | 179734 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | Width 4ft | 6004925.53632 | 2094359.72977 | 37.7309918751589 | -122.425292401846 | (37.7309918751589, -122.425292401846) | 9 | 7 | 6 | 28861 | 5 | |||
| 69756 | 179735 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6004922.43107 | 2094357.6156 | 37.7309858946841 | -122.425302986837 | (37.7309858946841, -122.425302986837) | 9 | 7 | 6 | 28861 | 5 | |||
| 134507 | 179736 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6004921.59693 | 2094359.59302 | 37.7309912771138 | -122.425306011263 | (37.7309912771138, -122.425306011263) | 9 | 7 | 6 | 28861 | 5 | |||
| 138393 | 179737 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6004916.3191 | 2094358.17697 | 37.7309870907763 | -122.425324156893 | (37.7309870907763, -122.425324156893) | 9 | 7 | 6 | 28861 | 5 | |||
| 139884 | 179738 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 4ft | 6004912.83024 | 2094358.68437 | 37.7309882868738 | -122.425336254571 | (37.7309882868738, -122.425336254571) | 9 | 7 | 6 | 28861 | 5 | |||
| 126755 | 179739 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6004909.53318 | 2094357.88098 | 37.7309858946685 | -122.42534759592 | (37.7309858946685, -122.42534759592) | 9 | 7 | 6 | 28861 | 5 | |||
| 145961 | 179740 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6004904.49617 | 2094357.54934 | 37.7309846994791 | -122.425364986131 | (37.7309846994791, -122.425364986131) | 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 | |||
| 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 | |||
| 123922 | 179743 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6004897.52319 | 2094358.78152 | 37.7309876888093 | -122.425389180565 | (37.7309876888093, -122.425389180565) | 9 | 7 | 6 | 28861 | 5 | |||
| 79817 | 179744 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6004895.55112 | 2094358.6043 | 37.730987090783 | -122.425395985741 | (37.730987090783, -122.425395985741) | 9 | 7 | 6 | 28861 | 5 | |||
| 193197 | 179745 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6004892.21375 | 2094355.84181 | 37.7309793170417 | -122.425407327082 | (37.7309793170417, -122.425407327082) | 9 | 7 | 6 | 28861 | 5 | |||
| 57176 | 179746 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 4ft | 6004890.51437 | 2094358.27232 | 37.7309858946676 | -122.425413375028 | (37.7309858946676, -122.425413375028) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 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 | |||
| 107629 | 179750 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6004883.72845 | 2094357.97667 | 37.7309846994755 | -122.425436814078 | (37.7309846994755, -122.425436814078) | 9 | 7 | 6 | 28861 | 5 | |||
| 90918 | 179749 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 4ft | 6004883.32719 | 2094359.72705 | 37.7309894829583 | -122.425438325822 | (37.7309894829583, -122.425438325822) | 9 | 7 | 6 | 28861 | 5 | |||
| 160382 | 179751 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6004881.94818 | 2094356.48865 | 37.7309805131181 | -122.425442862919 | (37.7309805131181, -122.425442862919) | 9 | 7 | 6 | 28861 | 5 | |||
| 129438 | 179752 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6004881.33272 | 2094358.46125 | 37.7309858946651 | -122.425445130998 | (37.7309858946651, -122.425445130998) | 9 | 7 | 6 | 28861 | 5 | |||
| 134656 | 179753 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6004874.81924 | 2094360.77335 | 37.7309918751611 | -122.42546781369 | (37.7309918751611, -122.42546781369) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 159274 | 179755 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6004867.64101 | 2094362.66319 | 37.7309966586612 | -122.425492764501 | (37.7309966586612, -122.425492764501) | 9 | 7 | 6 | 28861 | 5 | |||
| 179505 | 179756 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6004864.30812 | 2094360.11842 | 37.7309894829744 | -122.425504105834 | (37.7309894829744, -122.425504105834) | 9 | 7 | 6 | 28861 | 5 | |||
| 72318 | 179757 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6004862.37214 | 2094361.68258 | 37.7309936684225 | -122.425510910124 | (37.7309936684225, -122.425510910124) | 9 | 7 | 6 | 28861 | 5 | |||
| 97521 | 179758 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 6004859.59518 | 2094360.54227 | 37.7309903804801 | -122.425520429425 | (37.7309903804801, -122.425520429425) | 9 | 7 | 6 | 28861 | 5 | |||
| 120573 | 179759 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 10ft | 6004857.12989 | 2094362.00826 | 37.7309942664668 | -122.425529056646 | (37.7309942664668, -122.425529056646) | 9 | 7 | 6 | 28861 | 5 | |||
| 127877 | 179760 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 10ft | 6004853.85523 | 2094362.29345 | 37.730994864507 | -122.425540397994 | (37.730994864507, -122.425540397994) | 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 | |||
| 74338 | 179762 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 6004847.12334 | 2094364.61005 | 37.7310008449997 | -122.425563836098 | (37.7310008449997, -122.425563836098) | 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 | |||
| 141679 | 179764 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6004840.32846 | 2094363.87865 | 37.7309984527989 | -122.425587275126 | (37.7309984527989, -122.425587275126) | 9 | 7 | 6 | 28861 | 5 | |||
| 181727 | 179765 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 10ft | 6004837.08963 | 2094365.90524 | 37.7310038343548 | -122.425598616496 | (37.7310038343548, -122.425598616496) | 9 | 7 | 6 | 28861 | 5 | |||
| 193630 | 179766 | DPW Maintained 1 | Syzygium paniculatum :: Brush Cherry 243 | 201 Trumbull St | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 10ft | 6004833.34204 | 2094364.45804 | 37.7309996489081 | -122.425611469595 | (37.7309996489081, -122.425611469595) | 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) );