trees

480 rows where PlotSize = "3x3" and qLegalStatus_id = 2

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

PlotSize ✖

  • 3x3 · 480 ✖
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)
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
27 121462 Planning Code 138.1 required 2 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 415 Oxford St 1 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
524 225191 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 5 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
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
982 104688 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
1023 228184 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1190 Valencia St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 776221 6006352.00962 2102676.26299 37.7539076917969 -122.420951082919 (37.7539076917969, -122.420951082919) 2 4 5 28859 19
1462 225196 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 3160 21st St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 778605 6007182.851 2103832.80652 37.7571300930895 -122.418159821127 (37.7571300930895, -122.418159821127) 2 4 7 28859 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                      
1962 122597 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 42X Colin P Kelly Jr St 5 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
2139 251538 Planning Code 138.1 required 2 Brahea edulis :: Guadalupe Palm 218 1746 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981086 2103156 37.753768326371 -122.508360924805 (37.753768326371, -122.508360924805) 1 8 3 56 35
2311 256568 Planning Code 138.1 required 2 Acer buergeranum :: Trident Maple 110 2099X Steiner St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002352 2115365 37.7885215412843 -122.435691777518 (37.7885215412843, -122.435691777518) 13 6 1 29490 27
2678 157809 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 647 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/06/2019 12:00:00 AM 3 3x3 Permit Number 781831 6002443.37703 2099727.28553 37.7455893990301 -122.4342572226 (37.7455893990301, -122.4342572226) 2 7 5 63 22
2941 261590 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 299x 14th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006795 2107850 37.7681385292637 -122.41978620049 (37.7681385292637, -122.41978620049) 8 4 7 28853 19
3329 260429 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778605 6007240 2103949 37.7574523501876 -122.417970414127 (37.7574523501876, -122.417970414127) 2 4 7 28859 19
3713 225189 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 3 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
3797 260871 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198x Eddy St 4 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
3850 262121 Planning Code 138.1 required 2 Potential Site :: Potential Site 48 296x Day St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004047 2098716 37.7429035313116 -122.428640063872 (37.7429035313116, -122.428640063872) 2 7 5 63 22
3879 260548 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1190 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2018 12:00:00 AM 3 3x3 Permit Number 776221                    
3990 60261 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2495 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2015 12:00:00 AM 12 3x3 Permit Number 776014 6008888.61229415 2103948.71328851 37.7575442102667 -122.412268813453 (37.7575442102667, -122.412268813453) 2 4 7 28859 19
5412 261620 Planning Code 138.1 required 2 Tree(s) :: 17 1633 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2020 12:00:00 AM 3 3x3   6006860 2117000 37.7932658708928 -122.420210847334 (37.7932658708928, -122.420210847334) 13 9 10 28858 32
5422 122567 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 241 Flournoy St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2020 12:00:00 AM 3 3x3 Permit Number 777809 5994026.14526 2086558.74537 37.7089504501359 -122.46240754496 (37.7089504501359, -122.46240754496) 9 8 6 28861 25
5670 253203 Planning Code 138.1 required 2 Acer buergeranum :: Trident Maple 110 349 Mangels Ave 1 Sidewalk: Property side : Cutout Tree Private 2 FUF   3 3x3   5999103 2095207 37.732987611392 -122.445482716078 (37.732987611392, -122.445482716078) 9 7 4 59 40
6093 45072 Planning Code 138.1 required 2 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 596 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3 Permit Number 770844 6012065 2105633 37.7623466149115 -122.401401881236 (37.7623466149115, -122.401401881236) 8 3 8 28856 29
6357 261583 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 496 Urbano Dr 6 Sidewalk: Property side : Yard Tree Private 2       3x3   5992575 2091875 37.7234639294961 -122.467809264789 (37.7234639294961, -122.467809264789) 9 8 4 59 40
6460 261585 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 496 Urbano Dr 8 Sidewalk: Property side : Yard Tree Private 2       3x3   5992575 2091875 37.7234639294961 -122.467809264789 (37.7234639294961, -122.467809264789) 9 8 4 59 40
6487 261445 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 339 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007092 2095790 37.7350412423636 -122.417903903871 (37.7350412423636, -122.417903903871) 2 7 7 28859 2
6489 225192 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 6 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
6598 261578 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 496 Urbano Dr 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5992575 2091875 37.7234639294961 -122.467809264789 (37.7234639294961, -122.467809264789) 9 8 4 59 40
6664 226514 Planning Code 138.1 required 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 248 1225 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/07/2019 12:00:00 AM 3 3x3 Permit Number 781565 6005204.64951 2101211.39699 37.7498207677153 -122.424814719741 (37.7498207677153, -122.424814719741) 2 4 5 28859 19
6762 260431 Planning Code 138.1 required 2 Tree(s) :: 17 181 Fremont St 1 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
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
7223 106240 Planning Code 138.1 required 2 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 586 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3 Permit Number 770844 6012063 2105678 37.7624700633024 -122.401411961161 (37.7624700633024, -122.401411961161) 8 3 8 28856 29
7744 225194 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 3160 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3 Permit Number 778605 6007219.63733 2103836.19178 37.7571414587344 -122.418032839538 (37.7571414587344, -122.418032839538) 2 4 7 28859 19
8011 260843 Planning Code 138.1 required 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 1015 Brussels St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/11/2019 12:00:00 AM 3 3x3 Permit Number 779771 6011450.48648 2090129.50026 37.719743011404 -122.402437083292 (37.719743011404, -122.402437083292) 10 7 8 309 28
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
8102 260181 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 66x McCoppin St 1 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
8190 261370 Planning Code 138.1 required 2 Eriobotrya japonica :: Edible Loquat 119 102 Bache St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007140 2095356 37.7338522748733 -122.417707198486 (37.7338522748733, -122.417707198486) 2 7 7 28859 2
8319 260505 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 760 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/14/2019 12:00:00 AM 3 3x3 Permit Number 784870 6007464 2105234 37.7609932681872 -122.417286789238 (37.7609932681872, -122.417286789238) 2 4 7 28859 19
8349 163331 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 159 Sadowa St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/15/2019 12:00:00 AM 3 3x3 Permit Number 780897 5995371.93865 2087733.0149 37.7122521261194 -122.45784123641 (37.7122521261194, -122.45784123641) 9 8 6 28861 24
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
8598 121137 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1388x Minna St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2016 12:00:00 AM 3 3x3                      
8622 256682 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 330 Twin Peaks Blvd 8 Front Yard : Yard 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
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
8713 261829 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 256 Casitas Ave 1 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
8822 260549 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1190 Valencia St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2018 12:00:00 AM 3 3x3 Permit Number 776221                    
9271 225190 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 778605 6007240 2103949 37.7574523501876 -122.417970414127 (37.7574523501876, -122.417970414127) 2 4 7 28859 19
9333 261584 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 496 Urbano Dr 7 Sidewalk: Property side : Yard Tree Private 2       3x3   5992575 2091875 37.7234639294961 -122.467809264789 (37.7234639294961, -122.467809264789) 9 8 4 59 40
9453 260830 Planning Code 138.1 required 2 Callistemon viminalis :: Weeping Bottlebrush 60 165 Cerritos Ave 3 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
9544 261378 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1762 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/08/2020 12:00:00 AM 3 3x3 Permit Number 784740 5990006.33488 2103376.99766 37.7548967913393 -122.477528860126 (37.7548967913393, -122.477528860126) 1 8 3 56 35
10557 106246 Planning Code 138.1 required 2 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 560 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 770844 6012026 2105714 37.7625668468002 -122.401542461625 (37.7625668468002, -122.401542461625) 8 3 8 28856 29
10742 166681 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 563 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2019 12:00:00 AM 3 3x3   6002718.47853 2102666.28528 37.7536748096657 -122.433515959096 (37.7536748096657, -122.433515959096) 2 4 5 28862 22
11143 258742 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 367 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2019 12:00:00 AM 3 3x3 Permit Number 774042 6003945 2103884 37.7570878795298 -122.429361203627 (37.7570878795298, -122.429361203627) 2 4 5 28862 3
11346 261371 Planning Code 138.1 required 2 Syagrus romanzoffianum :: Queen Palm 85 105 Bache St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007217 2095358 37.7338620991787 -122.417441127318 (37.7338620991787, -122.417441127318) 2 7 7 28859 2
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
11511 225198 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 3160 21st St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 778605 6007149.23047 2103831.77129 37.7571253581517 -122.418276020715 (37.7571253581517, -122.418276020715) 2 4 7 28859 19
11548 225197 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 3160 21st St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 778605 6007163.79352 2103832.50742 37.7571281991351 -122.418225708166 (37.7571281991351, -122.418225708166) 2 4 7 28859 19
11732 261580 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 496 Urbano Dr 3 Sidewalk: Property side : Yard Tree Private 2       3x3   5992575 2091875 37.7234639294961 -122.467809264789 (37.7234639294961, -122.467809264789) 9 8 4 59 40
11885 157920 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 4147 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2019 12:00:00 AM 3 3x3 Permit Number 777832 6002961.17206 2100636.31842 37.7481147664022 -122.432531686182 (37.7481147664022, -122.432531686182) 2 4 5 63 22
11910 262222 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 240 Chattanooga St 3 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
11989 261017 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 79 Cragmont Ave 1 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
12221 261589 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 299x 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006795 2107850 37.7681385292637 -122.41978620049 (37.7681385292637, -122.41978620049) 8 4 7 28853 19
12438 260430 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778605 6007240 2103949 37.7574523501876 -122.417970414127 (37.7574523501876, -122.417970414127) 2 4 7 28859 19
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
12677 259879 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 10 Romain St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2019 12:00:00 AM 3 3x3 Permit Number 776294 6001192.18773 2103413.52714 37.7556398401092 -122.438847746407 (37.7556398401092, -122.438847746407) 2 4 5 28862 3
12753 253419 Planning Code 138.1 required 2 :: 45 3499 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997570 2115996 37.7899813188913 -122.452282225129 (37.7899813188913, -122.452282225129) 11 6 1 54 31
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
13706 225187 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 1 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
13730 260870 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198x Eddy St 3 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
13984 115980 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 5 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011593.71434 2091235.60939 37.7227881560287 -122.402019710862 (37.7227881560287, -122.402019710862) 10 3 7 309 28
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
14168 261582 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 496 Urbano Dr 5 Sidewalk: Property side : Yard Tree Private 2       3x3   5992575 2091875 37.7234639294961 -122.467809264789 (37.7234639294961, -122.467809264789) 9 8 4 59 40
14175 260509 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 436 Colon Ave 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5995686 2095271 37.7329676771739 -122.457300730651 (37.7329676771739, -122.457300730651) 9 7 4 59 40
14212 253124 Planning Code 138.1 required 2 Tree(s) :: 17 399x Lexington St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2017 12:00:00 AM 3 3x3 Permit Number 780530                    
14258 261352 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 297 Sagamore St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2020 12:00:00 AM 3 3x3 Permit Number 780859 5994172 2087374 37.7111973453091 -122.461962532307 (37.7111973453091, -122.461962532307) 9 8 6 28861 24
14403 260183 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 66x McCoppin St 3 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
14869 117019 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 168 Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008121.68381 2113004.40875 37.782365960952 -122.415562303882 (37.782365960952, -122.415562303882) 7 10 9 28852 36
14905 260579 Planning Code 138.1 required 2 Tree(s) :: 17 1662 36th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x3 Permit Number 782799 5985048 2103886 37.7560054004173 -122.494713443881 (37.7560054004173, -122.494713443881) 1 8 3 56 35
14929 256105 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1935 34th Ave 1 Sidewalk: Property side : Cutout Tree Private 2 Port 09/06/2018 12:00:00 AM 3 3x3 Permit Number 778629 5985666.45669 2102048.38182 37.7509959848908 -122.492439326416 (37.7509959848908, -122.492439326416) 1 8 3 29491 35
15413 262220 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 240 Chattanooga St 1 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
15566 121139 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1388x Minna St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2016 12:00:00 AM 3 3x3                      
15585 258769 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 1633 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2019 12:00:00 AM 3 3x3   5988962.35654 2103065.4403 37.7539807026125 -122.481116375927 (37.7539807026125, -122.481116375927) 1 8 3 56 35
15819 151746 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 3030 17th St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 779245 6008502.96204 2106251.6003 37.763845762487 -122.413765441348 (37.763845762487, -122.413765441348) 8 4 7 28859 19
15918 255699 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 9 Sidewalk: Curb side : Cutout Tree Private 2   06/27/2018 12:00:00 AM 3 3x3   6012573 2109637 37.773369031352 -122.399926071367 (37.773369031352, -122.399926071367) 14 2 9 28853 34
16474 253340 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 1045 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2017 12:00:00 AM 3 3x3 Permit Number 780536 6004464 2102825 37.7542094840672 -122.427490860103 (37.7542094840672, -122.427490860103) 2 4 5 28862 22
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
17123 254549 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 170 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/04/2020 12:00:00 AM 3 3x3   5992784 2114350 37.7851865177567 -122.46872140612 (37.7851865177567, -122.46872140612) 11 6 2 54 11
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
17700 260555 Planning Code 138.1 required 2 Tree(s) :: 17 502 07th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/23/2019 12:00:00 AM 3 3x3   6011196 2109910 37.7740417608934 -122.404708555539 (37.7740417608934, -122.404708555539) 14 2 9 28853 34
17746 262424 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 328 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/28/2020 12:00:00 AM 3 3x3   6006735.98718 2096026.524 37.7356706425738 -122.419151541699 (37.7356706425738, -122.419151541699) 2 7 7 28859 2
18060 258219 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 477 Eucalyptus Dr 1 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
18063 259659 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 4061 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 3x3 Permit Number 784440 6003514 2100377 37.7474340728524 -122.430601526112 (37.7474340728524, -122.430601526112) 2 4 5 63 22
18437 260868 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198x Eddy St 1 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
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
19030 221366 Planning Code 138.1 required 2 Quercus suber :: Cork Oak 78 55 Homestead St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/30/2019 12:00:00 AM 3 3x3 Permit Number 778991 6000992.93047 2101385.53728 37.7500601303816 -122.439391477336 (37.7500601303816, -122.439391477336) 2 4 5 28862 22
19087 261350 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 299 Sagamore St 1 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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);