Street_Tree_List

Data source: data.sfgov.org

189,144 rows sorted by PermitNotes

View and edit SQL

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes ▼ XCoord YCoord Latitude Longitude Location
3 119263 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 495X Lakeshore Dr 1 Median : Yard 3 Tree 1 DPW 2       10x30            
4 207368 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 920 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 1ft   5992009.48044 2105269.9271 37.760210314285004 -122.47073935813 (37.760210314285, -122.47073935813)
5 188702 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1501 Evans Ave 2 : 4 Tree 1 DPW 2     17 Width 4ft   6015994.71985 2098219.31717 37.7422086702947 -122.387293152263 (37.7422086702947, -122.387293152263)
6 141566 Permitted Site 1 Myoporum laetum :: Myoporum 1 501X Baker St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   6000587.8822 2110733.5952 37.7757045307049 -122.441462866076 (37.7757045307049, -122.441462866076)
7 188697 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1301 Evans Ave 13 : 4 Tree 1 DPW 2     15 Width 3ft   6017236.81305 2097292.98379 37.7397338556296 -122.38293388291001 (37.7397338556296, -122.38293388291)
8 122650 Permitted Site 1 Acer rubrum :: Red Maple 6 300x Hickory St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3x3            
9 203507 Undocumented 2 Agonis flexuosa :: Peppermint Willow 7 920 Kirkham St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 3ft   5991972.62617 2105259.8491700003 37.76018051163321 -122.470866084321 (37.7601805116332, -122.470866084321)
10 122670 Permitted Site 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 301x Hickory St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3X3            
11 122658 Permitted Site 1 Acer rubrum :: Red Maple 6 300x Hickory St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3x3            
12 122660 Permitted Site 1 Acer rubrum :: Red Maple 6 300x Hickory St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3x3            
13 122648 Permitted Site 1 Acer rubrum :: Red Maple 6 300x Hickory St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3x3            
16 122649 Permitted Site 1 Acer rubrum :: Red Maple 6 300x Hickory St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3x3            
19 182260 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1471 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3x3   5987398.0 2105276.0 37.759959232607606 -122.486688530832 (37.7599592326076, -122.486688530832)
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)
22 203506 Undocumented 2 Agonis flexuosa :: Peppermint Willow 7 910 Kirkham St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   5992059.0 2105289.0 37.760265546982495 -122.470569484113 (37.7602655469825, -122.470569484113)
24 22346 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 5280 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/27/2014 12:00:00 AM 3 3x3   6014341.487000001 2093641.8617 37.7295482207565 -122.39268941982701 (37.7295482207565, -122.392689419827)
25 23567 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2975 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/27/1992 12:00:00 AM 3 3X3   6005531.337230001 2120589.48411 37.803046726686894 -122.42506362870199 (37.8030467266869, -122.425063628702)
28 21823 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2741 Taylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/19/2006 12:00:00 AM 3 4x4   6008229.33947 2122327.41953 37.8079706947476 -122.415850241604 (37.8079706947476, -122.415850241604)
29 188686 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1300 Evans Ave 20 : 4 Tree 1 DPW 2     12 Width 3ft   6017760.57019 2097020.5910900002 37.739014844955705 -122.381104000867 (37.7390148449557, -122.381104000867)
31 22614 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1001 Turk St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     24 3x5   6005426.7391 2112695.1691 37.781365013820206 -122.424863625752 (37.7813650138202, -122.424863625752)
32 10933 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1359 Hudson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X4   6016893.48466 2096461.5108299998 37.7374318223223 -122.384063092353 (37.7374318223223, -122.384063092353)
33 2889 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1545 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     65 3X3   6006951.47041 2116025.01423 37.79059395549061 -122.419825138035 (37.7905939554906, -122.419825138035)
34 240126 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 20 Lily St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6006399.28254 2110261.0751 37.7747364652596 -122.42132618837299 (37.7747364652596, -122.421326188373)
36 13434 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2X Market St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 4X4   6014136.36792 2117295.16476 37.7944836321678 -122.39505462349199 (37.7944836321678, -122.395054623492)
37 226924 Undocumented 2 Juniperus chinensis :: Juniper 19 1 Newburg St 1 Sidewalk: Property side : Pot 6 Tree 1 Private 1     11 Width 4ft   6002558.65829 2099967.6575700003 37.7462559468486 -122.433875776072 (37.7462559468486, -122.433875776072)
38 192589 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1390 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6008004.0 2110521.0 37.775540499151 -122.415793536261 (37.775540499151, -122.415793536261)
39 3558 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 101 Cargo Way 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/21/2017 05:52:00 PM 6 3X3   6018773.865780001 2097541.9761 37.7405023461002 -122.377636624239 (37.7405023461002, -122.377636624239)
40 222540 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1 Newburg St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002573.08856 2099992.67614 37.74632546084511 -122.433827665916 (37.7463254608451, -122.433827665916)
41 192590 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1390 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6008004.0 2110521.0 37.775540499151 -122.415793536261 (37.775540499151, -122.415793536261)
43 222539 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1 Newburg St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002564.39948 2099984.1142599997 37.7463014588556 -122.433857099823 (37.7463014588556, -122.433857099823)
44 226925 Undocumented 2 Juniperus chinensis :: Juniper 19 1 Newburg St 2 Sidewalk: Property side : Pot 6 Tree 1 Private 1     19 Width 4ft   6002565.841680001 2099976.66752 37.746281093695 -122.433851580699 (37.746281093695, -122.433851580699)
45 27522 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 3201 California St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3X3   5998967.7443 2114917.3257 37.787099536792 -122.44736849888001 (37.787099536792, -122.44736849888)
46 18228 DPW Maintained 3 Maytenus boaria :: Mayten 22 1737-1795 Post St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/09/2004 12:00:00 AM 12 3X3   6003682.1522 2114179.2812 37.785341320174396 -122.431004998109 (37.7853413201744, -122.431004998109)
47 17325 DPW Maintained 3 Fraxinus americana :: American Ash 23 150 Otis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/31/2016 12:00:00 AM 3 3x3   6006651.4447 2108878.4679400004 37.7709543699737 -122.420355751511 (37.7709543699737, -122.420355751511)
48 3528 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 201X Cargo Way 38 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/21/2017 04:23:00 PM 3 3X3   6018298.55272 2097894.94115 37.7414453176516 -122.37930460042801 (37.7414453176516, -122.379304600428)
49 251186 Undocumented 2 Juniperus chinensis :: Juniper 19 3042 Steiner St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6002010.0 2118654.0 37.7975328515761 -122.437110618013 (37.7975328515761, -122.437110618013)
52 233897 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1021 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6003182.0050800005 2102290.73647 37.75266992967379 -122.43188616810801 (37.7526699296738, -122.431886168108)
53 251187 Undocumented 2 Schinus terebinthifolius :: Brazilian Pepper 25 1 Baker St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6000800.0 2109063.0 37.771129578660705 -122.440609247553 (37.7711295786607, -122.440609247553)
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            
55 2909 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1700 California St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 4X4   6006037.49643 2115968.63965 37.7903876339283 -122.422983431149 (37.7903876339283, -122.422983431149)
56 27602 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 988 Fulton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 4X4   6003218.3377 2111393.5053 37.7776659856505 -122.432410615738 (37.7776659856505, -122.432410615738)
58 4749 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1255 Columbus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/03/2015 12:00:00 AM 8 3X3   6007516.58505 2121541.63395 37.805773032263296 -122.41826116482599 (37.8057730322633, -122.418261164826)
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            
61 226596 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1 Newburg St 4 Sidewalk: Property side : Pot 6 Tree 1 Private 1     4 Width 4ft   6002583.45295 2099992.19698 37.746324733318 -122.433791792881 (37.746324733318, -122.433791792881)
62 239043 Undocumented 2 Pyrus calleryana :: Ornamental Pear 9 10 12th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6006946.59098 2109912.5632700003 37.773810376676295 -122.41940820332898 (37.7738103766763, -122.419408203329)
64 138748 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1614 Broderick St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6000643.1477 2114229.9232 37.7853077023438 -122.441522641665 (37.7853077023438, -122.441522641665)
65 226926 Undocumented 2 Juniperus chinensis :: Juniper 19 1 Newburg St 3 Sidewalk: Property side : Pot 6 Tree 1 Private 1     15 Width 4ft   6002574.76935 2099983.89995 37.7463014588644 -122.433821226777 (37.7463014588644, -122.433821226777)
66 222538 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1 Newburg St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002556.19825 2099973.42317 37.746271638232 -122.43388469462201 (37.746271638232, -122.433884694622)
68 251188 Undocumented 2 Schinus terebinthifolius :: Brazilian Pepper 25 1 Baker St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6000800.0 2109063.0 37.771129578660705 -122.440609247553 (37.7711295786607, -122.440609247553)
69 19206 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 630 Sansome St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6012230.08543 2117977.14861 37.7962500076802 -122.40169859442699 (37.7962500076802, -122.401698594427)
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            
71 251206 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 270 Trumbull St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6005145.0 2094297.0 37.7308320294825 -122.424529217878 (37.7308320294825, -122.424529217878)
72 25725 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 729 Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6004286.7153 2111148.1106 37.777052715887706 -122.428697236196 (37.7770527158877, -122.428697236196)
74 188665 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 2175X Palou Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     37     6011669.71313 2097723.45025 37.740606653987705 -122.402212916691 (37.7406066539877, -122.402212916691)
75 138824 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 729 GROVE ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 0ft   6004305.1004 2111150.1162 37.77705926326529 -122.428633779399 (37.7770592632653, -122.428633779399)
78 251199 Significant Tree 6 Pinus radiata :: Monterey Pine 3 900X 14th St 4 Front Yard : Yard 7 Tree 1 Private 1       3X3   6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
79 251205 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2000X Market St 5 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       4X4   6004899.0 2108432.0 37.769629569555896 -122.426385716137 (37.7696295695559, -122.426385716137)
85 22613 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1001 Turk St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     24 3x5   6005358.7073 2112686.5825 37.7813375942673 -122.42509837168001 (37.7813375942673, -122.42509837168)
87 11032 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1500 Hyde St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     70 3X3   6007492.86428 2117507.22815 37.794694232707 -122.41805706457599 (37.794694232707, -122.418057064576)
88 251208 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 4115 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5982071.0 2104840.0 37.758450113202294 -122.505079418654 (37.7584501132023, -122.505079418654)
89 251189 Permitted Site 1 Tree(s) :: 17 1493 Hudson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/22/2017 12:00:00 AM 3 3x3   6016267.45517 2096986.6643299998 37.7388391569445 -122.38626419104999 (37.7388391569445, -122.38626419105)
92 98091 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 2X Frank Norris St 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   3 3x3   6007129.633230001 2115568.12393 37.789349482642606 -122.41917628075599 (37.7893494826426, -122.419176280756)
93 251198 Significant Tree 6 Pinus radiata :: Monterey Pine 3 900X 14th St 3 Front Yard : Yard 7 Tree 1 Private 1           6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
94 201404 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1051 Ingalls St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/02/1990 12:00:00 AM 14 Width 3ft   6018112.6185 2094686.77545 37.732626074632705 -122.379724665662 (37.7326260746327, -122.379724665662)
96 251196 Significant Tree 6 Pinus radiata :: Monterey Pine 3 900X 14th St 2 Front Yard : Cutout 8 Tree 1 Private 1   03/22/2017 12:00:00 AM 3     6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
97 5266 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1245 Divisadero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X4   6001289.7409 2112772.8314 37.781343716873 -122.43918115910401 (37.781343716873, -122.439181159104)
98 142074 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1384X GROVE ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6001183.1648 2110763.0502 37.7758193019084 -122.439405751925 (37.7758193019084, -122.439405751925)
99 7992 Permitted Site 1 Pyrus calleryana :: Ornamental Pear 9 2247 Franklin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/01/2007 12:00:00 AM 3 3X3   6005467.69382 2117725.44397 37.7951792074025 -122.42507996488001 (37.7951792074025, -122.42507996488)
101 192592 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1399X Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6008031.0 2110483.0 37.775437677991796 -122.41569744526699 (37.7754376779918, -122.415697445267)
104 251210 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1170 Ingalls St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/02/1992 12:00:00 AM                
105 6251 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1315 Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/06/2003 12:00:00 AM 24 3X3   6004480.8051 2113256.6545 37.7828532389184 -122.428176124144 (37.7828532389184, -122.428176124144)
106 10645 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 906 Hayes St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 4x4   6003455.1435 2110726.9996 37.775849351151706 -122.431543829861 (37.7758493511517, -122.431543829861)
107 142075 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1384X GROVE ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6001166.7226 2110758.8221 37.775806756879895 -122.439462326391 (37.7758067568799, -122.439462326391)
108 192593 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1399X Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6008031.0 2110483.0 37.775437677991796 -122.41569744526699 (37.7754376779918, -122.415697445267)
109 9895 DPW Maintained 3 Eucalyptus Spp :: Eucalyptus 40 1800X Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6005051.0377 2115464.4068 37.7889474242075 -122.426360597873 (37.7889474242075, -122.426360597873)
110 97646 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 1824 Noriega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4x4   5988290.0 2103126.0 37.7541078738982 -122.48344595561899 (37.7541078738982, -122.483445955619)
111 7749 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 400X Franklin St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3X3   6006371.15759 2111615.2483900003 37.7784531123456 -122.421519673008 (37.7784531123456, -122.421519673008)
112 9896 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1800X Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2007 12:00:00 AM 3 3X3   6004999.6173 2115457.4476 37.7889254092316 -122.426538009917 (37.7889254092316, -122.426538009917)
113 183695 Permitted Site 1 Olea europaea :: Olive Tree 41 1341 42nd Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5983048.7244 2105854.1384 37.7612921278024 -122.50177309900499 (37.7612921278024, -122.501773099005)
114 251216 Significant Tree 6 Myoporum laetum :: Myoporum 1 399X Townsend St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
115 6964 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 700 Fell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3X3   6003997.6735 2110460.7643 37.7751490695403 -122.42964808764499 (37.7751490695403, -122.429648087645)
116 26163 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 220 Richardson Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   5999083.87135 2119853.9919 37.8006609458028 -122.447322173097 (37.8006609458028, -122.447322173097)
118 251217 Significant Tree 6 Myoporum laetum :: Myoporum 1 399X Townsend St 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
119 251215 DPW Maintained 3 Ficus nitida :: Laurel Fig 43 175X Otis St 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.42011195674299 (37.7705111956623, -122.420111956743)
122 183689 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1341 42nd Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5983043.6112 2105976.497 37.761627789464704 -122.501799836383 (37.7616277894647, -122.501799836383)
123 18916 DPW Maintained 3 Olea europaea :: Olive Tree 41 2621 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 6x5   6002236.03231 2115724.70658 37.7895026155894 -122.4361187581 (37.7895026155894, -122.4361187581)
124 20281 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 20X Sunset Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
125 119758 Undocumented 2 Maytenus boaria :: Mayten 22 151X Octavia St Frontage West 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
126 228560 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 700 Valencia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 Width 3ft   6006200.30022 2105449.82338 37.761514690968596 -122.42167271244301 (37.7615146909686, -122.421672712443)
127 18052 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2840 Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6000317.799 2114808.7133 37.7868783690408 -122.442689819484 (37.7868783690408, -122.442689819484)
128 212622 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 115 Beverly St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   5991392.0 2089980.0 37.718192344870296 -122.471760605115 (37.7181923448703, -122.471760605115)
129 20398 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 262X Sunset Blvd 43 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 60            
131 237033 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Octavia St 7 : 4 Tree 1 DPW 2     6 Width 4ft   6005718.98472 2109769.85153 37.7733493059578 -122.423644547079 (37.7733493059578, -122.423644547079)
132 116641 Permitted Site 1 Ginkgo biloba :: Maidenhair Tree 44 270 Brannan St 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     1 4x4   6015158.0 2112983.0 37.782700175280794 -122.39121805332199 (37.7827001752808, -122.391218053322)
135 237030 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Octavia St 4 : 4 Tree 1 DPW 2     5 Width 4ft   6005725.94025 2109733.85532 37.773250861665204 -122.423617927146 (37.7732508616652, -122.423617927146)
137 228561 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 700 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 Width 3ft   6006199.77605 2105468.2728 37.7615653191939 -122.42167583577299 (37.7615653191939, -122.421675835773)
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)
140 6337 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 1916 Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6001700.9234 2112915.307 37.7817583075946 -122.437768878541 (37.7817583075946, -122.437768878541)
141 832 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1396 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 12:18:00 PM 3 3X3   5981551.7086 2105613.8347 37.7605442750604 -122.50693272862101 (37.7605442750604, -122.506932728621)

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 3068.707ms · Data source: data.sfgov.org