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)
74 188665 3 5 2175X Palou Ave 1 1 1 2     37     6011669.71313 2097723.45025 37.740606653987705 -122.402212916691 (37.7406066539877, -122.402212916691)
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            
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)
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            
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)
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)
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)
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)
1647 20023 3 5 100 STAIRWAY48 7 1 1 2     12 10ST            
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
3819 19829 3 5 100 STAIRWAY25 13 1 1 2     6 60X            
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)
4568 142545 3 5 301 FRANCISCO ST 7 1 1 4     20 Width 0ft   6009562.3577 2121186.5007 37.80491286675579 -122.41115633279499 (37.8049128667558, -122.411156332795)
4570 142547 3 5 301 FRANCISCO ST 9 1 1 4     20 Width 0ft   6009612.5597 2121193.6724 37.804935373675605 -122.41098310943799 (37.8049353736756, -122.410983109438)
5001 17864 3 5 2121 Pine St 9 1 1 2     12 3X3   6003749.9172 2115228.4651 37.78822595410529 -122.430845453567 (37.7882259541053, -122.430845453567)
5165 18104 3 5 3047 Pine St 1 1 1 2     12 3x3   5999356.199 2114621.5583 37.786309626644 -122.446003255008 (37.786309626644, -122.446003255008)
5167 27271 3 5 2134 Van Ness Ave 1 1 1 2     24 2X2   6006018.78384 2117780.42149 37.7953612769429 -122.42317701472 (37.7953612769429, -122.42317701472)
5281 17859 3 5 2121 Pine St 4 1 1 2     12 3X3   6003647.2236 2115215.6899 37.7881850576658 -122.431199843789 (37.7881850576658, -122.431199843789)
5371 18271 3 5 1949 Post St 2 1 1 2     6 3X3   6002897.9436 2114073.452 37.785006273193495 -122.43371055367399 (37.7850062731935, -122.433710553674)
5383 23482 3 5 2450 Van Ness Ave 1 1 1 2     30 3x3   6005868.84657 2118854.8733 37.7983029872579 -122.423772257989 (37.7983029872579, -122.423772257989)
5388 6963 3 5 700 Fell St 1 1 1 2     18 3X3   6004011.7809 2110463.0214 37.7751560657789 -122.42959944801599 (37.7751560657789, -122.429599448016)
5395 5286 3 5 1363 Divisadero St 1 1 1 2     18 3X3   6001243.7155 2113125.1285 37.78230841581821 -122.439365644426 (37.7823084158182, -122.439365644426)
5421 13063 3 5 590 Lombard St 2 1 1 2     30 2X2   6009554.3361 2120533.7978 37.803120257284 -122.41113795910499 (37.803120257284, -122.411137959105)
5472 6255 3 5 1315 Ellis St 5 1 1 2     55 3X3   6004589.0866 2113270.6263 37.782897727980206 -122.427802511173 (37.7828977279802, -122.427802511173)
5528 23516 3 5 2656 Van Ness Ave 1 1 1 2   08/26/1994 12:00:00 AM 30 5x5   6005775.26266 2119527.50037 37.800144566769205 -122.42414394780899 (37.8001445667692, -122.424143947809)
5576 14497 3 5 350 Masonic Ave 1 1 1 2     90 3X3   5999071.4256 2111558.1482 37.7778820323449 -122.446767989356 (37.7778820323449, -122.446767989356)
5588 9934 3 5 2336 Gough St 5 1 1 2     18 3X3   6005029.63249 2117730.67065 37.7951688031463 -122.426596098652 (37.7951688031463, -122.426596098652)
5704 17832 3 5 1977 Pine St 2 1 1 2     24 5x5   6004499.0246 2115333.9095 37.7885578925396 -122.428261185185 (37.7885578925396, -122.428261185185)
5707 23479 3 5 2418 Van Ness Ave 1 1 1 2     38 4x6   6005891.1574800005 2118710.22844 37.7979070885885 -122.423684765642 (37.7979070885885, -122.423684765642)
5742 14498 3 5 350 Masonic Ave 2 1 1 2     100 3X3   5999068.9707 2111582.6972 37.7779492973394 -122.44677824853001 (37.7779492973394, -122.44677824853)
5811 17867 3 5 2126 Pine St 1 1 1 2     12 3X3   6003744.3566 2115283.9831 37.78837807743321 -122.430868655963 (37.7883780774332, -122.430868655963)
5814 6256 3 5 1315 Ellis St 6 1 1 2     100 3X3   6004614.9344 2113276.215 37.7829145353129 -122.427713486832 (37.7829145353129, -122.427713486832)
5878 5285 3 5 1363 Divisadero St 3 1 1 2     18 3X3   6001249.1303 2113085.1947 37.7821990759369 -122.439344048338 (37.7821990759369, -122.439344048338)
5995 7109 3 5 2160 Fell St 1 1 1 2     22 3X3   5997101.518999999 2109497.2925 37.772110729949105 -122.453433718113 (37.7721107299491, -122.453433718113)
6082 6924 3 5 446 Fell St 1 1 1 2     36 3X4   6005254.8423 2110638.1989 37.775707366557 -122.425311885836 (37.775707366557, -122.425311885836)
6086 7024 3 5 1124 Fell St 1 1 1 2     24 3X3   6002012.3902 2110183.0208 37.774273842043904 -122.43649573066601 (37.7742738420439, -122.436495730666)
6171 8616 3 5 2600 Geary Blvd 4 11 1 2     12 20   5999337.0471 2113224.2861 37.78247198716561 -122.44596898090299 (37.7824719871656, -122.445968980903)
6192 18042 3 5 2815 Pine St 1 1 1 2     12 3X3   6000288.8455 2114746.503 37.7867059051394 -122.442785522834 (37.7867059051394, -122.442785522834)
6251 18079 3 5 2958 Pine St 1 1 1 2     18 3X3   5999776.6083 2114733.1887 37.786640132310296 -122.444556777947 (37.7866401323103, -122.444556777947)
6334 6269 3 5 1355 Ellis St 4 1 1 2     125 3X3   6004413.7404 2113247.5728 37.7828245080819 -122.42840749249201 (37.7828245080819, -122.428407492492)
6338 6270 3 5 1355 Ellis St 5 1 1 2     75 3X3   6004445.8756 2113251.7643 37.782837835273206 -122.428296616989 (37.7828378352732, -122.428296616989)
6397 18075 3 5 2945 Pine St 1 1 1 2     24 3X3   5999836.3647 2114682.6256 37.786504708751 -122.444346400919 (37.786504708751, -122.444346400919)
6431 6926 3 5 474 Fell St 1 1 1 2     24 3X3   6005147.8848 2110623.4947 37.7756609491529 -122.425680831948 (37.7756609491529, -122.425680831948)
6466 5201 3 5 730 Divisadero St 1 1 1 2     18 3x6   6001603.6657 2110963.249 37.7763929190422 -122.43796547839199 (37.7763929190422, -122.437965478392)
6492 20389 3 5 262X Sunset Blvd 35 1 1 2     12 60            
6495 26421 3 5 2235X Octavia St 6 11 1 2     6 20   6004624.1328 2116974.76242 37.793070338586205 -122.427945300259 (37.7930703385862, -122.427945300259)
6519 23572 3 5 3015 Van Ness Ave 1 1 1 2     35 3x3   6005516.07344 2120742.37785 37.8034656713563 -122.425127334879 (37.8034656713563, -122.425127334879)
6522 14481 3 5 281 Masonic Ave 2 1 1 2   11/09/1990 12:00:00 AM 40 3X3   5998935.5096 2112063.3301 37.779261366231104 -122.447274536897 (37.7792613662311, -122.447274536897)
6654 7065 3 5 1588 Fell St 1 1 1 2   06/16/2014 12:00:00 AM 30 3X3   5999848.9957 2109884.015 37.7733296774154 -122.443957794129 (37.7733296774154, -122.443957794129)
6669 17873 3 5 2152 Pine St 1 1 1 2     18 3X3   6003637.0261 2115269.5348 37.7883323242451 -122.431238970337 (37.7883323242451, -122.431238970337)
6683 7097 3 5 1988 Fell St 1 1 1 2     24 4x6   5997952.7475 2109617.0075 37.7724881931803 -122.450497895204 (37.7724881931803, -122.450497895204)
6716 17870 3 5 2140 Pine St 1 1 1 2     12 3X3   6003687.0793 2115278.307 37.788359246862896 -122.431066420843 (37.7883592468629, -122.431066420843)
6738 17820 3 5 1911 Pine St 1 1 1 2     12 3X3   6004637.6708 2115354.7286 37.7886229005187 -122.427782974318 (37.7886229005187, -122.427782974318)
6746 20018 3 5 100 STAIRWAY48 2 1 1 2     12 10ST            
6819 23867 3 5 1460 Webster St 2 1 1 2     80 4X6   6003686.8148 2113759.4476 37.7841888268021 -122.430958893029 (37.7841888268021, -122.430958893029)
6881 26539 3 5 500 Francisco St 2 1 1 2     18 4X4   6008853.6446 2121130.7332 37.8047199727818 -122.413604973767 (37.8047199727818, -122.413604973767)
6885 18901 3 5 2590 Sacramento St 2 1 1 2     30 3X3   6002400.944180001 2115794.1415 37.7897026338206 -122.435553151076 (37.7897026338206, -122.435553151076)
6972 17861 3 5 2121 Pine St 6 1 1 2     18 3X3   6003684.0754 2115220.6034 37.7882006371659 -122.431072693705 (37.7882006371659, -122.431072693705)
6982 17878 3 5 2189 Pine St 2 1 1 2     6 3X3   6003500.3079 2115200.4578 37.78813490757079 -122.431707058922 (37.7881349075708, -122.431707058922)
7022 14504 3 5 436 Masonic Ave 1 1 1 2     30 3X3   5999110.8967 2111284.0293 37.7771316270833 -122.446611718241 (37.7771316270833, -122.446611718241)
7059 18085 3 5 2986 Pine St 1 1 1 2     18 5x9   5999664.9755 2114716.7721 37.7865886861458 -122.44494181853001 (37.7865886861458, -122.44494181853)
7077 6266 3 5 1355 Ellis St 1 1 1 2     45 3X3   6004309.6505 2113217.5334 37.7827361367074 -122.428765457764 (37.7827361367074, -122.428765457764)
7101 7075 3 5 1702 Fell St 2 1 1 2     30 3X3   5999191.7179 2109787.4763 37.7730270916611 -122.44622445463699 (37.7730270916611, -122.446224454637)
7116 7056 3 5 1390 Fell St 1 1 1 2     30 3X3   6000868.0121 2110028.3766 37.77378413322079 -122.440443239867 (37.7737841332208, -122.440443239867)
7128 17833 3 5 2003 Pine St 1 1 1 2     24 3X3   6004227.6624 2115298.5998 37.788445582937 -122.429197538284 (37.788445582937, -122.429197538284)
7137 6252 3 5 1315 Ellis St 2 1 1 2     100 3X3   6004508.0501 2113262.2432 37.78287012558321 -122.42808226621099 (37.7828701255832, -122.428082266211)
7202 23877 3 5 1499X Webster St 3 1 1 2     24 3X3   6003598.0216 2113733.7356 37.784113196541796 -122.431264249788 (37.7841131965418, -122.431264249788)
7320 5190 3 5 518 Divisadero St 1 1 1 2     18 3X3   6001706.5859 2110230.9953 37.7743881862019 -122.43755699782899 (37.7743881862019, -122.437556997829)
7369 17863 3 5 2121 Pine St 8 1 1 2     12 3X3   6003725.8407 2115226.9911 37.7882205427126 -122.43092864894399 (37.7882205427126, -122.430928648944)
Powered by Datasette · Query took 32.027ms · Data source: data.sfgov.org