Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 125644 | 125644 | 3784 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 35 Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/2014 10:43:00 AM | 3 | 3X4 | 6017319.3126468 | 2095790.6090322 | 37.735613192974704 | -122.382544123056 | (37.7356131929747, -122.382544123056) | ||
| 21779 | 21779 | 29598 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/31/2014 08:52:00 AM | 3 | 5991178.77498 | 2091110.6465200002 | 37.7212844823864 | -122.472580013151 | (37.7212844823864, -122.472580013151) | |||
| 16933 | 16933 | 26076 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 269 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5994312.4294 | 2088054.8516 | 37.7130748868127 | -122.461526506385 | (37.7130748868127, -122.461526506385) | ||
| 17492 | 17492 | 26073 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 285 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1997 12:00:00 AM | 8 | 3x3 | 5994159.2599 | 2088057.6707 | 37.7130738098987 | -122.462056111894 | (37.7130738098987, -122.462056111894) | ||
| 18540 | 18540 | 26342 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2630 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1997 12:00:00 AM | 6 | 3X3 | 5997363.52119 | 2088889.5746799998 | 37.715541990037295 | -122.451041118862 | (37.7155419900373, -122.451041118862) | ||
| 19329 | 19329 | 26084 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 145 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1997 12:00:00 AM | 11 | 3X3 | 5995430.1902 | 2088042.6356 | 37.713105618543 | -122.457662291956 | (37.713105618543, -122.457662291956) | ||
| 114152 | 114152 | 22339 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 5236 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1997 12:00:00 AM | 3 | 3X3 | 6014418.1916 | 2093832.59155 | 37.730076186176206 | -122.39243757764099 | (37.7300761861762, -122.392437577641) | ||
| 77627 | 77627 | 1693 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 26 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1996 12:00:00 AM | 3 | 3X3 | 6017694.7378197 | 2093654.8040294999 | 37.7297694248505 | -122.38109767205201 | (37.7297694248505, -122.381097672052) | ||
| 97591 | 97591 | 1700 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 43 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1996 12:00:00 AM | 6 | 3X3 | 6017768.2322395 | 2093598.2442303002 | 37.7296181792492 | -122.380839660676 | (37.7296181792492, -122.380839660676) | ||
| 15890 | 15890 | 17142 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1992 12:00:00 AM | 3 | 3X3 | 6017965.0245 | 2093314.7049599998 | 37.7288504949441 | -122.380139626367 | (37.7288504949441, -122.380139626367) | ||
| 99391 | 99391 | 17145 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1992 12:00:00 AM | 6 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.37983116682699 | (37.7286870123052, -122.379831166827) | ||
| 309 | 309 | 20164 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1155X Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1990 12:00:00 AM | 25 | 4X4 | 6002621.0 | 2112212.0 | 37.7798794773869 | -122.43453554599199 | (37.7798794773869, -122.434535545992) | ||
| 18067 | 18067 | 5516 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 839 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/30/2009 12:00:00 AM | 3 | 6X6 | 6005075.66356 | 2103479.99989 | 37.756042537557605 | -122.425422183901 | (37.7560425375576, -122.425422183901) | ||
| 126432 | 126432 | 26478 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 120 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/30/2009 12:00:00 AM | 3 | 3X3 | 6001175.6711954 | 2098684.4538551 | 37.7426539948984 | -122.438566040387 | (37.7426539948984, -122.438566040387) | ||
| 108970 | 108970 | 24041 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 66 Westbrook Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/30/1994 12:00:00 AM | 12 | 3X4 | 6017284.9951248 | 2095593.5314005 | 37.7350701611901 | -122.382649063918 | (37.7350701611901, -122.382649063918) | ||
| 14491 | 14491 | 15022 | DPW Maintained 3 | Hypelate trifoliata :: White ironwood 286 | 825 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/30/1992 12:00:00 AM | 18 | 3x3 | 6015991.79898 | 2096688.54395 | 37.7380053172864 | -122.387196501233 | (37.7380053172864, -122.387196501233) | ||
| 94981 | 94981 | 15024 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 845 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/30/1992 12:00:00 AM | 17 | 3X3 | 6015971.14204 | 2096622.00458 | 37.7378214697096 | -122.387263283018 | (37.7378214697096, -122.387263283018) | ||
| 120792 | 120792 | 1764 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2000X Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/30/1992 12:00:00 AM | 12 | 3X3 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | ||
| 11132 | 11132 | 1820 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/30/1991 12:00:00 AM | 3 | 6 | 6011846.03792 | 2087600.59079 | 37.7128212089973 | -122.400892211026 | (37.7128212089973, -122.400892211026) | ||
| 11580 | 11580 | 1821 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/30/1991 12:00:00 AM | 6 | 6 | 6011817.461569999 | 2087571.87835 | 37.712740776339295 | -122.400988964593 | (37.7127407763393, -122.400988964593) | ||
| 105433 | 105433 | 1786 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2001X Bay Shore Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/30/1991 12:00:00 AM | 6 | 3X3 | 6012442.836211099 | 2088493.8744970001 | 37.7153072596479 | -122.398892125343 | (37.7153072596479, -122.398892125343) | ||
| 116146 | 116146 | 1781 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2001X Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/30/1991 12:00:00 AM | 5 | 3x3 | 6012442.836211099 | 2088493.8744970001 | 37.7153072596479 | -122.398892125343 | (37.7153072596479, -122.398892125343) | ||
| 124235 | 124235 | 1780 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2001X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/30/1991 12:00:00 AM | 6 | 3X3 | 6012442.836211099 | 2088493.8744970001 | 37.7153072596479 | -122.398892125343 | (37.7153072596479, -122.398892125343) | ||
| 125100 | 125100 | 1818 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2100 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/30/1991 12:00:00 AM | 3 | 6 | 6012027.2003656 | 2087907.9406618 | 37.7136752340099 | -122.400287624748 | (37.7136752340099, -122.400287624748) | ||
| 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) | |
| 10410 | 10410 | 86450 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2362 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987982.1495 | 2099214.8079 | 37.7433508614418 | -122.4842237451 | (37.7433508614418, -122.4842237451) | ||
| 10519 | 10519 | 86446 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2426 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987996.8709 | 2098757.0924 | 37.742094952584296 | -122.484139283552 | (37.7420949525843, -122.484139283552) | ||
| 10928 | 10928 | 86448 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2410 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987993.1483 | 2098903.2906 | 37.7424961575573 | -122.484162874059 | (37.7424961575573, -122.484162874059) | ||
| 10961 | 10961 | 86453 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2330 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987973.3506 | 2099428.6905 | 37.74393761420671 | -122.48426985180201 | (37.7439376142067, -122.484269851802) | ||
| 10972 | 10972 | 86435 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2578 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988030.7572 | 2097759.3623 | 37.739357420836704 | -122.483948972283 | (37.7393574208367, -122.483948972283) | ||
| 11018 | 11018 | 86445 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2434 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987997.5477 | 2098724.6039 | 37.7420057871296 | -122.484134561433 | (37.7420057871296, -122.484134561433) | ||
| 11450 | 11450 | 86561 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1891 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987822.6937 | 2102437.7427 | 37.7521908954775 | -122.485011502397 | (37.7521908954775, -122.485011502397) | ||
| 11518 | 11518 | 86451 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2358 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987978.4269 | 2099245.2659 | 37.743434274314396 | -122.484238850005 | (37.7434342743144, -122.484238850005) | ||
| 11689 | 11689 | 86565 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2243 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987907.2026 | 2100032.4695 | 37.7455915795676 | -122.48454285152799 | (37.7455915795676, -122.484542851528) | ||
| 11712 | 11712 | 86567 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2307 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987921.2336 | 2099575.5655 | 37.744337859372294 | -122.484460828778 | (37.7443378593723, -122.484460828778) | ||
| 11820 | 11820 | 86568 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2337 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987926.9868 | 2099392.4793 | 37.7438354881374 | -122.484427509802 | (37.7438354881374, -122.484427509802) | ||
| 11838 | 11838 | 86566 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2291 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987915.7374 | 2099735.4596 | 37.7447765661609 | -122.484491558794 | (37.7447765661609, -122.484491558794) | ||
| 12029 | 12029 | 86454 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2326 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987972.3353 | 2099456.4411 | 37.744013750897295 | -122.48427539724199 | (37.7440137508973, -122.484275397242) | ||
| 12219 | 12219 | 86452 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2350 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987979.4422 | 2099298.3981 | 37.743580220411 | -122.48423923521099 | (37.743580220411, -122.484239235211) | ||
| 12481 | 12481 | 86449 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2370 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987981.4727 | 2099180.2889 | 37.743256041979606 | -122.48422355425699 | (37.7432560419796, -122.484223554257) | ||
| 12490 | 12490 | 86438 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2558 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988026.0275 | 2097893.3718 | 37.7397251004281 | -122.483975149426 | (37.7397251004281, -122.483975149426) | ||
| 12534 | 12534 | 86442 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2470 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988005.6699 | 2098496.5076 | 37.7413799676446 | -122.484089754678 | (37.7413799676446, -122.484089754678) | ||
| 12667 | 12667 | 86440 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2506 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988014.3608 | 2098206.7963 | 37.7405850025908 | -122.484038465173 | (37.7405850025908, -122.484038465173) | ||
| 12670 | 12670 | 86437 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2566 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988027.6041 | 2097846.7049 | 37.7395970571481 | -122.483966277165 | (37.7395970571481, -122.483966277165) | ||
| 12746 | 12746 | 86444 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2438 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988000.2551 | 2098696.1765 | 37.7419278906096 | -122.48412311600401 | (37.7419278906096, -122.484123116004) | ||
| 12867 | 12867 | 86434 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2590 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988032.3338 | 2097694.7224 | 37.7391800283996 | -122.48393878255 | (37.7391800283996, -122.48393878255) | ||
| 13118 | 13118 | 86439 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2550 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988024.4509 | 2097942.8764 | 37.7398609352841 | -122.48398422975 | (37.7398609352841, -122.48398422975) | ||
| 13167 | 13167 | 86441 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2498 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988007.7004 | 2098406.8258 | 37.7411338432365 | -122.484076158984 | (37.7411338432365, -122.484076158984) | ||
| 79532 | 79532 | 86562 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2207 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987900.988811 | 2100267.110901 | 37.746235480683 | -122.48458154567899 | (37.746235480683, -122.484581545679) | ||
| 92704 | 92704 | 86563 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2215 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987902.745463 | 2100215.048221 | 37.7460926326953 | -122.484571653291 | (37.7460926326953, -122.484571653291) | ||
| 97679 | 97679 | 86443 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2450 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987997.37774 | 2098622.10748 | 37.741724349066 | -122.484127634313 | (37.741724349066, -122.484127634313) | |
| 143250 | 143250 | 86436 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2574 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988026.00444 | 2097787.2202669997 | 37.7394336348182 | -122.48396744726001 | (37.7394336348182, -122.48396744726) | ||
| 19230 | 19230 | 23057 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1125 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1995 12:00:00 AM | 20 | 3X3 | 6006400.53773 | 2103001.31347 | 37.75480294082929 | -122.420806336166 | (37.7548029408293, -122.420806336166) | ||
| 21699 | 21699 | 23058 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1125 Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1995 12:00:00 AM | 3 | 3X3 | 6006398.20766 | 2103046.47398 | 37.754926809838096 | -122.420817600178 | (37.7549268098381, -122.420817600178) | ||
| 95581 | 95581 | 23060 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1130X Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1995 12:00:00 AM | 20 | 3X3 | 6006285.82184 | 2102960.15037 | 37.7546834499434 | -122.42120013326999 | (37.7546834499434, -122.42120013327) | ||
| 113363 | 113363 | 23096 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1387 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1995 12:00:00 AM | 20 | 3X3 | 6006465.03799 | 2101520.60096 | 37.7507408794773 | -122.420478177928 | (37.7507408794773, -122.420478177928) | ||
| 116687 | 116687 | 23059 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1130X Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1995 12:00:00 AM | 20 | 3X3 | 6006285.82184 | 2102960.15037 | 37.7546834499434 | -122.42120013326999 | (37.7546834499434, -122.42120013327) | ||
| 16309 | 16309 | 6731 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1992 12:00:00 AM | 6 | 3x3 | 6017098.09908 | 2097131.4743700002 | 37.7392827179327 | -122.38340226151699 | (37.7392827179327, -122.383402261517) | ||
| 16577 | 16577 | 6662 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1550 Evans Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1992 12:00:00 AM | 6 | 3X3 | 6016012.0516099995 | 2098330.17252 | 37.7425140162093 | -122.387240954701 | (37.7425140162093, -122.387240954701) | ||
| 23320 | 23320 | 6751 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1215 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1992 12:00:00 AM | 7 | 6017537.38126 | 2096718.5380000002 | 37.738173145164104 | -122.38185469014499 | (37.7381731451641, -122.381854690145) | |||
| 78861 | 78861 | 6767 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1275 Fairfax Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1992 12:00:00 AM | 12 | 3x3 | 6017284.4858800005 | 2096909.9197200001 | 37.738684672549205 | -122.38274239930401 | (37.7386846725492, -122.382742399304) | ||
| 14657 | 14657 | 12132 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1400X La Salle Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2016 05:53:00 AM | 3 | 3X3 | 6016426.995019999 | 2095242.04569 | 37.734057614557 | -122.385591017134 | (37.734057614557, -122.385591017134) | ||
| 19486 | 19486 | 10095 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 727 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2016 05:21:00 AM | 3 | 2X2 | 6005664.2360000005 | 2104708.85405 | 37.759449920391 | -122.423474060781 | (37.759449920391, -122.423474060781) | ||
| 9796 | 9796 | 11975 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2016 02:52:00 PM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
| 9774 | 9774 | 11891 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 610X Keith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2016 02:46:00 PM | 3 | 3X4 | 6017375.698266099 | 2096379.4784168 | 37.73723322563529 | -122.382390131809 | (37.7372332256353, -122.382390131809) | ||
| 9789 | 9789 | 91811 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2685 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2016 02:45:00 PM | 3 | 3x3 | 6008942.770855 | 2102838.050886 | 37.754497621185 | -122.412003022866 | (37.754497621185, -122.412003022866) | ||
| 9797 | 9797 | 26571 | DPW Maintained 3 | Ulmus 'Prospector' :: Prospector Elm 255 | 355 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2016 02:34:00 PM | 3 | 3X3 | 6010658.7520522 | 2098287.1955653 | 37.742098094898 | -122.40574814809999 | (37.742098094898, -122.4057481481) | ||
| 10379 | 10379 | 86560 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1887 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987821.2541 | 2102469.8936 | 37.7522790893532 | -122.48501883929899 | (37.7522790893532, -122.485018839299) | ||
| 10413 | 10413 | 86491 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1610 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987803.6185 | 2104298.7956 | 37.7572997330502 | -122.485214007697 | (37.7572997330502, -122.485214007697) | ||
| 10423 | 10423 | 86471 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1814 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 8 | 3x3 | 5987856.6219 | 2102916.0794 | 37.7535062555598 | -122.48492926433501 | (37.7535062555598, -122.484929264335) | ||
| 10430 | 10430 | 86483 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1706 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987833.1754 | 2103641.2255 | 37.7554959453769 | -122.48506354557101 | (37.7554959453769, -122.485063545571) | ||
| 10488 | 10488 | 86479 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1750 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987839.9732 | 2103389.1385 | 37.7548041785464 | -122.485021542908 | (37.7548041785464, -122.485021542908) | ||
| 10499 | 10499 | 86552 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1807 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987803.5941 | 2102964.5337 | 37.7536362092428 | -122.485116198466 | (37.7536362092428, -122.485116198466) | ||
| 10540 | 10540 | 86470 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1822 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987859.0288 | 2102867.5421 | 37.7533731253955 | -122.484917380259 | (37.7533731253955, -122.484917380259) | ||
| 10563 | 10563 | 86468 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1830 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 10 | 3x3 | 5987859.0288 | 2102813.3889 | 37.753224435288 | -122.484913407703 | (37.753224435288, -122.484913407703) | ||
| 10606 | 10606 | 86484 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1698 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987824.3728 | 2103790.6728 | 37.75590577449189 | -122.48510495178002 | (37.7559057744919, -122.48510495178) | ||
| 10786 | 10786 | 86557 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1839 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 5 | 3x3 | 5987812.6165 | 2102765.0103 | 37.7530888972888 | -122.48507035960199 | (37.7530888972888, -122.485070359602) | ||
| 10855 | 10855 | 86473 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1786 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987851.8695 | 2103141.0168 | 37.754123596233896 | -122.484962200288 | (37.7541235962339, -122.484962200288) | ||
| 10877 | 10877 | 86480 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1742 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987841.1062 | 2103418.0293 | 37.754883570877105 | -122.485019744249 | (37.7548835708771, -122.485019744249) | ||
| 10880 | 10880 | 86487 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1654 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987812.2064 | 2104044.7342 | 37.7566026495976 | -122.48516566702 | (37.7566026495976, -122.48516566702) | ||
| 10891 | 10891 | 86489 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1642 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987810.0594 | 2104111.2911 | 37.7567852717409 | -122.485177975352 | (37.7567852717409, -122.485177975352) | ||
| 10966 | 10966 | 86558 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1867 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 7 | 3x3 | 5987816.4554 | 2102586.0208 | 37.7525976639013 | -122.48504395302 | (37.7525976639013, -122.48504395302) | ||
| 11138 | 11138 | 86554 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1815 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987806.6182 | 2102907.2902 | 37.753479210173104 | -122.48510154092199 | (37.7534792101731, -122.485101540922) | ||
| 11205 | 11205 | 86472 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1810 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987855.0174 | 2102938.1418 | 37.7535667395127 | -122.484936431442 | (37.7535667395127, -122.484936431442) | ||
| 11268 | 11268 | 86482 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1722 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987834.8749 | 2103544.3561 | 37.7552300671815 | -122.48505056143499 | (37.7552300671815, -122.485050561435) | ||
| 11492 | 11492 | 86474 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1774 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987847.9041 | 2103231.0884 | 37.754370677583 | -122.484982521185 | (37.754370677583, -122.484982521185) | ||
| 11622 | 11622 | 86462 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1874 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 6 | 3x12 | 5987866.4109 | 2102544.1995 | 37.7524857435744 | -122.484868132588 | (37.7524857435744, -122.484868132588) | ||
| 11723 | 11723 | 86466 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1838 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987861.6361 | 2102765.0521 | 37.753091867307 | -122.48490084539499 | (37.753091867307, -122.484900845395) | ||
| 11748 | 11748 | 86465 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1842 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 8 | 3x3 | 5987862.4384 | 2102740.1818 | 37.7530236268855 | -122.484896246512 | (37.7530236268855, -122.484896246512) | ||
| 11831 | 11831 | 86477 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1754 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987839.9732 | 2103364.7795 | 37.754737295309 | -122.485019755857 | (37.754737295309, -122.485019755857) | ||
| 11875 | 11875 | 86490 | DPW Maintained 3 | Solanum rantonnetti :: 269 | 1618 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987805.7655 | 2104249.4147 | 37.7571642715643 | -122.485202959431 | (37.7571642715643, -122.485202959431) | ||
| 11879 | 11879 | 86555 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1819 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 5 | 3x3 | 5987809.0175 | 2102882.3372 | 37.7534108357177 | -122.48509141307 | (37.7534108357177, -122.48509141307) | ||
| 11890 | 11890 | 86455 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2274 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987957.131 | 2099832.7559 | 37.745046126390704 | -122.484355563995 | (37.7450461263907, -122.484355563995) | ||
| 11953 | 11953 | 86463 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1866 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987865.2759 | 2102589.5992 | 37.7526103328382 | -122.48487538787501 | (37.7526103328382, -122.484875387875) | ||
| 11980 | 11980 | 86461 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1878 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987868.3971 | 2102516.6759 | 37.75241028685029 | -122.48485924507 | (37.7524102868503, -122.48485924507) | ||
| 12105 | 12105 | 86556 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1823 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987809.2575 | 2102855.2249 | 37.7533364066252 | -122.485088594036 | (37.7533364066252, -122.485088594036) | ||
| 12123 | 12123 | 86469 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1826 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987859.0288 | 2102838.2592 | 37.7532927224365 | -122.48491523213 | (37.7532927224365, -122.48491523213) | ||
| 12139 | 12139 | 86488 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1646 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987812.9221 | 2104078.3705 | 37.7566950474544 | -122.485165659807 | (37.7566950474544, -122.485165659807) | ||
| 12358 | 12358 | 86559 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1883 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987822.6937 | 2102488.6083 | 37.7523305587422 | -122.48501523391501 | (37.7523305587422, -122.485015233915) | ||
| 12463 | 12463 | 86457 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2254 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987953.7171 | 2099943.2812 | 37.7453494007747 | -122.484375473288 | (37.7453494007747, -122.484375473288) |
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");