sf-trees

Data source: data.sfgov.org

Custom SQL query returning 10 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2515 124752 1 42 2478 Sacramento St 1 1 1 1   11/26/2002 12:00:00 AM 9 Width 5ft   6002956.6534 2115870.86114 37.7899448329366 -122.433635939447 (37.7899448329366, -122.433635939447)
36367 203642 2 42 1700 Moraga St 1 1 1 1     28 Width 5ft   5993150.97673 2103877.75625 37.7564537210662 -122.466690296437 (37.7564537210662, -122.466690296437)
41593 220031 2 42 541 Grand View Ave 2 9 1 1     7 Width 5ft   6000040.44223 2101732.89415 37.7509596367958 -122.44271016275101 (37.7509596367958, -122.442710162751)
69034 220048 2 42 1401 Rivoli St 3 1 1 1     3 Width 5ft   5997746.6978 2105897.5577 37.7622637372081 -122.450942387687 (37.7622637372081, -122.450942387687)
146004 203662 2 42 337 Detroit St 1 9 1 1     9 Width 5ft   5999398.70847 2094267.55477 37.7304249920009 -122.44439288782301 (37.7304249920009, -122.444392887823)
166995 203640 2 42 216 Ralston St 5 9 1 1     13 Width 5ft   5992221.60329 2089317.4306299998 37.7164210557753 -122.468844858002 (37.7164210557753, -122.468844858002)
167945 220049 2 42 1401 Rivoli St 4 1 1 1     4 Width 5ft   5997764.73117 2105899.6107 37.7622704065882 -122.450880165397 (37.7622704065882, -122.450880165397)
170022 220032 2 42 4496 24th St 1 9 1 1     8 Width 5ft   6000063.08667 2101692.20447 37.7508492036437 -122.442628935085 (37.7508492036437, -122.442628935085)
170043 203639 2 42 216 Ralston St 4 9 1 1     11 Width 5ft   5992221.12373 2089294.63928 37.7163584485498 -122.46884485801701 (37.7163584485498, -122.468844858017)
174318 220076 2 42 4512 19th St 1 1 1 1     8 Width 5ft   6001006.90228 2104666.0365299997 37.7590683830131 -122.43957830609 (37.7590683830131, -122.43957830609)
Powered by Datasette · Query took 9.253ms · Data source: data.sfgov.org