Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 92394 | 92394 | 115737 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 9x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776557 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 85354 | 85354 | 116746 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 9x BLANKEN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011671.0 | 2087411.0 | 37.71229086541071 | -122.40148388608 | (37.7122908654107, -122.40148388608) | ||||
| 88764 | 88764 | 116749 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 9x BLANKEN AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011671.0 | 2087411.0 | 37.71229086541071 | -122.40148388608 | (37.7122908654107, -122.40148388608) | ||||
| 108617 | 108617 | 116747 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 9x BLANKEN AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011671.0 | 2087411.0 | 37.71229086541071 | -122.40148388608 | (37.7122908654107, -122.40148388608) | ||||
| 120023 | 120023 | 116748 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 9x BLANKEN AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011671.0 | 2087411.0 | 37.71229086541071 | -122.40148388608 | (37.7122908654107, -122.40148388608) | ||||
| 72210 | 72210 | 16475 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 9X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
| 90238 | 90238 | 16471 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 9X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
| 96388 | 96388 | 16476 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 9X Newhall St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
| 115131 | 115131 | 16473 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 9X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
| 118199 | 118199 | 16470 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 9X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
| 140227 | 140227 | 16472 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 9X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
| 142877 | 142877 | 16478 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 9X Newhall St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/16/1997 12:00:00 AM | 6 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | ||
| 96198 | 96198 | 13301 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 9X Lyell St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6003085.685949201 | 2094681.4720202 | 37.7317711908882 | -122.43167603243099 | (37.7317711908882, -122.431676032431) | |||
| 138487 | 138487 | 13304 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 9X Lyell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6003085.685949201 | 2094681.4720202 | 37.7317711908882 | -122.43167603243099 | (37.7317711908882, -122.431676032431) | |||
| 141679 | 141679 | 13302 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 9X Lyell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 6003085.685949201 | 2094681.4720202 | 37.7317711908882 | -122.43167603243099 | (37.7317711908882, -122.431676032431) | |||
| 142098 | 142098 | 13303 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 9X Lyell St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 15 | 6003085.685949201 | 2094681.4720202 | 37.7317711908882 | -122.43167603243099 | (37.7317711908882, -122.431676032431) | |||
| 97285 | 97285 | 102172 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 9X Hattie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621.0 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) |
| 143029 | 143029 | 102171 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 9X Hattie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621.0 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) |
| 23018 | 23018 | 12977 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 9X Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/1990 12:00:00 AM | 4 | 3X3 | 6002070.87849 | 2108590.79545 | 37.7699053099025 | -122.436179442539 | (37.7699053099025, -122.436179442539) | ||
| 139866 | 139866 | 115801 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 9M CAIRE TER | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6012720.0 | 2101959.0 | 37.7522951385919 | -122.398878598484 | (37.7522951385919, -122.398878598484) | |||||
| 81662 | 81662 | 115444 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 99x Vandewater St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | ||||
| 97297 | 97297 | 115442 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 99x Vandewater St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | ||||
| 112326 | 112326 | 115441 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 99x Vandewater St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | ||||
| 113661 | 113661 | 115440 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 99x Vandewater St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | ||||
| 115493 | 115493 | 115443 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 99x Vandewater St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | ||||
| 2733 | 2733 | 253189 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
| 2735 | 2735 | 253188 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
| 2737 | 2737 | 253186 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
| 2738 | 2738 | 253184 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
| 2739 | 2739 | 253185 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
| 2741 | 2741 | 253190 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
| 2744 | 2744 | 253187 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
| 77511 | 77511 | 121374 | Undocumented 2 | Palm (unknown Genus) :: Palm Spp 161 | 99x Santa Marina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006202.0 | 2097575.0 | 37.73989232614821 | -122.421107660096 | (37.7398923261482, -122.421107660096) | ||||
| 98900 | 98900 | 121373 | Undocumented 2 | Palm (unknown Genus) :: Palm Spp 161 | 99x Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006202.0 | 2097575.0 | 37.73989232614821 | -122.421107660096 | (37.7398923261482, -122.421107660096) | ||||
| 109131 | 109131 | 121376 | Undocumented 2 | Palm (unknown Genus) :: Palm Spp 161 | 99x Santa Marina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006202.0 | 2097575.0 | 37.73989232614821 | -122.421107660096 | (37.7398923261482, -122.421107660096) | ||||
| 120908 | 120908 | 121375 | Undocumented 2 | Palm (unknown Genus) :: Palm Spp 161 | 99x Santa Marina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006202.0 | 2097575.0 | 37.73989232614821 | -122.421107660096 | (37.7398923261482, -122.421107660096) | ||||
| 41263 | 41263 | 218719 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x San Marcos Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5993701.46816 | 2100309.93296 | 37.7466891448909 | -122.464527467374 | (37.7466891448909, -122.464527467374) | |||
| 42882 | 42882 | 211250 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 33 | Width 5ft | 5993746.09289 | 2100276.06203 | 37.7465987162755 | -122.464370702046 | (37.7465987162755, -122.464370702046) | |||
| 43117 | 43117 | 219165 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 5993760.22324 | 2100276.5052799997 | 37.7466007478231 | -122.46432187335199 | (37.7466007478231, -122.464321873352) | |||
| 44102 | 44102 | 209213 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 5993777.82606 | 2100247.64237 | 37.7465225122089 | -122.46425891004101 | (37.7465225122089, -122.464258910041) | |||
| 47921 | 47921 | 211249 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 5ft | 5993726.26019 | 2100287.2096700002 | 37.74662818164779 | -122.464440090141 | (37.7466281816478, -122.464440090141) | |||
| 56613 | 56613 | 211254 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 31 | Width 5ft | 5993790.37609 | 2100225.91603 | 37.7464635805444 | -122.46421393671899 | (37.7464635805444, -122.464213936719) | |||
| 60137 | 60137 | 209212 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 5993771.94389 | 2100232.96399 | 37.746481870051106 | -122.4642781843 | (37.7464818700511, -122.4642781843) | |||
| 60262 | 60262 | 219167 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 5993768.02883 | 2100241.187 | 37.7465042226907 | -122.464292318936 | (37.7465042226907, -122.464292318936) | |||
| 61181 | 61181 | 211251 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 5993753.32003 | 2100266.28903 | 37.746572298679794 | -122.464345002125 | (37.7465722986798, -122.464345002125) | |||
| 74481 | 74481 | 218721 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x San Marcos Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 5993716.07745 | 2100297.78462 | 37.746656630797794 | -122.464476068412 | (37.7466566307978, -122.464476068412) | |||
| 75541 | 75541 | 209208 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 5993802.83706 | 2100253.03783 | 37.7465387683529 | -122.46417281704399 | (37.7465387683529, -122.464172817044) | |||
| 76824 | 76824 | 219162 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 5ft | 5993732.15666 | 2100284.86554 | 37.74662208515711 | -122.46441953075501 | (37.7466220851571, -122.464419530755) | |||
| 123719 | 123719 | 209209 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 5993795.21392 | 2100243.94669 | 37.746513367011 | -122.464198516942 | (37.746513367011, -122.464198516942) | |||
| 134757 | 134757 | 209210 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 5993788.41941 | 2100238.90873 | 37.746499142429705 | -122.464221645739 | (37.7464991424297, -122.464221645739) | |||
| 147824 | 147824 | 218720 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x San Marcos Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5993709.38363 | 2100297.55504 | 37.746655614559295 | -122.464499198102 | (37.7466556145593, -122.464499198102) | |||
| 153512 | 153512 | 219166 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 5993758.91368 | 2100249.51951 | 37.7465265762511 | -122.46432444273 | (37.7465265762511, -122.46432444273) | |||
| 154163 | 154163 | 219163 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 5ft | 5993739.16637 | 2100264.73593 | 37.746567218412 | -122.46439383083599 | (37.746567218412, -122.464393830836) | |||
| 156535 | 156535 | 219164 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 5ft | 5993746.9601 | 2100281.9643 | 37.7466149724013 | -122.464368131807 | (37.7466149724013, -122.464368131807) | |||
| 157795 | 157795 | 209207 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 5993815.86849 | 2100254.24474 | 37.7465428332992 | -122.46412784372801 | (37.7465428332992, -122.464127843728) | |||
| 160858 | 160858 | 211253 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | Width 5ft | 5993783.32 | 2100243.82658 | 37.7465123516796 | -122.46423963577 | (37.7465123516796, -122.46423963577) | |||
| 178018 | 178018 | 209211 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 5993782.2667 | 2100229.04683 | 37.7464717095186 | -122.46424220511601 | (37.7464717095186, -122.464242205116) | |||
| 184665 | 184665 | 211252 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 5ft | 5993772.95985 | 2100263.65639 | 37.7465662021668 | -122.464276899165 | (37.7465662021668, -122.464276899165) | |||
| 144546 | 144546 | 33745 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x SAN JOSE AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 10 | 4x4 | Permit Number 37802 | 6006338.0 | 2102697.0 | 37.7539638411405 | -122.421001003808 | (37.7539638411405, -122.421001003808) | |
| 166 | 166 | 251230 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99x Ogden Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007537.0 | 2096150.0 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | ||||
| 167 | 167 | 251232 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99x Ogden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007537.0 | 2096150.0 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | ||||
| 3258 | 3258 | 253374 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99x Ogden Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007537.0 | 2096150.0 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | ||||
| 129004 | 129004 | 108871 | Property Tree 7 | Tree(s) :: 17 | 99x OAKWOOD ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6005305.0 | 2104962.0 | 37.760124716943295 | -122.424734485609 | (37.7601247169433, -122.424734485609) | |||||
| 1384 | 1384 | 251515 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99x Mountview Ct | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997620.0 | 2100449.0 | 37.7472961010623 | -122.450987675073 | (37.7472961010623, -122.450987675073) | ||||
| 1409 | 1409 | 251514 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99x Mountview Ct | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997620.0 | 2100449.0 | 37.7472961010623 | -122.450987675073 | (37.7472961010623, -122.450987675073) | ||||
| 13137 | 13137 | 13326 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6011657.72731 | 2090650.48596 | 37.72118509918629 | -122.40175732193799 | (37.7211850991863, -122.401757321938) | |||
| 93628 | 93628 | 13325 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 99x Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/10/1992 12:00:00 AM | 12 | 4x9 | 6004718.9472012 | 2089729.3577775 | 37.7182662183542 | -122.42567717675699 | (37.7182662183542, -122.425677176757) | ||
| 9827 | 9827 | 173704 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5997184.0 | 2089426.0 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | |||
| 9830 | 9830 | 60472 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1982 12:00:00 AM | 3x3 | Permit Number 20066 | 5997184.0 | 2089426.0 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | |
| 65538 | 65538 | 110519 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 99x JULIAN AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6006400.0 | 2107588.0 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | |||
| 95125 | 95125 | 110520 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 99x JULIAN AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6006400.0 | 2107588.0 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | |||
| 113014 | 113014 | 110518 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 99x JULIAN AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6006400.0 | 2107588.0 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | |||
| 114259 | 114259 | 110522 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 99x JULIAN AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6006400.0 | 2107588.0 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | |||
| 114942 | 114942 | 110521 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 99x JULIAN AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6006400.0 | 2107588.0 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | |||
| 115187 | 115187 | 110517 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 99x JULIAN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6006400.0 | 2107588.0 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | |||
| 53479 | 53479 | 108406 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 12 | 3x3 | Permit Number 773269 | 6008120.84483 | 2112658.906 | 37.7814172463574 | -122.41554073723302 | (37.7814172463574, -122.415540737233) | |
| 135927 | 135927 | 108405 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 11 | 3x3 | Permit Number 773269 | 6008118.29339 | 2112682.65315 | 37.7814823069089 | -122.41555124581001 | (37.7814823069089, -122.41555124581) | |
| 151164 | 151164 | 108408 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 11 | 3x3 | Permit Number 773269 | 6008126.98045 | 2112612.39837 | 37.7812898924571 | -122.41551621722601 | (37.7812898924571, -122.415516217226) | |
| 170033 | 170033 | 108407 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 12 | 3x3 | Permit Number 773269 | 6008123.88182 | 2112634.14044 | 37.7813494167874 | -122.415528476779 | (37.7813494167874, -122.415528476779) | |
| 182575 | 182575 | 108410 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 10 | 3x3 | Permit Number 773269 | 6008131.8663 | 2112579.02445 | 37.781198530314995 | -122.41549695101801 | (37.781198530315, -122.415496951018) | |
| 184627 | 184627 | 108409 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 13 | 3x3 | Permit Number 773269 | 6008129.59407 | 2112591.6747 | 37.78123313714521 | -122.41550570771601 | (37.7812331371452, -122.415505707716) | |
| 88315 | 88315 | 108412 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 99x HYDE ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | ||
| 92393 | 92393 | 108411 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 99x HYDE ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | ||
| 107281 | 107281 | 108413 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 99x HYDE ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | ||
| 112409 | 112409 | 108414 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 99x HYDE ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | ||
| 91188 | 91188 | 111312 | Undocumented 2 | Acacia spp :: Acacia Spp 176 | 99x GILROY ST | 3 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 30x30 | 6015277.0 | 2088666.0 | 37.7159373992527 | -122.389107938034 | (37.7159373992527, -122.389107938034) | ||||
| 96975 | 96975 | 111311 | Undocumented 2 | Acacia spp :: Acacia Spp 176 | 99x GILROY ST | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 30x30 | 6015277.0 | 2088666.0 | 37.7159373992527 | -122.389107938034 | (37.7159373992527, -122.389107938034) | ||||
| 123880 | 123880 | 111310 | Undocumented 2 | Acacia spp :: Acacia Spp 176 | 99x GILROY ST | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 30x30 | 6015277.0 | 2088666.0 | 37.7159373992527 | -122.389107938034 | (37.7159373992527, -122.389107938034) | ||||
| 49231 | 49231 | 114226 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 79797 | 79797 | 114240 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 99x FONT BLVD | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | |||||
| 80545 | 80545 | 114228 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 86013 | 86013 | 114235 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 105010 | 105010 | 114230 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 105245 | 105245 | 114225 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 99x FONT BLVD | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 48 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 105541 | 105541 | 114227 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 112189 | 112189 | 114231 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 117729 | 117729 | 114237 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 125709 | 125709 | 114234 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 128194 | 128194 | 114232 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 128290 | 128290 | 114229 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");