trees
194,517 rows sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87 | 259654 | DPW Maintained 1 | :: 45 | 101x Cora St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 90 | 259864 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1398x Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | |||||||||||||
| 99 | 255073 | Private 9 | Tree(s) :: 17 | 173R Glenview Dr | Back Yard : Yard | Tree | Private 2 | ||||||||||||||||
| 162 | 105806 | Undocumented 4 | Tree(s) :: 17 | 1248X ANZA ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x3 | 5994834 | 2112130 | 37.7792092085373 | -122.461468091676 | (37.7792092085373, -122.461468091676) | 11 | 6 | 2 | 54 | 11 | |||||
| 165 | 104843 | Permitted Site 7 | :: 45 | 1320 21st Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5989622 | 2106334.7 | 37.7629955389606 | -122.479074319647 | (37.7629955389606, -122.479074319647) | 1 | 8 | 3 | 56 | 35 | ||||||
| 170 | 108637 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 15 TUCKER AVE | Back Yard : Yard | Tree | Private 2 | 6011049.2 | 2088423.2 | 37.7150354478954 | -122.403704200211 | (37.7150354478954, -122.403704200211) | 9 | 7 | 8 | 309 | 39 | ||||||
| 227 | 102275 | Property Tree 8 | Tree(s) :: 17 | 267 Topaz Way | Back Yard : Yard | Landscaping | Private 2 | 6001225.6 | 2097744.2 | 37.7400751189117 | -122.438326054857 | (37.7400751189117, -122.438326054857) | 2 | 7 | 5 | 63 | 7 | ||||||
| 361 | 107141 | Undocumented 4 | Tree(s) :: 17 | 3498 16TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003565.7 | 2106565.7 | 37.764429704069 | -122.430864344516 | (37.764429704069, -122.430864344516) | 15 | 4 | 5 | 28862 | 3 | ||||||
| 391 | 104857 | DPW Maintained 1 | :: 45 | 2555 46th Ave | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5982069.8 | 2097707.6 | 37.7388664658919 | -122.504555139124 | (37.7388664658919, -122.504555139124) | 1 | 8 | 3 | 29491 | 35 | ||||||
| 533 | 257925 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 274 Staples Ave | Back Yard : Yard | Tree | Private 2 | 10x10 | 5998272.17919 | 2093819.44967 | 37.7291302611298 | -122.448255187535 | (37.7291302611298, -122.448255187535) | 9 | 7 | 4 | 28861 | 40 | |||||
| 894 | 260859 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 739 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985675.22385 | 2110852.85567 | 37.7751711283725 | -122.493057514378 | (37.7751711283725, -122.493057514378) | 11 | 6 | 2 | 55 | 26 | |||
| 927 | 260891 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 839 34th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985392.72943 | 2110161.55054 | 37.7732564760791 | -122.493983752439 | (37.7732564760791, -122.493983752439) | 11 | 6 | 2 | 55 | 26 | |||
| 980 | 96180 | Permitted Site 7 | Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767812 | ||||||||||||||
| 1030 | 260915 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1307 Waller St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5999454.48308 | 2108393.47297 | 37.7692145145226 | -122.445215277932 | (37.7692145145226, -122.445215277932) | 15 | 5 | 11 | 29492 | 9 | |||
| 1105 | 106501 | Undocumented 4 | Tree(s) :: 17 | 1266 09TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 5993358 | 2106830.8 | 37.764573953722 | -122.46618893715 | (37.764573953722, -122.46618893715) | 11 | 8 | 11 | 56 | 12 | |||||
| 1298 | 91659 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1015 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007624.666917 | 2103742.941155 | 37.7569082017019 | -122.4166254819 | (37.7569082017019, -122.4166254819) | 2 | 4 | 7 | 28859 | 19 | |||
| 1361 | 105851 | Undocumented 4 | Tree(s) :: 17 | 2590 16TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991465.4 | 2097806.4 | 37.7396859298071 | -122.472077039908 | (37.7396859298071, -122.472077039908) | 1 | 8 | 4 | 29491 | 40 | |||||
| 1558 | 256904 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1571 37th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782743 | 5984651.59496 | 2104500.79365 | 37.7576702424259 | -122.496129679735 | (37.7576702424259, -122.496129679735) | 1 | 8 | 3 | 56 | 35 | |
| 1593 | 259756 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1523 Innes Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015921.70632 | 2096895.74231 | 37.7385703600528 | -122.387453298811 | (37.7385703600528, -122.387453298811) | 10 | 3 | 8 | 58 | 1 | |||
| 1694 | 100166 | Property Tree 8 | Salix spp :: Willow 203 | 2340 Twin Peaks Blvd | Front Yard : Yard | Tree | Private 2 | Permit Number 769026 | |||||||||||||||
| 2010 | 260603 | DPW Maintained 1 | Tree(s) :: 17 | 1162 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013406.09782 | 2090446.93369 | 37.7207235989971 | -122.395699409803 | (37.7207235989971, -122.395699409803) | 10 | 3 | 8 | 58 | 1 | |||
| 2090 | 260628 | DPW Maintained 1 | Tree(s) :: 17 | 1251 Revere Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6016934.60308 | 2092996.85523 | 37.7279208386687 | -122.383679778477 | (37.7279208386687, -122.383679778477) | 10 | 3 | 8 | 58 | 1 | |||
| 2116 | 108701 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 478 30th St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774626 | 6003507.49152 | 2098366.33094 | 37.7419128730633 | -122.43048058961 | (37.7419128730633, -122.43048058961) | 2 | 7 | 5 | 63 | 22 | |
| 2122 | 259750 | DPW Maintained 1 | Tilia tomentosa :: Silver Linden 217 | 1631 La Salle Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015305.45247 | 2096307.05022 | 37.7369197808761 | -122.389542925227 | (37.7369197808761, -122.389542925227) | 10 | 3 | 8 | 58 | 1 | |||
| 2238 | 88648 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 74 Carmelita St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51628 | 6002619 | 2108775 | 37.7704422164895 | -122.434296675208 | (37.7704422164895, -122.434296675208) | 15 | 5 | 5 | 29492 | 9 | |||
| 2248 | 90191 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1860X Balboa St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989777.17693 | 2111298.44542 | 37.7766336380006 | -122.478900695137 | (37.7766336380006, -122.478900695137) | 11 | 6 | 2 | 55 | 26 | |||
| 2335 | 262272 | Undocumented 4 | Tree(s) :: 17 | 99X Glendale St | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5999984 | 2103563 | 37.7559814441149 | -122.443036761048 | (37.7559814441149, -122.443036761048) | 2 | 5 | 5 | 28862 | 38 | |||||
| 2500 | 258153 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 546 Sanchez St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6003620.18216 | 2105099.99944 | 37.760408329171 | -122.430571313 | (37.760408329171, -122.430571313) | 2 | 4 | 5 | 28862 | 3 | ||||
| 2548 | 104858 | DPW Maintained 1 | :: 45 | 4205 24th St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 6001816 | 2101720.7 | 37.7510272133613 | -122.436569249202 | (37.7510272133613, -122.436569249202) | 2 | 4 | 5 | 28862 | 22 | ||||||
| 2598 | 95032 | - 12 | Tree(s) :: 17 | 211 Maynard St | Front Yard : Cutout | Landscaping | Private 2 | 6004772 | 2093802 | 37.7294517978782 | -122.425783519869 | (37.7294517978782, -122.425783519869) | 9 | 7 | 6 | 28861 | 5 | ||||||
| 2658 | 91806 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2945 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009025.873084 | 2101313.36822 | 37.7503158463726 | -122.411607913685 | (37.7503158463726, -122.411607913685) | 2 | 4 | 7 | 28859 | 19 | |||
| 2699 | 260850 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 590 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985681.12582 | 2111876.19139 | 37.7779812613037 | -122.493112500198 | (37.7779812613037, -122.493112500198) | 11 | 6 | 2 | 55 | 26 | |||
| 2770 | 260890 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 527 46th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5981596.48479 | 2112160.58463 | 37.7785223833836 | -122.507263579501 | (37.7785223833836, -122.507263579501) | 11 | 6 | 2 | 55 | 26 | |||
| 2777 | 256912 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 26 Lily St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782765 | |||||||||||
| 2862 | 261320 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 872 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014869 | 2089377 | 37.7178670406836 | -122.390567842363 | (37.7178670406836, -122.390567842363) | 10 | 3 | 8 | 58 | 1 | |||||
| 2911 | 258680 | Undocumented 4 | Potential Site :: Potential Site 48 | 2824 21st St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009247 | 2103976 | 37.7576392372832 | -122.411031286576 | (37.7576392372832, -122.411031286576) | 2 | 4 | 7 | 28859 | 19 | |||||
| 3226 | 107892 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 162 Brewster St | Front Yard : Cutout | Tree | Private 2 | 11/04/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773952 | 6010231.01704 | 2099016.49618 | 37.7440766668365 | -122.407278527778 | (37.7440766668365, -122.407278527778) | 2 | 7 | 7 | 28859 | 2 | ||
| 3289 | 262310 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1356 20th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2016 12:00:00 AM | 5989914.31197 | 2106134.19071 | 37.7624619657204 | -122.478048663847 | (37.7624619657204, -122.478048663847) | 1 | 8 | 3 | 56 | 35 | |||||
| 3354 | 258363 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 526 Silliman St | Sidewalk: Property side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009244.29167 | 2093882.64592 | 37.7299249505577 | -122.410328004922 | (37.7299249505577, -122.410328004922) | 9 | 3 | 7 | 309 | 28 | ||||
| 3379 | 258367 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 901 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | ||||||||||||||
| 3380 | 261217 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3400 Vicente St | : Cutout | Tree | Private 2 | FUF | 3x3 | 5982420.06104 | 2097439.60235 | 37.738151214353 | -122.503324281602 | (37.738151214353, -122.503324281602) | 1 | 8 | 3 | 29491 | 35 | ||||
| 3470 | 260424 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 751 Goettingen St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | 6010808.85842 | 2091198.73798 | 37.7226430782423 | -122.404730210147 | (37.7226430782423, -122.404730210147) | 10 | 3 | 7 | 309 | 28 | |||
| 3541 | 258357 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 446 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6009476.28698 | 2093953.76582 | 37.7301332328809 | -122.409530983744 | (37.7301332328809, -122.409530983744) | 9 | 3 | 7 | 309 | 28 | |||
| 3667 | 97254 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 601 Tompkins Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | Permit Number 768271 | 6008616.2 | 2096553.7 | 37.7372238594213 | -122.412688154144 | (37.7372238594213, -122.412688154144) | 10 | 7 | 7 | 28859 | 2 | |||
| 3681 | 106711 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 3990 FOLSOM ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008366.1 | 2096547.2 | 37.7371919715517 | -122.413552407719 | (37.7371919715517, -122.413552407719) | 2 | 7 | 7 | 28859 | 2 | |||||
| 3726 | 94934 | Significant Tree 6 | Ficus carica 'Black Mission' :: Black Mission Fig 265 | 2451X Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.387194089236 | (37.7197277910807, -122.387194089236) | 10 | 3 | 8 | 58 | 1 | ||||
| 3740 | 102276 | DPW Maintained 1 | Tree(s) :: 17 | 279 Topaz Way | Back Yard : Yard | Landscaping | Private 2 | 6001205.6 | 2097796.6 | 37.7402178594385 | -122.438398959733 | (37.7402178594385, -122.438398959733) | 2 | 7 | 5 | 63 | 7 | ||||||
| 3750 | 90460 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 786 25th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988216.47669 | 2110650.29112 | 37.7747632366882 | -122.484252000581 | (37.7747632366882, -122.484252000581) | 11 | 6 | 2 | 55 | 26 | |||
| 3782 | 259863 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1393 Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6011953.37624 | 2088478.22992 | 37.7152370172193 | -122.40058282589 | (37.7152370172193, -122.40058282589) | 10 | 7 | 8 | 309 | 39 | |||
| 3785 | 258385 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 101 University St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007919.90114 | 2093441.26607 | 37.7286386864609 | -122.414875367562 | (37.7286386864609, -122.414875367562) | 9 | 3 | 7 | 309 | 28 | ||||
| 3798 | 262575 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 141 Topaz Way | Front Yard : Yard | Tree | Private 2 | 3x3 | 6001722 | 2097902 | 37.7405366227001 | -122.436621002014 | (37.7405366227001, -122.436621002014) | 2 | 7 | 5 | 63 | 7 | |||||
| 3933 | 258362 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 520 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009260.75409 | 2093887.69259 | 37.7299397304564 | -122.410271448334 | (37.7299397304564, -122.410271448334) | 9 | 3 | 7 | 309 | 28 | ||||
| 3941 | 92078 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1151 Sutter St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2009 12:00:00 AM | 3x3 | Permit Number 52192 | 6007083 | 2115004 | 37.7877979108835 | -122.419297592258 | (37.7877979108835, -122.419297592258) | 13 | 9 | 10 | 28858 | 21 | |||
| 3994 | 256688 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1477 Green St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782620 | |||||||||||
| 4231 | 261663 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 1099x Broadway | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2020 12:00:00 AM | 3 | 3x3 | 6008393 | 2118190 | 37.7966195766837 | -122.414990814528 | (37.7966195766837, -122.414990814528) | 5 | 1 | 10 | 308 | 21 | |||
| 4377 | 88323 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 125 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51312 | 6003417 | 2092629 | 37.7261543381556 | -122.430384225952 | (37.7261543381556, -122.430384225952) | 9 | 7 | 6 | 28861 | 5 | |||
| 4381 | 260219 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2162 24th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | 5988860.24203 | 2100615.01865 | 37.7472465592201 | -122.48129007726 | (37.7472465592201, -122.48129007726) | 1 | 8 | 3 | 29491 | 35 | |||
| 4399 | 260599 | DPW Maintained 1 | Tree(s) :: 17 | 1114 Hollister Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014272.04969 | 2090150.96276 | 37.7199590543715 | -122.392685364492 | (37.7199590543715, -122.392685364492) | 10 | 3 | 8 | 58 | 1 | |||
| 4492 | 260884 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 195 26th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5987712.04911 | 2114688.49303 | 37.7858216131413 | -122.486293421393 | (37.7858216131413, -122.486293421393) | 11 | 6 | 1 | 55 | 33 | |||
| 4537 | 96174 | Permitted Site 7 | Malus sylvestris :: Apple 277 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767807 | ||||||||||||||
| 4623 | 106966 | Undocumented 4 | Tree(s) :: 17 | 2391 47TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5981720.8 | 2098834.4 | 37.7419398125124 | -122.505845312535 | (37.7419398125124, -122.505845312535) | 1 | 8 | 3 | 29491 | 35 | ||||||
| 4636 | 260858 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 730 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985713.16819 | 2110906.59773 | 37.7753209078179 | -122.492930217758 | (37.7753209078179, -122.492930217758) | 11 | 6 | 2 | 55 | 26 | |||
| 4640 | 259372 | DPW Maintained 1 | Laurus x 'Saratoga' :: Hybrid Laurel 4 | 1495 Shafter Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6015477.8076 | 2093733.58604 | 37.7298631224309 | -122.388767411163 | (37.7298631224309, -122.388767411163) | 10 | 3 | 8 | 58 | 1 | |||
| 4853 | 107519 | Undocumented 4 | Tree(s) :: 17 | 100x CHURCH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004015.5 | 2108290.9 | 37.7691921614924 | -122.429431648714 | (37.7691921614924, -122.429431648714) | 7 | 9 | 5 | 28862 | 3 | ||||||
| 4879 | 260889 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 527 45th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5981905.91133 | 2112171.65096 | 37.7785709887537 | -122.506193994794 | (37.7785709887537, -122.506193994794) | 11 | 6 | 2 | 55 | 26 | |||
| 4924 | 259757 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 1539 Innes Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015839.81008 | 2096956.81487 | 37.7387335166642 | -122.387740719291 | (37.7387335166642, -122.387740719291) | 10 | 3 | 8 | 58 | 1 | |||
| 4943 | 260913 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 482 Frederick St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5997348.59542 | 2107447.85511 | 37.7664976608583 | -122.452431145559 | (37.7664976608583, -122.452431145559) | 15 | 5 | 11 | 29492 | 9 | |||
| 4980 | 86291 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1339 25th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/05/2006 12:00:00 AM | 3 | 3x3 | 5988318.888394 | 2106196.850699 | 37.7625412799726 | -122.483571174333 | (37.7625412799726, -122.483571174333) | 1 | 8 | 3 | 56 | 35 | |||
| 5012 | 261384 | Undocumented 4 | Potential Site :: Potential Site 48 | 246 Leavenworth St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008558 | 2113314 | 37.7832405398106 | -122.41407474629 | (37.7832405398106, -122.41407474629) | 7 | 10 | 9 | 28852 | 36 | |||||
| 5082 | 258116 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2245 Jones St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6008057.63672 | 2120117.2159 | 37.8018923796488 | -122.416287818099 | (37.8018923796488, -122.416287818099) | 5 | 1 | 10 | 308 | 32 | ||||
| 5176 | 260916 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1726 Page St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5998303.71415 | 2108967.89528 | 37.7707259785013 | -122.449237098474 | (37.7707259785013, -122.449237098474) | 15 | 5 | 11 | 29492 | 9 | |||
| 5227 | 96177 | Permitted Site 7 | Diospyros kaki :: Persimmon 288 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767810 | ||||||||||||||
| 5239 | 112929 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | |||
| 5254 | 260218 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2162 24th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | 5988860.24203 | 2100615.01865 | 37.7472465592201 | -122.48129007726 | (37.7472465592201, -122.48129007726) | 1 | 8 | 3 | 29491 | 35 | |||
| 5290 | 89193 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | |||||
| 5320 | 88554 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 579 16th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51499 | 5990911.3 | 2111462.4 | 37.7771496035915 | -122.474989443149 | (37.7771496035915, -122.474989443149) | 11 | 6 | 2 | 54 | 26 | |||
| 5429 | 116488 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2149 LYON ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999319 | 2116238 | 37.7907458271484 | -122.446248274058 | (37.7907458271484, -122.446248274058) | 13 | 6 | 1 | 29490 | 31 | |||||
| 5477 | 88381 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 423 16th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51359 | 5990873.7 | 2112494.8 | 37.7799821106609 | -122.475194900005 | (37.7799821106609, -122.475194900005) | 11 | 6 | 2 | 54 | 26 | |||
| 5607 | 260608 | DPW Maintained 1 | Tree(s) :: 17 | 1010 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014125.00477 | 2089910.99969 | 37.7192919954616 | -122.393176869863 | (37.7192919954616, -122.393176869863) | 10 | 3 | 8 | 58 | 1 | |||
| 5724 | 87766 | Permitted Site 7 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 3896 22nd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50469 | 6002488 | 2102987 | 37.7545423364482 | -122.434335932006 | (37.7545423364482, -122.434335932006) | 2 | 4 | 5 | 28862 | 22 | |||
| 5732 | 258358 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 341 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009791.92467 | 2094008.68962 | 37.7303017232085 | -122.408443651573 | (37.7303017232085, -122.408443651573) | 10 | 3 | 7 | 309 | 28 | ||||
| 5747 | 94949 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 50 Pomona St | : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
| 5768 | 87061 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | unknown : Yard | Tree | Private 2 | 3x3 | Permit Number 50003 | |||||||||||||||
| 6021 | 260882 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 810 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985734.50152 | 2110356.92333 | 37.7738129057539 | -122.492815926544 | (37.7738129057539, -122.492815926544) | 11 | 6 | 2 | 55 | 26 | |||
| 6097 | 95161 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 2721 Pacific Ave | Front Yard : Yard | Tree | Private 2 | Permit Number 54078 | 6001026.7 | 2116843.3 | 37.7925052022591 | -122.440383162252 | (37.7925052022591, -122.440383162252) | 13 | 6 | 1 | 29490 | 27 | |||||
| 6189 | 260917 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1740 Page St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5998239.87383 | 2108958.8784 | 37.7706975687071 | -122.44945727244 | (37.7706975687071, -122.44945727244) | 15 | 5 | 11 | 29492 | 9 | |||
| 6343 | 96176 | Permitted Site 7 | Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767809 | ||||||||||||||
| 6402 | 94573 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3978 18th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53752 | 6003116 | 2105363 | 37.761101890414 | -122.432333828196 | (37.761101890414, -122.432333828196) | 15 | 4 | 5 | 28862 | 3 | ||
| 6410 | 91640 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1427 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007757.588641 | 2101343.923892 | 37.7503285203588 | -122.415995902486 | (37.7503285203588, -122.415995902486) | 2 | 4 | 7 | 28859 | 19 | |||
| 6422 | 260907 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2125 Lake St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5988893.20555 | 2114661.62902 | 37.7858166251674 | -122.482205030291 | (37.7858166251674, -122.482205030291) | 11 | 6 | 2 | 55 | 26 | |||
| 6593 | 261297 | Permitted Site 7 | :: 45 | 3180 18th St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/01/2013 12:00:00 AM | 3 | 6008239.4944 | 2105648.95562 | 37.762176240156 | -122.414634049312 | (37.762176240156, -122.414634049312) | 8 | 4 | 7 | 28859 | 19 | ||||
| 6695 | 260396 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Thornton Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | |||||||||||||
| 6730 | 96175 | Permitted Site 7 | Malus sylvestris :: Apple 277 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767808 | ||||||||||||||
| 6758 | 95372 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 180 Yukon St | Back Yard : Cutout | Tree | Private 2 | 15 | Permit Number 767755 | 6000174.3 | 2103956.9 | 37.7570738455347 | -122.442406920559 | (37.7570738455347, -122.442406920559) | 2 | 4 | 5 | 28862 | 3 | ||||
| 6813 | 256911 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 26 Lily St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782765 | |||||||||||
| 6833 | 109426 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 132 Locust St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2015 12:00:00 AM | 3 | 5997544.3 | 2115966.4 | 37.7898985728773 | -122.452369007612 | (37.7898985728773, -122.452369007612) | 11 | 6 | 1 | 54 | 31 | ||||
| 6875 | 260888 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 528 45th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5981946.38688 | 2112159.7169 | 37.7785406040131 | -122.50605309173 | (37.7785406040131, -122.50605309173) | 11 | 6 | 2 | 55 | 26 | |||
| 6891 | 260855 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 710 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985708.10427 | 2111037.07472 | 37.775678864326 | -122.492957347897 | (37.775678864326, -122.492957347897) | 11 | 6 | 2 | 55 | 26 | |||
| 7105 | 262039 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1251 Hyde St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783100 | 6007540 | 2116706 | 37.7924969115625 | -122.417837146347 | (37.7924969115625, -122.417837146347) | 5 | 1 | 10 | 28858 | 21 | ||
| 7291 | 105130 | Significant Tree 6 | Tree(s) :: 17 | 4045 MORAGA ST | Sidewalk: Property side : Yard | Tree | Private 2 | 5981665.2 | 2103465.9 | 37.7546533409301 | -122.506380933635 | (37.7546533409301, -122.506380933635) | 1 | 8 | 3 | 56 | 35 |
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) );