208 rows where qLegalStatus_id = 5 sorted by qSpecies_id descending

View and edit SQL

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)
16257 225172 Section 806 (d) 5 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 248 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/08/2020 12:00:00 AM 3 4x4 Permit Number 779647 6006535.62128 2098220.14009 37.7416825381227 -122.419999905071 (37.7416825381227, -122.419999905071) 2 7 7 28859 2
6139 264669 Section 806 (d) 5 Prunus subhirtella 'autumnalis' :: Higan Cherry 297 1890 Church St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/11/2020 12:00:00 AM 3 4x4 Permit Number 770415 6004581.61952 2097649.26106 37.7400047512279 -122.426715548384 (37.7400047512279, -122.426715548384) 2 7 5 63 7
15098 169494 Section 806 (d) 5 Prunus subhirtella 'autumnalis' :: Higan Cherry 297 1890 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/11/2020 12:00:00 AM 3 4x4 Permit Number 770415 6004581.61952 2097649.26106 37.7400047512279 -122.426715548384 (37.7400047512279, -122.426715548384) 2 7 5 63 7
17710 169495 Section 806 (d) 5 Prunus subhirtella 'autumnalis' :: Higan Cherry 297 150 Randall St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/11/2020 12:00:00 AM 3 Width 3ft Permit Number 770415 6004561.3283 2097566.6275 37.7397767110236 -122.426779823841 (37.7397767110236, -122.426779823841) 2 7 5 63 7
18648 108454 Section 806 (d) 5 Acer x freemanii :: Freeman Maple 276 696 Pennsylvania Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6014383.50929 2103916.35065 37.757762155526 -122.393262829511 (37.757762155526, -122.393262829511) 10 3 8 28856 29
8444 103091 Section 806 (d) 5 Fagus sylvatica :: European Beech 272 1540 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008424.20559 2117797.21945 37.7955428518875 -122.414855023041 (37.7955428518875, -122.414855023041) 5 1 10 308 21
9912 103092 Section 806 (d) 5 Fagus sylvatica :: European Beech 272 1540 Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008422.05981 2117808.63756 37.7955740826282 -122.414863256344 (37.7955740826282, -122.414863256344) 5 1 10 308 21
10996 103096 Section 806 (d) 5 Fagus sylvatica :: European Beech 272 1540 Jones St 6 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008414.12252 2117870.41106 37.7957432514055 -122.414895095058 (37.7957432514055, -122.414895095058) 5 1 10 308 21
14679 103093 Section 806 (d) 5 Fagus sylvatica :: European Beech 272 1540 Jones St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008420.39916 2117820.52002 37.7956066156178 -122.414869843894 (37.7956066156178, -122.414869843894) 5 1 10 308 21
17667 103095 Section 806 (d) 5 Fagus sylvatica :: European Beech 272 1540 Jones St 5 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008416.42419 2117851.09099 37.7956903325975 -122.414885762773 (37.7956903325975, -122.414885762773) 5 1 10 308 21
18706 103094 Section 806 (d) 5 Fagus sylvatica :: European Beech 272 1540 Jones St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008418.50881 2117836.67229 37.7956508595435 -122.414877528601 (37.7956508595435, -122.414877528601) 5 1 10 308 21
2411 110745 Section 806 (d) 5 Cotinus coggygria 'Royal Purple' :: Smoke tree 229 2300x Mariposa St 5 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2015 12:00:00 AM 3 3x3   6010533.01376 2106015.32988 37.7633108106613 -122.406727421634 (37.7633108106613, -122.406727421634) 8 4 8 28859 19
10128 256113 Section 806 (d) 5 Magnolia spp :: Magnolia 224 356 Willard North St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2018 12:00:00 AM 3                        
2107 113082 Section 806 (d) 5 Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 414 Somerset St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2015 12:00:00 AM 3 3x3   6010030.65327 2092539.3572 37.7262806120542 -122.407514778095 (37.7262806120542, -122.407514778095) 10 3 7 309 28
3788 110746 Section 806 (d) 5 Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 2300x Mariposa St 6 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2015 12:00:00 AM 3 3x3   6010517.26001 2106013.51672 37.7633049506856 -122.406781781161 (37.7633049506856, -122.406781781161) 8 4 8 28859 19
14075 110744 Section 806 (d) 5 Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 2300x Mariposa St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2015 12:00:00 AM 3 3x3   6010545.16814 2106015.79361 37.7633127639997 -122.406685416098 (37.7633127639997, -122.406685416098) 8 4 8 28859 19
16603 110742 Section 806 (d) 5 Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 2300x Mariposa St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2015 12:00:00 AM 3 3x3   6010595.22782 2106018.33058 37.7633225306396 -122.406512454011 (37.7633225306396, -122.406512454011) 8 4 8 28859 19
17154 110741 Section 806 (d) 5 Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 2300x Mariposa St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2015 12:00:00 AM 3 3x3   6010604.54028 2106019.56363 37.7633264372932 -122.406480331995 (37.7633264372932, -122.406480331995) 8 4 8 28859 19
3554 264866 Section 806 (d) 5 Heteromeles arbutifolia :: Toyon 186 10X Selma Way 8 Unaccepted Street : Yard Tree Private 2       10x100   5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
5206 264864 Section 806 (d) 5 Heteromeles arbutifolia :: Toyon 186 10X Selma Way 6 Unaccepted Street : Yard Tree Private 2       10x100   5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
5321 264860 Section 806 (d) 5 Heteromeles arbutifolia :: Toyon 186 10X Selma Way 2 Unaccepted Street : Yard Tree Private 2       10x100   5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
5474 264865 Section 806 (d) 5 Heteromeles arbutifolia :: Toyon 186 10X Selma Way 7 Unaccepted Street : Yard Tree Private 2       10x100   5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
6005 264861 Section 806 (d) 5 Heteromeles arbutifolia :: Toyon 186 10X Selma Way 3 Unaccepted Street : Yard Tree Private 2       10x100   5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
7163 255651 Section 806 (d) 5 Heteromeles arbutifolia :: Toyon 186 10X Selma Way 1 Unaccepted Street : Yard Tree Private 2       10x100 Permit Number 783039 5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
8122 264863 Section 806 (d) 5 Heteromeles arbutifolia :: Toyon 186 10X Selma Way 5 Unaccepted Street : Yard Tree Private 2       10x100   5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
12645 264862 Section 806 (d) 5 Heteromeles arbutifolia :: Toyon 186 10X Selma Way 4 Unaccepted Street : Yard Tree Private 2       10x100   5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
194410 265060 Section 806 (d) 5 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 48 Miraloma Dr 1 Sidewalk: Property side : Yard Tree Private 2   12/28/2020 12:00:00 AM 3 6x6 Permit Number 782253 5994833.01253 2097558.21258 37.7391987718964 -122.46041537824 (37.7391987718964, -122.46041537824) 9 7 4 59 40
2551 256191 Section 806 (d) 5 Olea europaea 'Fruitless' :: Fruitless Olive 177 3600 Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2018 12:00:00 AM 3                        
3302 256186 Section 806 (d) 5 Olea europaea 'Fruitless' :: Fruitless Olive 177 1598 Bay St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2018 12:00:00 AM 3     6003155.82812 2120664.19895 37.8031173987704 -122.433289466249 (37.8031173987704, -122.433289466249) 13 9 1 57 17
4868 256192 Section 806 (d) 5 Olea europaea 'Fruitless' :: Fruitless Olive 177 3600 Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2018 12:00:00 AM 3                        
4989 256185 Section 806 (d) 5 Olea europaea 'Fruitless' :: Fruitless Olive 177 1598 Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2018 12:00:00 AM 3     6003155.82812 2120664.19895 37.8031173987704 -122.433289466249 (37.8031173987704, -122.433289466249) 13 9 1 57 17
6215 256187 Section 806 (d) 5 Olea europaea 'Fruitless' :: Fruitless Olive 177 1598 Bay St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2018 12:00:00 AM 3     6003155.82812 2120664.19895 37.8031173987704 -122.433289466249 (37.8031173987704, -122.433289466249) 13 9 1 57 17
9500 256189 Section 806 (d) 5 Olea europaea 'Fruitless' :: Fruitless Olive 177 3600 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2018 12:00:00 AM 3                        
15675 256190 Section 806 (d) 5 Olea europaea 'Fruitless' :: Fruitless Olive 177 3600 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2018 12:00:00 AM 3                        
18862 256188 Section 806 (d) 5 Olea europaea 'Fruitless' :: Fruitless Olive 177 1598 Bay St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2018 12:00:00 AM 3     6003155.82812 2120664.19895 37.8031173987704 -122.433289466249 (37.8031173987704, -122.433289466249) 13 9 1 57 17
6318 261662 Section 806 (d) 5 Aesculus californica :: California Buckeye 168 137 Elsie St 1 Sidewalk: Property side : Yard Tree Private 2   02/13/2020 12:00:00 AM 3     6007155.81154 2098485.15545 37.7424451335194 -122.417874270912 (37.7424451335194, -122.417874270912) 2 7 7 28859 2
9833 262515 Section 806 (d) 5 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 1951 34th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   08/07/2020 12:00:00 AM 3 3x3 Permit Number 779100 5985670.12137 2101944.25665 37.7507102998335 -122.49241898675 (37.7507102998335, -122.49241898675) 1 8 3 29491 35
13701 112515 Section 806 (d) 5 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2646 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6000218.93903 2118886.71439 37.7980698532985 -122.443324869154 (37.7980698532985, -122.443324869154) 13 9 1 57 17
16986 111918 Section 806 (d) 5 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 41 Toledo Way 1 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2015 12:00:00 AM 3 3x3 Permit Number 773012 6001705.38657 2120044.83908 37.8013344103251 -122.438264349848 (37.8013344103251, -122.438264349848) 13 9 1 57 17
7765 263633 Section 806 (d) 5 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 160 Caselli Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/01/2020 12:00:00 AM 3 4x4 Permit Number 782824 6000235.49843 2104901.88273 37.7596720242526 -122.442263109517 (37.7596720242526, -122.442263109517) 2 4 5 28862 3
5719 108450 Section 806 (d) 5 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 696 Pennsylvania Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6014379.30863 2103997.39375 37.7579844490278 -122.393283028308 (37.7579844490278, -122.393283028308) 10 3 8 28856 29
7842 108451 Section 806 (d) 5 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 696 Pennsylvania Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6014380.97285 2103975.72487 37.7579250434155 -122.393275756387 (37.7579250434155, -122.393275756387) 10 3 8 28856 29
8951 108447 Section 806 (d) 5 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 696 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6014378.0974 2104018.35584 37.7580419391129 -122.393288684138 (37.7580419391129, -122.393288684138) 10 3 8 28856 29
10248 108452 Section 806 (d) 5 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 696 Pennsylvania Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6014381.40925 2103952.18314 37.757860427147 -122.393272599772 (37.757860427147, -122.393272599772) 10 3 8 28856 29
14750 108453 Section 806 (d) 5 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 696 Pennsylvania Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   6014383.1993 2103935.66602 37.7578151741454 -122.393265253191 (37.7578151741454, -122.393265253191) 10 3 8 28856 29
746 110743 Section 806 (d) 5 Cercis occidentalis :: Western Redbud 136 2300x Mariposa St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2015 12:00:00 AM 3 3x3   6010565.19201 2106016.80838 37.7633166706365 -122.406616231274 (37.7633166706365, -122.406616231274) 8 4 8 28859 19
6293 97158 Section 806 (d) 5 Schinus molle :: California Pepper 91 1079 Le Conte Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012744.23117 2089823.98249 37.7189762599209 -122.397943616401 (37.7189762599209, -122.397943616401) 10 3 8 58 1
6990 97154 Section 806 (d) 5 Schinus molle :: California Pepper 91 1079 Le Conte Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2011 12:00:00 AM 4   Permit Number 768080 6012676.26956 2089874.1029 37.7191100952408 -122.398182049174 (37.7191100952408, -122.398182049174) 10 3 8 58 1
12625 97159 Section 806 (d) 5 Schinus molle :: California Pepper 91 1079 Le Conte Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012757.60574 2089814.3813 37.7189506418481 -122.397896712286 (37.7189506418481, -122.397896712286) 10 3 8 58 1
12626 97156 Section 806 (d) 5 Schinus molle :: California Pepper 91 1079 Le Conte Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012721.62132 2089840.20593 37.7190195469812 -122.398022907844 (37.7190195469812, -122.398022907844) 10 3 8 58 1
18330 97157 Section 806 (d) 5 Schinus molle :: California Pepper 91 1079 Le Conte Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2011 12:00:00 AM 2   Permit Number 768080 6012734.70575 2089832.2191 37.7189983454895 -122.397977119771 (37.7189983454895, -122.397977119771) 10 3 8 58 1
18353 97155 Section 806 (d) 5 Schinus molle :: California Pepper 91 1079 Le Conte Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012703.24235 2089857.95173 37.7190672497343 -122.398087681509 (37.7190672497343, -122.398087681509) 10 3 8 58 1
194417 265061 Section 806 (d) 5 Prunus serrulata :: Ornamental Cherry 84 48 Miraloma Dr 2 Sidewalk: Property side : Yard Tree Private 2       6x6   5994833.01253 2097558.21258 37.7391987718964 -122.46041537824 (37.7391987718964, -122.46041537824) 9 7 4 59 40
6880 24222 Section 806 (d) 5 Quercus suber :: Cork Oak 78 54 Whitney Young Cir 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2010 12:00:00 AM 3 4x4 this is original dpw basin record. 6017205.2608 2094992.48681 37.7334154068844 -122.382882921904 (37.7334154068844, -122.382882921904) 10 3 8 58 1
194494 264749 Section 806 (d) 5 Quercus suber :: Cork Oak 78 1339 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2021 12:00:00 AM 3 3x3 Permit Number 785207 5991088 2106284 37.7629413570223 -122.474000279679 (37.7629413570223, -122.474000279679) 1 8 11 56 12
3977 262296 Section 806 (d) 5 Acer rubrum :: Red Maple 75 45 Alma St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2020 12:00:00 AM 3 3x3 Permit Number 782635 5998403.0154 2106238.4273 37.7632372305534 -122.448696994498 (37.7632372305534, -122.448696994498) 15 5 11 29492 9
16264 111321 Section 806 (d) 5 Acacia melanoxylon :: Blackwood Acacia 70 1X Peabody St 1 Sidewalk: Curb side : Cutout Tree Private 2     15     6010185.88551 2087316.24933 37.7119477217782 -122.406610237293 (37.7119477217782, -122.406610237293) 9 7 8 309 39
2854 255187 Section 806 (d) 5 Callistemon viminalis :: Weeping Bottlebrush 60 4740 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/27/2018 12:00:00 AM 3 3x3 Permit Number 780757 5980843 2110991 37.7752666409579 -122.509783220192 (37.7752666409579, -122.509783220192) 11 6 2 55 26
3836 261734 Section 806 (d) 5 Podocarpus gracilor :: Fern Pine 51 540 De Haro St 2 Sidewalk: Property side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
4604 261733 Section 806 (d) 5 Podocarpus gracilor :: Fern Pine 51 540 De Haro St 1 Sidewalk: Property side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
18205 262139 Section 806 (d) 5 Podocarpus gracilor :: Fern Pine 51 1582 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/08/2020 12:00:00 AM 3 3x3 Permit Number 782766 5981929 2104333 37.7570496794991 -122.505532928251 (37.7570496794991, -122.505532928251) 1 8 3 56 35
3337 261748 Section 806 (d) 5 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 540 De Haro St 16 Sidewalk: Curb side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
11461 261747 Section 806 (d) 5 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 540 De Haro St 15 Sidewalk: Curb side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
15024 261746 Section 806 (d) 5 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 540 De Haro St 14 Sidewalk: Curb side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
4750 113090 Section 806 (d) 5 Pyrus calleryana :: Ornamental Pear 44 1213 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2015 12:00:00 AM 3 3x3   6008675.52728 2094042.60872 37.7303322746045 -122.41230559973 (37.7303322746045, -122.41230559973) 9 3 7 309 28
2593 19154 Section 806 (d) 5 Pittosporum undulatum :: Victorian Box 36 64 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/30/2014 12:00:00 AM 3 3x3 Permit Number 774356 6003450.27402 2107953.58185 37.7682339504649 -122.431362651168 (37.7682339504649, -122.431362651168) 15 9 5 28862 3
6198 112830 Section 806 (d) 5 Pittosporum undulatum :: Victorian Box 36 2265 MISSION ST 1 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2015 12:00:00 AM 3 3x3   6006944 2105170 37.760788269781 -122.419080706794 (37.760788269781, -122.419080706794) 2 4 7 28859 19
7728 116230 Section 806 (d) 5 Pittosporum undulatum :: Victorian Box 36 49 Grace St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/02/2014 12:00:00 AM 3 2.5x4 Permit Number 770598 6008318.16403 2110322.45497 37.7750129977898 -122.414692709823 (37.7750129977898, -122.414692709823) 8 2 9 28853 34
16128 103468 Section 806 (d) 5 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 799X Battery St 1 Sidewalk: Curb side : Cutout Tree Private 2     2     6012421.85953 2118740.3114 37.7983561695566 -122.401088663417 (37.7983561695566, -122.401088663417) 3 1 10 28860 6
9107 264723 Section 806 (d) 5 Pistacia chinensis :: Chinese Pistache 32 335 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/18/2020 12:00:00 AM 3 4x4 Permit Number 782646 6008658.96802 2100212.34216 37.7472720863526 -122.412798868954 (37.7472720863526, -122.412798868954) 2 7 7 28859 2
9475 163463 Section 806 (d) 5 Pistacia chinensis :: Chinese Pistache 32 109 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/24/2020 12:00:00 AM 3 3x3 Permit Number 774886 5995872.36784 2087580.2575 37.7118614273349 -122.456100577893 (37.7118614273349, -122.456100577893) 9 8 6 28861 24
10091 163462 Section 806 (d) 5 Pistacia chinensis :: Chinese Pistache 32 115 Plymouth Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2020 12:00:00 AM 3 3x3 Permit Number 774886 5995871.2375 2087597.30845 37.7119081803938 -122.45610571662 (37.7119081803938, -122.45610571662) 9 8 6 28861 24
17374 163460 Section 806 (d) 5 Pistacia chinensis :: Chinese Pistache 32 115 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2020 12:00:00 AM 3 3x3 Permit Number 774886 5995870.33981 2087649.24929 37.7120507463226 -122.45611257216 (37.7120507463226, -122.45611257216) 9 8 6 28861 24
19607 163461 Section 806 (d) 5 Pistacia chinensis :: Chinese Pistache 32 115 Plymouth Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2020 12:00:00 AM 3 3x3 Permit Number 774886 5995870.30801 2087623.97935 37.7119813591246 -122.456110856234 (37.7119813591246, -122.456110856234) 9 8 6 28861 24
9877 126318 Section 806 (d) 5 Platanus x hispanica :: Sycamore: London Plane 27 752 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2020 12:00:00 AM 3 Width 3ft Permit Number 778828 6010086.22048 2116329.20443 37.791605285407 -122.409000507567 (37.791605285407, -122.409000507567) 5 1 10 28857 21
9924 101922 Section 806 (d) 5 Platanus x hispanica :: Sycamore: London Plane 27 1401X California St 6 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2012 12:00:00 AM 4 3x3 Permit Number 769132 6007599.52227 2116115.67925 37.7908793859256 -122.417589338874 (37.7908793859256, -122.417589338874) 13 1 10 28858 21
13794 101919 Section 806 (d) 5 Platanus x hispanica :: Sycamore: London Plane 27 1401X California St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2012 12:00:00 AM 9 3x3 Permit Number 769132 6007497.40622 2116101.25633 37.7908340376155 -122.417941633898 (37.7908340376155, -122.417941633898) 13 1 10 28858 21
14057 107967 Section 806 (d) 5 Platanus x hispanica :: Sycamore: London Plane 27 2405x Scott St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2014 12:00:00 AM 3 3x3 Permit Number 770079 6001240.68928 2116684.58018 37.7920815807513 -122.439631370586 (37.7920815807513, -122.439631370586) 13 6 1 29490 27
17403 101921 Section 806 (d) 5 Platanus x hispanica :: Sycamore: London Plane 27 1401X California St 5 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2012 12:00:00 AM 3 3x3 Permit Number 769132 6007574.87115 2116111.37594 37.7908661829645 -122.417674325729 (37.7908661829645, -122.417674325729) 13 1 10 28858 21
19022 101920 Section 806 (d) 5 Platanus x hispanica :: Sycamore: London Plane 27 1401X California St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2012 12:00:00 AM 13 3x3 Permit Number 769132 6007536.5156 2116104.21807 37.7908443708073 -122.417806526949 (37.7908443708073, -122.417806526949) 13 1 10 28858 21
1757 261740 Section 806 (d) 5 Geijera parviflora :: Australian Willow 25 540 De Haro St 8 Sidewalk: Property side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
3374 261742 Section 806 (d) 5 Geijera parviflora :: Australian Willow 25 540 De Haro St 10 Sidewalk: Property side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
5885 261744 Section 806 (d) 5 Geijera parviflora :: Australian Willow 25 540 De Haro St 12 Sidewalk: Property side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
12766 261739 Section 806 (d) 5 Geijera parviflora :: Australian Willow 25 540 De Haro St 7 Sidewalk: Property side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
14638 261745 Section 806 (d) 5 Geijera parviflora :: Australian Willow 25 540 De Haro St 13 Sidewalk: Property side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
14658 261743 Section 806 (d) 5 Geijera parviflora :: Australian Willow 25 540 De Haro St 11 Sidewalk: Property side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
16452 261741 Section 806 (d) 5 Geijera parviflora :: Australian Willow 25 540 De Haro St 9 Sidewalk: Property side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
38 167409 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 4 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/20/2020 12:00:00 AM 3 3X3 Permit Number 781788 6001979.94285 2107686.90453 37.7674182815445 -122.436429284105 (37.7674182815445, -122.436429284105) 15 5 5 29492 3
56 124 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 1032 14th St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/20/2020 12:00:00 AM 3 3X3 Permit Number 781788 6002037.12702 2107659.05322 37.7673450578674 -122.436229498819 (37.7673450578674, -122.436229498819) 15 5 5 29492 3
881 254388 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 990 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2018 12:00:00 AM 3 3x3   6009377.71563 2118076.93343 37.7963644085284 -122.411575473026 (37.7963644085284, -122.411575473026) 3 1 10 308 4
1811 258532 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 1565 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2019 12:00:00 AM 3 3x3 Permit Number 777683 6006695.00356 2117330.6469 37.7941644464503 -122.420805231935 (37.7941644464503, -122.420805231935) 13 9 10 28858 32
3076 228280 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 3 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
3160 228282 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 5 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
3306 228286 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 9 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
3516 92206 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 443 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/22/2015 12:00:00 AM 3 3x3 Permit Number 775730 6002885.09645 2091274.76844 37.7224057768794 -122.432126318576 (37.7224057768794, -122.432126318576) 9 7 6 28861 5
5830 98280 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 66 09th St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2012 12:00:00 AM 2   Permit Number 58649 6008148.55904 2110896.00071 37.776578287595 -122.415320022909 (37.776578287595, -122.415320022909) 8 2 9 28853 34
6383 228279 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
6545 254389 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 990 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2018 12:00:00 AM 3 3x3   6009377.71563 2118076.93343 37.7963644085284 -122.411575473026 (37.7963644085284, -122.411575473026) 3 1 10 308 4
7043 112197 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2570 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/16/2015 12:00:00 AM 3 3x3   6001886.22681 2116705.46829 37.7921756543416 -122.437399303646 (37.7921756543416, -122.437399303646) 13 6 1 29490 27
7100 228281 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 4 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3

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