Street_Tree_List

Data source: data.sfgov.org

1,287 rows where qLegalStatus = 6 sorted by YCoord

View and edit SQL

Suggested facets: SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord ▼ Latitude Longitude Location
86 119601 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 34 4357x Mission St 3 Front Yard : Yard 7 Tree 1 Private 1         Permit Number 774415          
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          
363 119608 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 34 299x Avalon Ave 4 Front Yard : Yard 7 Tree 1 Private 1                    
595 119606 Significant Tree 6 Myoporum laetum :: Myoporum 1 299x Avalon Ave 2 Front Yard : Yard 7 Tree 1 Private 1                    
2196 119600 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 34 4357x Mission St 2 Front Yard : Yard 7 Tree 1 Private 1         Permit Number 774415          
4747 253677 Significant Tree 6 Pinus canariensis :: Canary Island Pine 71 199X Kissling St 1 Side Yard : Cutout 18 Tree 1 Private 1       5x10            
7681 103657 Significant Tree 6 Tree(s) :: 17 350X Hickory St 1 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7809 119599 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 34 4357x Mission St 1 Front Yard : Yard 7 Tree 1 Private 1         Permit Number 774415          
7810 119607 Significant Tree 6 Pinus radiata :: Monterey Pine 3 299x Avalon Ave 3 Front Yard : Yard 7 Tree 1 Private 1                    
7834 119605 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 299x Avalon Ave 1 Front Yard : Yard 7 Tree 1 Private 1                    
8197 103668 Significant Tree 6 Tree(s) :: 17 350X Hickory St 6 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
9148 85030 Significant Tree 6 Tree(s) :: 17 411 Panama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/2007 12:00:00 AM     Permit Number 49384          
11212 103658 Significant Tree 6 Tree(s) :: 17 350X Hickory St 2 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
12113 103660 Significant Tree 6 Tree(s) :: 17 350X Hickory St 4 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
12885 103661 Significant Tree 6 Tree(s) :: 17 350X Hickory St 5 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
15949 103659 Significant Tree 6 Tree(s) :: 17 350X Hickory St 3 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
16097 104813 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 60 1601X Portola Dr 5 Front Yard : Yard 7 Tree 1 Private 1                    
22866 251139 Significant Tree 6 Tree(s) :: 17 621X Gough St 1 Back Yard : Yard 13 Tree 1 Private 1   03/10/2017 12:00:00 AM 3   Permit Number 779685          
99448 116072 Significant Tree 6 Juniperus chinensis :: Juniper 19 388 POLARIS WAY 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6000586.0 2086414.0 37.70892857908329 -122.439725431133 (37.7089285790833, -122.439725431133)
89334 116094 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 86 300x EXECUTIVE PARK BLVD 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
92450 116095 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 86 300x EXECUTIVE PARK BLVD 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
106195 116091 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 86 300x EXECUTIVE PARK BLVD 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
114742 116093 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 86 300x EXECUTIVE PARK BLVD 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
118020 116097 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 86 300x EXECUTIVE PARK BLVD 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
119705 116096 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 86 300x EXECUTIVE PARK BLVD 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
144536 116092 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 86 300x EXECUTIVE PARK BLVD 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
78769 116833 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 60 1750 Geneva Ave 1 Front Yard : Yard 7 Tree 1 Private 1           6004521.4 2087037.7 37.710864341935 -122.42616849363998 (37.710864341935, -122.42616849364)
81752 116834 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 60 1750 Geneva Ave 2 Front Yard : Yard 7 Tree 1 Private 1           6004521.4 2087037.7 37.710864341935 -122.42616849363998 (37.710864341935, -122.42616849364)
95921 116835 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 60 1750 Geneva Ave 3 Front Yard : Yard 7 Tree 1 Private 1           6004521.4 2087037.7 37.710864341935 -122.42616849363998 (37.710864341935, -122.42616849364)
110125 116836 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 60 1750 Geneva Ave 4 Front Yard : Yard 7 Tree 1 Private 1           6004521.4 2087037.7 37.710864341935 -122.42616849363998 (37.710864341935, -122.42616849364)
114433 116837 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 60 1750 Geneva Ave 5 Front Yard : Yard 7 Tree 1 Private 1           6004521.4 2087037.7 37.710864341935 -122.42616849363998 (37.710864341935, -122.42616849364)
10627 1283 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 44 3995X Alemany Blvd 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     10 10x10   5992081.50866 2087171.0422099999 37.710519496741206 -122.469172961285 (37.7105194967412, -122.469172961285)
11052 1284 Significant Tree 6 Acer buergeranum :: Trident Maple 120 3995X Alemany Blvd 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     12 3X10 Permit Number 778829 5992111.480830001 2087185.8440900003 37.7105618710011 -122.469070448459 (37.7105618710011, -122.469070448459)
9985 120925 Significant Tree 6 Pinus radiata :: Monterey Pine 3 3995X Alemany Blvd 8 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9986 1263 Significant Tree 6 Pinus radiata :: Monterey Pine 3 3995X Alemany Blvd 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   12/02/1998 12:00:00 AM 10 3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9994 120923 Significant Tree 6 Pinus radiata :: Monterey Pine 3 3995X Alemany Blvd 6 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9998 120931 Significant Tree 6 Pinus radiata :: Monterey Pine 3 3995X Alemany Blvd 14 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9999 120922 Significant Tree 6 Pinus radiata :: Monterey Pine 3 3995X Alemany Blvd 5 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10006 120927 Significant Tree 6 Pinus radiata :: Monterey Pine 3 3995X Alemany Blvd 10 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10015 120928 Significant Tree 6 Pinus radiata :: Monterey Pine 3 3995X Alemany Blvd 11 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10021 120935 Significant Tree 6 Pinus radiata :: Monterey Pine 3 3995X Alemany Blvd 18 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
74397 120924 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 3995X Alemany Blvd 7 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
79421 120930 Significant Tree 6 Pinus radiata :: Monterey Pine 3 3995X Alemany Blvd 13 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
84748 120926 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 3995X Alemany Blvd 9 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
100341 120932 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 3995X Alemany Blvd 15 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
115407 120934 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 3995X Alemany Blvd 17 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
116287 120933 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 3995X Alemany Blvd 16 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
118149 120936 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 3995X Alemany Blvd 19 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
119867 120929 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 3995X Alemany Blvd 12 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
120789 120921 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 3995X Alemany Blvd 4 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
22897 215094 Significant Tree 6 Tree(s) :: 17 218 Sadowa St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   03/13/2017 12:00:00 AM 3 Width 5ft Permit Number 779008 5994821.63014 2087784.2030900002 37.7123610457095 -122.45974695827199 (37.7123610457095, -122.459746958272)
22894 206842 Significant Tree 6 Tree(s) :: 17 218 Sadowa St 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   03/13/2017 12:00:00 AM 3 Width 5ft Permit Number 779008 5994803.1874 2087784.4983 37.712360795684 -122.45981072288001 (37.712360795684, -122.45981072288)
110973 106962 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 218 SADOWA ST 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     22     5994814.0 2087793.9 37.7123872323548 -122.459774032106 (37.7123872323548, -122.459774032106)
107838 104193 Significant Tree 6 Calocedrus decurrens :: Incense Cedar 177 122 Arch St 1 Front Yard : Yard 7 Tree 1 Private 1           5992720.4 2088013.1 37.712868482575104 -122.467026013031 (37.7128684825751, -122.467026013031)
91767 104749 Significant Tree 6 Pinus radiata :: Monterey Pine 3 1X Junipero Serra Blvd Off Ramp 1 Front Yard : Yard 7 Tree 1 Private 1         Permit Number 770709 5991326.15861 2088181.65405 37.7132507161795 -122.47185719553998 (37.7132507161795, -122.47185719554)
113067 104750 Significant Tree 6 Pinus radiata :: Monterey Pine 3 1X Junipero Serra Blvd Off Ramp 2 Front Yard : Yard 7 Tree 1 Private 1   08/30/2016 12:00:00 AM 3   Permit Number 770709 5991326.15861 2088181.65405 37.7132507161795 -122.47185719553998 (37.7132507161795, -122.47185719554)
10019 173629 Significant Tree 6 Tibochina urvilleana :: Princess Flower 260 10X Junipero Serra Blvd Off Ramp 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   01/20/2017 12:00:00 AM 3 3x3 Permit Number 779383 5991168.0 2088425.0 37.713909732222 -122.472421570074 (37.713909732222, -122.472421570074)
125954 114239 Significant Tree 6 Acacia longifolia :: Golden Wattle 140 1300x JUNIPERO SERRA BLVD 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28     5991168.0 2088425.0 37.713909732222 -122.472421570074 (37.713909732222, -122.472421570074)
93028 115827 Significant Tree 6 Myoporum laetum :: Myoporum 1 60X CHUMASERO DR 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   08/30/2016 12:00:00 AM 3 3x3 Permit Number 777531 5990913.0 2088468.0 37.714013037331 -122.473306070941 (37.714013037331, -122.473306070941)
145474 114257 Significant Tree 6 Leptospermum quinquenervia :: Tea Tree 151 50x CHUMASERO DR 1 Front Yard : Yard 7 Tree 1 Private 1           5990913.0 2088468.0 37.714013037331 -122.473306070941 (37.714013037331, -122.473306070941)
11071 113042 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 62 500 Raymond Ave 1 Front Yard : Cutout 8 Tree 1 Private 1   10/06/2015 12:00:00 AM 30 3x3   6008233.879509999 2088473.9314700002 37.715017072864796 -122.413438766187 (37.7150170728648, -122.413438766187)
18835 114526 Significant Tree 6 Pinus radiata :: Monterey Pine 3 1 TIOGA AVE 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           6011351.0 2088602.0 37.715543251319204 -122.402673611341 (37.7155432513192, -122.402673611341)
88169 114525 Significant Tree 6 Pinus radiata :: Monterey Pine 3 1 TIOGA AVE 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           6011351.0 2088602.0 37.715543251319204 -122.402673611341 (37.7155432513192, -122.402673611341)
11055 116459 Significant Tree 6 Eucalyptus lehmanni :: Bushy Yate 267 777 Brotherhood Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 10x20 Permit Number 777772 5989848.42836 2088633.8329099999 37.7144066723949 -122.476997704287 (37.7144066723949, -122.476997704287)
10991 116458 Significant Tree 6 Eucalyptus lehmanni :: Bushy Yate 267 777 Brotherhood Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 10x20   5989819.39068 2088633.8654 37.7144050769972 -122.477098071327 (37.7144050769972, -122.477098071327)
49231 114226 Significant Tree 6 Acacia longifolia :: Golden Wattle 140 99x FONT BLVD 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
79797 114240 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 60 99x FONT BLVD 16 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
80545 114228 Significant Tree 6 Acacia longifolia :: Golden Wattle 140 99x FONT BLVD 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
86013 114235 Significant Tree 6 Acacia longifolia :: Golden Wattle 140 99x FONT BLVD 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
105010 114230 Significant Tree 6 Acacia longifolia :: Golden Wattle 140 99x FONT BLVD 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
105245 114225 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 60 99x FONT BLVD 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     48     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
105541 114227 Significant Tree 6 Acacia longifolia :: Golden Wattle 140 99x FONT BLVD 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
112189 114231 Significant Tree 6 Acacia longifolia :: Golden Wattle 140 99x FONT BLVD 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
117729 114237 Significant Tree 6 Acacia longifolia :: Golden Wattle 140 99x FONT BLVD 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
125709 114234 Significant Tree 6 Acacia longifolia :: Golden Wattle 140 99x FONT BLVD 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
128194 114232 Significant Tree 6 Acacia longifolia :: Golden Wattle 140 99x FONT BLVD 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
128290 114229 Significant Tree 6 Acacia longifolia :: Golden Wattle 140 99x FONT BLVD 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
138891 114238 Significant Tree 6 Acacia longifolia :: Golden Wattle 140 99x FONT BLVD 14 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
139193 114233 Significant Tree 6 Acacia longifolia :: Golden Wattle 140 99x FONT BLVD 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
139478 114236 Significant Tree 6 Acacia longifolia :: Golden Wattle 140 99x FONT BLVD 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
50075 113043 Significant Tree 6 Pinus radiata :: Monterey Pine 3 500 RAYMOND AVE 2 Front Yard : Cutout 8 Tree 1 Private 1   10/06/2015 12:00:00 AM   3x3   6008527.0 2088690.0 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248)
98650 113044 Significant Tree 6 Pinus radiata :: Monterey Pine 3 500 RAYMOND AVE 3 Front Yard : Cutout 8 Tree 1 Private 1       3x3   6008527.0 2088690.0 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248)
101280 113045 Significant Tree 6 Pinus radiata :: Monterey Pine 3 500 RAYMOND AVE 4 Front Yard : Cutout 8 Tree 1 Private 1       3x3   6008527.0 2088690.0 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248)
4659 253652 Significant Tree 6 Pinus radiata :: Monterey Pine 3 131 Font Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1       10x10   5990844.0 2088883.0 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248)
4673 253651 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 60 131 Font Blvd 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   5990844.0 2088883.0 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248)
123839 114250 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 60 131 FONT BLVD 1 Front Yard : Yard 7 Tree 1 Private 1     36     5990844.0 2088883.0 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248)
113606 111093 Significant Tree 6 Pinus radiata :: Monterey Pine 3 100x FONT BLVD 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/04/2015 12:00:00 AM 50 3x3 Permit Number 775594 5990916.0 2088996.0 37.715462969911 -122.473334188491 (37.715462969911, -122.473334188491)
94747 114034 Significant Tree 6 Ulmus pumila :: Siberian Elm 53 198x FONT BLVD 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     40 3x3   5990818.0 2089012.0 37.7155012267577 -122.473674083302 (37.7155012267577, -122.473674083302)
125242 111094 Significant Tree 6 Pinus radiata :: Monterey Pine 3 150x FONT BLVD   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/04/2015 12:00:00 AM 30 3x3 Permit Number 775594 5990976.0 2089133.0 37.715842612516106 -122.473136789074 (37.7158426125161, -122.473136789074)
3843 253568 Significant Tree 6 Eucalyptus globulus :: Blue Gum 103 301X Sargent St 1 Front Yard : Cutout 8 Tree 1 Private 1       3x3   5993018.0 2089140.0 37.7159798527116 -122.46607925705901 (37.7159798527116, -122.466079257059)
123361 117295 Significant Tree 6 Tree(s) :: 17 130 CAMBON DR 1 Side Yard : Yard 17 Tree 1 Private 1       3x3   5990450.0 2089482.0 37.7167704112637 -122.47498033116501 (37.7167704112637, -122.474980331165)
108424 106038 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 75 230 Lakeview Ave   Front Yard : Yard 7 Tree 1 Private 1         Permit Number 772456 5997013.1 2089546.6 37.7173259605404 -122.452299707743 (37.7173259605404, -122.452299707743)
9641 114157 Significant Tree 6 Pinus radiata :: Monterey Pine 3 1200x JUNIPERO SERRA BLVD 18 Front Yard : Yard 7 Tree 1 Private 1     32     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9643 114152 Significant Tree 6 Pinus radiata :: Monterey Pine 3 1200X JUNIPERO SERRA BLVD 11 Front Yard : Yard 7 Tree 1 Private 1     8     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9644 114150 Significant Tree 6 Pinus radiata :: Monterey Pine 3 1200X JUNIPERO SERRA BLVD 9 Front Yard : Yard 7 Tree 1 Private 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9647 114149 Significant Tree 6 Pinus radiata :: Monterey Pine 3 1200X JUNIPERO SERRA BLVD 8 Front Yard : Yard 7 Tree 1 Private 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9651 114156 Significant Tree 6 Pinus radiata :: Monterey Pine 3 1200x JUNIPERO SERRA BLVD 17 Front Yard : Yard 7 Tree 1 Private 1     32     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)

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