trees
184 rows where SiteOrder = 2 and qLegalStatus_id = 2 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8065 | 255771 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 450 Toland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2018 12:00:00 AM | 3 | Permit Number 779472 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
9263 | 254120 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 150 Jennings St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/02/2018 12:00:00 AM | 3 | Permit Number 781123 | ||||||||||||
17897 | 254369 | Planning Code 138.1 required 2 | Citrus spp :: Lemon: Orange: Lime 120 | 590X Orizaba Ave | 2 | Back Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | ||||||||||||
34272 | 115532 | Planning Code 138.1 required 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 100X Hayes St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007293.46404 | 2111265.83422 | 37.7775456658356 | -122.418304279225 | (37.7775456658356, -122.418304279225) | 7 | 9 | 9 | 28852 | 36 | ||
48155 | 107646 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1600X Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2016 12:00:00 AM | 3 | Permit Number 773331 | 6005773.76538 | 2115716.99395 | 37.7896817924241 | -122.423878022401 | (37.7896817924241, -122.423878022401) | 13 | 9 | 1 | 28858 | 41 | ||
60942 | 247939 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 29 Joy St | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 12 | Permit Number 775404 | 6010258.29977 | 2098917.51569 | 37.7438064148349 | -122.40717721395 | (37.7438064148349, -122.40717721395) | 2 | 7 | 7 | 28859 | 2 | |||
74634 | 254115 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Newhall St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/02/2018 12:00:00 AM | 3 | Permit Number 781123 | 6018720.08887 | 2097065.44422 | 37.739190920851 | -122.377789500691 | (37.739190920851, -122.377789500691) | 10 | 3 | 8 | 58 | 1 | ||
95475 | 46434 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2St. Ankeny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 1 | Permit Number 47151 | 6011096.25435 | 2089701.2859 | 37.7185474406786 | -122.40363143174 | (37.7185474406786, -122.40363143174) | 10 | 7 | 8 | 309 | 28 | |
120325 | 112085 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99X Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.7905278405438 | -122.396700174955 | (37.7905278405438, -122.396700174955) | 12 | 2 | 9 | 28855 | 6 | |||
126777 | 254698 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 2051 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Permit Number 778364 | 6015756.78552 | 2106043.12781 | 37.763678027819 | -122.388661890454 | (37.763678027819, -122.388661890454) | 14 | 3 | 8 | 28856 | 29 | ||
131750 | 39246 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3524 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | 1 | Permit Number 772836 | 5997390.1418 | 2116079.35829 | 37.7901998932662 | -122.452910535096 | (37.7901998932662, -122.452910535096) | 11 | 6 | 1 | 54 | 31 | ||
145856 | 254700 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 650 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Permit Number 778364 | 6015970.50894 | 2106056.61706 | 37.7637269088073 | -122.387923622314 | (37.7637269088073, -122.387923622314) | 14 | 3 | 8 | 28856 | 29 | ||
158442 | 254367 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 79 Ashton Ave | 2 | Front Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | 5994130.90698 | 2090445.22251 | 37.7196278254181 | -122.462327167234 | (37.7196278254181, -122.462327167234) | 9 | 8 | 6 | 28861 | 24 | ||
160771 | 187941 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015065.49236 | 2115322.58848 | 37.7891190169896 | -122.391701726057 | (37.7891190169896, -122.391701726057) | 6 | 2 | 9 | 28855 | 6 | ||||
164459 | 116850 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 83 Panorama Dr | 2 | Front Yard : Yard | Tree | Private 2 | 05/03/2016 12:00:00 AM | 3 | 5997625.8 | 2100317.8 | 37.7469361901044 | -122.450958160054 | (37.7469361901044, -122.450958160054) | 1 | 5 | 4 | 59 | 38 | |||
167671 | 256690 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 2825 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2018 12:00:00 AM | 3 | Permit Number 772474 | 5986729.50015 | 2114421.37847 | 37.7850308764656 | -122.489673069254 | (37.7850308764656, -122.489673069254) | 11 | 6 | 1 | 55 | 33 | ||
48760 | 255654 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 298X Coso Ave | 2 | Side Yard : Yard | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 10x10 | Permit Number 776462 | 6007785 | 2099424 | 37.7450583812321 | -122.415765181935 | (37.7450583812321, -122.415765181935) | 2 | 7 | 7 | 28859 | 2 | |
16166 | 166316 | Planning Code 138.1 required 2 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2019 12:00:00 AM | 3 | 10x4 | Permit Number 779829 | 6008870.16891 | 2103155.64589 | 37.7553655917605 | -122.412276546247 | (37.7553655917605, -122.412276546247) | 2 | 4 | 7 | 28859 | 19 | |
37189 | 121502 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 299 Fremont St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4 | 10x4 | 6014428.99687 | 2115060.94265 | 37.7883652457059 | -122.393885614549 | (37.7883652457059, -122.393885614549) | 6 | 2 | 9 | 28855 | 6 | |||
88090 | 85806 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 210X Shipley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011627 | 2111882 | 37.7794804977568 | -122.403356401218 | (37.7794804977568, -122.403356401218) | 14 | 2 | 9 | 28856 | 34 | |
190939 | 13063 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 590 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2017 12:00:00 AM | 3 | 2X2 | Permit Number 780933 | 6009554.3361 | 2120533.7978 | 37.803120257284 | -122.411137959105 | (37.803120257284, -122.411137959105) | 3 | 1 | 10 | 308 | 23 | |
28863 | 115887 | Planning Code 138.1 required 2 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 | 134 Lunado Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | 2x4 | Permit Number 772714 | 5991633.6 | 2092401.5 | 37.7248551637156 | -122.471101821397 | (37.7248551637156, -122.471101821397) | 9 | 8 | 4 | 59 | 40 | |
122740 | 115096 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 537 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010119.08101 | 2111896.4319 | 37.7794357889593 | -122.408573975335 | (37.7794357889593, -122.408573975335) | 14 | 2 | 9 | 28853 | 34 | |
639 | 261347 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 780859 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
61214 | 15236 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2015 12:00:00 AM | 3 | 3X3 | Permit Number 770747 | 6008261.49106 | 2110663.48431 | 37.7759461992201 | -122.414912896556 | (37.7759461992201, -122.414912896556) | 8 | 2 | 9 | 28853 | 34 | |
100024 | 258333 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 215X Raccoon Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 04/29/2019 12:00:00 AM | 3 | 3X3 | Permit Number 776074 | |||||||||||
158086 | 15247 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1401X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770901 | 6007902.55668 | 2110326.57547 | 37.7750009522643 | -122.416130681693 | (37.7750009522643, -122.416130681693) | 8 | 2 | 9 | 28853 | 34 | |
12720 | 115537 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
95904 | 256882 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3075 25th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/21/2018 12:00:00 AM | 3 | 3x10 | Permit Number 781920 | 5988824.60597 | 2094879.63635 | 37.7314966214822 | -122.480993433312 | (37.7314966214822, -122.480993433312) | 1 | 8 | 4 | 64 | 35 | |
186896 | 114793 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 10 Linares Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x10 | Permit Number 777094 | 5993887.4 | 2102332.1 | 37.7522522176371 | -122.464031307011 | (37.7522522176371, -122.464031307011) | 1 | 8 | 4 | 29491 | 40 | |||
26464 | 251519 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | 7 | 9 | 5 | 28862 | 3 | ||||
3 | 121463 | Planning Code 138.1 required 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 415 Oxford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2020 12:00:00 AM | 3 | 3x3 | Permit Number 778984 | 6006773.54328 | 2092061.724 | 37.7247862819155 | -122.418740608563 | (37.7247862819155, -122.418740608563) | 9 | 7 | 7 | 309 | 28 | |
642 | 260182 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 66x McCoppin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2019 12:00:00 AM | 3 | 3x3 | 6006141 | 2109130 | 37.7716162396968 | -122.422139269172 | (37.7716162396968, -122.422139269172) | 8 | 2 | 9 | 28853 | 19 | ||
1560 | 258220 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 477 Eucalyptus Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774069 | 5989683 | 2094686 | 37.7310148065902 | -122.478011682019 | (37.7310148065902, -122.478011682019) | 1 | 8 | 4 | 64 | 14 | |
1675 | 225195 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007206.11976 | 2103835.77909 | 37.7571395647689 | -122.418079559351 | (37.7571395647689, -122.418079559351) | 2 | 4 | 7 | 28859 | 19 | ||
1751 | 121138 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1388x Minna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
6889 | 173762 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1405 Van Dyke Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2017 12:00:00 AM | 3 | 3x3 | Permit Number 773007 | 6015436.02818 | 2092717.71929 | 37.727071439337 | -122.388840955894 | (37.727071439337, -122.388840955894) | 10 | 3 | 8 | 58 | 1 | |
7182 | 262122 | Planning Code 138.1 required 2 | Potential Site :: Potential Site 48 | 296x Day St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004047 | 2098716 | 37.7429035313116 | -122.428640063872 | (37.7429035313116, -122.428640063872) | 2 | 7 | 5 | 63 | 22 | ||||
8046 | 261018 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 79 Cragmont Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774761 | 5992858 | 2101375 | 37.749564886931 | -122.467521508976 | (37.749564886931, -122.467521508976) | 1 | 8 | 4 | 29491 | 12 | |
8436 | 260432 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 181 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/2019 12:00:00 AM | 3 | 3x3 | 6013986 | 2115554 | 37.7896944377585 | -122.395452879395 | (37.7896944377585, -122.395452879395) | 12 | 2 | 9 | 28855 | 6 | ||
8699 | 262221 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 240 Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 781435 | 6004728 | 2102256 | 37.7526620712812 | -122.426537368454 | (37.7526620712812, -122.426537368454) | 2 | 4 | 5 | 28862 | 22 | |
11471 | 260869 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 198x Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | 3x3 | 6009475 | 2113668 | 37.7842640010762 | -122.410927291409 | (37.7842640010762, -122.410927291409) | 14 | 10 | 9 | 28852 | 36 | ||
12606 | 261830 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 256 Casitas Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/05/2020 12:00:00 AM | 3 | 3x3 | Permit Number 781540 | 5994862.12068 | 2096567.59314 | 37.7364804498834 | -122.460242983215 | (37.7364804498834, -122.460242983215) | 9 | 7 | 4 | 59 | 40 | |
13037 | 152668 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 811 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777381 | 6008574.99769 | 2103713.14234 | 37.7568797829862 | -122.413336764205 | (37.7568797829862, -122.413336764205) | 2 | 4 | 7 | 28859 | 19 | |
14010 | 261579 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 496 Urbano Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
14035 | 159355 | Planning Code 138.1 required 2 | Melaleuca quinquenervia :: Cajeput 10 | 417 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998509.88268 | 2087558.19074 | 37.7119518775514 | -122.44698304145 | (37.7119518775514, -122.44698304145) | 9 | 7 | 6 | 28861 | 25 | |
16696 | 195151 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1912 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6012043 | 2105629 | 37.7623344042956 | -122.401477690357 | (37.7623344042956, -122.401477690357) | 8 | 3 | 8 | 28856 | 29 | |||
17210 | 225188 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
18512 | 260829 | Planning Code 138.1 required 2 | Callistemon viminalis :: Weeping Bottlebrush 60 | 165 Cerritos Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/10/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781510 | 5991854 | 2092943 | 37.7263547341381 | -122.470379348754 | (37.7263547341381, -122.470379348754) | 9 | 8 | 4 | 59 | 40 | |
19183 | 261351 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 299 Sagamore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784323 | 5994169 | 2087374 | 37.7111971725927 | -122.461972900974 | (37.7111971725927, -122.461972900974) | 9 | 8 | 6 | 28861 | 24 | |
20111 | 1217 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3501 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2016 12:00:00 AM | 3 | 3x3 | 5993695.72185 | 2087421.09824 | 37.7112992341463 | -122.463612070865 | (37.7112992341463, -122.463612070865) | 9 | 8 | 4 | 64 | 24 | ||
20307 | 253871 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2017 12:00:00 AM | 3 | 3x3 | Permit Number 56289 | 6007037 | 2116831 | 37.7928118105792 | -122.419586418272 | (37.7928118105792, -122.419586418272) | 13 | 9 | 10 | 28858 | 32 | |
27168 | 75842 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
27287 | 255049 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 925 Woolsey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779631 | 6009075.60356 | 2091383.60862 | 37.7230536656288 | -122.410734764023 | (37.7230536656288, -122.410734764023) | 9 | 3 | 7 | 309 | 28 | |
30240 | 243370 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006249.22799 | 2103449.78821 | 37.7560258191488 | -122.421361454386 | (37.7560258191488, -122.421361454386) | 2 | 4 | 5 | 28859 | 19 | |
34077 | 256492 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 280 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780675 | 6001741.51076 | 2104267.16046 | 37.7580149486389 | -122.437009129166 | (37.7580149486389, -122.437009129166) | 2 | 4 | 5 | 28862 | 3 | |
36004 | 187698 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2880 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008980.17665 | 2103937.78959 | 37.7575193538388 | -122.41195137385 | (37.7575193538388, -122.41195137385) | 2 | 4 | 7 | 28859 | 19 | ||||
41357 | 255423 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2398X 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780836 | 5982745 | 2098835 | 37.7420016902952 | -122.502304062071 | (37.7420016902952, -122.502304062071) | 1 | 8 | 3 | 29491 | 35 | |
46086 | 115494 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 1199X OCEAN AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777362 | 5996259 | 2091739 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | 9 | 8 | 4 | 28861 | 24 | |
47024 | 120519 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 520 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010156 | 2108818 | 37.7709851997146 | -122.408229076629 | (37.7709851997146, -122.408229076629) | 8 | 2 | 9 | 28853 | 34 | ||||
47537 | 18353 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 480 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2013 12:00:00 AM | 3 | 3x3 | 6010310.70956 | 2106111.3358 | 37.7635619805233 | -122.407503071611 | (37.7635619805233, -122.407503071611) | 8 | 4 | 8 | 28859 | 19 | ||
49019 | 113699 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 239 Minerva St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778180 | 5994635.15348587 | 2088996.04011087 | 37.7156777383317 | -122.460479228374 | (37.7156777383317, -122.460479228374) | 9 | 8 | 6 | 28861 | 24 | |
49532 | 256566 | Planning Code 138.1 required 2 | Acer buergeranum :: Trident Maple 110 | 2099X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002352 | 2115365 | 37.7885215412843 | -122.435691777518 | (37.7885215412843, -122.435691777518) | 13 | 6 | 1 | 29490 | 27 | ||||
51709 | 173899 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 1762 12th Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 779465 | 5992511.90241 | 2103608.89481 | 37.7556785957656 | -122.468880856653 | (37.7556785957656, -122.468880856653) | 1 | 8 | 4 | 56 | 12 | |||
52945 | 117454 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 236 Shipley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776408 | 6011519 | 2111785 | 37.7792081256956 | -122.403723194086 | (37.7792081256956, -122.403723194086) | 14 | 2 | 9 | 28856 | 34 | |
55332 | 115079 | Planning Code 138.1 required 2 | Brahea edulis :: Guadalupe Palm 218 | 1746 Great Hwy | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5981053.87958296 | 2103176.2415425 | 37.7538220108937 | -122.508473505042 | (37.7538220108937, -122.508473505042) | 1 | 8 | 3 | 56 | 35 | ||||
56397 | 251539 | Planning Code 138.1 required 2 | Brahea edulis :: Guadalupe Palm 218 | 1746 Great Hwy | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5981086 | 2103156 | 37.753768326371 | -122.508360924805 | (37.753768326371, -122.508360924805) | 1 | 8 | 3 | 56 | 35 | ||||
57241 | 253248 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 570 Jessie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.13768 | 37.7809123781536 | -122.409958002933 | (37.7809123781536, -122.409958002933) | 14 | 2 | 9 | 28853 | 34 | |
57409 | 256506 | Planning Code 138.1 required 2 | Cercis canadensis :: Eastern Redbud 346 | 978 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/15/2018 12:00:00 AM | 3 | 3x3 | 6005672.85931 | 2103292.97405 | 37.7555627312558 | -122.423343584439 | (37.7555627312558, -122.423343584439) | 2 | 4 | 5 | 28859 | 19 | ||
60760 | 122593 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 72 Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
64240 | 112973 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4099x ULLOA ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 773327 | 5983385 | 2098079 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | 1 | 8 | 3 | 29491 | 35 | ||
64492 | 117113 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1650 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773961 | 6005663.57094 | 2117913.49378 | 37.7957066076266 | -122.424415580821 | (37.7957066076266, -122.424415580821) | 13 | 9 | 1 | 28858 | 27 | |
70032 | 253393 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.16338 | 2116767.09226 | 37.7930680031541 | -122.392879995147 | (37.7930680031541, -122.392879995147) | 12 | 2 | 9 | 28855 | 6 | |
70866 | 224462 | Planning Code 138.1 required 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2810 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775960 | 6010311.37562 | 2101086.64633 | 37.7497653433983 | -122.407146558773 | (37.7497653433983, -122.407146558773) | 2 | 4 | 7 | 28859 | 19 | |
72671 | 255301 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1238 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777218 | 6006649 | 2115006 | 37.7877789501949 | -122.420799295532 | (37.7877789501949, -122.420799295532) | 13 | 9 | 10 | 28858 | 21 | |
81974 | 256777 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2828 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777329 | 6003004.23187 | 2118313.15271 | 37.7966534371422 | -122.433645942426 | (37.7966534371422, -122.433645942426) | 13 | 9 | 1 | 57 | 17 | |
82212 | 156914 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 2995 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782654 | 6009047.12311 | 2101072.92433 | 37.7496568330138 | -122.411517443787 | (37.7496568330138, -122.411517443787) | 2 | 4 | 7 | 28859 | 19 | |
87472 | 255403 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 150 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
93272 | 256871 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 1025 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776275 | 6009358.6182 | 2098062.94866 | 37.7414095695618 | -122.410227790564 | (37.7414095695618, -122.410227790564) | 10 | 7 | 7 | 28859 | 2 | |
96128 | 73589 | Planning Code 138.1 required 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 468 Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/1995 12:00:00 AM | 12 | 3x3 | Permit Number 770905 | 6010928.13640467 | 2111848.51157587 | 37.7793494887795 | -122.405771720076 | (37.7793494887795, -122.405771720076) | 14 | 2 | 9 | 28853 | 34 | |
97662 | 117018 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 168 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008125.66458 | 2112987.05621 | 37.7823185388132 | -122.415547303188 | (37.7823185388132, -122.415547303188) | 7 | 10 | 9 | 28852 | 36 | |
100425 | 243144 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 98x Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2017 12:00:00 AM | 3 | 3x3 | 6006195 | 2098242 | 37.7417233638646 | -122.421179213365 | (37.7417233638646, -122.421179213365) | 2 | 7 | 7 | 28859 | 2 | ||
102847 | 256610 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 80 Terra Vista Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780481 | 6000092 | 2112863 | 37.7815230689536 | -122.443331223004 | (37.7815230689536, -122.443331223004) | 15 | 5 | 1 | 29490 | 16 | |
109022 | 255406 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
113669 | 159358 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 49 Naglee Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998584.62871 | 2087583.88571 | 37.712026700246 | -122.446726546692 | (37.712026700246, -122.446726546692) | 9 | 7 | 6 | 28861 | 25 | |
117515 | 119808 | Planning Code 138.1 required 2 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1634 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773331 | 6006048 | 2115627 | 37.7894501691998 | -122.422922798032 | (37.7894501691998, -122.422922798032) | 13 | 9 | 1 | 28858 | 41 | |
121157 | 257909 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 199x Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2019 12:00:00 AM | 3 | 3x3 | 6014800 | 2111540 | 37.778718149686 | -122.392355631341 | (37.778718149686, -122.392355631341) | 6 | 2 | 9 | 28856 | 20 | ||
123272 | 256677 | Planning Code 138.1 required 2 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 330 Twin Peaks Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2019 12:00:00 AM | 3 | 3x3 | 5998688 | 2103995 | 37.7570936308358 | -122.447549834506 | (37.7570936308358, -122.447549834506) | 15 | 5 | 4 | 63 | 38 | ||
126056 | 255417 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99x Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6007395 | 2111066 | 37.7770026839515 | -122.417938862064 | (37.7770026839515, -122.417938862064) | 7 | 9 | 9 | 28852 | 36 | ||
126119 | 85804 | Planning Code 138.1 required 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 923 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778048 | 6011441.4589 | 2111949.4191 | 37.7796552503769 | -122.404003016031 | (37.7796552503769, -122.404003016031) | 14 | 2 | 9 | 28856 | 34 | |
127597 | 103379 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 2712 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2013 12:00:00 AM | 4 | 3x3 | Permit Number 770136 | 6000520 | 2117210 | 37.7934832007909 | -122.44216269001 | (37.7934832007909, -122.44216269001) | 13 | 9 | 1 | 57 | 27 | |
129348 | 251179 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 1043 Minna St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6007668 | 2109797 | 37.7735336727503 | -122.41690453761 | (37.7735336727503, -122.41690453761) | 8 | 2 | 9 | 28853 | 19 | ||||
130529 | 256674 | Planning Code 138.1 required 2 | Cornus florida :: Eastern Dogwood 385 | 330 Twin Peaks Blvd | 2 | Side Yard : Cutout | Tree | Private 2 | 03/27/2019 12:00:00 AM | 3 | 3x3 | 5998688 | 2103995 | 37.7570936308358 | -122.447549834506 | (37.7570936308358, -122.447549834506) | 15 | 5 | 4 | 63 | 38 | ||
130781 | 255652 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 949 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002910 | 2110236 | 37.7744702748436 | -122.433394524315 | (37.7744702748436, -122.433394524315) | 15 | 5 | 11 | 29492 | 10 | ||||
135960 | 103695 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1X Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006027.79546 | 2103458.18152 | 37.7560363783091 | -122.422127839194 | (37.7560363783091, -122.422127839194) | 2 | 4 | 5 | 28859 | 19 | |
135962 | 187674 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2690 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | 2 | 4 | 7 | 28859 | 19 | ||||
148641 | 253378 | Planning Code 138.1 required 2 | :: 45 | 2 Alpine Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001556 | 2108661 | 37.7700688079313 | -122.43796542225 | (37.7700688079313, -122.43796542225) | 15 | 5 | 5 | 29492 | 9 | ||||
152864 | 124718 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 610 Cortland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 775784 | 6007724.21349 | 2097196.46477 | 37.7389386461297 | -122.415817669649 | (37.7389386461297, -122.415817669649) | 2 | 7 | 7 | 28859 | 2 | |
155799 | 256869 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 985 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776274 | 6009287.99434 | 2098069.06568 | 37.7414224065761 | -122.410472416169 | (37.7414224065761, -122.410472416169) | 10 | 7 | 7 | 28859 | 2 | |
161200 | 257940 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 65 Buena Vista Ave East | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2019 12:00:00 AM | 3 | 3x3 | Permit Number 779175 | 6001128.17111 | 2108817.40029 | 37.7704739053605 | -122.439456486198 | (37.7704739053605, -122.439456486198) | 15 | 5 | 11 | 29492 | 9 |
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) );