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)
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)
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)
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)
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)
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)
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)
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)
7372 6254 3 5 1315 Ellis St 4 1 1 2     85 3X3   6004557.65 2113267.8319 37.7828882768645 -122.427911069574 (37.7828882768645, -122.427911069574)
7496 6049 3 5 1865 Eddy St 2 1 1 2     12 4X4   6001591.0462 2112505.5339 37.7806269262997 -122.438119638656 (37.7806269262997, -122.438119638656)
7634 5240 3 5 1100 Divisadero St 9 1 1 2     24 3X3   6001405.3119 2112421.3803 37.780385297097205 -122.43875614904499 (37.7803852970972, -122.438756149045)
7639 18080 3 5 2964 Pine St 1 1 1 2     18 3X3   5999752.9685 2114731.2187 37.7866333742754 -122.444638424012 (37.7866333742754, -122.444638424012)
7729 5905 3 5 1276 Eddy St 1 1 1 2     24 6x6   6004411.4514 2112945.733 37.7819956014908 -122.42839389105801 (37.7819956014908, -122.428393891058)
7768 22759 3 5 1620 Turk St 1 1 1 2     18 4x4   6002316.427999999 2112303.8634 37.7801144169363 -122.435595767889 (37.7801144169363, -122.435595767889)
7838 20021 3 5 100 STAIRWAY48 5 1 1 2     12 10ST            
7857 17860 3 5 2121 Pine St 5 1 1 2     12 3X3   6003663.9297 2115217.6553 37.7881914008546 -122.431142183883 (37.7881914008546, -122.431142183883)
Powered by Datasette · Query took 46.549ms · Data source: data.sfgov.org