trees

194,517 rows sorted by Supervisor Districts descending

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts ▲ Zip Codes Neighborhoods (old)
75 74661 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 165-167 11th St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056) 8 2 9 28853 34
98 261380 DPW Maintained 1 Potential Site :: Potential Site 48 298x Leavenworth St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6008523 2113477 37.7836861327236 -122.414207368753 (37.7836861327236, -122.414207368753) 7 10 9 28852 36
105 70839 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 939 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     6010931.16123 2112337.60471 37.780692593337 -122.405795716794 (37.780692593337, -122.405795716794) 14 2 9 28853 34
118 236256 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 151 Valencia St 1 : Tree Private 2     9 Width 4ft   6006073.15075 2108915.83898 37.7710243776945 -122.422358744984 (37.7710243776945, -122.422358744984) 8 2 9 28853 19
152 235666 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1301 Jessie St 4 : Tree Private 2     3 Width 2ft   6006462.25734 2109005.38337 37.7712921868165 -122.421019169707 (37.7712921868165, -122.421019169707) 8 2 9 28853 19
158 100607 Permitted Site 7 Tree(s) :: 17 270x 05th St 5 Sidewalk: Curb side : Cutout Tree Private 2           6011410.5 2112131.8 37.7801542961347 -122.404122955966 (37.7801542961347, -122.404122955966) 14 2 9 28853 34
193 100595 Permitted Site 7 Tree(s) :: 17 401x Clementina St 10 Sidewalk: Curb side : Cutout Tree Private 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
195 101535 Permitted Site 7 Tree(s) :: 17 1X Main St 12 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
211 196303 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 249 Shipley St 1 : Tree Private 2     1 Width 5ft   6011469.59111 2111688.37468 37.7789400547713 -122.403887319468 (37.7789400547713, -122.403887319468) 14 2 9 28856 34
309 40920 Permitted Site 7 Tree(s) :: 17 720 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/23/1999 12:00:00 AM     Permit Number 41793 6012338.0511994 2113764.09224404 37.7846879743619 -122.401028836502 (37.7846879743619, -122.401028836502) 12 2 9 28853 6
317 189161 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 109 Kissling St 4 : Tree Private 2     2 Width 3ft   6008149.50016 2109391.65635 37.7724477670719 -122.415210253457 (37.7724477670719, -122.415210253457) 8 2 9 28853 19
331 194117 DPW Maintained 1 Nyssa sylvatica :: Tupelo: Sour Gum 92 2 13th St 9 : Tree Private 2     2 Width 3ft   6009035.07102 2108345.44011 37.7696248302591 -122.412073015253 (37.7696248302591, -122.412073015253) 8 4 9 28853 19
335 102831 Undocumented 4 Schinus terebinthifolius :: Brazilian Pepper 93 25X Lansing St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6014531.5 2114230.8 37.7860915609161 -122.393472847757 (37.7860915609161, -122.393472847757) 6 2 9 28855 6
336 189035 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 50 Russ St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6010091.10409 2111787.20644 37.7791343146469 -122.408663052281 (37.7791343146469, -122.408663052281) 14 2 9 28853 34
337 193188 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 401 Harrison St 6 Sidewalk: Curb side : Yard Tree Private 2     9 Width 4ft   6014838.37703 2114321.79559 37.7863584598262 -122.392417493778 (37.7863584598262, -122.392417493778) 6 2 9 28855 6
347 108327 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
371 251215 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 175X Otis St 11 Sidewalk: Curb side : Cutout Tree DPW 1       3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.420111956743 (37.7705111956623, -122.420111956743) 8 2 9 28853 19
373 200940 DPW Maintained 1 :: 45 1515 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6008432.2434 2109068.8895 37.7715774111529 -122.414209373869 (37.7715774111529, -122.414209373869) 8 2 9 28853 19
419 78519 Significant Tree 6 Tree(s) :: 17 12 Sumner St 1 Front Yard : Yard Tree Private 2     15 3x3   6009421 2110873 37.7765865656959 -122.410916638665 (37.7765865656959, -122.410916638665) 8 2 9 28853 34
424 13666 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 653 Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/21/2014 12:00:00 AM 3 4x4   6011846.3206496 2114969.3004876 37.7879697501429 -122.402814861202 (37.7879697501429, -122.402814861202) 12 2 9 28855 6
441 200380 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 199x Shipley St 2 : Tree Private 2     7 Width 2ft   6011866.27149 2112076.32254 37.7800274232626 -122.402542323073 (37.7800274232626, -122.402542323073) 6 2 9 28856 34
448 17338 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 175X Otis St 3 Sidewalk: Curb side : Cutout Tree DPW 1   08/18/1993 12:00:00 AM 12 3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.420111956743 (37.7705111956623, -122.420111956743) 8 2 9 28853 19
507 195311 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 101 Market St 9 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6013845.70185 2116893.75953 37.7933653000223 -122.396032227918 (37.7933653000223, -122.396032227918) 12 2 9 28855 6
508 113374 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 88 HOWARD ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014757 2116474 37.7922633974731 -122.39284966575 (37.7922633974731, -122.39284966575) 12 2 9 28855 6
521 100638 Permitted Site 7 Tree(s) :: 17 401X Clementina St 8 Sidewalk: Curb side : Cutout Tree Private 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
535 50166 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 159 Russ St 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/11/2003 12:00:00 AM 3 3x3 Permit Number 46878 6010492.5895 2111415.08321 37.7781350293519 -122.407247904281 (37.7781350293519, -122.407247904281) 14 2 9 28853 34
576 196628 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 147 Natoma St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6012615.71361 2114306.35859 37.78619239642 -122.400106306963 (37.78619239642, -122.400106306963) 12 2 9 28855 6
585 75271 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 499 Illinois St 6 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2016 12:00:00 AM 3 5x5   6015975.8041 2106880.05369 37.7659881814233 -122.387962771269 (37.7659881814233, -122.387962771269) 14 3 9 310 20
616 243196 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1330 Stevenson St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6006254.26009 2108909.80844 37.771018033881 -122.421731852741 (37.771018033881, -122.421731852741) 8 2 9 28853 19
630 106356 Permitted Site 7 Hymenosporum flavum :: Sweet Shade 125 74 Brady St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2014 12:00:00 AM   3x3 Permit Number 771746 6006716.8 2109464.1 37.7725660586042 -122.420171254703 (37.7725660586042, -122.420171254703) 8 2 9 28853 19
631 62744 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1440 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1986 12:00:00 AM   3x3 Permit Number 23091 6009114.80137277 2108930.88306921 37.7712367935343 -122.411838604602 (37.7712367935343, -122.411838604602) 8 2 9 28853 34
634 79736 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 705 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6008945.3206 2110776.64932 37.7762953249107 -122.412555345054 (37.7762953249107, -122.412555345054) 8 2 9 28853 34
635 193701 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1455 Owen St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6013732.82197 2108340.14659 37.7698727553585 -122.395823166124 (37.7698727553585, -122.395823166124) 14 3 9 310 20
642 260182 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 66x McCoppin St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2019 12:00:00 AM 3 3x3   6006141 2109130 37.7716162396968 -122.422139269172 (37.7716162396968, -122.422139269172) 8 2 9 28853 19
648 189633 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 10 : Tree Private 2     10 Width 3ft   6007281.55408 2110475.16176 37.775373998252 -122.418289406239 (37.775373998252, -122.418289406239) 8 2 9 28853 34
649 189627 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 4 : Tree Private 2     16 Width 3ft   6007528.52851 2110215.72509 37.7746755460784 -122.417416671761 (37.7746755460784, -122.417416671761) 8 2 9 28853 34
653 262559 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 1801 03rd St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
666 49628 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1591 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/2003 12:00:00 AM 3   Permit Number 46483 6007746.40275 2109230.16933 37.7719816997133 -122.416593168865 (37.7719816997133, -122.416593168865) 8 2 9 28853 19
684 260585 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 397 05th St 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
698 190843 DPW Maintained 1 Koelreuteria paniculata :: Golden Rain Tree 131 150 Berry St 7 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 5ft   6014866.38244 2110860.17534 37.7768551897557 -122.392078432289 (37.7768551897557, -122.392078432289) 6 2 9 28856 20
728 102430 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 200 06th St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2017 12:00:00 AM 3 4x4 Permit Number 770993 6010566.09371 2111909.33227 37.7794962351107 -122.407028471514 (37.7794962351107, -122.407028471514) 14 2 9 28853 34
769 35030 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 403 Main St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/05/1998 12:00:00 AM 15   Permit Number 38603 6015647.17286 2114807.4956 37.7877369613497 -122.389653177477 (37.7877369613497, -122.389653177477) 6 2 9 28855 6
770 111807 Undocumented 4 Ficus nitida :: Laurel Fig 53 50X COLUMBIA SQUARE ST 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
777 84774 Permitted Site 7 Tree(s) :: 17 185 Berry St 20 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2007 12:00:00 AM     Permit No. 49299 6014606 2110554 37.7760000408576 -122.392957754299 (37.7760000408576, -122.392957754299) 6 2 9 28856 20
792 188161 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1400 03rd St 7 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 5ft   6015540.87909 2108424.96815 37.7702060746856 -122.389575008375 (37.7702060746856, -122.389575008375) 14 3 9 310 20
849 51822 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 75 Dore St 7 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2005 12:00:00 AM 11   Permit Number 48062 6008911.92726 2109811.9687 37.7736446648878 -122.412602652111 (37.7736446648878, -122.412602652111) 8 2 9 28853 34
852 108444 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1 Sycamore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2014 12:00:00 AM 2 3x2.5   6014877 2117007 37.7937335561349 -122.392471758503 (37.7937335561349, -122.392471758503) 12 2 9 28855 6
920 91853 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 601x Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2007 12:00:00 AM 3 3x3   6014039.760938 2113573.418065 37.7842592071543 -122.395128082808 (37.7842592071543, -122.395128082808) 6 2 9 28856 6
928 67058 Permitted Site 7 Tree(s) :: 17 180 07th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/1992 12:00:00 AM   3x3 Permit Number 30439 6009767.36044891 2111443.36861251 37.7781720795529 -122.409758741886 (37.7781720795529, -122.409758741886) 8 2 9 28853 34
949 38398 Permitted Site 7 Tree(s) :: 17 1000 Van Ness Ave 17 Sidewalk: Curb side : Cutout Tree Private 2   06/30/1998 12:00:00 AM     Permit Number 40450 6006538.75328643 2113902.05144478 37.7847415646224 -122.421102312622 (37.7847415646224, -122.421102312622) 7 9 9 28858 36
963 109935 Section 143 10 Lophostemon confertus :: Brisbane Box 11 260 05th St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011302 2112245.5 37.7804604268654 -122.404506314811 (37.7804604268654, -122.404506314811) 14 2 9 28853 34
969 198677 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 149 Russ St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6010377.80869 2111537.89689 37.7784658224798 -122.407653636128 (37.7784658224798, -122.407653636128) 14 2 9 28853 34
977 37516 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1999 12:00:00 AM 11   Permit Number 41076 6007956.90243 2113828.43772 37.7846192815973 -122.416190755523 (37.7846192815973, -122.416190755523) 7 10 9 28858 36
992 192119 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 1 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     22 Width 4ft   6010836.94593 2113119.25584 37.782833554469 -122.406176740686 (37.782833554469, -122.406176740686) 12 2 9 28853 34
1029 65280 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 435 Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/14/1989 12:00:00 AM 1   Permit Number 28085 6011091.92612 2112217.73363 37.7803724445696 -122.405231107147 (37.7803724445696, -122.405231107147) 14 2 9 28853 34
1039 51110 Permitted Site 7 Koelreuteria paniculata :: Golden Rain Tree 131 420@ 6TH ST Berry St 21 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2004 12:00:00 AM     Permit Number 47557 6013008.01748439 2109097.62504611 37.7719122726701 -122.398383421945 (37.7719122726701, -122.398383421945) 14 2 9 310 20
1041 109054 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 200 Shipley St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011721.75389 2111961.27607 37.7797034631784 -122.403034183007 (37.7797034631784, -122.403034183007) 14 2 9 28856 34
1042 189625 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 2 : Tree Private 2     18 Width 3ft   6007555.58457 2110185.16197 37.7745931492825 -122.417320912844 (37.7745931492825, -122.417320912844) 8 2 9 28853 34
1068 189619 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1022 Harrison St 10 Sidewalk: Curb side : Yard Tree Private 2     25 Width 0ft   6010873.70675 2110523.15136 37.7757073139658 -122.405866629254 (37.7757073139658, -122.405866629254) 14 2 9 28853 34
1080 169338 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1029 Geary St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/2019 12:00:00 AM 3 Width 4ft   6006781.41851 2114264.09095 37.7857493130165 -122.420288474132 (37.7857493130165, -122.420288474132) 13 9 9 28858 36
1107 258138 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300 Beale St 12 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3     6014765.94263 2115143.61778 37.7886109721909 -122.39272561329 (37.7886109721909, -122.39272561329) 6 2 9 28855 6
1114 32669 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 750 Brannan St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37093 6011928.74882851 2109868.72792778 37.773969364433 -122.402170934506 (37.773969364433, -122.402170934506) 14 2 9 28853 34
1120 57868 DPW Maintained 1 Fraxinus spp :: Ash Spp 121 360 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1977 12:00:00 AM 7   Permit Number 16812 6008032.73051 2113659.88131 37.7841607298832 -122.415916474888 (37.7841607298832, -122.415916474888) 7 10 9 28858 36
1150 97170 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 289 08th St 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6009625.74334 2110365.68554 37.7752050776892 -122.41017254363 (37.7752050776892, -122.41017254363) 8 2 9 28853 34
1154 197414 DPW Maintained 1 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1110 04th St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6014981.73944 2109803.00942 37.7739588520651 -122.391605444662 (37.7739588520651, -122.391605444662) 14 3 9 310 20
1156 31893 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 333 12th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1995 12:00:00 AM 8   Permit Number 35323 6008432.94494 2108718.71395 37.7706159506067 -122.414182168285 (37.7706159506067, -122.414182168285) 8 2 9 28853 19
1163 127620 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 888 O'Farrell St 9 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6007042.74082 2114007.27438 37.7850588791954 -122.419366145639 (37.7850588791954, -122.419366145639) 13 9 9 28858 36
1197 200396 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1001x Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2 DPW   2 Width 8ft   6011323 2110932 37.776855034552 -122.404341187165 (37.776855034552, -122.404341187165) 14 2 9 28853 34
1209 199473 DPW Maintained 1 Washingtonia robusta :: Mexican Fan Palm 72 1000 03rd St 6 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 5ft   6015478.1467 2109531.70871 37.7732414619454 -122.389869319627 (37.7732414619454, -122.389869319627) 14 3 9 310 20
1212 40354 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 12 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1999 12:00:00 AM 8   Permit Number 41479 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
1229 264907 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 259 Clara St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
1232 264776 Undocumented 4 Grevillea robusta :: Silk Oak Tree 76 90x Guy Pl 10 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
1237 35474 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 455 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/17/1998 12:00:00 AM     Permit Number 38887 6007396.82109854 2112616.81920427 37.7812609627381 -122.418042529741 (37.7812609627381, -122.418042529741) 7 9 9 28852 36
1256 97187 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 9 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086) 12 2 9 28855 6
1263 15197 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1110 Mission St 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/08/1995 12:00:00 AM 12 3X3   6009340.5816959 2111773.3907707 37.7790543166113 -122.411258449881 (37.7790543166113, -122.411258449881) 8 2 9 28853 34
1280 191487 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 288 07th St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6010205.79697 2110974.44372 37.7769090816273 -122.408208942312 (37.7769090816273, -122.408208942312) 8 2 9 28853 34
1381 84767 Permitted Site 7 Tree(s) :: 17 185 Berry St 13 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2007 12:00:00 AM     Permit No. 49299 6014606 2110554 37.7760000408576 -122.392957754299 (37.7760000408576, -122.392957754299) 6 2 9 28856 20
1390 33763 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1580 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/23/1996 12:00:00 AM     Permit Number 37815 6007223.30298499 2109757.94023834 37.7734013999863 -122.418440043785 (37.7734013999863, -122.418440043785) 8 2 9 28853 19
1391 71539 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 277 Shipley St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6011318.23655 2111544.70179 37.7785371054488 -122.40440080265 (37.7785371054488, -122.40440080265) 14 2 9 28856 34
1442 103437 Undocumented 4 Podocarpus henkelii :: Long-Leafed Yellow-Wood 187 50X Bluxome St 14 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
1449 13614 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 555 Market St 12 Sidewalk: Curb side : Cutout Tree DPW 1     45 4X4   6012641.55561 2115729.4469 37.7901013041673 -122.400116879409 (37.7901013041673, -122.400116879409) 12 2 9 28855 6
1453 23301 DPW Maintained 1 Eucalyptus melliodora :: Yellow Box 188 950X Van Ness Ave 2 Median : Cutout Tree DPW 1     30 9   6006575.9602707 2113798.8129121 37.7844601942992 -122.420966256023 (37.7844601942992, -122.420966256023) 7 9 9 28858 36
1467 259815 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 9 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
1478 242990 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1330 Stevenson St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 5x2.5   6006256.26412 2108953.61059 37.7711384171253 -122.421728032423 (37.7711384171253, -122.421728032423) 8 2 9 28853 19
1488 202330 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 301 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2019 12:00:00 AM 3 Width 5ft   6013774.7833 2115928.84741 37.7907119312625 -122.396209955548 (37.7907119312625, -122.396209955548) 12 2 9 28855 6
1496 103826 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 1000 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2009 12:00:00 AM 3 3x3   6006957.18445 2114384.03926 37.7860885642674 -122.419688886254 (37.7860885642674, -122.419688886254) 13 9 9 28858 36
1501 27903 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 280 The Embarcadero 33 Sidewalk: Curb side : Cutout Tree Port 6   01/31/2001 12:00:00 AM 12     6015937.152 2112771.705 37.7821632154212 -122.388507741674 (37.7821632154212, -122.388507741674) 6 2 9 28856 6
1509 78622 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 535 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6008370.1442 2114331.41346 37.7860235585803 -122.414796682248 (37.7860235585803, -122.414796682248) 13 10 9 28858 36
1524 28207 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 300X King St 13 Sidewalk: Curb side : Cutout Tree DPW 1     12     6014268.5967781 2110706.0699128 37.7763988431969 -122.394135578218 (37.7763988431969, -122.394135578218) 6 2 9 28856 20
1534 28217 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 300X King St 23 Sidewalk: Curb side : Cutout Tree DPW 1     12     6014268.5967781 2110706.0699128 37.7763988431969 -122.394135578218 (37.7763988431969, -122.394135578218) 6 2 9 28856 20
1580 31821 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 195 07th St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM 4   Permit Number 35284 6009820.27489 2111475.42861 37.7782630739317 -122.409577954154 (37.7782630739317, -122.409577954154) 14 2 9 28853 34
1582 51483 DPW Maintained 1 Koelreuteria paniculata :: Golden Rain Tree 131 235 Berry St 1 Sidewalk: Curb side : Cutout Tree Private 2     9   Permit Number 47794 6014118.18221 2110089.57063 37.774697713467 -122.39461272721 (37.774697713467, -122.39461272721) 6 2 9 310 20
1597 190959 DPW Maintained 1 Cupaniopsis anacardioides :: Carrotwood 195 580 07th St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6011525.3711 2109592.00933 37.773187034992 -122.403546820846 (37.773187034992, -122.403546820846) 14 2 9 28853 34
1649 92526 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 275 10th St 4 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2009 12:00:00 AM   3x3 Permit Number 52874 6008743 2109634 37.7731465224788 -122.413174412357 (37.7731465224788, -122.413174412357) 8 2 9 28853 34
1683 85790 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1125 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/07/2007 12:00:00 AM 3 3x3   6010146.2096 2110708.8868 37.776176587646 -122.408396338404 (37.776176587646, -122.408396338404) 8 2 9 28853 34
1693 70072 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 460-462 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     6014075.24964 2112803.80145 37.7821479895867 -122.394951382198 (37.7821479895867, -122.394951382198) 6 2 9 28856 6
1724 134353 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 826 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6006643.13761 2113330.8233 37.7831789957579 -122.420700610947 (37.7831789957579, -122.420700610947) 7 9 9 28858 36
1735 28503 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 270 06th St 6 Sidewalk: Curb side : Cutout Tree DPW 1   09/13/2013 12:00:00 AM 3 3x3   6010824.2979387 2111653.7211901 37.7788088323978 -122.406117215604 (37.7788088323978, -122.406117215604) 14 2 9 28853 34
1754 72457 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 539 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     6013447.28917 2112118.8251 37.7802322636443 -122.397075813805 (37.7802322636443, -122.397075813805) 6 2 9 28856 34
1761 193283 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1628 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007524.2032 2108954.2313 37.7712115401103 -122.417342217788 (37.7712115401103, -122.417342217788) 8 2 9 28853 19

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);