Street_Tree_List

Data source: data.sfgov.org

26,519 rows where qLegalStatus = 3 sorted by qSpecies

View and edit SQL

Suggested facets: qCareAssistant

Link rowid TreeID qLegalStatus qSpecies ▼ qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
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)
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)
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)
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)
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)
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)
6568 92750 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2049 Grove St 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 10/02/2009 12:00:00 AM 12 3x3 Permit Number 52971 5998090.3691 2110284.0117 37.774327490890705 -122.450069934151 (37.7743274908907, -122.450069934151)
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)
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)
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)
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)
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)
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)
11201 19747 DPW Maintained 3 Myoporum laetum :: Myoporum 1 100 STAIRWAY15 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 10ST            
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            
12182 19712 DPW Maintained 3 Myoporum laetum :: Myoporum 1 100 STAIRWAY13 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 40ST            
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)
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            
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)
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)
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)
18961 8216 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2189X Funston Ave 7 Median : Cutout 11 Tree 1 DPW 2     6 8X25   5992283.56126 2100549.85323 37.7472660644888 -122.469447862447 (37.7472660644888, -122.469447862447)
18962 29617 DPW Maintained 3 Myoporum laetum :: Myoporum 1 900X Junipero Serra Blvd 26 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 3 3X3   5991168.23882 2090896.94142 37.7206970910675 -122.472600860348 (37.7206970910675, -122.472600860348)
19157 22548 DPW Maintained 3 Myoporum laetum :: Myoporum 1 19 Topaz Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 2X3   6001457.66842 2098646.06303 37.7425646201593 -122.437588228722 (37.7425646201593, -122.437588228722)
19162 9363 DPW Maintained 3 Myoporum laetum :: Myoporum 1 256 Gold Mine Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 2x2   6001113.86641 2098278.49055 37.7415357993513 -122.43875065912901 (37.7415357993513, -122.438750659129)
19720 8219 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2189X Funston Ave 10 Median : Cutout 11 Tree 1 DPW 2     6 8X25   5992283.90112 2100578.3571900004 37.747344348682795 -122.469448761774 (37.7473443486828, -122.469448761774)
20221 4226 DPW Maintained 3 Myoporum laetum :: Myoporum 1 3982 Cesar Chavez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6004028.819080001 2100444.38934 37.7476482601598 -122.42882611964501 (37.7476482601598, -122.428826119645)
20254 23999 DPW Maintained 3 Myoporum laetum :: Myoporum 1 300 West Portal Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 3x3   5992235.8832 2097133.9008 37.7378839736291 -122.469364124733 (37.7378839736291, -122.469364124733)
20399 8212 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2189X Funston Ave 3 Median : Cutout 11 Tree 1 DPW 2     3 8X25   5992284.57704 2100523.9125099997 37.7471948966366 -122.46944246202 (37.7471948966366, -122.46944246202)
20519 29614 DPW Maintained 3 Myoporum laetum :: Myoporum 1 900X Junipero Serra Blvd 24 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 3 3X3   5991166.98096 2090921.81223 37.720765307364395 -122.47260702069599 (37.7207653073644, -122.472607020696)
20958 3909 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1000X 14th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6002142.832230001 2107666.80115 37.7673723370035 -122.43586443430901 (37.7673723370035, -122.435864434309)
21139 8218 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2189X Funston Ave 9 Median : Cutout 11 Tree 1 DPW 2     12 8X25   5992283.97023 2100569.2840400003 37.7473194401374 -122.46944786245199 (37.7473194401374, -122.469447862452)
21350 5101 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2629 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 3x3   6002336.13825 2096372.73058 37.7363724838986 -122.43438824303101 (37.7363724838986, -122.434388243031)
21615 8213 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2189X Funston Ave 4 Median : Cutout 11 Tree 1 DPW 2     6 8X25   5992288.54504 2100526.93925 37.7472034366016 -122.469428961394 (37.7472034366016, -122.469428961394)
22423 18155 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1355 Post St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6005677.61973 2114458.9667 37.7862221342749 -122.42412117337099 (37.7862221342749, -122.424121173371)
22514 18154 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1355 Post St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4x4   6005654.5988300005 2114457.04911 37.7862155692388 -122.42420068332899 (37.7862155692388, -122.424200683329)
22671 18156 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1355 Post St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6005730.74632 2114465.38856 37.786242766547105 -122.42393782586399 (37.7862427665471, -122.423937825864)
23048 8638 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2600X Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     26 0   5999322.495 2113336.6421 37.782779656634396 -122.44602740853901 (37.7827796566344, -122.446027408539)
23093 26475 DPW Maintained 3 Myoporum laetum :: Myoporum 1 106 Gold Mine Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     19 3X3   6001338.90016 2098832.9571 37.7430710337942 -122.438012277952 (37.7430710337942, -122.438012277952)
23165 25259 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1630 Ocean Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 3X3   5994884.3509 2092299.7091 37.724763157858796 -122.45985706395399 (37.7247631578588, -122.459857063954)
23246 8613 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2660 Geary Blvd 1 Median : Cutout 11 Tree 1 DPW 2     17 20   5998899.2985 2113220.7326 37.7824372241255 -122.447483138223 (37.7824372241255, -122.447483138223)
24433 232350 DPW Maintained 3 Myoporum laetum :: Myoporum 1 500x 27th St 8 Median : Cutout 11 Tree 1 DPW 2     7 Width 4ft   6002774.61344 2100063.62492 37.746531703279096 -122.433135885834 (37.7465317032791, -122.433135885834)
29614 210555 DPW Maintained 3 Myoporum laetum :: Myoporum 1 15x San Marcos Ave 22 Median : Cutout 11 Tree 1 DPW 2     7 Width 5ft   5993274.23094 2100297.44327 37.7466302132305 -122.466003890675 (37.7466302132305, -122.466003890675)
35348 194039 DPW Maintained 3 Myoporum laetum :: Myoporum 1 900x Carolina St 74 Median : Yard 3 Tree 1 DPW 2     38     6012510.33858 2102789.20195 37.754563007990896 -122.399661931254 (37.7545630079909, -122.399661931254)
54700 186973 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2900x Sloat Blvd 2 Median : Cutout 11 Tree 1 DPW 2     1 Width 0ft   5981564.792 2096478.003 37.7354606126333 -122.50621004103701 (37.7354606126333, -122.506210041037)
64729 194038 DPW Maintained 3 Myoporum laetum :: Myoporum 1 900x Carolina St 53 Median : Yard 3 Tree 1 DPW 2     7     6012502.8583 2102970.8089 37.7550612440971 -122.39970055084 (37.7550612440971, -122.39970055084)
69884 6036 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1826 Eddy St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6001703.73225 2112585.2403700002 37.7808521880762 -122.43773551469499 (37.7808521880762, -122.437735514695)
76161 90650 DPW Maintained 3 Myoporum laetum :: Myoporum 1 3350 Cabrillo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 04/07/2008 12:00:00 AM 3 3x3   5985244.351217 2110444.86641 37.77402569788379 -122.494517894729 (37.7740256978838, -122.494517894729)
77588 90649 DPW Maintained 3 Myoporum laetum :: Myoporum 1 3350 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 04/07/2008 12:00:00 AM 3 3x3   5985244.351217 2110444.86641 37.77402569788379 -122.494517894729 (37.7740256978838, -122.494517894729)
78065 8632 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2600 Geary Blvd 20 Median : Cutout 11 Tree 1 DPW 2     12 20   5999387.1761445 2113256.6615953 37.7825637442266 -122.44579788601101 (37.7825637442266, -122.445797886011)
78581 20664 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1501X Sunset Blvd 18 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 60   5984817.9532367 2104951.7766639 37.7589182591611 -122.49558761620101 (37.7589182591611, -122.495587616201)
79364 20662 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1501X Sunset Blvd 16 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 60   5984817.9532367 2104951.7766639 37.7589182591611 -122.49558761620101 (37.7589182591611, -122.495587616201)
80150 838 DPW Maintained 3 Myoporum laetum :: Myoporum 1 4255X Judah St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/24/2008 12:00:00 AM 30 3x3   5981362.6566223 2105522.5911084 37.7602826110734 -122.50757979099501 (37.7602826110734, -122.507579790995)
80182 106625 DPW Maintained 3 Myoporum laetum :: Myoporum 1 500X 27TH ST 7 Median : Cutout 11 Tree 1 DPW 2     8 5x400   6003184.0 2100084.0 37.7466108627938 -122.431721727073 (37.7466108627938, -122.431721727073)
81459 25185 DPW Maintained 3 Myoporum laetum :: Myoporum 1 3638 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/19/1996 12:00:00 AM   3X3   6000425.6878797 2103367.625274 37.7554701662116 -122.441495243201 (37.7554701662116, -122.441495243201)
82136 90665 DPW Maintained 3 Myoporum laetum :: Myoporum 1 3636 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 04/07/2008 12:00:00 AM 8 4x4   5984356.369637 2110412.6389740002 37.773885200127 -122.49758714758 (37.773885200127, -122.49758714758)
83577 20596 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1401X Sunset Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 60   5984800.4502922995 2105635.4093669 37.760794298851295 -122.495698574627 (37.7607942988513, -122.495698574627)
83716 15788 DPW Maintained 3 Myoporum laetum :: Myoporum 1 4840 Mission St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6001135.36791 2090627.3686 37.7205288045244 -122.438128360054 (37.7205288045244, -122.438128360054)
84555 2254 DPW Maintained 3 Myoporum laetum :: Myoporum 1 410X Brotherhood Way 7 Median : Cutout 11 Tree 1 DPW 2     25 M   5993748.152574 2087576.478532 37.7117288925291 -122.463442127126 (37.7117288925291, -122.463442127126)
85590 105133 DPW Maintained 3 Myoporum laetum :: Myoporum 1 98X WINFIELD ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6007331.0 2099216.0 37.7444617271859 -122.417320300114 (37.7444617271859, -122.417320300114)
86271 90668 DPW Maintained 3 Myoporum laetum :: Myoporum 1 3700 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 04/07/2008 12:00:00 AM 3 3x3   5984154.259047 2110405.3037610003 37.773853210641605 -122.498285728583 (37.7738532106416, -122.498285728583)
87683 24704 DPW Maintained 3 Myoporum laetum :: Myoporum 1 7040 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3X3   5985122.8914 2112550.40448 37.7797997921083 -122.49509333148701 (37.7797997921083, -122.495093331487)
87836 8626 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2600 Geary Blvd 14 Median : Cutout 11 Tree 1 DPW 2     12 20   5999387.1761445 2113256.6615953 37.7825637442266 -122.44579788601101 (37.7825637442266, -122.445797886011)
88219 2210 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1145 Broderick St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6000813.81573 2112576.3555400004 37.7807771513392 -122.44081352531 (37.7807771513392, -122.44081352531)
88268 16577 DPW Maintained 3 Myoporum laetum :: Myoporum 1 95X Nido Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3X3   5999200.479133099 2112280.3747819 37.779872451802795 -122.446373519186 (37.7798724518028, -122.446373519186)
88353 16576 DPW Maintained 3 Myoporum laetum :: Myoporum 1 95X Nido Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   5999200.479133099 2112280.3747819 37.779872451802795 -122.446373519186 (37.7798724518028, -122.446373519186)
89204 90652 DPW Maintained 3 Myoporum laetum :: Myoporum 1 3400 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/07/2008 12:00:00 AM 3 3x3   5985038.957769999 2110446.28749 37.7740175766633 -122.49522848002199 (37.7740175766633, -122.495228480022)
89335 1457 DPW Maintained 3 Myoporum laetum :: Myoporum 1 160 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/29/1996 12:00:00 AM 18 3X3   5995550.62433 2115045.99929 37.78725698253879 -122.459200223243 (37.7872569825388, -122.459200223243)
89711 1458 DPW Maintained 3 Myoporum laetum :: Myoporum 1 166 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   5995549.24707 2115014.62054 37.7871707457756 -122.45920271513799 (37.7871707457756, -122.459202715138)
90108 18157 DPW Maintained 3 Myoporum laetum :: Myoporum 1 1355 Post St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6005683.2980159 2114458.6818444002 37.7862216727319 -122.42410150769899 (37.7862216727319, -122.424101507699)
90226 90644 DPW Maintained 3 Myoporum laetum :: Myoporum 1 3300X Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 04/07/2008 12:00:00 AM 3 3x3   5985392.933158999 2110450.258895 37.774049198972605 -122.49400432939699 (37.7740491989726, -122.494004329397)
90491 11572 DPW Maintained 3 Myoporum laetum :: Myoporum 1 3906 Judah St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x12   5982438.0 2105598.0 37.7605529521075 -122.50386633030199 (37.7605529521075, -122.503866330302)
91329 25556 DPW Maintained 3 Myoporum laetum :: Myoporum 1 50X Industrial St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 4X4   6012204.29417 2097469.52586 37.7399392564551 -122.400346698766 (37.7399392564551, -122.400346698766)
92309 5042 DPW Maintained 3 Myoporum laetum :: Myoporum 1 5399X Diamond Heights Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6002053.1297196 2098277.9970185 37.741587834770705 -122.435502976689 (37.7415878347707, -122.435502976689)
92712 16571 DPW Maintained 3 Myoporum laetum :: Myoporum 1 95X Nido Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   5999200.479133099 2112280.3747819 37.779872451802795 -122.446373519186 (37.7798724518028, -122.446373519186)

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