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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 99953 | 99953 | 117254 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 2067 33RD AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5985987.0 | 2101171.0 | 37.7486056682842 | -122.49126630479601 | (37.7486056682842, -122.491266304796) | ||||
| 128066 | 128066 | 98503 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 208 Glenview Dr | Back Yard : Yard 13 | Tree 1 | Private 1 | 5998871.0 | 2100779.0 | 37.74827374071911 | -122.44668556582701 | (37.7482737407191, -122.446685565827) | ||||||
| 125346 | 125346 | 100148 | Property Tree 7 | Tree(s) :: 17 | 209 Vicksburg St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6004141.0 | 2102142.0 | 37.7523158521071 | -122.428559192815 | (37.7523158521071, -122.428559192815) | ||||||
| 126465 | 126465 | 101951 | Property Tree 7 | Tree(s) :: 17 | 21 Lyell St | unknown : Yard 19 | Tree 1 | Private 1 | 6003106.0 | 2094969.0 | 37.7325618289587 | -122.43162632292 | (37.7325618289587, -122.43162632292) | ||||||
| 124250 | 124250 | 99374 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 21 Panorama Dr | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | 5998009.0 | 2100230.0 | 37.7467170430405 | -122.449626769288 | (37.7467170430405, -122.449626769288) | |||||
| 94734 | 94734 | 98893 | Property Tree 7 | Tree(s) :: 17 | 216 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998910.0 | 2100761.0 | 37.7482265448319 | -122.44654941060699 | (37.7482265448319, -122.446549410607) | ||||||
| 92228 | 92228 | 122453 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 217 San Marcos Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10x10 | 5993325.07095 | 2100296.14299 | 37.7466295758311 | -122.465827998209 | (37.7466295758311, -122.465827998209) | ||||
| 104184 | 104184 | 104318 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 22 Beaver St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6002763.0 | 2106816.0 | 37.765071454107996 | -122.433658549479 | (37.765071454108, -122.433658549479) | ||||
| 98291 | 98291 | 98892 | Property Tree 7 | Tree(s) :: 17 | 220 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998935.0 | 2100753.0 | 37.7482060067302 | -122.44646238623999 | (37.7482060067302, -122.44646238624) | ||||||
| 78509 | 78509 | 102745 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 222 Moncada Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992354.0 | 2093377.4 | 37.727576385896604 | -122.468682482409 | (37.7275763858966, -122.468682482409) | |||||
| 13321 | 13321 | 187670 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 230 Victoria St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5993274.0 | 2088748.0 | 37.7149182807441 | -122.465165952001 | (37.7149182807441, -122.465165952001) | ||||
| 98180 | 98180 | 120995 | Property Tree 7 | Private shrub :: Private Shrub 64 | 231 Delano Ave | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 3x3 | 6000066.0 | 2092260.0 | 37.72495076112679 | -122.44194193563999 | (37.7249507611268, -122.44194193564) | ||||
| 115357 | 115357 | 98501 | Property Tree 7 | Tree(s) :: 17 | 232 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998998.0 | 2100740.0 | 37.748173910048706 | -122.446243600021 | (37.7481739100487, -122.446243600021) | ||||||
| 12440 | 12440 | 100166 | Property Tree 7 | Salix spp :: Willow 218 | 2340 Twin Peaks Blvd | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 769026 | ||||||||||
| 105403 | 105403 | 105236 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 235X STATES ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 30 | 6001213.0 | 2106258.0 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | ||||
| 102061 | 102061 | 109092 | Property Tree 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 237 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773766 | 6004335.1 | 2099509.2 | 37.7450977767532 | -122.427700396282 | (37.7450977767532, -122.427700396282) |
| 103600 | 103600 | 98436 | Property Tree 7 | Tree(s) :: 17 | 238 Glenview Dr | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999035.0 | 2100736.0 | 37.7481650400364 | -122.446115368035 | (37.7481650400364, -122.446115368035) | ||||||
| 110958 | 110958 | 108680 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 240 SANTA ANA AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5992606.9 | 2095181.7 | 37.73254515275271 | -122.46793939448999 | (37.7325451527527, -122.46793939449) | |||||
| 80672 | 80672 | 98502 | Property Tree 7 | Tree(s) :: 17 | 244 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999066.0 | 2100737.0 | 37.7481695560511 | -122.44600824337601 | (37.7481695560511, -122.446008243376) | ||||||
| 142682 | 142682 | 102752 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 2452 Green St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001313.0 | 2117994.0 | 37.7956810212331 | -122.43947508164 | (37.7956810212331, -122.43947508164) | ||||||
| 110904 | 110904 | 109242 | Property Tree 7 | Private shrub :: Private Shrub 64 | 2479 DIAMOND ST | Sidewalk: Curb side : Yard 2 | Landscaping 2 | Private 1 | 6002238.1 | 2097343.7 | 37.7390329760373 | -122.434796615916 | (37.7390329760373, -122.434796615916) | ||||||
| 125761 | 125761 | 108576 | Property Tree 7 | :: 54 | 2479 Diamond St | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6002240.0 | 2097369.0 | 37.7391025518434 | -122.434791855338 | (37.7391025518434, -122.434791855338) | |||||
| 144179 | 144179 | 102639 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 251 Dorado Ter | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5994312.1 | 2092840.7 | 37.726215661035106 | -122.461874461465 | (37.7262156610351, -122.461874461465) | |||||
| 124150 | 124150 | 121198 | Property Tree 7 | Cordyline australis :: Dracena Palm 141 | 2521 18th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 3x3 | 5990743.0 | 2098231.0 | 37.740809941753 | -122.47460574514 | (37.740809941753, -122.47460574514) | |||
| 120579 | 120579 | 114365 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 2546 28th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 35 | 5987735.7 | 2097954.4 | 37.739875761389605 | -122.48498344199601 | (37.7398757613896, -122.484983441996) | ||||
| 99802 | 99802 | 98890 | Property Tree 7 | Tree(s) :: 17 | 256 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999134.0 | 2100748.0 | 37.748203642185395 | -122.44577389345 | (37.7482036421854, -122.44577389345) | ||||||
| 91108 | 91108 | 97177 | Property Tree 7 | Tree(s) :: 17 | 257 Roosevelt Way | Back Yard : Yard 13 | Tree 1 | Private 1 | Monterey cypress tree in backyard on private property; not a Significant tree | 6000848.1 | 2107127.9 | 37.765819014897296 | -122.44030407045099 | (37.7658190148973, -122.440304070451) | |||||
| 141038 | 141038 | 102381 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 258 Molimo Dr | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997615.0 | 2096604.0 | 37.7367383790998 | -122.450727783905 | (37.7367383790998, -122.450727783905) | ||||||
| 107492 | 107492 | 98715 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 26 Vernon St | Back Yard : Yard 13 | Tree 1 | Private 1 | 5992459.0 | 2088068.0 | 37.713004133171 | -122.46793347935301 | (37.713004133171, -122.467933479353) | ||||||
| 154560 | 154560 | 110181 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 2620 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 1.5x4 | 5999902.8272 | 2114053.62 | 37.784781414472704 | -122.444071244627 | (37.7847814144727, -122.444071244627) | |||
| 100224 | 100224 | 91109 | Property Tree 7 | Tree(s) :: 17 | 2650 Turk Blvd | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | On campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | ||||
| 103103 | 103103 | 91108 | Property Tree 7 | Tree(s) :: 17 | 2650 Turk Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | On campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | ||||
| 89166 | 89166 | 102275 | Property Tree 7 | Tree(s) :: 17 | 267 Topaz Way | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6001225.6 | 2097744.2 | 37.740075118911705 | -122.438326054857 | (37.7400751189117, -122.438326054857) | ||||||
| 101483 | 101483 | 113482 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 2839 Pierce St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001345.0 | 2118077.0 | 37.7959107386074 | -122.43937030854799 | (37.7959107386074, -122.439370308548) | ||||||
| 129310 | 129310 | 99268 | Property Tree 7 | Tree(s) :: 17 | 292 Whitney St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6004280.0 | 2096681.0 | 37.7373290690714 | -122.42768945491501 | (37.7373290690714, -122.427689454915) | ||||||
| 90230 | 90230 | 98140 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 315 San Marcos Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992920.8 | 2100212.1 | 37.746375486546704 | -122.467219803339 | (37.7463754865467, -122.467219803339) | ||||||
| 1273 | 1273 | 251481 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 32 Peralta Ave | 1 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 3x3 | 6010779.0 | 2100499.0 | 37.7481779538542 | -122.40548810426901 | (37.7481779538542, -122.405488104269) | ||||
| 124085 | 124085 | 116154 | Property Tree 7 | Pinus Spp :: Pine Spp 105 | 324 POPE ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6000502.0 | 2087202.0 | 37.711087470467795 | -122.440072212787 | (37.7110874704678, -122.440072212787) | ||||
| 78101 | 78101 | 96597 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 110024 | 110024 | 96606 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 111128 | 111128 | 96599 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 113186 | 113186 | 96604 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 113756 | 113756 | 96600 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 123910 | 123910 | 96598 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | tree 3 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 126860 | 126860 | 96602 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 128034 | 128034 | 96601 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 142264 | 142264 | 96605 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 144514 | 144514 | 96603 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 901 | 901 | 224716 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 5 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 13 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 903 | 903 | 225889 | Property Tree 7 | Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash 121 | 3255x 24th St | 7 | Back Yard : Cutout 16 | Tree 1 | MTA 6 | 18 | Width 8ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 905 | 905 | 224715 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 4 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 12 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 909 | 909 | 234895 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 3255x 24th St | 6 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 40 | Width 10ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 914 | 914 | 225888 | Property Tree 7 | Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash 121 | 3255x 24th St | 1 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 32 | 6x6 | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 916 | 916 | 224714 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 3 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 11 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 928 | 928 | 224422 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 2 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 16 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 77987 | 77987 | 100070 | Property Tree 7 | Tree(s) :: 17 | 331 Serrano Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 777990 | 5990400.0 | 2090718.0 | 37.7201612636948 | -122.47524333880699 | (37.7201612636948, -122.475243338807) | ||||
| 104891 | 104891 | 102101 | Property Tree 7 | Cordyline australis :: Dracena Palm 141 | 331 Vernon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2012 12:00:00 AM | 12 | 3x3 | Permit Number 769722 | 5992434.3 | 2090067.3 | 37.718492301183204 | -122.468164197766 | (37.7184923011832, -122.468164197766) |
| 145060 | 145060 | 102056 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 332 19th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5990007.7 | 2113121.3 | 37.781652074321705 | -122.47823656971501 | (37.7816520743217, -122.478236569715) | |||||
| 76017 | 76017 | 106971 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 3479X San Bruno Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6011510.60551 | 2091910.0343099998 | 37.7246353494236 | -122.402354399294 | (37.7246353494236, -122.402354399294) | ||||
| 109029 | 109029 | 108973 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 3485X SAN BRUNO AVE | 1 | Median : Yard 3 | Tree 1 | DPW for City Agency 10 | 6011510.0 | 2091910.0 | 37.724635221414 | -122.402356490066 | (37.724635221414, -122.402356490066) | |||||
| 109233 | 109233 | 104397 | Property Tree 7 | Pseudotsuga menziesii :: Douglas Fir 231 | 350 Collingwood St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002086.0 | 2103822.0 | 37.756812219827296 | -122.43578589078301 | (37.7568122198273, -122.435785890783) | |||||
| 98644 | 98644 | 106968 | Property Tree 7 | :: 54 | 351 26th Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | 5987720.26121 | 2113604.44601 | 37.7828456076198 | -122.48618540122601 | (37.7828456076198, -122.486185401226) | ||||||
| 117738 | 117738 | 104008 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 357 Collingwood St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | 6002124.0 | 2103789.0 | 37.7567237682266 | -122.435652112093 | (37.7567237682266, -122.435652112093) | ||||
| 108742 | 108742 | 110939 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 38 SAINT CHARLES AVE | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 30 | 3x3 | 5992046.0 | 2088201.0 | 37.7133454608488 | -122.46937060641001 | (37.7133454608488, -122.46937060641) | |||
| 105598 | 105598 | 106227 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 38 Stanford Heights Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997884.0 | 2095808.5 | 37.7345695210024 | -122.44974042873999 | (37.7345695210024, -122.44974042874) | |||||
| 105590 | 105590 | 121144 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 400 Franconia St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 3x3 | 6010016.0 | 2098808.0 | 37.743492145498294 | -122.40800731166901 | (37.7434921454983, -122.408007311669) | |||
| 11978 | 11978 | 112948 | Property Tree 7 | Ligustrum japonicum :: Japanese Privet 4 | 400 Pioche St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x15 | 6005670.66964 | 2093276.94718 | 37.7280608613968 | -122.42263943148599 | (37.7280608613968, -122.422639431486) | |||
| 1380 | 1380 | 251512 | Property Tree 7 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4116x 18th St | 1 | Back Yard : Yard 13 | Tree 1 | MTA 6 | 3x3 | 6002190.0 | 2105341.0 | 37.760988934022706 | -122.43553488468001 | (37.7609889340227, -122.43553488468) | ||||
| 86057 | 86057 | 94469 | Property Tree 7 | Cupressus sempervirens :: Italian Cypress 136 | 4128 17th St | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 103566 | 103566 | 94487 | Property Tree 7 | Cupressus sempervirens :: Italian Cypress 136 | 4128 17th St | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 126549 | 126549 | 94468 | Property Tree 7 | Cupressus sempervirens :: Italian Cypress 136 | 4128 17th St | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 115179 | 115179 | 106275 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 42 Stanford Heights Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997882.5 | 2095834.4 | 37.7346405503947 | -122.449747480555 | (37.7346405503947, -122.449747480555) | |||||
| 95068 | 95068 | 109091 | Property Tree 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 4235 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773805 | 6001611.4 | 2102294.1 | 37.7525900037408 | -122.43731782876002 | (37.7525900037408, -122.43731782876) |
| 82794 | 82794 | 110929 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 445 BEACON ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6002243.0 | 2098437.0 | 37.7420352018096 | -122.434857838675 | (37.7420352018096, -122.434857838675) | |||||
| 79535 | 79535 | 96590 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 81703 | 81703 | 96593 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 85657 | 85657 | 96591 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 97416 | 97416 | 96594 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 116314 | 116314 | 96592 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 121581 | 121581 | 96589 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 79751 | 79751 | 105231 | Property Tree 7 | Pinus Spp :: Pine Spp 105 | 460X ROOSEVELT WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6000051.0 | 2106345.0 | 37.7636239504047 | -122.44300483360901 | (37.7636239504047, -122.443004833609) | ||||
| 116035 | 116035 | 105232 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 460X ROOSEVELT WAY | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 5999944.0 | 2106286.0 | 37.7634558498539 | -122.443370673769 | (37.7634558498539, -122.443370673769) | ||||
| 112387 | 112387 | 109194 | Property Tree 7 | Quercus agrifolia :: Coast Live Oak 180 | 4705 03rd St | Back Yard : Yard 13 | Tree 1 | Arts Commission 19 | 45 | 6015121.6 | 2095617.0 | 37.7350148477359 | -122.39013039721901 | (37.7350148477359, -122.390130397219) | |||||
| 83931 | 83931 | 105169 | Property Tree 7 | Corymbia ficifolia :: Red Flowering Gum 60 | 4755X 03RD ST | 3 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 23 | 4x4 | 6015032.0 | 2095658.0 | 37.7351224553975 | -122.39044304267901 | (37.7351224553975, -122.390443042679) | |||
| 111891 | 111891 | 105167 | Property Tree 7 | Corymbia ficifolia :: Red Flowering Gum 60 | 4755X 03RD ST | 1 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 8 | 3x3 | 6015032.0 | 2095658.0 | 37.7351224553975 | -122.39044304267901 | (37.7351224553975, -122.390443042679) | |||
| 112389 | 112389 | 105171 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 4755X 03RD ST | 5 | Front Yard : Yard 7 | Tree 1 | Arts Commission 19 | 14 | 4x4 | 6015032.0 | 2095658.0 | 37.7351224553975 | -122.39044304267901 | (37.7351224553975, -122.390443042679) | |||
| 117969 | 117969 | 105170 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 4755X 03RD ST | 4 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 2 | 3x3 | 6015032.0 | 2095658.0 | 37.7351224553975 | -122.39044304267901 | (37.7351224553975, -122.390443042679) | |||
| 101635 | 101635 | 121104 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 477 Myra Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997298.0 | 2097021.0 | 37.7378652095891 | -122.45185385938998 | (37.7378652095891, -122.45185385939) | ||||
| 114652 | 114652 | 97162 | Property Tree 7 | Malus :: Crab Apple 235 | 478 10th Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | Tree in backyard on private property; not significant. | 5992861.5 | 2112216.7 | 37.7793335349967 | -122.468298031686 | (37.7793335349967, -122.468298031686) | |||||
| 92371 | 92371 | 118371 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 4808 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999981.0 | 2101110.0 | 37.7492459313263 | -122.44287099416799 | (37.7492459313263, -122.442870994168) | ||||
| 9474 | 9474 | 173600 | Property Tree 7 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Clarendon Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5996184.0 | 2102497.0 | 37.7528370823128 | -122.45610127186899 | (37.7528370823128, -122.456101271869) | ||||
| 87654 | 87654 | 99961 | Property Tree 7 | Callistemon citrinus :: Lemon Bottlebrush 28 | 537 Valley St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/25/2012 12:00:00 AM | Permit Number 768880 | 6002459.0 | 2099152.0 | 37.7440106863694 | -122.434162082356 | (37.7440106863694, -122.434162082356) | |||
| 74398 | 74398 | 97290 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 55 Hiliritas Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 778896 | 6001461.7 | 2096833.2 | 37.7375871516219 | -122.437444499981 | (37.7375871516219, -122.437444499981) | |||||
| 108286 | 108286 | 100045 | Property Tree 7 | Acacia decurrens :: Acacia: Silver Wattle 181 | 556 28th St | Front Yard : Yard 7 | Tree 1 | Private 1 | Not sure which property tree is located on. | 6002301.0 | 2099461.0 | 37.7448501592716 | -122.434730501666 | (37.7448501592716, -122.434730501666) | |||||
| 142266 | 142266 | 98139 | Property Tree 7 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 556 Laidley St | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6003085.0 | 2096041.0 | 37.7355041065287 | -122.431775438062 | (37.7355041065287, -122.431775438062) | |||||
| 90103 | 90103 | 100046 | Property Tree 7 | Tree(s) :: 17 | 562 28th St | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/28/2012 12:00:00 AM | 17 | Permit Number 769057 | 6002262.0 | 2099459.0 | 37.7448424535299 | -122.43486521318898 | (37.7448424535299, -122.434865213189) | |||
| 98218 | 98218 | 122480 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 596X Buckingham Way | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 3x3 | 5990152.0 | 2094375.0 | 37.7301880902761 | -122.476367577616 | (37.7301880902761, -122.476367577616) | ||||
| 13296 | 13296 | 187658 | Property Tree 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 600X Clarendon Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5995637.0 | 2102382.0 | 37.7524899085688 | -122.457984564932 | (37.7524899085688, -122.457984564932) | ||||
| 81246 | 81246 | 109097 | Property Tree 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 601 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774331 | 6002630.6 | 2098839.9 | 37.743163470374895 | -122.43354642924999 | (37.7431634703749, -122.43354642925) |
| 81073 | 81073 | 101977 | Property Tree 7 | Cedrus deodara :: Deodar Cedar 129 | 601 Grand View Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000076.2 | 2101609.9 | 37.750623962991796 | -122.44257767940901 | (37.7506239629918, -122.442577679409) |
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");