sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3 119263 3 3 495X Lakeshore Dr 1 3 1 2       10x30            
5 188702 3 5 1501 Evans Ave 2 4 1 2     17 Width 4ft   6015994.71985 2098219.31717 37.7422086702947 -122.387293152263 (37.7422086702947, -122.387293152263)
7 188697 3 5 1301 Evans Ave 13 4 1 2     15 Width 3ft   6017236.81305 2097292.98379 37.7397338556296 -122.38293388291001 (37.7397338556296, -122.38293388291)
29 188686 3 5 1300 Evans Ave 20 4 1 2     12 Width 3ft   6017760.57019 2097020.5910900002 37.739014844955705 -122.381104000867 (37.7390148449557, -122.381104000867)
32 10933 3 11 1359 Hudson Ave 1 1 1 2     12 3X4   6016893.48466 2096461.5108299998 37.7374318223223 -122.384063092353 (37.7374318223223, -122.384063092353)
36 13434 3 15 2X Market St 2 1 1 2     6 4X4   6014136.36792 2117295.16476 37.7944836321678 -122.39505462349199 (37.7944836321678, -122.395054623492)
69 19206 3 30 630 Sansome St 4 1 1 2     12 3X3   6012230.08543 2117977.14861 37.7962500076802 -122.40169859442699 (37.7962500076802, -122.401698594427)
72 25725 3 15 729 Grove St 1 1 1 2     12 3X3   6004286.7153 2111148.1106 37.777052715887706 -122.428697236196 (37.7770527158877, -122.428697236196)
74 188665 3 5 2175X Palou Ave 1 1 1 2     37     6011669.71313 2097723.45025 37.740606653987705 -122.402212916691 (37.7406066539877, -122.402212916691)
97 5266 3 26 1245 Divisadero St 2 1 1 2     12 3X4   6001289.7409 2112772.8314 37.781343716873 -122.43918115910401 (37.781343716873, -122.439181159104)
106 10645 3 36 906 Hayes St 3 1 1 2     24 4x4   6003455.1435 2110726.9996 37.775849351151706 -122.431543829861 (37.7758493511517, -122.431543829861)
109 9895 3 40 1800X Pine St 1 1 1 2     18 3X3   6005051.0377 2115464.4068 37.7889474242075 -122.426360597873 (37.7889474242075, -122.426360597873)
119 251215 3 43 175X Otis St 11 1 1 2       3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.42011195674299 (37.7705111956623, -122.420111956743)
123 18916 3 41 2621 Sacramento St 1 1 1 2     14 6x5   6002236.03231 2115724.70658 37.7895026155894 -122.4361187581 (37.7895026155894, -122.4361187581)
124 20281 3 2 20X Sunset Blvd 2 1 1 2     12 60            
126 228560 3 11 700 Valencia St 2 1 1 2     7 Width 3ft   6006200.30022 2105449.82338 37.761514690968596 -122.42167271244301 (37.7615146909686, -122.421672712443)
127 18052 3 46 2840 Pine St 2 1 1 2     18 3X3   6000317.799 2114808.7133 37.7868783690408 -122.442689819484 (37.7868783690408, -122.442689819484)
129 20398 3 47 262X Sunset Blvd 43 1 1 2     24 60            
131 237033 3 18 100 Octavia St 7 4 1 2     6 Width 4ft   6005718.98472 2109769.85153 37.7733493059578 -122.423644547079 (37.7733493059578, -122.423644547079)
135 237030 3 18 100 Octavia St 4 4 1 2     5 Width 4ft   6005725.94025 2109733.85532 37.773250861665204 -122.423617927146 (37.7732508616652, -122.423617927146)
137 228561 3 11 700 Valencia St 1 1 1 2     7 Width 3ft   6006199.77605 2105468.2728 37.7615653191939 -122.42167583577299 (37.7615653191939, -122.421675835773)
140 6337 3 2 1916 Ellis St 1 1 1 2     18 3X3   6001700.9234 2112915.307 37.7817583075946 -122.437768878541 (37.7817583075946, -122.437768878541)
143 18836 3 32 2055 Sacramento St 2 1 1 2     12 3X3   6004953.14987 2116100.2629400003 37.7906877916676 -122.426744576702 (37.7906877916676, -122.426744576702)
148 175046 3 2 80X Junipero Serra Blvd 3 1 1 2     4 Width 3ft   5991566.54873 2087591.2585200001 37.7116435395983 -122.47098334961399 (37.7116435395983, -122.470983349614)
173 175044 3 2 80x Junipero Serra Blvd 1 1 1 2     19 Width 3ft   5991568.948890001 2087568.2224599998 37.7115804269636 -122.470973377029 (37.7115804269636, -122.470973377029)
175 17881 3 41 2205 Pine St 1 1 1 2     12 3X3   6003346.6048 2115178.7939 37.7880667103656 -122.432237297056 (37.7880667103656, -122.432237297056)
178 2985 3 15 2253 California St 1 1 1 2     65 3X3   6003588.0004 2115559.2302 37.789124975971106 -122.431429279776 (37.7891249759711, -122.431429279776)
181 9914 3 32 1900 Gough St 1 1 1 2     126 3X3   6005235.69262 2116267.9294 37.7911641319684 -122.42577893234899 (37.7911641319684, -122.425778932349)
185 251243 2 58 299x Chapman St 1 1 1 2       3x3   6008953.0 2098186.0 37.7417246968109 -122.411638974942 (37.7417246968109, -122.411638974942)
186 138359 3 59 2060 SUTTER ST 1 1 1 2     15 Width 0ft   6002861.592 2114464.6761 37.7860784126894 -122.43386429175101 (37.7860784126894, -122.433864291751)
187 251248 3 60 829 Chenery St 1 1 1 2       3x3   6001839.0 2095802.0 37.7347771581377 -122.436066227259 (37.7347771581377, -122.436066227259)
188 138368 3 59 2060 SUTTER ST 10 1 1 2     13 Width 0ft   6002679.2262 2114443.3671 37.786009553218996 -122.434493703661 (37.786009553219, -122.434493703661)
189 138807 3 46 2355 PINE ST 3 1 1 2     13 Width 0ft   6002661.6347 2115086.2451 37.7877737339769 -122.434600550462 (37.7877737339769, -122.434600550462)
192 138369 3 59 2060 SUTTER ST 11 1 1 2     16 Width 0ft   6002665.8461 2114439.4026 37.78599790817471 -122.434539711553 (37.7859979081747, -122.434539711553)
195 138365 3 59 2060 SUTTER ST 7 1 1 2     19 Width 0ft   6002748.6045 2114451.296 37.78603526200121 -122.43425424087799 (37.7860352620012, -122.434254240878)
196 251246 3 2 722X Mendell St 2 1 1 2       3X3   6016169.292972799 2097000.9113916 37.738872842648796 -122.38660458641 (37.7388728426488, -122.38660458641)
199 138362 3 59 2060 SUTTER ST 4 1 1 2     15 Width 0ft   6002806.585 2114457.2427 37.78605488083279 -122.434054069465 (37.7860548808328, -122.434054069465)
201 138367 3 59 2060 SUTTER ST 9 1 1 2     15 Width 0ft   6002691.6152 2114444.3582 37.7860129777854 -122.434450912019 (37.7860129777854, -122.434450912019)
202 138810 3 22 2355 PINE ST 6 1 1 2     11 Width 0ft   6002718.089 2115091.954 37.787792613821004 -122.434405637805 (37.787792613821, -122.434405637805)
207 138805 3 46 2355 PINE ST 1 1 1 2     11 Width 0ft   6002622.3069 2115079.2676 37.787752342886 -122.434736117903 (37.787752342886, -122.434736117903)
211 138370 3 59 2060 SUTTER ST 12 1 1 2     16 Width 0ft   6002647.5104 2114436.9248 37.7859900638921 -122.434602970779 (37.7859900638921, -122.434602970779)
212 138800 3 22 2375 PINE ST 1 1 1 2     7 Width 0ft   6002511.9355 2115060.8724 37.7876955676952 -122.435116665287 (37.7876955676952, -122.435116665287)
215 17196 3 21 2235X Octavia St 5 11 1 2     24 20   6004629.787409999 2116932.39582 37.792954330542 -122.42792271466601 (37.792954330542, -122.427922714666)
216 138364 3 59 2060 SUTTER ST 6 1 1 2     18 Width 0ft   6002783.7892 2114453.2783 37.7860427018539 -122.43413265320801 (37.7860427018539, -122.434132653208)
217 138366 3 59 2060 SUTTER ST 8 1 1 2     18 Width 0ft   6002708.9598 2114445.3493 37.7860166836287 -122.43439097535801 (37.7860166836287, -122.434390975358)
218 11423 3 2 722X Mendell St 1 1 1 2     0 3X3   6016169.292972799 2097000.9113916 37.738872842648796 -122.38660458641 (37.7388728426488, -122.38660458641)
219 138804 3 46 2375 PINE ST 5 1 1 2     1 Width 0ft   6002587.4194 2115073.5588 37.787734687268795 -122.43485641346001 (37.7877346872688, -122.43485641346)
220 138363 3 59 2060 SUTTER ST 5 1 1 2     16 Width 0ft   6002798.656 2114455.2605 37.7860489882217 -122.434081359893 (37.7860489882217, -122.434081359893)
221 138361 3 59 2060 SUTTER ST 3 1 1 2     16 Width 0ft   6002830.8674 2114461.7028 37.78606850519029 -122.433970377911 (37.7860685051903, -122.433970377911)
222 251247 3 2 722X Mendell St 3 1 1 2       3X3   6016169.292972799 2097000.9113916 37.738872842648796 -122.38660458641 (37.7388728426488, -122.38660458641)
223 23789 3 62 1100X Webster St 4 11 1 2     20 20   6003791.7059 2112684.1999 37.7812424081927 -122.43051925893299 (37.7812424081927, -122.430519258933)
227 13622 3 15 562 Market St 1 1 1 2     18 4x4   6012358.746590001 2115584.5782 37.789687756343604 -122.401085198325 (37.7896877563436, -122.401085198325)
228 246283 3 59 2125 Mission St 2 1 1 2     17 Width 0ft   6006872.377 2105970.5198 37.7629822769131 -122.419385210964 (37.7629822769131, -122.419385210964)
230 138371 3 59 2060 SUTTER ST 13 1 1 2     17 Width 0ft   6002611.3346 2114434.4469999997 37.785981206770394 -122.434727951803 (37.7859812067704, -122.434727951803)
231 138360 3 59 2060 SUTTER ST 2 1 1 2     14 Width 0ft   6002847.7164 2114462.1983 37.7860708218731 -122.433912120385 (37.7860708218731, -122.433912120385)
238 251251 3 63 321X Corbett Ave 2 7 1 2       10x10   5999565.0 2105069.0 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425)
239 251252 3 63 321X Corbett Ave 3 7 1 2       10x10   5999565.0 2105069.0 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425)
242 194017 3 2 717 Mendell St 3 1 1 2     22 Width 4ft   6016141.23024 2096883.95841 37.7385501598741 -122.386693461838 (37.7385501598741, -122.386693461838)
243 2928 3 15 1834 California St 1 1 1 2     25 3X3   6005568.20527 2115901.70542 37.7901773571486 -122.42460238530501 (37.7901773571486, -122.424602385305)
244 9908 3 2 1809 Gough St 2 1 1 2     14 6x6   6005225.98494 2115998.17525 37.79042290624211 -122.425793311632 (37.7904229062421, -122.425793311632)
246 251253 3 21 1350 Howard St 3 1 1 2       3x3   6008544.9526 2110145.4696299997 37.774539777213995 -122.413895673958 (37.774539777214, -122.413895673958)
247 251250 3 63 321X Corbett Ave 1 7 1 2       10x10   5999565.0 2105069.0 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425)
248 23733 3 15 800X Webster St 8 11 1 2     35 20   6003923.026000001 2111743.9893 37.7786682616238 -122.429997867276 (37.7786682616238, -122.429997867276)
255 19810 3 24 100 STAIRWAY24 1 1 1 2     12 100ST            
269 127441 3 32 2101 Van Ness Ave 4 1 1 2     15 Width 4ft   6005937.76794 2117668.55868 37.795049557533105 -122.423449386982 (37.7950495575331, -122.423449386982)
273 20166 3 59 1155X Steiner St 7 1 1 2     20 4X4   6002621.0 2112212.0 37.7798794773869 -122.43453554599199 (37.7798794773869, -122.434535545992)
275 818 3 2 1385 45th Ave 1 1 1 2     35 4x4   5982124.8821 2105687.3873 37.7607799675436 -122.504955867812 (37.7607799675436, -122.504955867812)
278 9598 3 22 1350 Golden Gate Ave 1 1 1 2     12 3X3   6003113.217999999 2112071.7207 37.7795222347306 -122.43282272296999 (37.7795222347306, -122.43282272297)
281 9686 3 11 300X Gough St 4 1 1 2     2 3x3   6005996.09112 2110833.49174 37.7762854431535 -122.42276159987499 (37.7762854431535, -122.422761599875)
286 10157 3 55 995 Guerrero St 1 1 1 2     12 3x3   6005745.7610599995 2103227.37374 37.755386722241504 -122.42308680461201 (37.7553867222415, -122.423086804612)
288 226558 3 32 320 Dolores St 3 1 1 2     22 Width 7ft   6004836.50691 2106380.98977 37.7639944545966 -122.42645581878 (37.7639944545966, -122.42645581878)
291 129605 3 55 2101 Van Ness Ave 1 1 1 2     10 Width 4ft   6005928.19437 2117729.67294 37.79521682154579 -122.42348685993299 (37.7952168215458, -122.423486859933)
296 18021 3 59 2725 Pine St 1 1 1 2     12 3X3   6000769.3896 2114817.5231 37.78692829139071 -122.44112805661501 (37.7869282913907, -122.441128056615)
315 127442 3 32 2101 Van Ness Ave 5 1 1 2     19 Width 4ft   6005941.14617 2117647.79475 37.794992735681504 -122.423436220932 (37.7949927356815, -122.423436220932)
319 3139 3 15 3320 California St 1 1 1 2     16 3X3   5998401.91704 2114901.9804700003 37.7870250535005 -122.449325021743 (37.7870250535005, -122.449325021743)
323 27392 3 55 2240 Hyde St 3 1 1 2     45 3X3   6007139.14869 2120046.64789 37.801646927424706 -122.419461214785 (37.8016469274247, -122.419461214785)
324 244302 3 9 350 Octavia St 5 1 1 2     4 Width 0ft   6005598.2085 2110574.7953 37.775552668496104 -122.424119585265 (37.7755526684961, -122.424119585265)
325 21670 3 59 1776 Sutter St 3 1 1 2     22 4X4   6004121.8146 2114641.2436 37.786634655728605 -122.429516856277 (37.7866346557286, -122.429516856277)
329 5267 3 26 1245 Divisadero St 3 1 1 2     6 3X4   6001292.1098 2112753.8798 37.7812918154006 -122.43917160516001 (37.7812918154006, -122.43917160516)
331 244290 3 9 201 Octavia St 2 1 1 2     4 Width 0ft   6005571.2897 2110005.1565 37.7739870584615 -122.424172183065 (37.7739870584615, -122.424172183065)
332 244303 3 9 350 Octavia St 6 1 1 2     3 Width 0ft   6005595.8477 2110592.7369 37.775601798483 -122.42412902808998 (37.775601798483, -122.42412902809)
335 244346 3 9 300 Octavia St 1 1 1 2     4 Width 0ft   6005627.7176 2110356.4274 37.77495474924589 -122.42400197393101 (37.7749547492459, -122.424001973931)
336 244304 3 9 350 Octavia St 7 1 1 2     4 Width 0ft   6005592.0705 2110609.2621 37.775646959405705 -122.42414326985501 (37.7756469594057, -122.424143269855)
337 14819 3 26 1234 McAllister St 5 1 1 2     12 4X4   6003219.5071 2111735.2352 37.7786043572111 -122.432430984172 (37.7786043572111, -122.432430984172)
338 244347 3 9 300 Octavia St 2 1 1 2     4 Width 0ft   6005625.3569 2110371.5361 37.774996100795995 -122.424011214757 (37.774996100796, -122.424011214757)
340 191854 3 39 573 10th St 1 9 1 2     24 Width 6ft tree is in ROW therefore DPW maintained 6009977.72395 2108375.30106 37.7697596664942 -122.408814503513 (37.7697596664942, -122.408814503513)
341 14553 3 5 875 Masonic Ave 1 1 1 2     60 3X3   5999239.2853 2109883.9856 37.7732947980524 -122.446066856713 (37.7732947980524, -122.446066856713)
342 21738 3 59 2045 Sutter St 2 1 1 2     12 4X4   6002837.9936 2114410.7158 37.7859289122324 -122.43394207733601 (37.7859289122324, -122.433942077336)
343 244298 3 35 350 Octavia St 1 1 1 2     6 Width 0ft   6005605.7628 2110511.5277 37.7753793775331 -122.42408895277501 (37.7753793775331, -122.424088952775)
344 251279 3 76 1200x Hudson Ave 8 1 1 2 3     3x3   6017356.0 2095183.0 37.733946845802 -122.38237501907301 (37.733946845802, -122.382375019073)
345 13664 3 15 648 Market St 1 1 1 2     35 4x4   6011893.33766 2115132.41268 37.788420242855395 -122.402663664993 (37.7884202428554, -122.402663664993)
346 235602 3 15 721 Valencia St 2 1 1 2     7 Width 3ft   6006265.751680001 2105377.56697 37.761319982338904 -122.421441210755 (37.7613199823389, -122.421441210755)
348 229175 3 11 795 Valencia St 1 1 1 2     6 Width 3ft   6006285.87907 2104987.97511 37.7602513890079 -122.421343931093 (37.7602513890079, -122.421343931093)
352 14742 3 25 900 McAllister St 2 1 1 2     12 4X4   6004772.182 2111961.3352 37.779313094037704 -122.427075791541 (37.7793130940377, -122.427075791541)
353 13824 3 15 964 Market St 1 1 1 2     40 4x4   6009889.5706 2113199.7435 37.7830015179357 -122.40945995866699 (37.7830015179357, -122.409459958667)
360 6307 3 79 1804 Ellis St 2 1 1 2     6 4x4   6002139.3488 2112974.3616 37.781945376326 -122.436256362281 (37.781945376326, -122.436256362281)
367 235603 3 15 715 Valencia St 1 1 1 2     7 Width 3ft   6006265.7166 2105404.69213 37.7613944596986 -122.42144325851002 (37.7613944596986, -122.42144325851)
370 3092 3 15 2980 California St 1 1 1 2     12 3X3   6000114.4381800005 2115142.33295 37.7877828069853 -122.443417371621 (37.7877828069853, -122.443417371621)
376 229176 3 11 793 Valencia St 1 1 1 2     2 Width 3ft   6006285.11873 2105008.6290700003 37.7603080570896 -122.42134802750601 (37.7603080570896, -122.421348027506)
378 138112 3 59 1698 Sutter St 1 1 1 2     17 Width 0ft   6004508.5013 2114699.1479 37.7868155327596 -122.428183141793 (37.7868155327596, -122.428183141793)
388 11057 3 32 1630 Hyde St 1 1 1 2     70 3X3   6007426.31744 2117960.00612 37.795933702633796 -122.418319444503 (37.7959337026338, -122.418319444503)
Powered by Datasette · Query took 35.211ms · Data source: data.sfgov.org