Street_Tree_List

Data source: data.sfgov.org

533 rows where qLegalStatus = 4 sorted by PlantType

View and edit SQL

Suggested facets: SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize

qLegalStatus

  • Planning Code 138.1 required · 533
Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType ▼ qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
14 196590 Planning Code 138.1 required 4 Pyrus calleryana :: Ornamental Pear 9 43 Lafayette St 2 : 4 Tree 1 Private 1     10 Width 3ft Permit Number 772992 6007565.6944699995 2109618.27361 37.773037177355796 -122.41724576098301 (37.7730371773558, -122.417245760983)
15 196591 Planning Code 138.1 required 4 Pyrus calleryana :: Ornamental Pear 9 43 Lafayette St 3 : 4 Tree 1 Private 1     13 Width 3ft Permit Number 772992 6007555.65106 2109624.06249 37.7730525072055 -122.417280912782 (37.7730525072055, -122.417280912782)
20 251179 Planning Code 138.1 required 4 Podocarpus gracilor :: Fern Pine 13 1043 Minna St 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6007668.0 2109797.0 37.7735336727503 -122.41690453761002 (37.7735336727503, -122.41690453761)
21 251178 Planning Code 138.1 required 4 Podocarpus gracilor :: Fern Pine 13 1043 Minna St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6007668.0 2109797.0 37.7735336727503 -122.41690453761002 (37.7735336727503, -122.41690453761)
30 196592 Planning Code 138.1 required 4 Pyrus calleryana :: Ornamental Pear 9 43 Lafayette St 4 : 4 Tree 1 Private 1     8 Width 3ft Permit Number 772992 6007533.59843 2109642.31042 37.7731013709756 -122.41735848920901 (37.7731013709756, -122.417358489209)
54 121137 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1388x Minna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/08/2016 12:00:00 AM 3 3x3            
60 121139 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1388x Minna St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/08/2016 12:00:00 AM 3 3x3            
70 121138 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1388x Minna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/08/2016 12:00:00 AM 3 3x3            
138 72565 Planning Code 138.1 required 4 Ginkgo biloba :: Maidenhair Tree 44 270 Brannan St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   11/16/1996 12:00:00 AM 3 4x4 Permit Number 770847 6015158.0 2112983.0 37.782700175280794 -122.39121805332199 (37.7827001752808, -122.391218053322)
139 116640 Planning Code 138.1 required 4 Ginkgo biloba :: Maidenhair Tree 44 270 Brannan St 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     1 4x4   6015158.0 2112983.0 37.782700175280794 -122.39121805332199 (37.7827001752808, -122.391218053322)
224 117019 Planning Code 138.1 required 4 Metrosideros excelsa :: New Zealand Xmas Tree 2 168 Hyde St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008121.68381 2113004.40875 37.782365960952 -122.41556230388201 (37.782365960952, -122.415562303882)
347 250073 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1599X Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
350 85805 Planning Code 138.1 required 4 Acer rubrum :: Red Maple 6 210X Shipley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011627.0 2111882.0 37.77948049775679 -122.40335640121799 (37.7794804977568, -122.403356401218)
351 251213 Planning Code 138.1 required 4 Acer rubrum :: Red Maple 6 210X Shipley St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604.0 2111950.0 37.779665925350706 -122.40344075372101 (37.7796659253507, -122.403440753721)
361 85803 Planning Code 138.1 required 4 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 923 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 3x3 Permit Number 778048 6011427.0378 2111936.1074 37.779617893816 -122.40405196806002 (37.779617893816, -122.40405196806)
365 251211 Planning Code 138.1 required 4 Acer rubrum :: Red Maple 6 210X Shipley St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604.0 2111950.0 37.779665925350706 -122.40344075372101 (37.7796659253507, -122.403440753721)
369 192563 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 33 08th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008747.97709 2111280.89227 37.777668779422896 -122.413273679445 (37.7776687794229, -122.413273679445)
372 251291 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 33 08th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
373 250075 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1599X Bush St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
377 250072 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1599X Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
384 85806 Planning Code 138.1 required 4 Acer rubrum :: Red Maple 6 210X Shipley St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011627.0 2111882.0 37.77948049775679 -122.40335640121799 (37.7794804977568, -122.403356401218)
387 85807 Planning Code 138.1 required 4 Acer rubrum :: Red Maple 6 210X Shipley St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604.0 2111950.0 37.779665925350706 -122.40344075372101 (37.7796659253507, -122.403440753721)
394 85804 Planning Code 138.1 required 4 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 923 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 3x3 Permit Number 778048 6011441.4589 2111949.4191 37.7796552503769 -122.404003016031 (37.7796552503769, -122.404003016031)
395 249557 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1450 Franklin St 3 : 4 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005881.27559 2115126.52616 37.788066583556706 -122.423464052238 (37.7880665835567, -122.423464052238)
396 251212 Planning Code 138.1 required 4 Acer rubrum :: Red Maple 6 210X Shipley St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604.0 2111950.0 37.779665925350706 -122.40344075372101 (37.7796659253507, -122.403440753721)
400 251289 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 33 08th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
403 65940 Planning Code 138.1 required 4 Liquidambar styraciflua :: American Sweet Gum 62 620 Eddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/1990 12:00:00 AM 8   Permit Number 28961 6007431.46715 2113367.23378 37.78332336932171 -122.41797588370702 (37.7833233693217, -122.417975883707)
404 249555 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1450 Franklin St 1 : 4 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005893.0868 2115064.96247 37.787898211588704 -122.423418809148 (37.7878982115887, -122.423418809148)
406 249556 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1450 Franklin St 2 : 4 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005884.0832400005 2115105.79396 37.7880098165527 -122.423452863778 (37.7880098165527, -122.423452863778)
412 251290 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 33 08th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
413 249558 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1450 Franklin St 4 : 4 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005877.98213 2115146.79048 37.7881220384566 -122.42347688825899 (37.7881220384566, -122.423476888259)
415 250074 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1599X Bush St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
416 192564 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 33 08th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
425 251299 Planning Code 138.1 required 4 Platanus x hispanica :: Sycamore: London Plane 15 2190X Market St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
431 251298 Planning Code 138.1 required 4 Platanus x hispanica :: Sycamore: London Plane 15 2190X Market St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
432 251297 Planning Code 138.1 required 4 Platanus x hispanica :: Sycamore: London Plane 15 2190X Market St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
446 251296 Planning Code 138.1 required 4 Platanus x hispanica :: Sycamore: London Plane 15 2190X Market St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
451 192346 Planning Code 138.1 required 4 Fraxinus spp :: Ash Spp 83 118 10th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/09/2014 12:00:00 AM 1 Width 3ft Permit Number 770901 6007994.19176 2110350.5452799997 37.7750719195804 -122.41581539288201 (37.7750719195804, -122.415815392882)
518 251314 Planning Code 138.1 required 4 :: 54 1108 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001901.0 2100825.0 37.7485726639367 -122.43621121860001 (37.7485726639367, -122.4362112186)
533 251313 Planning Code 138.1 required 4 :: 54 390 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6003369.0 2099547.0 37.7451468706327 -122.431043696183 (37.7451468706327, -122.431043696183)
721 183636 Planning Code 138.1 required 4 Pittosporum crassifolium :: Karo Tree 108 1478 47th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 3x9   5981570.9282 2105017.3718 37.7589076903569 -122.506822015648 (37.7589076903569, -122.506822015648)
948 251406 Planning Code 138.1 required 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 445 Amazon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2017 12:00:00 AM 3 3x3   6001636.0 2088904.0 37.7158252789105 -122.43627456666799 (37.7158252789105, -122.436274566668)
976 160371 Planning Code 138.1 required 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 868 Edinburgh St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/26/2017 12:00:00 AM 3 3x3 Permit Number 779314 6001686.38396 2088939.3945099998 37.7159253269669 -122.43610294800199 (37.7159253269669, -122.436102948002)
977 242613 Planning Code 138.1 required 4 Ulmus parvifolia :: Chinese Elm 46 48 Winfield St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 3x3 Permit Number 777782 6007306.44134 2099195.30791 37.744403529591395 -122.417403753004 (37.7444035295914, -122.417403753004)
991 160369 Planning Code 138.1 required 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 868 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/26/2017 12:00:00 AM 3 3x3 Permit Number 779314 6001700.06015 2088961.7176 37.715987398188894 -122.436057273237 (37.7159873981889, -122.436057273237)
994 160370 Planning Code 138.1 required 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 868 Edinburgh St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/26/2017 12:00:00 AM 3 3x3 Permit Number 779314 6001693.73373 2088950.71414 37.715956825716 -122.436078353349 (37.715956825716, -122.436078353349)
1180 251470 Planning Code 138.1 required 4 Tristaniopsis laurina :: Swamp Myrtle 37 194 Sweeny St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/04/2017 12:00:00 AM 3 3x3 Permit Number 777454 6009558.57553 2094850.0846799999 37.7325989441491 -122.409309728531 (37.7325989441491, -122.409309728531)
1388 251519 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1395 251525 Planning Code 138.1 required 4 Ulmus parvifolia :: Chinese Elm 46 173 Sanchez St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1401 251523 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1406 14313 Planning Code 138.1 required 4 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 2190X Market St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/01/2017 12:00:00 AM 3 4X4 Permit Number 779911 6003603.86 2107219.9092 37.7662281664546 -122.43077904924299 (37.7662281664546, -122.430779049243)
1413 246406 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1414 251524 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1416 251521 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1425 251522 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1432 14312 Planning Code 138.1 required 4 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 2190X Market St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/01/2017 12:00:00 AM 3 4X4 Permit Number 779911 6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
1433 251520 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1436 251534 Planning Code 138.1 required 4 Tristaniopsis laurina :: Swamp Myrtle 37 1818 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/16/2017 12:00:00 AM 3 3x3   5983226.0 2102732.0 37.7527300247516 -122.500929082058 (37.7527300247516, -122.500929082058)
1451 251539 Planning Code 138.1 required 4 Brahea edulis :: Guadalupe Palm 115 1746 Great Hwy 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5981086.0 2103156.0 37.753768326371 -122.50836092480499 (37.753768326371, -122.508360924805)
1459 251538 Planning Code 138.1 required 4 Brahea edulis :: Guadalupe Palm 115 1746 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/27/2001 12:00:00 AM   3x3   5981086.0 2103156.0 37.753768326371 -122.50836092480499 (37.753768326371, -122.508360924805)
1601 102430 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 200 06th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2017 12:00:00 AM 3 4x4 Permit Number 770993 6010566.09371 2111909.33227 37.779496235110706 -122.407028471514 (37.7794962351107, -122.407028471514)
1602 102429 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 200 06th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2017 12:00:00 AM 3 4x4 Permit Number 770993 6010552.49087 2111923.99595 37.7795357369219 -122.40707656363399 (37.7795357369219, -122.407076563634)
1634 199504 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 1009 Howard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2017 12:00:00 AM 3 Width 3ft Permit Number 770993 6010510.13491 2111932.18806 37.7795558601644 -122.407223669342 (37.7795558601644, -122.407223669342)
1642 199503 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 1009 Howard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2017 12:00:00 AM 3 Width 3ft Permit Number 770993 6010500.983080001 2111924.50305 37.7795342467397 -122.40725478770099 (37.7795342467397, -122.407254787701)
1801 251699 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1230 Chestnut St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/05/2017 12:00:00 AM 3 4x3 Permit Number 778360 6005943.79297 2120373.7363400003 37.8024776288704 -122.423620966152 (37.8024776288704, -122.423620966152)
1809 172747 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1230 Chestnut St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/05/2017 12:00:00 AM 3 4x3 Permit Number 778360 6006022.78943 2120387.12776 37.802518857014704 -122.423348551388 (37.8025188570147, -122.423348551388)
1812 172746 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1230 Chestnut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/05/2017 12:00:00 AM 3 4x3 Permit Number 778360 6006038.86692 2120389.38612 37.8025259652646 -122.423293075825 (37.8025259652646, -122.423293075825)
1934 252840 Planning Code 138.1 required 4 Tree(s) :: 17 80 Blake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5997842.0 2113206.0 37.782336294689 -122.45113984781099 (37.782336294689, -122.451139847811)
2025 243143 Planning Code 138.1 required 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 98x Eugenia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/16/2017 12:00:00 AM 3 3x3   6006195.0 2098242.0 37.7417233638646 -122.42117921336501 (37.7417233638646, -122.421179213365)
2032 243144 Planning Code 138.1 required 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 98x Eugenia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/16/2017 12:00:00 AM 3 3x3   6006195.0 2098242.0 37.7417233638646 -122.42117921336501 (37.7417233638646, -122.421179213365)
2129 156905 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 3201x 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/2017 12:00:00 AM 3 3x6 Permit Number 777588 6007417.0 2106083.0 37.763321780718705 -122.417509514421 (37.7633217807187, -122.417509514421)
2133 252909 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 3201x 17th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/2017 12:00:00 AM 3 3x6 Permit Number 777588 6007417.0 2106083.0 37.763321780718705 -122.417509514421 (37.7633217807187, -122.417509514421)
2142 252906 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 600 South Van Ness Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/2017 12:00:00 AM 3 3x3 Permit Number 777588 6007451.05071 2106154.24093 37.7635193076139 -122.417396792879 (37.7635193076139, -122.417396792879)
2143 252905 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 600 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/2017 12:00:00 AM 3 3x3 Permit Number 777588 6007451.05071 2106154.24093 37.7635193076139 -122.417396792879 (37.7635193076139, -122.417396792879)
2147 252908 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 600 South Van Ness Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/2017 12:00:00 AM 3 3x3 Permit Number 777588 6007451.05071 2106154.24093 37.7635193076139 -122.417396792879 (37.7635193076139, -122.417396792879)
2257 229627 Planning Code 138.1 required 4 Magnolia grandiflora :: Southern Magnolia 21 3662 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6008456.11159 2097816.22885 37.7406815009641 -122.41333091228701 (37.7406815009641, -122.413330912287)
2571 253124 Planning Code 138.1 required 4 Tree(s) :: 17 399x Lexington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/2017 12:00:00 AM 3 3x3 Permit Number 780530          
2575 253126 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 182 London St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/2017 12:00:00 AM 3 3x3 Permit Number 779117 6002742.73008 2092646.2038099999 37.726163358663705 -122.432716365158 (37.7261633586637, -122.432716365158)
2639 253101 Planning Code 138.1 required 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 3000x Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427.0 2106455.0 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734)
2642 253105 Planning Code 138.1 required 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1295 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427.0 2106455.0 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734)
2663 253102 Planning Code 138.1 required 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 3000x Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427.0 2106455.0 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734)
2666 253103 Planning Code 138.1 required 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 3000x Irving St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427.0 2106455.0 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734)
2669 253104 Planning Code 138.1 required 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 3000x Irving St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427.0 2106455.0 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734)
2687 253164 Planning Code 138.1 required 4 Tree(s) :: 17 146 Cambridge St 1 Front Yard : Cutout 8 Tree 1 Private 1   07/27/2017 12:00:00 AM 3 4x4   6006598.94029 2094006.4119099998 37.7301161400075 -122.419482094225 (37.7301161400075, -122.419482094225)
2715 253166 Planning Code 138.1 required 4 Pyrus kawakamii :: Evergreen Pear 82 2405 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/31/2017 12:00:00 AM 3 3x3 Permit Number 778209 5986396.6612 2098868.17463 37.742306656921 -122.48968039586501 (37.742306656921, -122.489680395865)
2759 253203 Planning Code 138.1 required 4 Acer buergeranum :: Trident Maple 120 349 Mangels Ave 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   5999103.0 2095207.0 37.732987611392005 -122.44548271607799 (37.732987611392, -122.445482716078)
2811 115532 Planning Code 138.1 required 4 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 100X Hayes St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007293.46404 2111265.83422 37.777545665835596 -122.41830427922501 (37.7775456658356, -122.418304279225)
2853 253248 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 570 Jessie St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/09/2017 12:00:00 AM 3 3x3 Permit Number 775513 6009730.1467 2112442.1376799997 37.7809123781536 -122.40995800293301 (37.7809123781536, -122.409958002933)
2868 253247 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 570 Jessie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/09/2017 12:00:00 AM 3 3x3 Permit Number 775513 6009730.1467 2112442.1376799997 37.7809123781536 -122.40995800293301 (37.7809123781536, -122.409958002933)
2897 253249 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 570 Jessie St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/09/2017 12:00:00 AM 3 3x3 Permit Number 775513 6009730.1467 2112442.1376799997 37.7809123781536 -122.40995800293301 (37.7809123781536, -122.409958002933)
3030 224462 Planning Code 138.1 required 4 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2810 26th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/15/2017 12:00:00 AM 3 3x3 Permit Number 775960 6010311.37562 2101086.64633 37.7497653433983 -122.40714655877301 (37.7497653433983, -122.407146558773)
3035 240686 Planning Code 138.1 required 4 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2810 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/15/2017 12:00:00 AM 3 3x3 Permit Number 775960 6010325.27315 2101087.17666 37.749767577309605 -122.40709853768499 (37.7497675773096, -122.407098537685)
3048 253287 Planning Code 138.1 required 4 Tree(s) :: 17 1237 Shafter Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/16/2017 12:00:00 AM 3 3x3 Permit Number 780510 6016839.12241 2092718.7941400001 37.727152059320204 -122.383990506478 (37.7271520593202, -122.383990506478)
3083 252820 Planning Code 138.1 required 4 Eriobotrya deflexa :: Bronze Loquat 49 2339 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/21/2017 12:00:00 AM 3 3x3   5983590.30233 2099230.6863599997 37.743137766616 -122.49941055724301 (37.743137766616, -122.499410557243)
3172 253340 Planning Code 138.1 required 4 Jacaranda mimosifolia :: Jacaranda 52 1045 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/23/2017 12:00:00 AM 3 3x3 Permit Number 780536 6004432.85841 2102813.20591 37.754175338839204 -122.427597715268 (37.7541753388392, -122.427597715268)
3174 253344 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2586 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/23/2017 12:00:00 AM 3 4x4 Permit Number 780063 5987098.36417 2097677.28593 37.7390777358027 -122.487166705945 (37.7390777358027, -122.487166705945)
3179 253343 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 200 Arguello Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x6 Permit Number 778434 5995550.1802199995 2114806.2223 37.786598594028504 -122.459184390305 (37.7865985940285, -122.459184390305)
3189 253342 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 200 Arguello Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x6 Permit Number 778434 5995550.1802199995 2114806.2223 37.786598594028504 -122.459184390305 (37.7865985940285, -122.459184390305)
3255 253377 Planning Code 138.1 required 4 :: 54 2 Alpine Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001556.0 2108661.0 37.7700688079313 -122.43796542225 (37.7700688079313, -122.43796542225)
3275 253378 Planning Code 138.1 required 4 :: 54 2 Alpine Ter 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001556.0 2108661.0 37.7700688079313 -122.43796542225 (37.7700688079313, -122.43796542225)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 141.191ms · Data source: data.sfgov.org