Street_Tree_List

Data source: data.sfgov.org

99,669 rows where qLegalStatus = 2 sorted by Latitude

View and edit SQL

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude ▼ Longitude Location
125 119758 Undocumented 2 Maytenus boaria :: Mayten 22 151X Octavia St Frontage West 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
549 251321 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 100X Monument Way 1 Unaccepted Street : Yard 14 Tree 1 Private 1                    
1493 103663 Undocumented 2 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          
1620 251543 Undocumented 2 Pinus radiata :: Monterey Pine 3 0X Bay Shore Blvd Off Ramp   Side Yard : Yard 17 Tree 1 Private 1                    
3007 253279 Undocumented 2 Pyrus calleryana :: Ornamental Pear 9 201X Laguna Honda Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 DPW 2       10x10 ROW IS 10' tree is street tree          
3239 100549 Undocumented 2 Acer spp :: Maple 158 290X Tehama St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x4            
3537 102838 Undocumented 2 Pinus radiata :: Monterey Pine 3 1101X Portola Dr 1 Sidewalk: Property side : Yard 9 Tree 1 DPW 2                    
3610 115725 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 250X Octavia St 2 Side Yard : Yard 17 Tree 1 Dept of Real Estate 5                    
4085 101532 Undocumented 2 Tree(s) :: 17 11323 Palou Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3            
4222 253622 Undocumented 2 Pittosporum spp :: Pittosporum spp 128 300x Naglee Ave   Unaccepted Street : Yard 14 Tree 1 Private 1                    
5598 103666 Undocumented 2 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          
6680 112268 Undocumented 2 Ficus nitida :: Laurel Fig 43 1X Geary St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
6704 112269 Undocumented 2 Ficus nitida :: Laurel Fig 43 1X Geary St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
7764 103662 Undocumented 2 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          
8408 103664 Undocumented 2 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          
9596 102839 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1101X Portola Dr 2 Sidewalk: Property side : Yard 9 Tree 1 DPW 2                    
9694 173632 Undocumented 2 Pinus radiata :: Monterey Pine 3 3300X Market St 1 Side Yard : Yard 17 Tree 1 Private 1                    
10149 173884 Undocumented 2 Maytenus boaria :: Mayten 22 100X Kirkham St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/02/2017 12:00:00 AM 3 3x3            
10201 173901 Undocumented 2 Cupressocyparis leylandii :: Leyland Cypress 34 4201x Lincoln Blvd 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       5x5            
10204 173902 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 601x Hearst Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
10665 103665 Undocumented 2 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          
10892 112910 Undocumented 2 Tree(s) :: 17 1899X Beach St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
10955 109923 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 214 state st 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3            
10998 112267 Undocumented 2 Ficus nitida :: Laurel Fig 43 1X Geary St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
11273 102842 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 1101X Portola Dr 8 Sidewalk: Property side : Yard 9 Tree 1 DPW 2                    
11415 103667 Undocumented 2 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          
11778 108180 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 835 Sacramento St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3            
12636 99746 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 4250 Clipper St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3            
15743 115724 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 250x Octavia St 1 Side Yard : Yard 17 Tree 1 Dept of Real Estate 5                    
16111 102843 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1101X Portola Dr 10 Sidewalk: Property side : Yard 9 Tree 1 DPW 2                    
16481 112908 Undocumented 2 Tree(s) :: 17 1899X Beach St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
16653 100543 Undocumented 2 Acer spp :: Maple 158 290X Tehama St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x4            
16896 100001 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 501X 01st St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1         Address is 100 1st Street          
17073 112909 Undocumented 2 Tree(s) :: 17 1899X Beach St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
18528 120131 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 799x Shotwell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3            
20185 120130 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 799x Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3            
185502 122532 Undocumented 2 Pinus radiata :: Monterey Pine 3 1900X Castro St 1 Unaccepted Street : Yard 14 Tree 1 Private 1                    
176642 178078 Undocumented 2 Persea americana :: Avocado 113 230 Rhine St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 6ft   5994079.51921 2086287.10063 37.7082076509257 -122.46220339079399 (37.7082076509257, -122.462203390794)
156682 175042 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 98 San Diego Ave 1 Front Yard : Yard 7 Tree 1 Private 1     33     5992757.09235 2086323.81583 37.7082322293939 -122.466776470378 (37.7082322293939, -122.466776470378)
179831 178849 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 13 Liebig St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 1ft   5995911.23484 2086261.34028 37.7082422172863 -122.455870959398 (37.7082422172863, -122.455870959398)
132962 175854 Undocumented 2 Citrus spp :: Lemon: Orange: Lime 278 13 Liebig St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 1ft   5995905.68343 2086266.21958 37.708255296101896 -122.455890498056 (37.7082552961019, -122.455890498056)
65025 179986 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 818 Brunswick St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5997558.28952 2086239.87811 37.708277679339 -122.450177037641 (37.708277679339, -122.450177037641)
52762 71598 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 126 Wilson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 9     5994743.91592 2086305.62835 37.70829675666771 -122.45990852057301 (37.7082967566677, -122.459908520573)
62380 176134 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 800 John Muir Dr 2 : 4 Tree 1 Private 1     16 Width 0ft   5987222.73644 2086464.9299599999 37.7082987351809 -122.48591391940901 (37.7082987351809, -122.485913919409)
48038 176133 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 800 John Muir Dr 1 : 4 Tree 1 Private 1     10 Width 0ft   5987205.94604 2086467.2590400001 37.708304151783295 -122.48597211903099 (37.7083041517833, -122.485972119031)
60822 175987 Undocumented 2 Cordyline australis :: Dracena Palm 141 170 Baltimore Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6002239.25029 2086152.9627200002 37.708305791247504 -122.43399292266199 (37.7083057912475, -122.433992922662)
41818 175988 Undocumented 2 Cordyline australis :: Dracena Palm 141 170 Baltimore Way 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   6002235.39507 2086153.26872 37.708306412667206 -122.43400626858299 (37.7083064126672, -122.434006268583)
160483 176136 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 800 John Muir Dr 4 : 4 Tree 1 Private 1     11 Width 0ft   5987247.74108 2086476.2363 37.7083312366754 -122.48582833093599 (37.7083312366754, -122.485828330936)
169985 177495 Undocumented 2 Maytenus boaria :: Mayten 22 818 Brunswick St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5997608.02587 2086258.36889 37.7083312969119 -122.45000647583299 (37.7083312969119, -122.450006475833)
35802 71599 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 130 Wilson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 7     5994726.40181 2086320.41636 37.7083363538073 -122.45997012143101 (37.7083363538073, -122.459970121431)
150864 178273 Undocumented 2 Pinus radiata :: Monterey Pine 3 98 San Diego Ave 2 Front Yard : Yard 7 Tree 1 Private 1     17     5992768.65673 2086361.85687 37.708337348457896 -122.46673926632499 (37.7083373484579, -122.466739266325)
161932 72806 Undocumented 2 Maytenus boaria :: Mayten 22 382 Guttenberg St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/30/1998 12:00:00 AM 6     5999864.9815 2086214.70068 37.70834028115829 -122.44220306922399 (37.7083402811583, -122.442203069224)
59353 176135 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 800 John Muir Dr 3 : 4 Tree 1 Private 1     13 Width 0ft   5987227.516530001 2086480.11804 37.7083407164149 -122.485898513129 (37.7083407164149, -122.485898513129)
161785 176137 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 800 John Muir Dr 5 : 4 Tree 1 Private 1     11 Width 0ft   5987255.345 2086484.45942 37.708354258405 -122.485802654386 (37.708354258405, -122.485802654386)
137279 73608 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 136 Wilson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 14     5994710.3414 2086333.6948099998 37.7083718896252 -122.46002658894899 (37.7083718896252, -122.460026588949)
109852 112633 Undocumented 2 Maytenus boaria :: Mayten 22 800x BRUNSWICK ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 5x6   5997602.0 2086276.0 37.70837936312 -122.450028571713 (37.70837936312, -122.450028571713)
113003 112634 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 800x BRUNSWICK ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       5x6   5997602.0 2086276.0 37.70837936312 -122.450028571713 (37.70837936312, -122.450028571713)
24631 176638 Undocumented 2 Juniperus chinensis :: Juniper 19 65 Santa Barbara Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 8ft   5993323.454919999 2086371.47099 37.7083957495352 -122.46482253315399 (37.7083957495352, -122.464822533154)
27333 180168 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 5935 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5996569.70599 2086304.01805 37.7083971704608 -122.453598302421 (37.7083971704608, -122.453598302421)
169260 177163 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 189 Velasco Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     19 Width 6ft   6007991.7614400005 2086069.6109099998 37.70840170934729 -122.41410563508002 (37.7084017093473, -122.41410563508)
159957 71600 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 136 Wilson St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 5     5994689.24707 2086354.8441299999 37.708428747449204 -122.460101024051 (37.7084287474492, -122.460101024051)
59888 177028 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 164 Baltimore Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   6002357.56159 2086195.5289200002 37.7084293823926 -122.433587065817 (37.7084293823926, -122.433587065817)
137871 175986 Undocumented 2 Cordyline australis :: Dracena Palm 141 164 Baltimore Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   6002363.53933 2086199.02425 37.708439318980396 -122.43356665568399 (37.7084393189804, -122.433566655684)
63245 71602 Undocumented 2 Celtis sinensis :: Chinese Hackberry 111 149 Wilson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 6     5994628.01123 2086360.41662 37.7084405258897 -122.46031306439899 (37.7084405258897, -122.460313064399)
55464 74182 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 138 Wilson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 4     5994679.00139 2086362.0842900001 37.7084480379267 -122.46013695827 (37.7084480379267, -122.46013695827)
4188 181057 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 5931 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/10/2017 03:33:00 PM 3 Width 3ft   5996618.07355 2086323.26043 37.7084527782463 -122.453432527712 (37.7084527782463, -122.453432527712)
41727 175985 Undocumented 2 Cordyline australis :: Dracena Palm 141 160 Baltimore Way 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   6002380.953509999 2086206.35478 37.7084604350668 -122.433506993768 (37.7084604350668, -122.433506993768)
50962 179971 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 160 Baltimore Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 6ft   6002384.15556 2086207.4195700001 37.708463540423104 -122.43349600315001 (37.7084635404231, -122.43349600315)
65128 73960 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 138 Wilson St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 4     5994666.9696 2086372.6899 37.7084764663958 -122.46017930913601 (37.7084764663958, -122.460179309136)
136095 71601 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 138 Wilson St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 4     5994653.0975 2086384.07363 37.708506925528795 -122.46022807666401 (37.7085069255288, -122.460228076664)
131206 179380 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 77 Santa Cruz Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 3ft   5993077.06779 2086425.7469099998 37.7085305695939 -122.46567800964199 (37.7085305695939, -122.465678009642)
162639 177639 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 5900 Mission St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 4ft   5996554.50989 2086363.6080900002 37.708559919867895 -122.45365512159799 (37.7085599198679, -122.453655121598)
160891 177329 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 2610 Bay Shore Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6010501.25874 2086080.5894099998 37.708572487900895 -122.405433245075 (37.7085724879009, -122.405433245075)
77398 106965 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 63 BELLE AVE   Sidewalk: Property side : Yard 9 Tree 1 Private 1           5991753.8 2086471.1 37.7085786821221 -122.47025464516001 (37.7085786821221, -122.47025464516)
94141 179594 Undocumented 2 Syagrus romanzoffianum :: Queen Palm 142 2115 Geneva Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6006118.53039 2086176.0114900002 37.7085884697411 -122.420587301759 (37.7085884697411, -122.420587301759)
60858 177640 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 5900 Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 4ft   5996580.5488 2086374.8113099998 37.7085921740666 -122.453565936738 (37.7085921740666, -122.453565936738)
175340 179595 Undocumented 2 Syagrus romanzoffianum :: Queen Palm 142 2109 Geneva Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6006095.08243 2086183.72557 37.7086083294779 -122.420668888264 (37.7086083294779, -122.420668888264)
1556 251583 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 75 Rice St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5995352.0 2086409.0 37.7086155444167 -122.45781440192499 (37.7086155444167, -122.457814401925)
72189 178591 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 67 Belle Ave 1 : 4 Tree 1 Private 1     9 Width 3ft   5991713.92465 2086485.44715 37.70861577046671 -122.470393502266 (37.7086157704667, -122.470393502266)
137765 178592 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 67 Belle Ave 2 : 4 Tree 1 Private 1     9 Width 3ft   5991724.32675 2086485.2281099998 37.7086157704725 -122.470357535671 (37.7086157704725, -122.470357535671)
48697 177826 Undocumented 2 Myoporum laetum :: Myoporum 1 89 Belle Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 2ft   5991639.3875 2086487.5926299999 37.708617351468895 -122.47065126593999 (37.7086173514689, -122.47065126594)
154719 178860 Undocumented 2 Prunus laurocerasus :: English laurel 227 89 Belle Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 2ft   5991691.410619999 2086487.07285 37.708618932476504 -122.470471431226 (37.7086189324765, -122.470471431226)
132730 71684 Undocumented 2 Olea europaea :: Olive Tree 41 163 Wilson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 5     5994555.12862 2086427.38157 37.7086202032335 -122.46056980286501 (37.7086202032335, -122.460569802865)
146626 179832 Undocumented 2 Taxus baccata :: Irish Yew 241 89 Belle Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 2ft   5991610.51667 2086489.35195 37.708620512585895 -122.470751174349 (37.7086205125859, -122.470751174349)
82512 176641 Undocumented 2 Juniperus chinensis :: Juniper 19 89 Belle Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 2ft   5991622.07464 2086489.1085299999 37.708620512601705 -122.47071121118 (37.7086205126017, -122.47071121118)
71336 179596 Undocumented 2 Syagrus romanzoffianum :: Queen Palm 142 2101 Geneva Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6006079.302180001 2086189.0223299998 37.7086219838753 -122.42072380268299 (37.7086219838753, -122.420723802683)
90824 73959 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 75 Rice St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/30/1995 12:00:00 AM 4 2x4 Permit Number 773591 5995358.56494273 2086411.36688337 37.7086224204841 -122.457791883945 (37.7086224204841, -122.457791883945)
146195 71596 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 75 Rice St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/30/1995 12:00:00 AM 12 2x3   5995358.56494273 2086411.36688337 37.7086224204841 -122.457791883945 (37.7086224204841, -122.457791883945)
39571 175574 Undocumented 2 Brugmansia spp :: Angel trumpet 137 262 Taber Pl 1 : 4 Tree 1 Private 1     16 Width 3ft   6009969.129269999 2086111.4112900002 37.708627351035794 -122.407274531388 (37.7086273510358, -122.407274531388)
152808 180169 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 5921 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5996782.55272 2086390.1360799999 37.7086458303022 -122.45286889471001 (37.7086458303022, -122.45286889471)
179770 71586 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 121 Goethe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 9     5994945.16185 2086428.98532 37.7086470380903 -122.459221923276 (37.7086470380903, -122.459221923276)
51116 179953 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 240 Peabody St 1 : 4 Tree 1 Private 1     17 Width 3ft   6009701.772480001 2086128.1297 37.708658289510204 -122.408199733244 (37.7086582895102, -122.408199733244)
57495 71603 Undocumented 2 Celtis sinensis :: Chinese Hackberry 111 171 Wilson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 6     5994523.67906 2086453.64687 37.708690512219206 -122.460680397897 (37.7086905122192, -122.460680397897)
157417 175573 Undocumented 2 Brugmansia spp :: Angel trumpet 137 256 Taber Pl 1 : 4 Tree 1 Private 1     17 Width 3ft   6009978.06824 2086136.62452 37.7086970817661 -122.40724541316901 (37.7086970817661, -122.407245413169)
159960 178246 Undocumented 2 Pinus radiata :: Monterey Pine 3 334 Schwerin St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     59 Width 8ft   6008498.73338 2086169.5102900001 37.7087044750874 -122.412360530312 (37.7087044750874, -122.412360530312)
134907 176619 Undocumented 2 Juniperus chinensis :: Juniper 19 375 Hanover St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     15 Width 3ft   5999272.06122 2086368.18274 37.7087278988324 -122.444263284724 (37.7087278988324, -122.444263284724)
170302 71651 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 177 Wilson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 7     5994505.19973 2086471.6739 37.7087389470079 -122.46074556997101 (37.7087389470079, -122.460745569971)
11387 104350 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 349 Guttenberg St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 3x3   5999840.77458 2086361.4281900001 37.708741782568104 -122.44229725703 (37.7087417825681, -122.44229725703)
48575 177328 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 2610 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6010526.80865 2086149.78348 37.708763909485796 -122.405349810469 (37.7087639094858, -122.405349810469)
68899 71587 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 129 Goethe St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 5     5994891.94658 2086476.6908099998 37.7087749666595 -122.459409293405 (37.7087749666595, -122.459409293405)

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