sf-trees

Data source: data.sfgov.org

Custom SQL query returning 8 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3781 228284 8 44 2036X 15th St 7 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
110700 107977 8 15 2750 JACKSON ST 7 1 1 1   11/10/2014 12:00:00 AM 3 3x3 Permit Number 770079 6001096.4 2116670.4 37.7920344322485 -122.440129594684 (37.7920344322485, -122.440129594684)
112757 117142 8 49 2203x NEWCOMB AVE 7 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983.0 2098083.0 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432)
113160 109947 8 147 400x CLEMENTINA ST 7 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
113705 112586 8 48 3400x WAWONA ST 7 5 1 1       4x4   5982411.0 2096792.0 37.7363725426512 -122.50330767262899 (37.7363725426512, -122.503307672629)
115319 101923 8 127 1401X California St 7 1 1 1   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007402.7 2116063.9 37.790726135860204 -122.418266664095 (37.7907261358602, -122.418266664095)
125268 109121 8 44 2036x 15TH ST 7 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
144368 113609 8 41 2900 18TH ST 7 1 1 1   10/05/2015 12:00:00 AM   3x3   6009122.0 2105484.0 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816)
Powered by Datasette · Query took 3.278ms · Data source: data.sfgov.org