trees
2,365 rows where qSpecies_id = 31 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
120641 | 100077 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 260 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005310 | 2109942 | 37.7737988894613 | -122.425071534475 | (37.7737988894613, -122.425071534475) | 7 | 9 | 11 | 28852 | 10 | ||||
106204 | 100368 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 718 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6x9 | 5992896.29545 | 2110550.04844 | 37.7747593697556 | -122.468056394721 | (37.7747593697556, -122.468056394721) | 11 | 6 | 2 | 54 | 11 | |||
35158 | 100568 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 868 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6011788.1802 | 2112369.4793 | 37.780828003664 | -122.40283310111 | (37.780828003664, -122.40283310111) | 6 | 2 | 9 | 28853 | 34 | |||
42968 | 100580 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
91488 | 100581 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
7295 | 100582 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
193091 | 100624 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
156133 | 100625 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
103199 | 100626 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
97041 | 101139 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 169 Buena Vista Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001425 | 2107346.2 | 37.7664512423305 | -122.438324340152 | (37.7664512423305, -122.438324340152) | 15 | 5 | 5 | 28862 | 3 | ||||
82816 | 101523 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2326 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6001809.97493 | 2118762.85825 | 37.7978203759732 | -122.437810557338 | (37.7978203759732, -122.437810557338) | 13 | 9 | 1 | 57 | 17 | |||
89847 | 101524 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2326 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6001795.96309 | 2118760.54126 | 37.7978132173675 | -122.437858876082 | (37.7978132173675, -122.437858876082) | 13 | 9 | 1 | 57 | 17 | |||
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 | ||
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 | |
107502 | 101947 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 149 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008537 | 2110562 | 37.7756830245653 | -122.413952655551 | (37.7756830245653, -122.413952655551) | 8 | 2 | 9 | 28853 | 34 | |||
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 | |
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 | |
40330 | 102181 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1800X Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 37814 | 6003496.6 | 2114956.8 | 37.7874656747779 | -122.431702484378 | (37.7874656747779, -122.431702484378) | 13 | 9 | 11 | 29490 | 27 | ||
170421 | 102277 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 316 Walnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2013 12:00:00 AM | 1 | 3x3 | Permit Number 776676 | 5998600.56179 | 2115376.04421 | 37.7883380681833 | -122.448671915192 | (37.7883380681833, -122.448671915192) | 13 | 6 | 1 | 54 | 31 | |
80968 | 102280 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4400X 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Permit Number 23102 | 6000531.3 | 2102322.2 | 37.7526056983006 | -122.441055007173 | (37.7526056983006, -122.441055007173) | 2 | 4 | 5 | 28862 | 22 | ||
178233 | 102452 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 546 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 16394 | 6007849 | 2104746 | 37.7596749854601 | -122.415920680262 | (37.7596749854601, -122.415920680262) | 2 | 4 | 7 | 28859 | 19 | |||
19271 | 102526 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 312 Walnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769739 | 5998624 | 2115422.5 | 37.7884669637257 | -122.448594170268 | (37.7884669637257, -122.448594170268) | 13 | 6 | 1 | 54 | 31 | |||
149698 | 102668 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 4097 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6001692 | 2105829 | 37.7623005659716 | -122.437292189744 | (37.7623005659716, -122.437292189744) | 15 | 5 | 5 | 28862 | 3 | |||
22420 | 102669 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 4097 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001692 | 2105829 | 37.7623005659716 | -122.437292189744 | (37.7623005659716, -122.437292189744) | 15 | 5 | 5 | 28862 | 3 | ||||
56130 | 102719 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1681 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008087.4331 | 2108473.4904 | 37.7699232110184 | -122.41535993867 | (37.7699232110184, -122.41535993867) | 8 | 2 | 9 | 28853 | 19 | |||
155936 | 102761 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 100X Russ St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/26/2013 12:00:00 AM | 3 | 3x3 | Permit Number 54619 | 6010215.5 | 2111581.3 | 37.7785759102049 | -122.408218187711 | (37.7785759102049, -122.408218187711) | 14 | 2 | 9 | 28853 | 34 |
84706 | 103143 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 2620 Buchanan St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6003626 | 2117322 | 37.7939672460834 | -122.431423695166 | (37.7939672460834, -122.431423695166) | 13 | 9 | 1 | 29490 | 27 | ||||
190456 | 103270 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 350 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004879 | 2109882 | 37.7736097878739 | -122.426558160091 | (37.7736097878739, -122.426558160091) | 7 | 9 | 11 | 28852 | 10 | ||||
39077 | 103271 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 350 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004879 | 2109882 | 37.7736097878739 | -122.426558160091 | (37.7736097878739, -122.426558160091) | 7 | 9 | 11 | 28852 | 10 | ||||
86900 | 103275 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2800X Pine St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6000456.3 | 2114876.5 | 37.7870723881298 | -122.442215507279 | (37.7870723881298, -122.442215507279) | 13 | 6 | 1 | 29490 | 27 | ||||
186333 | 103276 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2800X Pine St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6000456.3 | 2114876.5 | 37.7870723881298 | -122.442215507279 | (37.7870723881298, -122.442215507279) | 13 | 6 | 1 | 29490 | 27 | ||||
127597 | 103379 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 2712 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2013 12:00:00 AM | 4 | 3x3 | Permit Number 770136 | 6000520 | 2117210 | 37.7934832007909 | -122.44216269001 | (37.7934832007909, -122.44216269001) | 13 | 9 | 1 | 57 | 27 | |
72355 | 103417 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700X 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6015408.53922 | 2105754.52257 | 37.7628662739736 | -122.389846216032 | (37.7628662739736, -122.389846216032) | 10 | 3 | 8 | 28856 | 29 | |||
43816 | 103418 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 700X 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015432.6 | 2105817 | 37.7630391577767 | -122.389767361571 | (37.7630391577767, -122.389767361571) | 14 | 3 | 8 | 28856 | 29 | ||||
142223 | 103419 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 700X 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015432.6 | 2105817 | 37.7630391577767 | -122.389767361571 | (37.7630391577767, -122.389767361571) | 14 | 3 | 8 | 28856 | 29 | ||||
143441 | 103420 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 700X 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015432.6 | 2105817 | 37.7630391577767 | -122.389767361571 | (37.7630391577767, -122.389767361571) | 14 | 3 | 8 | 28856 | 29 | ||||
99529 | 103588 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 101X Laguna St | 1 | Front Yard : Yard | Tree | Private 2 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | |||||
180076 | 103743 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2011 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/11/2014 12:00:00 AM | 3 | 3x3 | 6008128.1 | 2106710.2 | 37.7650839125599 | -122.415094442696 | (37.7650839125599, -122.415094442696) | 8 | 4 | 7 | 28859 | 19 | ||
127963 | 103744 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2011 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/11/2014 12:00:00 AM | 3 | 3x3 | 6008128.1 | 2106710.2 | 37.7650839125599 | -122.415094442696 | (37.7650839125599, -122.415094442696) | 8 | 4 | 7 | 28859 | 19 | ||
76318 | 103752 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1631 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008153.338 | 2108655.6685 | 37.7704271332463 | -122.415144871631 | (37.7704271332463, -122.415144871631) | 8 | 2 | 9 | 28853 | 19 | ||
184969 | 103753 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1615 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008187.9193 | 2108722.8263 | 37.7706134761345 | -122.415030008645 | (37.7706134761345, -122.415030008645) | 8 | 2 | 9 | 28853 | 19 | ||
57138 | 104401 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 727 Ashbury St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5999017 | 2108166 | 37.768564950056 | -122.44671213341 | (37.768564950056, -122.44671213341) | 15 | 5 | 11 | 29492 | 9 | ||||
74389 | 104447 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2490X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | |||
72945 | 104450 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2490X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | |||
112431 | 104768 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 912 CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6002431.1 | 2102873.8 | 37.7542282864134 | -122.434524613527 | (37.7542282864134, -122.434524613527) | 2 | 4 | 5 | 28862 | 22 | |||
124588 | 104769 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 918 CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6002432.5 | 2102848.2 | 37.7541580743967 | -122.434517941678 | (37.7541580743967, -122.434517941678) | 2 | 4 | 5 | 28862 | 22 | |||
161237 | 104770 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 918 CASTRO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6002432.5 | 2102848.2 | 37.7541580743967 | -122.434517941678 | (37.7541580743967, -122.434517941678) | 2 | 4 | 5 | 28862 | 22 | |||
25061 | 104771 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 928 CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6002435.2 | 2102798.9 | 37.7540228616298 | -122.434505079683 | (37.7540228616298, -122.434505079683) | 2 | 4 | 5 | 28862 | 22 | |||
164074 | 104772 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 930 CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6002436.6 | 2102773.8 | 37.7539540224902 | -122.434498443618 | (37.7539540224902, -122.434498443618) | 2 | 4 | 5 | 28862 | 22 | |||
174224 | 104773 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 930 CASTRO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002436.6 | 2102773.8 | 37.7539540224902 | -122.434498443618 | (37.7539540224902, -122.434498443618) | 2 | 4 | 5 | 28862 | 22 | |||
120498 | 104777 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 732 CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6002379 | 2103830.2 | 37.7568513741308 | -122.434773176198 | (37.7568513741308, -122.434773176198) | 2 | 4 | 5 | 28862 | 3 | |||
145165 | 104802 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2670 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6x9 | 6000116.77208 | 2118873.41414 | 37.7980275078187 | -122.443677439384 | (37.7980275078187, -122.443677439384) | 13 | 9 | 1 | 57 | 17 | |||
89632 | 105077 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 299X FAIR OAKS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6005467 | 2101988 | 37.7519679548938 | -122.42396271727 | (37.7519679548938, -122.42396271727) | 2 | 4 | 5 | 28859 | 19 | |||
53830 | 105078 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 299X FAIR OAKS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6005467 | 2101988 | 37.7519679548938 | -122.42396271727 | (37.7519679548938, -122.42396271727) | 2 | 4 | 5 | 28859 | 19 | |||
32495 | 105218 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2100 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2014 12:00:00 AM | 2 | 3x3 | Permit Number 772439 | 5999896.69925 | 2116138.83336 | 37.790506517102 | -122.444242341317 | (37.790506517102, -122.444242341317) | 13 | 6 | 1 | 29490 | 27 | |
83145 | 105880 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 131X RUSS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5x5 | 6010355 | 2111553 | 37.7785060152737 | -122.407733605583 | (37.7785060152737, -122.407733605583) | 14 | 2 | 9 | 28853 | 34 | |||
12506 | 105953 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 54 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2014 12:00:00 AM | 4 | Permit Number 771133 | 5994277.8794 | 2115232.96253 | 37.7876970801078 | -122.463617190077 | (37.7876970801078, -122.463617190077) | 11 | 6 | 1 | 54 | 11 | ||
62805 | 105992 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 980 MINNESOTA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6015221.1 | 2104017.4 | 37.758086112912 | -122.39037313012 | (37.758086112912, -122.39037313012) | 10 | 3 | 8 | 28856 | 29 | |||
127376 | 105993 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 980 Minnesota St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6015232.0353 | 2104000.80366 | 37.7580411495011 | -122.390334151305 | (37.7580411495011, -122.390334151305) | 10 | 3 | 8 | 28856 | 29 | |||
97900 | 106019 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1942 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6003927.2972 | 2115156.9668 | 37.7880396862695 | -122.430226645832 | (37.7880396862695, -122.430226645832) | 13 | 9 | 11 | 29490 | 27 | ||||
179498 | 106172 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 150 CONRAD ST | 1 | Back Yard : Yard | Tree | Private 2 | 14 | 6001768.8 | 2096480 | 37.7366348009068 | -122.436357440328 | (37.7366348009068, -122.436357440328) | 2 | 7 | 5 | 63 | 7 | ||||
41277 | 106350 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1853 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6001488.8508 | 2114881.6293 | 37.7871452647326 | -122.43864348553 | (37.7871452647326, -122.43864348553) | 13 | 6 | 1 | 29490 | 27 | |||
55289 | 106454 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 4421 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6001709 | 2104078 | 37.7574937118352 | -122.437108021928 | (37.7574937118352, -122.437108021928) | 2 | 4 | 5 | 28862 | 3 | |||
150272 | 106455 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 4421 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6001709 | 2104078 | 37.7574937118352 | -122.437108021928 | (37.7574937118352, -122.437108021928) | 2 | 4 | 5 | 28862 | 3 | |||
9357 | 106645 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 4421 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | Permit Number 772901 | 6001633.7 | 2104049.1 | 37.7574100789152 | -122.437366369677 | (37.7574100789152, -122.437366369677) | 2 | 4 | 5 | 28862 | 3 | |||
103206 | 106762 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2900x Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6003492.62047 | 2118318.25536 | 37.796695146921 | -122.431956373706 | (37.796695146921, -122.431956373706) | 13 | 9 | 1 | 57 | 17 | ||||
142895 | 107048 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 1478 UNDERWOOD AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6015262.9 | 2093276.2 | 37.7285953185109 | -122.389478448264 | (37.7285953185109, -122.389478448264) | 10 | 3 | 8 | 58 | 1 | |||
4645 | 107053 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 450 Walnut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998625.9783 | 2115075.11894 | 37.7875132600186 | -122.448562297399 | (37.7875132600186, -122.448562297399) | 13 | 6 | 1 | 54 | 31 | |||||
148155 | 107599 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 177 CORBETT AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000269.8 | 2105595.5 | 37.7615784812961 | -122.442194269292 | (37.7615784812961, -122.442194269292) | 15 | 5 | 5 | 28862 | 3 | ||||||
168553 | 107830 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 145 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999377 | 2107392 | 37.7664602988917 | -122.445411267501 | (37.7664602988917, -122.445411267501) | 15 | 5 | 5 | 29492 | 9 | |||||
49994 | 107991 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4410x 23RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000358 | 2102265 | 37.7524387685866 | -122.441650202415 | (37.7524387685866, -122.441650202415) | 2 | 4 | 5 | 28862 | 22 | ||||
138910 | 107992 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4410x 23RD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000358 | 2102265 | 37.7524387685866 | -122.441650202415 | (37.7524387685866, -122.441650202415) | 2 | 4 | 5 | 28862 | 22 | ||||
27672 | 107994 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4410x 23RD ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000358 | 2102265 | 37.7524387685866 | -122.441650202415 | (37.7524387685866, -122.441650202415) | 2 | 4 | 5 | 28862 | 22 | ||||
147410 | 108134 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2055 FOLSOM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008137.2 | 2106486.4 | 37.7644699210537 | -122.415047125765 | (37.7644699210537, -122.415047125765) | 8 | 4 | 7 | 28859 | 19 | ||||
95943 | 108135 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2055 FOLSOM ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008137.2 | 2106486.4 | 37.7644699210537 | -122.415047125765 | (37.7644699210537, -122.415047125765) | 8 | 4 | 7 | 28859 | 19 | ||||
168342 | 108233 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 131 RUSS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x4 | 6010302 | 2111707 | 37.7789258960759 | -122.407927816208 | (37.7789258960759, -122.407927816208) | 14 | 2 | 9 | 28853 | 34 | |||
163066 | 108234 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 131 RUSS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010302 | 2111707 | 37.7789258960759 | -122.407927816208 | (37.7789258960759, -122.407927816208) | 14 | 2 | 9 | 28853 | 34 | ||||
28371 | 108235 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 131 RUSS ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010302 | 2111707 | 37.7789258960759 | -122.407927816208 | (37.7789258960759, -122.407927816208) | 14 | 2 | 9 | 28853 | 34 | ||||
143002 | 108236 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 131 RUSS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x4 | 6010302 | 2111707 | 37.7789258960759 | -122.407927816208 | (37.7789258960759, -122.407927816208) | 14 | 2 | 9 | 28853 | 34 | |||
67332 | 108237 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 131 RUSS ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010302 | 2111707 | 37.7789258960759 | -122.407927816208 | (37.7789258960759, -122.407927816208) | 14 | 2 | 9 | 28853 | 34 | ||||
39514 | 108244 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 150 Conrad St | 1 | Back Yard : Cutout | Tree | Private 2 | 20 | 6001768.8 | 2096480 | 37.7366348009068 | -122.436357440328 | (37.7366348009068, -122.436357440328) | 2 | 7 | 5 | 63 | 7 | ||||
89743 | 108480 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 195x 09TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993013.6 | 2114237 | 37.7848895119291 | -122.467918846049 | (37.7848895119291, -122.467918846049) | 11 | 6 | 2 | 54 | 11 | ||||
135352 | 108481 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 195x 09TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993013.6 | 2114237 | 37.7848895119291 | -122.467918846049 | (37.7848895119291, -122.467918846049) | 11 | 6 | 2 | 54 | 11 | ||||
83460 | 108482 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 195x 09TH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993013.6 | 2114237 | 37.7848895119291 | -122.467918846049 | (37.7848895119291, -122.467918846049) | 11 | 6 | 2 | 54 | 11 | ||||
151627 | 108869 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2360 FOLSOM ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6008129 | 2104684.1 | 37.7595207600627 | -122.414947915343 | (37.7595207600627, -122.414947915343) | 2 | 4 | 7 | 28859 | 19 | ||||
188567 | 109070 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 3027 16TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006619.6 | 2106627.5 | 37.7647719501604 | -122.420306113631 | (37.7647719501604, -122.420306113631) | 8 | 4 | 7 | 28859 | 19 | ||||
37182 | 109162 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 51x OCTAVIA ST | 1 | Median : Cutout | Tree | DPW 1 | 6 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649 | -122.423856888434 | (37.772384002649, -122.423856888434) | 7 | 9 | 11 | 28852 | 10 | |||
6452 | 109163 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 12 | Median : Cutout | Tree | DPW 1 | 3x20 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||||||
107729 | 109164 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 11 | Median : Cutout | Tree | DPW 1 | 3x20 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||||||
188233 | 109165 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 51x OCTAVIA ST | 4 | Median : Cutout | Tree | DPW 1 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649 | -122.423856888434 | (37.772384002649, -122.423856888434) | 7 | 9 | 11 | 28852 | 10 | ||||
10966 | 109166 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 51x OCTAVIA ST | 5 | Median : Cutout | Tree | DPW 1 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649 | -122.423856888434 | (37.772384002649, -122.423856888434) | 7 | 9 | 11 | 28852 | 10 | ||||
161548 | 109167 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 8 | Median : Cutout | Tree | DPW 1 | 3x20 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||||||
46034 | 109168 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 7 | Median : Cutout | Tree | DPW 1 | 3x20 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||||||
55922 | 109169 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 6 | Median : Cutout | Tree | DPW 1 | 3x20 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||||||
19858 | 109170 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 5 | Median : Cutout | Tree | DPW 1 | 3x20 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||||||
93874 | 109171 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 4 | Median : Cutout | Tree | DPW 1 | 3x20 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||||||
29074 | 109434 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 7 DANVERS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999816.1 | 2105451.8 | 37.7611580492101 | -122.443753102957 | (37.7611580492101, -122.443753102957) | 15 | 5 | 5 | 28862 | 3 | ||||
31630 | 109498 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2440 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 5989239.6228 | 2098735.6386 | 37.7421083236068 | -122.479840718717 | (37.7421083236068, -122.479840718717) | 1 | 8 | 3 | 29491 | 35 | |||
61409 | 109564 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 161 CORBETT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6000370.9 | 2105589.4 | 37.7615674935206 | -122.441844168883 | (37.7615674935206, -122.441844168883) | 15 | 5 | 5 | 28862 | 3 | |||
84560 | 110034 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2690 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008245.7 | 2102789.4 | 37.7543249025472 | -122.414410241803 | (37.7543249025472, -122.414410241803) | 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) );