Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize, PermitNotes
qLegalStatus ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 258 | 258 | 251259 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1050x Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009753.0 | 2116795.0 | 37.7928655753561 | -122.410186352148 | (37.7928655753561, -122.410186352148) | ||||
| 9398 | 9398 | 116356 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2752 FOLSOM ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6008296.0 | 2102398.0 | 37.7532530322434 | -122.414208601119 | (37.7532530322434, -122.414208601119) | |||
| 31561 | 31561 | 242790 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 444 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001493.01525 | 2103141.50906 | 37.754910054563396 | -122.437787910606 | (37.7549100545634, -122.437787910606) | |||
| 36292 | 36292 | 242782 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 3060 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009196.5579699995 | 2101026.42039 | 37.7495375244342 | -122.41099740631999 | (37.7495375244342, -122.41099740632) | |||
| 39767 | 39767 | 137066 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 12 Filbert St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6012425.54206 | 2120223.78485 | 37.8024296352708 | -122.401180217987 | (37.8024296352708, -122.401180217987) | ||||
| 41765 | 41765 | 242786 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 410 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005479.73909 | 2101277.25684 | 37.750017137383296 | -122.42386812932502 | (37.7500171373833, -122.423868129325) | |||
| 43013 | 43013 | 137065 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 11 Filbert St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6012521.25442 | 2120194.7201 | 37.8023551696124 | -122.40084696071399 | (37.8023551696124, -122.400846960714) | ||||
| 44759 | 44759 | 137064 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2781 Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5999684.54965 | 2118419.7892299998 | 37.7967573134519 | -122.44514041869199 | (37.7967573134519, -122.445140418692) | |||
| 50861 | 50861 | 242785 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2730 22nd St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6009778.64704 | 2103394.74604 | 37.7560730434384 | -122.409151611674 | (37.7560730434384, -122.409151611674) | |||
| 74986 | 74986 | 242783 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 3060 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009163.38905 | 2101022.2173 | 37.7495241236381 | -122.411111809067 | (37.7495241236381, -122.411111809067) | |||
| 84080 | 84080 | 116788 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 530 CRESCENT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6007719.0 | 2095661.0 | 37.7347223035732 | -122.415727003996 | (37.7347223035732, -122.415727003996) | |||
| 84484 | 84484 | 16429 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1390X Newcomb Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6016319.32575 | 2094912.29279 | 37.733146221039 | -122.38594028879 | (37.733146221039, -122.38594028879) | |||
| 90684 | 90684 | 116842 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1110 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 8 | 6003795.63291288 | 2101809.17317596 | 37.751382436857796 | -122.429729790926 | (37.7513824368578, -122.429729790926) | |||
| 101987 | 101987 | 99977 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2295 Folsom St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Permit Number 47188 | 6008194.0 | 2105070.0 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | ||||
| 104712 | 104712 | 117585 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 3100X FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002493.0 | 2118872.0 | 37.7981588656011 | -122.435454914846 | (37.7981588656011, -122.435454914846) | ||||
| 105057 | 105057 | 99976 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2295 Folsom St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6008194.0 | 2105070.0 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | |||||
| 121518 | 121518 | 98189 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1498X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6008828.0 | 2109520.0 | 37.7728382767515 | -122.412872323828 | (37.7728382767515, -122.412872323828) | |||
| 145109 | 145109 | 98188 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1498X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6008543.0 | 2109248.0 | 37.7720754271741 | -122.41383893105801 | (37.7720754271741, -122.413838931058) | |||
| 147797 | 147797 | 180576 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 100 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004076.33336 | 2094007.41244 | 37.7299764776345 | -122.428203140362 | (37.7299764776345, -122.428203140362) | |||
| 158978 | 158978 | 242789 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 305 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007810.4861 | 2106094.80833 | 37.7633763361668 | -122.416149407388 | (37.7633763361668, -122.416149407388) | |||
| 159535 | 159535 | 180578 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 106 Ney St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004112.42356 | 2094009.6957900003 | 37.7299847891668 | -122.42807853481001 | (37.7299847891668, -122.42807853481) | |||
| 160833 | 160833 | 120786 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 253 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5989295.33642 | 2113646.62963 | 37.78305310452279 | -122.480739452185 | (37.7830531045228, -122.480739452185) | |||
| 166098 | 166098 | 242788 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 305 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007812.97751 | 2106058.80596 | 37.763277622093206 | -122.416138240487 | (37.7632776220932, -122.416138240487) | |||
| 172845 | 172845 | 180574 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 605 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6002770.24765 | 2090074.97352 | 37.7191048944443 | -122.43243767198601 | (37.7191048944443, -122.432437671986) | |||
| 178714 | 178714 | 180575 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 185 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004602.74534 | 2093797.60717 | 37.7294301700595 | -122.426368337242 | (37.7294301700595, -122.426368337242) | |||
| 182330 | 182330 | 180577 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 106 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004093.306609999 | 2094009.2250299999 | 37.729982414954904 | -122.428144590899 | (37.7299824149549, -122.428144590899) | |||
| 185851 | 185851 | 242784 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2730 22nd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6009801.01572 | 2103396.12186 | 37.756078074246 | -122.409074350022 | (37.756078074246, -122.409074350022) | |||
| 187261 | 187261 | 242787 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 72 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006069.06091 | 2097600.46575 | 37.7399547543139 | -122.421569116835 | (37.7399547543139, -122.421569116835) | |||
| 116680 | 116680 | 108833 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 79 Ney St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774661 | 6003925.191380001 | 2094039.50832 | 37.7300560527634 | -122.42872794360301 | (37.7300560527634, -122.428727943603) | |
| 99817 | 99817 | 49040 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1110 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | Permit Number 46215 | 6003795.63291288 | 2101809.17317596 | 37.751382436857796 | -122.429729790926 | (37.7513824368578, -122.429729790926) | ||
| 100829 | 100829 | 115167 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1157 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 777350 | 5997321.9 | 2106236.4 | 37.7631697841866 | -122.452436048563 | (37.7631697841866, -122.452436048563) | |||
| 13595 | 13595 | 85796 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 975 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2014 12:00:00 AM | 3 | 3x3 | 6011171.3417 | 2111690.3951 | 37.778928935443204 | -122.404919231111 | (37.7789289354432, -122.404919231111) | ||
| 107082 | 107082 | 59736 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 916 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/19/2016 12:00:00 AM | Permit Number 775357 | 6003734.07108678 | 2102930.08592587 | 37.7544567132931 | -122.430022630753 | (37.7544567132931, -122.430022630753) | ||
| 105914 | 105914 | 12817 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2140 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2014 12:00:00 AM | 2 | 5 | 5988770.65902 | 2114708.68477 | 37.7859386982185 | -122.482632451333 | (37.7859386982185, -122.482632451333) | ||
| 119372 | 119372 | 87185 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1245 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2008 12:00:00 AM | 3x3 | Permit Number 50187 | 5999399.3 | 2108538.0 | 37.7696081992395 | -122.445416546032 | (37.7696081992395, -122.445416546032) | ||
| 121459 | 121459 | 115374 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 579 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 775275 | 6007846.3 | 2096185.0 | 37.7361682484885 | -122.41532396578 | (37.7361682484885, -122.41532396578) | ||
| 109170 | 109170 | 95393 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 3965 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767262 | 6004412.0 | 2100353.0 | 37.747419006534 | -122.427494591738 | (37.747419006534, -122.427494591738) | |
| 124602 | 124602 | 95382 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 4317 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767252 | 6001161.0 | 2101705.0 | 37.75094686177329 | -122.43883317496099 | (37.7509468617733, -122.438833174961) | |
| 78881 | 78881 | 38309 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2000 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2016 12:00:00 AM | 3 | Permit Number 771420 | 6008042.39215173 | 2106787.37094181 | 37.765290989194895 | -122.415396349695 | (37.7652909891949, -122.415396349695) | |
| 107269 | 107269 | 26593 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1641 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2003 12:00:00 AM | 3 | 3X3 | 6012037.06669 | 2091373.8047200001 | 37.723192347129896 | -122.400496829505 | (37.7231923471299, -122.400496829505) | ||
| 117501 | 117501 | 98852 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 64 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2012 12:00:00 AM | 3x3 | Permit Number 768793 | 6002914.9 | 2108659.2 | 37.770141048876 | -122.43326488117901 | (37.770141048876, -122.433264881179) | ||
| 138619 | 138619 | 110252 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1514 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774936 | 6002531.9 | 2101059.9 | 37.749253468980896 | -122.434046366801 | (37.7492534689809, -122.434046366801) | |
| 92509 | 92509 | 72489 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 410 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2013 12:00:00 AM | 3 | 4x4 | Permit Number 775549 | 6005471.04760898 | 2101307.0300515 | 37.75009839709271 | -122.423900301836 | (37.7500983970927, -122.423900301836) | |
| 361 | 361 | 85803 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 923 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778048 | 6011427.0378 | 2111936.1074 | 37.779617893816 | -122.40405196806002 | (37.779617893816, -122.40405196806) | |
| 394 | 394 | 85804 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 923 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778048 | 6011441.4589 | 2111949.4191 | 37.7796552503769 | -122.404003016031 | (37.7796552503769, -122.404003016031) | |
| 142716 | 142716 | 17508 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 209 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/25/2008 12:00:00 AM | 3 | 3X3 | 6002263.284973901 | 2091285.3954444 | 37.722399682135205 | -122.434276533913 | (37.7223996821352, -122.434276533913) | ||
| 81101 | 81101 | 103747 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1681 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008106.2 | 2108469.9 | 37.769914407380796 | -122.415294769944 | (37.7699144073808, -122.415294769944) | ||
| 81230 | 81230 | 103729 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2331 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008229.6 | 2104850.4 | 37.759983034143296 | -122.414611757947 | (37.7599830341433, -122.414611757947) | ||
| 86085 | 86085 | 103749 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1675 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008074.4 | 2108475.6 | 37.76992827096289 | -122.415405169405 | (37.7699282709629, -122.415405169405) | ||
| 86289 | 86289 | 103751 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1645 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008157.3 | 2108615.0 | 37.7703156897445 | -122.41512828788099 | (37.7703156897445, -122.415128287881) | ||
| 87880 | 87880 | 103725 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2899X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008379.2 | 2101559.4 | 37.7509550985774 | -122.41386156167499 | (37.7509550985774, -122.413861561675) | ||
| 90081 | 90081 | 103734 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2121 FOLSOM ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 8 | 3x3 | 6008239.0 | 2106082.0 | 37.7633652523205 | -122.414666405954 | (37.7633652523205, -122.414666405954) | ||
| 93196 | 93196 | 103735 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2101 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 8 | 3x3 | 6008250.5 | 2106082.2 | 37.7633664475813 | -122.41462664522601 | (37.7633664475813, -122.414626645226) | ||
| 94006 | 94006 | 103728 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2335 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008231.0 | 2104824.3 | 37.75991144818521 | -122.41460506901501 | (37.7599114481852, -122.414605069015) | ||
| 95105 | 95105 | 103740 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2075 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008144.6 | 2106350.8 | 37.7640980107115 | -122.415011932629 | (37.7640980107115, -122.415011932629) | ||
| 100388 | 100388 | 103748 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1675 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008074.4 | 2108475.6 | 37.76992827096289 | -122.415405169405 | (37.7699282709629, -122.415405169405) | ||
| 102314 | 102314 | 103731 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2225 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008315.8 | 2105284.4 | 37.761179541063704 | -122.414344341073 | (37.7611795410637, -122.414344341073) | ||
| 108220 | 108220 | 103754 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1601X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008223.7 | 2108752.2 | 37.7706961400308 | -122.41490832168002 | (37.7706961400308, -122.41490832168) | ||
| 111015 | 111015 | 103733 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2225 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008315.8 | 2105284.4 | 37.761179541063704 | -122.414344341073 | (37.7611795410637, -122.414344341073) | ||
| 112710 | 112710 | 103727 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2485 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008277.2 | 2103979.5 | 37.7575944160951 | -122.414385508985 | (37.7575944160951, -122.414385508985) | ||
| 113503 | 113503 | 103739 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2075 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008144.6 | 2106350.8 | 37.7640980107115 | -122.415011932629 | (37.7640980107115, -122.415011932629) | ||
| 114773 | 114773 | 103736 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2101 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 8 | 3x3 | 6008250.5 | 2106082.2 | 37.7633664475813 | -122.41462664522601 | (37.7633664475813, -122.414626645226) | ||
| 116171 | 116171 | 103730 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2315 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008264.6 | 2104925.3 | 37.7601906586786 | -122.41449600953501 | (37.7601906586786, -122.414496009535) | ||
| 118874 | 118874 | 103742 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2021 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008130.3 | 2106612.8 | 37.7648165983937 | -122.415079938624 | (37.7648165983937, -122.415079938624) | ||
| 123237 | 123237 | 103726 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2843 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008392.8 | 2101883.1 | 37.7518446697515 | -122.41383742638399 | (37.7518446697515, -122.413837426384) | ||
| 127189 | 127189 | 103737 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2075 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 9 | 3x3 | 6008144.6 | 2106350.8 | 37.7640980107115 | -122.415011932629 | (37.7640980107115, -122.415011932629) | ||
| 127384 | 127384 | 103750 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1665 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008126.9 | 2108535.0 | 37.770094320073596 | -122.41522777783301 | (37.7700943200736, -122.415227777833) | ||
| 142209 | 142209 | 103732 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2225 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008315.8 | 2105284.4 | 37.761179541063704 | -122.414344341073 | (37.7611795410637, -122.414344341073) | ||
| 144526 | 144526 | 103738 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2075 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008144.6 | 2106350.8 | 37.7640980107115 | -122.415011932629 | (37.7640980107115, -122.415011932629) | ||
| 81153 | 81153 | 85749 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 900 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011609.0 | 2112176.0 | 37.78028674810621 | -122.403439360525 | (37.7802867481062, -122.403439360525) | ||
| 81492 | 81492 | 85755 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 900 Folsom St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011609.0 | 2112176.0 | 37.78028674810621 | -122.403439360525 | (37.7802867481062, -122.403439360525) | ||
| 81541 | 81541 | 85772 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1585 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008240.0 | 2108862.0 | 37.770998540951794 | -122.41485971180599 | (37.7709985409518, -122.414859711806) | ||
| 82663 | 82663 | 85791 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1101X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6010323.0 | 2110925.0 | 37.776779882708205 | -122.407800012097 | (37.7767798827082, -122.407800012097) | ||
| 84955 | 84955 | 85798 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 965 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011205.0 | 2111745.0 | 37.7790807491546 | -122.404806638376 | (37.7790807491546, -122.404806638376) | ||
| 97966 | 97966 | 85773 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1585 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008240.0 | 2108862.0 | 37.770998540951794 | -122.41485971180599 | (37.7709985409518, -122.414859711806) | ||
| 99191 | 99191 | 85752 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 900 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011609.0 | 2112176.0 | 37.78028674810621 | -122.403439360525 | (37.7802867481062, -122.403439360525) | ||
| 99536 | 99536 | 85808 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 901X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011628.490476 | 2112144.478567 | 37.780201286185104 | -122.40336971541402 | (37.7802012861851, -122.403369715414) | ||
| 101326 | 101326 | 85800 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 935 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | Permit Number 768011 | 6011398.0 | 2111930.0 | 37.7795995018672 | -122.404151992929 | (37.7795995018672, -122.404151992929) | |
| 104550 | 104550 | 85745 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 880 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 6 | 3x3 | 6011737.0 | 2112298.0 | 37.7806288802706 | -122.403005130314 | (37.7806288802706, -122.403005130314) | ||
| 106010 | 106010 | 85751 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 900 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011609.0 | 2112176.0 | 37.78028674810621 | -122.403439360525 | (37.7802867481062, -122.403439360525) | ||
| 107666 | 107666 | 85746 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 900 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011609.0 | 2112176.0 | 37.78028674810621 | -122.403439360525 | (37.7802867481062, -122.403439360525) | ||
| 110092 | 110092 | 85771 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1480 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008543.0 | 2109248.0 | 37.7720754271741 | -122.41383893105801 | (37.7720754271741, -122.413838931058) | ||
| 111190 | 111190 | 85747 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 900 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011609.0 | 2112176.0 | 37.78028674810621 | -122.403439360525 | (37.7802867481062, -122.403439360525) | ||
| 111578 | 111578 | 85758 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 984 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011059.0 | 2111650.0 | 37.7788117396287 | -122.40530502246901 | (37.7788117396287, -122.405305022469) | ||
| 111910 | 111910 | 85801 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 935 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | Permit Number 768011 | 6011398.0 | 2111930.0 | 37.7795995018672 | -122.404151992929 | (37.7795995018672, -122.404151992929) | |
| 113931 | 113931 | 85753 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 900 Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011609.0 | 2112176.0 | 37.78028674810621 | -122.403439360525 | (37.7802867481062, -122.403439360525) | ||
| 115387 | 115387 | 85774 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1585 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008240.0 | 2108862.0 | 37.770998540951794 | -122.41485971180599 | (37.7709985409518, -122.414859711806) | ||
| 119684 | 119684 | 85754 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 900 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011609.0 | 2112176.0 | 37.78028674810621 | -122.403439360525 | (37.7802867481062, -122.403439360525) | ||
| 122473 | 122473 | 85748 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 900 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011609.0 | 2112176.0 | 37.78028674810621 | -122.403439360525 | (37.7802867481062, -122.403439360525) | ||
| 124908 | 124908 | 85802 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 935 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | Permit Number 768011 | 6011398.0 | 2111930.0 | 37.7795995018672 | -122.404151992929 | (37.7795995018672, -122.404151992929) | |
| 127683 | 127683 | 85770 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1480 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008543.0 | 2109248.0 | 37.7720754271741 | -122.41383893105801 | (37.7720754271741, -122.413838931058) | ||
| 145445 | 145445 | 85742 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 816 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6012158.0 | 2112700.0 | 37.7817561793381 | -122.40157694342501 | (37.7817561793381, -122.401576943425) | ||
| 146319 | 146319 | 85750 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 900 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011609.0 | 2112176.0 | 37.78028674810621 | -122.403439360525 | (37.7802867481062, -122.403439360525) | ||
| 99838 | 99838 | 85776 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1425 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2015 11:16:00 AM | 3 | 3x3 | 6008757.0 | 2109407.0 | 37.772524019699 | -122.413109930192 | (37.772524019699, -122.413109930192) | ||
| 15103 | 15103 | 85784 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1257 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2015 11:19:00 AM | 3 | 3x3 | 6009427.6278 | 2110025.2513 | 37.7742592182749 | -122.410833824093 | (37.7742592182749, -122.410833824093) | ||
| 103015 | 103015 | 85877 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2456 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/16/2013 12:00:00 AM | 3 | 3x3 | 6008190.0 | 2104121.0 | 37.7579780438756 | -122.41469709646601 | (37.7579780438756, -122.414697096466) | ||
| 125494 | 125494 | 85878 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2460 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/16/2013 12:00:00 AM | 9 | 3x3 | 6008191.0 | 2104098.0 | 37.757914947315506 | -122.414692010384 | (37.7579149473155, -122.414692010384) | ||
| 94092 | 94092 | 88649 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 135 Fillmore St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778385 | 6003732.7 | 2108890.4 | 37.7708222270411 | -122.43045261886999 | (37.7708222270411, -122.43045261887) | ||
| 69889 | 69889 | 85866 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2000 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/2007 12:00:00 AM | 5 | 3x3 | 6008038.0 | 2106791.0 | 37.7653007068824 | -122.415411798097 | (37.7653007068824, -122.415411798097) | ||
| 87903 | 87903 | 85860 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1740X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/2007 12:00:00 AM | 3 | 3x3 | 6007977.0 | 2108187.0 | 37.7691303681921 | -122.415721637336 | (37.7691303681921, -122.415721637336) |
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");