Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 9789 | 9789 | 91811 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2685 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2016 02:45:00 PM | 3 | 3x3 | 6008942.770855 | 2102838.050886 | 37.754497621185 | -122.412003022866 | (37.754497621185, -122.412003022866) | ||
| 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) | |||
| 174601 | 174601 | 31036 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 300 Bennington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/2015 12:00:00 AM | 2 | Permit Number 771782 | 6007053.24421 | 2096706.03657 | 37.737554295604895 | -122.41810281760901 | (37.7375542956049, -122.418102817609) | ||
| 105003 | 105003 | 13321 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 435X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/1997 12:00:00 AM | 5 | 3X3 | 6002797.38385 | 2090943.99635 | 37.7214925769985 | -122.432405907456 | (37.7214925769985, -122.432405907456) | ||
| 23315 | 23315 | 16418 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1390X Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/1992 12:00:00 AM | 13 | 3x3 | 6016308.5496 | 2094919.7628 | 37.7331661358215 | -122.385978065712 | (37.7331661358215, -122.385978065712) | ||
| 83647 | 83647 | 16426 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1390X Newcomb Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2007 12:00:00 AM | 12 | 3x3 | 6016278.2308330005 | 2094877.1898669999 | 37.733047561100896 | -122.386079920066 | (37.7330475611009, -122.386079920066) | ||
| 133033 | 133033 | 34578 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3300 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2012 12:00:00 AM | 3 | Permit Number 769651 | 5998982.19825 | 2115648.46298 | 37.789107873481 | -122.44737113578998 | (37.789107873481, -122.44737113579) | ||
| 21399 | 21399 | 7615 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3215 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/16/2014 02:11:00 PM | 3 | 3x3 | 6008475.32345 | 2099918.5016 | 37.7464549560373 | -122.413413122941 | (37.7464549560373, -122.413413122941) | ||
| 9589 | 9589 | 9765 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 827X Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6000964.4329 | 2111657.6469 | 37.778263187688296 | -122.440226567073 | (37.7782631876883, -122.440226567073) | ||
| 15989 | 15989 | 7405 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1065 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/1998 12:00:00 AM | 6 | 3X3 | 6010535.4473 | 2111084.5056 | 37.7772297388865 | -122.407076335552 | (37.7772297388865, -122.407076335552) | ||
| 17424 | 17424 | 7562 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2924 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2013 12:00:00 AM | 3 | 5x5 | 6008336.41396 | 2101367.26054 | 37.7504251238168 | -122.41399592947201 | (37.7504251238168, -122.413995929472) | ||
| 127611 | 127611 | 33762 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1800X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 5 | 3x3 | Permit Number 37814 | 6003491.84820405 | 2114902.28438826 | 37.7873157193536 | -122.431715030855 | (37.7873157193536, -122.431715030855) | |
| 95164 | 95164 | 101950 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 09th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 11 | 3x3 | Permit Number 769636 | 6008537.0 | 2110562.0 | 37.775683024565296 | -122.413952655551 | (37.7756830245653, -122.413952655551) | |
| 102013 | 102013 | 101949 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 10 | 3x3 | Permit Number 769636 | 6008537.0 | 2110562.0 | 37.775683024565296 | -122.413952655551 | (37.7756830245653, -122.413952655551) | |
| 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) | |
| 109035 | 109035 | 57076 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 980 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 18 | 3x3 | Permit Number 767819 | 6015234.40756552 | 2104029.6701639 | 37.7581205423321 | -122.39032796374501 | (37.7581205423321, -122.390327963745) | |
| 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) | ||
| 92898 | 92898 | 47527 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 277 27th St | 1 | 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) | ||
| 82532 | 82532 | 35613 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2839 Pacific Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768494 | 6000560.21131744 | 2116797.97814823 | 37.7923541883271 | -122.44199396863998 | (37.7923541883271, -122.44199396864) | |
| 17682 | 17682 | 23641 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 131 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/1997 12:00:00 AM | 10 | 3X3 | 6006567.62834 | 2098529.44793 | 37.742533631335604 | -122.419911178867 | (37.7425336313356, -122.419911178867) | ||
| 18588 | 18588 | 26273 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 230 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/1997 12:00:00 AM | 9 | 3X3 | 6006790.8897400005 | 2098369.36034 | 37.742106642199005 | -122.41912785229499 | (37.742106642199, -122.419127852295) | ||
| 21661 | 21661 | 23640 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 125 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/1997 12:00:00 AM | 12 | 3X3 | 6006550.3772 | 2098540.77805 | 37.7425637693939 | -122.41997163218299 | (37.7425637693939, -122.419971632183) | ||
| 108477 | 108477 | 45798 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 880 Clipper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2001 12:00:00 AM | Permit Number 44433 | 5999675.79411068 | 2100284.35240189 | 37.7469614974882 | -122.44386708589701 | (37.7469614974882, -122.443867085897) | |||
| 95763 | 95763 | 33602 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 200X Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1996 12:00:00 AM | 9 | Permit Number 37716 | 6006727.64769195 | 2098397.31693347 | 37.7421798430719 | -122.419348506645 | (37.7421798430719, -122.419348506645) | ||
| 17647 | 17647 | 7645 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3299 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2008 12:00:00 AM | 3 | 4x4 | 6008510.32989 | 2099428.74367 | 37.74511215491329 | -122.41325744669201 | (37.7451121549133, -122.413257446692) | ||
| 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) | |
| 82805 | 82805 | 44113 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1201 Treat Ave | 4 | 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) | |||
| 91822 | 91822 | 44116 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1201 Treat Ave | 1 | 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) | |||
| 102982 | 102982 | 44114 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1201 Treat Ave | 3 | 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) | |||
| 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) | |||
| 29948 | 29948 | 55354 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 601 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1972 12:00:00 AM | 10 | 3x3 | Permit Number 11287 | 5993641.36369 | 2113466.98214 | 37.782811483217 | -122.46569104074301 | (37.782811483217, -122.465691040743) | |
| 7586 | 7586 | 48883 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1515 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2002 12:00:00 AM | 4 | 5x4 | Permit Number 46089 | 6000106.0163 | 2114246.8974 | 37.7853236932557 | -122.44338216691901 | (37.7853236932557, -122.443382166919) | |
| 19327 | 19327 | 7658 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3335 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2010 12:00:00 AM | 3 | 3x3 | 6008522.8365 | 2099251.39925 | 37.7446259085611 | -122.41320166263 | (37.7446259085611, -122.41320166263) | ||
| 13722 | 13722 | 91035 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010666.0508 | 2111208.1223 | 37.7775764693736 | -122.40663324749599 | (37.7775764693736, -122.406633247496) | ||
| 14760 | 14760 | 91037 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010705.7086 | 2111246.6708 | 37.7776845332645 | -122.40649877417499 | (37.7776845332645, -122.406498774175) | ||
| 15087 | 15087 | 91034 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010653.2937 | 2111194.8106 | 37.7775392048064 | -122.406676440472 | (37.7775392048064, -122.406676440472) | ||
| 15203 | 15203 | 91033 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010628.8889 | 2111172.6244 | 37.777476921213605 | -122.40675930128401 | (37.7774769212136, -122.406759301284) | ||
| 15284 | 15284 | 91036 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010688.5143 | 2111227.8126 | 37.7776317911098 | -122.406556926191 | (37.7776317911098, -122.406556926191) | ||
| 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) | ||
| 32202 | 32202 | 91031 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010606.147999999 | 2111149.8835 | 37.7774132075868 | -122.406836366848 | (37.7774132075868, -122.406836366848) | ||
| 97148 | 97148 | 17813 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1900X Pine St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2012 12:00:00 AM | 4 | 3x3 | 6004830.0574482 | 2115432.8862429 | 37.7888483829176 | -122.427122914168 | (37.7888483829176, -122.427122914168) | ||
| 103257 | 103257 | 17810 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1900X Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2012 12:00:00 AM | 4 | 3X3 | 6004830.0574482 | 2115432.8862429 | 37.7888483829176 | -122.427122914168 | (37.7888483829176, -122.427122914168) | ||
| 70270 | 70270 | 48869 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 375 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2002 12:00:00 AM | 23 | Permit Number 46077 | 6013801.17849 | 2105352.33133 | 37.7616726766835 | -122.39537738027501 | (37.7616726766835, -122.395377380275) | ||
| 8034 | 8034 | 17992 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2619 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/2012 12:00:00 AM | 3 | 3X3 | 6001295.2434 | 2114888.6615 | 37.787153557687795 | -122.439313827621 | (37.7871535576878, -122.439313827621) | ||
| 147738 | 147738 | 33318 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2604 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 8 | Permit Number 37462 | 6004913.93801 | 2118560.0081599997 | 37.7974394114518 | -122.42705551819401 | (37.7974394114518, -122.427055518194) | |
| 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) | |||
| 172287 | 172287 | 56515 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1200 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1978 12:00:00 AM | 10 | Permit Number 17376 | 6008990.48315 | 2116704.87455 | 37.7925753427324 | -122.412818332001 | (37.7925753427324, -122.412818332001) | ||
| 156352 | 156352 | 83476 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 674-680 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 7 | 6015406.08252 | 2105913.749 | 37.763303339101 | -122.38986583564301 | (37.763303339101, -122.389865835643) | ||
| 143378 | 143378 | 23638 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 118 VIRGINIA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 12 | 4x4 | Permit Number 776560 | 6006594.0 | 2098480.0 | 37.7423993441016 | -122.41981648533199 | (37.7423993441016, -122.419816485332) | |
| 5079 | 5079 | 137895 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1944 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2017 12:00:00 AM | 3 | Width 0ft | 6003925.565 | 2115178.3301 | 37.788098246385395 | -122.430234163647 | (37.7880982463854, -122.430234163647) | ||
| 151264 | 151264 | 44079 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 172 Russ St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2000 12:00:00 AM | 4 | Permit Number 43600 | 6010499.79752 | 2111352.59578 | 37.777963856872795 | -122.40721856300699 | (37.7779638568728, -122.407218563007) | ||
| 28795 | 28795 | 33125 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2380 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 13 | 6x7 | Permit Number 37358 | 6001538.52427 | 2119069.35252 | 37.7986464896046 | -122.43877182467699 | (37.7986464896046, -122.438771824677) |
| 162741 | 162741 | 33151 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2434 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 7 | Permit Number 37374 | 5987066.8878 | 2098694.8228 | 37.741869787152204 | -122.487350256926 | (37.7418697871522, -122.487350256926) | |
| 181708 | 181708 | 33124 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2380 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 12 | 6x6 | Permit Number 37358 | 6001499.40758 | 2119065.9057400003 | 37.7986348002003 | -122.438906933417 | (37.7986348002003, -122.438906933417) |
| 52546 | 52546 | 68218 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 233 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/2010 12:00:00 AM | 4 | Permit Number 53885 | 5990842.3093 | 2113821.7941400004 | 37.7836238495535 | -122.475400406913 | (37.7836238495535, -122.475400406913) | |
| 141515 | 141515 | 68693 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 600 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 12 | 3x3 | Permit Number 32603 | 5993650.82821 | 2113525.7859099996 | 37.7829734883164 | -122.46566257132 | (37.7829734883164, -122.46566257132) |
| 20352 | 20352 | 14598 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1247 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2016 12:00:00 AM | 45 | 3X3 | 5999428.6068 | 2108510.475 | 37.7695342955042 | -122.445313195872 | (37.7695342955042, -122.445313195872) | ||
| 35199 | 35199 | 32994 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013107.849280001 | 2113632.60044 | 37.7843698402516 | -122.398356344087 | (37.7843698402516, -122.398356344087) | |
| 39927 | 39927 | 32998 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013208.8867 | 2113734.0736 | 37.784654089848296 | -122.398013908317 | (37.7846540898483, -122.398013908317) | |
| 45247 | 45247 | 32993 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013060.48706 | 2113590.00605 | 37.7842502474912 | -122.398517212115 | (37.7842502474912, -122.398517212115) | |
| 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) | |
| 150713 | 150713 | 32996 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013182.022469999 | 2113705.96324 | 37.7845754090665 | -122.398104877431 | (37.7845754090665, -122.398104877431) | |
| 166094 | 166094 | 32995 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 4 | Permit Number 37299 | 6013130.33001 | 2113657.2659299998 | 37.7844388182424 | -122.39828029921499 | (37.7844388182424, -122.398280299215) | |
| 188652 | 188652 | 32989 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013088.2865 | 2113616.3325900002 | 37.784324082736795 | -122.398422883105 | (37.7843240827368, -122.398422883105) | |
| 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) | |
| 185553 | 185553 | 53481 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2201 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/1969 12:00:00 AM | 8 | Permit Number 6390 | 6002979.07126 | 2117470.0427 | 37.794337047177294 | -122.433672716337 | (37.7943370471773, -122.433672716337) | ||
| 101977 | 101977 | 26771 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2605X Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/30/2013 12:00:00 AM | 3 | 3x3 | 6001478.3944063 | 2114917.2732237 | 37.7872425389418 | -122.43868221732001 | (37.7872425389418, -122.43868221732) | ||
| 37105 | 37105 | 51255 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2485 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2006 12:00:00 AM | 8 | Permit Number 49056 | 6001759.16032 | 2117307.5117200003 | 37.7938214847188 | -122.437882095676 | (37.7938214847188, -122.437882095676) | ||
| 47292 | 47292 | 54971 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 558 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1974 12:00:00 AM | 14 | Permit Number 14440 | 5993167.14361 | 2111676.4715400003 | 37.7778678620954 | -122.467201401573 | (37.7778678620954, -122.467201401573) | ||
| 26322 | 26322 | 97267 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2050X Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769192 | 5999912.27224 | 2116008.29642 | 37.7901489853223 | -122.44417907581301 | (37.7901489853223, -122.444179075813) | |
| 15335 | 15335 | 57068 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 918 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 15 | 6x7 | Permit Number 14334 | 6015212.77238 | 2104346.7451400002 | 37.7589899621477 | -122.390424942382 | (37.7589899621477, -122.390424942382) | |
| 16040 | 16040 | 57074 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 966 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 24 | 9x7.5 | Permit Number 14341 | 6015226.17172 | 2104099.64367 | 37.7583122177548 | -122.39036133601101 | (37.7583122177548, -122.390361336011) | |
| 34666 | 34666 | 57073 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 958 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 17 | Permit Number 14340 | 6015221.7654 | 2104138.81007 | 37.758419515877705 | -122.390379311651 | (37.7584195158777, -122.390379311651) | ||
| 41952 | 41952 | 51434 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 277 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2004 12:00:00 AM | 9 | Permit Number 47754 | 6002446.43605 | 2092096.42043 | 37.724636968819205 | -122.433701359735 | (37.7246369688192, -122.433701359735) | ||
| 117959 | 117959 | 52081 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 477 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2005 12:00:00 AM | Permit Number 48278 | 5998529.03039776 | 2106418.21564482 | 37.763738089155105 | -122.448274099423 | (37.7637380891551, -122.448274099423) | |||
| 88869 | 88869 | 32534 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 70 Porter St | 3 | 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) | ||
| 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) | ||
| 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) | ||
| 126904 | 126904 | 101710 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 990 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2016 12:00:00 AM | 3 | 3x3 | 6011874.0 | 2103773.0 | 37.7572288087602 | -122.40193172517901 | (37.7572288087602, -122.401931725179) | ||
| 172012 | 172012 | 49872 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1918 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2007 12:00:00 AM | 6 | 3x3 | Permit Number 49768 | 6003420.3009 | 2115360.353 | 37.7885694038243 | -122.431995291423 | (37.7885694038243, -122.431995291423) | |
| 71363 | 71363 | 32451 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4444 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 14 | Permit Number 36969 | 5999681.89649 | 2105763.6737900004 | 37.7620067217593 | -122.444239665821 | (37.7620067217593, -122.444239665821) | |
| 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) | ||
| 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) | ||
| 153324 | 153324 | 67600 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 555 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1992 12:00:00 AM | 10 | Permit Number 31170 | 6013571.5238 | 2104494.52261 | 37.7593045458768 | -122.39611154992599 | (37.7593045458768, -122.396111549926) | |
| 19037 | 19037 | 7013 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1031 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1997 12:00:00 AM | 8 | 3X3 | 6002426.7807 | 2110189.6116 | 37.774315477420295 | -122.435062751747 | (37.7743154774203, -122.435062751747) | ||
| 132309 | 132309 | 89024 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2724 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2008 12:00:00 AM | 4 | 4x4 | Permit Number 51769 | 6000900.18903 | 2116892.91159 | 37.7926342186313 | -122.440824453501 | (37.7926342186313, -122.440824453501) | |
| 14093 | 14093 | 97435 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 6016490.8874 | 2094837.7533 | 37.732951043415206 | -122.385341956131 | (37.7329510434152, -122.385341956131) | |||
| 16597 | 16597 | 97225 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1301X Newcomb Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016649.85073 | 2094946.9135099999 | 37.7332595687675 | -122.38479997523599 | (37.7332595687675, -122.384799975236) | ||
| 141737 | 141737 | 97434 | Ulmus parvifolia :: Chinese Elm 46 | 1380x Newcomb Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 6016360.63733 | 2094893.94179 | 37.7330981190079 | -122.38579618360501 | (37.7330981190079, -122.385796183605) | ||||
| 116642 | 116642 | 34293 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2868 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/28/2002 12:00:00 AM | 7 | Permit Number 45961 | 6010202.37211243 | 2101668.36098933 | 37.7513565026505 | -122.407564507802 | (37.7513565026505, -122.407564507802) | |
| 160202 | 160202 | 88993 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 680 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51742 | 6013040.85329 | 2113568.29514 | 37.784189540547295 | -122.398583614443 | (37.7841895405473, -122.398583614443) | |
| 180765 | 180765 | 88994 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 680 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51742 | 6013026.737980001 | 2113549.67814 | 37.784137636178 | -122.39863114183201 | (37.784137636178, -122.398631141832) | |
| 17654 | 17654 | 7660 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3340 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/23/2015 01:35:00 PM | 3 | 4x4 | 6008461.083190001 | 2099185.41304 | 37.744441257954705 | -122.41341052839701 | (37.7444412579547, -122.413410528397) | ||
| 101334 | 101334 | 86696 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 248 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/21/2007 12:00:00 AM | Permit Number 49695 | 6006131.0 | 2101708.4 | 37.7512377023769 | -122.42164664917601 | (37.7512377023769, -122.421646649176) | |||
| 46651 | 46651 | 55949 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2814 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/20/1989 12:00:00 AM | 3 | Permit Number 28156 | 5999490.08281 | 2118090.45953 | 37.7958419601055 | -122.44578961952101 | (37.7958419601055, -122.445789619521) | ||
| 47159 | 47159 | 74944 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2233 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 4 | 6010701.03805 | 2106443.01503 | 37.7644945370101 | -122.40617641152201 | (37.7644945370101, -122.406176411522) | ||
| 63175 | 63175 | 74494 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2233 17th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 5 | 6010764.33667 | 2106446.7054 | 37.7645082103165 | -122.40595773775699 | (37.7645082103165, -122.405957737757) | ||
| 70239 | 70239 | 74649 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2233 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 4 | 6010746.42629 | 2106444.22464 | 37.76450039699821 | -122.406019510419 | (37.7645003969982, -122.406019510419) | ||
| 134625 | 134625 | 54984 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 609 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 5 | Permit Number 10862 | 5990934.1509 | 2111213.50842 | 37.7764675398398 | -122.474892223692 | (37.7764675398398, -122.474892223692) |
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");