sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
31 22614 1 5 1001 Turk St 5 1 1 3     24 3x5   6005426.7391 2112695.1691 37.781365013820206 -122.424863625752 (37.7813650138202, -122.424863625752)
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)
74 188665 3 5 2175X Palou Ave 1 1 1 2     37     6011669.71313 2097723.45025 37.740606653987705 -122.402212916691 (37.7406066539877, -122.402212916691)
85 22613 1 5 1001 Turk St 4 1 1 3     24 3x5   6005358.7073 2112686.5825 37.7813375942673 -122.42509837168001 (37.7813375942673, -122.42509837168)
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)
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)
613 20019 3 5 100 STAIRWAY48 3 1 1 2     6 10ST            
670 13108 1 5 1557 Lombard St 1 1 1 1     60 3x3   6004929.5061 2119810.12 37.80087277869679 -122.427090735634 (37.8008727786968, -122.427090735634)
769 110848 2 5 2668 Vallejo St 2 1 1 1     3 3x3 Permit Number 778643 6000804.34505 2117582.1485 37.7945212238167 -122.441205550194 (37.7945212238167, -122.441205550194)
854 203901 3 5 3794 19th Ave 3 2 1 2     12 Width 3ft   5990470.121669999 2090714.3108400002 37.720155198286 -122.475000685058 (37.720155198286, -122.475000685058)
940 51496 1 5 1350 REVISED Fell St 1 1 1 1   03/16/2005 12:00:00 AM     Permit Number 47808 6000958.86990754 2110035.78536621 37.773809648853 -122.44012948036101 (37.773809648853, -122.440129480361)
1022 186874 3 5 2700 Sunset Blvd 23 3 1 2     13 Width 0ft   5985204.8462 2096382.2812 37.7354114037883 -122.493618136413 (37.7354114037883, -122.493618136413)
1059 186952 3 5 2800 Sunset Blvd 26 3 1 2     3 Width 0ft   5985204.8226 2096075.4539 37.734568936321295 -122.493595616872 (37.7345689363213, -122.493595616872)
1084 8287 3 5 1601 Galvez Ave 3 1 1 2   05/01/2017 12:00:00 AM 6 3x3   6015799.31492 2097666.33838 37.7406794801837 -122.387930230222 (37.7406794801837, -122.387930230222)
1109 20024 3 5 100 STAIRWAY48 8 1 1 2     12 10ST            
1171 172952 3 5 3000X Van Ness Ave 1 1 1 2 6   0 Width 3ft   6005556.34576 2120733.12845 37.8034425497953 -122.42498731221201 (37.8034425497953, -122.424987312212)
1175 2161 3 5 700X Mansell St 3 1 1 2     12 3x100   6009743.36579 2090187.72527 37.71980743673429 -122.408342124702 (37.7198074367343, -122.408342124702)
1261 122608 2 5 1214 29th Ave 2 1 1 1     12 3x3   5987092.2626 2106978.1702 37.7646150951119 -122.487870979055 (37.7646150951119, -122.487870979055)
1297 245226 3 5 451 Fell St 1 1 1 2     25 Width 0ft   6005125.512 2110566.2977 37.7755026358833 -122.42575415301701 (37.7755026358833, -122.425754153017)
1309 9930 3 5 2336 Gough St 1 1 1 2     17 3X3   6005037.50257 2117672.2143200003 37.7950087418189 -122.42656470240699 (37.7950087418189, -122.426564702407)
1376 141859 3 5 1126 TURK ST 1 1 1 2     17 Width 0ft   6004579.5781 2112622.703 37.7811181533984 -122.42778922577801 (37.7811181533984, -122.427789225778)
1399 116632 2 5 2332 Anza St 1 1 1 1   05/15/2017 12:00:00 AM 17 3x3 Permit Number 779740 5991403.36215 2112037.8136299998 37.7787580362874 -122.473329239514 (37.7787580362874, -122.473329239514)
1407 220312 3 5 4235 19th St 7 1 1 4   08/05/1995 12:00:00 AM 15 Width 3ft   6002007.42492 2104678.29116 37.759158924972404 -122.436118906483 (37.7591589249724, -122.436118906483)
1431 220311 3 5 4235 19th St 4 1 1 4   08/05/1995 12:00:00 AM 18 Width 3ft   6001938.02984 2104676.35813 37.7591496745354 -122.436358769151 (37.7591496745354, -122.436358769151)
1479 23464 3 5 2305 Van Ness Ave 1 1 1 2     30 3X3   6005842.187999999 2118344.10635 37.796899045714504 -122.423828167031 (37.7968990457145, -122.423828167031)
1500 251574 3 5 191 Portola Dr 1 9 1 2       3x3   5999731.0 2100707.0 37.748125134697 -122.443706547761 (37.748125134697, -122.443706547761)
1523 142666 2 5 2310 MASON ST 4 1 1 1     24 Width 0ft   6008911.1908 2121214.7045 37.8049537680909 -122.413411770849 (37.8049537680909, -122.413411770849)
1555 18077 3 5 2946 Pine St 1 1 1 2     16 3X3   5999820.6048 2114741.0687 37.7866642791044 -122.44440512772499 (37.7866642791044, -122.444405127725)
1635 251542 2 5 50 Vista Ln   1 1 1       3x3 Permit Number 780127 5999350.0 2102347.0 37.752606437592604 -122.445141915929 (37.7526064375926, -122.445141915929)
1647 20023 3 5 100 STAIRWAY48 7 1 1 2     12 10ST            
1682 120803 2 5 711 20th Ave 1 1 1 1   05/30/2017 12:00:00 AM 3 Width 2ft   5989721.4593400005 2110495.24706 37.774425041585296 -122.479034671677 (37.7744250415853, -122.479034671677)
1784 7098 3 5 2006 Fell St 1 1 1 2     24 3X3   5997799.556 2109595.5069 37.772420388962296 -122.451026246506 (37.7724203889623, -122.451026246506)
1814 105384 2 5 2853 Green St 2 1 1 1     18 4x3   5999429.08796 2117689.0147700002 37.794736216656794 -122.445971784396 (37.7947362166568, -122.445971784396)
1909 125218 1 5 2101 Washington St 21 1 1 3     13 Width 4ft   6005090.35688 2116771.11072 37.7925375271472 -122.42631763077499 (37.7925375271472, -122.426317630775)
1917 125217 1 5 2101 Washington St 20 1 1 1     29 Width 5ft Permit Number 768908 6005070.35193 2116772.06135 37.79253900653 -122.426386916319 (37.79253900653, -122.426386916319)
1983 124970 3 5 170 Richardson Ave 1 1 1 2     28 Width 4ft   5999252.18429 2119704.33945 37.8002596566144 -122.446728969472 (37.8002596566144, -122.446728969472)
2007 124969 3 5 150 Richardson Ave 2 1 1 2     18 Width 4ft   5999290.62404 2119668.8610400003 37.800164438189896 -122.44659339936199 (37.8001644381899, -122.446593399362)
2037 124755 2 5 2040 Broadway 1 1 1 1     14 Width 4ft Permit Number 779873 6003722.50351 2117641.05418 37.794848756005 -122.431112566798 (37.794848756005, -122.431112566798)
2081 252873 2 5 1501 Broderick St 7 7 1 1       3x3   6000422.0 2113928.0 37.7844660975886 -122.442266061376 (37.7844660975886, -122.442266061376)
2107 250672 2 5 726 El Camino Del Mar 1 1 1 1     24 Width 4ft   5986349.68151 2114864.86182 37.786226371002705 -122.491019750162 (37.7862263710027, -122.491019750162)
2110 140215 3 5 736 FELL ST 1 1 1 2     27 Width 0ft   6003875.2018 2110441.9467 37.7750904655336 -122.430070401808 (37.7750904655336, -122.430070401808)
2120 110253 2 5 1322 Baker St 1 1 1 1     19 3x3   6000252.5201 2113528.9926 37.783360865552396 -122.442823740221 (37.7833608655524, -122.442823740221)
2121 79286 2 5 1322 Baker St 2 1 1 1   09/08/2001 12:00:00 AM 15 3x3   6000254.8822 2113507.7337 37.7833026287552 -122.442814041263 (37.7833026287552, -122.442814041263)
2188 124801 2 5 2898 Union St 5 1 1 1     11 Width 4ft Permit Number 780062 5999229.08983 2118053.40815 37.7957253216105 -122.446690033314 (37.7957253216105, -122.446690033314)
2189 124797 2 5 2898 Union St 1 1 1 1   06/28/2017 12:00:00 AM 3 Width 3ft Permit Number 780062 5999308.846 2118065.45598 37.795762957336706 -122.446414930702 (37.7957629573367, -122.446414930702)
2194 23455 1 5 2240 Van Ness Ave 1 1 1 1     30 4X4   6005973.83981 2118127.35599 37.796311335142995 -122.423357203778 (37.796311335143, -122.423357203778)
2211 188595 2 5 1301 Rhode Island St 3 2 1 1   07/05/2017 12:00:00 AM 3 Width 7ft   6011997.611930001 2102271.8897 37.7531139870419 -122.401398733477 (37.7531139870419, -122.401398733477)
2230 112042 2 5 2418 Pacific Ave 2 1 1 1   01/14/2016 12:00:00 AM 17 3x3 Permit Number 776583 6002409.604230001 2117108.01013 37.79331067070571 -122.435617223266 (37.7933106707057, -122.435617223266)
2239 203945 2 5 2579 15th Ave 1 1 1 1     3 Width 3ft   5991715.80084 2097896.7211700003 37.7399484158804 -122.471217847832 (37.7399484158804, -122.471217847832)
2248 125016 2 5 3399X Steiner St 1 1 1 1     17 Width 3ft   6001832.0 2119600.0 37.800120199825 -122.437794333712 (37.800120199825, -122.437794333712)
2269 125219 3 5 2269 Sacramento St 2 1 1 2     24 Width 4ft   6003923.5815 2115960.33762 37.7902453288032 -122.430296840347 (37.7902453288032, -122.430296840347)
2354 18870 1 5 2269 Sacramento St 1 1 1 1     18 3X3   6003913.0 2115924.0 37.790144955549394 -122.430330857904 (37.7901449555494, -122.430330857904)
2379 17840 1 5 2017 Pine St 2 1 1 1     12 3X3   6004165.4355 2115291.4590000003 37.7884224532463 -122.429412324105 (37.7884224532463, -122.429412324105)
2394 125087 2 5 2498X Pierce St 3 1 1 1     16 Width 4ft Permit Number 779691 6001734.0 2116823.0 37.7924897105997 -122.437934432064 (37.7924897105997, -122.437934432064)
2440 125088 2 5 2498X Pierce St 4 1 1 1     17 Width 4ft Permit Number 779691 6001734.0 2116823.0 37.7924897105997 -122.437934432064 (37.7924897105997, -122.437934432064)
2463 106683 2 5 125 Maple St 3 1 1 1     6 6x300   5996555.44655 2115800.39633 37.789386070660704 -122.45577832652201 (37.7893860706607, -122.455778326522)
2529 141382 3 5 1294X Fell St 1 1 1 2     2 Width 0ft   6001285.0 2110102.0 37.7740100190711 -122.439006092772 (37.7740100190711, -122.439006092772)
2681 10334 3 5 850 Haight St 1 1 1 2     100 4X4   6002067.0 2109164.0 37.7714789673294 -122.436233885162 (37.7714789673294, -122.436233885162)
2746 181806 2 5 2099 Santiago St 1 1 1 1     20 Width 0ft   5986469.7425 2099569.8124 37.7442374331929 -122.489479287744 (37.7442374331929, -122.489479287744)
2777 253179 2 5 201x Drake St 1 1 1 1       3x3   6001862.0 2086566.0 37.709418484595 -122.43532626528601 (37.709418484595, -122.435326265286)
2778 246114 1 5 1418 Waller St 1 1 1 1   10/21/2003 12:00:00 AM 13 Width 0ft Permit Number 47096 5998969.2151 2108370.2652 37.769123080801 -122.44689211719 (37.769123080801, -122.44689211719)
2779 246118 1 5 1420 Waller St 1 1 1 1   06/29/1993 12:00:00 AM 6 Width 0ft Permit Number 31980 5998892.5994 2108357.8492 37.769084612317705 -122.44715623175301 (37.7690846123177, -122.447156231753)
2780 246115 1 5 1410 Waller St 2 1 1 1   10/21/2003 12:00:00 AM 13 Width 0ft Permit Number 47096 5998952.8623 2108365.1171 37.769108011186106 -122.446948309851 (37.7691080111861, -122.446948309851)
2794 7088 3 5 1864 Fell St 1 1 1 2     30 3X3   5998522.1287 2109694.9471 37.7727347674481 -122.448533971797 (37.7727347674481, -122.448533971797)
2828 7026 3 5 1138 Fell St 1 1 1 2     36 3x3   6001973.7961 2110177.6605 37.7742569308448 -122.436628850709 (37.7742569308448, -122.436628850709)
2844 17858 3 5 2121 Pine St 3 1 1 2     12 3X3   6003631.9915 2115212.7417 37.7881760994608 -122.43125233371799 (37.7881760994608, -122.431252333718)
2854 253253 6 5 99X Lopez Ave 4 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2895 114573 2 5 3621 Washington St 1 1 1 1     12 3x3   5997465.48926 2115720.33673 37.7892184334409 -122.452623918478 (37.7892184334409, -122.452623918478)
2971 7062 3 5 1550 Fell St 1 1 1 2     24 3X3   6000002.1366 2109905.8257 37.773398298516 -122.44342962722 (37.773398298516, -122.44342962722)
2994 142170 1 5 1477 GROVE ST 6 1 1 1     11 Width 0ft   6000804.7229 2110664.0211 37.7755258488103 -122.440707770392 (37.7755258488103, -122.440707770392)
3010 245175 3 5 1128 Haight St 1 1 1 2     24 Width 0ft   6000703.1785 2108961.6377 37.770845749220705 -122.44093688299 (37.7708457492207, -122.44093688299)
3196 9420 3 5 700X Golden Gate Ave 9 1 1 2     3 4X4   6005985.41292 2112474.4888400002 37.780790619431706 -122.422915195091 (37.7807906194317, -122.422915195091)
3360 124968 2 5 2822 Pierce St 2 1 1 1   09/05/2017 12:00:00 AM 3 Width 3ft   6001569.39846 2118152.80963 37.7961316595979 -122.438599283427 (37.7961316595979, -122.438599283427)
3374 26538 3 5 500 Francisco St 1 1 1 2     18 4X4   6008873.5963 2121134.1535 37.8047304843802 -122.413536170716 (37.8047304843802, -122.413536170716)
3385 23505 3 5 2600 Van Ness Ave 1 1 1 2     30 5x5   6005801.9507 2119345.52815 37.7996464242096 -122.424038648866 (37.7996464242096, -122.424038648866)
3503 14499 3 5 350 Masonic Ave 3 1 1 2     100 4x4   5999064.4701 2111602.7455 37.7780040877061 -122.44679526057199 (37.7780040877061, -122.446795260572)
3571 39975 1 5 0 Steiner St 1 1 1 1         Permit Number 41235          
3572 7105 3 5 2130 Fell St 1 1 1 2     24 4X4   5997237.8283 2109516.8856 37.7721723399981 -122.452963630149 (37.7721723399981, -122.452963630149)
3621 249566 1 5 1201 Franklin St 1 4 1 1     16 Width 4ft   6005942.163819999 2114329.62673 37.7858819315591 -122.42319672154899 (37.7858819315591, -122.423196721549)
3689 252876 2 5 1400 Baker St 1 7 1 1       3x3   6000422.0 2113928.0 37.7844660975886 -122.442266061376 (37.7844660975886, -122.442266061376)
3694 252874 2 5 2400 Post St 1 7 1 1       3x3   6000387.0 2114050.0 37.784799083264396 -122.44239591065 (37.7847990832644, -122.44239591065)
3756 252875 2 5 2400 Post St 2 7 1 1       3x3   6000387.0 2114050.0 37.784799083264396 -122.44239591065 (37.7847990832644, -122.44239591065)
3767 7104 3 5 2100 Fell St 1 1 1 2     24 3X3   5997303.9815 2109524.8914 37.7721981126985 -122.452735379757 (37.7721981126985, -122.452735379757)
3817 253560 2 5 535 Castenada Ave 5 1 1 1       Width 4ft   5992829.16774 2099990.2564 37.7457610706327 -122.46752052447701 (37.7457610706327, -122.467520524477)
3819 19829 3 5 100 STAIRWAY25 13 1 1 2     6 60X            
3851 252871 2 5 2557 Sutter St   7 1 1       3x3   5999847.0 2113975.0 37.7845623594454 -122.444258736096 (37.7845623594454, -122.444258736096)
3860 30022 1 5 1659 Haight St 1 1 1 1   02/02/2016 10:15:00 AM 3 3x3   5998115.9942 2108549.9942 37.76956778996521 -122.449856300055 (37.7695677899652, -122.449856300055)
3903 220233 1 5 1001 Ashbury St 1 9 1 1   05/23/1987 12:00:00 AM 39 Width 4ft Permit Number 12054 5999170.85741 2106639.03394 37.764381073148705 -122.44607010996201 (37.7643810731487, -122.446070109962)
3914 23457 1 5 2249 Van Ness Ave 1 1 1 1     14 5x5   6005866.883230001 2118164.3475 37.7964068674367 -122.42372992781901 (37.7964068674367, -122.423729927819)
3941 116781 2 5 200 Locust St 1 1 1 1   06/10/2016 12:00:00 AM 3 3x3 Permit Number 778230 5997601.127169999 2115625.0178 37.788964483784106 -122.452147749912 (37.7889644837841, -122.452147749912)
4010 253604 2 5 267 Teresita Blvd 1 5 1 1       3x10   5997729.0 2098564.0 37.7421265906625 -122.450474893449 (37.7421265906625, -122.450474893449)
4105 253605 2 5 301 Teresita Blvd 1 7 1 1       3x3   5997753.0 2098469.0 37.741867117319 -122.45038506263799 (37.741867117319, -122.450385062638)
4138 203734 2 5 2328 12th Ave 1 1 1 1     17 Width 4ft Permit Number 770921 5992653.8964 2099572.36715 37.7446035325326 -122.468096189498 (37.7446035325326, -122.468096189498)
4155 203731 1 5 2342 12th Ave 1 1 1 1   04/28/2004 12:00:00 AM 16 Width 4ft Permit Number 47446 5992657.79242 2099436.17889 37.7442298192534 -122.468072813407 (37.7442298192534, -122.468072813407)
4264 107589 2 5 2760 Broderick St 2 1 1 1     13 3x3   6000110.02976 2118059.62225 37.7957926664564 -122.443642277677 (37.7957926664564, -122.443642277677)
4407 5225 3 5 1034 Divisadero St 1 1 1 2     18 3X3   6001461.1836 2111997.0255 37.779223304768 -122.43853244967698 (37.779223304768, -122.438532449677)
4446 253627 3 5 44 Stonecrest Dr 1 5 1 2       3x3   5991061.0 2093828.0 37.7287388406121 -122.4731851996 (37.7287388406121, -122.4731851996)
4479 18084 3 5 2982 Pine St 1 1 1 2     20 4.5x15   5999689.9288 2114724.6521 37.786611746671205 -122.444856053153 (37.7866117466712, -122.444856053153)
Powered by Datasette · Query took 2.452ms · Data source: data.sfgov.org