Street_Tree_List

Data source: data.sfgov.org

188,912 rows where PlantType = 1 sorted by DBH

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            
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)
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)
51 60867 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/1983 12:00:00 AM     Permit Number 20649          
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)
57 44642 Permitted Site 1 Tree(s) :: 17   60 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
59 44994 Permitted Site 1 Tree(s) :: 17   106 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
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)
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)
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)
84 36641 Permitted Site 1 Robinia x ambigua :: Locust 33   13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/20/1998 12:00:00 AM     Permit Number 39461          
86 119601 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 34 4357x Mission St 3 Front Yard : Yard 7 Tree 1 Private 1         Permit Number 774415          
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)
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)
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                
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)
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)
125 119758 Undocumented 2 Maytenus boaria :: Mayten 22 151X Octavia St Frontage West 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
142 251241 Undocumented 2 Cupressocyparis leylandii :: Leyland Cypress 34 2305 Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5998495.0 2111363.0 37.777313260379 -122.44874797929701 (37.777313260379, -122.448747979297)
151 36617 Permitted Site 1 Robinia x ambigua :: Locust 33   8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/20/1998 12:00:00 AM     Permit Number 39461          
155 251225 Undocumented 2 Jacaranda mimosifolia :: Jacaranda 52 1 Yukon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       12x2.5   6000238.0 2104757.0 37.7592743544717 -122.442244057145 (37.7592743544717, -122.442244057145)
161 142720 Undocumented 2 :: 54 1170 COLUMBUS AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6007999.4825 2121188.7351 37.8048312311886 -122.416565007078 (37.8048312311886, -122.416565007078)
162 251231 Undocumented 2 Pinus radiata :: Monterey Pine 3 164 Serrano Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5989598.0 2090848.0 37.7204716934452 -122.478025052476 (37.7204716934452, -122.478025052476)
166 251230 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 99x Ogden Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007537.0 2096150.0 37.7360547576169 -122.416390866966 (37.7360547576169, -122.416390866966)
167 251232 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 99x Ogden Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007537.0 2096150.0 37.7360547576169 -122.416390866966 (37.7360547576169, -122.416390866966)
171 251242 Undocumented 2 Cupressocyparis leylandii :: Leyland Cypress 34 2449 Golden Gate Ave 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1           5997716.0 2111278.0 37.7770352956542 -122.451436646998 (37.7770352956542, -122.451436646998)
172 48332 Permitted Site 1 Tree(s) :: 17   142 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
174 251226 Undocumented 2 Koelreuteria paniculata :: Golden Rain Tree 56 1 Yukon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       13x2.5   6000262.0 2104839.0 37.7595008741196 -122.442166940047 (37.7595008741196, -122.442166940047)
185 251243 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 299x Chapman St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6008953.0 2098186.0 37.7417246968109 -122.411638974942 (37.7417246968109, -122.411638974942)
187 251248 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 829 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6001839.0 2095802.0 37.7347771581377 -122.436066227259 (37.7347771581377, -122.436066227259)
196 251246 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 722X Mendell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3X3   6016169.292972799 2097000.9113916 37.738872842648796 -122.38660458641 (37.7388728426488, -122.38660458641)
197 251245 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 701 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/04/1992 12:00:00 AM       6002463.96916 2095671.24377 37.73445361741221 -122.433896153002 (37.7344536174122, -122.433896153002)
204 61453 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/22/1984 12:00:00 AM     Permit Number 21392          
214 251244 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 99 Grove St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5   05/29/2013 12:00:00 AM       6007340.02606 2111591.01475 37.778441154342296 -122.41816626519301 (37.7784411543423, -122.418166265193)
222 251247 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 722X Mendell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3X3   6016169.292972799 2097000.9113916 37.738872842648796 -122.38660458641 (37.7388728426488, -122.38660458641)
235 45975 Permitted Site 1 Tree(s) :: 17   132 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
238 251251 DPW Maintained 3 Prunus amygdalus :: Almond 63 321X Corbett Ave 2 Front Yard : Yard 7 Tree 1 DPW 2       10x10   5999565.0 2105069.0 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425)
239 251252 DPW Maintained 3 Prunus amygdalus :: Almond 63 321X Corbett Ave 3 Front Yard : Yard 7 Tree 1 DPW 2       10x10   5999565.0 2105069.0 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425)
241 251257 Undocumented 2 Phoenix dactylifera :: Date Palm 65 1748x Eucalyptus Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5986101.0 2094852.0 37.7312620395563 -122.490407299046 (37.7312620395563, -122.490407299046)
245 251255 Undocumented 2 Tree(s) :: 17 4089x Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5991686.0 2086822.0 37.7095382490701 -122.47051450746099 (37.7095382490701, -122.470514507461)
246 251253 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 1350 Howard St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6008544.9526 2110145.4696299997 37.774539777213995 -122.413895673958 (37.774539777214, -122.413895673958)
247 251250 DPW Maintained 3 Prunus amygdalus :: Almond 63 321X Corbett Ave 1 Front Yard : Yard 7 Tree 1 DPW 2       10x10   5999565.0 2105069.0 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425)
249 251254 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 330 09th Ave 1 unknown : Cutout 12 Tree 1 MTA 6       3x3   5993109.0 2113253.0 37.782193225103605 -122.467517213871 (37.7821932251036, -122.467517213871)
251 251258 Undocumented 2 Phoenix dactylifera :: Date Palm 65 1748x Eucalyptus Dr 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5986101.0 2094852.0 37.7312620395563 -122.490407299046 (37.7312620395563, -122.490407299046)
253 251256 Undocumented 2 Gleditsia triacanthos :: Honey Locust 67 4091x Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5991686.0 2086783.0 37.70943116445179 -122.470511668938 (37.7094311644518, -122.470511668938)
257 251260 Undocumented 2 Pyrus calleryana :: Ornamental Pear 9 1163 South Van Ness Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 3ft   6007684.87734 2102881.8281400003 37.754547168222295 -122.41635626045701 (37.7545471682223, -122.416356260457)
258 251259 Undocumented 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 1050x Sacramento St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6009753.0 2116795.0 37.7928655753561 -122.410186352148 (37.7928655753561, -122.410186352148)
272 251264 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          
277 251265 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          
279 48153 Permitted Site 1 Tree(s) :: 17   263 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
293 251262 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          
294 251266 Private 5 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 10x Paloma Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
300 251263 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          
308 46059 Permitted Site 1 Tree(s) :: 17   101 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
316 67789 Permitted Site 1 Tree(s) :: 17 7 4384 St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/17/1992 12:00:00 AM     Permit Number 31429          
320 48259 Permitted Site 1 Tree(s) :: 17   123 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
321 65143 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/1989 12:00:00 AM     Permit Number 27118          
328 251272 Undocumented 2 Acer negundo :: Box Elder 74 1301X 07th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5993949.0 2106317.0 37.7631972735035 -122.46410754142299 (37.7631972735035, -122.464107541423)
339 251273 Undocumented 2 Acer negundo :: Box Elder 74 1301X 07th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5993949.0 2106317.0 37.7631972735035 -122.46410754142299 (37.7631972735035, -122.464107541423)
344 251279 DPW Maintained 3 Quercus suber :: Cork Oak 76 1200x Hudson Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3     3x3   6017356.0 2095183.0 37.733946845802 -122.38237501907301 (37.733946845802, -122.382375019073)
358 251286 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 1299x Hudson Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 02/09/1998 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
363 119608 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 34 299x Avalon Ave 4 Front Yard : Yard 7 Tree 1 Private 1                    
375 251284 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 1299x Hudson Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 06/21/1996 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
385 251282 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 1299x Hudson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 04/07/2016 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
390 251276 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1175X Hudson Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/09/1998 12:00:00 AM   3x3   6017547.0 2094834.0 37.732999109091 -122.381690402626 (37.732999109091, -122.381690402626)
391 251275 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1175x Hudson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 09/16/2011 12:00:00 AM   3x3   6017547.0 2094834.0 37.732999109091 -122.381690402626 (37.732999109091, -122.381690402626)
392 251280 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 1275x Hudson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/11/2006 12:00:00 AM   3x3   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216)
393 251277 DPW Maintained 3 Quercus suber :: Cork Oak 76 1200x Hudson Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 10/26/2011 12:00:00 AM   3x3   6017356.0 2095183.0 37.733946845802 -122.38237501907301 (37.733946845802, -122.382375019073)
398 251281 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 1275x Hudson Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/23/2006 12:00:00 AM   3x3   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216)
402 251283 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 1299x Hudson Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 06/06/1997 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
409 251278 DPW Maintained 3 Quercus suber :: Cork Oak 76 1200x Hudson Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 01/27/2016 09:31:00 AM   3x3   6017356.0 2095183.0 37.733946845802 -122.38237501907301 (37.733946845802, -122.382375019073)
410 251287 DPW Maintained 3 Callistemon viminalis :: Weeping Bottlebrush 20 1299x Hudson Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 02/09/1998 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
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)
427 251307 Undocumented 2 Tree(s) :: 17 200 Cashmere St 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   6016315.0 2096328.0 37.7370332293639 -122.38605389871 (37.7370332293639, -122.38605389871)
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)
433 251301 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 100 Whitney Young Cir 2 Back Yard : Yard 13 Tree 1 Mayor Office of Housing 7       3x3   6016360.0 2096059.0 37.736297099957106 -122.385879567348 (37.7362970999571, -122.385879567348)
441 251295 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 220 Point Lobos Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/1989 12:00:00 AM   3x3 Permit Number 27117 5982087.0 2112698.0 37.7800268469822 -122.50560657808902 (37.7800268469822, -122.505606578089)
444 44838 Permitted Site 1 Tree(s) :: 17   12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
445 251285 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1299x Hudson Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/11/2006 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
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)
454 251309 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 2111 15th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5991606.081259999 2101026.68041 37.7485361329461 -122.471825260742 (37.7485361329461, -122.471825260742)
462 187628 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2 Rotteck St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 779889 6003236.0 2095183.0 37.7331567921798 -122.431192151262 (37.7331567921798, -122.431192151262)
467 85277 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 801 Holladay Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/2007 12:00:00 AM     Permit Number 49566          
474 251300 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 100 Whitney Young Cir 1 Back Yard : Yard 13 Tree 1 Health Dept 8       3x3   6016360.0 2096059.0 37.736297099957106 -122.385879567348 (37.7362970999571, -122.385879567348)
476 174954 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1400x Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4xt Permit Number 779898 6007316.0 2110809.0 37.776292577113104 -122.418193923043 (37.7762925771131, -122.418193923043)
509 38234 Permitted Site 1 Geijera parviflora :: Australian Willow 68 0 16th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/1998 12:00:00 AM     Permit Number 40352          
514 251312 Undocumented 2 :: 54 1499 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6003369.0 2099547.0 37.7451468706327 -122.431043696183 (37.7451468706327, -122.431043696183)
515 48129 Permitted Site 1 Tree(s) :: 17   297 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
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)
536 45913 Permitted Site 1 Tree(s) :: 17   59 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
541 251317 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 399X 12th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
545 251322 Undocumented 2 Betula spp :: Birch 95 828 Foerster St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1       Width 3ft   5998302.82159 2096489.58159 37.7364635618398 -122.448341458403 (37.7364635618398, -122.448341458403)
549 251321 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 100X Monument Way 1 Unaccepted Street : Yard 14 Tree 1 Private 1                    
558 251320 Undocumented 2 Schinus terebinthifolius :: Brazilian Pepper 25 35 Park St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 3ft   6004965.06472 2096463.48809 37.7367705580153 -122.425305393447 (37.7367705580153, -122.425305393447)
580 48268 Permitted Site 1 Tree(s) :: 17   132 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          

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