sf-trees

Data source: data.sfgov.org

Custom SQL query returning 10 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2825 81846 3 12 1421 Pine St 1 1 1 10 6 12/20/2007 12:00:00 AM 3 3x3 Permit Number 50020 6007049.49584 2115692.06976 37.7896852939829 -122.419462344328 (37.7896852939829, -122.419462344328)
1043 81845 3 12 1421 Pine St 2 1 1 10 6 04/28/2017 08:33:00 AM 3 3x3 Permit Number 50020 6007103.87391 2115697.8037 37.789704100621705 -122.419274608151 (37.7897041006217, -122.419274608151)
81617 81843 3 12 1299X Larkin St 1 1 1 10 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
88938 82383 3 12 1421 Pine St 4 1 1 10 6 09/11/2012 12:00:00 AM 3 3x3   6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
97025 81841 3 12 1299X Larkin St 3 1 1 10 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
100401 81842 3 12 1299X Larkin St 2 1 1 10 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
111252 81840 3 12 1299X Larkin St 4 1 1 10 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
141753 81839 3 12 1299X Larkin St 5 1 1 10 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
115219 98995 3 12 2190X Divisadero St 1 1 1 10       3x3   6000922.9 2115860.7 37.7898013277865 -122.44067180053001 (37.7898013277865, -122.44067180053)
79502 98996 3 12 2190X North Point St 2 1 1 10   04/18/2011 12:00:00 AM   3x3   6000702.0 2120685.0 37.803035002067396 -122.441782472194 (37.8030350020674, -122.441782472194)
Powered by Datasette · Query took 35.304ms · Data source: data.sfgov.org