Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 340 | 340 | 191854 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 573 10th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 24 | Width 6ft | tree is in ROW therefore DPW maintained | 6009977.72395 | 2108375.30106 | 37.7697596664942 | -122.408814503513 | (37.7697596664942, -122.408814503513) | ||
| 83526 | 83526 | 86829 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 258 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/13/2009 12:00:00 AM | 3 | 3x3 | privately planted on DPW street; unpermitted | 6002882.169263 | 2106798.606637 | 37.765030457224704 | -122.43324512978701 | (37.7650304572247, -122.433245129787) | |
| 124310 | 124310 | 16684 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 262 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/1998 12:00:00 AM | 3 | 4x4 | privately planted on DPW street; unpermitted | 6002878.0000942005 | 2106783.4724173998 | 37.7649886658228 | -122.4332584684 | (37.7649886658228, -122.4332584684) | |
| 21175 | 21175 | 5356 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 220 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/2015 03:17:00 PM | 3 | 6x6 | posted for removal 3/27/14 DPW | 6004796.958190001 | 2107043.90776 | 37.765812433218706 | -122.426639815582 | (37.7658124332187, -122.426639815582) | |
| 110767 | 110767 | 110456 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 200X Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | next to cross walk | 5998971.779069999 | 2112109.89902 | 37.7793913048339 | -122.44715241864401 | (37.7793913048339, -122.447152418644) | |||
| 3514 | 3514 | 21564 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1450 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 4X4 | dead | 6005645.68769 | 2114853.19648 | 37.787302788433706 | -122.424259698627 | (37.7873027884337, -122.424259698627) | ||
| 97454 | 97454 | 105000 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 280X SAN MARCOS AVE | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 65 | Tree tag no. 416 | 5993063.2 | 2100277.9 | 37.7465643757171 | -122.466732187112 | (37.7465643757171, -122.466732187112) | |||
| 128507 | 128507 | 110558 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1X Otis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Tree is at very corner of Otis and Mission; at 12 St and S Van Ness Intersection | 6007165.9 | 2109609.0 | 37.7729892139286 | -122.418628045346 | (37.7729892139286, -122.418628045346) | |||
| 141034 | 141034 | 4148 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3631 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1999 12:00:00 AM | 3 | 3X3 | She would like to be kept in the loop on what happens with this. | 6006082.4281665 | 2100506.5376626 | 37.7479349243864 | -122.421729258843 | (37.7479349243864, -122.421729258843) | |
| 94652 | 94652 | 86601 | DPW Maintained 3 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 254 | 1728 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/10/2011 12:00:00 AM | 3 | 3x3 | Replant with Acer rubrum 'Red Sunset' | 6009458.0 | 2106735.0 | 37.7652266534479 | -122.410496377801 | (37.7652266534479, -122.410496377801) | |
| 32070 | 32070 | 18941 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2782 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | Replace with P. Undulatum | 6001522.42549 | 2115673.82967 | 37.7893223527794 | -122.438584108286 | (37.7893223527794, -122.438584108286) | ||
| 125987 | 125987 | 93051 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1555X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/09/2010 12:00:00 AM | 3 | 3x3 | Planted for DPW by FUF | 6015509.3 | 2098161.9 | 37.7420241196322 | -122.388967590374 | (37.7420241196322, -122.388967590374) | |
| 82560 | 82560 | 93052 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1555X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/09/2010 12:00:00 AM | 3 | 3x3 | Planted by FUF for BUF | 6015509.3 | 2098161.9 | 37.7420241196322 | -122.388967590374 | (37.7420241196322, -122.388967590374) | |
| 5174 | 5174 | 27604 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780706 | 6003185.1314 | 2111389.5656 | 37.7776532852192 | -122.43252520607 | (37.7776532852192, -122.43252520607) | |
| 5175 | 5175 | 27606 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780706 | 6003145.1713 | 2111385.063 | 37.7776386560762 | -122.43266311980801 | (37.7776386560762, -122.432663119808) | |
| 2876 | 2876 | 10595 | DPW Maintained 3 | Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 152 | 1098 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 38 | 3X3 | Permit Number 780455 | 6010831.5223199995 | 2110575.81704 | 37.7758495624369 | -122.40601626744801 | (37.7758495624369, -122.406016267448) | ||
| 2891 | 2891 | 10596 | DPW Maintained 3 | Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 152 | 1098 Harrison St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | Permit Number 780455 | 6010813.59233 | 2110557.81798 | 37.775799138353705 | -122.406077023861 | (37.7757991383537, -122.406077023861) | ||
| 2268 | 2268 | 4983 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5300 Diamond Heights Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/10/2017 12:00:00 AM | 3 | 3X3 | Permit Number 780192 | 6001475.6363 | 2098933.58975 | 37.7433551224547 | -122.43754668724199 | (37.7433551224547, -122.437546687242) | |
| 3319 | 3319 | 4982 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5300 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/31/2017 12:00:00 AM | 3 | 3X3 | Permit Number 780192 | 6001462.73007 | 2098944.10019 | 37.743383247851604 | -122.437592066128 | (37.7433832478516, -122.437592066128) | |
| 2769 | 2769 | 17844 | DPW Maintained 3 | Tree(s) :: 17 | 2064 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/03/2017 12:00:00 AM | 3 | 3X3 | Permit Number 780190 | 6004071.9084 | 2115331.7333 | 37.7885277407175 | -122.429738786656 | (37.7885277407175, -122.429738786656) | |
| 3063 | 3063 | 13736 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 780155 | 6010795.99203 | 2114077.5984099996 | 37.785462646015894 | -122.40638597245399 | (37.7854626460159, -122.406385972454) | ||
| 3066 | 3066 | 13737 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | Permit Number 780155 | 6010751.43772 | 2114034.04518 | 37.7853405666668 | -122.40653704776001 | (37.7853405666668, -122.40653704776) | ||
| 3498 | 3498 | 200857 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1117 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 0ft | Permit Number 780155 | 6008905.5117 | 2112149.5313 | 37.7800626991558 | -122.412790138104 | (37.7800626991558, -122.412790138104) | ||
| 3500 | 3500 | 13943 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1101 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Permit Number 780155 | 6008953.3362 | 2112197.3558 | 37.780196698058894 | -122.412628072717 | (37.7801966980589, -122.412628072717) | |||
| 3507 | 3507 | 200856 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1117 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 0ft | Permit Number 780155 | 6008896.2254 | 2112159.7462 | 37.7800902256084 | -122.412822986117 | (37.7800902256084, -122.412822986117) | ||
| 3515 | 3515 | 13941 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1101 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 780155 | 6008943.5856 | 2112207.5707 | 37.780224198497294 | -122.412662526962 | (37.7802241984973, -122.412662526962) | ||
| 1336 | 1336 | 7171 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003475.9145 | 2111120.5411 | 37.7769310959731 | -122.431500078765 | (37.7769310959731, -122.431500078765) | ||
| 1340 | 1340 | 7172 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003478.683999999 | 2111101.7087 | 37.7768795438362 | -122.43148915347099 | (37.7768795438362, -122.431489153471) | ||
| 1343 | 1343 | 7169 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003470.3756 | 2111160.9753 | 37.777041804334296 | -122.43152212680799 | (37.7770418043343, -122.431522126808) | ||
| 1345 | 1345 | 7170 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003473.1451 | 2111141.589 | 37.776988731328295 | -122.43151116193 | (37.7769887313283, -122.43151116193) | ||
| 1383 | 1383 | 26841 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 100 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | Permit Number 779930 | 6006975.88726 | 2110943.04151 | 37.7766414730488 | -122.419379980819 | (37.7766414730488, -122.419379980819) | ||
| 456 | 456 | 23112 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1448 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/1992 12:00:00 AM | 20 | 3X3 | Permit Number 779902 | 6006436.396269999 | 2101132.22455 | 37.74967287242389 | -122.42054965793899 | (37.7496728724239, -122.420549657939) | |
| 449 | 449 | 200971 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1408 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | Width 0ft | Permit Number 779898 | 6007408.8361 | 2110843.7597 | 37.7763932439775 | -122.417875241075 | (37.7763932439775, -122.417875241075) | ||
| 477 | 477 | 14079 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1420 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 779898 | 6007326.0633 | 2110762.9345 | 37.7761666587056 | -122.418155844592 | (37.7761666587056, -122.418155844592) | ||
| 480 | 480 | 200973 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1416 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 0ft | Permit Number 779898 | 6007323.0 | 2110807.0 | 37.7762874795996 | -122.41816956622401 | (37.7762874795996, -122.418169566224) | ||
| 489 | 489 | 200974 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1422 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 0ft | Permit Number 779898 | 6007323.0 | 2110807.0 | 37.7762874795996 | -122.41816956622401 | (37.7762874795996, -122.418169566224) | ||
| 453 | 453 | 200966 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1438 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | Permit Number 779897 | 6007276.3996 | 2110716.1923 | 37.776035520315205 | -122.418324330264 | (37.7760355203152, -122.418324330264) | ||
| 481 | 481 | 14087 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1446 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 779892 | 6007224.7884 | 2110663.6072 | 37.775888228839705 | -122.418499137854 | (37.7758882288397, -122.418499137854) | ||
| 493 | 493 | 14089 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1446X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | Permit Number 779892 | 6007243.2905 | 2110686.0046 | 37.7759507683181 | -122.418436722662 | (37.7759507683181, -122.418436722662) | ||
| 494 | 494 | 14085 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1446 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 779892 | 6007257.8975 | 2110700.6115 | 37.775991697649104 | -122.418387229062 | (37.7759916976491, -122.418387229062) | ||
| 2050 | 2050 | 252861 | DPW Maintained 3 | Tree(s) :: 17 | 988 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779759 | 6010589.4479 | 2112082.95565 | 37.7799742710855 | -122.40695991983 | (37.7799742710855, -122.40695991983) | |
| 4833 | 4833 | 4457 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1408 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/2017 12:00:00 AM | 3 | 3X3 | Permit Number 779671 | 6004499.90701 | 2100635.94447 | 37.748200878269294 | -122.42721076637599 | (37.7482008782693, -122.427210766376) | |
| 2364 | 2364 | 192162 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1500 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 29 | Width 5ft | Permit Number 779453 | 6007414.0762 | 2109937.75552 | 37.7739058675964 | -122.417792878858 | (37.7739058675964, -122.417792878858) | ||
| 2416 | 2416 | 192163 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1500 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 29 | Width 5ft | Permit Number 779453 | 6007335.7591 | 2109863.52425 | 37.7736976385647 | -122.41805852779 | (37.7736976385647, -122.41805852779) | ||
| 2426 | 2426 | 192160 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1500 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | Width 3ft | Permit Number 779453 | 6007491.12658 | 2110012.65001 | 37.774115845790796 | -122.41753165726699 | (37.7741158457908, -122.417531657267) | ||
| 2442 | 2442 | 192161 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1500 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 32 | Width 5ft | Permit Number 779453 | 6007448.619659999 | 2109968.2743599997 | 37.7739916089565 | -122.417675550588 | (37.7739916089565, -122.417675550588) | ||
| 2449 | 2449 | 192165 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1500 Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/30/2008 12:00:00 AM | 29 | Width 4ft | Permit Number 779453 | 6007288.76075 | 2109818.60353 | 37.7735716516336 | -122.418217917334 | (37.7735716516336, -122.418217917334) | |
| 2467 | 2467 | 192164 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1500 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | Width 5ft | Permit Number 779453 | 6007314.84465 | 2109842.28548 | 37.7736381448041 | -122.418129368272 | (37.7736381448041, -122.418129368272) | ||
| 1986 | 1986 | 251131 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 354 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 02/14/2014 12:00:00 AM | 3x3 | Permit Number 779305 | 6011875.0 | 2111882.0 | 37.779494345884295 | -122.402498458881 | (37.7794943458843, -122.402498458881) | |
| 1997 | 1997 | 28906 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 354 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2014 12:00:00 AM | 5 | 3X3 | Permit Number 779305 | 6011835.68516 | 2111895.24936 | 37.779528530663704 | -122.402635398413 | (37.7795285306637, -122.402635398413) | |
| 9039 | 9039 | 27385 | DPW Maintained 3 | Tree(s) :: 17 | 2200 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/07/2016 12:00:00 AM | 3 | 3X3 | Permit Number 779236 | 6007159.916809999 | 2119895.6354400003 | 37.8012334551161 | -122.419378628241 | (37.8012334551161, -122.419378628241) | |
| 9042 | 9042 | 27384 | DPW Maintained 3 | Tree(s) :: 17 | 2200 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | Permit Number 779236 | 6007162.48532 | 2119880.42159 | 37.801191826388504 | -122.41936866015101 | (37.8011918263885, -122.419368660151) | ||
| 100739 | 100739 | 14097 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 1455 Market St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/23/2016 12:00:00 AM | 3 | 4X4 | Permit Number 778907 | 6007200.0 | 2110540.0 | 37.7755474375327 | -122.41857612030898 | (37.7755474375327, -122.418576120309) | |
| 1918 | 1918 | 251819 | DPW Maintained 3 | Acer macrophyllum :: Big Leaf Maple 159 | 298X Corbett Ave | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 3x3 | Permit Number 778898 | 5999572.0 | 2105342.0 | 37.7608426398345 | -122.444589445505 | (37.7608426398345, -122.444589445505) | |||
| 100045 | 100045 | 120550 | DPW Maintained 3 | Acer macrophyllum :: Big Leaf Maple 159 | 298x Corbett Ave | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 10 | Permit Number 778898 | 5999572.0 | 2105342.0 | 37.7608426398345 | -122.444589445505 | (37.7608426398345, -122.444589445505) | |||
| 123028 | 123028 | 18540 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 60 Quartz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 2x2 | Permit Number 778371 | 5999060.658518599 | 2099832.0947892 | 37.745684600557794 | -122.445961639207 | (37.7456846005578, -122.445961639207) | ||
| 1990 | 1990 | 123760 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 201 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/14/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 778327 | 5994952.60534 | 2110751.23907 | 37.7754303235309 | -122.460957832773 | (37.7754303235309, -122.460957832773) | |
| 15461 | 15461 | 109908 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1401 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/18/2015 02:04:00 PM | 3 | 3x3 | Permit Number 778313 | 6008340.42119 | 2109862.66125 | 37.773751763372395 | -122.414583173274 | (37.7737517633724, -122.414583173274) | |
| 10234 | 10234 | 122682 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/03/2017 12:00:00 AM | 3 | 6x10 | Permit Number 778226 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | |
| 102473 | 102473 | 95360 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 12 | 3x3 | Permit Number 778058 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | |
| 111421 | 111421 | 95362 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 3x3 | Permit Number 778058 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | ||
| 112944 | 112944 | 95359 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 12 | 3x3 | Permit Number 778058 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | |
| 114297 | 114297 | 95361 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 10 | 3x3 | Permit Number 778058 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | |
| 118079 | 118079 | 95358 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 25 | 3x3 | Permit Number 778058 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | |
| 95178 | 95178 | 4254 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 4079 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/2016 12:00:00 AM | 3 | 3X3 | Permit Number 777901 | 6003404.066852901 | 2100364.8685588003 | 37.747394534256394 | -122.430980801713 | (37.7473945342564, -122.430980801713) | |
| 96458 | 96458 | 116067 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 4150X CLEMENT ST | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777818 | 5983115.0 | 2113126.0 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | |
| 13462 | 13462 | 15276 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1563X Mission St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/28/2016 12:00:00 AM | 3 | Permit Number 777705 | 6007259.7778199995 | 2109715.95764 | 37.7732881790271 | -122.41831089463699 | (37.7732881790271, -122.418310894637) | ||
| 16543 | 16543 | 15277 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1563X Mission St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/28/2016 12:00:00 AM | 3 | 4X4 | Permit Number 777705 | 6007250.560819999 | 2109703.40074 | 37.7732531819334 | -122.418341887077 | (37.7732531819334, -122.418341887077) | |
| 10388 | 10388 | 2288 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989397.47374 | 2088680.9253 | 37.714509804868605 | -122.47855980688699 | (37.7145098048686, -122.478559806887) | |
| 10549 | 10549 | 2290 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X Brotherhood Way | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989540.89128 | 2088682.16282 | 37.714521528411495 | -122.478064194121 | (37.7145215284115, -122.478064194121) | |
| 10721 | 10721 | 2286 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989102.32398 | 2088689.12288 | 37.714515172905294 | -122.4795805509 | (37.7145151729053, -122.4795805509) | |
| 11963 | 11963 | 2289 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X Brotherhood Way | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989454.26944 | 2088678.0808599999 | 37.7145052920719 | -122.478363292437 | (37.7145052920719, -122.478363292437) | |
| 12203 | 12203 | 2287 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X Brotherhood Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989126.18342 | 2088688.6181299998 | 37.7145151729252 | -122.47949804711 | (37.7145151729252, -122.47949804711) | |
| 22766 | 22766 | 9009 | DPW Maintained 3 | Tree(s) :: 17 | 5255 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/27/2016 12:00:00 AM | 3 | 4X4 | Permit Number 777115 | 5990680.0267 | 2112634.9623 | 37.7803557304658 | -122.47587513459999 | (37.7803557304658, -122.4758751346) | |
| 2634 | 2634 | 7336 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2100 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/22/2016 12:00:00 AM | 3 | 3X3 | Permit Number 777018 | 6002905.15105 | 2115557.99031 | 37.789082847149 | -122.43379176139601 | (37.789082847149, -122.433791761396) | |
| 5405 | 5405 | 24573 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2100 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/22/2016 12:00:00 AM | 3 | 3X3 | Permit Number 777018 | 6002899.36519 | 2115591.06429 | 37.789173331540006 | -122.43381414462799 | (37.78917333154, -122.433814144628) | |
| 138704 | 138704 | 91592 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 590 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 5 | 3x3 | Permit Number 776895 | 6007446.6064019995 | 2106234.50211 | 37.7637394360724 | -122.41741785273899 | (37.7637394360724, -122.417417852739) | ||
| 91114 | 91114 | 90656 | DPW Maintained 3 | Tree(s) :: 17 | 3450 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 12/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776853 | 5984933.7362440005 | 2110433.593284 | 37.7739765609982 | -122.495591517296 | (37.7739765609982, -122.495591517296) |
| 113762 | 113762 | 90657 | DPW Maintained 3 | Tree(s) :: 17 | 3450 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 12/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776853 | 5984933.7362440005 | 2110433.593284 | 37.7739765609982 | -122.495591517296 | (37.7739765609982, -122.495591517296) |
| 14868 | 14868 | 28521 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 363 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | Permit Number 776437 | 6011229.90589 | 2111312.4766599997 | 37.777894532647 | -122.40469002104601 | (37.777894532647, -122.404690021046) | ||
| 15874 | 15874 | 28520 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 363 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | Permit Number 776437 | 6011243.37931 | 2111294.78009 | 37.7778466950054 | -122.40464216540899 | (37.7778466950054, -122.404642165409) | ||
| 16549 | 16549 | 28519 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 363 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | Permit Number 776437 | 6011256.2125 | 2111285.60514 | 37.777822219954295 | -122.404597124655 | (37.7778222199543, -122.404597124655) | ||
| 127336 | 127336 | 23686 | DPW Maintained 3 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 332 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/29/2016 12:00:00 AM | 3 | 3X3 | Permit Number 776287 | 6006868.2665484 | 2098036.0093442 | 37.741195691996296 | -122.418836670708 | (37.7411956919963, -122.418836670708) | |
| 17186 | 17186 | 1368 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 33 Amethyst Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | Permit Number 776000 | 5999092.87122 | 2100014.72745 | 37.746187905058896 | -122.445863385507 | (37.7461879050589, -122.445863385507) | ||
| 21467 | 21467 | 1367 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 33 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | Permit Number 776000 | 5999068.70954 | 2100015.2299099998 | 37.7461879050483 | -122.445946969396 | (37.7461879050483, -122.445946969396) | ||
| 87987 | 87987 | 90154 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 638 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/01/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775919 | 5993572.64081 | 2111433.85169 | 37.7772250922406 | -122.465781024081 | (37.7772250922406, -122.465781024081) | |
| 13040 | 13040 | 86402 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1715 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | Permit Number 775346 | 5988092.6268 | 2103602.7043 | 37.7554052860025 | -122.484163468892 | (37.7554052860025, -122.484163468892) | |
| 945 | 945 | 26844 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | Permit Number 775213 | 6006969.72882 | 2110998.7322 | 37.7767940394414 | -122.419405236481 | (37.7767940394414, -122.419405236481) | ||
| 5454 | 5454 | 26842 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | Permit Number 775213 | 6006970.057999999 | 2110963.93279 | 37.7766985071661 | -122.419401628405 | (37.7766985071661, -122.419401628405) | ||
| 5579 | 5579 | 26845 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | Permit Number 775213 | 6006964.16578 | 2111032.6003799997 | 37.776886719994295 | -122.41942688403799 | (37.7768867199943, -122.419426884038) | ||
| 7883 | 7883 | 26843 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | Permit Number 775213 | 6006968.35618 | 2110982.6622 | 37.7767498377733 | -122.419408844544 | (37.7767498377733, -122.419408844544) | ||
| 101817 | 101817 | 26840 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 100 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/03/2014 12:00:00 AM | 3 | 3X3 | Permit Number 775213 | 6006995.01563 | 2110975.40829 | 37.776731421778706 | -122.41931610666599 | (37.7767314217787, -122.419316106666) | |
| 103791 | 103791 | 26839 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 100 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 775213 | 6006995.01563 | 2110975.40829 | 37.776731421778706 | -122.41931610666599 | (37.7767314217787, -122.419316106666) | |
| 14295 | 14295 | 28861 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 386 01st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2006 12:00:00 AM | 3 | 3x3 | Permit Number 775014 | 6014571.110280001 | 2114290.34716 | 37.78625726449361 | -122.39333997428699 | (37.7862572644936, -122.393339974287) | |
| 119887 | 119887 | 91796 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 500x Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | Permit Number 775014 | 6014662.1325 | 2114223.547757 | 37.786078905224706 | -122.39302038306002 | (37.7860789052247, -122.39302038306) | |
| 22266 | 22266 | 17051 | DPW Maintained 3 | Tristania conferta :: 79 | 1235 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774567 | 6001055.3761 | 2109653.1693 | 37.7727645748724 | -122.43976821361 | (37.7727645748724, -122.43976821361) | |
| 82263 | 82263 | 1462 | DPW Maintained 3 | Acer x freemanii :: Freeman Maple 265 | 182 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/2009 12:00:00 AM | 3 | 3X3 | Permit Number 774484 | 5995551.94489 | 2114937.12028 | 37.786958106056396 | -122.459187767204 | (37.7869581060564, -122.459187767204) | |
| 103678 | 103678 | 108035 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 945 Market St | unknown : Cutout 12 | Tree 1 | DPW 2 | 3x3 | Permit Number 774370 | 6010085.9126699995 | 2113154.0076 | 37.782886937251796 | -122.408777465126 | (37.7828869372518, -122.408777465126) | ||||
| 17358 | 17358 | 4165 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3770 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2016 12:00:00 AM | 3 | 3X3 | Permit Number 774303 | 6005421.09901 | 2100523.30385 | 37.747943645176704 | -122.424017300779 | (37.7479436451767, -122.424017300779) | |
| 89354 | 89354 | 111589 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | Permit Number 774260 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) |
JSON shape: default, array, newline-delimited
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");