sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
20 251179 4 13 1043 Minna St 2 5 1 1       3x3   6007668.0 2109797.0 37.7735336727503 -122.41690453761002 (37.7735336727503, -122.41690453761)
21 251178 4 13 1043 Minna St 1 5 1 1       3x3   6007668.0 2109797.0 37.7735336727503 -122.41690453761002 (37.7735336727503, -122.41690453761)
49 251186 2 19 3042 Steiner St 1 5 1 1       3x3   6002010.0 2118654.0 37.7975328515761 -122.437110618013 (37.7975328515761, -122.437110618013)
51 60867 1 17   1 1 1 1   04/25/1983 12:00:00 AM     Permit Number 20649          
53 251187 2 25 1 Baker St 2 1 1 1       3x3   6000800.0 2109063.0 37.771129578660705 -122.440609247553 (37.7711295786607, -122.440609247553)
57 44642 1 17   60 1 1 1   04/29/2001 12:00:00 AM     Permit Number 43835          
59 44994 1 17   106 1 1 1   04/25/2001 12:00:00 AM     Permit Number 43922          
68 251188 2 25 1 Baker St 5 1 1 1       3x3   6000800.0 2109063.0 37.771129578660705 -122.440609247553 (37.7711295786607, -122.440609247553)
71 251206 2 18 270 Trumbull St 1 1 1 1       3x3   6005145.0 2094297.0 37.7308320294825 -122.424529217878 (37.7308320294825, -122.424529217878)
78 251199 6 3 900X 14th St 4 7 1 1       3X3   6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
79 251205 2 2 2000X Market St 5 5 1 1       4X4   6004899.0 2108432.0 37.769629569555896 -122.426385716137 (37.7696295695559, -122.426385716137)
84 36641 1 33   13 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
86 119601 6 34 4357x Mission St 3 7 1 1         Permit Number 774415          
88 251208 2 2 4115 Kirkham St 1 1 1 1       3x3   5982071.0 2104840.0 37.758450113202294 -122.505079418654 (37.7584501132023, -122.505079418654)
93 251198 6 3 900X 14th St 3 7 1 1           6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
114 251216 6 1 399X Townsend St 1 5 1 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
118 251217 6 1 399X Townsend St 2 5 1 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
125 119758 2 22 151X Octavia St Frontage West 1 1 1 1                    
142 251241 2 34 2305 Golden Gate Ave 1 1 1 1           5998495.0 2111363.0 37.777313260379 -122.44874797929701 (37.777313260379, -122.448747979297)
151 36617 1 33   8 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
155 251225 2 52 1 Yukon St 1 1 1 1       12x2.5   6000238.0 2104757.0 37.7592743544717 -122.442244057145 (37.7592743544717, -122.442244057145)
161 142720 2 54 1170 COLUMBUS AVE 3 1 1 1       Width 0ft   6007999.4825 2121188.7351 37.8048312311886 -122.416565007078 (37.8048312311886, -122.416565007078)
162 251231 2 3 164 Serrano Dr 1 1 1 1       3x3   5989598.0 2090848.0 37.7204716934452 -122.478025052476 (37.7204716934452, -122.478025052476)
166 251230 2 55 99x Ogden Ave 2 1 1 1       3x3   6007537.0 2096150.0 37.7360547576169 -122.416390866966 (37.7360547576169, -122.416390866966)
167 251232 2 55 99x Ogden Ave 1 1 1 1       3x3   6007537.0 2096150.0 37.7360547576169 -122.416390866966 (37.7360547576169, -122.416390866966)
171 251242 2 34 2449 Golden Gate Ave 1 5 1 1           5997716.0 2111278.0 37.7770352956542 -122.451436646998 (37.7770352956542, -122.451436646998)
172 48332 1 17   142 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
174 251226 2 56 1 Yukon St 2 1 1 1       13x2.5   6000262.0 2104839.0 37.7595008741196 -122.442166940047 (37.7595008741196, -122.442166940047)
204 61453 1 17   1 1 1 1   06/22/1984 12:00:00 AM     Permit Number 21392          
235 45975 1 17   132 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
240 251249 5 64 161 Lundys Ln 1 7 2 1       3x3   6006716.0 2098685.0 37.7429691002686 -122.41940918518 (37.7429691002686, -122.41940918518)
241 251257 2 65 1748x Eucalyptus Dr 1 9 1 1       3x3   5986101.0 2094852.0 37.7312620395563 -122.490407299046 (37.7312620395563, -122.490407299046)
245 251255 2 17 4089x Alemany Blvd 1 1 1 1       3x3   5991686.0 2086822.0 37.7095382490701 -122.47051450746099 (37.7095382490701, -122.470514507461)
251 251258 2 65 1748x Eucalyptus Dr 2 9 1 1       3x3   5986101.0 2094852.0 37.7312620395563 -122.490407299046 (37.7312620395563, -122.490407299046)
253 251256 2 67 4091x Alemany Blvd 1 1 1 1       3x3   5991686.0 2086783.0 37.70943116445179 -122.470511668938 (37.7094311644518, -122.470511668938)
257 251260 2 9 1163 South Van Ness Ave 3 1 1 1       Width 3ft   6007684.87734 2102881.8281400003 37.754547168222295 -122.41635626045701 (37.7545471682223, -122.416356260457)
258 251259 2 69 1050x Sacramento St 2 1 1 1       3x3   6009753.0 2116795.0 37.7928655753561 -122.410186352148 (37.7928655753561, -122.410186352148)
272 251264 6 47 3630x 19th Ave 3 9 1 1         Permit Number 779147          
277 251265 6 47 3630x 19th Ave 4 9 1 1         Permit Number 779147          
279 48153 1 17   263 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
293 251262 6 47 3630x 19th Ave 1 9 1 1         Permit Number 779147          
294 251266 5 12 10x Paloma Ave 1 1 1 1                    
300 251263 6 47 3630x 19th Ave 2 9 1 1         Permit Number 779147          
308 46059 1 17   101 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
316 67789 1 17 7 4384 St 1 1 1 1   12/17/1992 12:00:00 AM     Permit Number 31429          
320 48259 1 17   123 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
321 65143 1 17   1 1 1 1   06/26/1989 12:00:00 AM     Permit Number 27118          
328 251272 2 74 1301X 07th Ave 1 1 1 1       3x3   5993949.0 2106317.0 37.7631972735035 -122.46410754142299 (37.7631972735035, -122.464107541423)
339 251273 2 74 1301X 07th Ave 2 1 1 1       3x3   5993949.0 2106317.0 37.7631972735035 -122.46410754142299 (37.7631972735035, -122.464107541423)
363 119608 6 34 299x Avalon Ave 4 7 1 1                    
425 251299 4 15 2190X Market St 3 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
427 251307 2 17 200 Cashmere St 1 13 1 1       3x3   6016315.0 2096328.0 37.7370332293639 -122.38605389871 (37.7370332293639, -122.38605389871)
431 251298 4 15 2190X Market St 4 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
432 251297 4 15 2190X Market St 5 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
441 251295 1 2 220 Point Lobos Ave 1 1 1 1   06/26/1989 12:00:00 AM   3x3 Permit Number 27117 5982087.0 2112698.0 37.7800268469822 -122.50560657808902 (37.7800268469822, -122.505606578089)
443 251293 2 54 3789 Market St 1 5 2 1       3x3   6000208.0 2102740.0 37.753734455764 -122.44220302061701 (37.753734455764, -122.442203020617)
444 44838 1 17   12 1 1 1   04/25/2001 12:00:00 AM     Permit Number 43922          
446 251296 4 15 2190X Market St 2 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
454 251309 2 44 2111 15th Ave 2 1 1 1       3x3   5991606.081259999 2101026.68041 37.7485361329461 -122.471825260742 (37.7485361329461, -122.471825260742)
462 187628 2 32 2 Rotteck St 1 1 1 1       3x3 Permit Number 779889 6003236.0 2095183.0 37.7331567921798 -122.431192151262 (37.7331567921798, -122.431192151262)
467 85277 1 61 801 Holladay Ave 1 1 1 1   07/24/2007 12:00:00 AM     Permit Number 49566          
476 174954 2 15 1400x Market St 1 1 1 1       4xt Permit Number 779898 6007316.0 2110809.0 37.776292577113104 -122.418193923043 (37.7762925771131, -122.418193923043)
509 38234 1 68 0 16th St 4 1 1 1   07/21/1998 12:00:00 AM     Permit Number 40352          
514 251312 2 54 1499 Noe St 1 1 1 1       3x3   6003369.0 2099547.0 37.7451468706327 -122.431043696183 (37.7451468706327, -122.431043696183)
515 48129 1 17   297 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
518 251314 4 54 1108 Diamond St 1 1 1 1       3x3   6001901.0 2100825.0 37.7485726639367 -122.43621121860001 (37.7485726639367, -122.4362112186)
533 251313 4 54 390 28th St 1 1 1 1       3x3   6003369.0 2099547.0 37.7451468706327 -122.431043696183 (37.7451468706327, -122.431043696183)
536 45913 1 17   59 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
541 251317 2 49 399X 12th St 3 1 1 1       3x3   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
545 251322 2 95 828 Foerster St 6 9 1 1       Width 3ft   5998302.82159 2096489.58159 37.7364635618398 -122.448341458403 (37.7364635618398, -122.448341458403)
549 251321 2 47 100X Monument Way 1 14 1 1                    
558 251320 2 25 35 Park St 3 1 1 1       Width 3ft   6004965.06472 2096463.48809 37.7367705580153 -122.425305393447 (37.7367705580153, -122.425305393447)
580 48268 1 17   132 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
588 251328 2 17 95x Tompkins Ave 2 1 1 1       3x3 Permit Number 779511 6007651.0 2096616.0 37.7373407014575 -122.416029712695 (37.7373407014575, -122.416029712695)
592 251331 2 32 2232 Webster St 2 1 1 1       3x3   6003295.0 2116396.0 37.791405922266996 -122.43250281523301 (37.791405922267, -122.432502815233)
595 119606 6 1 299x Avalon Ave 2 7 1 1                    
597 251329 1 17 95x Tompkins Ave 3 1 1 1   02/10/2017 12:00:00 AM   3x3 Permit Number 779511 6007651.0 2096616.0 37.7373407014575 -122.416029712695 (37.7373407014575, -122.416029712695)
599 251330 2 32 2232 Webster St 1 1 1 1       3x3   6003295.0 2116396.0 37.791405922266996 -122.43250281523301 (37.791405922267, -122.432502815233)
610 251327 1 17 95x Tompkins Ave 1 1 1 1   02/10/2017 12:00:00 AM   3x3 Permit Number 779511 6007651.0 2096616.0 37.7373407014575 -122.416029712695 (37.7373407014575, -122.416029712695)
617 57850 1 17 1700 S. Amaylett Blvd 1 1 1 1   04/14/1977 12:00:00 AM     Permit Number 16791          
621 251339 1 51 2230 Ocean Ave 3 1 1 1 4 05/28/2012 12:00:00 AM   3x3   5992640.0 2093746.0 37.728604988221896 -122.46772058248399 (37.7286049882219, -122.467720582484)
631 251294 7 54 7126 Geary Blvd 1 16 1 1       3x3   5984860.0 2112552.0 37.779788778901796 -122.49600289252199 (37.7797887789018, -122.496002892522)
632 44905 1 17   139 1 1 1   04/25/2001 12:00:00 AM     Permit Number 43922          
633 48204 1 17   47 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
634 251340 1 51 2230 Ocean Ave 4 1 1 1   04/26/1996 12:00:00 AM   3x3   5992640.0 2093746.0 37.728604988221896 -122.46772058248399 (37.7286049882219, -122.467720582484)
635 251315 2 49 399X 12th St 5 1 1 1       3x3   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
638 251341 1 50 2275 Ocean Ave 1 1 1 1   11/14/1996 12:00:00 AM   3x3 Permit Number 37503 5992527.0 2093770.0 37.7286643609316 -122.46811297163299 (37.7286643609316, -122.468112971633)
644 251319 2 49 399X 12th St 1 1 1 1       3x3   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
645 251316 2 49 399X 12th St 4 1 1 1       3x3   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
651 251359 2 2 4050 Geary Blvd 2 1 1 1       3x3   5994421.0 2112898.0 37.7812941506761 -122.462952553035 (37.7812941506761, -122.462952553035)
655 251353 2 26 510 22nd Ave 4 1 1 1       Width 3ft   5989096.969740001 2111833.32857 37.7780627562405 -122.481292881664 (37.7780627562405, -122.481292881664)
667 251356 2 54 519 22nd Ave 1 1 1 1       3x3   5989039.0 2111772.0 37.777890994652296 -122.481488924787 (37.7778909946523, -122.481488924787)
669 251343 7 39 934 Brannan St 1 13 1 1       3x3   6010724.0 2108745.0 37.7708165471861 -122.40625919407302 (37.7708165471861, -122.406259194073)
675 47038 1 12 716 Walter St 1 1 1 1   05/02/2002 12:00:00 AM     Permit Number 45030          
682 251365 5 47 138x Gladeview Way 2 9 1 1                    
689 48269 1 17   120 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
697 251362 2 105 1300X Stanyan St 1 14 1 1       3x3   5997565.0 2104877.0 37.7594511396077 -122.451497194349 (37.7594511396077, -122.451497194349)
712 251366 5 47 138x Gladeview Way 3 9 1 1                    
713 251364 5 47 138x Gladeview Way 1 9 1 1                    
726 44958 1 17   82 1 1 1   04/25/2001 12:00:00 AM     Permit Number 43922          
729 48266 1 17   130 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
Powered by Datasette · Query took 183.099ms · Data source: data.sfgov.org