Street_Tree_List

Data source: data.sfgov.org

1,636 rows where qSpecies = 1 sorted by PermitNotes

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
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)
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)
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                    
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)
828 8634 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2600 Geary Blvd 22 Median : Cutout 11 Tree 1 DPW 2     6 20   5999136.363 2113194.1665 37.7823778250539 -122.44666108993299 (37.7823778250539, -122.446661089933)
867 5563 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1000 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3   6005047.93676 2102495.8008 37.753338590028 -122.42544803402399 (37.753338590028, -122.425448034024)
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)
1214 14441 DPW Maintained 3 Myoporum laetum :: Myoporum 1 57 Masonic Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     100 4X4   5998815.3699 2112874.8656 37.781482766726896 -122.447748586483 (37.7814827667269, -122.447748586483)
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)
1687 18887 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2407 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6003191.46268 2115855.10762 37.789914898090004 -122.432822394747 (37.78991489809, -122.432822394747)
2528 138185 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1865 Buchanan St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 Width 0ft   6003940.6794 2114739.7851 37.786894968468 -122.43015057261002 (37.786894968468, -122.43015057261)
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)
3267 2831 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1200 California St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     75 3X3   6008484.02773 2116302.9533599997 37.791443325609606 -122.414542237062 (37.7914433256096, -122.414542237062)
3830 14440 DPW Maintained 3 Myoporum laetum :: Myoporum 1 45 Masonic Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 4X4   5998808.9399 2112938.4889 37.78165709226779 -122.44777541277399 (37.7816570922678, -122.447775412774)
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)
4979 8629 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2600 Geary Blvd 17 Median : Cutout 11 Tree 1 DPW 2     12 20   5999229.0905 2113208.3802 37.78242214856029 -122.44634131765899 (37.7824221485603, -122.446341317659)
5081 253792 Undocumented 2 Myoporum laetum :: Myoporum 1 1698X 08th Ave 2 Unaccepted Street : Yard 14 Tree 1 DPW 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5085 253795 Undocumented 2 Myoporum laetum :: Myoporum 1 1698X 08th Ave 5 Unaccepted Street : Yard 14 Tree 1 DPW 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
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)
5092 253791 Undocumented 2 Myoporum laetum :: Myoporum 1 1698X 08th Ave 1 Unaccepted Street : Yard 14 Tree 1 DPW 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5097 253793 Undocumented 2 Myoporum laetum :: Myoporum 1 1698X 08th Ave 3 Unaccepted Street : Yard 14 Tree 1 DPW 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5099 253794 Undocumented 2 Myoporum laetum :: Myoporum 1 1698X 08th Ave 4 Unaccepted Street : Yard 14 Tree 1 DPW 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5433 8620 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2600 Geary Blvd 8 Median : Cutout 11 Tree 1 DPW 2     6 20   5999320.4644 2113220.5634 37.7824608186771 -122.446026081758 (37.7824608186771, -122.446026081758)
5798 8630 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2600 Geary Blvd 18 Median : Cutout 11 Tree 1 DPW 2     6 20   5999216.9073 2113207.365 37.7824186652585 -122.44638339297501 (37.7824186652585, -122.446383392975)
6574 2832 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1200 California St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 3X3   6008465.75544 2116301.4842 37.7914382651038 -122.414605355047 (37.7914382651038, -122.414605355047)
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)
7106 8639 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2600X Geary Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 3x3   5999285.607000001 2113327.5047 37.7827524611939 -122.446154367514 (37.7827524611939, -122.446154367514)
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)
7236 8621 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2600 Geary Blvd 9 Median : Cutout 11 Tree 1 DPW 2     6 20   5999320.4644 2113213.4566 37.782441305247104 -122.446025570431 (37.7824413052471, -122.446025570431)
7592 98477 DPW Maintained 3 Myoporum laetum :: Myoporum 1 3020 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   5999352.2396 2114673.6817 37.7864525177898 -122.44602070386999 (37.7864525177898, -122.44602070387)
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)
8418 98478 DPW Maintained 3 Myoporum laetum :: Myoporum 1 3022 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     10 3x3   5999322.5683 2114670.9216 37.7864432448969 -122.44612316014201 (37.7864432448969, -122.446123160142)
8476 8633 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2600 Geary Blvd 21 Median : Cutout 11 Tree 1 DPW 2     12 20   5999163.0983 2113201.6118 37.7823997950612 -122.44656913375401 (37.7823997950612, -122.446569133754)
8703 2829 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1200 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     80 3X3   6008547.0936900005 2116310.73962 37.7914682476113 -122.414324580422 (37.7914682476113, -122.414324580422)
8762 8614 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2660 Geary Blvd 2 Median : Cutout 11 Tree 1 DPW 2     6 20   5998899.9753 2113233.2542 37.782471643857896 -122.44748169838999 (37.7824716438579, -122.44748169839)
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)
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)
9684 173630 Significant Tree 6 Myoporum laetum :: Myoporum 1 2699x OCEAN AVE 2 Sidewalk: Property side : Cutout 5 Tree 1 MTA 6 DPW 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
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)
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)
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)
9880 3771 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1100X Carolina St 1 Median : Cutout 11 Tree 1 DPW 2     18 18   6012538.0 2102781.0 37.75454202913279 -122.39956569430599 (37.7545420291328, -122.399565694306)
9884 173718 DPW Maintained 3 Myoporum laetum :: Myoporum 1 906 Carolina St 1 Median : Cutout 11 Tree 1 DPW 2     15 3x3   6012418.0 2103694.0 37.757042237838796 -122.400044801952 (37.7570422378388, -122.400044801952)
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)
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)
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)
10779 831 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1388 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 5.5x6.5   5981551.002 2105650.5805 37.7606451268888 -122.506937898142 (37.7606451268888, -122.506937898142)
10811 823 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1381 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3X3   5981813.5224 2105689.4462 37.760767297588295 -122.50603285620599 (37.7607672975883, -122.506032856206)
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)
11201 19747 DPW Maintained 3 Myoporum laetum :: Myoporum 1 100 STAIRWAY15 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 10ST            
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)
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)
11806 15748 DPW Maintained 3 Myoporum laetum :: Myoporum 1 4617 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6002094.7066 2092005.3194 37.7243668615839 -122.43491072988998 (37.7243668615839, -122.43491072989)
11842 19713 DPW Maintained 3 Myoporum laetum :: Myoporum 1 100 STAIRWAY13 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 40ST            
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)
12182 19712 DPW Maintained 3 Myoporum laetum :: Myoporum 1 100 STAIRWAY13 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 40ST            
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)
12649 24533 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1395 47th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   5981505.7764 2105644.9273 37.7606269413357 -122.507093890918 (37.7606269413357, -122.507093890918)
13008 19766 DPW Maintained 3 Myoporum laetum :: Myoporum 1 100 STAIRWAY16 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 30ST            
13014 24510 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1400 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 3X3   5981246.2202 2105482.1578 37.7601647328681 -122.507979481979 (37.7601647328681, -122.507979481979)
13219 24279 DPW Maintained 3 Myoporum laetum :: Myoporum 1 350X Winding Way 17 Median : Cutout 11 Tree 1 DPW 2     6 8   6000809.6312 2086798.35513 37.709996659695 -122.43898005820299 (37.709996659695, -122.438980058203)
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)
14337 19746 DPW Maintained 3 Myoporum laetum :: Myoporum 1 100 STAIRWAY15 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3            
14544 19711 DPW Maintained 3 Myoporum laetum :: Myoporum 1 100 STAIRWAY13 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 40ST            
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)
14667 3750 DPW Maintained 3 Myoporum laetum :: Myoporum 1 900 Carolina St 1 Median : Cutout 11 Tree 1 DPW 2     3 18   6012463.2126 2103693.82662 37.7570442824941 -122.39988842642401 (37.7570442824941, -122.399888426424)
15372 116055 Undocumented 2 Myoporum laetum :: Myoporum 1 650x Kansas St 11 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/30/2016 12:00:00 AM 3 4x4   6011513.13975 2105199.40577 37.7611252557522 -122.40328006754801 (37.7611252557522, -122.403280067548)
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)
15820 19764 DPW Maintained 3 Myoporum laetum :: Myoporum 1 100 STAIRWAY16 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 30ST            
16592 19752 DPW Maintained 3 Myoporum laetum :: Myoporum 1 100 STAIRWAY15 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 10ST            
16910 7017 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1055 Fell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6002366.0432 2110180.0215 37.774285696400206 -122.435272167554 (37.7742856964002, -122.435272167554)
17169 29607 DPW Maintained 3 Myoporum laetum :: Myoporum 1 900X Junipero Serra Blvd 16 Median : Cutout 11 Tree 1 DPW 2   03/09/2013 12:00:00 AM 3 3X3   5991176.48666 2091034.59302 37.7210755258009 -122.472582381082 (37.7210755258009, -122.472582381082)
17299 8210 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2189X Funston Ave 1 Median : Cutout 11 Tree 1 DPW 2     3 8X25   5992281.31882 2100517.50117 37.7471771044468 -122.469453261968 (37.7471771044468, -122.469453261968)
17380 4177 DPW Maintained 3 Myoporum laetum :: Myoporum 1 3811 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6005046.8356800005 2100458.58709 37.7477448104687 -122.425306883625 (37.7477448104687, -122.425306883625)
17849 26939 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1000 Dolores St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3   6005048.52765 2102486.42553 37.7533128811044 -122.42544532345501 (37.7533128811044, -122.425445323455)
17876 4225 DPW Maintained 3 Myoporum laetum :: Myoporum 1 3982 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6004042.0862300005 2100445.7636700002 37.747652784654704 -122.428780340555 (37.7476527846547, -122.428780340555)
17928 22547 DPW Maintained 3 Myoporum laetum :: Myoporum 1 15 Topaz Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 2X3   6001443.018180001 2098660.99719 37.7426047928778 -122.437639954147 (37.7426047928778, -122.437639954147)
18018 4976 DPW Maintained 3 Myoporum laetum :: Myoporum 1 5200X Diamond Heights Blvd 12 Median : Cutout 11 Tree 1 DPW 2     12 12   6000724.3855206 2099633.2111664 37.7452333754909 -122.440194472866 (37.7452333754909, -122.440194472866)
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)
18335 8215 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2189X Funston Ave 6 Median : Cutout 11 Tree 1 DPW 2     3 8X25   5992282.36795 2100542.6208599997 37.7472461372953 -122.469451462412 (37.7472461372953, -122.469451462412)
18536 8217 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2189X Funston Ave 8 Median : Cutout 11 Tree 1 DPW 2     6 8X25   5992282.7442 2100560.49724 37.7472952429876 -122.469451462429 (37.7472952429876, -122.469451462429)

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 1069.239ms · Data source: data.sfgov.org