sf-trees

Data source: data.sfgov.org

Custom SQL query returning 24 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1932 252826 6 75 3852 17th St 5 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1933 252830 6 75 3852 17th St 9 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1936 252824 6 75 3852 17th St 3 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1938 252827 6 75 3852 17th St 6 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
10174 173886 6 75 2931 20th St 1 7 1 1           6009454.0 2104482.0 37.759040204703496 -122.41035112011801 (37.7590402047035, -122.410351120118)
10190 173887 6 75 2931 20th St 2 7 1 1           6009454.0 2104482.0 37.759040204703496 -122.41035112011801 (37.7590402047035, -122.410351120118)
23162 251173 6 75 367 Jersey St 2 7 1 1       Width 3ft   6002770.52649 2101500.0126900002 37.7504754543841 -122.43325263672399 (37.7504754543841, -122.433252636724)
34652 243942 2 75 701 Church St 8 7 1 1     22 Width 3ft   6004361.46086 2104388.80864 37.7584975338534 -122.427956893407 (37.7584975338534, -122.427956893407)
41272 243941 2 75 701 Church St 1 7 1 1     21 Width 3ft   6004362.39063 2104350.06977 37.758391218686796 -122.4279509174 (37.7583912186868, -122.4279509174)
43953 249965 2 75 265 Filbert St 2 7 1 1     19 Width 0ft   6011638.85917 2120086.18138 37.802007891017205 -122.40389285566799 (37.8020078910172, -122.403892855668)
47352 203175 2 75 2338 Lane St 3 7 1 1     10     6013915.08418 2092868.40903 37.7274007851107 -122.394109422506 (37.7274007851107, -122.394109422506)
51983 203178 2 75 1301 Minnesota St 65 7 1 1     14     6015363.87101 2102334.663 37.75347359354279 -122.38976182994 (37.7534735935428, -122.38976182994)
54015 250212 2 75 300 Filbert St 1 7 1 1     21 Width 0ft   6011360.92473 2120092.038 37.8020084404915 -122.404855058325 (37.8020084404915, -122.404855058325)
87949 96848 6 75 1486 Innes Ave   7 1 1           6016133.4 2096820.6 37.7383757570157 -122.386716118251 (37.7383757570157, -122.386716118251)
107366 101903 7 75 1100 Ocean Ave 4 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
108424 106038 6 75 230 Lakeview Ave   7 1 1         Permit Number 772456 5997013.1 2089546.6 37.7173259605404 -122.452299707743 (37.7173259605404, -122.452299707743)
110616 101905 7 75 1100 Ocean Ave 6 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
146191 101904 7 75 1100 Ocean Ave 5 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
156480 247960 2 75 14 Joy St 1 7 1 1     17     6010368.04056 2098905.3223200003 37.743779075439704 -122.406796895161 (37.7437790754397, -122.406796895161)
163853 247589 2 75 800 Tompkins Ave 10 7 1 1     3     6008947.19059 2096447.5550400002 37.7369509800105 -122.411536266603 (37.7369509800105, -122.411536266603)
167968 203187 2 75 2209 25th St 1 7 1 1     18     6012122.25902 2101859.12536 37.7519875798856 -122.400938678078 (37.7519875798856, -122.400938678078)
174438 203177 2 75 1301 Minnesota St 61 7 1 1     17     6015358.55131 2102374.09965 37.7535815832452 -122.38978298111401 (37.7535815832452, -122.389782981114)
178669 243943 2 75 671 Church St 56 7 1 1     19 Width 3ft   6004315.82343 2105235.1157 37.7608187101375 -122.428175041065 (37.7608187101375, -122.428175041065)
184842 203176 2 75 1301 Minnesota St 12 7 1 1     12     6015380.59839 2102345.27771 37.753503666864205 -122.38970472391199 (37.7535036668642, -122.389704723912)
Powered by Datasette · Query took 11.355ms · Data source: data.sfgov.org