Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 118324 | 118324 | 119789 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
| 118660 | 118660 | 82639 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 262 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52220 | 6007782.82233026 | 2105835.06197207 | 37.7626615773847 | -122.41622669003401 | (37.7626615773847, -122.416226690034) | ||
| 118928 | 118928 | 32532 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 70 Porter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37034 | 6006985.4956632005 | 2095516.38069521 | 37.7342839493681 | -122.418252734879 | (37.7342839493681, -122.418252734879) | ||
| 119017 | 119017 | 36147 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2201 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1998 12:00:00 AM | Permit Number 39234 | 6010900.97776393 | 2106452.95281145 | 37.7645330054499 | -122.405485571016 | (37.7645330054499, -122.405485571016) | ||
| 119541 | 119541 | 108234 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 131 RUSS ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6010302.0 | 2111707.0 | 37.7789258960759 | -122.407927816208 | (37.7789258960759, -122.407927816208) | ||||
| 119806 | 119806 | 117578 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 701x CALIFORNIA ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6010911.0 | 2116555.0 | 37.79227143324471 | -122.406162679671 | (37.7922714332447, -122.406162679671) | ||||
| 119921 | 119921 | 92522 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1350 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6009005.0 | 2109688.0 | 37.773309499001996 | -122.412271934387 | (37.773309499002, -122.412271934387) | ||
| 120457 | 120457 | 35492 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3711 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/05/2002 12:00:00 AM | Permit Number 44720 | 6005570.32724281 | 2104283.24490329 | 37.7582759965632 | -122.423768581299 | (37.7582759965632, -122.423768581299) | ||
| 120581 | 120581 | 46913 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 455 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | ||
| 120594 | 120594 | 97847 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
| 120637 | 120637 | 92019 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 129 Hyde St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2009 12:00:00 AM | 3x3 | Permit Number 52167 | 6008096.0 | 2112840.0 | 37.781913090386794 | -122.415639514466 | (37.7819130903868, -122.415639514466) | |||
| 120668 | 120668 | 88830 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2008 12:00:00 AM | 3x3 | Permit Number 51714 | 6015215.0 | 2104389.0 | 37.7591061085001 | -122.39042019055901 | (37.7591061085001, -122.390420190559) | |||
| 120690 | 120690 | 110630 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1050X MANDALAY LN | 1 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 5991857.0 | 2101850.0 | 37.7508112705894 | -122.47101756601101 | (37.7508112705894, -122.471017566011) | |||||
| 120847 | 120847 | 100625 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Folsom St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | |||||
| 120965 | 120965 | 97833 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
| 121043 | 121043 | 97838 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
| 121291 | 121291 | 47711 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 134 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45506 | 6002059.65562663 | 2096599.51529402 | 37.73697948454021 | -122.435360375218 | (37.7369794845402, -122.435360375218) | ||
| 121401 | 121401 | 109167 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||
| 121453 | 121453 | 40844 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 66 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41772 | 6003136.41051744 | 2107916.36050667 | 37.7681139569619 | -122.432445614329 | (37.7681139569619, -122.432445614329) | ||||
| 121897 | 121897 | 43393 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 621 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43136 | 6002378.82516016 | 2102060.30692007 | 37.7519916606466 | -122.434647227061 | (37.7519916606466, -122.434647227061) | ||
| 122353 | 122353 | 119718 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
| 122435 | 122435 | 119792 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
| 122930 | 122930 | 119817 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 123175 | 123175 | 44112 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1201 Treat Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.41274433750601 | (37.7509254812099, -122.412744337506) | |||
| 123916 | 123916 | 107053 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 450 Walnut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5998625.9783 | 2115075.11894 | 37.7875132600186 | -122.44856229739901 | (37.7875132600186, -122.448562297399) | |||||
| 124318 | 124318 | 107994 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4410x 23RD ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000358.0 | 2102265.0 | 37.7524387685866 | -122.441650202415 | (37.7524387685866, -122.441650202415) | ||||
| 124335 | 124335 | 55859 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 206 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2011 12:00:00 AM | 3x3 | Permit Number 56866 | 6005405.07087572 | 2102495.68659096 | 37.753358448125795 | -122.42421298063101 | (37.7533584481258, -122.424212980631) | ||
| 124457 | 124457 | 119717 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
| 124491 | 124491 | 50045 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3928 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 3x3 | Permit Number 46776 | 6003593.46976323 | 2102471.5753466 | 37.753189787602 | -122.430476153053 | (37.753189787602, -122.430476153053) | |
| 124709 | 124709 | 46505 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 165 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44676 | 6009030.30482136 | 2110979.07994252 | 37.7768559207247 | -122.41227567097201 | (37.7768559207247, -122.412275670972) | |||
| 125021 | 125021 | 38383 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3815-3817 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 769372 | 6003483.0 | 2105926.0 | 37.762668556023996 | -122.43110471906799 | (37.762668556024, -122.431104719068) | ||||
| 125148 | 125148 | 44267 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 315 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/2001 12:00:00 AM | Permit Number 43696 | 6009681.81388664 | 2099574.48898013 | 37.7455780401568 | -122.409216925278 | (37.7455780401568, -122.409216925278) | ||
| 125241 | 125241 | 112386 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2200 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999398.0 | 2116386.0 | 37.7911567075357 | -122.445985588475 | (37.7911567075357, -122.445985588475) | ||||
| 125502 | 125502 | 102669 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 4097 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001692.0 | 2105829.0 | 37.7623005659716 | -122.437292189744 | (37.7623005659716, -122.437292189744) | ||||
| 125787 | 125787 | 45653 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3001 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/2001 12:00:00 AM | Permit Number 44350 | 6000345.05114977 | 2116113.5186525 | 37.790462578374 | -122.442689257593 | (37.790462578374, -122.442689257593) | |||
| 125886 | 125886 | 119679 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x Octavia St Frontage East | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109501.0 | 6005733.0 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | |||||
| 126070 | 126070 | 109170 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||
| 126297 | 126297 | 39478 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2856 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 777203 | 5999897.32915775 | 2117456.37972289 | 37.7941241886563 | -122.44433488583 | (37.7941241886563, -122.44433488583) | |||
| 126618 | 126618 | 110786 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 410 PACIFIC AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012080.0 | 2118442.0 | 37.7975180016372 | -122.402250623365 | (37.7975180016372, -122.402250623365) | ||||
| 127319 | 127319 | 97269 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2050X Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769192 | 5999973.8 | 2116027.1 | 37.79020412496 | -122.443967546887 | (37.79020412496, -122.443967546887) | |||
| 127445 | 127445 | 66565 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 195 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | Permit Number 29754 | 6004459.66256991 | 2092267.48419115 | 37.725220702438996 | -122.426754065425 | (37.725220702439, -122.426754065425) | ||
| 127815 | 127815 | 119816 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 127974 | 127974 | 109434 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 7 DANVERS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999816.1 | 2105451.8 | 37.7611580492101 | -122.443753102957 | (37.7611580492101, -122.443753102957) | ||||
| 128093 | 128093 | 119709 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
| 128211 | 128211 | 41906 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 60 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42269 | 6003134.36765804 | 2107953.23072837 | 37.7682150777502 | -122.43245531412902 | (37.7682150777502, -122.432455314129) | ||
| 128433 | 128433 | 97271 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3099 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2011 12:00:00 AM | 3x3 | Permit Number 768129 | 5999886.0 | 2116055.0 | 37.790275722262 | -122.444273332996 | (37.790275722262, -122.444273332996) | ||
| 128474 | 128474 | 119819 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 128531 | 128531 | 119710 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
| 128748 | 128748 | 32533 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 70 Porter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37034 | 6006985.4956632005 | 2095516.38069521 | 37.7342839493681 | -122.418252734879 | (37.7342839493681, -122.418252734879) | ||
| 139301 | 139301 | 119823 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 139312 | 139312 | 97844 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
| 139825 | 139825 | 122420 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2200 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998886.0 | 2091075.0 | 37.7216297132481 | -122.44593585753599 | (37.7216297132481, -122.445935857536) | ||||
| 139941 | 139941 | 43412 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 854 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51843 | 6003073.74768147 | 2103234.41761238 | 37.7552549166143 | -122.43232793300301 | (37.7552549166143, -122.432327933003) | ||
| 139998 | 139998 | 38953 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3204 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1998 12:00:00 AM | Permit Number 40748 | 6008411.48904152 | 2100134.52641769 | 37.747044527767 | -122.41364913267701 | (37.747044527767, -122.413649132677) | |||
| 140165 | 140165 | 63730 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 531 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1987 12:00:00 AM | 3x3 | Permit Number 24397 | 6003608.14995212 | 2110143.86487572 | 37.7742568780009 | -122.430972913922 | (37.7742568780009, -122.430972913922) | |
| 140198 | 140198 | 97835 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
| 140480 | 140480 | 87306 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2895 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50315 | 6010124.3 | 2101560.9 | 37.751057068106206 | -122.40782691465401 | (37.7510570681062, -122.407826914654) | |||
| 141055 | 141055 | 57535 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 546 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1976 12:00:00 AM | 3x3 | Permit Number 16394 | 6007841.081538401 | 2104745.28982278 | 37.7596725902927 | -122.41594801607 | (37.7596725902927, -122.41594801607) | ||
| 141852 | 141852 | 97849 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
| 141876 | 141876 | 119711 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
| 142143 | 142143 | 119825 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 142180 | 142180 | 102452 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 546 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 16394 | 6007849.0 | 2104746.0 | 37.7596749854601 | -122.41592068026199 | (37.7596749854601, -122.415920680262) | |||
| 142355 | 142355 | 52726 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 169 ROOSEVELT Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2006 12:00:00 AM | Permit Number 48781 | 6001418.20285712 | 2107376.9010813 | 37.76653515331179 | -122.438350049909 | (37.7665351533118, -122.438350049909) | |||
| 142478 | 142478 | 109070 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3027 16TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006619.6 | 2106627.5 | 37.7647719501604 | -122.420306113631 | (37.7647719501604, -122.420306113631) | ||||
| 142684 | 142684 | 103276 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2800X Pine St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6000456.3 | 2114876.5 | 37.7870723881298 | -122.442215507279 | (37.7870723881298, -122.442215507279) | ||||
| 143024 | 143024 | 109165 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 51x OCTAVIA ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649005 | -122.42385688843399 | (37.772384002649, -122.423856888434) | ||||
| 143300 | 143300 | 49790 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2862 & YORK 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2003 12:00:00 AM | Permit Number 46574 | 6010228.54978873 | 2101669.78710325 | 37.7513618837191 | -122.40747408248001 | (37.7513618837191, -122.40747408248) | |||
| 143524 | 143524 | 88555 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 609 16th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51500 | 5990920.3 | 2111212.9 | 37.7764650666065 | -122.47494009298401 | (37.7764650666065, -122.474940092984) | |||
| 143710 | 143710 | 121499 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 851 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004400.0 | 2103913.0 | 37.757193256010204 | -122.427789705541 | (37.7571932560102, -122.427789705541) | ||||
| 143889 | 143889 | 119821 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 143969 | 143969 | 119822 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 144247 | 144247 | 113083 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 501x BURROWS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009864.0 | 2093047.0 | 37.7276651627155 | -122.408126678641 | (37.7276651627155, -122.408126678641) | ||||
| 144361 | 144361 | 43363 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4147 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43113 | 6002235.09605777 | 2101760.99319187 | 37.751161655763894 | -122.435122856595 | (37.7511616557639, -122.435122856595) | ||
| 144605 | 144605 | 119782 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
| 144741 | 144741 | 46506 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 165 08th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44676 | 6009030.30482136 | 2110979.07994252 | 37.7768559207247 | -122.41227567097201 | (37.7768559207247, -122.412275670972) | |||
| 144792 | 144792 | 99816 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 660-662 Elizabeth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | Most likely permitted for planting at same time as tree no. 1 | 6002127.0 | 2102089.0 | 37.7520561456392 | -122.435520126196 | (37.7520561456392, -122.435520126196) | |||
| 144802 | 144802 | 46912 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 455 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | ||
| 144933 | 144933 | 119701 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||
| 145037 | 145037 | 119787 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
| 145232 | 145232 | 119714 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
| 145818 | 145818 | 87304 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2895 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50315 | 6010124.3 | 2101560.9 | 37.751057068106206 | -122.40782691465401 | (37.7510570681062, -122.407826914654) | |||
| 145979 | 145979 | 100624 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Folsom St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | |||||
| 146012 | 146012 | 119781 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
| 146136 | 146136 | 37289 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 799 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39819 | 6002464.40667382 | 2103562.84638335 | 37.756122133683704 | -122.43445869367399 | (37.7561221336837, -122.434458693674) | |||
| 146217 | 146217 | 103270 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 350 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004879.0 | 2109882.0 | 37.773609787873895 | -122.426558160091 | (37.7736097878739, -122.426558160091) | ||||
| 219 | 219 | 138804 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2375 PINE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | Width 0ft | 6002587.4194 | 2115073.5588 | 37.787734687268795 | -122.43485641346001 | (37.7877346872688, -122.43485641346) | |||
| 849 | 849 | 93578 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 401X Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53401 | 6009309.6837 | 2121148.6264 | 37.8047947000965 | -122.41202806393 | (37.8047947000965, -122.41202806393) | |
| 22293 | 22293 | 242425 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1626 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009679.80342 | 2100181.3375 | 37.7472442001585 | -122.40926669339899 | (37.7472442001585, -122.409266693399) | |||
| 28346 | 28346 | 180535 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 430 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010393.23752 | 2092315.54751 | 37.7256863661069 | -122.406245574796 | (37.7256863661069, -122.406245574796) | |||
| 33554 | 33554 | 242643 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 952 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007376.06475 | 2101722.46593 | 37.7513464531926 | -122.417342064 | (37.7513464531926, -122.417342064) | |||
| 34482 | 34482 | 180537 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 430 Wayland St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010311.60374 | 2092285.69304 | 37.7255998252705 | -122.40652567494101 | (37.7255998252705, -122.406525674941) | |||
| 35835 | 35835 | 242642 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 952 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007375.48933 | 2101738.08123 | 37.751389296887396 | -122.41734516035801 | (37.7513892968874, -122.417345160358) | |||
| 36737 | 36737 | 53651 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 829 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/1969 12:00:00 AM | 1 | Permit Number 6587 | 6012068.4217 | 2112548.0645 | 37.7813340008977 | -122.401876160632 | (37.7813340008977, -122.401876160632) | ||
| 41264 | 41264 | 123153 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 506 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992845.37698 | 2111963.44852 | 37.7786372439018 | -122.46833537820801 | (37.7786372439018, -122.468335378208) | |||
| 42458 | 42458 | 242448 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1157 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5997336.0067 | 2106240.14847 | 37.7631808847241 | -122.452387528971 | (37.7631808847241, -122.452387528971) | |||
| 43571 | 43571 | 200600 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016471.5892 | 2094834.3971 | 37.7329407602926 | -122.385408441845 | (37.7329407602926, -122.385408441845) | |||
| 46120 | 46120 | 200598 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016502.2145 | 2094839.4314 | 37.732956277793896 | -122.385302911931 | (37.7329562777939, -122.385302911931) | |||
| 47795 | 47795 | 180536 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 430 Wayland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010343.05054 | 2092296.39853 | 37.725630979562794 | -122.40641771941401 | (37.7256309795628, -122.406417719414) | |||
| 49733 | 49733 | 198455 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 700 Mariposa St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 6014981.91793 | 2106268.05786 | 37.7642526625648 | -122.39135766342699 | (37.7642526625648, -122.391357663427) | |||
| 52466 | 52466 | 137648 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1399 MCALLISTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6002615.378 | 2111605.9586 | 37.7782151204473 | -122.434511650396 | (37.7782151204473, -122.434511650396) |
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");