208 rows where qLegalStatus_id = 5 sorted by qAddress

View and edit SQL

SiteOrder

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)
1059 262280 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 10 Niantic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/25/2020 12:00:00 AM 3 3x3 Permit Number 784434 5992391 2086794 37.7095021076955 -122.468075893068 (37.7095021076955, -122.468075893068) 9 8 4 64 24
3880 262281 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 10 Niantic Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/25/2020 12:00:00 AM 3 3x3 Permit Number 784434 5992391 2086794 37.7095021076955 -122.468075893068 (37.7095021076955, -122.468075893068) 9 8 4 64 24
11800 262282 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 10 Niantic Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/25/2020 12:00:00 AM 3 3x3 Permit Number 784434 5992391 2086794 37.7095021076955 -122.468075893068 (37.7095021076955, -122.468075893068) 9 8 4 64 24
3414 262418 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 101 Brighton Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2020 12:00:00 AM 3 3x3 Permit Number 784737 5996197.23422 2090625.75995 37.7202423066045 -122.455197699909 (37.7202423066045, -122.455197699909) 9 8 6 28861 24
4243 162646 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 101 Brighton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2020 12:00:00 AM 3 3x3 Permit Number 784737 5996197.23422 2090625.75995 37.7202423066045 -122.455197699909 (37.7202423066045, -122.455197699909) 9 8 6 28861 24
4810 262420 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 101 Brighton Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2020 12:00:00 AM 3 3x3 Permit Number 784737 5996197.23422 2090625.75995 37.7202423066045 -122.455197699909 (37.7202423066045, -122.455197699909) 9 8 6 28861 24
7952 262419 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 101 Brighton Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2020 12:00:00 AM 3 3x3 Permit Number 784737 5996197.23422 2090625.75995 37.7202423066045 -122.455197699909 (37.7202423066045, -122.455197699909) 9 8 6 28861 24
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
194328 258403 Section 806 (d) 5 Eriobotrya deflexa :: Bronze Loquat 8 1052 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/10/2019 12:00:00 AM 3 3x5   6011869 2103486 37.7564404909426 -122.401928842587 (37.7564404909426, -122.401928842587) 10 3 8 28856 29
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
194400 265055 Section 806 (d) 5 Lophostemon confertus :: Brisbane Box 11 1085 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/23/2020 12:00:00 AM 3 4x4 Permit Number 781590 6009500.70465 2117396.93811 37.794504205778 -122.41110184732 (37.794504205778, -122.41110184732) 3 1 10 28857 21
194401 265056 Section 806 (d) 5 Lophostemon confertus :: Brisbane Box 11 1085 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/23/2020 12:00:00 AM 3 4x4 Permit Number 781590 6009500.70465 2117396.93811 37.794504205778 -122.41110184732 (37.794504205778, -122.41110184732) 3 1 10 28857 21
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
10736 262270 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 10X Restani Stwy 4 Unaccepted Street : Yard Tree Private 2   06/19/2020 12:00:00 AM 3 3x3 Permit Number 782248 5999595 2089918 37.7184933152793 -122.443401977243 (37.7184933152793, -122.443401977243) 9 7 6 28861 25
12694 262268 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 10X Restani Stwy 2 Unaccepted Street : Yard Tree Private 2   06/19/2020 12:00:00 AM 3 3x3 Permit Number 782248 5999595 2089918 37.7184933152793 -122.443401977243 (37.7184933152793, -122.443401977243) 9 7 6 28861 25
14968 262269 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 10X Restani Stwy 3 Unaccepted Street : Yard Tree Private 2   06/19/2020 12:00:00 AM 3 3x3 Permit Number 782248 5999595 2089918 37.7184933152793 -122.443401977243 (37.7184933152793, -122.443401977243) 9 7 6 28861 25
16422 262267 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 10X Restani Stwy 1 Unaccepted Street : Yard Tree Private 2   06/19/2020 12:00:00 AM 3 3x3 Permit Number 782248 5999595 2089918 37.7184933152793 -122.443401977243 (37.7184933152793, -122.443401977243) 9 7 6 28861 25
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
14595 262138 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 1118 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2020 12:00:00 AM 3 3x3 Permit Number 783072 5995073.28586 2091364.23184 37.7222054253906 -122.459136235782 (37.7222054253906, -122.459136235782) 9 8 4 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
194389 265057 Section 806 (d) 5 Lophostemon confertus :: Brisbane Box 11 1190 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/23/2020 12:00:00 AM 3 4x4 Permit Number 781590                    
194396 265058 Section 806 (d) 5 Lophostemon confertus :: Brisbane Box 11 1190 Mason St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/23/2020 12:00:00 AM 3 4x4 Permit Number 781590                    
194403 265059 Section 806 (d) 5 Lophostemon confertus :: Brisbane Box 11 1190 Mason St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/23/2020 12:00:00 AM 3 4x4 Permit Number 781590                    
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
7146 112795 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1235 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2015 12:00:00 AM   3x3   5983624.1 2106731.7 37.7637354441658 -122.499848016409 (37.7637354441658, -122.499848016409) 1 8 3 56 35
194343 265044 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 1250 Eucalyptus Dr 3 Sidewalk: Property side : Yard Tree Private 2   12/17/2020 12:00:00 AM 3 5x10 Permit Number 781946 5987698.06233 2094734.87015 37.7310335805158 -122.484877445397 (37.7310335805158, -122.484877445397) 1 8 4 64 35
194346 265043 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 1250 Eucalyptus Dr 1 Sidewalk: Property side : Yard Tree Private 2   12/17/2020 12:00:00 AM 3 5x10 Permit Number 781946 5987698.06233 2094734.87015 37.7310335805158 -122.484877445397 (37.7310335805158, -122.484877445397) 1 8 4 64 35
194349 265045 Section 806 (d) 5 Tree(s) :: 17 1250 Eucalyptus Dr 2 Sidewalk: Property side : Yard Tree Private 2   12/17/2020 12:00:00 AM 3 5x10 Permit Number 781946 5987698.06233 2094734.87015 37.7310335805158 -122.484877445397 (37.7310335805158, -122.484877445397) 1 8 4 64 35
194351 265046 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1250 Eucalyptus Dr 4 Sidewalk: Property side : Yard Tree Private 2   12/17/2020 12:00:00 AM 3 5x10 Permit Number 781946 5987698.06233 2094734.87015 37.7310335805158 -122.484877445397 (37.7310335805158, -122.484877445397) 1 8 4 64 35
7105 262039 Section 806 (d) 5 Lophostemon confertus :: Brisbane Box 11 1251 Hyde St   Sidewalk: Curb side : Cutout Tree Private 2   04/16/2020 12:00:00 AM 3 3x3 Permit Number 783100 6007540 2116706 37.7924969115625 -122.417837146347 (37.7924969115625, -122.417837146347) 5 1 10 28858 21
19451 254404 Section 806 (d) 5 Metrosideros excelsa :: New Zealand Xmas Tree 16 127 Central Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2018 12:00:00 AM 3 3x3   5999857 2108965 37.7708067512445 -122.443864065657 (37.7708067512445, -122.443864065657) 15 5 11 29492 9
8647 146616 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 1320 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 4x4 Permit Number 783073 6005474.41066 2120313.40732 37.8022854748664 -122.425240967805 (37.8022854748664, -122.425240967805) 13 9 1 57 17
11626 262262 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 1324 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2020 12:00:00 AM 3 4x4 Permit Number 784290 5993653.14185 2106470.72632 37.763602309694 -122.465141974097 (37.763602309694, -122.465141974097) 1 8 11 56 12
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
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
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
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
5958 102480 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 1456 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2013 12:00:00 AM 3 3x3 Permit Number 768914 6004877.03101 2120232.91154 37.8020306879258 -122.427302455863 (37.8020306879258, -122.427302455863) 13 9 1 57 17
7830 262278 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 15 Corona St 1 Sidewalk: Property side : Cutout Tree Private 2   06/25/2020 12:00:00 AM 3 3x3 Permit Number 784820 5992625 2091331 37.7219731255806 -122.467596882777 (37.7219731255806, -122.467596882777) 9 8 4 59 40
9135 262279 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 15 Corona St 2 Sidewalk: Property side : Cutout Tree Private 2   06/25/2020 12:00:00 AM 3 3x3 Permit Number 784820 5992625 2091331 37.7219731255806 -122.467596882777 (37.7219731255806, -122.467596882777) 9 8 4 59 40
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
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
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
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
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
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
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
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
18916 152848 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 160 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2019 12:00:00 AM 3 Width 3ft Permit Number 781252 6006654.74312 2105190.58967 37.7608285109489 -122.420082580673 (37.7608285109489, -122.420082580673) 2 4 7 28859 19
4387 264910 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 1615 Wallace Ave 1 Front Yard : Cutout Tree Private 2   11/04/2020 12:00:00 AM 3 4x4 Permit Number 775989 6014687.7877 2092924.6213 37.7275980500808 -122.391442091837 (37.7275980500808, -122.391442091837) 10 3 8 58 1
67 99921 Section 806 (d) 5 Olea europaea :: Olive Tree 9 1740 Jones St 1 Front Yard : Yard Tree Private 2   06/01/2015 12:00:00 AM 3   Permit Number 774389 6008331.64636 2118443.68708 37.7973126906849 -122.415221079511 (37.7973126906849, -122.415221079511) 5 1 10 308 21
12144 111632 Section 806 (d) 5 Tree(s) :: 17 1758 36th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 774682 5985071 2103231.6 37.7542099449347 -122.49458566251 (37.7542099449347, -122.49458566251) 1 8 3 56 35
33 261067 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 1832 Egbert Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/13/2020 12:00:00 AM 3 4x6 Permit Number 782484 6011934 2092960 37.727541965346 -122.400964507068 (37.727541965346, -122.400964507068) 10 3 8 58 1
18226 98437 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 1840 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/13/2012 12:00:00 AM 4 4x12 Permit Number 768068 6005870.33263 2116931.58044 37.7930221942694 -122.423630300016 (37.7930221942694, -122.423630300016) 13 9 1 28858 27
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
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
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
4594 221063 Section 806 (d) 5 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6006493.11817 2110111.72475 37.7743316749983 -122.420990984947 (37.7743316749983, -122.420990984947) 7 9 11 28852 10
11965 221066 Section 806 (d) 5 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2 Page St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6006423.38991 2110105.498 37.7743106470621 -122.421231746062 (37.7743106470621, -122.421231746062) 7 9 11 28852 10
14708 221065 Section 806 (d) 5 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2 Page St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6006445.36198 2110108.11027 37.7743190584079 -122.421155926024 (37.7743190584079, -122.421155926024) 7 9 11 28852 10
19533 259217 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 200 Grafton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2020 12:00:00 AM 3 3x3 Permit Number 784737 5996177 2090586 37.7201319742324 -122.455264770625 (37.7201319742324, -122.455264770625) 9 8 6 28861 24
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
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
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
8602 228283 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 6 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
10725 228284 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 7 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
10740 228285 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 8 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
9006 112755 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 2038 Balboa St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2015 12:00:00 AM   3x3   5989157.5 2111303.8 37.7766123371313 -122.481044705999 (37.7766123371313, -122.481044705999) 11 6 2 55 26
2103 262299 Section 806 (d) 5 Lagunaria patersonii :: Primrose Tree 6 209 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2020 12:00:00 AM 3 3x3 Permit Number 773443 6008837.63968 2097618.9316 37.7401611793174 -122.411997789374 (37.7401611793174, -122.411997789374) 10 7 7 28859 2
15368 262300 Section 806 (d) 5 Lagunaria patersonii :: Primrose Tree 6 209 Prentiss St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2020 12:00:00 AM 3 3x3 Permit Number 773443 6008837.63968 2097618.9316 37.7401611793174 -122.411997789374 (37.7401611793174, -122.411997789374) 10 7 7 28859 2
3533 263634 Section 806 (d) 5 Tree(s) :: 17 211 Sawyer St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/01/2020 12:00:00 AM 3 3x3   6008194.27066 2088426.33179 37.71488415001 -122.413572307092 (37.71488415001, -122.413572307092) 9 7 8 309 39
194448 265090 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 215 Montana St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/04/2021 12:00:00 AM 3 3x3 Permit Number 784731 5994883.78198 2089306.03852 37.7165432206381 -122.459642300713 (37.7165432206381, -122.459642300713) 9 8 6 28861 24
8728 96402 Section 806 (d) 5 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2160 36th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/12/2011 12:00:00 AM 1 2x3   5985141.5215 2100472.7854 37.7466391224256 -122.494138462065 (37.7466391224256, -122.494138462065) 1 8 3 29491 35
1296 114159 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 2250 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2015 12:00:00 AM 3 3x3 Permit Number 770124 6002793.85496 2117859.65506 37.7953963109343 -122.434341453993 (37.7953963109343, -122.434341453993) 13 9 1 57 17
4024 114160 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 2250 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2015 12:00:00 AM 3 3x3 Permit Number 770124 6002777.5161 2117854.22202 37.7953804657925 -122.434397600465 (37.7953804657925, -122.434397600465) 13 9 1 57 17

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