sf-trees

Data source: data.sfgov.org

Custom SQL query returning 75 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
134718 196565 2 362 1 24th St 22 23 1 1     9     6017179.65065 2102592.91539 37.7542832244069 -122.38350039013599 (37.7542832244069, -122.383500390136)
136962 188006 2 12 1310 Indiana St 5 23 1 1     3     6014970.94657 2102528.93122 37.7539852160557 -122.39113423586399 (37.7539852160557, -122.391134235864)
137271 191088 2 49 1 01st St 19 23 1 1     18     6014455.34951 2105889.6924799997 37.7631845152826 -122.393152451232 (37.7631845152826, -122.393152451232)
137284 189677 2 32 1 24th St 14 23 1 1     9     6017255.58244 2102660.6719 37.754473466102795 -122.38324251223801 (37.7544734661028, -122.383242512238)
137382 189292 2 141 1 01st St 33 23 1 1     5     6014376.229280001 2105886.6133 37.763171664875294 -122.393425888311 (37.7631716648753, -122.393425888311)
137606 196282 2 16 1 25th St 13 23 1 1     12     6015015.25562 2102205.64875 37.75310000977571 -122.39095841029499 (37.7531000097757, -122.390958410295)
138227 199545 2 224 1 01st St 1 23 1 1     12     6014356.43896 2105915.99545 37.7632512422621 -122.39349639336099 (37.7632512422621, -122.393496393361)
139126 199549 2 224 1 01st St 5 23 1 1     9     6014392.26095 2105920.87265 37.7632666242892 -122.39337283731399 (37.7632666242892, -122.393372837314)
146754 240351 2 76 4090 20th St 1 23 1 1     22 Width 3ft   6003153.88022 2104182.56452 37.7578628454134 -122.432118516979 (37.7578628454134, -122.432118516979)
147367 194594 2 193 1 01st St 22 23 1 1     10     6014433.28496 2105898.16367 37.7632065495547 -122.393229358544 (37.7632065495547, -122.393229358544)
148293 192370 2 10 1310 Indiana St 9 23 1 1     8     6015014.73228 2102443.11605 37.7537520155509 -122.390976815833 (37.7537520155509, -122.390976815833)
150305 234860 2 168 160 Carnelian Way 2 23 1 1     6     6000574.359 2100517.55086 37.7476530184698 -122.44077666170799 (37.7476530184698, -122.440776661708)
150675 190752 2 348 1 24th St 5 23 1 1     9     6017117.58441 2102700.05767 37.7545739842169 -122.383722492107 (37.7545739842169, -122.383722492107)
150778 188007 2 12 1310 Indiana St 2 23 1 1     9     6015000.133780001 2102555.57956 37.7540600063901 -122.391035161147 (37.7540600063901, -122.391035161147)
151521 223316 2 197 4404 20th St 1 23 1 1     3 Width 3ft   6003622.06269 2104228.7754599997 37.7580162625599 -122.430502643895 (37.7580162625599, -122.430502643895)
151585 196077 2 16 1 25th St 19 23 1 1     6     6014960.28506 2102234.79181 37.7531769800583 -122.391150547759 (37.7531769800583, -122.391150547759)
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)
151834 194402 2 344 1310 Indiana St 12 23 1 1     7     6014991.28899 2102382.99945 37.7535856472653 -122.39105368718799 (37.7535856472653, -122.391053687188)
152443 196094 2 16 1 01st St 26 23 1 1     8     6014400.8809 2105882.83985 37.7631626734333 -122.393340361863 (37.7631626734333, -122.393340361863)
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)
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)
153234 209020 2 103 33 Martha Ave 4 23 1 1     12     6000767.68455 2095534.49854 37.7339817396554 -122.439750952547 (37.7339817396554, -122.439750952547)
153276 199557 2 224 1 01st St 18 23 1 1     9     6014448.03527 2105905.59327 37.7632277690557 -122.393178861636 (37.7632277690557, -122.393178861636)
153691 188436 2 335 1310 Indiana St 3 23 1 1     3     6014947.70455 2102543.51938 37.7540239822338 -122.391215632613 (37.7540239822338, -122.391215632613)
153814 199510 2 453 1 01st St 14 23 1 1     5     6014434.26374 2105920.54159 37.7632680488164 -122.39322753922801 (37.7632680488164, -122.393227539228)
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)
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)
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)
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)
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)
157392 190908 2 298 1 01st St 32 23 1 1     1     6014392.80706 2105893.3505 37.7631910848138 -122.393369022367 (37.7631910848138, -122.393369022367)
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)
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)
158947 194032 2 1 1 25th St 9 23 1 1     4     6015018.29801 2102168.6663599997 37.7529986327902 -122.39094530450599 (37.7529986327902, -122.390945304506)
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)
162156 193474 2 549 1310 Indiana St 25 23 1 1     1     6014936.17409 2102358.6880200002 37.7535158347022 -122.391242588881 (37.7535158347022, -122.391242588881)
162377 194033 2 1 1 24th St 9 23 1 1     18     6017162.02159 2102667.2446 37.7544863425722 -122.383566530788 (37.7544863425722, -122.383566530788)
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)
163548 189289 2 141 1 01st St 20 23 1 1     10     6014461.84726 2105889.9963 37.76318571047079 -122.393129998769 (37.7631857104708, -122.393129998769)
163742 189680 2 32 1 24th St 21 23 1 1     9     6017213.38014 2102597.10976 37.754296605427704 -122.38338403586701 (37.7542966054277, -122.383384035867)
163941 211530 2 243 321 Melrose Ave 3 23 1 1     16     5997959.2212 2095523.47143 37.733791203898704 -122.44945983462699 (37.7337912038987, -122.449459834627)
164046 194259 2 113 1310 Indiana St 22 23 1 1     1     6014914.86206 2102424.38068 37.753695030018 -122.391320882968 (37.753695030018, -122.391320882968)
164257 205447 2 141 321 Melrose Ave 2 23 1 1     2     5997960.43745 2095528.68593 37.7338055912481 -122.44945600530001 (37.7338055912481, -122.4494560053)
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)
165387 191435 2 55 1310 Indiana St 1 23 1 1     1     6014946.60084 2102566.4575099996 37.75408690420971 -122.39122105282699 (37.7540869042097, -122.391221052827)
165472 199546 2 224 1 01st St 2 23 1 1     8     6014366.09507 2105920.56167 37.7632643166198 -122.393463315392 (37.7632643166198, -122.393463315392)
166837 199547 2 224 1 01st St 3 23 1 1     15     6014373.91679 2105917.88241 37.763257394541796 -122.39343607492201 (37.7632573945418, -122.393436074922)
167241 194528 2 150 1 25th St 21 23 1 1     3     6014977.555240001 2102273.87418 37.7532852503289 -122.391093555018 (37.7532852503289, -122.391093555018)
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)
168798 196566 2 362 1 24th St 23 23 1 1     13     6017174.3189900005 2102601.55087 37.7543066409576 -122.38351942967199 (37.7543066409576, -122.383519429672)
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)
170055 199552 2 224 1 01st St 8 23 1 1     15     6014417.3246 2105922.3261 37.7632720076265 -122.39328625146099 (37.7632720076265, -122.393286251461)
170165 197469 2 213 1 24th St 3 23 1 1     12     6017071.17305 2102662.5786200003 37.7544685090175 -122.383880386982 (37.7544685090175, -122.383880386982)
171000 192369 2 10 1310 Indiana St 8 23 1 1     7     6014983.64642 2102476.35721 37.7538415637469 -122.391086641939 (37.7538415637469, -122.391086641939)
171136 199548 2 224 1 01st St 4 23 1 1     9     6014382.11605 2105919.95745 37.7632635477036 -122.39340786139499 (37.7632635477036, -122.393407861395)
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)
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)
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)
173611 192357 2 10 1 25th St 1 23 1 1     16     6015039.28391 2102127.23317 37.7528860304727 -122.39086983518801 (37.7528860304727, -122.390869835188)
174541 234949 2 26 176 Carnelian Way 1 23 1 1     21     6000647.81323 2100527.14319 37.74768353965921 -122.44052334968599 (37.7476835396592, -122.440523349686)
174582 189679 2 32 1 24th St 20 23 1 1     12     6017238.946959999 2102621.26617 37.7543643468473 -122.383297299846 (37.7543643468473, -122.383297299846)
177343 199556 2 224 1 01st St 17 23 1 1     4     6014441.57524 2105911.35616 37.7632432338158 -122.39320160818599 (37.7632432338158, -122.393201608186)
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)
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)
180257 189221 2 274 1310 Indiana St 14 23 1 1     1     6015010.96324 2102373.3642599997 37.7535602828051 -122.39098497537901 (37.7535602828051, -122.390984975379)
181215 194529 2 150 1 25th St 23 23 1 1     2     6014967.185409999 2102296.35434 37.753346400626 -122.39113098750201 (37.753346400626, -122.391130987502)
181761 192393 2 331 1 24th St 25 23 1 1     3     6017132.65269 2102598.1255200002 37.7542949326738 -122.38366328523001 (37.7542949326738, -122.38366328523)
182983 194593 2 193 1 01st St 21 23 1 1     19     6014441.963140001 2105885.02123 37.763170945392496 -122.393198423694 (37.7631709453925, -122.393198423694)
184577 192373 2 10 1310 Indiana St 18 23 1 1     17     6015020.94183 2102357.50513 37.7535172906979 -122.390949358625 (37.7535172906979, -122.390949358625)
185838 209018 2 103 33 Martha Ave 3 23 1 1     38     6000767.57935 2095529.42368 37.733967799282 -122.439750952539 (37.733967799282, -122.439750952539)
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)
186761 194527 2 150 1 25th St 16 23 1 1     3     6014969.95823 2102191.83984 37.7530595798584 -122.39111409374901 (37.7530595798584, -122.391114093749)
187327 233306 2 3 174 Carnelian Way 1 23 1 1     26     6000631.47853 2100513.23992 37.7476444344533 -122.44057883696999 (37.7476444344533, -122.44057883697)
188614 197467 2 213 1 24th St 1 23 1 1     13     6017027.60375 2102629.3032400003 37.7543747331295 -122.38402874544799 (37.7543747331295, -122.384028745448)
188821 192368 2 10 1310 Indiana St 7 23 1 1     6     6014962.221059999 2102496.55555 37.753895835135104 -122.39116214813801 (37.7538958351351, -122.391162148138)
Powered by Datasette · Query took 2.574ms · Data source: data.sfgov.org