trees
2,365 rows where qSpecies_id = 31 sorted by PlantDate descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
141855 | 53651 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 829 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1969 12:00:00 AM | 1 | Permit Number 6587 | 6012068.4217 | 2112548.0645 | 37.7813340008977 | -122.401876160632 | (37.7813340008977, -122.401876160632) | 6 | 2 | 9 | 28856 | 34 | ||
105797 | 91811 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2685 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2016 02:45:00 PM | 3 | 3x3 | 6008942.770855 | 2102838.050886 | 37.754497621185 | -122.412003022866 | (37.754497621185, -122.412003022866) | 2 | 4 | 7 | 28859 | 19 | ||
33627 | 39478 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2856 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 777203 | 5999897.32915775 | 2117456.37972289 | 37.7941241886563 | -122.44433488583 | (37.7941241886563, -122.44433488583) | 13 | 9 | 1 | 57 | 27 | |||
189918 | 31036 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300 Bennington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2015 12:00:00 AM | 2 | Permit Number 771782 | 6007053.24421 | 2096706.03657 | 37.7375542956049 | -122.418102817609 | (37.7375542956049, -122.418102817609) | 2 | 7 | 7 | 28859 | 2 | ||
115411 | 13321 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 435X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/1997 12:00:00 AM | 5 | 3X3 | 6002797.38385 | 2090943.99635 | 37.7214925769985 | -122.432405907456 | (37.7214925769985, -122.432405907456) | 9 | 7 | 6 | 28861 | 5 | ||
182324 | 16418 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/1992 12:00:00 AM | 13 | 3x3 | 6016308.5496 | 2094919.7628 | 37.7331661358215 | -122.385978065712 | (37.7331661358215, -122.385978065712) | 10 | 3 | 8 | 58 | 1 | ||
133424 | 254076 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 416 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2017 12:00:00 AM | 3 | 3x3 | 6003139 | 2099532 | 37.7450926486102 | -122.431837924964 | (37.7450926486102, -122.431837924964) | 2 | 7 | 5 | 63 | 22 | ||
49167 | 16426 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2007 12:00:00 AM | 12 | 3x3 | 6016278.230833 | 2094877.189867 | 37.7330475611009 | -122.386079920066 | (37.7330475611009, -122.386079920066) | 10 | 3 | 8 | 58 | 1 | ||
171880 | 34578 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3300 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2012 12:00:00 AM | 3 | Permit Number 769651 | 5998982.19825 | 2115648.46298 | 37.789107873481 | -122.44737113579 | (37.789107873481, -122.44737113579) | 13 | 6 | 1 | 54 | 31 | ||
167787 | 7615 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3215 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/16/2014 02:11:00 PM | 3 | 3x3 | 6008475.32345 | 2099918.5016 | 37.7464549560373 | -122.413413122941 | (37.7464549560373, -122.413413122941) | 2 | 7 | 7 | 28859 | 2 | ||
26272 | 9765 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 827X Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6000964.4329 | 2111657.6469 | 37.7782631876883 | -122.440226567073 | (37.7782631876883, -122.440226567073) | 15 | 5 | 11 | 29490 | 41 | ||
134930 | 7405 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1065 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/1998 12:00:00 AM | 6 | 3X3 | 6010535.4473 | 2111084.5056 | 37.7772297388865 | -122.407076335552 | (37.7772297388865, -122.407076335552) | 14 | 2 | 9 | 28853 | 34 | ||
36724 | 7562 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2924 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 5x5 | 6008336.41396 | 2101367.26054 | 37.7504251238168 | -122.413995929472 | (37.7504251238168, -122.413995929472) | 2 | 4 | 7 | 28859 | 19 | ||
27440 | 33762 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1800X Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/1996 12:00:00 AM | 5 | 3x3 | Permit Number 37814 | 6003491.84820405 | 2114902.28438826 | 37.7873157193536 | -122.431715030855 | (37.7873157193536, -122.431715030855) | 13 | 9 | 11 | 29490 | 27 | |
82749 | 101950 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 149 09th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2012 12:00:00 AM | 11 | 3x3 | Permit Number 769636 | 6008537 | 2110562 | 37.7756830245653 | -122.413952655551 | (37.7756830245653, -122.413952655551) | 8 | 2 | 9 | 28853 | 34 | |
109377 | 101909 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1801 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2012 12:00:00 AM | 1 | 3x3 | Permit Number 56808 | 6000521 | 2114812 | 37.7868989750002 | -122.441987028891 | (37.7868989750002, -122.441987028891) | 13 | 6 | 1 | 29490 | 27 | |
110810 | 101949 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 149 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2012 12:00:00 AM | 10 | 3x3 | Permit Number 769636 | 6008537 | 2110562 | 37.7756830245653 | -122.413952655551 | (37.7756830245653, -122.413952655551) | 8 | 2 | 9 | 28853 | 34 | |
116775 | 57076 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 980 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2011 12:00:00 AM | 18 | 3x3 | Permit Number 767819 | 6015234.40756552 | 2104029.6701639 | 37.7581205423321 | -122.390327963745 | (37.7581205423321, -122.390327963745) | 10 | 3 | 8 | 28856 | 29 | |
12480 | 47528 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 277 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/2003 12:00:00 AM | Permit Number 45400 | 6004720.64686455 | 2100142.45310534 | 37.7468583456276 | -122.426412322279 | (37.7468583456276, -122.426412322279) | 2 | 7 | 5 | 63 | 22 | ||
85066 | 47527 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 277 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/2003 12:00:00 AM | Permit Number 45400 | 6004720.64686455 | 2100142.45310534 | 37.7468583456276 | -122.426412322279 | (37.7468583456276, -122.426412322279) | 2 | 7 | 5 | 63 | 22 | ||
50160 | 35613 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2839 Pacific Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768494 | 6000560.21131744 | 2116797.97814823 | 37.7923541883271 | -122.44199396864 | (37.7923541883271, -122.44199396864) | 13 | 6 | 1 | 29490 | 27 | |
56457 | 23641 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 131 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/05/1997 12:00:00 AM | 10 | 3X3 | 6006567.62834 | 2098529.44793 | 37.7425336313356 | -122.419911178867 | (37.7425336313356, -122.419911178867) | 2 | 7 | 7 | 28859 | 2 | ||
65181 | 26273 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 230 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/05/1997 12:00:00 AM | 9 | 3X3 | 6006790.88974 | 2098369.36034 | 37.742106642199 | -122.419127852295 | (37.742106642199, -122.419127852295) | 2 | 7 | 7 | 28859 | 2 | ||
155620 | 23640 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 125 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/05/1997 12:00:00 AM | 12 | 3X3 | 6006550.3772 | 2098540.77805 | 37.7425637693939 | -122.419971632183 | (37.7425637693939, -122.419971632183) | 2 | 7 | 7 | 28859 | 2 | ||
116748 | 45798 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 880 Clipper Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2001 12:00:00 AM | Permit Number 44433 | 5999675.79411068 | 2100284.35240189 | 37.7469614974882 | -122.443867085897 | (37.7469614974882, -122.443867085897) | 2 | 4 | 5 | 63 | 22 | |||
90967 | 33602 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 200X Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1996 12:00:00 AM | 9 | Permit Number 37716 | 6006727.64769195 | 2098397.31693347 | 37.7421798430719 | -122.419348506645 | (37.7421798430719, -122.419348506645) | 2 | 7 | 7 | 28859 | 2 | ||
115704 | 7645 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3299 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2008 12:00:00 AM | 3 | 4x4 | 6008510.32989 | 2099428.74367 | 37.7451121549133 | -122.413257446692 | (37.7451121549133, -122.413257446692) | 2 | 7 | 7 | 28859 | 2 | ||
60 | 264971 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 150 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2020 12:00:00 AM | 3 | 5990555.23468 | 2114396.47455 | 37.7851851170506 | -122.476435559205 | (37.7851851170506, -122.476435559205) | 11 | 6 | 2 | 54 | 26 | |||
51115 | 41185 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3440 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1999 12:00:00 AM | 2 | Permit Number 41903 | 6001280.22409 | 2120345.11349 | 37.8021346936235 | -122.439757137177 | (37.8021346936235, -122.439757137177) | 13 | 9 | 1 | 57 | 17 | |
55 | 1166 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2900 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/23/2020 12:00:00 AM | 25 | 3X3 | 5997012.91474 | 2087625.16187 | 37.7120501257788 | -122.45216178836 | (37.7120501257788, -122.45216178836) | 9 | 7 | 6 | 28861 | 25 | ||
11978 | 7458 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2576 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2019 12:00:00 AM | 3 | 5x5 | 6008224.65711 | 2103426.0166 | 37.7560717250334 | -122.41452805924 | (37.7560717250334, -122.41452805924) | 2 | 4 | 7 | 28859 | 19 | ||
55359 | 44113 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1201 Treat Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.412744337506 | (37.7509254812099, -122.412744337506) | 2 | 4 | 7 | 28859 | 19 | |||
86168 | 44116 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1201 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.412744337506 | (37.7509254812099, -122.412744337506) | 2 | 4 | 7 | 28859 | 19 | |||
114039 | 44114 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1201 Treat Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.412744337506 | (37.7509254812099, -122.412744337506) | 2 | 4 | 7 | 28859 | 19 | |||
156020 | 44112 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1201 Treat Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.412744337506 | (37.7509254812099, -122.412744337506) | 2 | 4 | 7 | 28859 | 19 | |||
179496 | 55354 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 601 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/1972 12:00:00 AM | 10 | 3x3 | Permit Number 11287 | 5993641.36369 | 2113466.98214 | 37.782811483217 | -122.465691040743 | (37.782811483217, -122.465691040743) | 11 | 6 | 2 | 54 | 11 | |
188398 | 48883 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1515 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2002 12:00:00 AM | 4 | 5x4 | Permit Number 46089 | 6000106.0163 | 2114246.8974 | 37.7853236932557 | -122.443382166919 | (37.7853236932557, -122.443382166919) | 15 | 6 | 1 | 29490 | 31 | |
43761 | 7658 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3335 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2010 12:00:00 AM | 3 | 3x3 | 6008522.8365 | 2099251.39925 | 37.7446259085611 | -122.41320166263 | (37.7446259085611, -122.41320166263) | 2 | 7 | 7 | 28859 | 2 | ||
23450 | 91035 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010666.0508 | 2111208.1223 | 37.7775764693736 | -122.406633247496 | (37.7775764693736, -122.406633247496) | 14 | 2 | 9 | 28853 | 34 | ||
24697 | 91031 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010606.148 | 2111149.8835 | 37.7774132075868 | -122.406836366848 | (37.7774132075868, -122.406836366848) | 14 | 2 | 9 | 28853 | 34 | ||
93167 | 91037 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010705.7086 | 2111246.6708 | 37.7776845332645 | -122.406498774175 | (37.7776845332645, -122.406498774175) | 14 | 2 | 9 | 28853 | 34 | ||
104469 | 91034 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010653.2937 | 2111194.8106 | 37.7775392048064 | -122.406676440472 | (37.7775392048064, -122.406676440472) | 14 | 2 | 9 | 28853 | 34 | ||
105551 | 91033 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010628.8889 | 2111172.6244 | 37.7774769212136 | -122.406759301284 | (37.7774769212136, -122.406759301284) | 14 | 2 | 9 | 28853 | 34 | ||
110000 | 91036 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010688.5143 | 2111227.8126 | 37.7776317911098 | -122.406556926191 | (37.7776317911098, -122.406556926191) | 14 | 2 | 9 | 28853 | 34 | ||
165047 | 91032 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010616.6864 | 2111159.8673 | 37.7774412104334 | -122.406800614681 | (37.7774412104334, -122.406800614681) | 14 | 2 | 9 | 28853 | 34 | ||
81626 | 17813 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1900X Pine St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2012 12:00:00 AM | 4 | 3x3 | 6004830.0574482 | 2115432.8862429 | 37.7888483829176 | -122.427122914168 | (37.7888483829176, -122.427122914168) | 13 | 9 | 11 | 28858 | 27 | ||
104664 | 17810 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1900X Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2012 12:00:00 AM | 4 | 3X3 | 6004830.0574482 | 2115432.8862429 | 37.7888483829176 | -122.427122914168 | (37.7888483829176, -122.427122914168) | 13 | 9 | 11 | 28858 | 27 | ||
112716 | 48869 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 375 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2002 12:00:00 AM | 23 | Permit Number 46077 | 6013801.17849 | 2105352.33133 | 37.7616726766835 | -122.395377380275 | (37.7616726766835, -122.395377380275) | 10 | 3 | 8 | 28856 | 29 | ||
8319 | 260505 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 760 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784870 | 6007464 | 2105234 | 37.7609932681872 | -122.417286789238 | (37.7609932681872, -122.417286789238) | 2 | 4 | 7 | 28859 | 19 | |
170067 | 17992 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2619 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2012 12:00:00 AM | 3 | 3X3 | 6001295.2434 | 2114888.6615 | 37.7871535576878 | -122.439313827621 | (37.7871535576878, -122.439313827621) | 13 | 6 | 1 | 29490 | 27 | ||
98651 | 33318 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2604 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 8 | Permit Number 37462 | 6004913.93801 | 2118560.00816 | 37.7974394114518 | -122.427055518194 | (37.7974394114518, -122.427055518194) | 13 | 9 | 1 | 57 | 17 | |
188745 | 38953 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3204 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1998 12:00:00 AM | Permit Number 40748 | 6008411.48904152 | 2100134.52641769 | 37.747044527767 | -122.413649132677 | (37.747044527767, -122.413649132677) | 2 | 7 | 7 | 28859 | 2 | |||
77089 | 56515 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1200 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1978 12:00:00 AM | 10 | Permit Number 17376 | 6008990.48315 | 2116704.87455 | 37.7925753427324 | -122.412818332001 | (37.7925753427324, -122.412818332001) | 5 | 1 | 10 | 28857 | 21 | ||
1850 | 138602 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2660 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2020 02:03:00 PM | 3 | Width 0ft | 6001218.2318 | 2114936.9229 | 37.7872816882761 | -122.439583731447 | (37.7872816882761, -122.439583731447) | 13 | 6 | 1 | 29490 | 27 | ||
172458 | 23638 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 118 VIRGINIA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 12 | 4x4 | Permit Number 776560 | 6006594 | 2098480 | 37.7423993441016 | -122.419816485332 | (37.7423993441016, -122.419816485332) | 2 | 7 | 7 | 28859 | 2 | |
139622 | 137895 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1944 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2017 12:00:00 AM | 3 | Width 0ft | 6003925.565 | 2115178.3301 | 37.7880982463854 | -122.430234163647 | (37.7880982463854, -122.430234163647) | 13 | 9 | 11 | 29490 | 27 | ||
175400 | 44079 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 172 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2000 12:00:00 AM | 4 | Permit Number 43600 | 6010499.79752 | 2111352.59578 | 37.7779638568728 | -122.407218563007 | (37.7779638568728, -122.407218563007) | 14 | 2 | 9 | 28853 | 34 | ||
39987 | 33125 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2380 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 13 | 6x7 | Permit Number 37358 | 6001538.52427 | 2119069.35252 | 37.7986464896046 | -122.438771824677 | (37.7986464896046, -122.438771824677) | 13 | 9 | 1 | 57 | 17 |
41592 | 33124 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2380 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 12 | 6x6 | Permit Number 37358 | 6001499.40758 | 2119065.90574 | 37.7986348002003 | -122.438906933417 | (37.7986348002003, -122.438906933417) | 13 | 9 | 1 | 57 | 17 |
84509 | 33151 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2434 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 7 | Permit Number 37374 | 5987066.8878 | 2098694.8228 | 37.7418697871522 | -122.487350256926 | (37.7418697871522, -122.487350256926) | 1 | 8 | 3 | 29491 | 35 | |
176570 | 68218 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 233 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/04/2010 12:00:00 AM | 4 | Permit Number 53885 | 5990842.3093 | 2113821.79414 | 37.7836238495535 | -122.475400406913 | (37.7836238495535, -122.475400406913) | 11 | 6 | 2 | 54 | 26 | |
107535 | 68693 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 600 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | 12 | 3x3 | Permit Number 32603 | 5993650.82821 | 2113525.78591 | 37.7829734883164 | -122.46566257132 | (37.7829734883164, -122.46566257132) | 11 | 6 | 2 | 54 | 11 |
122624 | 14598 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1247 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2016 12:00:00 AM | 45 | 3X3 | 5999428.6068 | 2108510.475 | 37.7695342955042 | -122.445313195872 | (37.7695342955042, -122.445313195872) | 15 | 5 | 11 | 29492 | 9 | ||
15550 | 32997 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013196.81609 | 2113721.08426 | 37.784617751847 | -122.398054757315 | (37.784617751847, -122.398054757315) | 6 | 2 | 9 | 28853 | 6 | |
16163 | 32994 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013107.84928 | 2113632.60044 | 37.7843698402516 | -122.398356344087 | (37.7843698402516, -122.398356344087) | 6 | 2 | 9 | 28853 | 6 | |
22908 | 32995 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 4 | Permit Number 37299 | 6013130.33001 | 2113657.26593 | 37.7844388182424 | -122.398280299215 | (37.7844388182424, -122.398280299215) | 6 | 2 | 9 | 28853 | 6 | |
63920 | 32998 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013208.8867 | 2113734.0736 | 37.7846540898483 | -122.398013908317 | (37.7846540898483, -122.398013908317) | 6 | 2 | 9 | 28853 | 6 | |
79347 | 32996 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013182.02247 | 2113705.96324 | 37.7845754090665 | -122.398104877431 | (37.7845754090665, -122.398104877431) | 6 | 2 | 9 | 28853 | 6 | |
90759 | 32989 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013088.2865 | 2113616.33259 | 37.7843240827368 | -122.398422883105 | (37.7843240827368, -122.398422883105) | 6 | 2 | 9 | 28853 | 6 | |
180006 | 32993 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013060.48706 | 2113590.00605 | 37.7842502474912 | -122.398517212115 | (37.7842502474912, -122.398517212115) | 6 | 2 | 9 | 28853 | 6 | |
189568 | 6037 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1822 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51912 | 6001625.9468 | 2112554.8978 | 37.7807644518495 | -122.43800243798 | (37.7807644518495, -122.43800243798) | 15 | 5 | 11 | 29490 | 41 | |
119288 | 53481 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2201 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/1969 12:00:00 AM | 8 | Permit Number 6390 | 6002979.07126 | 2117470.0427 | 37.7943370471773 | -122.433672716337 | (37.7943370471773, -122.433672716337) | 13 | 9 | 1 | 29490 | 27 | ||
108939 | 26771 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2605X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/30/2013 12:00:00 AM | 3 | 3x3 | 6001478.3944063 | 2114917.2732237 | 37.7872425389418 | -122.43868221732 | (37.7872425389418, -122.43868221732) | 13 | 6 | 1 | 29490 | 27 | ||
43128 | 51255 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2485 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2006 12:00:00 AM | 8 | Permit Number 49056 | 6001759.16032 | 2117307.51172 | 37.7938214847188 | -122.437882095676 | (37.7938214847188, -122.437882095676) | 13 | 9 | 1 | 29490 | 27 | ||
133326 | 54971 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 558 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1974 12:00:00 AM | 14 | Permit Number 14440 | 5993167.14361 | 2111676.47154 | 37.7778678620954 | -122.467201401573 | (37.7778678620954, -122.467201401573) | 11 | 6 | 2 | 54 | 11 | ||
6558 | 57073 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 958 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1974 12:00:00 AM | 17 | Permit Number 14340 | 6015221.7654 | 2104138.81007 | 37.7584195158777 | -122.390379311651 | (37.7584195158777, -122.390379311651) | 10 | 3 | 8 | 28856 | 29 | ||
20097 | 57068 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 918 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1974 12:00:00 AM | 15 | 6x7 | Permit Number 14334 | 6015212.77238 | 2104346.74514 | 37.7589899621477 | -122.390424942382 | (37.7589899621477, -122.390424942382) | 10 | 3 | 8 | 28856 | 29 | |
189978 | 57074 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 966 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1974 12:00:00 AM | 24 | 9x7.5 | Permit Number 14341 | 6015226.17172 | 2104099.64367 | 37.7583122177548 | -122.390361336011 | (37.7583122177548, -122.390361336011) | 10 | 3 | 8 | 28856 | 29 | |
6695 | 260396 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Thornton Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | |||||||||||||
7980 | 260398 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Thornton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/20/2018 12:00:00 AM | 3 | |||||||||||||
18433 | 260397 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Thornton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/20/2018 12:00:00 AM | 3 | |||||||||||||
56016 | 51434 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 277 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2004 12:00:00 AM | 9 | Permit Number 47754 | 6002446.43605 | 2092096.42043 | 37.7246369688192 | -122.433701359735 | (37.7246369688192, -122.433701359735) | 9 | 7 | 6 | 28861 | 5 | ||
169881 | 52081 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 477 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2005 12:00:00 AM | Permit Number 48278 | 5998529.03039776 | 2106418.21564482 | 37.7637380891551 | -122.448274099423 | (37.7637380891551, -122.448274099423) | 15 | 5 | 11 | 29492 | 9 | |||
120909 | 245848 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 251 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2018 12:00:00 AM | 3 | Width 0ft | 6005123.1957 | 2109797.771 | 37.7733923174645 | -122.425707453362 | (37.7733923174645, -122.425707453362) | 7 | 9 | 11 | 28852 | 10 | ||
23232 | 32533 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 70 Porter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | Permit Number 37034 | 6006985.4956632 | 2095516.38069521 | 37.7342839493681 | -122.418252734879 | (37.7342839493681, -122.418252734879) | 2 | 7 | 7 | 28859 | 2 | ||
62676 | 32534 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 70 Porter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | Permit Number 37034 | 6006985.4956632 | 2095516.38069521 | 37.7342839493681 | -122.418252734879 | (37.7342839493681, -122.418252734879) | 2 | 7 | 7 | 28859 | 2 | ||
158775 | 32532 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 70 Porter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | Permit Number 37034 | 6006985.4956632 | 2095516.38069521 | 37.7342839493681 | -122.418252734879 | (37.7342839493681, -122.418252734879) | 2 | 7 | 7 | 28859 | 2 | ||
25561 | 101710 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 990 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2016 12:00:00 AM | 3 | 3x3 | 6011874 | 2103773 | 37.7572288087602 | -122.401931725179 | (37.7572288087602, -122.401931725179) | 10 | 3 | 8 | 28856 | 29 | ||
120014 | 49872 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1918 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2007 12:00:00 AM | 6 | 3x3 | Permit Number 49768 | 6003420.3009 | 2115360.353 | 37.7885694038243 | -122.431995291423 | (37.7885694038243, -122.431995291423) | 13 | 9 | 1 | 29490 | 27 | |
151150 | 32451 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4444 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | 14 | Permit Number 36969 | 5999681.89649 | 2105763.67379 | 37.7620067217593 | -122.444239665821 | (37.7620067217593, -122.444239665821) | 15 | 5 | 5 | 28862 | 3 | |
187604 | 43412 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 854 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51843 | 6003073.74768147 | 2103234.41761238 | 37.7552549166143 | -122.432327933003 | (37.7552549166143, -122.432327933003) | 2 | 4 | 5 | 28862 | 22 | ||
181320 | 57535 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 546 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/1976 12:00:00 AM | 3x3 | Permit Number 16394 | 6007841.0815384 | 2104745.28982278 | 37.7596725902927 | -122.41594801607 | (37.7596725902927, -122.41594801607) | 2 | 4 | 7 | 28859 | 19 | ||
5878 | 236882 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 150 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2016 12:00:00 AM | 5 | Width 3ft | Permit Number 772898 | 5999413.41178 | 2107340.88769 | 37.7663220358477 | -122.445281650937 | (37.7663220358477, -122.445281650937) | 15 | 5 | 5 | 29492 | 9 | |
186371 | 67600 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 555 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1992 12:00:00 AM | 10 | Permit Number 31170 | 6013571.5238 | 2104494.52261 | 37.7593045458768 | -122.396111549926 | (37.7593045458768, -122.396111549926) | 10 | 3 | 8 | 28856 | 29 | |
77852 | 7013 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1031 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1997 12:00:00 AM | 8 | 3X3 | 6002426.7807 | 2110189.6116 | 37.7743154774203 | -122.435062751747 | (37.7743154774203, -122.435062751747) | 15 | 5 | 11 | 29492 | 10 | ||
25292 | 89024 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2724 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2008 12:00:00 AM | 4 | 4x4 | Permit Number 51769 | 6000900.18903 | 2116892.91159 | 37.7926342186313 | -122.440824453501 | (37.7926342186313, -122.440824453501) | 13 | 6 | 1 | 29490 | 27 | |
16699 | 97434 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1380x Newcomb Ave | 5 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 6016360.63733 | 2094893.94179 | 37.7330981190079 | -122.385796183605 | (37.7330981190079, -122.385796183605) | 10 | 3 | 8 | 58 | 1 | |||
55149 | 97435 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300x Newcomb Ave | 4 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 6016490.8874 | 2094837.7533 | 37.7329510434152 | -122.385341956131 | (37.7329510434152, -122.385341956131) | 10 | 3 | 8 | 58 | 1 | |||
188111 | 97225 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301X Newcomb Ave | 5 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016649.85073 | 2094946.91351 | 37.7332595687675 | -122.384799975236 | (37.7332595687675, -122.384799975236) | 10 | 3 | 8 | 58 | 1 | ||
143872 | 34293 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2868 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/2002 12:00:00 AM | 7 | Permit Number 45961 | 6010202.37211243 | 2101668.36098933 | 37.7513565026505 | -122.407564507802 | (37.7513565026505, -122.407564507802) | 2 | 4 | 7 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );