trees
3,587 rows where qSpecies_id = 28
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17347 | 12370 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1335 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004408.00965 | 2113459.2839 | 37.7834054897746 | -122.428442413333 | (37.7834054897746, -122.428442413333) | 7 | 9 | 11 | 29490 | 41 | |||
17411 | 12539 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 210 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/01/2019 12:00:00 AM | 3 | 3x3 | 5994802.33005 | 2114932.67469 | 37.7869027759417 | -122.461780923147 | (37.7869027759417, -122.461780923147) | 11 | 6 | 1 | 54 | 11 | ||
17574 | 120058 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 132 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | Width 4ft | 5987428.81431 | 2115064.18199 | 37.7868366349011 | -122.487300926674 | (37.7868366349011, -122.487300926674) | 11 | 6 | 1 | 55 | 33 | |||
17595 | 255124 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
17759 | 8164 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1108 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3x3 | 6002345.91863 | 2111334.94694 | 37.7774556905463 | -122.435424415956 | (37.7774556905463, -122.435424415956) | 15 | 5 | 11 | 29492 | 41 | |||
17899 | 110754 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 COLE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x4 | 5998015 | 2108858 | 37.770407716093 | -122.450227838314 | (37.770407716093, -122.450227838314) | 15 | 5 | 11 | 29492 | 9 | ||||
17905 | 260412 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Brotherhood Way | 1 | Side Yard : Yard | Tree | Private 2 | Width 0ft | 5992928.58802 | 2087852.90738 | 37.7124406464989 | -122.466294818667 | (37.7124406464989, -122.466294818667) | 9 | 8 | 4 | 64 | 24 | ||||
18145 | 12518 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 25 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3X3 | 5995386.16934 | 2114888.58618 | 37.7868153127181 | -122.459757792257 | (37.7868153127181, -122.459757792257) | 11 | 6 | 1 | 54 | 11 | |||
18193 | 189473 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 149 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 6015891.28978 | 2113582.38645 | 37.7843866224808 | -122.38872301585 | (37.7843866224808, -122.38872301585) | 6 | 2 | 9 | 28856 | 6 | |||
18267 | 248156 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 225 Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6010067.63283 | 2099505.65063 | 37.7454106326971 | -122.407877963018 | (37.7454106326971, -122.407877963018) | 2 | 7 | 7 | 28859 | 2 | |||
18302 | 33467 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 72 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37623 | 6006783.56593714 | 2099291.50343979 | 37.7446382277934 | -122.419218573599 | (37.7446382277934, -122.419218573599) | 2 | 7 | 7 | 28859 | 2 | ||
18469 | 61073 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2638 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/01/1983 12:00:00 AM | 20 | Permit Number 20909 | 5999566.78827199 | 2113662.02579548 | 37.78368702296 | -122.445205661056 | (37.78368702296, -122.445205661056) | 15 | 6 | 11 | 29490 | 31 | |
18502 | 1999 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 217 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 38 | 3X3 | 6007148.9837828 | 2097704.1672578 | 37.7403003295941 | -122.417842531543 | (37.7403003295941, -122.417842531543) | 2 | 7 | 7 | 28859 | 2 | |||
18540 | 48750 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
18557 | 206368 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 80 Southwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 39 | Width 3ft | 5995490.98867 | 2092437.73844 | 37.7251770224761 | -122.457769987599 | (37.7251770224761, -122.457769987599) | 9 | 7 | 4 | 28861 | 40 | |||
18576 | 261447 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 317 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006993 | 2095799 | 37.7350603822594 | -122.418246820854 | (37.7350603822594, -122.418246820854) | 2 | 7 | 7 | 28859 | 2 | ||||
18584 | 248142 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 280 Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6009850.53205 | 2099420.75509 | 37.7451653713952 | -122.408622678105 | (37.7451653713952, -122.408622678105) | 2 | 7 | 7 | 28859 | 2 | |||
18730 | 205491 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 528 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 5994097.86449 | 2107018.61016 | 37.7651322903366 | -122.46364359657 | (37.7651322903366, -122.46364359657) | 11 | 5 | 11 | 56 | 12 | |||
18822 | 65766 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1937 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1990 12:00:00 AM | 15 | Permit Number 28729 | 6003642.45675 | 2118972.66599 | 37.7985004828598 | -122.431484647806 | (37.7985004828598, -122.431484647806) | 13 | 9 | 1 | 57 | 17 | |
18977 | 97306 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 47 Kittredge Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997949.8 | 2111441.7 | 37.7774981585608 | -122.450639669067 | (37.7774981585608, -122.450639669067) | 15 | 6 | 2 | 54 | 16 | |||||
19077 | 138568 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2626 Pine St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6001336.9539 | 2114950.5561 | 37.7873258778413 | -122.439173956551 | (37.7873258778413, -122.439173956551) | 13 | 6 | 1 | 29490 | 27 | |||
19147 | 255132 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 10 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
19241 | 26162 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 220 Richardson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5999090.09548 | 2119848.96049 | 37.8006474865597 | -122.447300272802 | (37.8006474865597, -122.447300272802) | 13 | 9 | 1 | 57 | 17 | |||
19385 | 16804 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2060 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 18 | 4x3 | 6001450.7704065 | 2113227.696464 | 37.7826018222756 | -122.438656679492 | (37.7826018222756, -122.438656679492) | 15 | 5 | 11 | 29490 | 41 | |||
19433 | 123853 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 Lake St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 7ft | 5994558.56386 | 2114921.26273 | 37.786857406167 | -122.462623463806 | (37.786857406167, -122.462623463806) | 11 | 6 | 1 | 54 | 11 | |||
19442 | 123590 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 28 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5994274.25903 | 2115401.74269 | 37.7881602957788 | -122.463641970091 | (37.7881602957788, -122.463641970091) | 11 | 6 | 1 | 54 | 11 | |||
19545 | 141294 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1835 ELLIS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002014.4712 | 2112907.6925 | 37.7817552238956 | -122.436683606845 | (37.7817552238956, -122.436683606845) | 15 | 5 | 11 | 29490 | 41 | |||
19587 | 260401 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3900 Alemany Blvd | 2 | Median : Yard | Tree | DPW 1 | 3X5 | 5992602.03225 | 2087509.49597 | 37.7114788737215 | -122.467398529617 | (37.7114788737215, -122.467398529617) | 9 | 8 | 4 | 64 | 24 | ||||
19608 | 189403 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1900 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6012367.68824 | 2104717.66867 | 37.7598502014559 | -122.400290696781 | (37.7598502014559, -122.400290696781) | 10 | 3 | 8 | 28856 | 29 | |||
19665 | 189518 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 131 Acacia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6018139.6232 | 2096213.22199 | 37.736818885776 | -122.379737317327 | (37.736818885776, -122.379737317327) | 10 | 3 | 8 | 58 | 1 | |||
19666 | 98539 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 710 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 4x4 | 5991968.21537 | 2110556.64654 | 37.774723845896 | -122.471267264576 | (37.774723845896, -122.471267264576) | 11 | 6 | 2 | 54 | 11 | |||
19682 | 16216 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 527-529 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | Also has partial frontage shared with 535 Monterey Blvd. | 5998570.71989 | 2094653.44366 | 37.7314372752037 | -122.447283112845 | (37.7314372752037, -122.447283112845) | 9 | 7 | 4 | 59 | 40 | ||
19688 | 126199 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3045 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5999577.09584 | 2116663.67012 | 37.7919293417196 | -122.44538589855 | (37.7919293417196, -122.44538589855) | 13 | 6 | 1 | 29490 | 27 | |||
19739 | 119985 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2512 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 5ft | 5987666.80033 | 2110540.30319 | 37.7744292202448 | -122.486145343797 | (37.7744292202448, -122.486145343797) | 11 | 6 | 2 | 55 | 26 | |||
19759 | 206343 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 320 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 3ft | 5993037.90763 | 2099693.34054 | 37.7449578645128 | -122.46677715836 | (37.7449578645128, -122.46677715836) | 1 | 8 | 4 | 29491 | 40 | |||
19805 | 126225 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2137 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6003795.94873 | 2115803.8767 | 37.7898084966014 | -122.430727270273 | (37.7898084966014, -122.430727270273) | 13 | 9 | 1 | 29490 | 27 | |||
19926 | 1838 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2201X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6011226.77764 | 2087216.18178 | 37.7117311371657 | -122.403005565662 | (37.7117311371657, -122.403005565662) | 10 | 3 | 8 | 309 | 1 | |||
19936 | 206425 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 197 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 5ft | 6000818.65749 | 2094921.32163 | 37.7323009993923 | -122.439530782334 | (37.7323009993923, -122.439530782334) | 9 | 7 | 4 | 63 | 40 | |||
20003 | 99987 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 535@Clay Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012018 | 2117734 | 37.7955705425922 | -122.402415352518 | (37.7955705425922, -122.402415352518) | 3 | 1 | 10 | 28860 | 4 | |||||
20023 | 126333 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 537 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6011888.21181 | 2117712.45326 | 37.7955041342546 | -122.402862928705 | (37.7955041342546, -122.402862928705) | 3 | 1 | 10 | 28860 | 4 | |||
20078 | 248752 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1179 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6007686.46628 | 2102816.39807 | 37.7543676015089 | -122.416346131374 | (37.7543676015089, -122.416346131374) | 2 | 4 | 7 | 28859 | 19 | |||
20135 | 248904 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 4109 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1976 12:00:00 AM | 28 | Width 5ft | Permit Number 16599 | 6001658.90013 | 2103489.46423 | 37.7558748868343 | -122.437239147875 | (37.7558748868343, -122.437239147875) | 2 | 4 | 5 | 28862 | 22 | |
20149 | 102321 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 3200X 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008156.4 | 2105059 | 37.760551689018 | -122.414879686077 | (37.760551689018, -122.414879686077) | 2 | 4 | 7 | 28859 | 19 | |||
20154 | 126324 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 514 Commercial St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012230.12166 | 2117309.16104 | 37.7944158754575 | -122.401651495115 | (37.7944158754575, -122.401651495115) | 3 | 1 | 10 | 28860 | 4 | |||
20178 | 6025 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1791 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001894.3231 | 2112551.24042 | 37.7807696680583 | -122.437073734016 | (37.7807696680583, -122.437073734016) | 15 | 5 | 11 | 29490 | 41 | |||
20216 | 121344 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
20251 | 126264 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1333 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007187.34034 | 2115852.63803 | 37.7901339378778 | -122.418996808454 | (37.7901339378778, -122.418996808454) | 13 | 9 | 10 | 28858 | 21 | |||
20259 | 26515 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2886 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6008938.68629 | 2101687.00134 | 37.7513368683627 | -122.411935812817 | (37.7513368683627, -122.411935812817) | 2 | 4 | 7 | 28859 | 19 | ||||
20268 | 248759 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2987 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008379.36946 | 2103275.26244 | 37.7556664788408 | -122.413982346112 | (37.7556664788408, -122.413982346112) | 2 | 4 | 7 | 28859 | 19 | |||
20402 | 257888 | Property Tree 8 | Corymbia ficifolia :: Red Flowering Gum 28 | 155X Magellan Ave | 1 | Front Yard : Yard | Tree | MTA 3 | 10x10 | 5995070 | 2100842 | 37.7482288640106 | -122.459833790503 | (37.7482288640106, -122.459833790503) | 1 | 8 | 4 | 29491 | 40 | ||||
20449 | 12388 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1450 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x4 | 6004617.47643 | 2113882.98777 | 37.7845807261574 | -122.427747939391 | (37.7845807261574, -122.427747939391) | 13 | 9 | 11 | 28858 | 41 | |||
20479 | 120223 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 250 25th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5988081.34041 | 2114326.62635 | 37.7848495475274 | -122.484989234472 | (37.7848495475274, -122.484989234472) | 11 | 6 | 2 | 55 | 26 | |||
20491 | 118331 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007461 | 2099574 | 37.7454520282724 | -122.416896144845 | (37.7454520282724, -122.416896144845) | 2 | 7 | 7 | 28859 | 2 | ||||
20704 | 2136 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100X Bosworth St | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | ||||
20773 | 247271 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1520 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 0ft | 5999161.4757 | 2109086.5323 | 37.7711007505764 | -122.446278633453 | (37.7711007505764, -122.446278633453) | 15 | 5 | 11 | 29492 | 9 | |||
20866 | 212161 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300x Marietta Dr | 11 | Median : Cutout | Tree | DPW 1 | 24 | Width 5ft | 5999206.26812 | 2097588.84406 | 37.7395334857736 | -122.445296885446 | (37.7395334857736, -122.445296885446) | 9 | 7 | 4 | 59 | 40 | |||
20880 | 99966 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2270 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||||
20912 | 24331 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6006691.6523257 | 2112520.4868544 | 37.7809567435024 | -122.420475231256 | (37.7809567435024, -122.420475231256) | 7 | 9 | 9 | 28852 | 36 | ||||
20962 | 116910 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 351X HERMANN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6003606 | 2108630 | 37.7701000542623 | -122.430872290016 | (37.7701000542623, -122.430872290016) | 15 | 9 | 5 | 29492 | 10 | |||
20969 | 212079 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 121 San Pablo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 6ft | 5994275.39415 | 2097162.78754 | 37.7380809394917 | -122.462314685482 | (37.7380809394917, -122.462314685482) | 9 | 8 | 4 | 59 | 40 | |||
20983 | 26458 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017771.22225 | 2096841.34416 | 37.7385232566369 | -122.381054711725 | (37.7385232566369, -122.381054711725) | 10 | 3 | 8 | 58 | 1 | |||
21021 | 212245 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 281 Brighton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5996217.16098 | 2091789.9772 | 37.723440115058 | -122.455212909243 | (37.723440115058, -122.455212909243) | 9 | 8 | 4 | 28861 | 24 | |||
21101 | 189529 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 213 Acacia Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017810.85672 | 2096234.27169 | 37.7368585440828 | -122.380875482215 | (37.7368585440828, -122.380875482215) | 10 | 3 | 8 | 58 | 1 | |||
21189 | 14933 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016941.57525 | 2098184.84614 | 37.7421664120423 | -122.384016788063 | (37.7421664120423, -122.384016788063) | 10 | 3 | 8 | 58 | 1 | |||
21249 | 112640 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 299X STOCKTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6x9 | 6010693 | 2115178 | 37.7884783251045 | -122.406819877074 | (37.7884783251045, -122.406819877074) | 5 | 1 | 10 | 28852 | 6 | |||
21335 | 248633 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1550 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6009395.0721 | 2107534.93214 | 37.767419555005 | -122.410770529855 | (37.767419555005, -122.410770529855) | 8 | 4 | 7 | 28853 | 19 | |||
21663 | 189513 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 130 Acacia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6018133.38456 | 2096174.43393 | 37.7367120373179 | -122.379756193195 | (37.7367120373179, -122.379756193195) | 10 | 3 | 8 | 58 | 1 | |||
21752 | 29977 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 610X Junipero Serra Blvd | 2 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991336.00972369 | 2093444.32433125 | 37.7277012826104 | -122.47220652658 | (37.7277012826104, -122.47220652658) | 9 | 8 | 4 | 64 | 40 | ||
21784 | 123231 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 759 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 6ft | 5993483.55222 | 2110312.60045 | 37.7741412977795 | -122.466007712161 | (37.7741412977795, -122.466007712161) | 11 | 6 | 2 | 54 | 11 | |||
21802 | 212277 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 751 Junipero Serra Blvd | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5991382.29042 | 2092479.81131 | 37.725055648191 | -122.471976265919 | (37.725055648191, -122.471976265919) | 9 | 8 | 4 | 59 | 40 | |||
21817 | 222088 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3757 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003335.69899 | 2103576.63958 | 37.7562094265452 | -122.431446457193 | (37.7562094265452, -122.431446457193) | 2 | 4 | 5 | 28862 | 22 | |||
21890 | 205097 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800x Junipero Serra Blvd | 27 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 5991311.65126 | 2092183.57203 | 37.7242381608387 | -122.472198871475 | (37.7242381608387, -122.472198871475) | 9 | 8 | 4 | 59 | 40 | |||
21900 | 176048 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5989010.93647 | 2089619.81285 | 37.7170653066825 | -122.479964486788 | (37.7170653066825, -122.479964486788) | 1 | 8 | 4 | 64 | 14 | ||||
21958 | 248538 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 109 Beulah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997573.6273 | 2107783.5338 | 37.767432238783 | -122.451677021277 | (37.767432238783, -122.451677021277) | 15 | 5 | 11 | 29492 | 9 | |||
21966 | 14887 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 151 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2006 12:00:00 AM | 3 | 3x3 | 6017068.53164 | 2098456.8281 | 37.7429202372855 | -122.383596739007 | (37.7429202372855, -122.383596739007) | 10 | 3 | 8 | 58 | 1 | ||
22089 | 86892 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Mason St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49821 | 6008765 | 2122158 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | 3 | 1 | 10 | 308 | 23 | |||
22098 | 205111 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800x Junipero Serra Blvd | 49 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 5991346.44389 | 2092729.45294 | 37.7257390277172 | -122.472118370494 | (37.7257390277172, -122.472118370494) | 9 | 8 | 4 | 59 | 40 | |||
22317 | 30044 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 25 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.471585892822 | (37.7138086207581, -122.471585892822) | 1 | 8 | 4 | 64 | 24 | |||
22374 | 12660 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1045 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 4X4 | 5992154.39933 | 2114773.56456 | 37.7863131171963 | -122.470930475416 | (37.7863131171963, -122.470930475416) | 11 | 6 | 2 | 54 | 11 | |||
22384 | 14951 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 225 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017001.18429 | 2098171.14482 | 37.7421320862857 | -122.383809722815 | (37.7421320862857, -122.383809722815) | 10 | 3 | 8 | 58 | 1 | |||
22417 | 58653 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1041 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1979 12:00:00 AM | 3x3 | Permit Number 17875 | 5997239.92048014 | 2106921.18918515 | 37.7650453439116 | -122.452769014505 | (37.7650453439116, -122.452769014505) | 15 | 5 | 11 | 29492 | 12 | ||
22428 | 248743 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2225 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6008185.21113 | 2105259.93562 | 37.7611050308912 | -122.41479426214 | (37.7611050308912, -122.41479426214) | 2 | 4 | 7 | 28859 | 19 | |||
22477 | 248840 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 65 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6006855.4137 | 2099329.69653 | 37.7447471434584 | -122.418972846027 | (37.7447471434584, -122.418972846027) | 2 | 7 | 7 | 28859 | 2 | |||
22614 | 142207 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 427 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | Width 0ft | 5999714.6993 | 2110123.1538 | 37.7739786302184 | -122.444439532021 | (37.7739786302184, -122.444439532021) | 15 | 5 | 11 | 29492 | 16 | |||
22615 | 212111 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1802x Monterey Blvd | 2 | Median : Yard | Tree | DPW 1 | 24 | Width 10ft | 5992507.56631 | 2095396.95389 | 37.7331304494932 | -122.468298465918 | (37.7331304494932, -122.468298465918) | 9 | 8 | 4 | 59 | 40 | |||
22660 | 33533 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 185 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37643 | 6007275.34853053 | 2097937.54990535 | 37.7409482571652 | -122.417422147014 | (37.7409482571652, -122.417422147014) | 2 | 7 | 7 | 28859 | 2 | |||
22671 | 248642 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 101 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007785.69421 | 2107933.31633 | 37.7684230563089 | -122.416365384082 | (37.7684230563089, -122.416365384082) | 8 | 4 | 7 | 28853 | 19 | |||
22731 | 11780 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Junipero Serra Blvd | 12 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991289.71415 | 2091805.70466 | 37.7231993611319 | -122.472247172286 | (37.7231993611319, -122.472247172286) | 9 | 8 | 4 | 59 | 40 | ||
22869 | 12149 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X La Salle Ave | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016248.95724 | 2095649.36964 | 37.735166191751 | -122.386234942494 | (37.735166191751, -122.386234942494) | 10 | 3 | 8 | 58 | 1 | |||
22924 | 246218 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1378 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5999578.5072 | 2107913.2961 | 37.7679031482442 | -122.444751767156 | (37.7679031482442, -122.444751767156) | 15 | 5 | 11 | 29492 | 9 | |||
22935 | 12652 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 5992352.41288 | 2114839.20557 | 37.7865047992766 | -122.470250187524 | (37.7865047992766, -122.470250187524) | 11 | 6 | 1 | 54 | 11 | |||
23052 | 3754 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1020 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 36 | 18 | 6012443.0515847 | 2103208.5839527 | 37.755710788358 | -122.399924077269 | (37.755710788358, -122.399924077269) | 10 | 3 | 8 | 28856 | 29 | |||
23077 | 16168 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 425 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2007 12:00:00 AM | 28 | 3X3 | 5999268.01839 | 2094645.05904 | 37.7314540727301 | -122.444871826278 | (37.7314540727301, -122.444871826278) | 9 | 7 | 4 | 59 | 40 | ||
23094 | 248636 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 83 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6005406.472 | 2103224.32125 | 37.7553591885768 | -122.42425995315 | (37.7553591885768, -122.42425995315) | 2 | 4 | 5 | 28859 | 19 | |||
23098 | 189496 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 210 Acacia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017841.42794 | 2096187.45373 | 37.736731678516 | -122.380766529361 | (37.736731678516, -122.380766529361) | 10 | 3 | 8 | 58 | 1 | |||
23170 | 28848 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/08/2005 12:00:00 AM | 3 | 3X3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | ||
23280 | 22237 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 4445 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6015309.22014 | 2096468.43632 | 37.7373631231169 | -122.389541166269 | (37.7373631231169, -122.389541166269) | 10 | 3 | 8 | 58 | 1 | |||
23313 | 67885 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 558 Commercial St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/1993 12:00:00 AM | 11 | 4x4 | Permit Number 31579 | 6012000.40021 | 2117278.49262 | 37.7943188457921 | -122.402444206153 | (37.7943188457921, -122.402444206153) | 3 | 1 | 10 | 28860 | 4 | |
23339 | 248637 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 83 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6005405.36943 | 2103242.79732 | 37.7554098573023 | -122.424265080165 | (37.7554098573023, -122.424265080165) | 2 | 4 | 5 | 28859 | 19 | |||
23382 | 11720 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 |
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) );