trees
163,064 rows where qCaretaker_id = 2 sorted by Supervisor Districts descending
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );