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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15191 | 96232 | Permitted Site 7 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | |||||||||||||||||
| 15343 | 92823 | Permitted Site 7 | Tree(s) :: 17 | 50 Kirkham St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2009 12:00:00 AM | 3x3 | Permit Number 53037 | 5994776.3 | 2105346.5 | 37.7605801777143 | -122.461175855238 | (37.7605801777143, -122.461175855238) | 15 | 5 | 11 | 56 | 12 | |||
| 15426 | 262040 | DPW Maintained 1 | Tree(s) :: 17 | 740 Jamestown Ave | Back Yard : Yard | Tree | DPW 1 | Private | 6015231.58289 | 2088478.1596 | 37.7154191081975 | -122.38925181324 | (37.7154191081975, -122.38925181324) | 10 | 3 | 8 | 58 | 1 | |||||
| 15444 | 89331 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 4658 18th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51984 | 6000201 | 2105201 | 37.7604913603716 | -122.4424038966 | (37.7604913603716, -122.4424038966) | 15 | 4 | 5 | 28862 | 3 | |||
| 15558 | 91677 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 599 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007489.042117 | 2106191.625958 | 37.7636240956729 | -122.417268041752 | (37.7636240956729, -122.417268041752) | 8 | 4 | 7 | 28859 | 19 | |||
| 15601 | 99374 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 21 Panorama Dr | Back Yard : Yard | Tree | Private 2 | 24 | 5998009 | 2100230 | 37.7467170430405 | -122.449626769288 | (37.7467170430405, -122.449626769288) | 1 | 5 | 4 | 63 | 38 | |||||
| 15648 | 260854 | DPW Maintained 1 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 174 | 543 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985630.75782 | 2112196.1258 | 37.7788567636192 | -122.493310315227 | (37.7788567636192, -122.493310315227) | 11 | 6 | 2 | 55 | 26 | |||
| 15680 | 91641 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1401X South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007749.533216 | 2101489.31094 | 37.7507272674606 | -122.416034053567 | (37.7507272674606, -122.416034053567) | 2 | 4 | 7 | 28859 | 19 | |||
| 15765 | 258114 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 22 Isis St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 6008329.87381 | 2108642.20827 | 37.7704000939468 | -122.414533279126 | (37.7704000939468, -122.414533279126) | 8 | 2 | 9 | 28853 | 19 | |||||
| 15796 | 260912 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 99x Belvedere St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | |||||||||||||
| 15845 | 258506 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1826 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784310 | 5981340.96511 | 2102634.36273 | 37.7523510806953 | -122.507440512367 | (37.7523510806953, -122.507440512367) | 1 | 8 | 3 | 56 | 35 | |
| 15890 | 256718 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 927 Brazil Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782649 | |||||||||||
| 16099 | 258126 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 839 Woolsey St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 6009323.9018 | 2091459.72013 | 37.7232765705422 | -122.409881813505 | (37.7232765705422, -122.409881813505) | 9 | 3 | 7 | 309 | 28 | |||
| 16142 | 94943 | Significant Tree 6 | Pyrus pyrifolia '20th Century' :: Asian Pear '20th Century' 364 | 2525 Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.7196157592662 | -122.38561332474 | (37.7196157592662, -122.38561332474) | 10 | 3 | 8 | 58 | 1 | ||||
| 16169 | 105247 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1301X COLE ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x 5 | 5998246 | 2105821 | 37.7620821004846 | -122.44920998149 | (37.7620821004846, -122.44920998149) | 15 | 5 | 11 | 29492 | 9 | ||||
| 16174 | 107381 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 14 MOSS ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010161.8 | 2111354.5 | 37.7779501635385 | -122.408387955783 | (37.7779501635385, -122.408387955783) | 14 | 2 | 9 | 28853 | 34 | ||||||
| 16191 | 254533 | Permitted Site 7 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 23 | 154 Arleta Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781436 | |||||||||||
| 16196 | 251543 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0X Bay Shore Blvd Off Ramp | Side Yard : Yard | Tree | Private 2 | ||||||||||||||||
| 16203 | 87742 | Permitted Site 7 | Morus alba :: White Mulberry 246 | 1725 Mason St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2008 12:00:00 AM | 3x3 | Permit Number 50405 | 6009154 | 2119215 | 37.7994767072274 | -122.412430063534 | (37.7994767072274, -122.412430063534) | 3 | 1 | 10 | 308 | 32 | |||
| 16209 | 262261 | - 12 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 290 Green St | : | Tree | Private 2 | FUF | 06/18/2020 12:00:00 AM | 3 | Permit Number 785454 | 6011550.34746 | 2119418.71162 | 37.8001702361868 | -122.404152146942 | (37.8001702361868, -122.404152146942) | 3 | 1 | 10 | 308 | 23 | ||
| 16275 | 260607 | DPW Maintained 1 | Tree(s) :: 17 | 1026 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014043.19207 | 2089971.98975 | 37.71945491674 | -122.393463933828 | (37.71945491674, -122.393463933828) | 10 | 3 | 8 | 58 | 1 | |||
| 16306 | 260886 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 709 32nd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985981.28564 | 2111059.97075 | 37.7757577023633 | -122.492014045289 | (37.7757577023633, -122.492014045289) | 11 | 6 | 2 | 55 | 26 | |||
| 16351 | 92032 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4232 21st St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2009 12:00:00 AM | 3x3 | Permit Number 52175 | 6001386.1 | 2103403.9 | 37.75562443672 | -122.43817644846 | (37.75562443672, -122.43817644846) | 2 | 4 | 5 | 28862 | 3 | |||
| 16550 | 88330 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 544 London St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51318 | 6001416.8 | 2090660.3 | 37.7206352284922 | -122.437157897339 | (37.7206352284922, -122.437157897339) | 9 | 7 | 6 | 28861 | 5 | |||
| 16631 | 104298 | Permitted Site 7 | Tree(s) :: 17 | 4021 20TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x4 | 6003557 | 2104154 | 37.7578072610358 | -122.430722322319 | (37.7578072610358, -122.430722322319) | 2 | 4 | 5 | 28862 | 3 | |||||
| 16680 | 256664 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1381 Filbert St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 5x5 | Permit Number 782595 | 6006338.70929 | 2119347.35531 | 37.7996817310416 | -122.422181395696 | (37.7996817310416, -122.422181395696) | 13 | 9 | 1 | 28858 | 32 | |
| 16722 | 258368 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 910 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6008141.55513 | 2093544.59332 | 37.7289348532082 | -122.414116401333 | (37.7289348532082, -122.414116401333) | 9 | 3 | 7 | 309 | 28 | ||||
| 17004 | 259318 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 601 Wisconsin St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6012713 | 2104246 | 37.7585743521834 | -122.399063317374 | (37.7585743521834, -122.399063317374) | 10 | 3 | 8 | 28856 | 29 | |||||
| 17164 | 258124 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 231 Woolsey St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6011067.40482 | 2091994.16139 | 37.7248415942661 | -122.403892413165 | (37.7248415942661, -122.403892413165) | 10 | 3 | 7 | 309 | 28 | |||
| 17248 | 260604 | DPW Maintained 1 | Tree(s) :: 17 | 1058 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013879.56666 | 2090093.96987 | 37.7197807571849 | -122.394038065566 | (37.7197807571849, -122.394038065566) | 10 | 3 | 8 | 58 | 1 | |||
| 17341 | 260857 | DPW Maintained 1 | Tree(s) :: 17 | 726 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985712.15541 | 2110932.69313 | 37.7753924991275 | -122.492935643751 | (37.7753924991275, -122.492935643751) | 11 | 6 | 2 | 55 | 26 | |||
| 17354 | 88467 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 119 Augusta St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51421 | 6011176 | 2095454 | 37.7343476550611 | -122.403760347511 | (37.7343476550611, -122.403760347511) | 10 | 3 | 8 | 58 | 1 | |||
| 17383 | 258113 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 144 Freelon St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 6013235.08289 | 2111410.77261 | 37.7782762981131 | -122.397760259133 | (37.7782762981131, -122.397760259133) | 6 | 2 | 9 | 28856 | 34 | |||||
| 17544 | 259759 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 1563 Innes Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015716.96571 | 2097048.42371 | 37.7389782502581 | -122.388171852411 | (37.7389782502581, -122.388171852411) | 10 | 3 | 8 | 58 | 1 | |||
| 17566 | 89252 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 433 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2020 12:00:00 AM | 3 | 4x4 | Permit Number 51885 | 5985288.27991 | 2112944.49227 | 37.780891524599 | -122.49455024837 | (37.780891524599, -122.49455024837) | 11 | 6 | 2 | 55 | 26 | ||
| 17594 | 254853 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 799 Avalon Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781645 | |||||||||||
| 17742 | 94465 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 4128 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 5x6 | Permit Number 779215 | 6001502 | 2105859 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | 15 | 5 | 5 | 28862 | 3 | |||
| 17829 | 106868 | Undocumented 4 | Tree(s) :: 17 | 1956 GREAT HWY | Sidewalk: Property side : Cutout | Tree | Private 2 | 5981193.7 | 2101737.6 | 37.7498801477899 | -122.507883225183 | (37.7498801477899, -122.507883225183) | 1 | 8 | 3 | 29491 | 35 | ||||||
| 17928 | 87790 | Permitted Site 7 | Brahea aramata :: Mexican Blue Palm 377 | 635 Buena Vista West Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2008 12:00:00 AM | Permit Number 50531 | 5999771 | 2107673 | 37.7672543384354 | -122.444068690497 | (37.7672543384354, -122.444068690497) | 15 | 5 | 5 | 29492 | 9 | ||||
| 17942 | 258365 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 811 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6008440.06545 | 2093594.26657 | 37.7290880075188 | -122.413087936875 | (37.7290880075188, -122.413087936875) | 9 | 3 | 7 | 309 | 28 | ||||
| 18004 | 110212 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2978 CESAR CHAVEZ ST | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 3x4 | 6009700.7 | 2100638.5 | 37.7485006383082 | -122.409226689451 | (37.7485006383082, -122.409226689451) | 2 | 4 | 7 | 28859 | 19 | ||||
| 18098 | 259796 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 567 Somerset St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6010266.31037 | 2091928.95171 | 37.7246177539405 | -122.406657122403 | (37.7246177539405, -122.406657122403) | 10 | 3 | 7 | 309 | 28 | |||
| 18166 | 88091 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1619 39th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51095 | 5984024.3 | 2104125.3 | 37.756602478656 | -122.498271356488 | (37.756602478656, -122.498271356488) | 1 | 8 | 3 | 56 | 35 | |||
| 18199 | 254500 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1715 Octavia St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 769839 | 6004851.87126 | 2115244.61878 | 37.7883326812086 | -122.427034026756 | (37.7883326812086, -122.427034026756) | 13 | 9 | 11 | 28858 | 27 | |
| 18284 | 258470 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2414 47th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/17/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781119 | 5981787.508 | 2098641.53969 | 37.741414197633 | -122.505600368739 | (37.741414197633, -122.505600368739) | 1 | 8 | 3 | 29491 | 35 | |
| 18289 | 88190 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1118 Harrison St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51195 | 6010631 | 2110372 | 37.7752787109316 | -122.406695562022 | (37.7752787109316, -122.406695562022) | 8 | 2 | 9 | 28853 | 34 | |||
| 18423 | 258374 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1009 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007871.84523 | 2093420.07444 | 37.7285777984137 | -122.415040000813 | (37.7285777984137, -122.415040000813) | 9 | 3 | 7 | 309 | 5 | ||||
| 18434 | 105315 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2101 Laguna St | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770797 | 6004250.84301 | 2116191.67517 | 37.7908990545176 | -122.429181041856 | (37.7908990545176, -122.429181041856) | 13 | 9 | 1 | 28858 | 27 | |||||
| 18448 | 260600 | DPW Maintained 1 | Tree(s) :: 17 | 1122 Hollister Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014231.13861 | 2090181.46138 | 37.7200405252834 | -122.392828913667 | (37.7200405252834, -122.392828913667) | 10 | 3 | 8 | 58 | 1 | |||
| 18452 | 108642 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 167 Judson Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774606 | 5998978.54245 | 2093474.85877 | 37.7282244523119 | -122.44578846914 | (37.7282244523119, -122.44578846914) | 9 | 7 | 4 | 28861 | 40 | |
| 18556 | 105475 | Undocumented 4 | Tree(s) :: 17 | 671 Waller St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2014 12:00:00 AM | 3x3 | 6002476.36422 | 2108834.33955 | 37.7705970512656 | -122.434794296397 | (37.7705970512656, -122.434794296397) | 15 | 5 | 11 | 29492 | 9 | ||||
| 18563 | 259805 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1249 Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6011760.82557 | 2089103.97372 | 37.71694444304 | -122.401292315923 | (37.71694444304, -122.401292315923) | 10 | 7 | 8 | 309 | 39 | |||
| 18737 | 258112 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 28 06th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5993962.87947 | 2115311.61201 | 37.7878948748238 | -122.464712734046 | (37.7878948748238, -122.464712734046) | 11 | 6 | 1 | 54 | 11 | ||||||
| 18741 | 260851 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 625 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985649.08401 | 2111623.73701 | 37.7772862197699 | -122.493204739608 | (37.7772862197699, -122.493204739608) | 11 | 6 | 2 | 55 | 26 | |||
| 18837 | 260887 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 811 41st Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5983217.77071 | 2110265.58898 | 37.7734146368587 | -122.501514803752 | (37.7734146368587, -122.501514803752) | 11 | 6 | 2 | 55 | 26 | |||
| 18906 | 258110 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 639 Woolsey St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x5 | 6009897.96561 | 2091634.59657 | 37.723788900764 | -122.407909701204 | (37.723788900764, -122.407909701204) | 10 | 3 | 7 | 309 | 28 | ||||
| 19014 | 260601 | DPW Maintained 1 | Tree(s) :: 17 | 1142 Hollister Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014128.86091 | 2090257.70792 | 37.7202442017659 | -122.393187787982 | (37.7202442017659, -122.393187787982) | 10 | 3 | 8 | 58 | 1 | |||
| 19114 | 259651 | DPW Maintained 1 | :: 45 | 598x Rutland St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 19174 | 261294 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 801 Wisconsin St | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 6012760.41981 | 2103766.81895 | 37.7572612683759 | -122.398865686828 | (37.7572612683759, -122.398865686828) | 10 | 3 | 8 | 28856 | 29 | |||||
| 19267 | 88109 | Permitted Site 7 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1305 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51113 | 5981150.4 | 2106141.9 | 37.7619705488895 | -122.508359845943 | (37.7619705488895, -122.508359845943) | 1 | 8 | 3 | 56 | 35 | |||
| 19465 | 96173 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767806 | ||||||||||||||
| 19643 | 105261 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 619 GONZALEZ DR | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5988914.8 | 2089258.8 | 37.7160684695332 | -122.48027037241 | (37.7160684695332, -122.48027037241) | 1 | 8 | 4 | 64 | 14 | |||||
| 19875 | 96597 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 325 Sanchez St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6003898 | 2106263.7 | 37.7636193068731 | -122.429693469686 | (37.7636193068731, -122.429693469686) | 8 | 4 | 5 | 28862 | 3 | |||||
| 19898 | 98265 | Property Tree 8 | Pinus pinea :: Italian Stone Pine 63 | 755 O'Farrell St | Back Yard : Yard | Tree | Private 2 | Backyard tree; not significant | 6007700 | 2113968.3 | 37.7849888609023 | -122.417089467607 | (37.7849888609023, -122.417089467607) | 7 | 10 | 9 | 28858 | 36 | |||||
| 20053 | 88130 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 822 Duncan St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51154 | 6001234 | 2099702 | 37.7454512540188 | -122.438437243524 | (37.7454512540188, -122.438437243524) | 2 | 4 | 5 | 63 | 22 | |||
| 20087 | 255687 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1435 Oakdale Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782067 | 6015917.10189 | 2094795.04742 | 37.7328020209929 | -122.387322721383 | (37.7328020209929, -122.387322721383) | 10 | 3 | 8 | 58 | 1 | |
| 20196 | 88552 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 649 15th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51497 | 5991271.54152 | 2111000.35442 | 37.7759018234336 | -122.473709552083 | (37.7759018234336, -122.473709552083) | 11 | 6 | 2 | 54 | 26 | ||
| 20631 | 104678 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3531-3535 16TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003359 | 2106442.3 | 37.7640791638998 | -122.431570451949 | (37.7640791638998, -122.431570451949) | 15 | 4 | 5 | 28862 | 3 | ||||
| 20705 | 108706 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1683 Chattanooga St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774629 | 6004719.93732 | 2102694.114 | 37.7538645742471 | -122.42659644528 | (37.7538645742471, -122.42659644528) | 2 | 4 | 5 | 28862 | 22 | |
| 21071 | 258216 | Permitted Site 7 | Banksia integrifolia :: Coast Banksia 21 | 1525 44th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783183 | 5982470.91812 | 2104727.52358 | 37.758164806501 | -122.503688017142 | (37.758164806501, -122.503688017142) | 1 | 8 | 3 | 56 | 35 | |
| 21342 | 88261 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 229 Douglass St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51248 | 6001199 | 2104918 | 37.7597711445886 | -122.438931999231 | (37.7597711445886, -122.438931999231) | 2 | 4 | 5 | 28862 | 3 | |||
| 21444 | 87268 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 727 Moraga St | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/05/2008 12:00:00 AM | Permit Number 50290 | 5992077 | 2103851 | 37.7563182174397 | -122.470402504062 | (37.7563182174397, -122.470402504062) | 1 | 8 | 4 | 56 | 12 | ||||
| 21446 | 107856 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 2938 SLOAT BLVD | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5981725.3 | 2096580 | 37.7357501162313 | -122.505662672753 | (37.7357501162313, -122.505662672753) | 1 | 8 | 3 | 29491 | 35 | |||||
| 21713 | 88316 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 447 Edinburg St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51307 | 6003165.8 | 2091093 | 37.7219225920035 | -122.431143024225 | (37.7219225920035, -122.431143024225) | 9 | 7 | 6 | 28861 | 5 | |||
| 21821 | 97236 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 125 Excelsior Ave | Sidewalk: Property side : Yard | Tree | SFUSD 4 | FUF | 09/07/2011 12:00:00 AM | Permit Number 767513 | 6002911 | 2092621.3 | 37.7261045201699 | -122.432132888294 | (37.7261045201699, -122.432132888294) | 9 | 7 | 6 | 28861 | 5 | |||
| 21950 | 104740 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 200X Fair Oaks St | Sidewalk: Curb side : Cutout | Tree | Private 2 | On the 23rd side of property. | 6005413 | 2102541 | 37.753483315938 | -122.424188782445 | (37.753483315938, -122.424188782445) | 2 | 4 | 5 | 28859 | 19 | |||||
| 21984 | 105306 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4365 26th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2014 12:00:00 AM | 3x3 | Permit Number 771671 | 6001537.2 | 2100535.2 | 37.7477562656077 | -122.437448482105 | (37.7477562656077, -122.437448482105) | 2 | 4 | 5 | 63 | 22 | |||
| 22133 | 86802 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 3057 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2007 12:00:00 AM | 3x3 | Permit Number 49634 | 6008359 | 2106197 | 37.7636877570953 | -122.414259500664 | (37.7636877570953, -122.414259500664) | 8 | 4 | 7 | 28859 | 19 | |||
| 22140 | 108608 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 46 Mirabel Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774593 | 6007564.86266 | 2099909.67409 | 37.7463795558054 | -122.416560777242 | (37.7463795558054, -122.416560777242) | 2 | 7 | 7 | 28859 | 2 | |
| 22150 | 91686 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 377 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007415.631785 | 2107493.688708 | 37.7671951252581 | -122.417614236777 | (37.7671951252581, -122.417614236777) | 8 | 4 | 7 | 28853 | 19 | |||
| 22225 | 88126 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2202 Sutter St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51132 | 6002003.4 | 2114360.3 | 37.7857430855157 | -122.436825926477 | (37.7857430855157, -122.436825926477) | 13 | 6 | 1 | 29490 | 27 | |||
| 22366 | 108443 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 559 05th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773772 | 5994363.45802 | 2111716.68858 | 37.7780472719646 | -122.463065881676 | (37.7780472719646, -122.463065881676) | 11 | 6 | 2 | 54 | 11 | |||
| 22402 | 104719 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 61- 63 SUSSEX ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 771137 | 6002409.7 | 2096544.3 | 37.7368477492981 | -122.434146170859 | (37.7368477492981, -122.434146170859) | 2 | 7 | 5 | 63 | 7 | |||
| 22679 | 108026 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 862 Kansas St | Front Yard : Yard | Tree | Private 2 | Permit Number 774734 | 6011570 | 2104296 | 37.7586478799274 | -122.403019866682 | (37.7586478799274, -122.403019866682) | 10 | 3 | 8 | 28856 | 29 | |||||
| 22683 | 86700 | Permitted Site 7 | Azara microphylla :: Little-Leaf Azara 312 | 306 Mullen Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010582.9 | 2099803.7 | 37.7462578450491 | -122.40611723741 | (37.7462578450491, -122.40611723741) | 2 | 7 | 7 | 28859 | 2 | ||||||
| 22718 | 88236 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1593 McAllister St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51225 | 6001491 | 2111451 | 37.7777257527509 | -122.438390172535 | (37.7777257527509, -122.438390172535) | 15 | 5 | 11 | 29492 | 41 | |||
| 22774 | 121447 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1251 03rd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015574 | 2109248 | 37.7724677756099 | -122.389517929907 | (37.7724677756099, -122.389517929907) | 14 | 3 | 9 | 310 | 20 | |||||
| 22847 | 106710 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 3869 19th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 772840 | 6003862.3 | 2104785.7 | 37.7595590509906 | -122.429711522366 | (37.7595590509906, -122.429711522366) | 2 | 4 | 5 | 28862 | 3 | ||||
| 22984 | 92756 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
| 22987 | 88225 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2084 Hayes St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51221 | 5997896.9 | 2109991 | 37.7735118836843 | -122.450718045928 | (37.7735118836843, -122.450718045928) | 15 | 5 | 11 | 29492 | 16 | |||
| 23031 | 88096 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1795 40th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51099 | 5983752.7 | 2102993.7 | 37.7534794912156 | -122.499127022602 | (37.7534794912156, -122.499127022602) | 1 | 8 | 3 | 56 | 35 | |||
| 23171 | 109911 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1062X Carolina St | Median : Cutout | Tree | DPW 1 | 3x3 | 6012455.3 | 2103027.1 | 37.7552131559276 | -122.39986897476 | (37.7552131559276, -122.39986897476) | 10 | 3 | 8 | 28856 | 29 | |||||
| 23199 | 112923 | 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 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
| 23278 | 88325 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 346 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51314 | 6002623 | 2091442 | 37.7228500939634 | -122.433044266804 | (37.7228500939634, -122.433044266804) | 9 | 7 | 6 | 28861 | 5 | |||
| 23388 | 256663 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1381 Filbert St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782595 | 6006338.70929 | 2119347.35531 | 37.7996817310416 | -122.422181395696 | (37.7996817310416, -122.422181395696) | 13 | 9 | 1 | 28858 | 32 | |
| 23401 | 114142 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99 Divisadero St | Front Yard : Yard | Tree | Private 2 | 6001906.1 | 2108188.4 | 37.7687910682296 | -122.436720598265 | (37.7687910682296, -122.436720598265) | 15 | 5 | 5 | 29492 | 3 | ||||||
| 23473 | 87390 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3318 Fillmore St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2008 12:00:00 AM | 3x3 | Permit Number 50367 | 6002344.5 | 2119563.8 | 37.8000499325498 | -122.436018296661 | (37.8000499325498, -122.436018296661) | 13 | 9 | 1 | 57 | 17 | |||
| 23696 | 108446 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 672 05th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773773 | 5994431.81479 | 2110948.53978 | 37.7759420777365 | -122.462773673163 | (37.7759420777365, -122.462773673163) | 11 | 6 | 2 | 54 | 11 | |||
| 23742 | 112565 | Permitted Site 7 | Tree(s) :: 17 | 1000X 17th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2015 12:00:00 AM | Permit Number 774340 | 5990959.97324 | 2102133.59106 | 37.7515380150924 | -122.474140224193 | (37.7515380150924, -122.474140224193) | 1 | 8 | 4 | 29491 | 12 | ||||
| 23777 | 88528 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 771 14th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51478 | 6003493 | 2107743 | 37.7676581652647 | -122.431199833454 | (37.7676581652647, -122.431199833454) | 15 | 9 | 5 | 28862 | 3 |
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) );