Street_Tree_List

Data source: data.sfgov.org

1,636 rows where qSpecies = 1 sorted by qCaretaker

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker ▼ qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1 141565 Permitted Site 1 Myoporum laetum :: Myoporum 1 501X Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/1988 12:00:00 AM 21 Width 0ft Permit Number 25401 6000609.0 2110829.0 37.7759676911831 -122.441396661871 (37.7759676911831, -122.441396661871)
6 141566 Permitted Site 1 Myoporum laetum :: Myoporum 1 501X Baker St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   6000587.8822 2110733.5952 37.7757045307049 -122.441462866076 (37.7757045307049, -122.441462866076)
35 183515 Undocumented 2 Myoporum laetum :: Myoporum 1 2562 26th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   03/21/2017 12:00:00 AM 3 Width 0ft Permit Number 779639 5988336.7554 2097879.9474 37.7397063254514 -122.482899813956 (37.7397063254514, -122.482899813956)
114 251216 Significant Tree 6 Myoporum laetum :: Myoporum 1 399X Townsend St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
118 251217 Significant Tree 6 Myoporum laetum :: Myoporum 1 399X Townsend St 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
191 210495 Undocumented 2 Myoporum laetum :: Myoporum 1 365 San Leandro Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 3ft Permit Number 779799 5992304.44524 2094447.3559700001 37.7305113566072 -122.468931622808 (37.7305113566072, -122.468931622808)
263 141358 Undocumented 2 Myoporum laetum :: Myoporum 1 1499X Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 0ft   6000919.0 2110350.0 37.77467013322371 -122.44028993459101 (37.7746701332237, -122.440289934591)
595 119606 Significant Tree 6 Myoporum laetum :: Myoporum 1 299x Avalon Ave 2 Front Yard : Yard 7 Tree 1 Private 1                    
654 122328 Undocumented 2 Myoporum laetum :: Myoporum 1 3015 Turk Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/14/2017 12:00:00 AM 3 3x3 Permit Number 779630 5996535.0 2111432.0 37.7773904414434 -122.455533202662 (37.7773904414434, -122.455533202662)
694 120738 Undocumented 2 Myoporum laetum :: Myoporum 1 700x 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/17/2017 12:00:00 AM 3 Width 4ft   5989768.19982 2110516.41697 37.7744858825371 -122.478874537994 (37.7744858825371, -122.478874537994)
717 106656 Undocumented 2 Myoporum laetum :: Myoporum 1 700X 20TH AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/17/2017 12:00:00 AM 3 3x3 Permit Number 779658 5989753.9107099995 2110247.9151 37.773747820615704 -122.47890432357 (37.7737478206157, -122.47890432357)
720 104746 Undocumented 2 Myoporum laetum :: Myoporum 1 700X 20th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/17/2017 12:00:00 AM 3 3x3 Permit Number 779658 5989767.16587 2110527.4876599996 37.774516219561704 -122.478878924469 (37.7745162195617, -122.478878924469)
883 251306 Undocumented 2 Myoporum laetum :: Myoporum 1 1 Cashmere St 5 Back Yard : Yard 13 Tree 1 Private 1       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
885 251305 Undocumented 2 Myoporum laetum :: Myoporum 1 1 Cashmere St 4 Back Yard : Yard 13 Tree 1 Private 1       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
891 251304 Undocumented 2 Myoporum laetum :: Myoporum 1 1 Cashmere St 3 Back Yard : Yard 13 Tree 1 Private 1 Health Dept 5     3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
1011 232310 Permitted Site 1 Myoporum laetum :: Myoporum 1 1018 Shrader St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/18/2016 12:00:00 AM 26 Width 3ft Permit Number 17854 5997696.0 2107004.0 37.7652988449505 -122.451197528579 (37.7652988449505, -122.451197528579)
1095 54070 Permitted Site 1 Myoporum laetum :: Myoporum 1 1649 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/27/1972 12:00:00 AM 1   Permit Number 9793 5981260.4052 2103836.5943 37.7556473215408 -122.50780830550801 (37.7556473215408, -122.507808305508)
1262 251479 Undocumented 2 Myoporum laetum :: Myoporum 1 1214 29th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 779194 5987090.84961 2106996.2792700003 37.7646647351899 -122.48787719677 (37.7646647351899, -122.48787719677)
1333 187634 Undocumented 2 Myoporum laetum :: Myoporum 1 148 28th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 779931 5987142.0 2114987.0 37.786607985699604 -122.48828755026399 (37.7866079856996, -122.488287550264)
1412 120316 Undocumented 2 Myoporum laetum :: Myoporum 1 330 23rd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/15/2017 12:00:00 AM 3 Width 3ft Permit Number 779745 5988743.0107 2113100.3508099997 37.7815210589505 -122.482610207249 (37.7815210589505, -122.482610207249)
1423 54061 Permitted Site 1 Myoporum laetum :: Myoporum 1 330 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/27/1972 12:00:00 AM 12   Permit Number 779745 5988745.7457 2113084.32895 37.7814772265446 -122.482599571173 (37.7814772265446, -122.482599571173)
1465 210473 Permitted Site 1 Myoporum laetum :: Myoporum 1 855 Lincoln Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/26/2016 12:00:00 AM 14 Width 3ft Permit Number 41828 5993066.85825 2107284.5743400003 37.765803096458995 -122.46722890580901 (37.765803096459, -122.467228905809)
1545 142037 Undocumented 2 Myoporum laetum :: Myoporum 1 1499X Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 0ft   6000824.0 2111032.0 37.7765373235881 -122.44066748676701 (37.7765373235881, -122.440667486767)
1549 142039 Undocumented 2 Myoporum laetum :: Myoporum 1 1499X Fulton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   6000824.0 2111032.0 37.7765373235881 -122.44066748676701 (37.7765373235881, -122.440667486767)
1550 142038 Undocumented 2 Myoporum laetum :: Myoporum 1 1499X Fulton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   6000824.0 2111032.0 37.7765373235881 -122.44066748676701 (37.7765373235881, -122.440667486767)
1992 232379 Permitted Site 1 Myoporum laetum :: Myoporum 1 4235 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/1972 12:00:00 AM 16 Width 3ft Permit Number 10249 6001645.52772 2101734.6442400003 37.751055812089 -122.43715975664499 (37.751055812089, -122.437159756645)
2855 110902 Undocumented 2 Myoporum laetum :: Myoporum 1 2300x Franklin St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3x3   6005485.732559999 2117962.0378900003 37.795829853409295 -122.425034389936 (37.7958298534093, -122.425034389936)
4023 232380 Permitted Site 1 Myoporum laetum :: Myoporum 1 737 Elizabeth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 5ft   6001617.91184 2102022.2796 37.7518440201921 -122.437275848296 (37.7518440201921, -122.437275848296)
4468 253632 Undocumented 2 Myoporum laetum :: Myoporum 1 527 Oak St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6004455.0 2110106.0 37.7742008582336 -122.42804080634701 (37.7742008582336, -122.428040806347)
4547 131706 Undocumented 2 Myoporum laetum :: Myoporum 1 135 Locust St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   5997495.0 2115921.0 37.789771092089794 -122.452536302556 (37.7897710920898, -122.452536302556)
4551 131707 Undocumented 2 Myoporum laetum :: Myoporum 1 135 Locust St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   5997495.0 2115921.0 37.789771092089794 -122.452536302556 (37.7897710920898, -122.452536302556)
5086 110900 Undocumented 2 Myoporum laetum :: Myoporum 1 2300x Franklin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3x3   6005496.29651 2117906.44165 37.795677796936495 -122.42499387908998 (37.7956777969365, -122.42499387909)
5601 116211 Undocumented 2 Myoporum laetum :: Myoporum 1 3801 Sacramento St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/30/2016 12:00:00 AM 3 3x3 Permit Number 778748 5996580.5135 2114939.45555 37.7870235965959 -122.455629343026 (37.7870235965959, -122.455629343026)
5802 122541 Undocumented 2 Myoporum laetum :: Myoporum 1 2233 Post St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/23/2016 12:00:00 AM 3 3x3 Permit Number 779046 6001437.2497 2113869.2014 37.7843624618515 -122.438749438347 (37.7843624618515, -122.438749438347)
6978 6035 Permitted Site 1 Myoporum laetum :: Myoporum 1 1826 Eddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6001552.687000001 2112546.4084 37.780736975678295 -122.438255270265 (37.7807369756783, -122.438255270265)
7105 61394 Permitted Site 1 Myoporum laetum :: Myoporum 1 2584 Post St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/20/1984 12:00:00 AM 15 3x3 Permit Number 21315 5999837.8956 2113700.6918 37.7838086607697 -122.44427051519399 (37.7838086607697, -122.444270515194)
7131 116025 Permitted Site 1 Myoporum laetum :: Myoporum 1 1425 Vallejo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/02/2016 12:00:00 AM 3 3x3   6006694.6941 2118351.37216 37.796967084814 -122.42087880533501 (37.796967084814, -122.420878805335)
7159 116209 Undocumented 2 Myoporum laetum :: Myoporum 1 3801 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/30/2016 12:00:00 AM 3 3x3 Permit Number 778748 5996627.1701 2114945.18052 37.787041993130295 -122.455468336508 (37.7870419931303, -122.455468336508)
7502 116210 Undocumented 2 Myoporum laetum :: Myoporum 1 3801 Sacramento St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/30/2016 12:00:00 AM 3 3x3 Permit Number 778748 5996604.94532 2114941.4574599997 37.787030495305 -122.455544959643 (37.787030495305, -122.455544959643)
8062 110903 Undocumented 2 Myoporum laetum :: Myoporum 1 2300x Franklin St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3x3   6005480.89181 2117982.83198 37.7958866752705 -122.425052620105 (37.7958866752705, -122.425052620105)
8281 114455 Undocumented 2 Myoporum laetum :: Myoporum 1 1985 Golden Gate Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 3x3   6000100.5375 2111597.9948 37.7780501757265 -122.44321080446801 (37.7780501757265, -122.443210804468)
8845 101651 Undocumented 2 Myoporum laetum :: Myoporum 1 2X Masonic Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   5999032.2983 2113371.3303 37.782858325822 -122.447033859882 (37.782858325822, -122.447033859882)
8885 53229 Permitted Site 1 Myoporum laetum :: Myoporum 1 1435 Pacific Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/08/2016 12:00:00 AM 3 3x3 Permit Number 6112 6007249.74611 2117746.2070299997 37.795336722764795 -122.41891524533999 (37.7953367227648, -122.41891524534)
9190 2472 Permitted Site 1 Myoporum laetum :: Myoporum 1 2031X Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/26/1993 12:00:00 AM 12 4X4   6003774.0905 2114890.3514 37.7872989488923 -122.43073768033301 (37.7872989488923, -122.430737680333)
9615 138532 Undocumented 2 Myoporum laetum :: Myoporum 1 1670 Scott St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6001631.8101 2114208.4561 37.785305035186894 -122.438100638619 (37.7853050351869, -122.438100638619)
9779 114426 Undocumented 2 Myoporum laetum :: Myoporum 1 486 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 4x4   5985968.50007 2112632.43388 37.7800744897886 -122.49217408228901 (37.7800744897886, -122.492174082289)
9808 121557 Undocumented 2 Myoporum laetum :: Myoporum 1 421 Alvarado St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/2016 12:00:00 AM 3 3x3 Permit Number 779269 6003622.0 2102696.0 37.7538076209017 -122.430393500907 (37.7538076209017, -122.430393500907)
9810 121556 Undocumented 2 Myoporum laetum :: Myoporum 1 421 Alvarado St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3 Permit Number 779269 6003622.0 2102696.0 37.7538076209017 -122.430393500907 (37.7538076209017, -122.430393500907)
9833 173705 Undocumented 2 Myoporum laetum :: Myoporum 1 181 Addison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6002695.0 2097057.0 37.738271693727796 -122.433196386583 (37.7382716937278, -122.433196386583)
9861 118901 Undocumented 2 Myoporum laetum :: Myoporum 1 7300 Fulton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2017 12:00:00 AM 3 3x3 Permit Number 779332 5980648.88475 2109606.3629099997 37.7714533859213 -122.510351791198 (37.7714533859213, -122.510351791198)
9868 173714 Undocumented 2 Myoporum laetum :: Myoporum 1 699x 29th St 3 Front Yard : Cutout 8 Tree 1 Private 1       3x3   6002089.0 2098776.0 37.7429572717864 -122.435414565427 (37.7429572717864, -122.435414565427)
9873 118917 Undocumented 2 Myoporum laetum :: Myoporum 1 855 La Playa 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2017 12:00:00 AM 3 4x4   5980738.79777 2109987.23765 37.772504459681 -122.510069084185 (37.772504459681, -122.510069084185)
9874 118902 Undocumented 2 Myoporum laetum :: Myoporum 1 7300 Fulton St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2017 12:00:00 AM 3 3x3 Permit Number 779332 5980610.1556400005 2109606.19987 37.771450653513206 -122.510485742594 (37.7714506535132, -122.510485742594)
9912 173731 Significant Tree 6 Myoporum laetum :: Myoporum 1 484 Chenery St 1 Front Yard : Yard 7 Tree 1 Private 1           6003566.0 2096120.0 37.7357482768139 -122.43011807363199 (37.7357482768139, -122.430118073632)
9946 173747 Undocumented 2 Myoporum laetum :: Myoporum 1 2799x 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5981791.0 2096580.0 37.735753982711294 -122.50543552617201 (37.7357539827113, -122.505435526172)
10036 64803 Permitted Site 1 Myoporum laetum :: Myoporum 1 110X VALLEY ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/24/2017 12:00:00 AM 3   Permit Number 779438 6005124.0 2099350.0 37.7447052436017 -122.424961191686 (37.7447052436017, -122.424961191686)
10037 122341 Undocumented 2 Myoporum laetum :: Myoporum 1 401 04th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/24/2017 12:00:00 AM 3 3x3   5994600.0 2112752.0 37.780903582725 -122.462322713118 (37.780903582725, -122.462322713118)
10039 106657 Undocumented 2 Myoporum laetum :: Myoporum 1 706 20TH AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/02/2016 12:00:00 AM 10 3x3   5989753.9107099995 2110247.9151 37.773747820615704 -122.47890432357 (37.7737478206157, -122.47890432357)
10229 173709 Permitted Site 1 Myoporum laetum :: Myoporum 1 26 Alma St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/09/2017 12:00:00 AM 3 7x6   5998468.52120725 2106293.91375272 37.76339332794971 -122.448474428781 (37.7633933279497, -122.448474428781)
10231 56289 Permitted Site 1 Myoporum laetum :: Myoporum 1 26 Alma St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/1973 12:00:00 AM 3 7x6 Permit Number 12417 5998468.52120725 2106293.91375272 37.76339332794971 -122.448474428781 (37.7633933279497, -122.448474428781)
10258 173932 Undocumented 2 Myoporum laetum :: Myoporum 1 1109x Alemany Blvd   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6003491.0 2094313.0 37.7307824159859 -122.430248501015 (37.7307824159859, -122.430248501015)
10642 113534 Undocumented 2 Myoporum laetum :: Myoporum 1 3601 Wawona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   5981793.2608 2096687.6431 37.7360496742075 -122.505435686033 (37.7360496742075, -122.505435686033)
10678 116741 Permitted Site 1 Myoporum laetum :: Myoporum 1 1631 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/14/2017 12:00:00 AM 3 3x3 Permit Number 779477 5983734.6502 2104037.3849 37.7563440999856 -122.499266557723 (37.7563440999856, -122.499266557723)
11098 64696 Permitted Site 1 Myoporum laetum :: Myoporum 1 1055 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/13/1988 12:00:00 AM 6 3x3 Permit Number 25639 5989879.8498 2099000.4177 37.742872512219 -122.47764638889299 (37.742872512219, -122.477646388893)
11179 97318 Permitted Site 1 Myoporum laetum :: Myoporum 1 1026 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3x3   5989977.5691 2099069.2019 37.7430670461122 -122.477313532312 (37.7430670461122, -122.477313532312)
11232 110349 Undocumented 2 Myoporum laetum :: Myoporum 1 1948 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   5989635.8842 2106540.7717 37.7635621624427 -122.479041373687 (37.7635621624427, -122.479041373687)
11276 110108 Undocumented 2 Myoporum laetum :: Myoporum 1 4130 Moraga St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/03/2017 12:00:00 AM 3 3x3   5981417.4705 2103534.0756 37.75482594364829 -122.507242691355 (37.7548259436483, -122.507242691355)
11284 105132 Undocumented 2 Myoporum laetum :: Myoporum 1 1619 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/14/2016 12:00:00 AM   3x3 Permit Number 777355 5981562.16 2104041.1764 37.756226819608 -122.50677993398399 (37.756226819608, -122.506779933984)
11349 104508 Undocumented 2 Myoporum laetum :: Myoporum 1 80 Dichiera Ct 1 Sidewalk: Curb side : Hanging Pot 15 Tree 1 Private 1     14     5998566.299869999 2087993.98473 37.7131516918716 -122.446819386407 (37.7131516918716, -122.446819386407)
11464 97310 Permitted Site 1 Myoporum laetum :: Myoporum 1 916 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3x3   5990323.69 2099081.1313 37.7431198777207 -122.476117623457 (37.7431198777207, -122.476117623457)
11465 107858 Permitted Site 1 Myoporum laetum :: Myoporum 1 2908 Sloat Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/17/2016 12:00:00 AM 3 3x3 Permit Number 778432 5981789.5382 2096536.8762 37.735635490547 -122.505437384685 (37.735635490547, -122.505437384685)
11510 107860 Undocumented 2 Myoporum laetum :: Myoporum 1 3667 Wawona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 777933 5981683.9506 2096685.2741 37.7360367363779 -122.505813433386 (37.7360367363779, -122.505813433386)
11593 116739 Permitted Site 1 Myoporum laetum :: Myoporum 1 1678 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 778366 5983788.3957 2103743.2164 37.755539548337204 -122.49905895584999 (37.7555395483372, -122.49905895585)
11968 105207 Undocumented 2 Myoporum laetum :: Myoporum 1 2928 Sloat Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   5981748.5891 2096534.5072 37.7356265760949 -122.50557878346301 (37.7356265760949, -122.505578783463)
12286 97316 Permitted Site 1 Myoporum laetum :: Myoporum 1 1000 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 3x3   5990092.4633 2099074.5321 37.7430883471851 -122.47691665284201 (37.7430883471851, -122.476916652842)
12647 115149 Permitted Site 1 Myoporum laetum :: Myoporum 1 2430 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 4x4 Permit Number 777450 5987687.2149 2098724.2655 37.7419867848349 -122.48520755477199 (37.7419867848349, -122.485207554772)
12762 116742 Permitted Site 1 Myoporum laetum :: Myoporum 1 1638 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/02/2016 12:00:00 AM 3 6x3 Permit Number 778698 5983780.8141 2103988.0199 37.756211265636296 -122.499103262084 (37.7562112656363, -122.499103262084)
13181 117441 Permitted Site 1 Myoporum laetum :: Myoporum 1 1204 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/07/2016 12:00:00 AM 3 3x3 Permit Number 778732 5989885.5669 2107139.7037 37.765221164359495 -122.47822160390498 (37.7652211643595, -122.478221603905)
13254 115458 Permitted Site 1 Myoporum laetum :: Myoporum 1 476 FAIR OAKS ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6005502.0 2100939.0 37.7490896185955 -122.423767101444 (37.7490896185955, -122.423767101444)
13301 187651 Significant Tree 6 Myoporum laetum :: Myoporum 1 175 Raccoon Dr 1 Back Yard : Yard 13 Tree 1 Private 1           5998689.0 2104063.0 37.7572803991188 -122.447551270828 (37.7572803991188, -122.447551270828)
14583 25961 Permitted Site 1 Myoporum laetum :: Myoporum 1 2193 Oakdale Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/30/2000 12:00:00 AM 3 2x3   6011423.37679 2098134.57194 37.7417217530491 -122.403093568809 (37.7417217530491, -122.403093568809)
15432 25962 Permitted Site 1 Myoporum laetum :: Myoporum 1 2193 Oakdale Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/22/1997 12:00:00 AM 3 2X3   6011447.1772300005 2098118.06457 37.7416777564365 -122.40301011353901 (37.7416777564365, -122.403010113539)
18158 96243 Undocumented 2 Myoporum laetum :: Myoporum 1 100X 27th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3   6005866.5 2100251.5 37.7472224703829 -122.42245781101299 (37.7472224703829, -122.422457811013)
18727 3939 Permitted Site 1 Myoporum laetum :: Myoporum 1 999X 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6002271.23678 2107631.4399099997 37.7672825369934 -122.43541777162201 (37.7672825369934, -122.435417771622)
19078 16995 Permitted Site 1 Myoporum laetum :: Myoporum 1 900 Oak St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/11/2007 12:00:00 AM 3 3X3   6002566.6368 2109915.0941 37.7735696608208 -122.43455933158998 (37.7735696608208, -122.43455933159)
20976 108213 Undocumented 2 Myoporum laetum :: Myoporum 1 126 Clement St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5995164.0 2113575.0 37.783195780257 -122.46043122472 (37.783195780257, -122.46043122472)
21679 210472 Undocumented 2 Myoporum laetum :: Myoporum 1 624 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 4ft   5993801.69661 2106684.35823 37.764197452264106 -122.464643687651 (37.7641974522641, -122.464643687651)
22884 119188 Undocumented 2 Myoporum laetum :: Myoporum 1 850 La Playa 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5980787.759319999 2110046.86087 37.7726710552755 -122.509904154395 (37.7726710552755, -122.509904154395)
22903 131740 Undocumented 2 Myoporum laetum :: Myoporum 1 2901 Jackson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 3ft   6000252.76516 2116432.30199 37.7913326127476 -122.443031463558 (37.7913326127476, -122.443031463558)
22912 210552 Undocumented 2 Myoporum laetum :: Myoporum 1 414 Dewey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 3ft   5995155.65345 2100448.38141 37.7471530116111 -122.459509101961 (37.7471530116111, -122.459509101961)
22975 114454 Undocumented 2 Myoporum laetum :: Myoporum 1 1985 GOLDEN GATE AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/12/2016 12:00:00 AM 3 3x3   6000094.0 2111584.0 37.7780113768023 -122.44323241454501 (37.7780113768023, -122.443232414545)
23432 232311 Undocumented 2 Myoporum laetum :: Myoporum 1 1210 Shrader St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5997778.57601 2106237.8657400003 37.763199962017495 -122.450856672402 (37.7631999620175, -122.450856672402)
23578 181600 Undocumented 2 Myoporum laetum :: Myoporum 1 1300 Lower Great Hwy 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   5980858.6373 2105611.0043 37.7604956636473 -122.50932949211399 (37.7604956636473, -122.509329492114)
23645 131755 Undocumented 2 Myoporum laetum :: Myoporum 1 1856 Pacific Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     28 Width 4ft   6005252.93645 2117501.9314 37.7945533647075 -122.425807142281 (37.7945533647075, -122.425807142281)
23747 186497 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 17 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5980894.6551 2105244.501 37.7594914745751 -122.509177708249 (37.7594914745751, -122.509177708249)
23806 232314 Undocumented 2 Myoporum laetum :: Myoporum 1 99 Elsie St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5     6007320.806890001 2098778.15204 37.7432589210582 -122.417324523624 (37.7432589210582, -122.417324523624)
23867 232408 Undocumented 2 Myoporum laetum :: Myoporum 1 387 Beacon St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 3ft   6002395.6787 2098158.1545599997 37.7412782244979 -122.43430999392099 (37.7412782244979, -122.434309993921)
23868 182925 Undocumented 2 Myoporum laetum :: Myoporum 1 2630 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 0ft   5982150.6342 2097187.3229 37.737442682143204 -122.50423712648701 (37.7374426821432, -122.504237126487)
24163 194035 Undocumented 2 Myoporum laetum :: Myoporum 1 1433 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     28 Width 3ft   6012914.68454 2106566.8968 37.7649582598465 -122.398528655089 (37.7649582598465, -122.398528655089)
24344 232330 Undocumented 2 Myoporum laetum :: Myoporum 1 1801 Diamond St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 6ft   6002073.993430001 2098798.17814 37.743017315492295 -122.435468040134 (37.7430173154923, -122.435468040134)

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" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 994.903ms · Data source: data.sfgov.org