trees
194,517 rows sorted by qAddress descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 83163 | 115737 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 9x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776557 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
| 59876 | 116749 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
| 62277 | 116746 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
| 131415 | 116747 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
| 156017 | 116748 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
| 6868 | 16475 | DPW Maintained 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 9X Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018697.2048701 | 2097076.1109207 | 37.7392189485182 | -122.377869364283 | (37.7392189485182, -122.377869364283) | 10 | 3 | 8 | 58 | 1 | |||
| 75289 | 16471 | Permitted Site 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 9X Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6018697.2048701 | 2097076.1109207 | 37.7392189485182 | -122.377869364283 | (37.7392189485182, -122.377869364283) | 10 | 3 | 8 | 58 | 1 | |||
| 81962 | 16476 | Permitted Site 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 9X Newhall St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6018697.2048701 | 2097076.1109207 | 37.7392189485182 | -122.377869364283 | (37.7392189485182, -122.377869364283) | 10 | 3 | 8 | 58 | 1 | |||
| 144005 | 16473 | DPW Maintained 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 9X Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018697.2048701 | 2097076.1109207 | 37.7392189485182 | -122.377869364283 | (37.7392189485182, -122.377869364283) | 10 | 3 | 8 | 58 | 1 | |||
| 169023 | 16470 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 9X Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018697.2048701 | 2097076.1109207 | 37.7392189485182 | -122.377869364283 | (37.7392189485182, -122.377869364283) | 10 | 3 | 8 | 58 | 1 | |||
| 186720 | 16472 | DPW Maintained 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 9X Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018697.2048701 | 2097076.1109207 | 37.7392189485182 | -122.377869364283 | (37.7392189485182, -122.377869364283) | 10 | 3 | 8 | 58 | 1 | |||
| 187750 | 16478 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 9X Newhall St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/16/1997 12:00:00 AM | 6 | 3X3 | 6018697.2048701 | 2097076.1109207 | 37.7392189485182 | -122.377869364283 | (37.7392189485182, -122.377869364283) | 10 | 3 | 8 | 58 | 1 | ||
| 80686 | 13301 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 9X Lyell St | 1 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6003085.6859492 | 2094681.4720202 | 37.7317711908882 | -122.431676032431 | (37.7317711908882, -122.431676032431) | 9 | 7 | 5 | 28861 | 25 | |||
| 152150 | 13304 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 9X Lyell St | 4 | Median : Cutout | Tree | DPW 1 | 12 | 15 | 6003085.6859492 | 2094681.4720202 | 37.7317711908882 | -122.431676032431 | (37.7317711908882, -122.431676032431) | 9 | 7 | 5 | 28861 | 25 | |||
| 178562 | 13303 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 9X Lyell St | 3 | Median : Cutout | Tree | DPW 1 | 18 | 15 | 6003085.6859492 | 2094681.4720202 | 37.7317711908882 | -122.431676032431 | (37.7317711908882, -122.431676032431) | 9 | 7 | 5 | 28861 | 25 | |||
| 183101 | 13302 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 9X Lyell St | 2 | Median : Cutout | Tree | DPW 1 | 12 | 10 | 6003085.6859492 | 2094681.4720202 | 37.7317711908882 | -122.431676032431 | (37.7317711908882, -122.431676032431) | 9 | 7 | 5 | 28861 | 25 | |||
| 79494 | 102172 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 9X Hattie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) | 15 | 5 | 5 | 28862 | 3 |
| 187812 | 102171 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 9X Hattie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) | 15 | 5 | 5 | 28862 | 3 |
| 27484 | 12977 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 9X Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/1990 12:00:00 AM | 4 | 3X3 | 6002070.87849 | 2108590.79545 | 37.7699053099025 | -122.436179442539 | (37.7699053099025, -122.436179442539) | 15 | 5 | 5 | 29492 | 9 | ||
| 184600 | 115801 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 9M CAIRE TER | 1 | Front Yard : Yard | Tree | Private 2 | 6012720 | 2101959 | 37.7522951385919 | -122.398878598484 | (37.7522951385919, -122.398878598484) | 10 | 3 | 8 | 28856 | 29 | |||||
| 92681 | 115442 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
| 95648 | 115441 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
| 137554 | 115443 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
| 150284 | 115440 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
| 156023 | 115444 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
| 6306 | 237343 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007651 | 2096616 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | 2 | 7 | 7 | 28859 | 2 | |||
| 9376 | 237344 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007651 | 2096616 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | 2 | 7 | 7 | 28859 | 2 | |||
| 17067 | 223124 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 99x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007651 | 2096616 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | 2 | 7 | 7 | 28859 | 2 | |||
| 102059 | 253188 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99x The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014645 | 2117171 | 37.7941709756503 | -122.393285986986 | (37.7941709756503, -122.393285986986) | 12 | 2 | 10 | 28855 | 6 | ||||
| 108669 | 253189 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99x The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014645 | 2117171 | 37.7941709756503 | -122.393285986986 | (37.7941709756503, -122.393285986986) | 12 | 2 | 10 | 28855 | 6 | ||||
| 125960 | 253190 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99x The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014645 | 2117171 | 37.7941709756503 | -122.393285986986 | (37.7941709756503, -122.393285986986) | 12 | 2 | 10 | 28855 | 6 | ||||
| 144046 | 253187 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99x The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014645 | 2117171 | 37.7941709756503 | -122.393285986986 | (37.7941709756503, -122.393285986986) | 12 | 2 | 10 | 28855 | 6 | ||||
| 156585 | 253184 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99x The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014645 | 2117171 | 37.7941709756503 | -122.393285986986 | (37.7941709756503, -122.393285986986) | 12 | 2 | 10 | 28855 | 6 | ||||
| 160059 | 253185 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99x The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014645 | 2117171 | 37.7941709756503 | -122.393285986986 | (37.7941709756503, -122.393285986986) | 12 | 2 | 10 | 28855 | 6 | ||||
| 173231 | 253186 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99x The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014645 | 2117171 | 37.7941709756503 | -122.393285986986 | (37.7941709756503, -122.393285986986) | 12 | 2 | 10 | 28855 | 6 | ||||
| 4323 | 264887 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
| 12086 | 264891 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
| 13415 | 264888 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
| 15114 | 264890 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
| 17002 | 264889 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
| 18389 | 264893 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
| 27792 | 121374 | Undocumented 4 | Palm (unknown Genus) :: Palm Spp 273 | 99x Santa Marina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006202 | 2097575 | 37.7398923261482 | -122.421107660096 | (37.7398923261482, -122.421107660096) | 2 | 7 | 7 | 28859 | 2 | ||||
| 107285 | 121373 | Undocumented 4 | Palm (unknown Genus) :: Palm Spp 273 | 99x Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006202 | 2097575 | 37.7398923261482 | -122.421107660096 | (37.7398923261482, -122.421107660096) | 2 | 7 | 7 | 28859 | 2 | ||||
| 124117 | 121376 | Undocumented 4 | Palm (unknown Genus) :: Palm Spp 273 | 99x Santa Marina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006202 | 2097575 | 37.7398923261482 | -122.421107660096 | (37.7398923261482, -122.421107660096) | 2 | 7 | 7 | 28859 | 2 | ||||
| 155774 | 121375 | Undocumented 4 | Palm (unknown Genus) :: Palm Spp 273 | 99x Santa Marina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006202 | 2097575 | 37.7398923261482 | -122.421107660096 | (37.7398923261482, -122.421107660096) | 2 | 7 | 7 | 28859 | 2 | ||||
| 38731 | 218719 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Marcos Ave | 1 | Median : Cutout | Tree | DPW 1 | 5 | Width 5ft | 5993701.46816 | 2100309.93296 | 37.7466891448909 | -122.464527467374 | (37.7466891448909, -122.464527467374) | 1 | 8 | 4 | 29491 | 40 | |||
| 39244 | 209213 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 99x San Marcos Ave | 23 | Median : Cutout | Tree | DPW 1 | 2 | Width 5ft | 5993777.82606 | 2100247.64237 | 37.7465225122089 | -122.464258910041 | (37.7465225122089, -122.464258910041) | 1 | 8 | 4 | 29491 | 40 | |||
| 40694 | 211249 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 99x San Marcos Ave | 4 | Median : Cutout | Tree | DPW 1 | 23 | Width 5ft | 5993726.26019 | 2100287.20967 | 37.7466281816478 | -122.464440090141 | (37.7466281816478, -122.464440090141) | 1 | 8 | 4 | 29491 | 40 | |||
| 40877 | 211250 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 99x San Marcos Ave | 9 | Median : Cutout | Tree | DPW 1 | 33 | Width 5ft | 5993746.09289 | 2100276.06203 | 37.7465987162755 | -122.464370702046 | (37.7465987162755, -122.464370702046) | 1 | 8 | 4 | 29491 | 40 | |||
| 55816 | 219165 | DPW Maintained 1 | Hakea suaveolens :: Sweet Hakea Tree 73 | 99x San Marcos Ave | 8 | Median : Cutout | Tree | DPW 1 | 7 | Width 5ft | 5993760.22324 | 2100276.50528 | 37.7466007478231 | -122.464321873352 | (37.7466007478231, -122.464321873352) | 1 | 8 | 4 | 29491 | 40 | |||
| 64350 | 211254 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 99x San Marcos Ave | 15 | Median : Cutout | Tree | DPW 1 | 31 | Width 5ft | 5993790.37609 | 2100225.91603 | 37.7464635805444 | -122.464213936719 | (37.7464635805444, -122.464213936719) | 1 | 8 | 4 | 29491 | 40 | |||
| 69629 | 219167 | DPW Maintained 1 | Hakea suaveolens :: Sweet Hakea Tree 73 | 99x San Marcos Ave | 13 | Median : Cutout | Tree | DPW 1 | 8 | Width 5ft | 5993768.02883 | 2100241.187 | 37.7465042226907 | -122.464292318936 | (37.7465042226907, -122.464292318936) | 1 | 8 | 4 | 29491 | 40 | |||
| 72058 | 209212 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 99x San Marcos Ave | 22 | Median : Cutout | Tree | DPW 1 | 2 | Width 5ft | 5993771.94389 | 2100232.96399 | 37.7464818700511 | -122.4642781843 | (37.7464818700511, -122.4642781843) | 1 | 8 | 4 | 29491 | 40 | |||
| 75444 | 211251 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 99x San Marcos Ave | 10 | Median : Cutout | Tree | DPW 1 | 14 | Width 5ft | 5993753.32003 | 2100266.28903 | 37.7465722986798 | -122.464345002125 | (37.7465722986798, -122.464345002125) | 1 | 8 | 4 | 29491 | 40 | |||
| 98701 | 218721 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Marcos Ave | 3 | Median : Cutout | Tree | DPW 1 | 7 | Width 5ft | 5993716.07745 | 2100297.78462 | 37.7466566307978 | -122.464476068412 | (37.7466566307978, -122.464476068412) | 1 | 8 | 4 | 29491 | 40 | |||
| 102337 | 219162 | DPW Maintained 1 | Hakea suaveolens :: Sweet Hakea Tree 73 | 99x San Marcos Ave | 5 | Median : Cutout | Tree | DPW 1 | 6 | Width 5ft | 5993732.15666 | 2100284.86554 | 37.7466220851571 | -122.464419530755 | (37.7466220851571, -122.464419530755) | 1 | 8 | 4 | 29491 | 40 | |||
| 103292 | 209210 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 99x San Marcos Ave | 20 | Median : Cutout | Tree | DPW 1 | 1 | Width 5ft | 5993788.41941 | 2100238.90873 | 37.7464991424297 | -122.464221645739 | (37.7464991424297, -122.464221645739) | 1 | 8 | 4 | 29491 | 40 | |||
| 109445 | 209209 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 99x San Marcos Ave | 19 | Median : Cutout | Tree | DPW 1 | 3 | Width 5ft | 5993795.21392 | 2100243.94669 | 37.746513367011 | -122.464198516942 | (37.746513367011, -122.464198516942) | 1 | 8 | 4 | 29491 | 40 | |||
| 112437 | 209208 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 99x San Marcos Ave | 18 | Median : Cutout | Tree | DPW 1 | 3 | Width 5ft | 5993802.83706 | 2100253.03783 | 37.7465387683529 | -122.464172817044 | (37.7465387683529, -122.464172817044) | 1 | 8 | 4 | 29491 | 40 | |||
| 115311 | 219166 | DPW Maintained 1 | Hakea suaveolens :: Sweet Hakea Tree 73 | 99x San Marcos Ave | 12 | Median : Cutout | Tree | DPW 1 | 8 | Width 5ft | 5993758.91368 | 2100249.51951 | 37.7465265762511 | -122.46432444273 | (37.7465265762511, -122.46432444273) | 1 | 8 | 4 | 29491 | 40 | |||
| 131893 | 218720 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Marcos Ave | 2 | Median : Cutout | Tree | DPW 1 | 5 | Width 5ft | 5993709.38363 | 2100297.55504 | 37.7466556145593 | -122.464499198102 | (37.7466556145593, -122.464499198102) | 1 | 8 | 4 | 29491 | 40 | |||
| 141325 | 209207 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 99x San Marcos Ave | 17 | Median : Cutout | Tree | DPW 1 | 3 | Width 5ft | 5993815.86849 | 2100254.24474 | 37.7465428332992 | -122.464127843728 | (37.7465428332992, -122.464127843728) | 1 | 8 | 4 | 29491 | 40 | |||
| 142182 | 211253 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 99x San Marcos Ave | 14 | Median : Cutout | Tree | DPW 1 | 25 | Width 5ft | 5993783.32 | 2100243.82658 | 37.7465123516796 | -122.46423963577 | (37.7465123516796, -122.46423963577) | 1 | 8 | 4 | 29491 | 40 | |||
| 147688 | 219164 | DPW Maintained 1 | Hakea suaveolens :: Sweet Hakea Tree 73 | 99x San Marcos Ave | 7 | Median : Cutout | Tree | DPW 1 | 6 | Width 5ft | 5993746.9601 | 2100281.9643 | 37.7466149724013 | -122.464368131807 | (37.7466149724013, -122.464368131807) | 1 | 8 | 4 | 29491 | 40 | |||
| 151160 | 219163 | DPW Maintained 1 | Hakea suaveolens :: Sweet Hakea Tree 73 | 99x San Marcos Ave | 6 | Median : Cutout | Tree | DPW 1 | 6 | Width 5ft | 5993739.16637 | 2100264.73593 | 37.746567218412 | -122.464393830836 | (37.746567218412, -122.464393830836) | 1 | 8 | 4 | 29491 | 40 | |||
| 170757 | 211252 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 99x San Marcos Ave | 11 | Median : Cutout | Tree | DPW 1 | 28 | Width 5ft | 5993772.95985 | 2100263.65639 | 37.7465662021668 | -122.464276899165 | (37.7465662021668, -122.464276899165) | 1 | 8 | 4 | 29491 | 40 | |||
| 179289 | 209211 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 99x San Marcos Ave | 21 | Median : Cutout | Tree | DPW 1 | 2 | Width 5ft | 5993782.2667 | 2100229.04683 | 37.7464717095186 | -122.464242205116 | (37.7464717095186, -122.464242205116) | 1 | 8 | 4 | 29491 | 40 | |||
| 4098 | 242321 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2019 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006210.72103 | 2102654.46682 | 37.7538398793324 | -122.421438144967 | (37.7538398793324, -122.421438144967) | 2 | 4 | 5 | 28859 | 19 | |
| 98555 | 242320 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Jose Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006209.1521 | 2102634.3543 | 37.75378456653 | -122.421442142453 | (37.75378456653, -122.421442142453) | 2 | 4 | 5 | 28859 | 19 | |||
| 178712 | 33745 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x SAN JOSE AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/1996 12:00:00 AM | 10 | 4x4 | Permit Number 37802 | 6006338 | 2102697 | 37.7539638411405 | -122.421001003808 | (37.7539638411405, -122.421001003808) | 2 | 4 | 5 | 28859 | 19 | |
| 78499 | 255416 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99x Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6007395 | 2111066 | 37.7770026839515 | -122.417938862064 | (37.7770026839515, -122.417938862064) | 7 | 9 | 9 | 28852 | 36 | ||
| 126056 | 255417 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99x Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6007395 | 2111066 | 37.7770026839515 | -122.417938862064 | (37.7770026839515, -122.417938862064) | 7 | 9 | 9 | 28852 | 36 | ||
| 9825 | 259868 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 99x Peabody St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 15935 | 259870 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 99x Peabody St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 17026 | 259869 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 99x Peabody St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 35312 | 251230 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99x Ogden Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007537 | 2096150 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | 2 | 7 | 7 | 28859 | 2 | ||||
| 116313 | 253374 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99x Ogden Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007537 | 2096150 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | 2 | 7 | 7 | 28859 | 2 | ||||
| 153759 | 251232 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99x Ogden Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007537 | 2096150 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | 2 | 7 | 7 | 28859 | 2 | ||||
| 1153 | 223389 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
| 1161 | 223387 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
| 12094 | 223388 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
| 32266 | 108871 | Property Tree 8 | Tree(s) :: 17 | 99x OAKWOOD ST | 1 | Back Yard : Yard | Tree | Private 2 | 6005305 | 2104962 | 37.7601247169433 | -122.424734485609 | (37.7601247169433, -122.424734485609) | 2 | 4 | 5 | 28859 | 19 | |||||
| 6519 | 251515 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99x Mountview Ct | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997620 | 2100449 | 37.7472961010623 | -122.450987675073 | (37.7472961010623, -122.450987675073) | 1 | 5 | 4 | 63 | 38 | ||||
| 109594 | 251514 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99x Mountview Ct | 2 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997620 | 2100449 | 37.7472961010623 | -122.450987675073 | (37.7472961010623, -122.450987675073) | 1 | 5 | 4 | 63 | 38 | ||||
| 78678 | 13325 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 99x Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/1992 12:00:00 AM | 12 | 4x9 | 6004718.9472012 | 2089729.3577775 | 37.7182662183542 | -122.425677176757 | (37.7182662183542, -122.425677176757) | 9 | 7 | 6 | 309 | 18 | ||
| 180102 | 13326 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6011657.72731 | 2090650.48596 | 37.7211850991863 | -122.401757321938 | (37.7211850991863, -122.401757321938) | 10 | 7 | 8 | 309 | 28 | |||
| 23573 | 60472 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | 3x3 | Permit Number 20066 | 5997184 | 2089426 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | 9 | 8 | 6 | 28861 | 24 | |
| 157055 | 173704 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5997184 | 2089426 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | 9 | 8 | 6 | 28861 | 24 | |||
| 17186 | 110519 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
| 92925 | 110520 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
| 136878 | 110521 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
| 139612 | 110517 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
| 149801 | 110518 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
| 150794 | 110522 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
| 24037 | 108406 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 12 | 3x3 | Permit Number 773269 | 6008120.84483 | 2112658.906 | 37.7814172463574 | -122.415540737233 | (37.7814172463574, -122.415540737233) | 7 | 10 | 9 | 28852 | 36 | |
| 47186 | 108408 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 11 | 3x3 | Permit Number 773269 | 6008126.98045 | 2112612.39837 | 37.7812898924571 | -122.415516217226 | (37.7812898924571, -122.415516217226) | 7 | 10 | 9 | 28852 | 36 | |
| 84973 | 108407 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 12 | 3x3 | Permit Number 773269 | 6008123.88182 | 2112634.14044 | 37.7813494167874 | -122.415528476779 | (37.7813494167874, -122.415528476779) | 7 | 10 | 9 | 28852 | 36 | |
| 114952 | 108409 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 13 | 3x3 | Permit Number 773269 | 6008129.59407 | 2112591.6747 | 37.7812331371452 | -122.415505707716 | (37.7812331371452, -122.415505707716) | 7 | 10 | 9 | 28852 | 36 | |
| 137011 | 108405 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 11 | 3x3 | Permit Number 773269 | 6008118.29339 | 2112682.65315 | 37.7814823069089 | -122.41555124581 | (37.7814823069089, -122.41555124581) | 7 | 10 | 9 | 28852 | 36 | |
| 149589 | 108410 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 10 | 3x3 | Permit Number 773269 | 6008131.8663 | 2112579.02445 | 37.781198530315 | -122.415496951018 | (37.781198530315, -122.415496951018) | 7 | 10 | 9 | 28852 | 36 |
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) );