sf-trees

Data source: data.sfgov.org

Custom SQL query returning 18 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
928 224422 7 32 3255x 24th St 2 8 1 6     16 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
1945 252839 7 114 99 Pond St 2 9 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1948 252834 7 114 98 Prosper St 2 5 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
2606 253143 7 186 735 29th Ave 2 5 1 1       3x3   5986898.0 2110914.0 37.7754104499772 -122.48883220977301 (37.7754104499772, -122.488832209773)
78854 101901 7 2 1100 Ocean Ave 2 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
82732 102470 7 3 1021 Kirkham St 2 13 1 1           5991773.0 2105198.0 37.7599991432047 -122.471551983129 (37.7599991432047, -122.471551983129)
83310 33775 7 21 200x Mission St 2 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138.0 2116340.0 37.791861063915796 -122.394982044679 (37.7918610639158, -122.394982044679)
85853 114950 7 3 1X WOODACRE DR 2 19 1 2       30x100   5991187.0 2095315.0 37.732829063550795 -122.47285799850201 (37.7328290635508, -122.472857998502)
96460 109375 7 86 111 BAY ST 2 13 1 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
98786 100139 7 17 155 05th St 2 7 1 1         Permit Number 769024 6011029.6 2112857.4 37.782125333955705 -122.40549178692301 (37.7821253339557, -122.405491786923)
99354 102249 7 41 125X Powhattan Ave 2 7 1 1   01/07/2013 12:00:00 AM     Permit Number 768486 6007606.0 2098071.0 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592)
100224 91109 7 17 2650 Turk Blvd 2 7 1 1       On campus   5998086.4 2111055.5 37.7764455713486 -122.450139282915 (37.7764455713486, -122.450139282915)
108324 105353 7 17 1979 SAN JOSE AVE 2 7 1 1   04/16/2014 12:00:00 AM 27   Permit Number 772405 5999886.5 2092393.4 37.7253068164695 -122.442572018552 (37.7253068164695, -122.442572018552)
111875 115636 7 3 81x ELSIE ST 2 16 1 2     16 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
116035 105232 7 3 460X ROOSEVELT WAY 2 7 1 1     17     5999944.0 2106286.0 37.7634558498539 -122.443370673769 (37.7634558498539, -122.443370673769)
124771 105685 7 94 635 08TH ST 2 30 1 1     8     6011418.5 2109097.9 37.7718243537934 -122.40388172759701 (37.7718243537934, -122.403881727597)
125343 99276 7 17 85X 10th St 2 7 1 1   04/25/2012 12:00:00 AM     Permit Number 768878 6007907.6 2110517.0 37.7755240963356 -122.416126724722 (37.7755240963356, -122.416126724722)
125858 104539 7 19 1101 Van Ness Ave 2 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
Powered by Datasette · Query took 1.725ms · Data source: data.sfgov.org