sf-trees

Data source: data.sfgov.org

Custom SQL query returning 10 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
32546 249651 2 92 2401 Lyon St 3 7 1 1     8 Width 10ft   5999219.23747 2117269.58813 37.7935725973565 -122.446667700452 (37.7935725973565, -122.446667700452)
35406 231466 2 92 37 Seward St 2 7 1 1     8 Width 3ft   6000948.20429 2104259.35127 37.75794838352479 -122.439752154039 (37.7579483835248, -122.439752154039)
42819 249858 2 92 237 Greenwich St 1 7 1 1     10 Width 0ft   6011564.2852 2120410.55302 37.8028943698465 -122.40417376073201 (37.8028943698465, -122.404173760732)
62554 250215 2 92 308 Filbert St 1 7 1 1     24 Width 0ft   6011346.81351 2120087.84529 37.8019961395695 -122.40490359473301 (37.8019961395695, -122.404903594733)
69489 124267 2 92 3 03rd Ave 1 7 1 1     1     5994878.62692 2115008.29877 37.7871148109698 -122.46152244011002 (37.7871148109698, -122.46152244011)
159706 249648 2 92 2460 Lyon St 8 7 1 1     18     5999259.81264 2117301.8944200003 37.7936636195302 -122.446529632962 (37.7936636195302, -122.446529632962)
163891 249655 2 92 2401 Lyon St 7 7 1 1     5 Width 10ft   5999222.6408400005 2117247.53945 37.7935122519365 -122.44665433743201 (37.7935122519365, -122.446654337432)
173821 249649 2 92 2401 Lyon St 1 7 1 1     14     5999242.466569999 2117298.77489 37.793654063333996 -122.446589427069 (37.793654063334, -122.446589427069)
181718 249856 2 92 241 Greenwich St 2 7 1 1     6 Width 0ft   6011508.41601 2120409.27478 37.802887738231504 -122.404367007957 (37.8028877382315, -122.404367007957)
186152 193440 2 92 1775 Silver Ave 5 7 1 1     5 Width 3ft   6011367.39112 2095333.90709 37.7340285952496 -122.403090198147 (37.7340285952496, -122.403090198147)
Powered by Datasette · Query took 28.302ms · Data source: data.sfgov.org