Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1166 | 1166 | 251466 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 129 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008072.0 | 2112894.0 | 37.782060012266896 | -122.415726368353 | (37.7820600122669, -122.415726368353) | ||||
| 1187 | 1187 | 119794 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1213 | 1213 | 119747 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1219 | 1219 | 119829 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 10054 | 10054 | 173830 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1801 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000494.0 | 2114864.0 | 37.7870402148899 | -122.442084176412 | (37.7870402148899, -122.442084176412) | ||||
| 10157 | 10157 | 173899 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 1762 12th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 779465 | 5992511.90241 | 2103608.89481 | 37.7556785957656 | -122.468880856653 | (37.7556785957656, -122.468880856653) | |||
| 13945 | 13945 | 46285 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 18635 | 18635 | 102526 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 312 Walnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769739 | 5998624.0 | 2115422.5 | 37.7884669637257 | -122.448594170268 | (37.7884669637257, -122.448594170268) | |||
| 19810 | 19810 | 47528 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 277 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | Permit Number 45400 | 6004720.64686455 | 2100142.45310534 | 37.7468583456276 | -122.42641232227899 | (37.7468583456276, -122.426412322279) | ||
| 63412 | 63412 | 66733 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1133 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/1991 12:00:00 AM | Permit Number 29980 | 6008997.0 | 2116859.0 | 37.7929988993441 | -122.41280668476999 | (37.7929988993441, -122.41280668477) | |||
| 79112 | 79112 | 98464 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1999X Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005154.5 | 2116787.4 | 37.7925858789052 | -122.426096853469 | (37.7925858789052, -122.426096853469) | ||||
| 82092 | 82092 | 94046 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 42 Rivoli St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 53454 | 5998445.0 | 2106022.0 | 37.7626453762737 | -122.44853619655001 | (37.7626453762737, -122.44853619655) | ||||
| 84105 | 84105 | 103418 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 700X 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015432.6 | 2105817.0 | 37.7630391577767 | -122.389767361571 | (37.7630391577767, -122.389767361571) | ||||
| 84858 | 84858 | 103271 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 350 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004879.0 | 2109882.0 | 37.773609787873895 | -122.426558160091 | (37.7736097878739, -122.426558160091) | ||||
| 85133 | 85133 | 104447 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2490X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Rec/Park 7 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | |||
| 85473 | 85473 | 98928 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 112 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005385.0 | 2103055.0 | 37.7548930594212 | -122.42432216764401 | (37.7548930594212, -122.424322167644) | ||||
| 85972 | 85972 | 119818 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 86199 | 86199 | 111050 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1820 EDDY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001661.0 | 2112577.0 | 37.780827132241 | -122.437882755751 | (37.780827132241, -122.437882755751) | ||||
| 87858 | 87858 | 45651 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3001 Washington St | 2 | 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) | |||
| 90128 | 90128 | 49733 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2940REVISED Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2005 12:00:00 AM | Permit Number 46534 | 6008347.91771108 | 2101298.08089598 | 37.75023581813571 | -122.413951255275 | (37.7502358181357, -122.413951255275) | ||
| 93037 | 93037 | 87305 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2895 25th St | 2 | 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) | |||
| 93922 | 93922 | 119676 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x Octavia St Frontage East | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109501.0 | 6005733.0 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | |||||
| 95821 | 95821 | 36145 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2201 17th St | 2 | 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) | ||
| 98136 | 98136 | 101139 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 169 Buena Vista Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001425.0 | 2107346.2 | 37.7664512423305 | -122.438324340152 | (37.7664512423305, -122.438324340152) | ||||
| 100996 | 100996 | 99790 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 4140-4124 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Most likely planted when tree 1 was planted/permitted. | 6002271.0 | 2101809.0 | 37.751295509761206 | -122.435002130134 | (37.7512955097612, -122.435002130134) | |||
| 101393 | 101393 | 82620 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 262 Shotwell St | 2 | 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) | ||
| 106640 | 106640 | 98271 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | |
| 106821 | 106821 | 87287 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 131 Rivoli St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2007 12:00:00 AM | 3x3 | Permit Number 50304 | 5998096.0 | 2105951.0 | 37.762430467017204 | -122.44973813994801 | (37.7624304670172, -122.449738139948) | ||
| 107157 | 107157 | 110096 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 19 DANVERS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999798.2 | 2105476.6 | 37.7612251228861 | -122.443816792986 | (37.7612251228861, -122.443816792986) | ||||
| 110843 | 110843 | 46502 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 165 08th St | 2 | 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) | |||
| 113352 | 113352 | 107992 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4410x 23RD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000358.0 | 2102265.0 | 37.7524387685866 | -122.441650202415 | (37.7524387685866, -122.441650202415) | ||||
| 114456 | 114456 | 108481 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 195x 09TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993013.6 | 2114237.0 | 37.7848895119291 | -122.467918846049 | (37.7848895119291, -122.467918846049) | ||||
| 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) | ||
| 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) | ||
| 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) | |||||
| 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) | ||
| 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) | ||||
| 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) | |||
| 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) | |||||
| 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) | ||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||||
| 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) | |||
| 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) | |||
| 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) | |||
| 52888 | 52888 | 244411 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6005560.024 | 2110238.8403 | 37.7746280615118 | -122.424227776164 | (37.7746280615118, -122.424227776164) | |||
| 64606 | 64606 | 215486 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 25 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5994053.65956 | 2097702.19422 | 37.739549245488796 | -122.46312045374901 | (37.7395492454888, -122.463120453749) | |||
| 74042 | 74042 | 198453 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 700 Mariposa St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 6015012.52649 | 2106269.2143900003 | 37.7642575368696 | -122.39125187709499 | (37.7642575368696, -122.391251877095) | |||
| 96794 | 96794 | 137038 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1034 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009796.46818 | 2116817.7113799998 | 37.792930371678096 | -122.41003755358801 | (37.7929303716781, -122.410037553588) | |||
| 137947 | 137947 | 137646 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1399 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6002523.8866 | 2111593.3391 | 37.778175276442795 | -122.434827249536 | (37.7781752764428, -122.434827249536) | |||
| 146705 | 146705 | 91339 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 829 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52060 | 6012087.196 | 2112565.923 | 37.7813840839391 | -122.401812466037 | (37.7813840839391, -122.401812466037) | |
| 160672 | 160672 | 123129 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 758 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992907.031830001 | 2110299.16217 | 37.7740711235286 | -122.468001002791 | (37.7740711235286, -122.468001002791) | |||
| 173743 | 173743 | 200597 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016514.3807 | 2094844.0461 | 37.732969621897794 | -122.38526117126301 | (37.7329696218978, -122.385261171263) | |||
| 173944 | 173944 | 102277 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 316 Walnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2013 12:00:00 AM | 1 | 3x3 | Permit Number 776676 | 5998600.56179 | 2115376.04421 | 37.7883380681833 | -122.448671915192 | (37.7883380681833, -122.448671915192) | |
| 178117 | 178117 | 215490 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 45 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5994002.63682 | 2097564.4991099997 | 37.739168229725706 | -122.46328687779601 | (37.7391682297257, -122.463286877796) | |||
| 180271 | 180271 | 242380 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1217 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011151.17373 | 2102568.66425 | 37.75388160155921 | -122.404346786677 | (37.7538816015592, -122.404346786677) | |||
| 185344 | 185344 | 101909 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1801 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 1 | 3x3 | Permit Number 56808 | 6000521.0 | 2114812.0 | 37.786898975000206 | -122.44198702889099 | (37.7868989750002, -122.441987028891) | |
| 28071 | 28071 | 198653 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1670 Owen St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 8ft | 6014062.16151 | 2107274.8882299997 | 37.7669661078202 | -122.39460937273701 | (37.7669661078202, -122.394609372737) | |||
| 33491 | 33491 | 105218 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2100 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2014 12:00:00 AM | 2 | 3x3 | Permit Number 772439 | 5999896.69925 | 2116138.83336 | 37.790506517101996 | -122.44424234131701 | (37.790506517102, -122.444242341317) | |
| 45912 | 45912 | 242593 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 960 Elizabeth St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6000277.53945 | 2101991.5509200003 | 37.751683359019395 | -122.44190882273199 | (37.7516833590194, -122.441908822732) | |||
| 46920 | 46920 | 242576 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2019 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6008104.56596 | 2106730.31535 | 37.7651378220854 | -122.415177265415 | (37.7651378220854, -122.415177265415) | |||
| 64710 | 64710 | 242372 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 65 McCoppin St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6006293.4937 | 2109105.47321 | 37.7715574949158 | -122.42161004138201 | (37.7715574949158, -122.421610041382) | |||
| 69100 | 69100 | 242618 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 501 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007915.14616 | 2096519.82077 | 37.7370914621948 | -122.415109628301 | (37.7370914621948, -122.415109628301) | |||
| 74578 | 74578 | 215514 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 299 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993902.7407599995 | 2096288.82132 | 37.7356597801802 | -122.463539714991 | (37.7356597801802, -122.463539714991) | |||
| 76637 | 76637 | 242777 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 65 McCoppin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006292.544419999 | 2109106.4075 | 37.7715600067252 | -122.42161339136801 | (37.7715600067252, -122.421613391368) | |||
| 115943 | 115943 | 41185 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3440 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | 2 | Permit Number 41903 | 6001280.224090001 | 2120345.1134900004 | 37.8021346936235 | -122.439757137177 | (37.8021346936235, -122.439757137177) | |
| 125536 | 125536 | 75248 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 199X RUSS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/1995 12:00:00 AM | 2 | 5x5 | 6010421.0 | 2111456.0 | 37.7782433704481 | -122.407498444933 | (37.7782433704481, -122.407498444933) | ||
| 129887 | 129887 | 137641 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1317 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002837.2051 | 2111634.944 | 37.7783072968359 | -122.433746342282 | (37.7783072968359, -122.433746342282) | |||
| 865 | 865 | 142552 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 401 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6009334.5084 | 2121154.0569 | 37.804811003675105 | -122.411942539139 | (37.8048110036751, -122.411942539139) | |||
| 2753 | 2753 | 198672 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 193 Russ St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2017 12:00:00 AM | 3 | Width 4ft | 6010593.523440001 | 2111314.08538 | 37.777863361242105 | -122.406891615375 | (37.7778633612421, -122.406891615375) | ||
| 3293 | 3293 | 253393 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.163380001 | 2116767.09226 | 37.793068003154104 | -122.392879995147 | (37.7930680031541, -122.392879995147) | |
| 8667 | 8667 | 6037 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1822 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51912 | 6001625.9468 | 2112554.8978 | 37.7807644518495 | -122.43800243798 | (37.7807644518495, -122.43800243798) | |
| 13651 | 13651 | 85765 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1350 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008925.8803 | 2109636.8219 | 37.773164535944794 | -122.412542002878 | (37.7731645359448, -122.412542002878) | ||
| 13679 | 13679 | 100568 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 868 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6011788.1802 | 2112369.4793 | 37.780828003664 | -122.40283310111 | (37.780828003664, -122.40283310111) | |||
| 15022 | 15022 | 85767 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1400X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008747.4583 | 2109466.0696 | 37.7726856753072 | -122.41314711365 | (37.7726856753072, -122.41314711365) | ||
| 15618 | 15618 | 49607 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1245 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/13/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46474 | 6009479.3313 | 2110073.508 | 37.7743946188288 | -122.41065838012199 | (37.7743946188288, -122.410658380122) | |
| 15993 | 15993 | 85779 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1301 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009155.5683 | 2109764.3815 | 37.7735276724734 | -122.411756494108 | (37.7735276724734, -122.411756494108) | ||
| 16241 | 16241 | 91032 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010616.6864 | 2111159.8673 | 37.777441210433395 | -122.40680061468099 | (37.7774412104334, -122.406800614681) | ||
| 16370 | 16370 | 85856 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1530 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/2007 12:00:00 AM | 3 | 3x3 | 6008268.3583 | 2108979.6799 | 37.7713232557148 | -122.414769948978 | (37.7713232557148, -122.414769948978) | ||
| 19439 | 19439 | 28789 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2948 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2005 12:00:00 AM | 3 | 3X3 | 6008341.65854 | 2101291.24867 | 37.7502167068411 | -122.413972416691 | (37.7502167068411, -122.413972416691) | ||
| 21769 | 21769 | 16666 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 221 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/2011 12:00:00 AM | 3 | 3x3 | 6002922.68979 | 2106990.55693 | 37.765559804667795 | -122.433118695273 | (37.7655598046678, -122.433118695273) | ||
| 28099 | 28099 | 215484 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 21 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994076.92667 | 2097749.04597 | 37.739679229001496 | -122.46304340523001 | (37.7396792290015, -122.46304340523) | |||
| 29756 | 29756 | 215492 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 51 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993992.82093 | 2097521.50716 | 37.7390496190449 | -122.463317697564 | (37.7390496190449, -122.463317697564) | |||
| 35801 | 35801 | 215481 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994138.58821 | 2097841.54459 | 37.739936758872204 | -122.462836916405 | (37.7399367588722, -122.462836916405) | |||
| 37359 | 37359 | 215483 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 15 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994103.6572 | 2097790.09327 | 37.7397934743851 | -122.46295396047199 | (37.7397934743851, -122.462953960472) | |||
| 38137 | 38137 | 215538 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 66 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993953.054409999 | 2097475.42453 | 37.7389207965449 | -122.46345184763099 | (37.7389207965449, -122.463451847631) | |||
| 39846 | 39846 | 215499 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 95 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993991.18061 | 2097202.58443 | 37.738173842158105 | -122.463300232714 | (37.7381738421581, -122.463300232714) | |||
| 44742 | 44742 | 242652 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3000 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008156.87446 | 2103306.51725 | 37.7557397987621 | -122.414754018381 | (37.7557397987621, -122.414754018381) | |||
| 47189 | 47189 | 215569 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 262 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993829.85654 | 2096316.71457 | 37.735732168414 | -122.46379372579901 | (37.735732168414, -122.463793725799) | |||
| 53086 | 53086 | 198690 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 52 Dore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6008856.64566 | 2109825.7938 | 37.7736795226325 | -122.41279485791 | (37.7736795226325, -122.41279485791) | |||
| 53307 | 53307 | 242547 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2470 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008189.29085 | 2104062.2269099997 | 37.75781662655471 | -122.41469538979601 | (37.7578166265547, -122.414695389796) | |||
| 55611 | 55611 | 198674 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 169 Russ St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6010536.5691599995 | 2111353.45515 | 37.7779682743635 | -122.407091416859 | (37.7779682743635, -122.407091416859) | |||
| 56784 | 56784 | 242451 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 131 Rivoli St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5998061.5561 | 2105942.80556 | 37.7624059964569 | -122.449856677554 | (37.7624059964569, -122.449856677554) | |||
| 62540 | 62540 | 32997 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013196.81609 | 2113721.08426 | 37.784617751847 | -122.39805475731501 | (37.784617751847, -122.398054757315) | |
| 63083 | 63083 | 198599 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1050 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013108.22745 | 2107111.70363 | 37.7664649588148 | -122.397897454223 | (37.7664649588148, -122.397897454223) | |||
| 65668 | 65668 | 142251 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 471 LINDEN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6005162.3875 | 2110758.8534 | 37.7760334306508 | -122.42564029951599 | (37.7760334306508, -122.425640299516) |
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");