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                    
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
68299 176169 2 136 30 Kelloch Ave 1 10 1 1     17 Width 8ft   6008410.17529 2086203.98853 37.7087941752841 -122.41266903556999 (37.7087941752841, -122.41266903557)
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)
66352 176873 2 199 34 Kelloch Ave 1 1 1 1     2 Width 3ft   6008389.4363 2086207.95793 37.7088039104301 -122.412740993025 (37.7088039104301, -122.412740993025)
151378 177164 2 11 30 Kelloch Ave 2 4 1 1     1 Width 3ft   6008391.56884 2086208.1675200001 37.708804605615896 -122.41273363745701 (37.7088046056159, -122.412733637457)
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)
152396 177857 2 41 435 Sunnydale Ave 3 1 1 1     2 Width 3ft   6010447.87727 2086216.0665099998 37.7089414959281 -122.40562727470501 (37.7089414959281, -122.405627274705)
171717 176170 2 136 42 Kelloch Ave 1 4 1 1     1 Width 3ft   6008360.10661 2086217.92738 37.7088296382394 -122.41284306515499 (37.7088296382394, -122.412843065155)
176962 175882 2 141 140 Kelloch Ave 5 4 1 1     6 Width 3ft   6008037.77895 2086218.44055 37.708812949517394 -122.413957113834 (37.7088129495174, -122.413957113834)
179124 175881 2 141 140 Kelloch Ave 4 4 1 1     12 Width 3ft   6008040.46364 2086219.1455 37.7088150359462 -122.413947884982 (37.7088150359462, -122.413947884982)
156719 178517 2 15 328 Schwerin St 1 4 1 1     19 Width 4ft   6008541.04755 2086224.10569 37.708856757315395 -122.41221814244801 (37.7088567573154, -122.412218142448)
55394 175880 2 141 140 Kelloch Ave 3 4 1 1     11 Width 3ft   6008040.572369999 2086224.4613400002 37.7088296382554 -122.413947884988 (37.7088296382554, -122.413947884988)
162521 178554 2 15 575 Argonaut Ave 1 1 1 1     9 Width 2ft   6007838.70528 2086225.04271 37.7088198950039 -122.414645608726 (37.7088198950039, -122.414645608726)
119122 178548 2 15 328 Schwerin St 1 1 1 1     15 Width 3ft   6008543.60628 2086225.1928599998 37.7088598860379 -122.412209375875 (37.7088598860379, -122.412209375875)
188869 178549 2 15 42 Kelloch Ave 1 1 1 1     10 Width 3ft   6008341.68171 2086226.9900599997 37.7088534882771 -122.412907384688 (37.7088534882771, -122.412907384688)
154303 175879 2 141 140 Kelloch Ave 2 4 1 1     9 Width 3ft   6008041.81725 2086229.374 37.708843197325 -122.41394392978701 (37.708843197325, -122.413943929787)
60233 176171 2 136 46 Kelloch Ave 1 10 1 1     17 Width 6ft   6008338.63627 2086231.2816700002 37.708865101208204 -122.412918213412 (37.7088651012082, -122.412918213412)
52100 178508 2 15 575 Argonaut Ave 2 1 1 1     12 Width 3ft   6007843.72677 2086231.7813400002 37.708838680016704 -122.414628730257 (37.7088386800167, -122.414628730257)
70441 177856 2 41 435 Sunnydale Ave 2 1 1 1     2 Width 3ft   6010405.93473 2086233.7709700002 37.7089877633386 -122.405773481086 (37.7089877633386, -122.405773481086)
57129 175878 2 141 140 Kelloch Ave 1 4 1 1     9 Width 3ft   6008044.64173 2086236.91355 37.7088640580086 -122.413934700952 (37.7088640580086, -122.413934700952)
183428 177855 2 41 435 Sunnydale Ave 1 1 1 1     2 Width 3ft   6010393.78556 2086237.29466 37.7089967592527 -122.40581571863301 (37.7089967592527, -122.405815718633)
50693 176103 2 47 50 Kelloch Ave 1 10 1 1     14 Width 6ft   6008313.99103 2086238.6229700001 37.7088838754685 -122.413003909814 (37.7088838754685, -122.413003909814)
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)
145728 178555 2 15 580 Argonaut Ave 1 1 1 1     14 Width 2ft   6007810.831590001 2086243.5160299998 37.708869052843 -122.414743250798 (37.708869052843, -122.414743250798)
147503 178547 2 15 322 Schwerin St 1 1 1 1     15 Width 3ft   6008553.87122 2086250.69527 37.7089304864164 -122.412175699859 (37.7089304864164, -122.412175699859)
76451 178516 2 15 322 Schwerin St 1 4 1 1     17 Width 4ft   6008552.66413 2086251.2184400002 37.70893185520271 -122.41217990870001 (37.7089318552027, -122.4121799087)
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)
184172 178271 2 3 35 Tomaso Ct 2 17 1 1     17 Width 3ft   6009176.170940001 2086260.2904299998 37.7089917311415 -122.41002561149901 (37.7089917311415, -122.410025611499)
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)
32945 178518 2 15 62 Kelloch Ave 1 10 1 1     14 Width 6ft   6008249.62715 2086262.35093 37.708945414261606 -122.41322803793899 (37.7089454142616, -122.413228037939)
70516 178550 2 15 62 Kelloch Ave 1 1 1 1     12 Width 3ft   6008247.372380001 2086262.5391799998 37.7089458045697 -122.413235844076 (37.7089458045697, -122.413235844076)
176645 178270 2 3 35 Tomaso Ct 1 17 1 1     14 Width 3ft   6009167.93697 2086263.08528 37.7089989437285 -122.41005426658701 (37.7089989437285, -122.410054266587)
30008 178244 2 3 62 Tomaso Ct 4 7 1 1     17 Width 8ft   6009170.0421 2086265.24197 37.7090049835504 -122.410047143074 (37.7090049835504, -122.410047143074)
168635 177817 2 1 35 Tomaso Ct 3 17 1 1     15 Width 3ft   6009184.18934 2086265.3806200002 37.7090061571804 -122.409998257729 (37.7090061571804, -122.409998257729)
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)
37802 178243 2 3 62 Tomaso Ct 3 7 1 1     26 Width 8ft   6009152.06447 2086268.0035 37.7090115585089 -122.410109471469 (37.7090115585089, -122.410109471469)
180452 177816 2 1 60 Tomaso Ct 1 7 1 1     15 Width 3ft   6009147.33252 2086269.1354099999 37.7090144012735 -122.41012590570601 (37.7090144012735, -122.410125905706)
132971 178242 2 3 62 Tomaso Ct 2 7 1 1     17 Width 8ft   6009144.65272 2086270.07017 37.709016817728 -122.41013523347401 (37.709016817728, -122.410135233474)
183568 176102 2 47 62 Tomaso Ct 5 7 1 1     20 Width 8ft   6009173.04361 2086270.9274900001 37.709020763061396 -122.41003717048099 (37.7090207630614, -122.410037170481)
62440 178519 2 15 74 Kelloch Ave 1 4 1 1     11 Width 3ft   6008207.90106 2086273.84024 37.7089746188665 -122.413373061735 (37.7089746188665, -122.413373061735)
66895 176112 2 47 35 Tomaso Ct 4 17 1 1     15 Width 3ft   6009187.4096 2086275.4475900002 37.7090339795175 -122.409987838189 (37.7090339795175, -122.409987838189)
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)
166145 178551 2 15 74 Kelloch Ave 1 1 1 1     12 Width 3ft   6008208.8909599995 2086276.4009099999 37.70898170551929 -122.413369821453 (37.7089817055193, -122.413369821453)
53016 180001 2 37 62 Tomaso Ct 6 7 1 1     22 Width 8ft   6009181.15123 2086279.38185 37.709044431429604 -122.41000974567899 (37.7090444314296, -122.410009745679)
164474 177818 2 1 35 Tomaso Ct 5 17 1 1     16 Width 3ft   6009189.876619999 2086285.53025 37.7090618027185 -122.409980023068 (37.7090618027185, -122.409980023068)
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)
55176 178556 2 15 550 Argonaut Ave 1 1 1 1     15 Width 2ft   6007824.59893 2086288.7583 37.708994052312 -122.414698868372 (37.708994052312, -122.414698868372)
34606 178520 2 15 74 Kelloch Ave 2 4 1 1     10 Width 3ft   6008160.20585 2086291.9091900003 37.7090215544595 -122.413539180899 (37.7090215544595, -122.413539180899)
Powered by Datasette · Query took 122.167ms · Data source: data.sfgov.org