2,365 rows where qSpecies_id = 31 sorted by TreeID

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);