trees
1,732 rows where qLegalStatus_id = 6 sorted by DBH descending
This data as json, CSV (advanced)
qCaretaker_id ✖
- Private 1,494
- DPW 38
- Housing Authority 25
- SFUSD 23
- MTA 21
- DPW for City Agency 14
- Rec/Park 9
- Police Dept 3
- Arts Commission 3
- PUC 1
- Public Library 1
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34293 | 111094 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 150x FONT BLVD | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2015 12:00:00 AM | 30 | 3x3 | Permit Number 775594 | 5990976 | 2089133 | 37.7158426125161 | -122.473136789074 | (37.7158426125161, -122.473136789074) | 1 | 8 | 4 | 64 | 14 | ||
| 37736 | 101041 | Significant Tree 6 | Tree(s) :: 17 | 3750 18th St | 1 | Front Yard : Yard | Tree | SFUSD 4 | 03/15/2012 12:00:00 AM | 30 | Permit Number 769376 | 6005230 | 2105481 | 37.7615455321967 | -122.425030802687 | (37.7615455321967, -122.425030802687) | 8 | 4 | 5 | 28859 | 19 | ||
| 42938 | 112725 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 40x BERNAL HEIGHTS BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6009324 | 2098099 | 37.7415066181332 | -122.410350033668 | (37.7415066181332, -122.410350033668) | 10 | 7 | 7 | 28859 | 2 | |||
| 43131 | 116576 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 2500x OCEAN AVE | 1 | Sidewalk: Property side : Yard | Tree | MTA 3 | DPW | 30 | 10X10 | 5991377 | 2094742 | 37.7312667472315 | -122.472159374256 | (37.7312667472315, -122.472159374256) | 1 | 8 | 4 | 64 | 40 | ||
| 66441 | 109838 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 200x MONTCALM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6009924 | 2099647 | 37.7457907048197 | -122.408384592716 | (37.7457907048197, -122.408384592716) | 2 | 7 | 7 | 28859 | 2 | |||
| 69512 | 113042 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 500 Raymond Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 10/06/2015 12:00:00 AM | 30 | 3x3 | 6008233.87951 | 2088473.93147 | 37.7150170728648 | -122.413438766187 | (37.7150170728648, -122.413438766187) | 9 | 7 | 8 | 309 | 18 | ||
| 81588 | 113833 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 932 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 6007966 | 2102301 | 37.7529681504442 | -122.415342945464 | (37.7529681504442, -122.415342945464) | 2 | 4 | 7 | 28859 | 19 | ||||
| 82071 | 106360 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1820 POST ST | 1 | Front Yard : Yard | Tree | Private 2 | 30 | 6003351.1 | 2114201.6 | 37.785383838011 | -122.432151932321 | (37.785383838011, -122.432151932321) | 13 | 9 | 11 | 29490 | 13 | ||||
| 100702 | 109040 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 654 Precita Ave | Front Yard : Yard | Tree | Private 2 | 30 | 6009911.5 | 2100416.7 | 37.7479034320272 | -122.408482100152 | (37.7479034320272, -122.408482100152) | 2 | 7 | 7 | 28859 | 2 | |||||
| 109570 | 114194 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 555x SAN JOSE AVE | 2 | Front Yard : Yard | Tree | Private 2 | 11/23/2015 12:00:00 AM | 30 | 3x3 | Permit Number 777057 | 6006305 | 2100249 | 37.747240333103 | -122.420941331562 | (37.747240333103, -122.420941331562) | 2 | 7 | 7 | 28859 | 2 | |
| 109646 | 114230 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
| 118842 | 116091 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | |||
| 138347 | 116585 | Significant Tree 6 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2100 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2018 12:00:00 AM | 30 | 3x3 | 6011855.05017 | 2103755.96694 | 37.7571809821214 | -122.401996064067 | (37.7571809821214, -122.401996064067) | 10 | 3 | 8 | 28856 | 29 | |
| 144070 | 97894 | Significant Tree 6 | Tree(s) :: 17 | 2927 Folsom St | Front Yard : Yard | Tree | Private 2 | 02/29/2012 12:00:00 AM | 30 | Permit Number 768566 | 6008395 | 2101384 | 37.7504743768844 | -122.413794517972 | (37.7504743768844, -122.413794517972) | 2 | 4 | 7 | 28859 | 19 | |||
| 155327 | 107408 | Significant Tree 6 | Acer japonicum :: Japanese Maple 124 | 10 PEMBERTON PL | 1 | Front Yard : Yard | Tree | Private 2 | 30 | 5998956.5 | 2104566.5 | 37.7586781689727 | -122.446662380642 | (37.7586781689727, -122.446662380642) | 15 | 5 | 5 | 28862 | 12 | ||||
| 163659 | 102019 | Significant Tree 6 | Melaleuca quinquenervia :: Cajeput 10 | 3028 Market St | 1 | Front Yard : Yard | Tree | Private 2 | 30 | 4x14 | 6000376.7 | 2105451.5 | 37.7611891846044 | -122.44181421161 | (37.7611891846044, -122.44181421161) | 15 | 5 | 5 | 28862 | 3 | |||
| 178584 | 108144 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 140x TOPAZ WAY | 2 | Front Yard : Yard | Tree | Private 2 | 30 | Permit Number 775551 | 6001767 | 2098265 | 37.7415358930081 | -122.436491384585 | (37.7415358930081, -122.436491384585) | 2 | 7 | 5 | 63 | 7 | |||
| 22 | 262394 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 66 Cleary Ct | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 11/13/2020 12:00:00 AM | 3 | 3x3 | 6004824 | 2113713 | 37.7841256623529 | -122.427021325889 | (37.7841256623529, -122.427021325889) | 13 | 9 | 11 | 28858 | 41 | ||
| 29 | 264952 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 2 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
| 31 | 264951 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 1 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
| 523 | 92314 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2783 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985837.7861 | 2096464.2212 | 37.7356733962807 | -122.491435886509 | (37.7356733962807, -122.491435886509) | 1 | 8 | 3 | 29491 | 35 | ||
| 797 | 260459 | Significant Tree 6 | Tree(s) :: 17 | 1798X Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | 5x10 | Permit Number 784470 | 5992678 | 2095461 | 37.733316146518 | -122.467713892437 | (37.733316146518, -122.467713892437) | 9 | 8 | 4 | 59 | 40 | |
| 821 | 261708 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Entrada Ct | 1 | Front Yard : Yard | Tree | Private 2 | 02/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783258 | 5992481.8221 | 2092418.55282 | 37.724951011222 | -122.468170882637 | (37.724951011222, -122.468170882637) | 9 | 8 | 4 | 59 | 40 | |
| 1002 | 260458 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 835 Darien Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/19/2019 12:00:00 AM | 3 | 6x10 | Permit Number 784514 | 5994066 | 2094094 | 37.7296427463027 | -122.462816092129 | (37.7296427463027, -122.462816092129) | 9 | 8 | 4 | 59 | 40 | |
| 1475 | 80073 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2788 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5985889.2586 | 2096432.3825 | 37.735588983385 | -122.491255586179 | (37.735588983385, -122.491255586179) | 1 | 8 | 3 | 64 | 35 | |||
| 1697 | 92318 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2787 34th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985842.0312 | 2096446.1793 | 37.7356241060746 | -122.49141988223 | (37.7356241060746, -122.49141988223) | 1 | 8 | 3 | 29491 | 35 | ||
| 1773 | 116537 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 6 | Back Yard : Yard | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754 | 2090179 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | 9 | 8 | 6 | 28861 | 24 | |
| 2201 | 107549 | Significant Tree 6 | Tree(s) :: 17 | 198X Jennings St | 2 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.7393885572332 | -122.377570991407 | (37.7393885572332, -122.377570991407) | 10 | 3 | 8 | 58 | 1 | ||
| 2213 | 261044 | Significant Tree 6 | Tilia cordata :: Littleleaf Linden 12 | 499x Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2019 12:00:00 AM | 3 | 3x3 | 6014038 | 2115260 | 37.7888900740934 | -122.39525236007 | (37.7888900740934, -122.39525236007) | 6 | 2 | 9 | 28855 | 6 | ||
| 2591 | 92319 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2788 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985889.2586 | 2096423.8922 | 37.7355656712712 | -122.491254961509 | (37.7355656712712, -122.491254961509) | 1 | 8 | 3 | 64 | 35 | ||
| 3182 | 261252 | Significant Tree 6 | Banksia integrifolia :: Coast Banksia 21 | 100 Collins St | 1 | Front Yard : Cutout | Tree | Private 2 | 12/18/2019 12:00:00 AM | 3 | |||||||||||||
| 4096 | 261159 | Significant Tree 6 | Tree(s) :: 17 | 1100X Moraga St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/22/2020 12:00:00 AM | 3 | 10x10 | Permit Number 784837 | 5990881 | 2103853 | 37.7562544846391 | -122.474538790377 | (37.7562544846391, -122.474538790377) | 1 | 8 | 4 | 56 | 12 | |
| 4724 | 262586 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2 Byron Ct | 1 | Front Yard : Yard | Tree | Private 2 | 08/19/2020 12:00:00 AM | 3 | 8x8 | Permit Number 781313 | 5999459.72778 | 2086749.57445 | 37.7097858201455 | -122.443642066205 | (37.7097858201455, -122.443642066205) | 9 | 7 | 6 | 28861 | 5 | |
| 5577 | 92312 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2711 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985822.132 | 2096946.3119 | 37.7369961745626 | -122.49152548244 | (37.7369961745626, -122.49152548244) | 1 | 8 | 3 | 29491 | 35 | ||
| 5622 | 251139 | Significant Tree 6 | Tree(s) :: 17 | 621X Gough St | 1 | Back Yard : Yard | Tree | Private 2 | 03/10/2017 12:00:00 AM | 3 | Permit Number 779685 | ||||||||||||
| 5983 | 110477 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 131X Washington St | 1 | Back Yard : Yard | Tree | Private 2 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 6013427.21844 | 2117958.83498 | 37.7962664536588 | -122.397554954018 | (37.7962664536588, -122.397554954018) | 3 | 1 | 10 | 28860 | 6 | |
| 6364 | 264920 | Significant Tree 6 | Tree(s) :: 17 | 99X Everglade Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 6x10 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |
| 6747 | 261157 | Significant Tree 6 | Tree(s) :: 17 | 1100X Moraga St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/22/2020 12:00:00 AM | 3 | 10x10 | Permit Number 784837 | 5990881 | 2103853 | 37.7562544846391 | -122.474538790377 | (37.7562544846391, -122.474538790377) | 1 | 8 | 4 | 56 | 12 | |
| 6931 | 92315 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2783 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985839.9086 | 2096474.3035 | 37.7357012036342 | -122.491429290175 | (37.7357012036342, -122.491429290175) | 1 | 8 | 3 | 29491 | 35 | ||
| 7770 | 98170 | Significant Tree 6 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2324 Sacramento St | Front Yard : Yard | Tree | Private 2 | 12/22/2011 12:00:00 AM | 3 | Permit Number 768454 | 6003670.2 | 2115963.1 | 37.7902385582714 | -122.431173718492 | (37.7902385582714, -122.431173718492) | 13 | 9 | 1 | 29490 | 27 | |||
| 7796 | 264921 | Significant Tree 6 | Tree(s) :: 17 | 99X Everglade Dr | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 6x10 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |
| 8007 | 261753 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 127 Edgehill Way | 3 | Back Yard : Cutout | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | 5994849.50332 | 2098967.43632 | 37.7430690988325 | -122.46046044555 | (37.7430690988325, -122.46046044555) | 1 | 8 | 4 | 59 | 40 | |||
| 8183 | 261995 | Significant Tree 6 | Phoenix spp :: Date palm (species unknown) 255 | 2727 Pierce St | 2 | Front Yard : Yard | Tree | Private 2 | 10/07/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785198 | 6001553 | 2117834 | 37.7952553588401 | -122.438633170174 | (37.7952553588401, -122.438633170174) | 13 | 9 | 1 | 57 | 27 | |
| 8316 | 260638 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 3140 25th St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008726.17419 | 2101580.94088 | 37.7510337250786 | -122.412663209658 | (37.7510337250786, -122.412663209658) | 2 | 4 | 7 | 28859 | 19 | |||
| 8580 | 261010 | Significant Tree 6 | Tree(s) :: 17 | 91 Parkridge Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784979 | 5998980 | 2102204 | 37.7521926688144 | -122.446411148664 | (37.7521926688144, -122.446411148664) | 2 | 5 | 5 | 63 | 38 | |
| 9381 | 261160 | Significant Tree 6 | Tree(s) :: 17 | 1100X Moraga St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/22/2020 12:00:00 AM | 3 | 10x10 | Permit Number 784837 | 5990881 | 2103853 | 37.7562544846391 | -122.474538790377 | (37.7562544846391, -122.474538790377) | 1 | 8 | 4 | 56 | 12 | |
| 9495 | 261033 | Significant Tree 6 | Tree(s) :: 17 | 551 Los Palmos Dr | 1 | Front Yard : Yard | Tree | Private 2 | 01/14/2020 12:00:00 AM | 3 | 10x10 | Permit Number 784596 | 5996615 | 2095626 | 37.7339957349096 | -122.454114584985 | (37.7339957349096, -122.454114584985) | 9 | 7 | 4 | 59 | 40 | |
| 9908 | 215094 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 218 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994821.63014 | 2087784.20309 | 37.7123610457095 | -122.459746958272 | (37.7123610457095, -122.459746958272) | 9 | 8 | 6 | 28861 | 24 | |
| 10123 | 257894 | Significant Tree 6 | Metrosideros robusta :: Northern Rata Tree 335 | 1776 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 01/27/2020 12:00:00 AM | 3 | 6005064 | 2118169 | 37.7963742870274 | -122.426508408066 | (37.7963742870274, -122.426508408066) | 13 | 9 | 1 | 28858 | 17 | |||
| 10910 | 120918 | Significant Tree 6 | Tree(s) :: 17 | 555x SAN JOSE AVE | 2 | Front Yard : Yard | Tree | Private 2 | 11/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778877 | 6006305 | 2100249 | 37.747240333103 | -122.420941331562 | (37.747240333103, -122.420941331562) | 2 | 7 | 7 | 28859 | 2 | |
| 11618 | 92317 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2787 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985840.9699 | 2096433.9745 | 37.7355905329114 | -122.491422653463 | (37.7355905329114, -122.491422653463) | 1 | 8 | 3 | 29491 | 35 | ||
| 11628 | 261752 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 127 Edgehill Way | 2 | Back Yard : Cutout | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | 5994849.50332 | 2098967.43632 | 37.7430690988325 | -122.46046044555 | (37.7430690988325, -122.46046044555) | 1 | 8 | 4 | 59 | 40 | |||
| 12273 | 261709 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Entrada Ct | 2 | Front Yard : Yard | Tree | Private 2 | 02/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783258 | 5992481.8221 | 2092418.55282 | 37.724951011222 | -122.468170882637 | (37.724951011222, -122.468170882637) | 9 | 8 | 4 | 59 | 40 | |
| 12868 | 111864 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Allston Way | 1 | Front Yard : Yard | Tree | Private 2 | 06/26/2015 12:00:00 AM | 3 | Permit Number 775591 | 5994228.4 | 2098418 | 37.7415247340782 | -122.462568190827 | (37.7415247340782, -122.462568190827) | 1 | 8 | 4 | 59 | 40 | ||
| 12923 | 237906 | Significant Tree 6 | Tree(s) :: 17 | 3937 21st St | 3 | Front Yard : Yard | Tree | Private 2 | 10/06/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785171 | 6002245.41508 | 2103514.00804 | 37.7559756019151 | -122.43521254633 | (37.7559756019151, -122.43521254633) | 2 | 4 | 5 | 28862 | 22 | |
| 13120 | 258703 | Significant Tree 6 | Tree(s) :: 17 | 131X Juan Bautista Cir | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783241 | 5989556 | 2089774 | 37.7175203194228 | -122.478091750656 | (37.7175203194228, -122.478091750656) | 1 | 8 | 4 | 64 | 14 | |
| 13252 | 92316 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2787 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985840.4393 | 2096424.4229 | 37.7355642757438 | -122.49142378511 | (37.7355642757438, -122.49142378511) | 1 | 8 | 3 | 29491 | 35 | ||
| 13434 | 260582 | Significant Tree 6 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 2101X Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2019 12:00:00 AM | 3 | 5x5 | Permit Number 782628 | |||||||||||
| 13981 | 261996 | Significant Tree 6 | Phoenix spp :: Date palm (species unknown) 255 | 2727 Pierce St | 1 | Front Yard : Yard | Tree | Private 2 | 10/07/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785198 | 6001553 | 2117834 | 37.7952553588401 | -122.438633170174 | (37.7952553588401, -122.438633170174) | 13 | 9 | 1 | 57 | 27 | |
| 14326 | 112045 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 2418 Pacific Ave | 1 | Front Yard : Yard | Tree | Private 2 | 06/26/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785474 | 6002446.95594 | 2117111.03197 | 37.7933210893366 | -122.435488200226 | (37.7933210893366, -122.435488200226) | 13 | 9 | 1 | 29490 | 27 | |
| 14608 | 259056 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 99 Cedro Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784357 | 5992279 | 2093128 | 37.7268872622364 | -122.468923614031 | (37.7268872622364, -122.468923614031) | 9 | 8 | 4 | 59 | 40 | |
| 14866 | 259322 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1721 19th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783194 | 5990247 | 2103661 | 37.7556905489205 | -122.476717329726 | (37.7556905489205, -122.476717329726) | 1 | 8 | 3 | 56 | 35 | |
| 15509 | 258701 | Significant Tree 6 | Tree(s) :: 17 | 206 Edgewood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783089 | 5996625 | 2105876 | 37.7621402663071 | -122.454820337862 | (37.7621402663071, -122.454820337862) | 15 | 5 | 11 | 29492 | 12 | |
| 15674 | 258702 | Significant Tree 6 | Tree(s) :: 17 | 131X Juan Bautista Cir | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783241 | 5989556 | 2089774 | 37.7175203194228 | -122.478091750656 | (37.7175203194228, -122.478091750656) | 1 | 8 | 4 | 64 | 14 | |
| 16055 | 260578 | Significant Tree 6 | Tree(s) :: 17 | 1879 Funston Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/22/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 784834 | 5992075.37659 | 2102679.56742 | 37.7531016753032 | -122.470322812874 | (37.7531016753032, -122.470322812874) | 1 | 8 | 4 | 56 | 12 | |
| 16207 | 254459 | Significant Tree 6 | Tree(s) :: 17 | 1055X Duncan St | 4 | Side Yard : Yard | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | Permit Number 780800 | ||||||||||||
| 16794 | 261146 | Significant Tree 6 | Ficus Spp. :: 101 | 375x Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2020 12:00:00 AM | 3 | 3x3 | 6014494 | 2112212 | 37.780546313007 | -122.393461254196 | (37.780546313007, -122.393461254196) | 6 | 2 | 9 | 28856 | 6 | ||
| 16799 | 261042 | Significant Tree 6 | Tilia cordata :: Littleleaf Linden 12 | 499x Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2019 12:00:00 AM | 3 | 3x3 | 6014038 | 2115260 | 37.7888900740934 | -122.39525236007 | (37.7888900740934, -122.39525236007) | 6 | 2 | 9 | 28855 | 6 | ||
| 19112 | 261751 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 127 Edgehill Way | 1 | Back Yard : Cutout | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | 5994849.50332 | 2098967.43632 | 37.7430690988325 | -122.46046044555 | (37.7430690988325, -122.46046044555) | 1 | 8 | 4 | 59 | 40 | |||
| 19367 | 254458 | Significant Tree 6 | Tree(s) :: 17 | 1055X Duncan St | 3 | Side Yard : Yard | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | Permit Number 780800 | ||||||||||||
| 20184 | 108109 | Significant Tree 6 | Tree(s) :: 17 | 952 CAPP ST | 1 | Front Yard : Yard | Tree | Private 2 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774355 | 6007364.7 | 2101732.3 | 37.7513728159016 | -122.417382061559 | (37.7513728159016, -122.417382061559) | 2 | 4 | 7 | 28859 | 19 | |
| 20293 | 254534 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 737 Buena Vista Ave West | 6 | Front Yard : Yard | Tree | Private 2 | 02/27/2018 12:00:00 AM | 3 | 10X10 | 5999910.14564 | 2107959.614 | 37.7680492454315 | -122.443607999122 | (37.7680492454315, -122.443607999122) | 15 | 5 | 5 | 29492 | 9 | ||
| 21303 | 115100 | Significant Tree 6 | Tree(s) :: 17 | 710 PACHECO ST | 1 | Front Yard : Cutout | Tree | Private 2 | 02/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777305 | 5992727 | 2102215 | 37.7518637464828 | -122.468035600741 | (37.7518637464828, -122.468035600741) | 1 | 8 | 4 | 29491 | 12 | |
| 23612 | 253210 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 567 Mississippi St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/02/2019 12:00:00 AM | 3 | 3x3 | 6014163 | 2104519 | 37.7594046471392 | -122.394067636073 | (37.7594046471392, -122.394067636073) | 10 | 3 | 8 | 28856 | 29 | ||
| 26477 | 253808 | Significant Tree 6 | Tree(s) :: 17 | 2 Garfield St | 2 | Side Yard : Yard | Tree | Private 2 | 09/14/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780744 | 5993976 | 2090624 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | 9 | 8 | 6 | 64 | 24 | |
| 26906 | 110476 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3700 Washington St | 1 | Back Yard : Yard | Tree | Private 2 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 5997015.1 | 2115715 | 37.7891779638687 | -122.454181816252 | (37.7891779638687, -122.454181816252) | 11 | 6 | 1 | 54 | 31 | |
| 28531 | 173636 | Significant Tree 6 | Tree(s) :: 17 | 2590 Pacific Ave | 2 | Front Yard : Yard | Tree | Private 2 | 05/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779167 | 6001760 | 2117029 | 37.7930568116395 | -122.43785923272 | (37.7930568116395, -122.43785923272) | 13 | 6 | 1 | 29490 | 27 | |
| 31713 | 107635 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 1150 Lombard St | 10 | Front Yard : Yard | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | Permit Number 773092 | 6006825.00646 | 2120436.80144 | 37.8027004912885 | -122.420576003873 | (37.8027004912885, -122.420576003873) | 5 | 1 | 1 | 28858 | 32 | ||
| 32199 | 253765 | Significant Tree 6 | Cornus SPP :: Dogwood 355 | 1366 Guerrero St | 2 | Front Yard : Yard | Tree | Private 2 | 02/14/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780977 | 6005800.08489 | 2101007.66776 | 37.7492949871928 | -122.422741198761 | (37.7492949871928, -122.422741198761) | 2 | 4 | 5 | 28859 | 19 | |
| 32335 | 173635 | Significant Tree 6 | Tree(s) :: 17 | 2590 Pacific Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 05/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779167 | 6001760 | 2117029 | 37.7930568116395 | -122.43785923272 | (37.7930568116395, -122.43785923272) | 13 | 6 | 1 | 29490 | 27 | |
| 32791 | 254539 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 737 Buena Vista Ave West | 5 | Front Yard : Yard | Tree | Private 2 | 02/27/2018 12:00:00 AM | 3 | 10X10 | 5999910.14564 | 2107959.614 | 37.7680492454315 | -122.443607999122 | (37.7680492454315, -122.443607999122) | 15 | 5 | 5 | 29492 | 9 | ||
| 35924 | 89310 | Significant Tree 6 | Tree(s) :: 17 | 32 Lyon St | 2 | Front Yard : Yard | Tree | Private 2 | 06/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780094 | 6000399 | 2109002 | 37.7709392449299 | -122.441991937871 | (37.7709392449299, -122.441991937871) | 15 | 5 | 11 | 29492 | 9 | |
| 36574 | 107552 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 2 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
| 37092 | 254109 | Significant Tree 6 | Tree(s) :: 17 | 38X Starview Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 6x6 | Permit Number 781050 | 5997469 | 2101545 | 37.7502968010125 | -122.451588863361 | (37.7502968010125, -122.451588863361) | 1 | 5 | 4 | 63 | 38 | |
| 37232 | 256765 | Significant Tree 6 | Tree(s) :: 17 | 355 Serrano Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/15/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782555 | 5988732 | 2090042 | 37.7182083166364 | -122.480959519123 | (37.7182083166364, -122.480959519123) | 1 | 8 | 4 | 64 | 14 | |
| 37577 | 100056 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 401X Tehama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011330.4 | 2112435.9 | 37.7809848079497 | -122.404421471201 | (37.7809848079497, -122.404421471201) | 14 | 2 | 9 | 28853 | 34 | |
| 40123 | 256065 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 2800 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2018 12:00:00 AM | 3 | 3x3 | 6002545 | 2117972 | 37.7956906526811 | -122.435210571933 | (37.7956906526811, -122.435210571933) | 13 | 9 | 1 | 57 | 17 | ||
| 41224 | 258232 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 04/24/2019 12:00:00 AM | 3 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||
| 42183 | 110954 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 126X Mendell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 6017060.74507 | 2098543.22184 | 37.7431570265693 | -122.383629676533 | (37.7431570265693, -122.383629676533) | 10 | 3 | 8 | 58 | 1 | |||
| 43728 | 254538 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 737 Buena Vista Ave West | 4 | Front Yard : Yard | Tree | Private 2 | 02/27/2018 12:00:00 AM | 3 | 10X10 | 5999910.14564 | 2107959.614 | 37.7680492454315 | -122.443607999122 | (37.7680492454315, -122.443607999122) | 15 | 5 | 5 | 29492 | 9 | ||
| 45577 | 92320 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2733 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5984522 | 2096783 | 37.7364716996862 | -122.496008508371 | (37.7364716996862, -122.496008508371) | 1 | 8 | 3 | 29491 | 35 | |
| 46153 | 209002 | Significant Tree 6 | Tree(s) :: 17 | 115 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/17/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781950 | 5994125 | 2096751 | 37.7369416119865 | -122.462804803775 | (37.7369416119865, -122.462804803775) | 9 | 8 | 4 | 59 | 40 | |
| 51717 | 115446 | Significant Tree 6 | Tree(s) :: 17 | 546 FRANCONIA ST | 2 | Back Yard : Yard | Tree | Private 2 | 04/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777844 | 6009931 | 2098208 | 37.7418399166086 | -122.408258912238 | (37.7418399166086, -122.408258912238) | 10 | 7 | 7 | 28859 | 2 | |
| 52054 | 255462 | Significant Tree 6 | Tree(s) :: 17 | 98 Saint Francis Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2018 12:00:00 AM | 3 | 10x5 | Permit Number 777805 | 5992112.53458 | 2095987.97644 | 37.7347304251367 | -122.469707196177 | (37.7347304251367, -122.469707196177) | 9 | 8 | 4 | 59 | 40 | |
| 52558 | 255280 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 320 Magellan Ave | 1 | Front Yard : Yard | Tree | Private 2 | 05/01/2018 12:00:00 AM | 3 | 10x20 | Permit Number 781012 | 5994287.14264 | 2099988.88368 | 37.7458413694018 | -122.462478996433 | (37.7458413694018, -122.462478996433) | 1 | 8 | 4 | 29491 | 40 | |
| 54288 | 115736 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 66 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776551 | 5993801.4 | 2096894.7 | 37.7373175329251 | -122.463934052027 | (37.7373175329251, -122.463934052027) | 1 | 8 | 4 | 59 | 40 | ||
| 55458 | 255165 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 371 Prospect Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781717 | 6006352.58239 | 2097791.19314 | 37.7404944317648 | -122.420602351048 | (37.7404944317648, -122.420602351048) | 2 | 7 | 7 | 28859 | 2 | |
| 56372 | 107551 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 1 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
| 57424 | 101476 | Significant Tree 6 | :: 45 | 541 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2015 12:00:00 AM | 3 | Permit Number 775316 | 6000089 | 2095440.1 | 37.7336838892166 | -122.442090592963 | (37.7336838892166, -122.442090592963) | 9 | 7 | 4 | 63 | 40 | ||
| 58512 | 253898 | Significant Tree 6 | Tree(s) :: 17 | 201X Oak Park Dr | 2 | Back Yard : Yard | Tree | Private 2 | 01/17/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780818 | 5996124 | 2103402 | 37.7553185401494 | -122.45637419556 | (37.7553185401494, -122.45637419556) | 1 | 5 | 4 | 63 | 12 |
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) );