trees

163,064 rows where qCaretaker_id = 2 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1775 196240 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 477 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6010588.30864 2112340.27099 37.7806807348789 -122.406982002622 (37.7806807348789, -122.406982002622) 14 2 9 28853 34
1778 262558 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 1801 03rd St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
1791 202438 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 200 Brannan St 7 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6015393.28137 2113192.42013 37.7832882498865 -122.390418710082 (37.7832882498865, -122.390418710082) 6 2 9 28856 6
1800 189943 DPW Maintained 1 Ceratonia siliqua :: Carob 5 160 Spear St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6014663.90287 2116268.03372 37.7916926905231 -122.393157367813 (37.7916926905231, -122.393157367813) 12 2 9 28855 6
1892 124739 DPW Maintained 1 Tree(s) :: 17 999 Brannan St 8 Sidewalk: Curb side : Cutout Tree Private 2           6010535.71931722 2108464.76902983 37.7700365636667 -122.406890710328 (37.7700365636667, -122.406890710328) 14 2 9 28853 34
1893 202466 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 299 Bryant St 19 Sidewalk: Property side : Yard Tree Private 2     14 Width 3ft   6015364.08596 2113980.86874 37.7854515313193 -122.390574827864 (37.7854515313193, -122.390574827864) 6 2 9 28856 6
1939 81851 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 234X Eddy St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6009256.87157 2113623.19571 37.7841287454965 -122.411678774977 (37.7841287454965, -122.411678774977) 14 10 9 28852 36
1943 262553 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 1801 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
1962 122597 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 42X Colin P Kelly Jr St 5 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
1998 201212 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 698 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft Permit Number 770669 6012984.2928 2113511.8761 37.7840314756866 -122.398775334072 (37.7840314756866, -122.398775334072) 6 2 9 28853 6
2007 188784 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 499 Illinois St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 6ft   6015979.83831 2106803.95395 37.7657794514949 -122.387943506912 (37.7657794514949, -122.387943506912) 14 3 9 310 20
2016 134492 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 199 Fulton St 15 Sidewalk: Property side : Yard Tree Private 2     10 Width 4ft   6008187.17961 2111997.187 37.7796040530222 -122.415264393538 (37.7796040530222, -122.415264393538) 7 10 9 28852 36
2027 32641 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/17/1999 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
2072 259693 Undocumented 4 Maytenus boaria :: Mayten 58 30 Lafayette St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007347 2109367 37.7723349336637 -122.417984438142 (37.7723349336637, -122.417984438142) 8 2 9 28853 19
2094 262557 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 1801 03rd St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
2106 193374 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 778 Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6008975.96564 2110229.86919 37.7747957152898 -122.412410677425 (37.7747957152898, -122.412410677425) 8 2 9 28853 34
2135 187956 DPW Maintained 1 Acer rubrum :: Red Maple 75 340 Fremont St 7 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6014829.80215 2114536.31276 37.7869469986487 -122.392462171218 (37.7869469986487, -122.392462171218) 6 2 9 28855 6
2143 35031 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 403 Main St 8 Sidewalk: Curb side : Cutout Tree Private 2   01/05/1998 12:00:00 AM 16   Permit Number 38603 6015552.5764 2114910.07467 37.7880133742625 -122.389987634449 (37.7880133742625, -122.389987634449) 6 2 9 28855 6
2153 100644 Permitted Site 7 Tree(s) :: 17 401X Clementina St 14 Sidewalk: Curb side : Cutout Tree Private 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34

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)
);