Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8946 | 8946 | 14523 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 625 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4x4 | 5999129.3058 | 2110654.1301 | 37.7754031370148 | -122.446502707181 | (37.7754031370148, -122.446502707181) | |||
| 19216 | 19216 | 5559 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 984 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6005041.33516 | 2102650.51852 | 37.753763035857794 | -122.425481873703 | (37.7537630358578, -122.425481873703) | |||
| 20711 | 20711 | 10425 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1419 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3x3 | 5999323.0709 | 2108716.5502 | 37.7700941010229 | -122.445693060933 | (37.7700941010229, -122.445693060933) | |||
| 22077 | 22077 | 5514 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 827 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X5 | 6005075.88619 | 2103522.4766599997 | 37.7561591814037 | -122.425424436705 | (37.7561591814037, -122.425424436705) | |||
| 103612 | 103612 | 12645 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 944 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5992509.49668 | 2114843.34604 | 37.786525248314206 | -122.469707022996 | (37.7865252483142, -122.469707022996) | |||
| 117166 | 117166 | 17371 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1050X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5999379.151930001 | 2109268.47217 | 37.771612740675394 | -122.44553877169399 | (37.7716127406754, -122.445538771694) | |||
| 81599 | 81599 | 10262 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 212 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005067.14002 | 2109566.5504900003 | 37.772754274276096 | -122.42588489611201 | (37.7727542742761, -122.425884896112) | |||
| 109971 | 109971 | 12646 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 944 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 5992487.23998 | 2114843.45413 | 37.786524258671896 | -122.469784032853 | (37.7865242586719, -122.469784032853) | |||
| 77447 | 77447 | 10384 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1330 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 5999747.979280001 | 2108852.64514 | 37.770492033974705 | -122.44423309424 | (37.7704920339747, -122.44423309424) | |||
| 17707 | 17707 | 10404 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1372 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 5999585.1964 | 2108804.377 | 37.7703502135529 | -122.44479268919599 | (37.7703502135529, -122.444792689196) | |||
| 100986 | 100986 | 10490 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1687 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 5997959.93364 | 2108479.83355 | 37.769366216326496 | -122.450391046811 | (37.7693662163265, -122.450391046811) | |||
| 16984 | 16984 | 10523 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1855 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 5997295.7816 | 2108435.9791 | 37.769207770213704 | -122.452685140494 | (37.7692077702137, -122.452685140494) | |||
| 18248 | 18248 | 5692 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1546 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6005220.41395 | 2099376.74782 | 37.7447841325786 | -122.42462971298401 | (37.7447841325786, -122.424629712984) | |||
| 19376 | 19376 | 10521 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1855 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 5997344.2343 | 2108442.9441 | 37.769229670497 | -122.452518048778 | (37.769229670497, -122.452518048778) | |||
| 21881 | 21881 | 5738 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1740 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4X4 | 6005286.8727 | 2098237.12847 | 37.741658750152794 | -122.42431887223499 | (37.7416587501528, -122.424318872235) | |||
| 90237 | 90237 | 10520 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1855 HAIGHT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5997298.0 | 2108414.0 | 37.7691475483634 | -122.452675880715 | (37.7691475483634, -122.452675880715) | |||
| 2263 | 2263 | 22364 | Landmark tree 9 | Schinus terebinthifolius :: Brazilian Pepper 25 | 5490X 03rd St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 40TR | 6014151.6099 | 2093070.9929 | 37.7279701830365 | -122.393305916851 | (37.7279701830365, -122.393305916851) | |||
| 18223 | 18223 | 14566 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1030 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5999382.6721 | 2109282.399 | 37.771651181181504 | -122.445527596882 | (37.7716511811815, -122.445527596882) | |||
| 17589 | 17589 | 10438 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1474 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5999064.8261 | 2108729.1491 | 37.770113946782 | -122.446587229644 | (37.770113946782, -122.446587229644) | |||
| 117637 | 117637 | 2775 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 325 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 5994586.46007 | 2110712.87272 | 37.77530390424771 | -122.462221623284 | (37.7753039042477, -122.462221623284) | |||
| 119968 | 119968 | 104734 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 5490x 03RD ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 9x9 | 6014203.0 | 2093127.0 | 37.7281268221954 | -122.39313217573601 | (37.7281268221954, -122.393132175736) | |||
| 142046 | 142046 | 2772 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 300 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5994610.57975 | 2110790.94437 | 37.775519657009994 | -122.462143851512 | (37.77551965701, -122.462143851512) | |||
| 171132 | 171132 | 197575 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1121 Jamestown Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | 6013269.3073 | 2090137.6242 | 37.719866686770395 | -122.396150589498 | (37.7198666867704, -122.396150589498) | ||||
| 66751 | 66751 | 197556 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200 Kansas St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 37 | Width 4ft | 6011387.43171 | 2107337.57251 | 37.7669891592581 | -122.403865303157 | (37.7669891592581, -122.403865303157) | |||
| 95365 | 95365 | 5484 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 700X Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 35 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | |||
| 142558 | 142558 | 7684 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 315X Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5994678.74309 | 2110742.5512099997 | 37.7753907066265 | -122.46190454994301 | (37.7753907066265, -122.461904549943) | |||
| 28030 | 28030 | 197577 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 299x Cashmere St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 6016820.77887 | 2095888.49241 | 37.735854408739 | -122.38427457691002 | (37.735854408739, -122.38427457691) | ||||
| 14458 | 14458 | 94035 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1300X Lane St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 32 | 5x5 | 6015684.8669 | 2095240.1882 | 37.7340114236329 | -122.388156677838 | (37.7340114236329, -122.388156677838) | ||
| 141439 | 141439 | 22636 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1181 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | 3X3 | 6004533.51826 | 2112418.26728 | 37.780554217860704 | -122.427933997943 | (37.7805542178607, -122.427933997943) | |||
| 1570 | 1570 | 5344 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 180 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6004766.753190001 | 2107347.6889299997 | 37.7666448358082 | -122.42676592392999 | (37.7666448358082, -122.42676592393) | |||
| 79047 | 79047 | 22632 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1171 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6004419.15464 | 2112535.54329 | 37.7808697581914 | -122.428337997055 | (37.7808697581914, -122.428337997055) | |||
| 108644 | 108644 | 2785 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 431 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 5994248.85209 | 2110724.78834 | 37.7753171764734 | -122.463390343008 | (37.7753171764734, -122.463390343008) | |||
| 120228 | 120228 | 2780 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 410 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5994353.307030001 | 2110782.9529 | 37.7754828983009 | -122.463033233018 | (37.7754828983009, -122.463033233018) | |||
| 128634 | 128634 | 7135 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 336X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5994611.623430001 | 2110790.08992 | 37.775517371009 | -122.46214017921899 | (37.775517371009, -122.462140179219) | |||
| 139008 | 139008 | 7138 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 336X Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5994611.623430001 | 2110790.08992 | 37.775517371009 | -122.46214017921899 | (37.775517371009, -122.462140179219) | |||
| 141986 | 141986 | 2786 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 435 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5994220.38396 | 2110725.0334799998 | 37.775316209380605 | -122.463488837884 | (37.7753162093806, -122.463488837884) | |||
| 143530 | 143530 | 2769 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 300 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5994681.187530001 | 2110791.87373 | 37.7755262738923 | -122.46189967141899 | (37.7755262738923, -122.461899671419) | |||
| 151449 | 151449 | 247579 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 300x Alemany Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6008670.31016 | 2095309.15662 | 37.733809649895704 | -122.412413126286 | (37.7338096498957, -122.412413126286) | ||||
| 169541 | 169541 | 214180 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 350 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 3ft | 5992555.06379 | 2094476.42863 | 37.7306056595249 | -122.46806731945499 | (37.7306056595249, -122.468067319455) | |||
| 104503 | 104503 | 5421 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 445 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | 5X5 | 6004959.0723832 | 2105770.0586221 | 37.7623239107578 | -122.42598840833999 | (37.7623239107578, -122.42598840834) | |||
| 24001 | 24001 | 239679 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3426 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 5ft | 6005478.10496 | 2103741.19129 | 37.7567824376811 | -122.42404897940399 | (37.7567824376811, -122.424048979404) | |||
| 57850 | 57850 | 141929 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1050 MCALLISTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 6004201.9404 | 2111879.6644 | 37.7790565838512 | -122.429042670434 | (37.7790565838512, -122.429042670434) | |||
| 130526 | 130526 | 98610 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1537 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3x3 | 6015377.6336 | 2094141.2385 | 37.7309769017577 | -122.389142180051 | (37.7309769017577, -122.389142180051) | |||
| 165240 | 165240 | 240560 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 55 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 6003262.809119999 | 2105621.97436 | 37.761821295028795 | -122.431844570873 | (37.7618212950288, -122.431844570873) | |||
| 1073 | 1073 | 22619 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1107 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6004653.0794 | 2112584.8191 | 37.7810182911755 | -122.42753224810801 | (37.7810182911755, -122.427532248108) | |||
| 24323 | 24323 | 197548 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101 Rhode Island St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6011737.58275 | 2107186.1268599997 | 37.766592879273404 | -122.402643527378 | (37.7665928792734, -122.402643527378) | |||
| 42737 | 42737 | 239675 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 689 Dolores St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 9ft | 6005030.3991 | 2104342.90235 | 37.7584093076526 | -122.425640136401 | (37.7584093076526, -122.425640136401) | |||
| 68118 | 68118 | 239670 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 443 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6004953.91663 | 2105786.25833 | 37.762368099926206 | -122.426007393424 | (37.7623680999262, -122.426007393424) | |||
| 74804 | 74804 | 197559 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200 Kansas St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 4ft | 6011390.59783 | 2107261.9100099998 | 37.7667815840329 | -122.403849027227 | (37.7667815840329, -122.403849027227) | |||
| 84806 | 84806 | 2774 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 325 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 4X6 | 5994591.7075 | 2110737.91873 | 37.7753729760761 | -122.46220528818701 | (37.7753729760761, -122.462205288187) | |||
| 94120 | 94120 | 10424 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1417 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 5999343.5805 | 2108720.18711 | 37.77010525801229 | -122.445622380313 | (37.7701052580123, -122.445622380313) | |||
| 136198 | 136198 | 247576 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 350x Alemany Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6008435.75806 | 2095170.56175 | 37.733415932988 | -122.413214248635 | (37.733415932988, -122.413214248635) | ||||
| 154792 | 154792 | 239731 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1709 Castro St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6002630.2192400005 | 2100589.8349099997 | 37.7479683603545 | -122.433672786481 | (37.7479683603545, -122.433672786481) | |||
| 184658 | 184658 | 124347 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 850 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 8ft | 5992970.95796 | 2111419.69143 | 37.777151486539104 | -122.46786138931499 | (37.7771514865391, -122.467861389315) | |||
| 189008 | 189008 | 197555 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200 Kansas St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 4ft | 6011386.38473 | 2107363.2099 | 37.7670594952368 | -122.403870728771 | (37.7670594952368, -122.403870728771) | |||
| 2300 | 2300 | 6356 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1234X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001371.4698 | 2112650.1535 | 37.7810115248297 | -122.438889623593 | (37.7810115248297, -122.438889623593) | |||
| 2506 | 2506 | 10385 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1330 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/17/2017 12:00:00 AM | 24 | 3X3 | 5999759.2979999995 | 2108827.6222 | 37.7704239730353 | -122.444192144461 | (37.7704239730353, -122.444192144461) | ||
| 15674 | 15674 | 94034 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1300X Lane St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 24 | 3x3 | 6015674.4242 | 2095246.7836 | 37.7340289546749 | -122.388193241926 | (37.7340289546749, -122.388193241926) | ||
| 17571 | 17571 | 5359 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 233 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5x5 | 6004883.71893 | 2107010.19311 | 37.765724765498206 | -122.426337327709 | (37.7657247654982, -122.426337327709) | |||
| 20272 | 20272 | 5372 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 266 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5x5 | 6004807.33386 | 2106790.92069 | 37.7651183778313 | -122.426585912012 | (37.7651183778313, -122.426585912012) | |||
| 53284 | 53284 | 197543 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6011744.4821 | 2107062.59215 | 37.7662540659871 | -122.40261097552799 | (37.7662540659871, -122.402610975528) | |||
| 61007 | 61007 | 215018 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 113 Stillings Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6000011.08105 | 2095687.8075 | 37.734359595202996 | -122.442377758036 | (37.734359595203, -122.442377758036) | ||||
| 66153 | 66153 | 141832 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1171 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6004383.2413 | 2112546.5688 | 37.7808979992964 | -122.428463024993 | (37.7808979992964, -122.428463024993) | |||
| 88014 | 88014 | 23587 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3251X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005329.9297952 | 2121916.8669395 | 37.8066799978444 | -122.42585514440701 | (37.8066799978444, -122.425855144407) | |||
| 124515 | 124515 | 701 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1401X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005272.9475237 | 2100137.7446563 | 37.7468766226068 | -122.424502181659 | (37.7468766226068, -122.424502181659) | |||
| 125698 | 125698 | 54244 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 10 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/1972 12:00:00 AM | 24 | Permit Number 9985 | 6003826.70188878 | 2107089.19403693 | 37.7658818771202 | -122.42999895682699 | (37.7658818771202, -122.429998956827) | ||
| 2547 | 2547 | 141912 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6004447.1952 | 2111915.047 | 37.7791676154415 | -122.42819675688 | (37.7791676154415, -122.42819675688) | |||
| 21727 | 21727 | 4159 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3736-3738 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/1989 12:00:00 AM | 23 | 3X3 | 6005622.07663 | 2100534.0724299997 | 37.7479845580381 | -122.4233230934 | (37.7479845580381, -122.4233230934) | ||
| 23500 | 23500 | 200674 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6015639.7987 | 2095348.4618 | 37.7343062239298 | -122.38832004816099 | (37.7343062239298, -122.388320048161) | |||
| 135451 | 135451 | 200680 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6015687.0653 | 2095298.4471 | 37.734171512631 | -122.388153141599 | (37.734171512631, -122.388153141599) | |||
| 171198 | 171198 | 142669 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 444 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6009205.7299 | 2121176.5543 | 37.8048655501446 | -122.412389783451 | (37.8048655501446, -122.412389783451) | |||
| 173328 | 173328 | 197547 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101 Rhode Island St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6011743.058130001 | 2107162.2739 | 37.7665276901155 | -122.402622911324 | (37.7665276901155, -122.402622911324) | |||
| 186374 | 186374 | 214195 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 333 San Benito Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 5992867.77854 | 2094524.25297 | 37.730755027909105 | -122.466989702314 | (37.7307550279091, -122.466989702314) | |||
| 30398 | 30398 | 240548 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4172 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6002753.681480001 | 2101252.12814 | 37.7497938663026 | -122.433293177244 | (37.7497938663026, -122.433293177244) | |||
| 55322 | 55322 | 239696 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 112 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 5997951.3916 | 2106835.98646 | 37.7648521416436 | -122.450302081196 | (37.7648521416436, -122.450302081196) | |||
| 56796 | 56796 | 215019 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 113 Stillings Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 10ft | 6000031.68078 | 2095690.19732 | 37.7343673311927 | -122.44230670979601 | (37.7343673311927, -122.442306709796) | |||
| 65250 | 65250 | 239739 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4195 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 6002669.07226 | 2100621.06715 | 37.7480563212454 | -122.433540666185 | (37.7480563212454, -122.433540666185) | |||
| 66303 | 66303 | 240534 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3250 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6006614.52941 | 2103803.76084 | 37.7570183352315 | -122.420123238094 | (37.7570183352315, -122.420123238094) | |||
| 76650 | 76650 | 246228 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 5999452.5303 | 2107741.8948 | 37.7674253335335 | -122.44517518096501 | (37.7674253335335, -122.445175180965) | |||
| 82237 | 82237 | 98255 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1375 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 5x5 | Permit Number 25808 | 6003289.0 | 2100236.0 | 37.7470341706262 | -122.431369496968 | (37.7470341706262, -122.431369496968) | ||
| 84317 | 84317 | 5480 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 695 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 8 | 6005032.869109999 | 2104338.69015 | 37.7583978815122 | -122.425631294213 | (37.7583978815122, -122.425631294213) | |||
| 146870 | 146870 | 239737 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1375 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 6003294.62667 | 2100231.18022 | 37.7470212555198 | -122.431349696436 | (37.7470212555198, -122.431349696436) | |||
| 152193 | 152193 | 197554 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200 Kansas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 4ft | 6011382.26351 | 2107407.34025 | 37.7671804369461 | -122.40388808926201 | (37.7671804369461, -122.403888089262) | |||
| 159825 | 159825 | 179469 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 750 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6002474.00901 | 2089177.3596700002 | 37.716623442792795 | -122.433397545354 | (37.7166234427928, -122.433397545354) | |||
| 166446 | 166446 | 123745 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 98 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 5995418.55494 | 2110821.8121700003 | 37.775650899214895 | -122.459351125835 | (37.7756508992149, -122.459351125835) | |||
| 175512 | 175512 | 136398 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 536 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6004816.1478699995 | 2110734.28179 | 37.7759463924382 | -122.426836284165 | (37.7759463924382, -122.426836284165) | |||
| 177291 | 177291 | 141831 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1181 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6004346.382 | 2112542.3961 | 37.780884456218295 | -122.42859024188999 | (37.7808844562183, -122.42859024189) | |||
| 177504 | 177504 | 197553 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101 Rhode Island St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6011728.60069 | 2107407.7927900003 | 37.7672010224355 | -122.402690185116 | (37.7672010224355, -122.402690185116) | |||
| 188040 | 188040 | 197520 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 98 Lafayette St | 5 | : 4 | Tree 1 | Private 1 | 22 | Width 3ft | 6007717.2402800005 | 2109472.44967 | 37.7726453040621 | -122.416711211162 | (37.7726453040621, -122.416711211162) | |||
| 688 | 688 | 214188 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 358 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1972 12:00:00 AM | 21 | Width 3ft | Permit Number 9461 | 5992780.99407 | 2094319.4986599998 | 37.7301878137975 | -122.467274844971 | (37.7301878137975, -122.467274844971) | |
| 2527 | 2527 | 141910 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6004551.4043 | 2111926.6796 | 37.7792054513567 | -122.42783708385099 | (37.7792054513567, -122.427837083851) | |||
| 17239 | 17239 | 5333 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 135 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3X3 | 6004851.68413 | 2107592.33342 | 37.767321372413704 | -122.42648958384399 | (37.7673213724137, -122.426489583844) | |||
| 60746 | 60746 | 246229 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Frederick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 5999439.8115 | 2107740.3807 | 37.767420450212605 | -122.44521906453001 | (37.7674204502126, -122.44521906453) | |||
| 63285 | 63285 | 240524 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1023 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5997228.0393199995 | 2107019.29645 | 37.7653140406215 | -122.452817189965 | (37.7653140406215, -122.452817189965) | |||
| 67417 | 67417 | 240549 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 426 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6003562.13775 | 2103342.68871 | 37.755579884022396 | -122.430646661337 | (37.7555798840224, -122.430646661337) | |||
| 67464 | 67464 | 123731 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 401 Cabrillo St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 4ft | 5994355.1491 | 2110725.19999 | 37.7753244302949 | -122.463022669753 | (37.7753244302949, -122.463022669753) | |||
| 109617 | 109617 | 2778 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 330 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3X3 | 5994563.2204599995 | 2110788.63831 | 37.775510598279205 | -122.462307510178 | (37.7755105982792, -122.462307510178) | |||
| 134997 | 134997 | 200682 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6015703.0041 | 2095289.1037 | 37.7341467406335 | -122.388097383825 | (37.7341467406335, -122.388097383825) | |||
| 136636 | 136636 | 239720 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4428 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6001164.3795 | 2101162.4320400003 | 37.749457292323605 | -122.438782612939 | (37.7494572923236, -122.438782612939) | |||
| 136734 | 136734 | 239703 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1048 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5998155.7967300005 | 2106630.88901 | 37.764300691739294 | -122.44958031947701 | (37.7643006917393, -122.449580319477) |
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");