sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
108981 103959 2 16 460X Lily St 1 31 1 1           6004484.08045 2109981.44374 37.773860502373 -122.427931334456 (37.773860502373, -122.427931334456)
126368 105684 7 94 635 08TH ST 1 30 1 1     10     6011418.5 2109097.9 37.7718243537934 -122.40388172759701 (37.7718243537934, -122.403881727597)
124771 105685 7 94 635 08TH ST 2 30 1 1     8     6011418.5 2109097.9 37.7718243537934 -122.40388172759701 (37.7718243537934, -122.403881727597)
113280 105686 7 94 635 08TH ST 3 30 1 1     6     6011418.5 2109097.9 37.7718243537934 -122.40388172759701 (37.7718243537934, -122.403881727597)
104863 106838 6 11 735 Battery St 1 30 1 1         Permit Number 773117 6012413.67639 2118682.92207 37.798198135735895 -122.40111294506201 (37.7981981357359, -122.401112945062)
95825 113796 8 191 331 TERESITA BLVD 2 29 1 1       3x3   5997873.0 2098382.0 37.741635103508294 -122.44996387489401 (37.7416351035083, -122.449963874894)
94067 91239 3 109 842x Guerrero St 1 28 1 2   11/20/1989 12:00:00 AM 3     6005622.0 2104059.0 37.7576631893365 -122.423573931211 (37.7576631893365, -122.423573931211)
93295 104872 6 82 1753 Noe St 1 27 1 1   11/22/2013 12:00:00 AM     Permit Number 770054 6003434.1 2098036.1 37.7410019772539 -122.430710793678 (37.7410019772539, -122.430710793678)
139364 96618 6 11 3555@ 19th St 19th St 268 26 1 3         Permit Number 771218 6006277.0 2104934.0 37.7601026853586 -122.42137080656 (37.7601026853586, -122.42137080656)
123271 93131 1 17 700 Brotherhood Way   26 1 1   02/10/2010 12:00:00 AM     Permit Number 53178 5991178.9 2088065.4 37.7129229890255 -122.47235769727399 (37.7129229890255, -122.472357697274)
122233 93130 1 17 700 Brotherhood Way   26 1 1   02/10/2010 12:00:00 AM     Permit Number 53178 5991178.9 2088065.4 37.7129229890255 -122.47235769727399 (37.7129229890255, -122.472357697274)
111357 96617 6 11 3555@ Valencia 19th St 251 26 1 3         Permit Number 771218 6006277.0 2104934.0 37.7601026853586 -122.42137080656 (37.7601026853586, -122.42137080656)
109026 94201 1 40 1227 Pierce St 2 26 1 1   06/22/2010 12:00:00 AM     Permit Number 53604 6002086.0 2112766.6 37.7813718842821 -122.436426049876 (37.7813718842821, -122.436426049876)
105405 98743 2 5 155 Masonic Ave 5 26 1 4 2         5998843.8 2112455.0 37.7803315496091 -122.447619999218 (37.7803315496091, -122.447619999218)
104230 96185 6 17 333 Harrison St 2 26 1 1         Permit Number 767224 6015127.7 2114620.1 37.7871935976335 -122.39143736362 (37.7871935976335, -122.39143736362)
93937 96184 6 17 333 Harrison St 1 26 1 1         Permit Number 767224 6015127.7 2114620.1 37.7871935976335 -122.39143736362 (37.7871935976335, -122.39143736362)
89488 96348 1 17 2200X San Jose Ave 4 26 1 1   05/09/2011 12:00:00 AM     Permit Number 767939 5998886.2 2091075.7 37.7216316467069 -122.445935216513 (37.7216316467069, -122.445935216513)
82961 96186 6 17 333 Harrison St 3 26 1 1         Permit Number 767224 6015127.7 2114620.1 37.7871935976335 -122.39143736362 (37.7871935976335, -122.39143736362)
159181 98310 6 44 1499@Newhall Evans Ave 2 25 1 1   01/25/2012 12:00:00 AM 4   Permit Number 768575 6016248.7932 2098029.2738099997 37.7417009175609 -122.38640138991501 (37.7417009175609, -122.386401389915)
129210 95985 6 19 577 Sanchez St 1 25 1 1           6003673.0 2104901.0 37.7598649162805 -122.430374442168 (37.7598649162805, -122.430374442168)
126156 98308 6 17 1490 Fairfax Ave 1 25 1 1   01/25/2012 12:00:00 AM   3x3 Permit Number 768575 6016246.6 2097899.9 37.7413455620636 -122.386399955147 (37.7413455620636, -122.386399955147)
122098 101203 6 17 7070 California St 2 25 1 1   10/03/2012 12:00:00 AM     Permit Number 769231 5985659.5 2114437.4 37.7850123376907 -122.49337605842699 (37.7850123376907, -122.493376058427)
117221 94066 6 161 548 Page St   25 1 1   06/02/2010 12:00:00 AM     Permit Number 53460 6003937.0 2109751.0 37.7731967952272 -122.429807334526 (37.7731967952272, -122.429807334526)
116206 103477 6 17 875 El Camino Del Mar 1 25 1 1   05/08/2013 12:00:00 AM     Permit Number 770113 5985641.7 2114972.5 37.7864805258078 -122.493477079739 (37.7864805258078, -122.493477079739)
110409 98703 6 47 7070@ 32nd Ave California St 4 25 1 1   03/10/2012 12:00:00 AM     Permit Number 767466 5985659.5 2114437.4 37.7850123376907 -122.49337605842699 (37.7850123376907, -122.493376058427)
109889 93903 6 75 546 Page St   25 1 1           6003947.0 2109752.0 37.773200107256606 -122.42977281454901 (37.7732001072566, -122.429772814549)
104638 101202 6 17 7070 California St 1 25 1 1   10/03/2012 12:00:00 AM     Permit Number 769231 5985659.5 2114437.4 37.7850123376907 -122.49337605842699 (37.7850123376907, -122.493376058427)
104145 101810 6 17 38 Nebraska St 1 25 1 1   11/22/2012 12:00:00 AM     Permit Number 769374 6009268.6 2097830.3 37.740765720819 -122.41052261908999 (37.740765720819, -122.41052261909)
101905 97139 2 19 937 Goettingen St   25 2 1           6011052.0 2090410.0 37.720490952554606 -122.40383424464399 (37.7204909525546, -122.403834244644)
95092 93874 6 150 2614 Sacramento St   25 1 1   04/14/2010 12:00:00 AM     Permit Number 53370 6002291.0 2115777.0 37.789649322620896 -122.43593231943599 (37.7896493226209, -122.435932319436)
89463 99299 6 458 1457 Willard St 1 25 1 1   05/02/2012 12:00:00 AM     Permit Number 768720 5996809.7 2106270.3 37.763233506694 -122.454210015753 (37.763233506694, -122.454210015753)
77945 95138 6 17 2130 Fulton St 128 25 1 1   01/07/2011 12:00:00 AM   3x3 Permit Number 54069 5997590.0 2110608.0 37.7751884337973 -122.45182417211599 (37.7751884337973, -122.451824172116)
75158 95137 6 17 2130 Fulton St 127 25 1 1   01/07/2011 12:00:00 AM   3x3 Permit Number 54069 5997590.0 2110608.0 37.7751884337973 -122.45182417211599 (37.7751884337973, -122.451824172116)
66105 98309 6 82 401X Newhall St 1 25 1 1     6 3x3   6016081.14502 2097910.9401599998 37.741366715992896 -122.386972815546 (37.7413667159929, -122.386972815546)
140734 94945 6 338 1820X Palou Ave   24 1 3 1 04/04/2009 12:00:00 AM       6013714.4 2096294.3 37.7367964240349 -122.395043047708 (37.7367964240349, -122.395043047708)
125788 104827 1 54 4366 26th St   24 1 1       3X3   6001535.3 2100615.2 37.7479758185871 -122.437460780102 (37.7479758185871, -122.437460780102)
107188 94950 6 31 50 Pomona St   24 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
104123 93976 1 150 3261 Harrison St   24 1 1   05/06/2010 12:00:00 AM     Permit Number 53402 6009036.0 2099698.0 37.7458809718535 -122.411458783557 (37.7458809718535, -122.411458783557)
99206 115258 1 54 2150 Jackson St   24 2 1   01/21/2016 12:00:00 AM   6x12   6003858.0 2116995.5 37.7930839063862 -122.430597643601 (37.7930839063862, -122.430597643601)
90667 94951 6 31 50 Pomona St   24 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
44829 94949 6 31 50 Pomona St   24 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
188821 192368 2 10 1310 Indiana St 7 23 1 1     6     6014962.221059999 2102496.55555 37.753895835135104 -122.39116214813801 (37.7538958351351, -122.391162148138)
188614 197467 2 213 1 24th St 1 23 1 1     13     6017027.60375 2102629.3032400003 37.7543747331295 -122.38402874544799 (37.7543747331295, -122.384028745448)
187327 233306 2 3 174 Carnelian Way 1 23 1 1     26     6000631.47853 2100513.23992 37.7476444344533 -122.44057883696999 (37.7476444344533, -122.44057883697)
186761 194527 2 150 1 25th St 16 23 1 1     3     6014969.95823 2102191.83984 37.7530595798584 -122.39111409374901 (37.7530595798584, -122.391114093749)
186405 224262 2 103 91 Stanton St 2 23 1 1     22 Width 3ft   6000293.691000001 2103856.2070400002 37.7568041715846 -122.44198679486 (37.7568041715846, -122.44198679486)
185838 209018 2 103 33 Martha Ave 3 23 1 1     38     6000767.57935 2095529.42368 37.733967799282 -122.439750952539 (37.733967799282, -122.439750952539)
184577 192373 2 10 1310 Indiana St 18 23 1 1     17     6015020.94183 2102357.50513 37.7535172906979 -122.390949358625 (37.7535172906979, -122.390949358625)
182983 194593 2 193 1 01st St 21 23 1 1     19     6014441.963140001 2105885.02123 37.763170945392496 -122.393198423694 (37.7631709453925, -122.393198423694)
181761 192393 2 331 1 24th St 25 23 1 1     3     6017132.65269 2102598.1255200002 37.7542949326738 -122.38366328523001 (37.7542949326738, -122.38366328523)
181215 194529 2 150 1 25th St 23 23 1 1     2     6014967.185409999 2102296.35434 37.753346400626 -122.39113098750201 (37.753346400626, -122.391130987502)
180257 189221 2 274 1310 Indiana St 14 23 1 1     1     6015010.96324 2102373.3642599997 37.7535602828051 -122.39098497537901 (37.7535602828051, -122.390984975379)
179643 222664 2 270 4090 20th St 3 23 1 1     9 Width 3ft   6003149.42788 2104190.19818 37.7578835531891 -122.432134460156 (37.7578835531891, -122.432134460156)
178126 224454 2 40 4090 20th St 6 23 1 1     12 Width 3ft   6003124.6046 2104168.08557 37.7578214298263 -122.432218730236 (37.7578214298263, -122.432218730236)
177343 199556 2 224 1 01st St 17 23 1 1     4     6014441.57524 2105911.35616 37.7632432338158 -122.39320160818599 (37.7632432338158, -122.393201608186)
174582 189679 2 32 1 24th St 20 23 1 1     12     6017238.946959999 2102621.26617 37.7543643468473 -122.383297299846 (37.7543643468473, -122.383297299846)
174541 234949 2 26 176 Carnelian Way 1 23 1 1     21     6000647.81323 2100527.14319 37.74768353965921 -122.44052334968599 (37.7476835396592, -122.440523349686)
173611 192357 2 10 1 25th St 1 23 1 1     16     6015039.28391 2102127.23317 37.7528860304727 -122.39086983518801 (37.7528860304727, -122.390869835188)
173331 233230 2 41 199 Franconia St 3 23 1 1     5 Width 3ft   6010120.38838 2099686.6934 37.745910689944104 -122.407708305 (37.7459106899441, -122.407708305)
172054 222663 2 270 4090 20th St 2 23 1 1     9 Width 3ft   6003162.223809999 2104187.96649 37.7578781509761 -122.43209004713002 (37.7578781509761, -122.43209004713)
171294 223319 2 197 4404 20th St 4 23 1 1     3 Width 3ft   6003647.0575 2104227.27295 37.7580135529116 -122.43041609403299 (37.7580135529116, -122.430416094033)
171136 199548 2 224 1 01st St 4 23 1 1     9     6014382.11605 2105919.95745 37.7632635477036 -122.39340786139499 (37.7632635477036, -122.393407861395)
171000 192369 2 10 1310 Indiana St 8 23 1 1     7     6014983.64642 2102476.35721 37.7538415637469 -122.391086641939 (37.7538415637469, -122.391086641939)
170165 197469 2 213 1 24th St 3 23 1 1     12     6017071.17305 2102662.5786200003 37.7544685090175 -122.383880386982 (37.7544685090175, -122.383880386982)
170055 199552 2 224 1 01st St 8 23 1 1     15     6014417.3246 2105922.3261 37.7632720076265 -122.39328625146099 (37.7632720076265, -122.393286251461)
169576 233228 2 41 199 Franconia St 1 23 1 1     6 Width 3ft   6010113.61596 2099694.13241 37.7459307367175 -122.407732247644 (37.7459307367175, -122.407732247644)
168798 196566 2 362 1 24th St 23 23 1 1     13     6017174.3189900005 2102601.55087 37.7543066409576 -122.38351942967199 (37.7543066409576, -122.383519429672)
167772 245705 2 141 4001 20th St 1 23 1 1     16 Width 3ft   6003616.02573 2104184.50188 37.757894355861396 -122.430520363245 (37.7578943558614, -122.430520363245)
167241 194528 2 150 1 25th St 21 23 1 1     3     6014977.555240001 2102273.87418 37.7532852503289 -122.391093555018 (37.7532852503289, -122.391093555018)
166837 199547 2 224 1 01st St 3 23 1 1     15     6014373.91679 2105917.88241 37.763257394541796 -122.39343607492201 (37.7632573945418, -122.393436074922)
165472 199546 2 224 1 01st St 2 23 1 1     8     6014366.09507 2105920.56167 37.7632643166198 -122.393463315392 (37.7632643166198, -122.393463315392)
165387 191435 2 55 1310 Indiana St 1 23 1 1     1     6014946.60084 2102566.4575099996 37.75408690420971 -122.39122105282699 (37.7540869042097, -122.391221052827)
164374 222115 2 60 4090 20th St 9 23 1 1     15 Width 3ft   6003100.58415 2104168.90978 37.757822330949004 -122.432301861758 (37.757822330949, -122.432301861758)
164257 205447 2 141 321 Melrose Ave 2 23 1 1     2     5997960.43745 2095528.68593 37.7338055912481 -122.44945600530001 (37.7338055912481, -122.4494560053)
164046 194259 2 113 1310 Indiana St 22 23 1 1     1     6014914.86206 2102424.38068 37.753695030018 -122.391320882968 (37.753695030018, -122.391320882968)
163941 211530 2 243 321 Melrose Ave 3 23 1 1     16     5997959.2212 2095523.47143 37.733791203898704 -122.44945983462699 (37.7337912038987, -122.449459834627)
163742 189680 2 32 1 24th St 21 23 1 1     9     6017213.38014 2102597.10976 37.754296605427704 -122.38338403586701 (37.7542966054277, -122.383384035867)
163548 189289 2 141 1 01st St 20 23 1 1     10     6014461.84726 2105889.9963 37.76318571047079 -122.393129998769 (37.7631857104708, -122.393129998769)
162701 176100 2 47 491 La Grande Ave 2 23 1 1     19     6004405.409030001 2089175.08917 37.7167265950249 -122.42672149649799 (37.7167265950249, -122.426721496498)
162377 194033 2 1 1 24th St 9 23 1 1     18     6017162.02159 2102667.2446 37.7544863425722 -122.383566530788 (37.7544863425722, -122.383566530788)
162156 193474 2 549 1310 Indiana St 25 23 1 1     1     6014936.17409 2102358.6880200002 37.7535158347022 -122.391242588881 (37.7535158347022, -122.391242588881)
161704 225066 2 97 199 Franconia St 13 23 1 1     5 Width 3ft   6010116.17854 2099660.00965 37.745837186534295 -122.407720980957 (37.7458371865343, -122.407720980957)
158947 194032 2 1 1 25th St 9 23 1 1     4     6015018.29801 2102168.6663599997 37.7529986327902 -122.39094530450599 (37.7529986327902, -122.390945304506)
158856 177486 2 315 601 La Grande Ave 1 23 1 1     6     6004368.23495 2089081.7920799998 37.7164683196427 -122.42684334834999 (37.7164683196427, -122.42684334835)
157410 233500 2 150 4090 20th St 10 23 1 1     3 Width 3ft   6003098.24212 2104183.0577 37.7578610449587 -122.43231097188601 (37.7578610449587, -122.432310971886)
157392 190908 2 298 1 01st St 32 23 1 1     1     6014392.80706 2105893.3505 37.7631910848138 -122.393369022367 (37.7631910848138, -122.393369022367)
156957 233233 2 41 199 Franconia St 6 23 1 1     9 Width 3ft   6010125.251569999 2099665.5030400003 37.745852778088 -122.407689994823 (37.745852778088, -122.407689994823)
156510 233334 2 3 91 Stanton St 1 23 1 1     15 Width 3ft   6000284.24588 2103856.40307 37.7568041715962 -122.442019473547 (37.7568041715962, -122.442019473547)
156226 223318 2 197 4404 20th St 3 23 1 1     6 Width 3ft   6003637.291809999 2104227.88023 37.75801466716629 -122.43044991126101 (37.7580146671663, -122.430449911261)
154821 237005 2 16 199 Franconia St 16 23 1 1     9 Width 3ft   6010090.49979 2099699.0653 37.7459429872721 -122.40781252834101 (37.7459429872721, -122.407812528341)
154537 233603 2 41 199 Franconia St 9 23 1 1     6 Width 3ft   6010152.72418 2099634.5230799997 37.7457692517475 -122.40759281407101 (37.7457692517475, -122.407592814071)
153814 199510 2 453 1 01st St 14 23 1 1     5     6014434.26374 2105920.54159 37.7632680488164 -122.39322753922801 (37.7632680488164, -122.393227539228)
153691 188436 2 335 1310 Indiana St 3 23 1 1     3     6014947.70455 2102543.51938 37.7540239822338 -122.391215632613 (37.7540239822338, -122.391215632613)
153276 199557 2 224 1 01st St 18 23 1 1     9     6014448.03527 2105905.59327 37.7632277690557 -122.393178861636 (37.7632277690557, -122.393178861636)
153234 209020 2 103 33 Martha Ave 4 23 1 1     12     6000767.68455 2095534.49854 37.7339817396554 -122.439750952547 (37.7339817396554, -122.439750952547)
152563 234500 2 302 4090 20th St 8 23 1 1     9 Width 3ft   6003098.9698 2104154.51537 37.757782715804204 -122.43230641682699 (37.7577827158042, -122.432306416827)
152462 233605 2 41 199 Franconia St 12 23 1 1     9 Width 3ft   6010122.88511 2099649.32748 37.745808231063705 -122.407697037414 (37.7458082310637, -122.407697037414)
152443 196094 2 16 1 01st St 26 23 1 1     8     6014400.8809 2105882.83985 37.7631626734333 -122.393340361863 (37.7631626734333, -122.393340361863)
151834 194402 2 344 1310 Indiana St 12 23 1 1     7     6014991.28899 2102382.99945 37.7535856472653 -122.39105368718799 (37.7535856472653, -122.391053687188)
151779 241988 2 37 199 Franconia St 18 23 1 1     5 Width 3ft   6010085.85388 2099710.92257 37.745975284649 -122.40782942930299 (37.745975284649, -122.407829429303)
151585 196077 2 16 1 25th St 19 23 1 1     6     6014960.28506 2102234.79181 37.7531769800583 -122.391150547759 (37.7531769800583, -122.391150547759)
Powered by Datasette · Query took 2.707ms · Data source: data.sfgov.org