trees

736 rows where DBH = 3 and qLegalStatus_id = 2 sorted by PlantDate

✎ View and edit SQL

This data as json, CSV (advanced)

DBH ✖

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)
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
5543 121277 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26
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
7505 247942 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 29 Joy St 5 Unaccepted Street : Yard Tree DPW 1     3   Permit Number 775404 6010292.72224 2098904.67919 37.7437730949632 -122.407057283984 (37.7437730949632, -122.407057283984) 2 7 7 28859 2
16304 162975 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 131 Harold Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 5x5   5996790.92866 2090757.22233 37.72063731584 -122.453154991525 (37.72063731584, -122.453154991525) 9 8 6 28861 24
16618 251060 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 5418 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft Permit Number 777516 5990225.155 2112720.9896 37.7805655538274 -122.477455019941 (37.7805655538274, -122.477455019941) 11 6 2 55 26
17276 72565 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 270 Brannan St 1 Sidewalk: Property side : Cutout Tree Private 2     3 4x4 Permit Number 770847 6015158 2112983 37.7827001752808 -122.391218053322 (37.7827001752808, -122.391218053322) 6 2 9 28856 6
34491 187942 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 3 Sidewalk: Curb side : Yard Tree Private 2     3     6015080.74918 2115307.92538 37.7890796023783 -122.391647913344 (37.7890796023783, -122.391647913344) 6 2 9 28855 6
36998 121281 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 14 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26
46971 110398 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 2St. Ankeny St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6011080.03742 2089739.99739 37.7186528286367 -122.403690209641 (37.7186528286367, -122.403690209641) 10 7 8 309 28
58719 121093 Planning Code 138.1 required 2 Tree(s) :: 17 150 Ridgewood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 778915 5996816.77701 2094570.70089 37.7311097051787 -122.453340820219 (37.7311097051787, -122.453340820219) 9 7 4 59 40
62537 121276 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26
71462 187943 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 4 Sidewalk: Curb side : Yard Tree Private 2     3     6015093.73077 2115293.30797 37.7890401869059 -122.391601975949 (37.7890401869059, -122.391601975949) 6 2 9 28855 6
73578 187945 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 6 Sidewalk: Curb side : Yard Tree Private 2     3     6015129.76051 2115255.3706 37.7889380194338 -122.391474663423 (37.7889380194338, -122.391474663423) 6 2 9 28855 6
77980 121283 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 16 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26
80724 121284 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 17 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26
84600 117455 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 236 Shipley St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 776408 6011503.45491 2111758.78759 37.7791352841027 -122.403775126323 (37.7791352841027, -122.403775126323) 14 2 9 28856 34
93654 121280 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 13 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26
105455 256779 Planning Code 138.1 required 2 Tree(s) :: 17 1231 Grove St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 4x4 Permit Number 782672 6001926.50082 2110819.32275 37.7760160870933 -122.436838397294 (37.7760160870933, -122.436838397294) 15 5 11 29492 10
110069 116528 Planning Code 138.1 required 2 :: 45 125 CROWN TER 1 Sidewalk: Property side : Cutout Tree Private 2     3 3x3   5998841 2104182 37.7576158290564 -122.447034160915 (37.7576158290564, -122.447034160915) 2 5 5 28862 3
110801 187940 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 1 Sidewalk: Curb side : Yard Tree Private 2     3     6015048.62855 2115342.19505 37.7891719160015 -122.391761444649 (37.7891719160015, -122.391761444649) 6 2 9 28855 6
122606 187947 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 8 Sidewalk: Curb side : Yard Tree Private 2     3     6015161.72984 2115222.99296 37.7888508922136 -122.391361788631 (37.7888508922136, -122.391361788631) 6 2 9 28855 6
123746 117456 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 236 SHIPLEY ST 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 776408 6011519 2111785 37.7792081256956 -122.403723194086 (37.7792081256956, -122.403723194086) 14 2 9 28856 34
128498 121278 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26
133882 187944 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 5 Sidewalk: Curb side : Yard Tree Private 2     3     6015109.7038 2115276.55289 37.7889950679055 -122.391545539018 (37.7889950679055, -122.391545539018) 6 2 9 28855 6
149325 187946 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 7 Sidewalk: Curb side : Yard Tree Private 2     3     6015145.56326 2115239.56325 37.7888954931699 -122.391418882079 (37.7888954931699, -122.391418882079) 6 2 9 28855 6
149736 121282 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 15 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26
152002 121279 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 12 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26
153036 256778 Planning Code 138.1 required 2 Tree(s) :: 17 1231 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 4x4 Permit Number 782672 6001926.50082 2110819.32275 37.7760160870933 -122.436838397294 (37.7760160870933, -122.436838397294) 15 5 11 29492 10
160441 117453 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 236 Shipley St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 776408 6011539.59396 2111788.0027 37.779217520823 -122.403652162024 (37.779217520823, -122.403652162024) 14 2 9 28856 34
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
164491 251061 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 5418 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft Permit Number 777516 5990182.6788 2112719.9143 37.7805601365444 -122.477601885097 (37.7805601365444, -122.477601885097) 11 6 2 55 26
4642 254121 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 150 Jennings St 3 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
4781 254118 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 1 Newhall St 5 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
5071 254119 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 150 Jennings St 1 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
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                    
18507 254122 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 150 Jennings St 4 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
48804 254117 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 1 Newhall St 4 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
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
75135 254116 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 1 Newhall St 3 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
118980 254114 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 1 Newhall St 1 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
99548 256905 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 338 Princeton St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/03/2019 12:00:00 AM 3 3x3 Permit Number 781421 6007824.5446 2092249.93927 37.7253622000817 -122.415120729164 (37.7253622000817, -122.415120729164) 9 3 7 309 28
125325 256910 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 835 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/07/2019 12:00:00 AM 3 3x3   6007598 2104806 37.7598256170474 -122.416793017555 (37.7598256170474, -122.416793017555) 2 4 7 28859 19
4912 261377 Planning Code 138.1 required 2 Olea Majestic Beauty :: 183 3015 25th Ave 2 Sidewalk: Property side : Yard Tree Private 2   01/08/2020 12:00:00 AM 3 4x10 Permit Number 784883 5988814.87181 2095155.07295 37.7322523337557 -122.481047245899 (37.7322523337557, -122.481047245899) 1 8 4 64 35
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
17863 261376 Planning Code 138.1 required 2 Olea Majestic Beauty :: 183 3015 25th Ave 1 Sidewalk: Property side : Yard Tree Private 2   01/08/2020 12:00:00 AM 3 4x10 Permit Number 784883 5988814.87181 2095155.07295 37.7322523337557 -122.481047245899 (37.7322523337557, -122.481047245899) 1 8 4 64 35
7193 254151 Planning Code 138.1 required 2 Tree(s) :: 17 201 Steuart St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/09/2018 12:00:00 AM 3 4x4 Permit Number 781165                    
8723 254152 Planning Code 138.1 required 2 Tree(s) :: 17 201 Steuart St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/09/2018 12:00:00 AM 3 4x4 Permit Number 781165                    
9600 254154 Planning Code 138.1 required 2 Tree(s) :: 17 201 Steuart St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/09/2018 12:00:00 AM 3 4x4 Permit Number 781165                    
15617 254153 Planning Code 138.1 required 2 Tree(s) :: 17 201 Steuart St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/09/2018 12:00:00 AM 3 4x4 Permit Number 781165                    
24135 254150 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 2123 30th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   01/09/2018 12:00:00 AM 3 3x6 Permit Number 778310 5986951.71761 2100810.65655 37.7476725845461 -122.487903895201 (37.7476725845461, -122.487903895201) 1 8 3 29491 35
174013 257892 Planning Code 138.1 required 2 Leptospermum scoparium 'Snow White' :: New Zealand White Tea Tree 493 91 Canyon Dr 1 Front Yard : Yard Tree Private 2   01/11/2019 12:00:00 AM 3 3x3   6002890 2086311 37.7087766368694 -122.43175513536 (37.7087766368694, -122.43175513536) 9 7 6 28861 5
40028 57959 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 336 Hanover St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2017 12:00:00 AM 3 3x3 Permit Number 774423 5999490.29697456 2086502.70799744 37.7091097236101 -122.443518692288 (37.7091097236101, -122.443518692288) 9 7 6 28861 5
95009 173748 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1259 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2017 12:00:00 AM 3 3x3 Permit Number 773489 5989520 2106786 37.7642287625639 -122.479460118399 (37.7642287625639, -122.479460118399) 1 8 3 56 35
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
13199 261348 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300x Alemany Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 784323 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
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
15290 25338 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300X Alemany Blvd 1 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
16027 261349 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300x Alemany Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 784323 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
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
38353 256715 Planning Code 138.1 required 2 Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 1540 17th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   01/15/2019 12:00:00 AM 3 4x8 Permit Number 779534 5990911 2104908 37.7591529734205 -122.474512031039 (37.7591529734205, -122.474512031039) 1 8 4 56 12
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
31747 173761 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1405 Van Dyke Ave 1 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
32980 147589 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 Width 4ft Permit Number 777516 5990252.11416 2112971.56981 37.7812551417606 -122.477380075345 (37.7812551417606, -122.477380075345) 11 6 2 55 26
47139 257910 Planning Code 138.1 required 2 Tree(s) :: 17 199x Townsend St 3 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
116306 147588 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 Width 4ft Permit Number 777516 5990252.64201 2112933.29364 37.7811500766647 -122.477375451022 (37.7811500766647, -122.477375451022) 11 6 2 55 26
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
134962 147590 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 Width 4ft Permit Number 777516 5990251.14725 2113004.86394 37.7813465020817 -122.477385854376 (37.7813465020817, -122.477385854376) 11 6 2 55 26
193393 257908 Planning Code 138.1 required 2 Tree(s) :: 17 199x Townsend St 1 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
193648 147591 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 Width 4ft Permit Number 777516 5990250.17652 2113053.797 37.7814808023322 -122.477392789959 (37.7814808023322, -122.477392789959) 11 6 2 55 26
6587 261546 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 1955 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2020 12:00:00 AM 3 3X3 Permit Number 783144 5985360.77923 2101907.46183 37.750591180724 -122.493485992107 (37.750591180724, -122.493485992107) 1 8 3 29491 35
168133 121551 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1125 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/23/2017 12:00:00 AM 3 3x3 Permit Number 778243 6009293.51408 2111653.12836 37.7787214646499 -122.411412777974 (37.7787214646499, -122.411412777974) 8 2 9 28853 34
176162 121550 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1125 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/23/2017 12:00:00 AM 3 3x3 Permit Number 778243 6009252.51421 2111618.01515 37.7786227523886 -122.411552131552 (37.7786227523886, -122.411552131552) 8 2 9 28853 34
4743 167761 Planning Code 138.1 required 2 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 451 Buena Vista Ave East 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2020 12:00:00 AM 3 4x4 Permit Number 780770 6000439.87639 2107208.3352 37.7660166188918 -122.441721798828 (37.7660166188918, -122.441721798828) 15 5 5 29492 3
13240 157603 Planning Code 138.1 required 2 Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 16 Fountain St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2020 12:00:00 AM 3 5x5 Permit Number 784681 6000322.25182 2101567.57465 37.7505217703771 -122.441723777343 (37.7505217703771, -122.441723777343) 2 4 5 28862 22
37845 256671 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 423 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2019 12:00:00 AM 3 3x3 Permit Number 781122 5994719 2091406 37.7222997368586 -122.460363933092 (37.7222997368586, -122.460363933092) 9 8 4 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
61672 15237 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1321 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/27/2015 12:00:00 AM 3 3X3 Permit Number 770747 6008256.52807 2110680.03106 37.7759913537931 -122.414931236282 (37.7759913537931, -122.414931236282) 8 2 9 28853 34
190069 15235 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1321 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/27/2015 12:00:00 AM 3 3X3 Permit Number 770747 6008256.52807 2110680.03106 37.7759913537931 -122.414931236282 (37.7759913537931, -122.414931236282) 8 2 9 28853 34
134738 115357 Planning Code 138.1 required 2 Syagrus romanzoffianum :: Queen Palm 85 270 Ocean Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/27/2016 12:00:00 AM 3 3x6   5999894.51999 2091641.88128 37.7232437759734 -122.442490363056 (37.7232437759734, -122.442490363056) 9 7 6 28861 25
60006 257929 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 255 Seneca Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2019 12:00:00 AM 3 3x3 Permit Number 781730 5999620.44198 2090680.5387 37.7205885233371 -122.443368776907 (37.7205885233371, -122.443368776907) 9 7 6 28861 25
86670 146397 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 3318 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2019 12:00:00 AM 3 Width 4ft Permit Number 780850 6000857.39871 2119780.85133 37.8005613036105 -122.441179804419 (37.8005613036105, -122.441179804419) 13 9 1 57 17
17886 261591 Planning Code 138.1 required 2 :: 45 1747 Cayuga Ave 1 Sidewalk: Property side : Cutout Tree Private 2   01/28/2020 12:00:00 AM 3   Permit Number 784552 5998049.81023 2088594.07996 37.7147698965646 -122.44864773571 (37.7147698965646, -122.44864773571) 9 7 6 28861 25
84340 115405 Planning Code 138.1 required 2 Podocarpus macrophyllus :: Yew Pine 137 2050 43RD AVE 1 Sidewalk: Property side : Cutout Tree Private 2   01/29/2016 12:00:00 AM 3 3x3   5982969 2101168 37.7484206232379 -122.50170211889 (37.7484206232379, -122.50170211889) 1 8 3 29491 35
49446 257939 Planning Code 138.1 required 2 Tree(s) :: 17 65 Buena Vista Ave East 1 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
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
25098 257924 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 1490x Green St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2019 12:00:00 AM 3 3x3 Permit Number 779557 6005922 2118675 37.79781210117 -122.423575535726 (37.79781210117, -122.423575535726) 13 9 10 28858 32
50619 257922 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 1490x Green St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2019 12:00:00 AM 3 3x3 Permit Number 779557 6005922 2118675 37.79781210117 -122.423575535726 (37.79781210117, -122.423575535726) 13 9 10 28858 32
104150 257920 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 1490x Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2019 12:00:00 AM 3 3x3 Permit Number 779557 6005922 2118675 37.79781210117 -122.423575535726 (37.79781210117, -122.423575535726) 13 9 10 28858 32
104300 196537 Planning Code 138.1 required 2 Prunus x yedoensis :: Yoshino Cherry 77 526 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2019 12:00:00 AM 3 Width 3ft Permit Number 782869 6010635.96485 2105787.36101 37.7626906193079 -122.406355282166 (37.7626906193079, -122.406355282166) 8 4 8 28859 19
178936 257923 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 1490x Green St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2019 12:00:00 AM 3 3x3 Permit Number 779557 6005922 2118675 37.79781210117 -122.423575535726 (37.79781210117, -122.423575535726) 13 9 10 28858 32
186623 257921 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 1490x Green St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2019 12:00:00 AM 3 3x3 Permit Number 779557 6005922 2118675 37.79781210117 -122.423575535726 (37.79781210117, -122.423575535726) 13 9 10 28858 32
53742 82615 Planning Code 138.1 required 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2901 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2016 12:00:00 AM 3 3x3 Permit Number 777487 6010040.72394239 2101604.72592715 37.7511727251881 -122.408119020981 (37.7511727251881, -122.408119020981) 2 4 7 28859 19
131633 115503 Planning Code 138.1 required 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2901 25th St 72 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2016 12:00:00 AM 3 3x3 Permit Number 777487 6010040.72394239 2101604.72592715 37.7511727251881 -122.408119020981 (37.7511727251881, -122.408119020981) 2 4 7 28859 19
163013 115504 Planning Code 138.1 required 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2901 25th St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2016 12:00:00 AM 3 3x3 Permit Number 777487 6010040.72394239 2101604.72592715 37.7511727251881 -122.408119020981 (37.7511727251881, -122.408119020981) 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
12808 254368 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 590X Orizaba Ave 1 Back Yard : Yard Tree Private 2   02/06/2018 12:00:00 AM 3   Permit Number 778929                    
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                    
31798 154902 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 1101X Ortega St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/06/2018 12:00:00 AM 3 4x4 Permit Number 778565 5990408 2102358 37.7521221923779 -122.476065384407 (37.7521221923779, -122.476065384407) 1 8 4 29491 12

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