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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 159494 | 159494 | 53398 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1221 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1972 12:00:00 AM | 9 | Permit Number 9833 | 6008515.21769 | 2116802.84208 | 37.7928176497632 | -122.414469707612 | (37.7928176497632, -122.414469707612) | ||
| 85923 | 85923 | 53738 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 660-662 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/1972 12:00:00 AM | 4x4 | Permit Number 9418 | 6002127.0 | 2102089.0 | 37.7520561456392 | -122.435520126196 | (37.7520561456392, -122.435520126196) | ||
| 102907 | 102907 | 53737 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 656-658 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/1972 12:00:00 AM | 17 | Permit Number 9417 | 6002154.67978797 | 2102100.23729555 | 37.7520885726312 | -122.435425209305 | (37.7520885726312, -122.435425209305) | ||
| 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) | |||
| 10163 | 10163 | 173898 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 1762 12th Ave | 1 | 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) | |||
| 97695 | 97695 | 117445 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 403 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 778578 | 6009365.1 | 2121160.8 | 37.8048312347901 | -122.411837150077 | (37.8048312347901, -122.411837150077) | ||
| 154216 | 154216 | 117051 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1827 SCOTT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 4x4 | Permit Number 778308 | 6001498.0 | 2114739.0 | 37.786754161797106 | -122.43860160783599 | (37.7867541617971, -122.438601607836) | ||
| 333 | 333 | 242579 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 818 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2016 12:00:00 AM | 11 | Width 3ft | Permit Number 778239 | 6001257.943419999 | 2101462.97247 | 37.7502878270446 | -122.438480597209 | (37.7502878270446, -122.438480597209) | |
| 94618 | 94618 | 116954 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 818 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778239 | 6001245.0 | 2101454.0 | 37.7502624545247 | -122.43852471352 | (37.7502624545247, -122.43852471352) | |
| 977 | 977 | 242613 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 48 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | Permit Number 777782 | 6007306.44134 | 2099195.30791 | 37.744403529591395 | -122.417403753004 | (37.7444035295914, -122.417403753004) | ||
| 103581 | 103581 | 116355 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 148 28TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777724 | 6004916.0 | 2099631.0 | 37.7454650539376 | -122.425700412207 | (37.7454650539376, -122.425700412207) | |
| 92745 | 92745 | 95635 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 111X 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777379 | 6007972.0 | 2107962.0 | 37.76851228983521 | -122.415722998498 | (37.7685122898352, -122.415722998498) | |
| 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) | |||
| 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) | |
| 20985 | 20985 | 87685 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 118 Virginia Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2008 12:00:00 AM | 4x4 | Permit Number 776560 | 6006594.8 | 2098480.6 | 37.7424010366351 | -122.419813761733 | (37.7424010366351, -122.419813761733) | |||
| 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) | |
| 140609 | 140609 | 121251 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 4151 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | Permit Number 776206 | 6001358.0 | 2105811.0 | 37.762232149605 | -122.43844607836701 | (37.762232149605, -122.438446078367) | ||
| 107475 | 107475 | 110612 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 15 MAGELLAN AVE | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775412 | 5994586.0 | 2101167.0 | 37.7490933856104 | -122.46153099469801 | (37.7490933856104, -122.461530994698) | ||
| 81580 | 81580 | 97846 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2015 12:00:00 AM | 3 | Permit Number 775024 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | ||
| 81162 | 81162 | 89025 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2724 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774819 | 6000906.5 | 2116912.2 | 37.792687538981205 | -122.440804001611 | (37.7926875389812, -122.440804001611) | |
| 5267 | 5267 | 62038 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2015 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2015 12:00:00 AM | 3 | Permit Number 773957 | 6000922.27992 | 2115385.7995599997 | 37.788497339028204 | -122.440639868553 | (37.7884973390282, -122.440639868553) | ||
| 121063 | 121063 | 16605 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 101 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2014 12:00:00 AM | 18 | 3X3 | Permit Number 773154 | 6002878.7558281 | 2107677.2386141997 | 37.7674427729111 | -122.433319725194 | (37.7674427729111, -122.433319725194) | |
| 19559 | 19559 | 106645 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 4421 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | Permit Number 772901 | 6001633.7 | 2104049.1 | 37.75741007891521 | -122.437366369677 | (37.7574100789152, -122.437366369677) | |||
| 9754 | 9754 | 25175 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3066 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 9x9 | Permit Number 772559 | 6000144.4461106 | 2105441.7794376 | 37.7611492576992 | -122.44261677830299 | (37.7611492576992, -122.442616778303) | ||
| 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) | |
| 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) | ||
| 3289 | 3289 | 253392 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 1 | 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) | |
| 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) | |
| 3316 | 3316 | 253394 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 3 | 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) | |
| 103898 | 103898 | 96758 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 54 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2014 12:00:00 AM | 24 | 4x4 | Permit Number 771133 | 5994277.344819999 | 2115214.0458299997 | 37.7876451092051 | -122.46361766617201 | (37.7876451092051, -122.463617666172) | |
| 176776 | 176776 | 105953 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 54 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2014 12:00:00 AM | 4 | Permit Number 771133 | 5994277.8794 | 2115232.96253 | 37.7876970801078 | -122.463617190077 | (37.7876970801078, -122.463617190077) | ||
| 107374 | 107374 | 103379 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 2712 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2013 12:00:00 AM | 4 | 3x3 | Permit Number 770136 | 6000520.0 | 2117210.0 | 37.793483200790895 | -122.44216269001001 | (37.7934832007909, -122.44216269001) | |
| 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) | |||
| 109027 | 109027 | 47022 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 340 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/28/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769670 | 6004925.00265887 | 2109895.52879881 | 37.7736495352098 | -122.426399993288 | (37.7736495352098, -122.426399993288) |
| 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) | ||
| 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) | |
| 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) | ||||
| 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) | |
| 27973 | 27973 | 97268 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2050X Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | Permit Number 769192 | 5999910.90621 | 2116024.41622 | 37.7901931681384 | -122.44418496098 | (37.7901931681384, -122.44418496098) | ||
| 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) | |||
| 459 | 459 | 35612 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2839 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2012 12:00:00 AM | 5 | 3x3 | Permit Number 768882 | 6000549.03074 | 2116799.12347 | 37.792356695946005 | -122.442032735847 | (37.792356695946, -122.442032735847) | |
| 179887 | 179887 | 98993 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1919 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768862 | 6003810.0 | 2118645.0 | 37.7976102909597 | -122.430881499482 | (37.7976102909597, -122.430881499482) | |
| 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) | |
| 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) | |
| 107595 | 107595 | 98272 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 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) | ||
| 109285 | 109285 | 98270 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | witin landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | |
| 118014 | 118014 | 98273 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 4 | 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) | |
| 98911 | 98911 | 97270 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3099 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2011 12:00:00 AM | 3x3 | Permit Number 768129 | 5999976.0 | 2116041.4 | 37.7902435145098 | -122.443960962963 | (37.7902435145098, -122.443960962963) | ||
| 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) | ||
| 167125 | 167125 | 97272 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3099 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768129 | 5999961.63318 | 2116061.04996 | 37.790296648615495 | -122.444012083414 | (37.7902966486155, -122.444012083414) | |
| 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) | |
| 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) | ||
| 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) | ||
| 75118 | 75118 | 53259 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 210 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1969 12:00:00 AM | 15 | Permit Number 6149 | 5997600.12702 | 2115607.0052799997 | 37.7889149689082 | -122.452149910107 | (37.7889149689082, -122.452149910107) | ||
| 16004 | 16004 | 30372 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 498x Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/1956 12:00:00 AM | 10 | 3x3 | Permit Number 60 | 6012938.59384 | 2104777.04886 | 37.760045064747295 | -122.39832036668999 | (37.7600450647473, -122.39832036669) | |
| 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) | ||
| 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) | |
| 120654 | 120654 | 102761 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 100X Russ St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2013 12:00:00 AM | 3 | 3x3 | Permit Number 54619 | 6010215.5 | 2111581.3 | 37.7785759102049 | -122.40821818771099 | (37.7785759102049, -122.408218187711) |
| 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) | |
| 64971 | 64971 | 94464 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 894 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53682 | 6011686.524 | 2112270.5705 | 37.780550746456896 | -122.403177821901 | (37.7805507464569, -122.403177821901) | |
| 29761 | 29761 | 94343 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 735 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53631 | 6009320.52267 | 2110260.04995 | 37.774897914235794 | -122.41122091122101 | (37.7748979142358, -122.411220911221) | |
| 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) | ||||
| 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) | |
| 129283 | 129283 | 52300 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 264 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53169 | 6001736.20846819 | 2104306.03679934 | 37.758121392277005 | -122.437030249981 | (37.758121392277, -122.437030249981) | |
| 96105 | 96105 | 92521 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1350 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6009005.0 | 2109688.0 | 37.773309499001996 | -122.412271934387 | (37.773309499002, -122.412271934387) | ||
| 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) | ||
| 56384 | 56384 | 83010 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 507 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52387 | 6011806.26016 | 2105993.89934 | 37.763323124185 | -122.402322147448 | (37.763323124185, -122.402322147448) | |
| 36571 | 36571 | 83024 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1209 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52375 | 6013948.88284 | 2105690.7354200003 | 37.762610074220206 | -122.39489022832399 | (37.7626100742202, -122.394890228324) | |
| 166749 | 166749 | 81876 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1209 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52375 | 6013966.08986 | 2105691.70822 | 37.762613702073004 | -122.394830783137 | (37.762613702073, -122.394830783137) | |
| 146841 | 146841 | 83229 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1169 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52333 | 6005183.33361 | 2120915.83626 | 37.8039231412044 | -122.426291152916 | (37.8039231412044, -122.426291152916) | |
| 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) | ||
| 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) | ||
| 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) | |||
| 84660 | 84660 | 64129 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 662 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2009 12:00:00 AM | 3x3 | Permit Number 52075 | 6002246.83688253 | 2098888.05007266 | 37.7432738978208 | -122.43487682109199 | (37.7432738978208, -122.434876821092) | ||
| 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) | |
| 28213 | 28213 | 91295 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3065 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52052 | 6000114.74904 | 2115757.9849799997 | 37.7894732446403 | -122.443460536396 | (37.7894732446403, -122.443460536396) | |
| 27039 | 27039 | 91160 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 525 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52035 | 6007065.15922 | 2112579.7073 | 37.7811403900434 | -122.41918728576401 | (37.7811403900434, -122.419187285764) | |
| 48424 | 48424 | 91161 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 525 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52035 | 6007091.03056 | 2112582.20177 | 37.7811486961969 | -122.41909796060101 | (37.7811486961969, -122.419097960601) | |
| 72202 | 72202 | 91162 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 525 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52035 | 6007112.347019999 | 2112584.78934 | 37.781157001421704 | -122.41902439967801 | (37.7811570014217, -122.419024399678) | |
| 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) | |
| 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) | ||
| 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) | |
| 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) | |
| 78368 | 78368 | 55226 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/1973 12:00:00 AM | 3x3 | Permit Number 51714 | 6015214.86332087 | 2104389.48828919 | 37.7591074416555 | -122.390420697382 | (37.7591074416555, -122.390420697382) | ||
| 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) | |||
| 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) | |||
| 110225 | 110225 | 88436 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1631 Folsom St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2008 12:00:00 AM | 3x3 | Permit Number 51400 | 6008146.0 | 2108680.0 | 37.7704935294513 | -122.41517197646799 | (37.7704935294513, -122.415171976468) | |||
| 81200 | 81200 | 88338 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 315 Paris St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51325 | 6002541.0 | 2091742.0 | 37.723669175153205 | -122.43334915015801 | (37.7236691751532, -122.433349150158) | |||
| 94108 | 94108 | 88329 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 120 London St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51317 | 6002940.0 | 2092960.0 | 37.7270361584814 | -122.432056812936 | (37.7270361584814, -122.432056812936) | |||
| 81725 | 81725 | 87967 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 901 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51002 | 6000425.8 | 2112036.7 | 37.779273289788605 | -122.442117107328 | (37.7792732897886, -122.442117107328) | ||
| 21157 | 21157 | 32488 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 282 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 12 | 3x3 | Permit Number 50560 | 6000387.70986 | 2106807.48138 | 37.7649130014568 | -122.44187345869899 | (37.7649130014568, -122.441873458699) | |
| 103372 | 103372 | 81863 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 880 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50491 | 5994900.59315185 | 2093952.33613362 | 37.729301806319704 | -122.459920577502 | (37.7293018063197, -122.459920577502) | ||
| 79538 | 79538 | 52664 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1328C. CHAVEZ Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50454 | 6003228.63897895 | 2100503.21297012 | 37.747764453898604 | -122.431597294154 | (37.7477644538986, -122.431597294154) | ||
| 130427 | 130427 | 34703 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 591 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50359 | 5981606.7893900005 | 2111740.24587 | 37.777368864087 | -122.50719674082501 | (37.777368864087, -122.507196740825) | |
| 148743 | 148743 | 62667 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 438 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50321 | 5998175.4126699995 | 2114969.52536 | 37.7871975551779 | -122.45011354281 | (37.7871975551779, -122.45011354281) | |
| 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) | |||
| 95800 | 95800 | 87308 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2895 25th St | 5 | 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) | |||
| 105883 | 105883 | 87307 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2895 25th St | 4 | 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) |
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");