trees
3,587 rows where qSpecies_id = 28 sorted by YCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 55940 | 38221 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 140 Chester Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | Permit Number 40348 | 5991708.17687703 | 2088279.9583595 | 37.7135427330302 | -122.470543976889 | (37.7135427330302, -122.470543976889) | 9 | 8 | 6 | 64 | 24 | |||
| 117749 | 176010 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2168 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012292.82852 | 2088295.96759 | 37.7147554870429 | -122.399396735587 | (37.7147554870429, -122.399396735587) | 10 | 7 | 8 | 309 | 39 | |||
| 29780 | 11857 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 5 | Median : Cutout | Tree | DPW 1 | 0 | 5x5 | 5991386.4673518 | 2088368.501669 | 37.71376724375 | -122.471662357701 | (37.71376724375, -122.471662357701) | 1 | 8 | 4 | 64 | 14 | |||
| 34515 | 11870 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 16 | Median : Cutout | Tree | DPW 1 | 0 | 6X6 | 5991386.4673518 | 2088368.501669 | 37.71376724375 | -122.471662357701 | (37.71376724375, -122.471662357701) | 1 | 8 | 4 | 64 | 14 | |||
| 35759 | 11859 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 7 | Median : Cutout | Tree | DPW 1 | 0 | 5x5 | 5991386.4673518 | 2088368.501669 | 37.71376724375 | -122.471662357701 | (37.71376724375, -122.471662357701) | 1 | 8 | 4 | 64 | 14 | |||
| 50688 | 11864 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 13 | Median : Cutout | Tree | DPW 1 | 0 | 6X6 | 5991386.4673518 | 2088368.501669 | 37.71376724375 | -122.471662357701 | (37.71376724375, -122.471662357701) | 1 | 8 | 4 | 64 | 14 | |||
| 57663 | 254422 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 18 | Median : Cutout | Tree | DPW 1 | 6X6 | 5991386.4673518 | 2088368.501669 | 37.71376724375 | -122.471662357701 | (37.71376724375, -122.471662357701) | 1 | 8 | 4 | 64 | 14 | ||||
| 66188 | 11866 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 11 | Median : Cutout | Tree | DPW 1 | 0 | 5x5 | 5991386.4673518 | 2088368.501669 | 37.71376724375 | -122.471662357701 | (37.71376724375, -122.471662357701) | 1 | 8 | 4 | 64 | 14 | |||
| 110990 | 254423 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 19 | Median : Cutout | Tree | DPW 1 | 6X6 | 5991386.4673518 | 2088368.501669 | 37.71376724375 | -122.471662357701 | (37.71376724375, -122.471662357701) | 1 | 8 | 4 | 64 | 14 | ||||
| 139088 | 254421 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 17 | Median : Cutout | Tree | DPW 1 | 6X6 | 5991386.4673518 | 2088368.501669 | 37.71376724375 | -122.471662357701 | (37.71376724375, -122.471662357701) | 1 | 8 | 4 | 64 | 14 | ||||
| 149537 | 11863 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 10 | Median : Cutout | Tree | DPW 1 | 0 | 6X6 | 5991386.4673518 | 2088368.501669 | 37.71376724375 | -122.471662357701 | (37.71376724375, -122.471662357701) | 1 | 8 | 4 | 64 | 14 | |||
| 163006 | 11858 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 6 | Median : Cutout | Tree | DPW 1 | 0 | 5x5 | 5991386.4673518 | 2088368.501669 | 37.71376724375 | -122.471662357701 | (37.71376724375, -122.471662357701) | 1 | 8 | 4 | 64 | 14 | |||
| 41376 | 11840 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 12 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341 | (37.7137927618926, -122.47166998341) | 1 | 8 | 4 | 64 | 14 | |||
| 75017 | 11839 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 14 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341 | (37.7137927618926, -122.47166998341) | 1 | 8 | 4 | 64 | 14 | |||
| 76963 | 11846 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 18 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341 | (37.7137927618926, -122.47166998341) | 1 | 8 | 4 | 64 | 14 | |||
| 86863 | 11841 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 13 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341 | (37.7137927618926, -122.47166998341) | 1 | 8 | 4 | 64 | 14 | |||
| 100058 | 11830 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 2 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341 | (37.7137927618926, -122.47166998341) | 1 | 8 | 4 | 64 | 14 | ||
| 100785 | 11834 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 6 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341 | (37.7137927618926, -122.47166998341) | 1 | 8 | 4 | 64 | 14 | |||
| 121219 | 11831 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 3 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341 | (37.7137927618926, -122.47166998341) | 1 | 8 | 4 | 64 | 14 | ||
| 172813 | 11832 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 4 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341 | (37.7137927618926, -122.47166998341) | 1 | 8 | 4 | 64 | 14 | |||
| 175987 | 11835 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 7 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341 | (37.7137927618926, -122.47166998341) | 1 | 8 | 4 | 64 | 14 | |||
| 176023 | 11843 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 20 | Median : Cutout | Tree | DPW 1 | 3 | 2X2 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341 | (37.7137927618926, -122.47166998341) | 1 | 8 | 4 | 64 | 14 | |||
| 180049 | 11844 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 16 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341 | (37.7137927618926, -122.47166998341) | 1 | 8 | 4 | 64 | 14 | |||
| 181789 | 11847 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 19 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341 | (37.7137927618926, -122.47166998341) | 1 | 8 | 4 | 64 | 14 | |||
| 189402 | 11845 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 17 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341 | (37.7137927618926, -122.47166998341) | 1 | 8 | 4 | 64 | 14 | |||
| 190189 | 11836 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 8 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341 | (37.7137927618926, -122.47166998341) | 1 | 8 | 4 | 64 | 14 | |||
| 192758 | 11837 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 9 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341 | (37.7137927618926, -122.47166998341) | 1 | 8 | 4 | 64 | 14 | |||
| 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 | |||
| 32786 | 30046 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 27 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.471585892822 | (37.7138086207581, -122.471585892822) | 1 | 8 | 4 | 64 | 24 | |||
| 36138 | 30042 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.471585892822 | (37.7138086207581, -122.471585892822) | 1 | 8 | 4 | 64 | 24 | |||
| 45427 | 30038 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 1 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.471585892822 | (37.7138086207581, -122.471585892822) | 1 | 8 | 4 | 64 | 24 | ||
| 57877 | 30039 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 10 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.471585892822 | (37.7138086207581, -122.471585892822) | 1 | 8 | 4 | 64 | 24 | |||
| 103531 | 30041 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 22 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.471585892822 | (37.7138086207581, -122.471585892822) | 1 | 8 | 4 | 64 | 24 | |||
| 119806 | 30045 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 26 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.471585892822 | (37.7138086207581, -122.471585892822) | 1 | 8 | 4 | 64 | 24 | |||
| 169159 | 30040 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 21 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.471585892822 | (37.7138086207581, -122.471585892822) | 1 | 8 | 4 | 64 | 24 | |||
| 170306 | 30043 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 24 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.471585892822 | (37.7138086207581, -122.471585892822) | 1 | 8 | 4 | 64 | 24 | |||
| 66928 | 176031 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 120 Chester Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 3ft | 5991721.84166 | 2088391.39626 | 37.7138495046339 | -122.470504858115 | (37.7138495046339, -122.470504858115) | 9 | 8 | 6 | 64 | 24 | |||
| 116528 | 176026 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 136 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011766.53231 | 2088401.57632 | 37.7150161195868 | -122.401223260471 | (37.7150161195868, -122.401223260471) | 10 | 7 | 8 | 309 | 39 | |||
| 165448 | 1764 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2000X Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/30/1992 12:00:00 AM | 12 | 3X3 | 6012375.8565272 | 2088505.2474917 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | 10 | 7 | 8 | 309 | 39 | ||
| 177472 | 175996 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 959 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 6ft | 6001537.92258 | 2088610.33751 | 37.7150133739397 | -122.436592559601 | (37.7150133739397, -122.436592559601) | 9 | 7 | 6 | 28861 | 5 | |||
| 72553 | 103455 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 953 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x9 | 6001548 | 2088631 | 37.7150706812167 | -122.436559205883 | (37.7150706812167, -122.436559205883) | 9 | 7 | 6 | 28861 | 5 | ||||
| 44052 | 114240 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 99x FONT BLVD | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | |||||
| 126287 | 114225 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 99x FONT BLVD | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 48 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
| 10661 | 114250 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 131 FONT BLVD | 1 | Front Yard : Yard | Tree | Private 2 | 36 | 5990844 | 2088883 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | 1 | 8 | 4 | 64 | 14 | ||||
| 164291 | 253651 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 131 Font Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990844 | 2088883 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | 1 | 8 | 4 | 64 | 14 | ||||
| 116781 | 176039 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100 Junipero Serra Blvd | 10 | : | Tree | Private 2 | 6 | Width 0ft | 5991303.11629 | 2088916.85693 | 37.7152680709394 | -122.471990389765 | (37.7152680709394, -122.471990389765) | 1 | 8 | 4 | 64 | 24 | |||
| 33486 | 176038 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100 Junipero Serra Blvd | 9 | : | Tree | Private 2 | 6 | Width 0ft | 5991295.02694 | 2088957.62103 | 37.7153795311078 | -122.472021319244 | (37.7153795311078, -122.472021319244) | 1 | 8 | 4 | 64 | 24 | |||
| 92216 | 176037 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100 Junipero Serra Blvd | 8 | : | Tree | Private 2 | 3 | Width 0ft | 5991282.94152 | 2088997.4789 | 37.7154882717346 | -122.472065994874 | (37.7154882717346, -122.472065994874) | 1 | 8 | 4 | 64 | 24 | |||
| 96648 | 176036 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100 Junipero Serra Blvd | 7 | : | Tree | Private 2 | 6 | Width 0ft | 5991277.56282 | 2089025.31454 | 37.7155643903478 | -122.47208661362 | (37.7155643903478, -122.47208661362) | 1 | 8 | 4 | 64 | 24 | |||
| 36158 | 176035 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100 Junipero Serra Blvd | 6 | : | Tree | Private 2 | 6 | Width 0ft | 5991271.23185 | 2089055.15051 | 37.7156459462668 | -122.472110669573 | (37.7156459462668, -122.472110669573) | 1 | 8 | 4 | 64 | 24 | |||
| 194366 | 265027 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2623 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 5997622 | 2089116 | 37.7161784966097 | -122.450164015076 | (37.7161784966097, -122.450164015076) | 9 | 8 | 6 | 28861 | 24 | |||
| 153414 | 176034 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100 Junipero Serra Blvd | 4 | : | Tree | Private 2 | 7 | Width 0ft | 5991251.90527 | 2089128.82374 | 37.7158471165157 | -122.472182837493 | (37.7158471165157, -122.472182837493) | 1 | 8 | 4 | 64 | 24 | |||
| 14358 | 206311 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 145 Majestic Ave | 1 | : | Tree | Private 2 | 16 | Width 3ft | 5996946.82319 | 2089129.17686 | 37.7161760165962 | -122.452498687872 | (37.7161760165962, -122.452498687872) | 9 | 8 | 6 | 28861 | 24 | |||
| 144416 | 26378 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2623 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 5997606.3009019 | 2089136.049585 | 37.7162326497335 | -122.450219722793 | (37.7162326497335, -122.450219722793) | 9 | 8 | 6 | 28861 | 24 | |||
| 43827 | 121486 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 381 Wilde Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 6010841.28133 | 2089139.29102 | 37.7169900712102 | -122.404473235851 | (37.7169900712102, -122.404473235851) | 9 | 7 | 8 | 309 | 39 | |||
| 167621 | 176033 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100 Junipero Serra Blvd | 3 | : | Tree | Private 2 | 7 | Width 0ft | 5991250.41814 | 2089152.61686 | 37.7159123605459 | -122.472189711002 | (37.7159123605459, -122.472189711002) | 1 | 8 | 4 | 64 | 24 | |||
| 36700 | 176017 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 26 Ervine St | 13 | Front Yard : Yard | Tree | Private 2 | 25 | 6009623.16291 | 2089154.94299 | 37.7169648982982 | -122.408684805076 | (37.7169648982982, -122.408684805076) | 9 | 7 | 8 | 309 | 18 | ||||
| 57462 | 176018 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 26 Ervine St | 12 | Front Yard : Yard | Tree | Private 2 | 13 | 6009605.36223 | 2089158.99044 | 37.7169750147514 | -122.40874661906 | (37.7169750147514, -122.40874661906) | 9 | 7 | 8 | 309 | 18 | ||||
| 46008 | 121484 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 381 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 6010784.23761 | 2089159.37234 | 37.7170420223587 | -122.404671822369 | (37.7170420223587, -122.404671822369) | 9 | 7 | 8 | 309 | 39 | |||
| 166134 | 206312 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 137 Majestic Ave | 1 | : | Tree | Private 2 | 15 | Width 3ft | 5996974.1215 | 2089165.00897 | 37.7162759672427 | -122.452406916553 | (37.7162759672427, -122.452406916553) | 9 | 8 | 6 | 28861 | 24 | |||
| 162013 | 176032 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100 Junipero Serra Blvd | 2 | : | Tree | Private 2 | 4 | Width 0ft | 5991243.83692 | 2089170.5769 | 37.7159612935557 | -122.472213766971 | (37.7159612935557, -122.472213766971) | 1 | 8 | 4 | 64 | 24 | |||
| 95453 | 176019 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 26 Ervine St | 10 | Front Yard : Yard | Tree | Private 2 | 25 | 6009612.43081 | 2089172.96988 | 37.717013795323 | -122.408723171949 | (37.717013795323, -122.408723171949) | 9 | 7 | 8 | 309 | 18 | ||||
| 95131 | 176020 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 26 Ervine St | 9 | Front Yard : Yard | Tree | Private 2 | 10 | 6009615.52074 | 2089232.9452 | 37.7171786482456 | -122.408716720218 | (37.7171786482456, -122.408716720218) | 9 | 7 | 8 | 309 | 18 | ||||
| 50190 | 104428 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 390 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 4x4 | 6010699.78768 | 2089233.16834 | 37.7172399307634 | -122.404968919684 | (37.7172399307634, -122.404968919684) | 10 | 7 | 8 | 309 | 39 | |||
| 168693 | 104429 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 390 Wilde Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6010684.07078 | 2089238.89414 | 37.7172547740586 | -122.405023648815 | (37.7172547740586, -122.405023648815) | 10 | 7 | 8 | 309 | 39 | |||
| 25023 | 176021 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 26 Ervine St | 8 | Front Yard : Yard | Tree | Private 2 | 5 | 6009620.69504 | 2089243.53702 | 37.7172080210075 | -122.408699581837 | (37.7172080210075, -122.408699581837) | 9 | 7 | 8 | 309 | 18 | ||||
| 8634 | 176044 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | 5990534.22824 | 2089263.30634 | 37.7161748133009 | -122.474673246391 | (37.7161748133009, -122.474673246391) | 1 | 8 | 4 | 64 | 14 | ||||
| 93668 | 176025 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 26 Ervine St | 5 | Front Yard : Yard | Tree | Private 2 | 15 | 6009634.04356 | 2089276.35677 | 37.7172988849001 | -122.408655756084 | (37.7172988849001, -122.408655756084) | 9 | 7 | 8 | 309 | 18 | ||||
| 179912 | 176053 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | 5989219.15665 | 2089312.55172 | 37.7162337395604 | -122.479222313162 | (37.7162337395604, -122.479222313162) | 1 | 8 | 4 | 64 | 14 | ||||
| 24640 | 176024 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 26 Ervine St | 3 | Front Yard : Yard | Tree | Private 2 | 25 | 6009648.36238 | 2089313.42999 | 37.7174014822691 | -122.40860887622 | (37.7174014822691, -122.40860887622) | 9 | 7 | 8 | 309 | 18 | ||||
| 58195 | 176054 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 5989245.31981 | 2089315.24778 | 37.7162426617475 | -122.479132078791 | (37.7162426617475, -122.479132078791) | 1 | 8 | 4 | 64 | 14 | ||||
| 128723 | 176023 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 26 Ervine St | 2 | Front Yard : Yard | Tree | Private 2 | 22 | 6009654.67743 | 2089334.90979 | 37.7174608150493 | -122.40858856232 | (37.7174608150493, -122.40858856232) | 9 | 7 | 8 | 309 | 18 | ||||
| 155164 | 176057 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5989281.98257 | 2089351.51723 | 37.7163443777799 | -122.479008007435 | (37.7163443777799, -122.479008007435) | 1 | 8 | 4 | 64 | 14 | ||||
| 187312 | 176022 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 26 Ervine St | 1 | Front Yard : Yard | Tree | Private 2 | 16 | 6009662.72679 | 2089352.75305 | 37.7175102597674 | -122.408561997261 | (37.7175102597674, -122.408561997261) | 9 | 7 | 8 | 309 | 18 | ||||
| 147050 | 176056 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 5989277.71826 | 2089365.90518 | 37.7163836358725 | -122.479023798614 | (37.7163836358725, -122.479023798614) | 1 | 8 | 4 | 64 | 14 | ||||
| 151595 | 103669 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 20 Rutland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2016 12:00:00 AM | 3 | 3x3 | 6010632.36965 | 2089377.76421 | 37.7176331925972 | -122.405212129663 | (37.7176331925972, -122.405212129663) | 10 | 7 | 8 | 309 | 39 | ||
| 155266 | 176055 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 5989270.85841 | 2089380.99818 | 37.7164246791237 | -122.479048612712 | (37.7164246791237, -122.479048612712) | 1 | 8 | 4 | 64 | 14 | ||||
| 54735 | 176050 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989206.75613 | 2089405.10082 | 37.7164871361381 | -122.47927194137 | (37.7164871361381, -122.47927194137) | 1 | 8 | 4 | 64 | 14 | ||||
| 106648 | 176051 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | 5989218.52603 | 2089406.15184 | 37.7164907055632 | -122.479231336085 | (37.7164907055632, -122.479231336085) | 1 | 8 | 4 | 64 | 14 | ||||
| 37254 | 176052 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 5989234.20998 | 2089407.11974 | 37.7164942740645 | -122.47917719598 | (37.7164942740645, -122.47917719598) | 1 | 8 | 4 | 64 | 14 | ||||
| 86770 | 176059 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 265 Ottawa Ave | 1 | Front Yard : Yard | Tree | Private 2 | 20 | 5998208.53283 | 2089432.61356 | 37.7170813919775 | -122.448159469808 | (37.7170813919775, -122.448159469808) | 9 | 7 | 6 | 28861 | 25 | ||||
| 182033 | 176049 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5989054.79394 | 2089564.29309 | 37.716915411303 | -122.479808833919 | (37.716915411303, -122.479808833919) | 1 | 8 | 4 | 64 | 14 | ||||
| 88918 | 176045 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5990157.58815 | 2089581.85402 | 37.7170276349961 | -122.475998332672 | (37.7170276349961, -122.475998332672) | 1 | 8 | 4 | 64 | 14 | ||||
| 68726 | 176047 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 5988958.7133 | 2089588.42281 | 37.7169760831658 | -122.480142699133 | (37.7169760831658, -122.480142699133) | 1 | 8 | 4 | 64 | 14 | ||||
| 31724 | 24412 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1199X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/23/1995 12:00:00 AM | 12 | 3x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | ||
| 34452 | 11772 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1199X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/23/1995 12:00:00 AM | 12 | 3x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | ||
| 57719 | 11785 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1199X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
| 83353 | 24460 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1199X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/22/1995 12:00:00 AM | 6 | 3x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | ||
| 134137 | 24414 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1199X Junipero Serra Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/23/1995 12:00:00 AM | 12 | 3x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | ||
| 176383 | 11790 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1199X Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
| 193977 | 24413 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1199X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/22/1995 12:00:00 AM | 6 | 3x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | ||
| 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 | ||||
| 101312 | 176046 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 5990073.98867 | 2089647.08481 | 37.7172018948419 | -122.47629205486 | (37.7172018948419, -122.47629205486) | 1 | 8 | 4 | 64 | 14 | ||||
| 174054 | 212249 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1111 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | Width 4ft | 5991209.84448 | 2089782.7559 | 37.7176402198878 | -122.472375861652 | (37.7176402198878, -122.472375861652) | 9 | 8 | 6 | 64 | 24 | |||
| 120897 | 206313 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 431 Lakeview Ave | 3 | : | Tree | Private 2 | 13 | Width 3ft | 5996540.85431 | 2089794.08161 | 37.7179784216475 | -122.453949894167 | (37.7179784216475, -122.453949894167) | 9 | 8 | 6 | 28861 | 24 | |||
| 65602 | 212292 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 2 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 5991164.37326 | 2089829.54432 | 37.7177660575462 | -122.472536442798 | (37.7177660575462, -122.472536442798) | 9 | 8 | 4 | 64 | 24 | |||
| 79421 | 29636 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1110X Junipero Serra Blvd | 9 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990451 | 2089843.5367701 | 37.717801208369 | -122.47273266668 | (37.717801208369, -122.47273266668) | 9 | 8 | 4 | 64 | 40 | ||
| 95248 | 29632 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1110X Junipero Serra Blvd | 5 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991107.8990451 | 2089843.5367701 | 37.717801208369 | -122.47273266668 | (37.717801208369, -122.47273266668) | 9 | 8 | 4 | 64 | 40 | ||
| 106333 | 29635 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1110X Junipero Serra Blvd | 8 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991107.8990451 | 2089843.5367701 | 37.717801208369 | -122.47273266668 | (37.717801208369, -122.47273266668) | 9 | 8 | 4 | 64 | 40 | ||
| 106785 | 29629 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1110X Junipero Serra Blvd | 2 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990451 | 2089843.5367701 | 37.717801208369 | -122.47273266668 | (37.717801208369, -122.47273266668) | 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) );