Street_Tree_List

Data source: data.sfgov.org

189,144 rows sorted by SiteOrder

View and edit SQL

These facets timed out: PlantType

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▼ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
858 251395 Undocumented 2 Cupaniopsis anacardioides :: Carrotwood 118 2101 26th St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6012226.0 2101445.0 37.750856267744496 -122.400550836744 (37.7508562677445, -122.400550836744)
999 251422 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 480x De Long St   Front Yard : Yard 7 Tree 1 Private 1       3x3   5992963.0 2086633.0 37.709093057147996 -122.466087289133 (37.709093057148, -122.466087289133)
1101 251439 DPW Maintained 3 Gleditsia triacanthos :: Honey Locust 67 49X Eddy St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6010285.0 2113564.0 37.78402382830029 -122.408117626865 (37.7840238283003, -122.408117626865)
1524 251544 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 863X Ocean Ave   Side Yard : Yard 17 Tree 1 Private 1       3x3   5997430.0 2091537.0 37.722815009603295 -122.451002133856 (37.7228150096033, -122.451002133856)
1556 251583 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 75 Rice St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5995352.0 2086409.0 37.7086155444167 -122.45781440192499 (37.7086155444167, -122.457814401925)
1620 251543 Undocumented 2 Pinus radiata :: Monterey Pine 3 0X Bay Shore Blvd Off Ramp   Side Yard : Yard 17 Tree 1 Private 1                    
1635 251542 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 50 Vista Ln   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 780127 5999350.0 2102347.0 37.752606437592604 -122.445141915929 (37.7526064375926, -122.445141915929)
1683 251669 Undocumented 2 Schinus terebinthifolius :: Brazilian Pepper 25 203 Addison St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6002642.0 2097220.0 37.7387162474086 -122.433391278876 (37.7387162474086, -122.433391278876)
1735 251679 Undocumented 2 Dodonaea viscosa :: Hop Bush 132 5 Dwight St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6011495.0 2091622.0 37.7238435952898 -122.40238810251101 (37.7238435952898, -122.402388102511)
1769 251689 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 355 Silver Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6003702.0 2093526.0 37.728633439635104 -122.429462937782 (37.7286334396351, -122.429462937782)
1836 251749 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 601 Prague St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6002875.0 2087693.0 37.7125704580966 -122.43190559156 (37.7125704580966, -122.43190559156)
1848 251743 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 143 Cordova St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001773.0 2087479.0 37.7119203272299 -122.43569914014999 (37.7119203272299, -122.43569914015)
1946 252821 Undocumented 2 Nyssa sylvatica :: Tupelo: Sour Gum 162 47 Miramar Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5995289.0 2090229.0 37.719100747698704 -122.45830844121001 (37.7191007476987, -122.45830844121)
1985 252841 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1763 Golden Gate Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/07/1998 12:00:00 AM   3x3 Permit Number 40601 6001163.0 2111730.0 37.7784731541065 -122.43954484007 (37.7784731541065, -122.43954484007)
2126 252903 Undocumented 2 Private shrub :: Private Shrub 64 215 Capistrano Ave   Front Yard : Yard 7 Tree 1 Private 1       3x3   6001180.0 2093207.0 37.727614424830705 -122.438158778943 (37.7276144248307, -122.438158778943)
2198 252932 Undocumented 2 Olea europaea :: Olive Tree 41 66 Edgar Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5997141.0 2091179.0 37.7218154760893 -122.451975324711 (37.7218154760893, -122.451975324711)
2199 252934 Undocumented 2 Olea europaea :: Olive Tree 41 78 Edgar Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5997141.0 2091229.0 37.7219527643602 -122.451978930217 (37.7219527643602, -122.451978930217)
2201 252933 Undocumented 2 Olea europaea :: Olive Tree 41 72 Edgar Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5997141.0 2091205.0 37.7218868659906 -122.45197719957199 (37.7218868659906, -122.451977199572)
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)
2650 253148 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 375 Naples St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/13/2000 12:00:00 AM   3x3 Permit Number 43092 6003622.0 2091383.0 37.722744709081205 -122.42958672889 (37.7227447090812, -122.42958672889)
2749 253209 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1129 Naples St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001432.0 2087854.0 37.712930619101 -122.43690455890899 (37.712930619101, -122.436904558909)
2757 253210 Undocumented 2 Cedrus deodara :: Deodar Cedar 129 567 Mississippi St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014163.0 2104519.0 37.7594046471392 -122.394067636073 (37.7594046471392, -122.394067636073)
3318 253415 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 55 Stoneybrook Ave   Front Yard : Cutout 8 Tree 1 Private 1   08/31/2017 12:00:00 AM 3   Permit Number 779907 6005926.97731 2093972.4268599998 37.729984953042795 -122.421802746417 (37.7299849530428, -122.421802746417)
3851 252871 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2557 Sutter St   Front Yard : Yard 7 Tree 1 Private 1       3x3   5999847.0 2113975.0 37.7845623594454 -122.444258736096 (37.7845623594454, -122.444258736096)
4032 253155 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 546 Ellington Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 11:02:00 AM 3 3x3   5997941.0 2087090.0 37.710633814489604 -122.44891554828999 (37.7106338144896, -122.44891554829)
4222 253622 Undocumented 2 Pittosporum spp :: Pittosporum spp 128 300x Naglee Ave   Unaccepted Street : Yard 14 Tree 1 Private 1                    
5008 253723 DPW Maintained 3 Calocedrus decurrens :: Incense Cedar 177 1X Glenview Dr   Median : Yard 3 Tree 1 DPW 2       3x3   5998487.0 2100314.0 37.746975021233204 -122.447979947083 (37.7469750212332, -122.447979947083)
5181 253819 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1100x Prague St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001057.0 2086858.0 37.71017450293179 -122.43812937571998 (37.7101745029318, -122.43812937572)
8534 96176 Permitted Site 1 Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 251     Unaccepted Street : Cutout 20 Tree 1 Private 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767809          
9563 108596 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 36 Bronte St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   1 3x3 Permit Number 770949 6009339.44395 2097251.26276 37.7391797819084 -122.410236794344 (37.7391797819084, -122.410236794344)
9585 96180 Permitted Site 1 Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 251     Unaccepted Street : Cutout 20 Tree 1 Private 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767812          
9710 173649 Undocumented 2 Quercus ilex :: Holly Oak 78 2645 Lake St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5987243.0 2114574.0 37.7854798983764 -122.48790776340401 (37.7854798983764, -122.487907763404)
9718 105047 Planning Code 138.1 required 4 Tristaniopsis laurina :: Swamp Myrtle 37 278 Capitol Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5995102.4 2087946.7 37.7128233663074 -122.458788296392 (37.7128233663074, -122.458788296392)
9777 88104 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1247 46th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/2008 12:00:00 AM   4x10 Permit Number 51108 5981754.7 2106590.8 37.763238693975296 -122.50630313344999 (37.7632386939753, -122.50630313345)
9790 104876 Planning Code 138.1 required 4 Prunus laurocerasus :: English laurel 227 2478 43rd Ave   Sidewalk: Property side : Cutout 5 Tree 1 Private 1   12/28/2016 12:00:00 AM 3   Permit Number 778928 5983068.6 2098273.8 37.740479796641296 -122.50114367627701 (37.7404797966413, -122.501143676277)
9962 173753 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1140 Lawton St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5990653.0 2104548.0 37.7581495573033 -122.475378025252 (37.7581495573033, -122.475378025252)
10029 94465 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 4128 17th St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 5x6 Permit Number 779215 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
10086 88538 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 1306 York St   Sidewalk: Property side : Cutout 5 Tree 1 Private 1   06/26/2009 12:00:00 AM   3x12 Permit Number 52223 6010027.5 2101589.4 37.7511299031436 -122.40816367021999 (37.7511299031436, -122.40816367022)
10162 173888 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2 Vasquez Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5995783.0 2100209.0 37.7465317821399 -122.457322486502 (37.7465317821399, -122.457322486502)
10220 173929 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 95 High St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5999870.0 2100717.0 37.7481605193068 -122.443226610241 (37.7481605193068, -122.443226610241)
10258 173932 Undocumented 2 Myoporum laetum :: Myoporum 1 1109x Alemany Blvd   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6003491.0 2094313.0 37.7307824159859 -122.430248501015 (37.7307824159859, -122.430248501015)
10638 96234 Permitted Site 1 Tree(s) :: 17     Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   04/15/2011 12:00:00 AM     Permit Number 767856          
11086 96178 Permitted Site 1 Citrus aurantifolia 'Bearss' :: Seedless Lime 268     Unaccepted Street : Cutout 20 Tree 1 Private 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767810          
11627 88529 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12     Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/2008 12:00:00 AM   3x3 Permit Number 51479          
11641 96232 Permitted Site 1 Tree(s) :: 17     Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1                    
12440 100166 Property Tree 7 Salix spp :: Willow 218 2340 Twin Peaks Blvd   Front Yard : Yard 7 Tree 1 Private 1         Permit Number 769026          
13297 173883 Undocumented 2 Tree(s) :: 17 127 Holloway Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/23/2017 12:00:00 AM 3 3x3 Permit Number 779596 5996444.0 2091166.0 37.721739833175 -122.454383721237 (37.721739833175, -122.454383721237)
13429 96174 Permitted Site 1 Malus sylvestris :: Apple 281     Unaccepted Street : Cutout 20 Tree 1 Private 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767807          
14101 96173 Permitted Site 1 Sequoia sempervirens :: Coast Redwood 116     Unaccepted Street : Cutout 20 Tree 1 Private 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767806          
15678 96177 Permitted Site 1 Diospyros kaki :: Persimmon 293     Unaccepted Street : Cutout 20 Tree 1 Private 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767810          
15720 96179 Permitted Site 1 Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 251     Unaccepted Street : Cutout 20 Tree 1 Private 1       3x3 Permit Number 767811          
15790 87061 Permitted Site 1 Eucalyptus Spp :: Eucalyptus 40     unknown : Yard 19 Tree 1 Private 1       3x3 Permit Number 50003          
16044 96231 Permitted Site 1 Tree(s) :: 17     Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1                    
16457 93053 Permitted Site 1 Pinus Spp :: Pine Spp 105     Front Yard : Yard 7 Tree 1 Private 1   04/28/2010 12:00:00 AM 36   Permit Number 53387          
16511 96175 Permitted Site 1 Malus sylvestris :: Apple 281     Unaccepted Street : Cutout 20 Tree 1 Private 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767808          
18196 108832 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 60 Ney St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774659 6003833.887 2093995.50335 37.7299300570357 -122.429040457944 (37.7299300570357, -122.429040457944)
18642 106966 Undocumented 2 Tree(s) :: 17 2391 47TH AVE   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5981720.8 2098834.4 37.7419398125124 -122.505845312535 (37.7419398125124, -122.505845312535)
18677 88330 Permitted Site 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 544 London St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51318 6001416.8 2090660.3 37.720635228492206 -122.437157897339 (37.7206352284922, -122.437157897339)
18679 86291 DPW Maintained 3 Melaleuca quinquenervia :: Cajeput 50 1339 25th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/05/2006 12:00:00 AM 3 3x3   5988318.888394 2106196.850699 37.7625412799726 -122.483571174333 (37.7625412799726, -122.483571174333)
18682 87286 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1272 42nd Ave   Sidewalk: Property side : Yard 9 Tree 1 Private 1   03/18/2007 12:00:00 AM     Permit Number 50303 5983096.8 2106514.6 37.7631083916796 -122.501655692289 (37.7631083916796, -122.501655692289)
18733 88323 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 125 Lisbon St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51312 6003417.0 2092629.0 37.7261543381556 -122.430384225952 (37.7261543381556, -122.430384225952)
18879 94134 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 18 Nebraska St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/11/2010 12:00:00 AM   3x3 Permit Number 53498 6009291.0 2097948.0 37.7410901551317 -122.41045347697501 (37.7410901551317, -122.410453476975)
18892 116488 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2149 LYON ST   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5999319.0 2116238.0 37.7907458271484 -122.446248274058 (37.7907458271484, -122.446248274058)
19027 97174 Significant Tree 6 Tristaniopsis laurina :: Swamp Myrtle 37 26 Gilbert St   Sidewalk: Property side : Cutout 5 Tree 1 Private 1 FUF 1         6011445.1 2110013.2 37.7743390438118 -122.40385413458 (37.7743390438118, -122.40385413458)
19054 94934 Significant Tree 6 Ficus carica 'Black Mission' :: Black Mission Fig 311 2451X Griffith St   Sidewalk: Property side : Cutout 5 Tree 1 Housing Authority 20 FUF 1 04/04/2009 12:00:00 AM       6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
19238 104509 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 80 DICHIERA CT   Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14     5998620.0 2088043.0 37.7132893442667 -122.446637305723 (37.7132893442667, -122.446637305723)
19350 95161 Significant Tree 6 Acer palmatum :: Japanese Maple 175 2721 Pacific Ave   Front Yard : Yard 7 Tree 1 Private 1         Permit Number 54078 6001026.7 2116843.3 37.7925052022591 -122.440383162252 (37.7925052022591, -122.440383162252)
19413 106117 Permitted Site 1 Ginkgo biloba :: Maidenhair Tree 44 405 Lisbon St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/24/2014 12:00:00 AM   3x3 Permit Number 772749 6002458.5 2091056.7 37.721782813937395 -122.433585385445 (37.7217828139374, -122.433585385445)
19424 87790 Permitted Site 1 Brahea aramata :: Mexican Blue Palm 313 635 Buena Vista West Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/31/2008 12:00:00 AM     Permit Number 50531 5999771.0 2107673.0 37.7672543384354 -122.44406869049699 (37.7672543384354, -122.444068690497)
19560 103375 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 22 VANDEWATER ST   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       2.5x2.5 Permit Number 770057 6009069.0 2121391.0 37.8054466905223 -122.41287812458401 (37.8054466905223, -122.412878124584)
19599 106501 Undocumented 2 Tree(s) :: 17 1266 09TH AVE   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x6   5993358.0 2106830.8 37.764573953722 -122.46618893715001 (37.764573953722, -122.46618893715)
19638 88554 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 579 16th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/2008 12:00:00 AM   3x3 Permit Number 51499 5990911.3 2111462.4 37.777149603591496 -122.474989443149 (37.7771496035915, -122.474989443149)
19648 88109 Permitted Site 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 1305 48th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/01/2008 12:00:00 AM   3x3 Permit Number 51113 5981150.4 2106141.9 37.7619705488895 -122.50835984594299 (37.7619705488895, -122.508359845943)
19781 96412 Significant Tree 6 Acer palmatum :: Japanese Maple 175 185 Chilton Ave   Front Yard : Yard 7 Tree 1 Private 1   05/18/2011 12:00:00 AM     Permit Number 767805 6001587.1 2095138.7 37.732941575251004 -122.436889661497 (37.732941575251, -122.436889661497)
19801 94573 Permitted Site 1 Jacaranda mimosifolia :: Jacaranda 52 3978 18th St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/20/2010 12:00:00 AM   3x3 Permit Number 53752 6003116.0 2105363.0 37.761101890414 -122.432333828196 (37.761101890414, -122.432333828196)
20263 91677 DPW Maintained 3 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 599 South Van Ness Ave   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/01/2007 12:00:00 AM 3 3x3   6007489.042117 2106191.6259580003 37.763624095672895 -122.417268041752 (37.7636240956729, -122.417268041752)
20297 87411 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 898X Ellis St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/22/2008 12:00:00 AM 3 3x3   6006570.640875 2113589.260791 37.783884515657896 -122.42096977598499 (37.7838845156579, -122.420969775985)
20384 104821 Undocumented 2 Ficus nitida :: Laurel Fig 43 2173 15TH ST   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20     6003063.7 2107068.1 37.7657807169148 -122.43263651234301 (37.7657807169148, -122.432636512343)
20472 89331 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 4658 18th St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/31/2008 12:00:00 AM   3x3 Permit Number 51984 6000201.0 2105201.0 37.760491360371596 -122.4424038966 (37.7604913603716, -122.4424038966)
20985 87685 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 118 Virginia Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/23/2008 12:00:00 AM   4x4 Permit Number 776560 6006594.8 2098480.6 37.7424010366351 -122.419813761733 (37.7424010366351, -122.419813761733)
21199 97237 Property Tree 7 Olea europaea :: Olive Tree 41 125 Excelsior Ave   Sidewalk: Property side : Yard 9 Tree 1 SFUSD 4 FUF 1 09/07/2011 12:00:00 AM     Permit Number 767513 6002911.0 2092621.3 37.7261045201699 -122.43213288829399 (37.7261045201699, -122.432132888294)
21236 92078 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1151 Sutter St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/22/2009 12:00:00 AM   3x3 Permit Number 52192 6007083.0 2115004.0 37.7877979108835 -122.41929759225799 (37.7877979108835, -122.419297592258)
25407 95032   Tree(s) :: 17 211 Maynard St   Front Yard : Cutout 8 Landscaping 2 Private 1           6004772.0 2093802.0 37.729451797878205 -122.425783519869 (37.7294517978782, -122.425783519869)
28196 88382 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 355 17th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM 2 3x3 Permit Number 51360 5990561.77007 2113010.94096 37.7813812065074 -122.476311706446 (37.7813812065074, -122.476311706446)
29641 89003 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 658 40th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/25/2008 12:00:00 AM 5 3x3 Permit Number 51755 5983531.7658 2111325.68873 37.7763438006114 -122.50050706598 (37.7763438006114, -122.50050706598)
30135 105475 Undocumented 2 Tree(s) :: 17 671 Waller St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/29/2014 12:00:00 AM   3x3   6002476.36422 2108834.33955 37.770597051265604 -122.434794296397 (37.7705970512656, -122.434794296397)
30542 86751 Permitted Site 1 Tree(s) :: 17 81 Parker Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/03/2007 12:00:00 AM     Permit Number 49713 5996801.8 2114038.7 37.7845630578844 -122.454798641129 (37.7845630578844, -122.454798641129)
30941 88552 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 649 15th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/2008 12:00:00 AM 3 3x3 Permit Number 51497 5991271.5415199995 2111000.35442 37.7759018234336 -122.473709552083 (37.7759018234336, -122.473709552083)
32417 105247 Undocumented 2 Schinus terebinthifolius :: Brazilian Pepper 25 1301X COLE ST   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 4x 5   5998246.0 2105821.0 37.7620821004846 -122.44920998148999 (37.7620821004846, -122.44920998149)
33525 88586 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 815 24th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/31/2008 12:00:00 AM 4 3x3 Permit Number 51529 5988483.68185 2110405.40991 37.7741064155227 -122.483309739734 (37.7741064155227, -122.483309739734)
34103 88390 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 258 22nd Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM 6 3x3 Permit Number 51368 5989033.92216 2113597.32101 37.7829025195026 -122.48164021539301 (37.7829025195026, -122.481640215393)
34436 88394 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 139 25th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM 1 3x3 Permit Number 51373 5988000.05712 2115038.19323 37.78679857243979 -122.485322676521 (37.7867985724398, -122.485322676521)
35131 88579 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 767 19th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/31/2008 12:00:00 AM 4 3x3 Permit Number 51519 5990042.4275400005 2110151.2798 37.773499236106204 -122.477899243352 (37.7734992361062, -122.477899243352)
37397 91640 DPW Maintained 3 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1427 South Van Ness Ave   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/01/2007 12:00:00 AM 8 3x3   6007757.588641 2101343.9238919998 37.7503285203588 -122.415995902486 (37.7503285203588, -122.415995902486)
37400 88728 Permitted Site 1 Eriobotrya deflexa :: Bronze Loquat 49 68 Pontiac St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/11/2008 12:00:00 AM   3x3 Permit Number 51663 6010467.8 2117974.1 37.7961431384766 -122.407796278381 (37.7961431384766, -122.407796278381)
40011 88560 Permitted Site 1 Prunus spp :: Cherry 84 2901 Pierce St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/2008 12:00:00 AM   3x3 Permit Number 51505 6001501.0 2118350.0 37.7966692015857 -122.43885009322901 (37.7966692015857, -122.438850093229)
40857 124637 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 124 Arguello Blvd   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     31 Width 5ft   5995537.16304 2115311.02189 37.787983889154205 -122.459265995172 (37.7879838891542, -122.459265995172)
41693 91420 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 770 18th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/08/2009 12:00:00 AM 5 3x3 Permit Number 52101 5990400.3408699995 2110139.21584 37.7734868781795 -122.47666030039301 (37.7734868781795, -122.476660300393)
41811 108815 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 474 Munich St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774652 6003779.44726 2089723.3814299998 37.7181966752665 -122.42892420414499 (37.7181966752665, -122.428924204145)
42748 89044 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 44 Surrey St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 51783 6002618.0 2096049.0 37.735499589249294 -122.433390603486 (37.7354995892493, -122.433390603486)

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