sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
125 119758 2 22 151X Octavia St Frontage West 1 1 1 1                    
549 251321 2 47 100X Monument Way 1 14 1 1                    
1493 103663 2 17 350X Hickory St 2 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
1620 251543 2 3 0X Bay Shore Blvd Off Ramp   17 1 1                    
3007 253279 2 9 201X Laguna Honda Blvd 1 9 1 2       10x10 ROW IS 10' tree is street tree          
3239 100549 2 158 290X Tehama St 4 1 1 1     3 3x4            
3537 102838 2 3 1101X Portola Dr 1 9 1 2                    
3610 115725 2 198 250X Octavia St 2 17 1 5                    
4085 101532 2 17 11323 Palou Ave 1 1 1 1       3x3            
4222 253622 2 128 300x Naglee Ave   14 1 1                    
5598 103666 2 17 350X Hickory St 5 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
6680 112268 2 43 1X Geary St 2 1 1 1                    
6704 112269 2 43 1X Geary St 3 1 1 1                    
7764 103662 2 17 350X Hickory St 1 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
8408 103664 2 17 350X Hickory St 3 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
9596 102839 2 143 1101X Portola Dr 2 9 1 2                    
9694 173632 2 3 3300X Market St 1 17 1 1                    
10149 173884 2 22 100X Kirkham St 2 1 1 1   02/02/2017 12:00:00 AM 3 3x3            
10201 173901 2 34 4201x Lincoln Blvd 1 5 1 1       5x5            
10204 173902 2 55 601x Hearst Ave 2 1 1 1                    
10665 103665 2 17 350X Hickory St 4 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
10892 112910 2 17 1899X Beach St 3 1 1 1                    
10955 109923 2 12 214 state st 1 1 1 1       3x3            
10998 112267 2 43 1X Geary St 1 1 1 1                    
11273 102842 2 2 1101X Portola Dr 8 9 1 2                    
11415 103667 2 17 350X Hickory St 6 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
11778 108180 2 11 835 Sacramento St 2 1 1 1       3x3            
12636 99746 2 55 4250 Clipper St 1 1 1 1       3x3            
15743 115724 2 198 250x Octavia St 1 17 1 5                    
16111 102843 2 5 1101X Portola Dr 10 9 1 2                    
16481 112908 2 17 1899X Beach St 1 1 1 1                    
16653 100543 2 158 290X Tehama St 3 1 1 1     3 3x4            
16896 100001 2 32 501X 01st St 2 10 1 1         Address is 100 1st Street          
17073 112909 2 17 1899X Beach St 2 1 1 1                    
18528 120131 2 15 799x Shotwell St 2 1 1 1       3x3            
20185 120130 2 15 799x Shotwell St 1 1 1 1       3x3            
185502 122532 2 3 1900X Castro St 1 14 1 1                    
176642 178078 2 113 230 Rhine St 1 9 1 1     5 Width 6ft   5994079.51921 2086287.10063 37.7082076509257 -122.46220339079399 (37.7082076509257, -122.462203390794)
156682 175042 2 5 98 San Diego Ave 1 7 1 1     33     5992757.09235 2086323.81583 37.7082322293939 -122.466776470378 (37.7082322293939, -122.466776470378)
179831 178849 2 72 13 Liebig St 2 1 1 1     6 Width 1ft   5995911.23484 2086261.34028 37.7082422172863 -122.455870959398 (37.7082422172863, -122.455870959398)
132962 175854 2 278 13 Liebig St 1 1 1 1     4 Width 1ft   5995905.68343 2086266.21958 37.708255296101896 -122.455890498056 (37.7082552961019, -122.455890498056)
65025 179986 2 37 818 Brunswick St 1 1 1 1     6 Width 3ft   5997558.28952 2086239.87811 37.708277679339 -122.450177037641 (37.708277679339, -122.450177037641)
52762 71598 2 12 126 Wilson St 1 1 1 1 1 09/30/1995 12:00:00 AM 9     5994743.91592 2086305.62835 37.70829675666771 -122.45990852057301 (37.7082967566677, -122.459908520573)
62380 176134 2 47 800 John Muir Dr 2 4 1 1     16 Width 0ft   5987222.73644 2086464.9299599999 37.7082987351809 -122.48591391940901 (37.7082987351809, -122.485913919409)
48038 176133 2 47 800 John Muir Dr 1 4 1 1     10 Width 0ft   5987205.94604 2086467.2590400001 37.708304151783295 -122.48597211903099 (37.7083041517833, -122.485972119031)
60822 175987 2 141 170 Baltimore Way 2 1 1 1     11 Width 5ft   6002239.25029 2086152.9627200002 37.708305791247504 -122.43399292266199 (37.7083057912475, -122.433992922662)
41818 175988 2 141 170 Baltimore Way 3 1 1 1     4 Width 5ft   6002235.39507 2086153.26872 37.708306412667206 -122.43400626858299 (37.7083064126672, -122.434006268583)
160483 176136 2 47 800 John Muir Dr 4 4 1 1     11 Width 0ft   5987247.74108 2086476.2363 37.7083312366754 -122.48582833093599 (37.7083312366754, -122.485828330936)
169985 177495 2 22 818 Brunswick St 2 1 1 1     5 Width 3ft   5997608.02587 2086258.36889 37.7083312969119 -122.45000647583299 (37.7083312969119, -122.450006475833)
35802 71599 2 44 130 Wilson St 1 1 1 1 1 09/30/1995 12:00:00 AM 7     5994726.40181 2086320.41636 37.7083363538073 -122.45997012143101 (37.7083363538073, -122.459970121431)
150864 178273 2 3 98 San Diego Ave 2 7 1 1     17     5992768.65673 2086361.85687 37.708337348457896 -122.46673926632499 (37.7083373484579, -122.466739266325)
161932 72806 2 22 382 Guttenberg St 1 1 1 1 1 05/30/1998 12:00:00 AM 6     5999864.9815 2086214.70068 37.70834028115829 -122.44220306922399 (37.7083402811583, -122.442203069224)
59353 176135 2 47 800 John Muir Dr 3 4 1 1     13 Width 0ft   5987227.516530001 2086480.11804 37.7083407164149 -122.485898513129 (37.7083407164149, -122.485898513129)
161785 176137 2 47 800 John Muir Dr 5 4 1 1     11 Width 0ft   5987255.345 2086484.45942 37.708354258405 -122.485802654386 (37.708354258405, -122.485802654386)
137279 73608 2 44 136 Wilson St 1 1 1 1 1 09/30/1995 12:00:00 AM 14     5994710.3414 2086333.6948099998 37.7083718896252 -122.46002658894899 (37.7083718896252, -122.460026588949)
109852 112633 2 22 800x BRUNSWICK ST 1 1 1 1     6 5x6   5997602.0 2086276.0 37.70837936312 -122.450028571713 (37.70837936312, -122.450028571713)
113003 112634 2 37 800x BRUNSWICK ST 2 1 1 1       5x6   5997602.0 2086276.0 37.70837936312 -122.450028571713 (37.70837936312, -122.450028571713)
24631 176638 2 19 65 Santa Barbara Ave 1 9 1 1     11 Width 8ft   5993323.454919999 2086371.47099 37.7083957495352 -122.46482253315399 (37.7083957495352, -122.464822533154)
27333 180168 2 37 5935 Mission St 2 1 1 1     5 Width 3ft   5996569.70599 2086304.01805 37.7083971704608 -122.453598302421 (37.7083971704608, -122.453598302421)
169260 177163 2 11 189 Velasco Ave 1 10 1 1     19 Width 6ft   6007991.7614400005 2086069.6109099998 37.70840170934729 -122.41410563508002 (37.7084017093473, -122.41410563508)
159957 71600 2 44 136 Wilson St 2 1 1 1 1 09/30/1995 12:00:00 AM 5     5994689.24707 2086354.8441299999 37.708428747449204 -122.460101024051 (37.7084287474492, -122.460101024051)
59888 177028 2 27 164 Baltimore Way 2 2 1 1     7 Width 6ft   6002357.56159 2086195.5289200002 37.7084293823926 -122.433587065817 (37.7084293823926, -122.433587065817)
137871 175986 2 141 164 Baltimore Way 1 2 1 1     5 Width 6ft   6002363.53933 2086199.02425 37.708439318980396 -122.43356665568399 (37.7084393189804, -122.433566655684)
63245 71602 2 111 149 Wilson St 1 1 1 1 1 09/30/1995 12:00:00 AM 6     5994628.01123 2086360.41662 37.7084405258897 -122.46031306439899 (37.7084405258897, -122.460313064399)
55464 74182 2 44 138 Wilson St 1 1 1 1 1 09/30/1995 12:00:00 AM 4     5994679.00139 2086362.0842900001 37.7084480379267 -122.46013695827 (37.7084480379267, -122.46013695827)
4188 181057 2 37 5931 Mission St 1 1 1 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 2 141 160 Baltimore Way 3 2 1 1     2 Width 6ft   6002380.953509999 2086206.35478 37.7084604350668 -122.433506993768 (37.7084604350668, -122.433506993768)
50962 179971 2 31 160 Baltimore Way 2 2 1 1     8 Width 6ft   6002384.15556 2086207.4195700001 37.708463540423104 -122.43349600315001 (37.7084635404231, -122.43349600315)
65128 73960 2 44 138 Wilson St 2 1 1 1 1 09/30/1995 12:00:00 AM 4     5994666.9696 2086372.6899 37.7084764663958 -122.46017930913601 (37.7084764663958, -122.460179309136)
136095 71601 2 44 138 Wilson St 3 1 1 1 1 09/30/1995 12:00:00 AM 4     5994653.0975 2086384.07363 37.708506925528795 -122.46022807666401 (37.7085069255288, -122.460228076664)
131206 179380 2 45 77 Santa Cruz Ave 1 9 1 1     9 Width 3ft   5993077.06779 2086425.7469099998 37.7085305695939 -122.46567800964199 (37.7085305695939, -122.465678009642)
162639 177639 2 2 5900 Mission St 4 1 1 1     0 Width 4ft   5996554.50989 2086363.6080900002 37.708559919867895 -122.45365512159799 (37.7085599198679, -122.453655121598)
160891 177329 2 21 2610 Bay Shore Blvd 4 1 1 1     7 Width 3ft   6010501.25874 2086080.5894099998 37.708572487900895 -122.405433245075 (37.7085724879009, -122.405433245075)
77398 106965 2 15 63 BELLE AVE   9 1 1           5991753.8 2086471.1 37.7085786821221 -122.47025464516001 (37.7085786821221, -122.47025464516)
94141 179594 2 142 2115 Geneva Ave 1 1 1 1     9 Width 3ft   6006118.53039 2086176.0114900002 37.7085884697411 -122.420587301759 (37.7085884697411, -122.420587301759)
60858 177640 2 2 5900 Mission St 3 1 1 1     0 Width 4ft   5996580.5488 2086374.8113099998 37.7085921740666 -122.453565936738 (37.7085921740666, -122.453565936738)
175340 179595 2 142 2109 Geneva Ave 1 1 1 1     10 Width 3ft   6006095.08243 2086183.72557 37.7086083294779 -122.420668888264 (37.7086083294779, -122.420668888264)
1556 251583 2 12 75 Rice St   1 1 1       3x3   5995352.0 2086409.0 37.7086155444167 -122.45781440192499 (37.7086155444167, -122.457814401925)
72189 178591 2 15 67 Belle Ave 1 4 1 1     9 Width 3ft   5991713.92465 2086485.44715 37.70861577046671 -122.470393502266 (37.7086157704667, -122.470393502266)
137765 178592 2 15 67 Belle Ave 2 4 1 1     9 Width 3ft   5991724.32675 2086485.2281099998 37.7086157704725 -122.470357535671 (37.7086157704725, -122.470357535671)
48697 177826 2 1 89 Belle Ave 3 9 1 1     8 Width 2ft   5991639.3875 2086487.5926299999 37.708617351468895 -122.47065126593999 (37.7086173514689, -122.47065126594)
154719 178860 2 227 89 Belle Ave 4 9 1 1     15 Width 2ft   5991691.410619999 2086487.07285 37.708618932476504 -122.470471431226 (37.7086189324765, -122.470471431226)
132730 71684 2 41 163 Wilson St 1 1 1 1 1 09/30/1995 12:00:00 AM 5     5994555.12862 2086427.38157 37.7086202032335 -122.46056980286501 (37.7086202032335, -122.460569802865)
146626 179832 2 241 89 Belle Ave 1 9 1 1     8 Width 2ft   5991610.51667 2086489.35195 37.708620512585895 -122.470751174349 (37.7086205125859, -122.470751174349)
82512 176641 2 19 89 Belle Ave 2 9 1 1     10 Width 2ft   5991622.07464 2086489.1085299999 37.708620512601705 -122.47071121118 (37.7086205126017, -122.47071121118)
71336 179596 2 142 2101 Geneva Ave 1 1 1 1     8 Width 3ft   6006079.302180001 2086189.0223299998 37.7086219838753 -122.42072380268299 (37.7086219838753, -122.420723802683)
90824 73959 2 12 75 Rice St 2 1 1 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 2 12 75 Rice St 3 1 1 1   09/30/1995 12:00:00 AM 12 2x3   5995358.56494273 2086411.36688337 37.7086224204841 -122.457791883945 (37.7086224204841, -122.457791883945)
39571 175574 2 137 262 Taber Pl 1 4 1 1     16 Width 3ft   6009969.129269999 2086111.4112900002 37.708627351035794 -122.407274531388 (37.7086273510358, -122.407274531388)
152808 180169 2 37 5921 Mission St 2 1 1 1     7 Width 3ft   5996782.55272 2086390.1360799999 37.7086458303022 -122.45286889471001 (37.7086458303022, -122.45286889471)
179770 71586 2 82 121 Goethe St 1 1 1 1 1 09/30/1995 12:00:00 AM 9     5994945.16185 2086428.98532 37.7086470380903 -122.459221923276 (37.7086470380903, -122.459221923276)
51116 179953 2 31 240 Peabody St 1 4 1 1     17 Width 3ft   6009701.772480001 2086128.1297 37.708658289510204 -122.408199733244 (37.7086582895102, -122.408199733244)
57495 71603 2 111 171 Wilson St 1 1 1 1 1 09/30/1995 12:00:00 AM 6     5994523.67906 2086453.64687 37.708690512219206 -122.460680397897 (37.7086905122192, -122.460680397897)
157417 175573 2 137 256 Taber Pl 1 4 1 1     17 Width 3ft   6009978.06824 2086136.62452 37.7086970817661 -122.40724541316901 (37.7086970817661, -122.407245413169)
159960 178246 2 3 334 Schwerin St 1 9 1 1     59 Width 8ft   6008498.73338 2086169.5102900001 37.7087044750874 -122.412360530312 (37.7087044750874, -122.412360530312)
134907 176619 2 19 375 Hanover St 1 10 1 1     15 Width 3ft   5999272.06122 2086368.18274 37.7087278988324 -122.444263284724 (37.7087278988324, -122.444263284724)
170302 71651 2 28 177 Wilson St 1 1 1 1 1 09/30/1995 12:00:00 AM 7     5994505.19973 2086471.6739 37.7087389470079 -122.46074556997101 (37.7087389470079, -122.460745569971)
11387 104350 2 39 349 Guttenberg St 1 1 1 1     24 3x3   5999840.77458 2086361.4281900001 37.708741782568104 -122.44229725703 (37.7087417825681, -122.44229725703)
48575 177328 2 21 2610 Bay Shore Blvd 1 1 1 1     6 Width 3ft   6010526.80865 2086149.78348 37.708763909485796 -122.405349810469 (37.7087639094858, -122.405349810469)
68899 71587 2 37 129 Goethe St 2 1 1 1 1 09/30/1995 12:00:00 AM 5     5994891.94658 2086476.6908099998 37.7087749666595 -122.459409293405 (37.7087749666595, -122.459409293405)
151491 176168 2 136 30 Kelloch Ave 1 10 1 1     12 Width 8ft   6008416.5566300005 2086198.9199700002 37.7087806162127 -122.412646622645 (37.7087806162127, -122.412646622645)
Powered by Datasette · Query took 68.602ms · Data source: data.sfgov.org