home / trees

Street_Tree_List

Data source: data.sfgov.org

2,351 rows where qSpecies = 26

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
86 100077 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 260 Page St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6005310.0 2109942.0 37.7737988894613 -122.42507153447501 (37.7737988894613, -122.425071534475) 7 9 11 28852 10
349 100368 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 718 10th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 6x9   5992896.29545 2110550.04844 37.7747593697556 -122.46805639472099 (37.7747593697556, -122.468056394721) 11 6 2 54 11
515 100568 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 868 Folsom St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3x3   6011788.1802 2112369.4793 37.780828003664 -122.40283310111 (37.780828003664, -122.40283310111) 6 2 9 28853 34
527 100580 Permitted Site 2 Ulmus parvifolia :: Chinese Elm 26 900 Folsom St 11 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6011458.7 2112074.6 37.7799999312698 -122.403952182873 (37.7799999312698, -122.403952182873) 14 2 9 28853 34
528 100581 Permitted Site 2 Ulmus parvifolia :: Chinese Elm 26 900 Folsom St 12 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6011458.7 2112074.6 37.7799999312698 -122.403952182873 (37.7799999312698, -122.403952182873) 14 2 9 28853 34
529 100582 Permitted Site 2 Ulmus parvifolia :: Chinese Elm 26 900 Folsom St 13 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6011458.7 2112074.6 37.7799999312698 -122.403952182873 (37.7799999312698, -122.403952182873) 14 2 9 28853 34
567 100624 Permitted Site 2 Ulmus parvifolia :: Chinese Elm 26 900 Folsom St 11 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6011458.7 2112074.6 37.7799999312698 -122.403952182873 (37.7799999312698, -122.403952182873) 14 2 9 28853 34
568 100625 Permitted Site 2 Ulmus parvifolia :: Chinese Elm 26 900 Folsom St 12 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6011458.7 2112074.6 37.7799999312698 -122.403952182873 (37.7799999312698, -122.403952182873) 14 2 9 28853 34
569 100626 Permitted Site 2 Ulmus parvifolia :: Chinese Elm 26 900 Folsom St 13 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6011458.7 2112074.6 37.7799999312698 -122.403952182873 (37.7799999312698, -122.403952182873) 14 2 9 28853 34
984 101139 Permitted Site 2 Ulmus parvifolia :: Chinese Elm 26 169 Buena Vista Ter 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6001425.0 2107346.2 37.7664512423305 -122.438324340152 (37.7664512423305, -122.438324340152) 15 5 5 28862 3
1338 101523 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 2326 Filbert St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6001809.9749300005 2118762.85825 37.7978203759732 -122.43781055733801 (37.7978203759732, -122.437810557338) 13 9 1 57 17
1339 101524 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 2326 Filbert St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6001795.96309 2118760.54126 37.7978132173675 -122.437858876082 (37.7978132173675, -122.437858876082) 13 9 1 57 17
1515 101710 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 990 Rhode Island St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/12/2016 12:00:00 AM 3 3x3   6011874.0 2103773.0 37.7572288087602 -122.40193172517901 (37.7572288087602, -122.401931725179) 10 3 8 28856 29
1647 101909 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 1801 Broderick St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/07/2012 12:00:00 AM 1 3x3 Permit Number 56808 6000521.0 2114812.0 37.786898975000206 -122.44198702889099 (37.7868989750002, -122.441987028891) 13 6 1 29490 27
1668 101947 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 149 09th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6008537.0 2110562.0 37.775683024565296 -122.413952655551 (37.7756830245653, -122.413952655551) 8 2 9 28853 34
1669 101949 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 149 09th St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/07/2012 12:00:00 AM 10 3x3 Permit Number 769636 6008537.0 2110562.0 37.775683024565296 -122.413952655551 (37.7756830245653, -122.413952655551) 8 2 9 28853 34
1671 101950 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 149 09th St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/07/2012 12:00:00 AM 11 3x3 Permit Number 769636 6008537.0 2110562.0 37.775683024565296 -122.413952655551 (37.7756830245653, -122.413952655551) 8 2 9 28853 34
1893 102181 Permitted Site 2 Ulmus parvifolia :: Chinese Elm 26 1800X Webster St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3 Permit Number 37814 6003496.6 2114956.8 37.7874656747779 -122.431702484378 (37.7874656747779, -122.431702484378) 13 9 11 29490 27
1991 102277 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 316 Walnut St 2 Sidewalk: Curb side : Cutout 2 Tree 1 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
1993 102280 Permitted Site 2 Ulmus parvifolia :: Chinese Elm 26 4400X 23rd St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3 Permit Number 23102 6000531.3 2102322.2 37.7526056983006 -122.441055007173 (37.7526056983006, -122.441055007173) 2 4 5 28862 22
2161 102452 Permitted Site 2 Ulmus parvifolia :: Chinese Elm 26 546 Shotwell St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3 Permit Number 16394 6007849.0 2104746.0 37.7596749854601 -122.41592068026199 (37.7596749854601, -122.415920680262) 2 4 7 28859 19
2233 102526 Permitted Site 2 Ulmus parvifolia :: Chinese Elm 26 312 Walnut St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3 Permit Number 769739 5998624.0 2115422.5 37.7884669637257 -122.448594170268 (37.7884669637257, -122.448594170268) 13 6 1 54 31
2363 102668 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 4097 17th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6001692.0 2105829.0 37.7623005659716 -122.437292189744 (37.7623005659716, -122.437292189744) 15 5 5 28862 3
2364 102669 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 4097 17th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6001692.0 2105829.0 37.7623005659716 -122.437292189744 (37.7623005659716, -122.437292189744) 15 5 5 28862 3
2408 102719 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 1681 Folsom St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   6008087.4331 2108473.4904 37.7699232110184 -122.41535993867 (37.7699232110184, -122.41535993867) 8 2 9 28853 19
2448 102761 Permitted Site 2 Ulmus parvifolia :: Chinese Elm 26 100X Russ St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 02/26/2013 12:00:00 AM 3 3x3 Permit Number 54619 6010215.5 2111581.3 37.7785759102049 -122.40821818771099 (37.7785759102049, -122.408218187711) 14 2 9 28853 34
2793 103143 Significant Tree 4 Ulmus parvifolia :: Chinese Elm 26 2620 Buchanan St 1 Front Yard : Yard 4 Tree 1 Private 2       3x3   6003626.0 2117322.0 37.7939672460834 -122.431423695166 (37.7939672460834, -122.431423695166) 13 9 1 29490 27
2920 103270 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 350 Page St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6004879.0 2109882.0 37.773609787873895 -122.426558160091 (37.7736097878739, -122.426558160091) 7 9 11 28852 10
2921 103271 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 350 Page St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6004879.0 2109882.0 37.773609787873895 -122.426558160091 (37.7736097878739, -122.426558160091) 7 9 11 28852 10
2925 103275 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 2800X Pine St 1 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3x3   6000456.3 2114876.5 37.7870723881298 -122.442215507279 (37.7870723881298, -122.442215507279) 13 6 1 29490 27
2926 103276 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 2800X Pine St 3 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3x3   6000456.3 2114876.5 37.7870723881298 -122.442215507279 (37.7870723881298, -122.442215507279) 13 6 1 29490 27
3015 103379 Planning Code 138.1 required 8 Ulmus parvifolia :: Chinese Elm 26 2712 Broadway 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/21/2013 12:00:00 AM 4 3x3 Permit Number 770136 6000520.0 2117210.0 37.793483200790895 -122.44216269001001 (37.7934832007909, -122.44216269001) 13 9 1 57 27
3051 103417 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 700X 18th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     17 3x3   6015408.53922 2105754.52257 37.7628662739736 -122.38984621603201 (37.7628662739736, -122.389846216032) 10 3 8 28856 29
3052 103418 Permitted Site 2 Ulmus parvifolia :: Chinese Elm 26 700X 18th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6015432.6 2105817.0 37.7630391577767 -122.389767361571 (37.7630391577767, -122.389767361571) 14 3 8 28856 29
3053 103419 Permitted Site 2 Ulmus parvifolia :: Chinese Elm 26 700X 18th St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6015432.6 2105817.0 37.7630391577767 -122.389767361571 (37.7630391577767, -122.389767361571) 14 3 8 28856 29
3055 103420 Permitted Site 2 Ulmus parvifolia :: Chinese Elm 26 700X 18th St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6015432.6 2105817.0 37.7630391577767 -122.389767361571 (37.7630391577767, -122.389767361571) 14 3 8 28856 29
3213 103588 Significant Tree 4 Ulmus parvifolia :: Chinese Elm 26 101X Laguna St 1 Front Yard : Yard 4 Tree 1 Private 2           6005198.60314 2109385.58511 37.772264815602 -122.42541726943199 (37.772264815602, -122.425417269432) 7 9 5 28852 10
3360 103743 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 2011 Folsom St 1 Sidewalk: Curb side : Cutout 2 Tree 1 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
3361 103744 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 2011 Folsom St 2 Sidewalk: Curb side : Cutout 2 Tree 1 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
3370 103752 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 1631 Folsom St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/04/2007 12:00:00 AM 3 3x3   6008153.3379999995 2108655.6685 37.7704271332463 -122.41514487163099 (37.7704271332463, -122.415144871631) 8 2 9 28853 19
3371 103753 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 1615 Folsom St 1 Sidewalk: Curb side : Cutout 2 Tree 1 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
3901 104401 Private 7 Ulmus parvifolia :: Chinese Elm 26 727 Ashbury St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 3x3   5999017.0 2108166.0 37.768564950056 -122.44671213341002 (37.768564950056, -122.44671213341) 15 5 11 29492 9
3947 104447 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 2490X Folsom St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1 Rec/Park 5     3x3   6008214.39649 2104163.7525299997 37.7580968032353 -122.41461574816002 (37.7580968032353, -122.41461574816) 2 4 7 28859 19
3951 104450 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 2490X Folsom St 5 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1 Rec/Park 5     3x3   6008214.39649 2104163.7525299997 37.7580968032353 -122.41461574816002 (37.7580968032353, -122.41461574816) 2 4 7 28859 19
4240 104768 Private 7 Ulmus parvifolia :: Chinese Elm 26 912 CASTRO ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     17 3x3   6002431.1 2102873.8 37.7542282864134 -122.43452461352699 (37.7542282864134, -122.434524613527) 2 4 5 28862 22
4241 104769 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 918 CASTRO ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 3x3   6002432.5 2102848.2 37.7541580743967 -122.43451794167801 (37.7541580743967, -122.434517941678) 2 4 5 28862 22
4243 104770 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 918 CASTRO ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 3x3   6002432.5 2102848.2 37.7541580743967 -122.43451794167801 (37.7541580743967, -122.434517941678) 2 4 5 28862 22
4244 104771 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 928 CASTRO ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 3x3   6002435.2 2102798.9 37.7540228616298 -122.43450507968299 (37.7540228616298, -122.434505079683) 2 4 5 28862 22
4245 104772 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 930 CASTRO ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13 3x3   6002436.6 2102773.8 37.7539540224902 -122.434498443618 (37.7539540224902, -122.434498443618) 2 4 5 28862 22
4246 104773 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 930 CASTRO ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6002436.6 2102773.8 37.7539540224902 -122.434498443618 (37.7539540224902, -122.434498443618) 2 4 5 28862 22
4250 104777 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 732 CASTRO ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 3x3   6002379.0 2103830.2 37.7568513741308 -122.43477317619801 (37.7568513741308, -122.434773176198) 2 4 5 28862 3
4270 104802 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 2670 Greenwich St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     20 6x9   6000116.7720800005 2118873.41414 37.7980275078187 -122.443677439384 (37.7980275078187, -122.443677439384) 13 9 1 57 17
4523 105077 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 299X FAIR OAKS ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 3x3   6005467.0 2101988.0 37.7519679548938 -122.42396271726999 (37.7519679548938, -122.42396271727) 2 4 5 28859 19
4524 105078 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 299X FAIR OAKS ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     18 3x3   6005467.0 2101988.0 37.7519679548938 -122.42396271726999 (37.7519679548938, -122.42396271727) 2 4 5 28859 19
4610 105218 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 2100 Baker St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/07/2014 12:00:00 AM 2 3x3 Permit Number 772439 5999896.69925 2116138.83336 37.790506517101996 -122.44424234131701 (37.790506517102, -122.444242341317) 13 6 1 29490 27
5175 105880 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 131X RUSS ST 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 5x5   6010355.0 2111553.0 37.778506015273706 -122.407733605583 (37.7785060152737, -122.407733605583) 14 2 9 28853 34
5213 105953 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 54 05th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 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
5249 105992 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 980 MINNESOTA ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     18 3x3   6015221.1 2104017.4 37.758086112912004 -122.39037313012 (37.758086112912, -122.39037313012) 10 3 8 28856 29
5250 105993 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 980 Minnesota St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 3x3   6015232.0353 2104000.8036599997 37.758041149501096 -122.39033415130501 (37.7580411495011, -122.390334151305) 10 3 8 28856 29
5273 106019 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 1942 Buchanan St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     18     6003927.2972 2115156.9668 37.7880396862695 -122.43022664583201 (37.7880396862695, -122.430226645832) 13 9 11 29490 27
5401 106172 Significant Tree 4 Ulmus parvifolia :: Chinese Elm 26 150 CONRAD ST 1 Back Yard : Yard 6 Tree 1 Private 2     14     6001768.8 2096480.0 37.7366348009068 -122.43635744032801 (37.7366348009068, -122.436357440328) 2 7 5 63 7
5544 106350 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 1853 Scott St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 3x3   6001488.8508 2114881.6293 37.7871452647326 -122.43864348553001 (37.7871452647326, -122.43864348553) 13 6 1 29490 27
5632 106454 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 4421 20th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     20 3x3   6001709.0 2104078.0 37.7574937118352 -122.43710802192801 (37.7574937118352, -122.437108021928) 2 4 5 28862 3
5633 106455 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 4421 20th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     20 3x3   6001709.0 2104078.0 37.7574937118352 -122.43710802192801 (37.7574937118352, -122.437108021928) 2 4 5 28862 3
5788 106645 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 4421 20th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3X3 Permit Number 772901 6001633.7 2104049.1 37.75741007891521 -122.437366369677 (37.7574100789152, -122.437366369677) 2 4 5 28862 3
5872 106762 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 2900x Buchanan St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7     6003492.6204699995 2118318.25536 37.796695146921 -122.431956373706 (37.796695146921, -122.431956373706) 13 9 1 57 17
6110 107048 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 1478 UNDERWOOD AVE 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6015262.9 2093276.2 37.7285953185109 -122.389478448264 (37.7285953185109, -122.389478448264) 10 3 8 58 1
6116 107053 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 450 Walnut St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5998625.9783 2115075.11894 37.7875132600186 -122.44856229739901 (37.7875132600186, -122.448562297399) 13 6 1 54 31
6560 107599 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 177 CORBETT AVE   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6000269.8 2105595.5 37.7615784812961 -122.44219426929199 (37.7615784812961, -122.442194269292) 15 5 5 28862 3
6732 107830 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 145 Delmar St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5999377.0 2107392.0 37.7664602988917 -122.44541126750099 (37.7664602988917, -122.445411267501) 15 5 5 29492 9
6894 107991 Permitted Site 2 Ulmus parvifolia :: Chinese Elm 26 4410x 23RD ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6000358.0 2102265.0 37.7524387685866 -122.441650202415 (37.7524387685866, -122.441650202415) 2 4 5 28862 22
6895 107992 Permitted Site 2 Ulmus parvifolia :: Chinese Elm 26 4410x 23RD ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6000358.0 2102265.0 37.7524387685866 -122.441650202415 (37.7524387685866, -122.441650202415) 2 4 5 28862 22
6897 107994 Permitted Site 2 Ulmus parvifolia :: Chinese Elm 26 4410x 23RD ST 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6000358.0 2102265.0 37.7524387685866 -122.441650202415 (37.7524387685866, -122.441650202415) 2 4 5 28862 22
7027 108134 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 2055 FOLSOM ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6008137.2 2106486.4 37.7644699210537 -122.415047125765 (37.7644699210537, -122.415047125765) 8 4 7 28859 19
7028 108135 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 2055 FOLSOM ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6008137.2 2106486.4 37.7644699210537 -122.415047125765 (37.7644699210537, -122.415047125765) 8 4 7 28859 19
7116 108233 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 131 RUSS ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 4x4   6010302.0 2111707.0 37.7789258960759 -122.407927816208 (37.7789258960759, -122.407927816208) 14 2 9 28853 34
7117 108234 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 131 RUSS ST 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       4x4   6010302.0 2111707.0 37.7789258960759 -122.407927816208 (37.7789258960759, -122.407927816208) 14 2 9 28853 34
7118 108235 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 131 RUSS ST 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       4x4   6010302.0 2111707.0 37.7789258960759 -122.407927816208 (37.7789258960759, -122.407927816208) 14 2 9 28853 34
7119 108236 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 131 RUSS ST 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 4x4   6010302.0 2111707.0 37.7789258960759 -122.407927816208 (37.7789258960759, -122.407927816208) 14 2 9 28853 34
7120 108237 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 131 RUSS ST 10 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       4x4   6010302.0 2111707.0 37.7789258960759 -122.407927816208 (37.7789258960759, -122.407927816208) 14 2 9 28853 34
7128 108244 Significant Tree 4 Ulmus parvifolia :: Chinese Elm 26 150 Conrad St 1 Back Yard : Cutout 23 Tree 1 Private 2     20     6001768.8 2096480.0 37.7366348009068 -122.43635744032801 (37.7366348009068, -122.436357440328) 2 7 5 63 7
7358 108480 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 195x 09TH AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5993013.6 2114237.0 37.7848895119291 -122.467918846049 (37.7848895119291, -122.467918846049) 11 6 2 54 11
7359 108481 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 195x 09TH AVE 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5993013.6 2114237.0 37.7848895119291 -122.467918846049 (37.7848895119291, -122.467918846049) 11 6 2 54 11
7360 108482 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 195x 09TH AVE 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5993013.6 2114237.0 37.7848895119291 -122.467918846049 (37.7848895119291, -122.467918846049) 11 6 2 54 11
7767 108869 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 2360 FOLSOM ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1       3x3   6008129.0 2104684.1 37.759520760062706 -122.41494791534299 (37.7595207600627, -122.414947915343) 2 4 7 28859 19
7970 109070 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 3027 16TH ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6006619.6 2106627.5 37.7647719501604 -122.420306113631 (37.7647719501604, -122.420306113631) 8 4 7 28859 19
8063 109162 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 51x OCTAVIA ST 1 Median : Cutout 1 Tree 1 DPW 1     6 3x20   6005650.4 2109419.7 37.772384002649005 -122.42385688843399 (37.772384002649, -122.423856888434) 7 9 11 28852 10
8064 109163 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 6x Octavia St Frontage West 12 Median : Cutout 1 Tree 1 DPW 1       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
8065 109164 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 6x Octavia St Frontage West 11 Median : Cutout 1 Tree 1 DPW 1       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
8066 109165 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 51x OCTAVIA ST 4 Median : Cutout 1 Tree 1 DPW 1       3x20   6005650.4 2109419.7 37.772384002649005 -122.42385688843399 (37.772384002649, -122.423856888434) 7 9 11 28852 10
8067 109166 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 51x OCTAVIA ST 5 Median : Cutout 1 Tree 1 DPW 1       3x20   6005650.4 2109419.7 37.772384002649005 -122.42385688843399 (37.772384002649, -122.423856888434) 7 9 11 28852 10
8068 109167 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 6x Octavia St Frontage West 8 Median : Cutout 1 Tree 1 DPW 1       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
8069 109168 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 6x Octavia St Frontage West 7 Median : Cutout 1 Tree 1 DPW 1       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
8070 109169 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 6x Octavia St Frontage West 6 Median : Cutout 1 Tree 1 DPW 1       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
8072 109170 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 6x Octavia St Frontage West 5 Median : Cutout 1 Tree 1 DPW 1       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
8073 109171 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 6x Octavia St Frontage West 4 Median : Cutout 1 Tree 1 DPW 1       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
8325 109434 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 7 DANVERS ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5999816.1 2105451.8 37.7611580492101 -122.443753102957 (37.7611580492101, -122.443753102957) 15 5 5 28862 3
8377 109498 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 2440 23rd Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     24 3x3   5989239.6228 2098735.6386 37.74210832360679 -122.479840718717 (37.7421083236068, -122.479840718717) 1 8 3 29491 35
8432 109564 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 161 CORBETT AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 3x3   6000370.9 2105589.4 37.7615674935206 -122.441844168883 (37.7615674935206, -122.441844168883) 15 5 5 28862 3
8781 110034 Undocumented 3 Ulmus parvifolia :: Chinese Elm 26 2690 Folsom St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6008245.7 2102789.4 37.754324902547204 -122.414410241803 (37.7543249025472, -122.414410241803) 2 4 7 28859 19

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 79.216ms · Data source: data.sfgov.org