sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
13675 18550 9 5 1700X Quesada Ave 5 11 1 2     30 19   6014656.2717 2095062.2920900001 37.733465912826 -122.391700443637 (37.733465912826, -122.391700443637)
151907 111321 8 5 1X Peabody St 1 1 1 1     15     6010185.8855099995 2087316.24933 37.7119477217782 -122.406610237293 (37.7119477217782, -122.406610237293)
2854 253253 6 5 99X Lopez Ave 4 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
8131 112367 6 5 2770 Broadway 1 5 1 1   07/23/2015 12:00:00 AM 3 3x3 Permit Number 774944 6000432.434780001 2117179.73451 37.7933951089516 -122.442463497617 (37.7933951089516, -122.442463497617)
9677 114154 6 5 1200x JUNIPERO SERRA BLVD 13 7 1 1     20     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9996 173615 6 5 1200X JUNIPERO SERRA BLVD 14 7 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
13306 187657 6 5 2072 15th Ave 1 2 1 1       3x3   5991666.0 2101424.0 37.7496305363998 -122.47164701446 (37.7496305363998, -122.47164701446)
77934 105417 6 5 1450X McAllister St 3 7 1 1           6002220.7882900005 2111575.67932 37.7781095739995 -122.43587451144501 (37.7781095739995, -122.435874511445)
78383 115661 6 5 341 HAZELWOOD AVE 1 1 1 1     15 3x3   5996066.0 2095432.0 37.7334315621613 -122.455998615118 (37.7334315621613, -122.455998615118)
78929 99659 6 5 1325 Portola Dr 3 7 1 1           5993615.2 2097760.6 37.7396843456359 -122.464640684629 (37.7396843456359, -122.464640684629)
79584 116089 6 5 98x WOODWARD ST 3 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
79771 105872 6 5 595X San Jose Ave 6 7 1 1           6006124.4715599995 2100100.1430599997 37.7468214281195 -122.421555015777 (37.7468214281195, -122.421555015777)
80060 113973 6 5 11 Hiliritas Ave 1 7 1 1         Permit Number 776381 6001589.6 2096875.9 37.7377116664791 -122.437005345865 (37.7377116664791, -122.437005345865)
81189 98546 6 5 555@Rio Teresita Blvd 2 9 1 1           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448)
85026 99100 6 5 60 Santa Monica Way 1 1 1 1           5993700.7 2097327.0 37.7384987171226 -122.464313592449 (37.7384987171226, -122.464313592449)
85142 104690 6 5 1435X La Salle Ave 1 7 1 1         Permit Number 770699 6016460.43075 2095036.9864400001 37.733496412822205 -122.385461132957 (37.7334964128222, -122.385461132957)
85680 99097 6 5 99X Santa Monica Way 1 2 1 1           5994003.8 2097131.6 37.7379796635799 -122.463251452094 (37.7379796635799, -122.463251452094)
86822 114840 6 5 2455x HYDE ST   1 1 13     12 3x3   6006980.0 2120877.0 37.803917898432395 -122.42007090461901 (37.8039178984324, -122.420070904619)
89406 114379 6 5 443X ARBALLO DR 1 7 1 1     36     5988110.0 2090275.0 37.718811899837206 -122.483126550771 (37.7188118998372, -122.483126550771)
91700 95229 6 5 1@Carl Irving St 5 9 1 1   11/16/2010 12:00:00 AM 15     5995817.2 2106753.3 37.7645027364821 -122.45767767256001 (37.7645027364821, -122.45767767256)
98300 94851 6 5 1107 Bowdoin St 2 7 1 1   11/17/2010 12:00:00 AM 12   Permit Number 774691 6009593.0 2091048.0 37.7221611506882 -122.408922553301 (37.7221611506882, -122.408922553301)
101747 113695 6 5 907 FLORIDA ST 1 1 1 1     24 3x3   6009441.0 2103786.0 37.7571284172194 -122.41034693748101 (37.7571284172194, -122.410346937481)
102846 105415 6 5 1450X McAllister St 1 7 1 1           6002220.7882900005 2111575.67932 37.7781095739995 -122.43587451144501 (37.7781095739995, -122.435874511445)
103243 116088 6 5 98x WOODWARD ST 2 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
104669 95231 6 5 1@Carl Irving St 10 9 1 1   11/16/2010 12:00:00 AM       5995817.2 2106753.3 37.7645027364821 -122.45767767256001 (37.7645027364821, -122.45767767256)
105103 105858 6 5 1580 Valencia St 18 7 1 1           6006496.0 2100402.0 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307)
105359 98545 6 5 555@Rio Teresita Blvd 1 7 1 1           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448)
105444 105416 6 5 1450X McAllister St 2 7 1 1           6002220.7882900005 2111575.67932 37.7781095739995 -122.43587451144501 (37.7781095739995, -122.435874511445)
107871 116087 6 5 98x WOODWARD ST 1 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
108061 104751 6 5 13X JUAN BAUTISTA CIR 2 7 1 1           5989494.0 2090180.0 37.7186314952818 -122.47833572411999 (37.7186314952818, -122.47833572412)
118749 105859 6 5 1580 Valencia St 18 7 1 1           6006496.0 2100402.0 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307)
121713 92964 6 5 380 Valdez Ave 1 7 1 1     17     5995792.2 2095482.9 37.7335556021648 -122.456948893253 (37.7335556021648, -122.456948893253)
125535 116090 6 5 98x WOODWARD ST 4 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
138465 120551 6 5 1485 Fairfax Ave 1 7 1 1           6016296.0 2097688.0 37.7407664622153 -122.38621437638201 (37.7407664622153, -122.386214376382)
154324 112045 6 5 2418 Pacific Ave 1 8 1 1     18 3x3   6002446.95594 2117111.03197 37.7933210893366 -122.435488200226 (37.7933210893366, -122.435488200226)
171221 112905 6 5 2401 Keith St 1 7 1 1     25     6014331.87009 2092225.76664 37.725659374776605 -122.39262364628901 (37.7256593747766, -122.392623646289)
13466 104640 5 5 112 07th St 1 1 1 1     10 2.5x2.5   6009509.89326 2111697.52669 37.778855505921605 -122.410667371323 (37.7788555059216, -122.410667371323)
18151 124716 5 5 2195 Palou Ave 1 1 1 1                    
88695 104451 5 5 2490X Folsom St 6 1 1 3       3x3   6008214.39649 2104163.7525299997 37.7580968032353 -122.41461574816002 (37.7580968032353, -122.41461574816)
92561 104449 5 5 2490X Folsom St 4 1 1 3       3x3   6008214.39649 2104163.7525299997 37.7580968032353 -122.41461574816002 (37.7580968032353, -122.41461574816)
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            
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)
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)
Powered by Datasette · Query took 30.818ms · Data source: data.sfgov.org