sf-trees

Data source: data.sfgov.org

Custom SQL query returning 39 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1573 251597 9 148 1650 Valencia St 1 17 1 1           6006336.0 2100501.0 37.747934015176504 -122.42085202386299 (37.7479340151765, -122.420852023863)
2263 22364 9 25 5490X 03rd St 1 11 1 2     48 40TR   6014151.6099 2093070.9929 37.7279701830365 -122.393305916851 (37.7279701830365, -122.393305916851)
4546 7946 9 184 1701 Franklin St 1 1 1 1     18 3X3   6005703.15328 2116043.32965 37.7905738421571 -122.424145551273 (37.7905738421571, -122.424145551273)
7798 1716 9 30 555 Battery St 4 1 1 2     18 5x15   6012528.51285 2117974.4106400004 37.796259138493205 -122.400665775228 (37.7962591384932, -122.400665775228)
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)
16525 18547 9 72 1700X Quesada Ave 2 11 1 2     30 19   6014668.27449 2095058.7142299998 37.733456755021 -122.391658696189 (37.733456755021, -122.391658696189)
16768 18555 9 100 1700X Quesada Ave 10 11 1 2     12 19   6014626.04256 2095092.9200799998 37.733548332979105 -122.39180709603201 (37.7335483329791, -122.391807096032)
16811 18551 9 100 1700X Quesada Ave 6 11 1 2     30 19   6014649.71614 2095074.3239900002 37.733498586072294 -122.391723949223 (37.7334985860723, -122.391723949223)
18163 24539 9 292 500X Cortland Ave 3 1 1 3     50 3X3   6007622.1254900005 2097206.54003 37.738960570878795 -122.41617135711999 (37.7389605708788, -122.41617135712)
20653 2618 9 103 1661X Octavia St 5 1 1 2     42 10X10   6004876.92395 2115038.87855 37.787769186678204 -122.42693268975599 (37.7877691866782, -122.426932689756)
21449 24540 9 292 500X Cortland Ave 4 1 1 3     50 3X3   6007652.968230001 2097201.05938 37.7389472564055 -122.416064328819 (37.7389472564055, -122.416064328819)
22308 248932 9 24 46 Cook St 1 7 1 1         Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 5997514.0 2113392.0 37.7828282170553 -122.452288002469 (37.7828282170553, -122.452288002469)
22823 251110 9 100 1700X Quesada Ave 5 3 1 2                    
22824 251112 9 100 1700X Quesada Ave 14 22 1 2                    
22825 251109 9 100 1700X Quesada Ave 3 3 1 2                    
22828 251115 9 100 1700X Quesada Ave 19 3 1 2                    
22831 251116 9 100 1700X Quesada Ave 20 3 1 2                    
22832 251108 9 100 1700X Quesada Ave 2 3 1 2                    
22833 251113 9 100 1700X Quesada Ave 15 3 1 2                    
22838 251111 9 100 1700X Quesada Ave 7 3 1 2                    
22839 251114 9 100 1700X Quesada Ave 16 3 1 2                    
35608 194288 9 100 1700x Quesada Ave 37 3 1 2     34     6014411.93404 2095259.01392 37.733992504551296 -122.392558950849 (37.7339925045513, -122.392558950849)
39870 194287 9 100 1700x Quesada Ave 32 3 1 2     31     6014435.322380001 2095233.3766599998 37.733923408722795 -122.392476296866 (37.7339234087228, -122.392476296866)
54354 194291 9 100 1700x Quesada Ave 41 3 1 2     38     6014364.32912 2095287.3135099998 37.7340675655682 -122.39272551607701 (37.7340675655682, -122.392725516077)
58702 194289 9 100 1700x Quesada Ave 38 3 1 2     48     6014396.14271 2095264.76436 37.734007417094 -122.39261394888901 (37.734007417094, -122.392613948889)
65300 111749 9 180 4124 23rd St 1 13 1 1           6002319.4 2102413.2 37.752957247271 -122.434877962118 (37.752957247271, -122.434877962118)
78801 2617 9 103 1661X Octavia St 4 1 1 2     42 10X10   6004876.92395 2115038.87855 37.787769186678204 -122.42693268975599 (37.7877691866782, -122.426932689756)
80756 2614 9 103 1661X Octavia St 1 1 1 2     42 10X10   6004876.92395 2115038.87855 37.787769186678204 -122.42693268975599 (37.7877691866782, -122.426932689756)
90443 111748 9 338 730 28th Ave 1 13 1 1           5987294.2 2110946.4 37.7755225253955 -122.48746405921301 (37.7755225253955, -122.487464059213)
94802 18548 9 100 1700X Quesada Ave 3 11 1 2     30 19   6014793.6967997 2095004.1424748 37.7333138733401 -122.39122125893199 (37.7333138733401, -122.391221258932)
97410 113742 9 148 1580 Valencia St 2 7 1 1     80     6006496.0 2100402.0 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307)
101071 111757 9 480 3440X Folsom St 1 7 1 3           6008633.6974599995 2098934.7859 37.743762781475 -122.41279594632401 (37.743762781475, -122.412795946324)
114869 111205 9 24 46 COOK ST   13 1 1     36   Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 5997514.0 2113392.0 37.7828282170553 -122.452288002469 (37.7828282170553, -122.452288002469)
116419 2615 9 103 1661X Octavia St 2 1 1 2     42 10X10   6004876.92395 2115038.87855 37.787769186678204 -122.42693268975599 (37.7877691866782, -122.426932689756)
121641 64380 9 447 1221 Stanyan St 1 1 1 1   04/21/1988 12:00:00 AM     Permit Number 25220 5997415.00742592 2105661.0761541002 37.7615954244829 -122.452072511028 (37.7615954244829, -122.452072511028)
124625 111763 9 47 2626 Vallejo St 1 13 1 1           6001000.6 2117623.4 37.7946456667745 -122.440529445268 (37.7946456667745, -122.440529445268)
126137 105444 9 180 20-28 ROSEMONT PL 1 13 1 1           6005075.5 2108088.5 37.768696376708895 -122.425750755404 (37.7686963767089, -122.425750755404)
126390 2619 9 103 1661X Octavia St 6 1 1 2     36 10X10   6004877.75733 2115027.26874 37.7877373561683 -122.42692897924101 (37.7877373561683, -122.426928979241)
138324 2616 9 103 1661X Octavia St 3 1 1 2     42 10X10   6004876.92395 2115038.87855 37.787769186678204 -122.42693268975599 (37.7877691866782, -122.426932689756)
Powered by Datasette · Query took 1.745ms · Data source: data.sfgov.org