Street_Tree_List

Data source: data.sfgov.org

1,824 rows where qSpecies = 47 sorted by SiteOrder

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▼ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
999 251422 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 480x De Long St   Front Yard : Yard 7 Tree 1 Private 1       3x3   5992963.0 2086633.0 37.709093057147996 -122.466087289133 (37.709093057148, -122.466087289133)
90230 98140 Property Tree 7 Cupressus macrocarpa :: Monterey Cypress 47 315 San Marcos Ave   Front Yard : Yard 7 Tree 1 Private 1           5992920.8 2100212.1 37.746375486546704 -122.467219803339 (37.7463754865467, -122.467219803339)
99355 106961 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 325 DWIGHT ST   Sidewalk: Curb side : Yard 2 Tree 1 Private 1           6010604.0 2091349.0 37.7230442144558 -122.405448941518 (37.7230442144558, -122.405448941518)
109226 109516 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 105 MIDCREST WAY   Sidewalk: Property side : Yard 9 Tree 1 Private 1     30 12x12   5998180.4 2101012.8 37.748876224655795 -122.4490904711 (37.7488762246558, -122.4490904711)
112771 109706 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 96 CRESTA VISTA DR   Back Yard : Cutout 16 Tree 1 Private 1           5995602.1 2096103.5 37.7352487002973 -122.45765100803699 (37.7352487002973, -122.457651008037)
114948 113440 Property Tree 7 Cupressus macrocarpa :: Monterey Cypress 47 190 BEACON ST   Back Yard : Yard 13 Tree 1 Private 1     32 3x3   6003193.0 2097540.0 37.739626138558705 -122.43150902083299 (37.7396261385587, -122.431509020833)
122333 97685 Property Tree 7 Cupressus macrocarpa :: Monterey Cypress 47 84 Coventry Ct   Back Yard : Yard 13 Tree 1 Private 1           5997084.0 2096485.0 37.7363812239889 -122.452555087132 (37.7363812239889, -122.452555087132)
122936 107159 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 1000 ESMERALDA AVE   Front Yard : Yard 7 Tree 1 Private 1           6009839.0 2098688.0 37.7431527400861 -122.408610872619 (37.7431527400861, -122.408610872619)
128066 98503 Property Tree 7 Cupressus macrocarpa :: Monterey Cypress 47 208 Glenview Dr   Back Yard : Yard 13 Tree 1 Private 1           5998871.0 2100779.0 37.74827374071911 -122.44668556582701 (37.7482737407191, -122.446685565827)
143207 98706 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 353 UPPER TER   Unaccepted Street : Yard 14 Tree 1 Private 1           5999086.1 2105914.9 37.7623879420949 -122.446311165521 (37.7623879420949, -122.446311165521)
145874 100769 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3701 21st St   Front Yard : Yard 7 Tree 1 Private 1     55   Street tree w/in RoW 6003717.0 2103606.0 37.7563116466144 -122.43012988292 (37.7563116466144, -122.43012988292)
6533 19565 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY1 -11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 100ST            
8903 19566 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY1 -9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 100ST            
293 251262 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          
362 187139 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2301 Sunset Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     39 Width 0ft   5984937.035 2099496.8257 37.7439474344515 -122.494773601416 (37.7439474344515, -122.494773601416)
484 205880 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 44 Mendosa Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     43 Width 3ft   5993348.04769 2101170.42115 37.7490314462559 -122.46581205990499 (37.7490314462559, -122.465812059905)
549 251321 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 100X Monument Way 1 Unaccepted Street : Yard 14 Tree 1 Private 1                    
713 251364 Private 5 Cupressus macrocarpa :: Monterey Cypress 47 138x Gladeview Way 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1                    
763 251373 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 401 Portola Dr 1 Median : Yard 3 Tree 1 DPW 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
784 251384 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 138x Gladeview Way 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5997939.0 2102166.0 37.7520288182083 -122.45000833213699 (37.7520288182083, -122.450008332137)
869 124177 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 8X Almaden Ct 1 Sidewalk: Property side : Yard 9 Tree 1 DPW 2     10 Width 9ft   5995876.0 2112606.0 37.7805760973259 -122.457897862346 (37.7805760973259, -122.457897862346)
961 251408 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 75 Christmas Tree Point Rd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5998776.0 2103023.0 37.75442978774979 -122.447175546291 (37.7544297877498, -122.447175546291)
1029 251428 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 5030 Diamond Heights Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5999555.0 2100128.0 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879)
1030 251424 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 5016 Diamond Heights Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5999555.0 2100128.0 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879)
1098 251438 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2501X Santiago St 1 Median : Yard 3 Tree 1 DPW 2                    
1398 251517 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 145 Bonview St 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   6007188.0 2098162.0 37.7415596321362 -122.417740072125 (37.7415596321362, -122.417740072125)
1604 251632 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 14R Amethyst Way 1 Back Yard : Yard 13 Tree 1 Private 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1625 251623 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 76R Amber Dr 1 Back Yard : Yard 13 Tree 1 Private 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
1626 251635 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 18R Amethyst Way 1 Back Yard : Yard 13 Tree 1 Private 1           5999176.0 2100050.0 37.746289501198795 -122.445578473632 (37.7462895011988, -122.445578473632)
1628 251629 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 8R Amethyst Way 1 Back Yard : Yard 13 Tree 1 Private 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1633 251599 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 740 Moraga St 1 Front Yard : Yard 7 Tree 1 Private 1       3x3   5992006.0 2103899.0 37.756445907456396 -122.470651540396 (37.7564459074564, -122.470651540396)
1643 251614 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 64R Amber Dr 1 Back Yard : Yard 13 Tree 1 Private 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1645 251626 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 2R Amethyst Way 1 Back Yard : Yard 13 Tree 1 Private 1           5999263.0 2100016.0 37.746201111936706 -122.44527519504999 (37.7462011119367, -122.44527519505)
1650 251608 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 56R Amber Dr 1 Back Yard : Yard 13 Tree 1 Private 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1652 251618 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 72R Amber Dr 1 Back Yard : Yard 13 Tree 1 Private 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1736 251677 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 772x Panorama Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5996636.0 2102785.0 37.7536537924326 -122.454558985212 (37.7536537924326, -122.454558985212)
1820 251716 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3929 19th St 1 Front Yard : Yard 7 Tree 1 Private 1           6003450.0 2104734.0 37.75939373993371 -122.431133769968 (37.7593937399337, -122.431133769968)
1822 251717 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 1000X San Jose Ave 1 Front Yard : Yard 7 Tree 1 DPW 2           6004710.0 2096486.0 37.736817957153605 -122.426188866367 (37.7368179571536, -122.426188866367)
2151 252916 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 101 Gold Mine Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001472.0 2098865.0 37.7431665844065 -122.437554349716 (37.7431665844065, -122.437554349716)
2186 252924 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 700 Sanchez St 1 Front Yard : Yard 7 Tree 1 DPW 2           6003672.0 2104202.0 37.757945572264 -122.430328029181 (37.757945572264, -122.430328029181)
2764 253207 Property Tree 7 Cupressus macrocarpa :: Monterey Cypress 47 89 Woodhaven Ct 1 Back Yard : Cutout 16 Tree 1 Private 1       3x3   5996069.0 2103645.0 37.75598259914371 -122.45658197288401 (37.7559825991437, -122.456581972884)
3121 253303 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3132 253339 Property Tree 7 Cupressus macrocarpa :: Monterey Cypress 47 2019X 24th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 PUC 13       3x3   5988853.0 2101569.0 37.7498655183494 -122.481384971136 (37.7498655183494, -122.481384971136)
3208 253368 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 236 Moncada Way 1 Median : Yard 3 Tree 1 DPW 2       10x10   5992398.0 2093455.0 37.7277919980392 -122.468536018982 (37.7277919980392, -122.468536018982)
3361 253428 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3 Valletta Ct 1 Side Yard : Cutout 18 Tree 1 Private 1       6x10   5999319.0 2096479.0 37.736492551957895 -122.44482735214198 (37.7364925519579, -122.444827352142)
3496 253449 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 330 Twin Peaks Blvd 1 Unaccepted Street : Yard 14 Tree 1 Private 1       10x10   5998688.0 2103995.0 37.7570936308358 -122.44754983450599 (37.7570936308358, -122.447549834506)
3981 18927 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2691 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6001960.28459 2115686.06098 37.7893808348161 -122.437070045665 (37.7893808348161, -122.437070045665)
4063 253608 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 400X Portola Dr 1 Median : Cutout 11 Tree 1 DPW 2       10x10   5998814.0 2100235.0 37.746776792757004 -122.44684353081101 (37.746776792757, -122.446843530811)
4447 253626 Property Tree 7 Cupressus macrocarpa :: Monterey Cypress 47 1671 Funston Ave 1 Back Yard : Yard 13 Tree 1 Private 1       10x10   5992125.0 2104081.0 37.756952512450205 -122.47025325330601 (37.7569525124502, -122.470253253306)
4893 253707 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1 Monument Way 1 Unaccepted Street : Yard 14 Tree 1 Private 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
4923 253718 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 227 Madison St 1 Front Yard : Yard 7 Tree 1 Private 1       3x3   6005690.0 2092595.0 37.726189474375204 -122.422524168298 (37.7261894743752, -122.422524168298)
5088 206891 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 1675x 15th Ave 1 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2     24 Width 3ft   5991393.559640001 2103864.47578 37.756315678748706 -122.472767037095 (37.7563156787487, -122.472767037095)
5090 253789 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 1651X 15th Ave 1 Median : Cutout 11 Tree 1 DPW 2       3x2   5991453.0 2104016.0 37.756735165128205 -122.47257252055401 (37.7567351651282, -122.472572520554)
5096 253768 Property Tree 7 Cupressus macrocarpa :: Monterey Cypress 47 100 Raccoon Dr 1 Back Yard : Yard 13 Tree 1 Private 1           5998692.0 2104165.0 37.7575606372552 -122.44754823773899 (37.7575606372552, -122.447548237739)
5102 253784 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 1709X 15th Ave 1 Median : Cutout 11 Tree 1 DPW 2       3x2   5991403.0 2103783.0 37.756092514171904 -122.472728448949 (37.7560925141719, -122.472728448949)
5105 253777 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 90 Cuesta Ct 1 Front Yard : Yard 7 Tree 1 DPW 2           5999757.0 2101744.0 37.750973968576496 -122.443691128062 (37.7509739685765, -122.443691128062)
6006 20312 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 101X Sunset Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 60            
6023 19905 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY35 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 120ST            
6399 20412 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 453X Sunset Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
7834 119605 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 299x Avalon Ave 1 Front Yard : Yard 7 Tree 1 Private 1                    
9172 173599 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 100X Warren Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3x3   5995367.0 2102770.0 37.7535397418859 -122.458946354326 (37.7535397418859, -122.458946354326)
9683 173631 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 99X Everglade Dr 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   5986361.0 2095495.0 37.733042731061104 -122.48955570953301 (37.7330427310611, -122.489555709533)
9916 173733 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 14 Richland Ave 1 Side Yard : Yard 17 Tree 1 DPW 2       3x3   6004601.0 2096122.0 37.7358123337564 -122.426539816145 (37.7358123337564, -122.426539816145)
10134 173877 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2651 San Jose Ave 1 Side Yard : Cutout 18 Tree 1 Private 1       3x3   5997397.0 2088796.0 37.7152869722449 -122.450918658158 (37.7152869722449, -122.450918658158)
10255 112606 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 100X Monument Way 1 Back Yard : Yard 13 Tree 1 Private 1       10x10   5999003.0 2105766.0 37.761974353511896 -122.446587863076 (37.7619743535119, -122.446587863076)
10256 173933 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 190 Beacon St 1 Front Yard : Yard 7 Tree 1 Private 1           6003193.0 2097540.0 37.739626138558705 -122.43150902083299 (37.7396261385587, -122.431509020833)
11591 20428 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 485X Sunset Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 40            
12151 19869 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY33 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 25ST            
13184 20013 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY47 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 100ST            
13268 187627 Private 5 Cupressus macrocarpa :: Monterey Cypress 47 88 States St 1 Back Yard : Yard 13 Tree 1 Private 1           6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423)
13275 187637 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 875 El Camino Del Mar 1 Side Yard : Yard 17 Tree 1 Private 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
13307 187654 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 375 Woodside Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       3x3   5997267.0 2099886.0 37.7457300260474 -122.452167701039 (37.7457300260474, -122.452167701039)
13314 187669 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 554 Valley St 1 Median : Yard 3 Tree 1 Private 1           6002324.0 2099197.0 37.7441265828549 -122.434632098307 (37.7441265828549, -122.434632098307)
14425 19694 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY7 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 12ST            
14521 20280 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 20X Sunset Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 60            
14992 19932 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY38 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 10ST            
15767 19699 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY11 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 40ST            
16807 106757 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 999 Key Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   06/02/2014 12:00:00 AM 36     6013321.202330001 2089752.82506 37.718812992515105 -122.395944254446 (37.7188129925151, -122.395944254446)
18889 106642 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 4540X 17TH ST 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     24     5999139.0 2105833.0 37.762166086231204 -122.446122313424 (37.7621660862312, -122.446122313424)
19685 92559 Permitted Site 1 Cupressus macrocarpa :: Monterey Cypress 47 222 Stanyan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 52905 5996693.0 2111182.0 37.776713072168704 -122.454968563419 (37.7767130721687, -122.454968563419)
21086 23592 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 200X Vasquez Ave 1 Median : Cutout 11 Tree 1 DPW 2     6 8   5994656.2966599995 2099224.9929400003 37.7437651683354 -122.461147162215 (37.7437651683354, -122.461147162215)
22920 251148 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 625 Brotherhood Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22926 251147 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 113x Gladeview Way 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   5997915.0 2102038.0 37.7516759885035 -122.450082102397 (37.7516759885035, -122.450082102397)
23079 8464 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 1900 Geary Blvd 1 Median : Cutout 11 Tree 1 DPW 2     17 8   6002427.515 2113723.6274 37.784019039174794 -122.435313053048 (37.7840190391748, -122.435313053048)
24119 184645 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3430 Moraga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     37 Width 0ft   5983573.582 2103608.0944 37.7551559377943 -122.49979184963699 (37.7551559377943, -122.499791849637)
24947 206807 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 11x Saint Francis Blvd 1 Median : Yard 3 Tree 1 DPW 2     12     5991689.221530001 2095992.9314700002 37.734719554257296 -122.471171081279 (37.7347195542573, -122.471171081279)
25672 247989 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 130 Mullen Ave 1 Front Yard : Yard 7 Tree 1 Private 1     15 Width 10ft   6009899.29934 2099821.3308900003 37.7462679959733 -122.40848229933901 (37.7462679959733, -122.408482299339)
26174 206899 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 901 Monterey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5996026.341440001 2094620.2534900003 37.731200426151794 -122.456077057924 (37.7312004261518, -122.456077057924)
26275 223757 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 5745 Diamond Heights Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 10ft   6000755.6342 2096957.8752099997 37.7378893137452 -122.439894635432 (37.7378893137452, -122.439894635432)
30020 218148 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 35 Ashton Ave 1 Back Yard : Yard 13 Tree 1 Private 1     25     5994122.86099 2090034.3755400002 37.7184992748049 -122.462325196761 (37.7184992748049, -122.462325196761)
30529 102468 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 50 Saint Germain Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1           5998217.7 2104179.8 37.757574157371295 -122.44918961776699 (37.7575741573713, -122.449189617767)
30531 21160 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2301 Sunset Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 60   5985027.9083074005 2099542.6271361 37.744078511576 -122.49446276258301 (37.744078511576, -122.494462762583)
34240 247903 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 582 Esmeralda Ave 1 Side Yard : Yard 17 Tree 1 Private 1     31     6009830.823 2098729.7061900003 37.743266798225605 -122.40864208815701 (37.7432667982256, -122.408642088157)
34630 205915 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 506 Congo St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 5ft   6000129.85009 2095267.01455 37.7332109649183 -122.44193694363199 (37.7332109649183, -122.441936943632)
35760 223799 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 8 Laidley St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     34     6003000.19412 2098305.51493 37.741717135947205 -122.43223031618601 (37.7417171359472, -122.432230316186)
35815 249711 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2901 Broadway 1 Front Yard : Yard 7 Tree 1 Private 1     30     5999592.84448 2116997.53125 37.7928469352999 -122.44535542411501 (37.7928469352999, -122.445355424115)
36295 176117 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 1 : 4 Tree 1 Private 1     27 Width 0ft   5982122.73417 2092919.02565 37.725721454959896 -122.50401753028099 (37.7257214549599, -122.504017530281)
38550 205889 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 25 Stanford Heights Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 3ft   5997824.88709 2095746.51675 37.734395947598 -122.449940335175 (37.734395947598, -122.449940335175)
38782 139327 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 1350x GEARY BLVD 1 Median : Cutout 11 Tree 1 DPW 2     22 Width 0ft   6005396.3086 2114138.3218 37.785325835852795 -122.425071614426 (37.7853258358528, -122.425071614426)
39207 186925 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2800x Sunset Blvd 1 Median : Cutout 11 Tree 1 DPW 2     32 Width 0ft   5985117.1657 2095920.8688 37.734139358467104 -122.493887283293 (37.7341393584671, -122.493887283293)

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