sf-trees

Data source: data.sfgov.org

Custom SQL query returning 14 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
7949 14640 3 97 600X McAllister St 3 1 1 2     18 4x4   6006169.26455 2112150.7692 37.779912136471 -122.422256155719 (37.779912136471, -122.422256155719)
13493 107151 2 97 215 Missouri St 1 1 1 1     12 4x4   6013483.16907 2106058.28155 37.7635933686511 -122.396526740817 (37.7635933686511, -122.396526740817)
15046 17433 3 97 1900 Palou Ave 1 1 1 2     18 4x4   6013265.7394 2096489.52235 37.7373075045406 -122.396607955902 (37.7373075045406, -122.396607955902)
15614 17378 3 97 1600 Palou Ave 2 1 1 2     18 4x4   6014792.92868 2095354.29337 37.7342752738796 -122.391248382303 (37.7342752738796, -122.391248382303)
18276 16647 1 97 178 Noe St 1 1 1 1   09/04/2015 12:00:00 AM 14 4x4   6002850.6051900005 2107244.6681 37.7662534427777 -122.433386179722 (37.7662534427777, -122.433386179722)
50159 27616 3 97 775 McAllister St 4 1 1 2     24 4x4   6005483.48508 2112000.60744 37.7794611228941 -122.424617889559 (37.7794611228941, -122.424617889559)
84621 21779 1 97 2535 Taylor St 1 1 1 1     3 4x4   6008355.3148 2121474.2130400003 37.8056350868765 -122.415353830252 (37.8056350868765, -122.415353830252)
92019 94581 1 97 1025 Clayton St 2 1 1 1       4x4   5998825.0 2106371.0 37.763625362932 -122.44724703752199 (37.763625362932, -122.447247037522)
97514 56845 1 97 980 Clayton St 1 1 1 1   08/02/1974 12:00:00 AM   4x4 Permit Number 14078 5998833.42862215 2106621.08669964 37.7643125198309 -122.447235885769 (37.7643125198309, -122.447235885769)
101303 59009 1 97 3737 20th St 1 1 1 1   04/07/1980 12:00:00 AM 15 4x4 Permit Number 18300 6005405.85335043 2104274.1193378996 37.758241653827 -122.42433675552401 (37.758241653827, -122.424336755524)
110804 21781 3 97 2550X Taylor St 1 1 1 2   08/12/2011 12:00:00 AM 3 4x4   6008458.5658599995 2121488.77145 37.805680863133205 -122.41499754514 (37.8056808631332, -122.41499754514)
127268 14688 3 97 775 McAllister St 3 1 1 2     26 4x4   6005346.74925 2111820.94662 37.7789600951073 -122.425078130411 (37.7789600951073, -122.425078130411)
127740 14687 3 97 775 McAllister St 2 1 1 2     24 4x4   6005346.74925 2111820.94662 37.7789600951073 -122.425078130411 (37.7789600951073, -122.425078130411)
127903 102874 1 97 2761 21st St 3 1 1 1       4x4   6009574.6 2103896.5 37.757439313651396 -122.409892695521 (37.7574393136514, -122.409892695521)
Powered by Datasette · Query took 8.709ms · Data source: data.sfgov.org