Street_Tree_List

Data source: data.sfgov.org

1,824 rows where qSpecies = 47 sorted by PlantDate

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
129 20398 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 262X Sunset Blvd 43 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 60            
272 251264 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          
277 251265 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          
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          
300 251263 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 2 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)
503 8533 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2100 Geary Blvd 4 Median : Cutout 11 Tree 1 DPW 2     18 6   6001504.6387 2113566.4305 37.783534963845 -122.43849459602801 (37.783534963845, -122.438494596028)
549 251321 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 100X Monument Way 1 Unaccepted Street : Yard 14 Tree 1 Private 1                    
618 20377 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 262X Sunset Blvd 25 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     48 60            
682 251365 Private 5 Cupressus macrocarpa :: Monterey Cypress 47 138x Gladeview Way 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1                    
712 251366 Private 5 Cupressus macrocarpa :: Monterey Cypress 47 138x Gladeview Way 3 Sidewalk: Property side : Yard 9 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                    
731 251375 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 401 Portola Dr 3 Median : Yard 3 Tree 1 DPW 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
747 251378 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 401 Portola Dr 6 Median : Yard 3 Tree 1 DPW 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
749 251374 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 401 Portola Dr 2 Median : Yard 3 Tree 1 DPW 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
757 251377 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 401 Portola Dr 5 Median : Yard 3 Tree 1 DPW 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
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)
764 251379 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 401 Portola Dr 7 Median : Yard 3 Tree 1 DPW 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
782 251385 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 138x Gladeview Way 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5997939.0 2102166.0 37.7520288182083 -122.45000833213699 (37.7520288182083, -122.450008332137)
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)
785 251376 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 401 Portola Dr 4 Median : Yard 3 Tree 1 DPW 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
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)
886 19568 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY1 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     48 100ST            
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)
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)
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)
1600 251625 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 76R Amber Dr 3 Back Yard : Yard 13 Tree 1 Private 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
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)
1605 251634 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 14R Amethyst Way 3 Back Yard : Yard 13 Tree 1 Private 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1608 251603 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 44R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999509.0 2100035.0 37.746267320465705 -122.444425925791 (37.7462673204657, -122.444425925791)
1609 251630 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 8R Amethyst Way 2 Back Yard : Yard 13 Tree 1 Private 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1613 251616 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 64R Amber Dr 3 Back Yard : Yard 13 Tree 1 Private 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1618 251611 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 56R Amber Dr 4 Back Yard : Yard 13 Tree 1 Private 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1619 251617 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 64R Amber Dr 4 Back Yard : Yard 13 Tree 1 Private 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1623 251613 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 60R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999394.0 2100048.0 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752)
1624 251624 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 76R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
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)
1629 251631 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 8R Amethyst Way 3 Back Yard : Yard 13 Tree 1 Private 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1631 251621 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 72R Amber Dr 4 Back Yard : Yard 13 Tree 1 Private 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1632 251628 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 2R Amethyst Way 3 Back Yard : Yard 13 Tree 1 Private 1           5999263.0 2100016.0 37.746201111936706 -122.44527519504999 (37.7462011119367, -122.44527519505)
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)
1637 251619 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 72R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1638 251620 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 72R Amber Dr 3 Back Yard : Yard 13 Tree 1 Private 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1639 251615 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 64R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1640 251622 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 72R Amber Dr 5 Back Yard : Yard 13 Tree 1 Private 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1641 251627 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2R Amethyst Way 2 Back Yard : Yard 13 Tree 1 Private 1           5999263.0 2100016.0 37.746201111936706 -122.44527519504999 (37.7462011119367, -122.44527519505)
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)
1646 251633 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 14R Amethyst Way 2 Back Yard : Yard 13 Tree 1 Private 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
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)
1651 251609 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 56R Amber Dr 2 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)
1654 251610 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 56R Amber Dr 3 Back Yard : Yard 13 Tree 1 Private 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
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)
1875 251783 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 610 Clipper St 5 Side Yard : Yard 17 Tree 1 DPW 2       Width 2ft   6001275.75039 2100902.7174 37.7487505133321 -122.438378885672 (37.7487505133321, -122.438378885672)
1898 20392 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 262X Sunset Blvd 38 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
2144 252907 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 25 Point Lobos Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       10x10   5982783.76519 2112486.06679 37.7794859217892 -122.50318049806101 (37.7794859217892, -122.503180498061)
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)
2531 8603 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2400 Geary Blvd 3 Median : Cutout 11 Tree 1 DPW 2     36 6   5999987.1554 2113318.7057 37.782768340075606 -122.443726682203 (37.7827683400756, -122.443726682203)
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)
2848 253255 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 270 Castenada Ave 2 Front Yard : Yard 7 Tree 1 Private 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
3044 253288 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 650 Peru Ave 4 Front Yard : Yard 7 Tree 1 Private 1           6005101.95698 2092563.1940099997 37.7260689503102 -122.42455474103201 (37.7260689503102, -122.424554741032)
3046 253289 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 650 Peru Ave 5 Front Yard : Yard 7 Tree 1 Private 1           6005101.95698 2092563.1940099997 37.7260689503102 -122.42455474103201 (37.7260689503102, -122.424554741032)
3049 253290 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 650 Peru Ave 6 Front Yard : Yard 7 Tree 1 Private 1           6005101.95698 2092563.1940099997 37.7260689503102 -122.42455474103201 (37.7260689503102, -122.424554741032)
3050 253291 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 650 Peru Ave 7 Front Yard : Yard 7 Tree 1 Private 1           6005101.95698 2092563.1940099997 37.7260689503102 -122.42455474103201 (37.7260689503102, -122.424554741032)
3112 253318 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3113 253332 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 27 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3115 253329 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 24 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3116 253328 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 23 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3119 253313 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3120 253308 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
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)
3122 253323 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 21 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3123 253306 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3125 253309 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3127 253316 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3128 253330 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 25 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3129 253317 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3130 253319 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3131 253310 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 8 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)
3133 253333 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 28 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3135 253335 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 30 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3136 253320 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3139 253322 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 20 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3140 253334 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 29 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3141 253311 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3142 217765 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 470 West Portal Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     42 Width 10ft   5991548.70787 2096139.0246599999 37.7351125606845 -122.471667523249 (37.7351125606845, -122.471667523249)
3143 253336 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 31 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3145 253304 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3146 253314 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 Euclid Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)

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