sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
10 122670 1 8 301x Hickory St 3 1 1 1   11/10/2016 12:00:00 AM 3 3X3            
25 23567 3 15 2975 Van Ness Ave 1 1 1 2   05/27/1992 12:00:00 AM 3 3X3   6005531.337230001 2120589.48411 37.803046726686894 -122.42506362870199 (37.8030467266869, -122.425063628702)
33 2889 1 15 1545 California St 1 1 1 1     65 3X3   6006951.47041 2116025.01423 37.79059395549061 -122.419825138035 (37.7905939554906, -122.419825138035)
39 3558 1 11 101 Cargo Way 4 1 1 1   03/21/2017 05:52:00 PM 6 3X3   6018773.865780001 2097541.9761 37.7405023461002 -122.377636624239 (37.7405023461002, -122.377636624239)
45 27522 1 2 3201 California St 2 1 1 1     8 3X3   5998967.7443 2114917.3257 37.787099536792 -122.44736849888001 (37.787099536792, -122.44736849888)
46 18228 3 22 1737-1795 Post St 2 1 1 2   04/09/2004 12:00:00 AM 12 3X3   6003682.1522 2114179.2812 37.785341320174396 -122.431004998109 (37.7853413201744, -122.431004998109)
48 3528 3 11 201X Cargo Way 38 1 1 2   03/21/2017 04:23:00 PM 3 3X3   6018298.55272 2097894.94115 37.7414453176516 -122.37930460042801 (37.7414453176516, -122.379304600428)
58 4749 1 5 1255 Columbus Ave 1 1 1 1   08/03/2015 12:00:00 AM 8 3X3   6007516.58505 2121541.63395 37.805773032263296 -122.41826116482599 (37.8057730322633, -122.418261164826)
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)
78 251199 6 3 900X 14th St 4 7 1 1       3X3   6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
87 11032 1 32 1500 Hyde St 1 1 1 1     70 3X3   6007492.86428 2117507.22815 37.794694232707 -122.41805706457599 (37.794694232707, -122.418057064576)
99 7992 1 9 2247 Franklin St 1 1 1 1   02/01/2007 12:00:00 AM 3 3X3   6005467.69382 2117725.44397 37.7951792074025 -122.42507996488001 (37.7951792074025, -122.42507996488)
105 6251 3 5 1315 Ellis St 1 1 1 2   12/06/2003 12:00:00 AM 24 3X3   6004480.8051 2113256.6545 37.7828532389184 -122.428176124144 (37.7828532389184, -122.428176124144)
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)
111 7749 1 15 400X Franklin St 6 1 1 1     7 3X3   6006371.15759 2111615.2483900003 37.7784531123456 -122.421519673008 (37.7784531123456, -122.421519673008)
112 9896 3 11 1800X Pine St 2 1 1 2   02/20/2007 12:00:00 AM 3 3X3   6004999.6173 2115457.4476 37.7889254092316 -122.426538009917 (37.7889254092316, -122.426538009917)
115 6964 1 26 700 Fell St 2 1 1 1     8 3X3   6003997.6735 2110460.7643 37.7751490695403 -122.42964808764499 (37.7751490695403, -122.429648087645)
116 26163 1 32 220 Richardson Ave 6 1 1 1     12 3X3   5999083.87135 2119853.9919 37.8006609458028 -122.447322173097 (37.8006609458028, -122.447322173097)
119 251215 3 43 175X Otis St 11 1 1 2       3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.42011195674299 (37.7705111956623, -122.420111956743)
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)
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)
141 832 3 48 1396 47th Ave 1 1 1 2   03/28/2017 12:18:00 PM 3 3X3   5981551.7086 2105613.8347 37.7605442750604 -122.50693272862101 (37.7605442750604, -122.506932728621)
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)
144 11598 1 48 4134 Judah St 1 1 1 1   03/28/2017 11:51:00 AM 3 3X3   5981663.7126 2105589.2786 37.760483446414796 -122.506543543521 (37.7604834464148, -122.506543543521)
149 26071 3 50 247 Orizaba Ave 1 1 1 2   03/28/2017 01:41:00 PM 3 3X3   5993990.1569314 2088190.8403771 37.7134297247264 -122.46265023824101 (37.7134297247264, -122.462650238241)
150 11606 3 48 4200x Judah St 1 1 1 2   03/28/2017 11:54:00 AM 3 3X3   5981492.2847 2105581.1189 37.76045094714279 -122.507135818078 (37.7604509471428, -122.507135818078)
152 24532 3 48 1395 47th Ave 1 1 1 2   03/28/2017 12:21:00 PM 3 3X3   5981507.2257 2105680.0147 37.7607233666377 -122.50709148147499 (37.7607233666377, -122.507091481475)
153 5972 3 26 1550 Eddy St 1 1 1 2   02/02/1990 12:00:00 AM 8 3X3   6003044.0843 2112751.363 37.7813844410266 -122.43311045884899 (37.7813844410266, -122.433110458849)
157 3193 1 15 3698 California St 4 1 1 1     16 3X3   5996969.37189 2114704.2549799997 37.7864001056199 -122.454266992435 (37.7864001056199, -122.454266992435)
165 11582 3 48 4000 Judah St 1 1 1 2   03/28/2017 11:49:00 AM 3 3X3   5982109.291 2105604.0369 37.760550193841404 -122.505003612665 (37.7605501938414, -122.505003612665)
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)
176 24515 3 11 2030 Fell St 1 1 1 2   04/07/2016 07:40:00 AM 3 3X3   5997710.2902 2109583.0289 37.772381016672895 -122.45133412385 (37.7723810166729, -122.45133412385)
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)
180 18700 1 15 100X Richardson Ave 2 1 1 1     18 3X3   5999457.6873699995 2119517.78462 37.799759164102895 -122.44600442526199 (37.7997591641029, -122.446004425262)
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)
193 6069 1 2 1930 Eddy St 3 1 1 1   05/26/2015 12:00:00 AM 3 3X3   6001175.3543 2112495.6639 37.7805761758993 -122.439557004629 (37.7805761758993, -122.439557004629)
196 251246 3 2 722X Mendell St 2 1 1 2       3X3   6016169.292972799 2097000.9113916 37.738872842648796 -122.38660458641 (37.7388728426488, -122.38660458641)
206 4750 1 32 1201 Columbus Ave 1 1 1 1     50 3X3   6007660.31382 2121409.3470799997 37.8054178953714 -122.417754386066 (37.8054178953714, -122.417754386066)
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)
222 251247 3 2 722X Mendell St 3 1 1 2       3X3   6016169.292972799 2097000.9113916 37.738872842648796 -122.38660458641 (37.7388728426488, -122.38660458641)
234 26932 3 26 1570 Golden Gate Ave 1 1 1 2   04/05/2000 12:00:00 AM 3 3X3   6002097.1307 2111930.5841 37.7790770280177 -122.43632769328998 (37.7790770280177, -122.43632769329)
236 8118 1 6 841 Fulton St 1 1 1 1   12/15/2005 12:00:00 AM 3 3X3   6003718.373 2111409.0283 37.777736949412606 -122.430681932079 (37.7777369494126, -122.430681932079)
237 2654 3 22 1988 Bush St 1 1 1 2   01/30/2005 12:00:00 AM 12 3X3   6004003.2237 2114978.8425 37.7875549020514 -122.429951242636 (37.7875549020514, -122.429951242636)
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)
264 20199 3 26 1300X Steiner St 7 1 1 2   01/02/1991 12:00:00 AM 12 3X3   6002784.1975 2112923.5771 37.7818425521761 -122.434021853774 (37.7818425521761, -122.434021853774)
270 28098 1 16 639 Divisadero St 1 1 1 1   11/28/2006 12:00:00 AM 3 3X3   6001577.9698 2110674.4978 37.7755986195101 -122.438033679217 (37.7755986195101, -122.438033679217)
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)
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)
317 7957 3 11 1800 Franklin St 1 1 1 2   06/22/2016 03:18:00 PM 3 3X3   6005720.43568 2116275.48789 37.791212266380896 -122.424102272302 (37.7912122663809, -122.424102272302)
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)
322 7968 1 26 1901 Franklin St 3 1 1 1   10/03/2007 12:00:00 AM 3 3X3   6005627.24821 2116610.0246200003 37.7921255585096 -122.42444850412 (37.7921255585096, -122.42444850412)
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)
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)
359 22941 3 11 413 Valencia St 1 1 1 2   04/05/2017 12:00:00 AM 6 3X3   6006166.67617 2107189.14794 37.766288570288204 -122.421912561635 (37.7662885702882, -122.421912561635)
366 22992 3 11 670 Valencia St 2 1 1 2   04/05/2017 12:00:00 AM 18 3X3   6006180.5496 2105697.57647 37.7621938490894 -122.42175862016501 (37.7621938490894, -122.421758620165)
368 18096 3 35 3008 Pine St 1 1 1 2   01/29/1997 12:00:00 AM 6 3X3   5999424.6928 2114682.6521 37.786481285230295 -122.44577068023099 (37.7864812852303, -122.445770680231)
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)
381 122664 1 11 401x Laguna St 2 1 1 1   11/10/2016 12:00:00 AM 3 3X3            
386 2602 1 26 1760 Bush St 1 1 1 1     6 3X3   6005112.3923 2115130.7833 37.7880348455319 -122.42612455857201 (37.7880348455319, -122.426124558572)
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)
399 17856 3 41 2121 Pine St 1 1 1 2   04/21/2000 12:00:00 AM 10 3X3   6003596.6138 2115206.3541 37.7881565558045 -122.431374278321 (37.7881565558045, -122.431374278321)
424 122666 1 11 401x Laguna St 4 1 1 1   11/10/2016 12:00:00 AM 3 3X3            
436 6932 3 32 500 Fell St 1 1 1 2     12 3X3   6004980.8762 2110598.20876 37.775582081585895 -122.42625675563801 (37.7755820815859, -122.426256755638)
442 9602 1 26 1355 Golden Gate Ave 4 1 1 1     11 3X3   6003083.4108 2112017.0963 37.779370559175206 -122.432921935155 (37.7793705591752, -122.432921935155)
447 27524 3 2 3201 California St 4 1 1 2     9 3X3   5999021.2149 2114925.4479 37.787124893549795 -122.447184087894 (37.7871248935498, -122.447184087894)
456 23112 3 11 1448 Valencia St 1 1 1 2   03/26/1992 12:00:00 AM 20 3X3 Permit Number 779902 6006436.396269999 2101132.22455 37.74967287242389 -122.42054965793899 (37.7496728724239, -122.420549657939)
466 1665 3 79 1400X Fell St 6 1 1 2   05/06/1992 12:00:00 AM 18 3X3   6000409.8977 2109962.9335 37.7735783473195 -122.44202322778901 (37.7735783473195, -122.442023227789)
475 6052 3 2 1900 Eddy St 2 1 1 2   11/18/2003 12:00:00 AM 3 3X3   6001270.4508 2112511.2313 37.7806243318768 -122.439229137442 (37.7806243318768, -122.439229137442)
488 2821 1 15 1100X California St 7 1 1 1     45 3X3   6008831.67633 2116355.92064 37.7916082855564 -122.41334312239701 (37.7916082855564, -122.413343122397)
508 6667 3 21 1550 Evans Ave 15 1 1 2   04/10/2017 01:21:00 PM 3 3X3   6015906.32098 2098408.37334 37.7427228837554 -122.387611997891 (37.7427228837554, -122.387611997891)
524 4705 1 11 940 Columbus Ave 2 1 1 1   04/10/2017 09:01:00 PM 3 3X3   6008689.9314 2120561.6575 37.8031482394038 -122.414131236147 (37.8031482394038, -122.414131236147)
526 18856 3 60 2201 Sacramento St 1 1 1 2     12 3X3   6004191.661859999 2115995.22985 37.790356315029996 -122.429371791378 (37.79035631503, -122.429371791378)
531 27691 1 93 1765 Turk St 1 1 1 1   08/25/2015 12:00:00 AM 7 3X3   6001581.2067 2112155.8038 37.779666096456 -122.438128618136 (37.779666096456, -122.438128618136)
534 2998 1 15 2314 California St 1 1 1 1     45 3X3   6003265.59996 2115577.92692 37.7891580349704 -122.43254607984501 (37.7891580349704, -122.432546079845)
546 12251 3 37 512 Laguna St 2 1 1 2   12/24/2014 12:00:00 AM 3 3X3   6005037.9059 2110678.2828 37.77580516874 -122.426065177531 (37.77580516874, -122.426065177531)
548 18094 1 22 3001 Pine St 2 1 1 1     6 3X3   5999514.29 2114642.3727 37.786375803755895 -122.445457799993 (37.7863758037559, -122.445457799993)
550 3006 1 15 2380 California St 1 1 1 1     75 3X3   6002989.49365 2115542.57517 37.7890453067372 -122.433498845012 (37.7890453067372, -122.433498845012)
551 1664 3 62 1400X Fell St 5 1 1 2     18 3X3   6000454.8566 2109968.1462 37.7735952220186 -122.441868082855 (37.7735952220186, -122.441868082855)
562 15241 3 32 1370 Mission St 1 1 1 2     18 3X3 Permit Number 49662 6008042.0 2110573.0 37.7756854149614 -122.415665767345 (37.7756854149614, -122.415665767345)
577 15499 1 26 2704 Mission St 3 1 1 1     12 3X3   6006991.0 2102555.0 37.7536107294676 -122.41873270043001 (37.7536107294676, -122.41873270043)
579 2702 1 2 2121 Bush St 2 1 1 1     12 3X3   6003192.7078 2114808.0993 37.7870401500361 -122.432743262211 (37.7870401500361, -122.432743262211)
582 27390 3 55 2240 Hyde St 2 1 1 2     45 3X3   6007140.50399 2120032.48345 37.8016081117892 -122.419455519354 (37.8016081117892, -122.419455519354)
589 26916 1 15 1901 Geary Blvd 10 1 1 3     18 3X3   6002555.1851 2113680.9302 37.783909052953 -122.43486830704398 (37.783909052953, -122.434868307044)
602 15498 1 75 2704 Mission St 2 1 1 1     12 3X3   6007015.1629 2102569.9783 37.7536532168709 -122.41865020170799 (37.7536532168709, -122.418650201708)
612 23503 1 15 2550 Van Ness Ave 4 1 1 1     12 3X3   6005820.29029 2119236.56275 37.7993482683535 -122.42396743424999 (37.7993482683535, -122.42396743425)
614 2880 3 15 1477 California St 1 1 1 2     45 3X3   6007321.86349 2116079.14078 37.7907634327304 -122.41854743611 (37.7907634327304, -122.41854743611)
615 2703 1 26 2123 Bush St 1 1 1 1   02/06/1987 12:00:00 AM 12 3X3   6003147.2203 2114799.0941 37.7870128441602 -122.432899995096 (37.7870128441602, -122.432899995096)
616 8142 3 26 924 Fulton St 2 1 1 2     35 3X3   6003320.2078 2111406.4501 37.777707304798206 -122.432059137251 (37.7777073047982, -122.432059137251)
641 5315 1 44 1820 Divisadero St 1 1 1 1   03/22/1990 12:00:00 AM 3 3X3   6001085.4403 2114655.5077 37.7865014360219 -122.440022974412 (37.7865014360219, -122.440022974412)
657 5214 3 9 835 Divisadero St 1 1 1 1 4 12/09/2001 12:00:00 AM 3 3X3   6001489.0793 2111327.2763 37.7773859294292 -122.438387950593 (37.7773859294292, -122.438387950593)
672 23002 1 81 742 Valencia St 1 1 1 2   02/23/1994 12:00:00 AM 20 3X3   6006210.140269999 2105247.24413 37.7609590106658 -122.421624291141 (37.7609590106658, -122.421624291141)
684 24323 1 103 600X Golden Gate Ave 10 1 1 1     12 3X3   6006332.380890001 2112512.31586 37.7809140549901 -122.42171754994101 (37.7809140549901, -122.421717549941)
687 13252 1 79 2395 Lombard St 3 1 1 1     14 3X3   6001005.1632 2119265.163 37.7991537757264 -122.440631471061 (37.7991537757264, -122.440631471061)
696 5946 3 10 1415 Eddy St 3 1 1 2     12 3X3   6003699.8521 2112803.046 37.7815635260957 -122.43084551167601 (37.7815635260957, -122.430845511676)
704 2199 3 2 1100 Broderick St 5 1 1 2     12 3X3   6000885.4114 2112518.5919999997 37.7806226245627 -122.440561697516 (37.7806226245627, -122.440561697516)
706 2833 1 2 1200 California St 5 1 1 1     6 3X3   6008452.59238 2116301.4374700002 37.7914373972624 -122.41465089583099 (37.7914373972624, -122.414650895831)
732 25708 3 15 586 06th St 1 1 1 2     11 3X3   6012145.80041 2110254.86265 37.77504171494321 -122.40144725460199 (37.7750417149432, -122.401447254602)
735 24812 3 9 2425 Fillmore St 1 1 1 2   07/12/1996 12:00:00 AM 5 3X3   6002709.02465 2116620.06864 37.7919879109555 -122.434546304291 (37.7919879109555, -122.434546304291)
741 9506 1 22 935 Golden Gate Ave 3 1 1 1   01/10/2002 12:00:00 AM 3 3X3   6005056.2117 2112292.3227 37.7802379614696 -122.426116783326 (37.7802379614696, -122.426116783326)
753 48 3 22 810 14th St 3 1 1 2     4 3X3   6003376.13457 2107738.85817 37.767640169485105 -122.43160376032499 (37.7676401694851, -122.431603760325)
Powered by Datasette · Query took 2.088ms · Data source: data.sfgov.org