sf-trees

Data source: data.sfgov.org

Custom SQL query returning 10 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
41124 247987 2 84 124 Mullen Ave 1 7 1 1     11     6009857.2555 2099808.73815 37.7462310644209 -122.408626794296 (37.7462310644209, -122.408626794296)
47512 196066 2 84 602 Arthur Ave 29 7 1 1     3     6015729.65904 2099863.28866 37.7467079937826 -122.38832437158999 (37.7467079937826, -122.38832437159)
61578 238534 2 84 671 Church St 39 7 1 1     12 Width 3ft   6004315.939809999 2105094.00544 37.7604312615151 -122.428164581928 (37.7604312615151, -122.428164581928)
63982 247592 2 84 800 Tompkins Ave 13 7 1 1     20     6008994.80779 2096446.35961 37.736950368458096 -122.41137154767799 (37.7369503684581, -122.411371547678)
98763 249657 2 84 2401 Lyon St 9 7 1 1     5 Width 10ft   5999220.856459999 2117228.0712599996 37.7934586955217 -122.44665911012301 (37.7934586955217, -122.446659110123)
119284 116071 3 84 4150X CLEMENT ST 1 7 1 2     8 3x3   5983115.0 2113126.0 37.7812624555251 -122.502082001527 (37.7812624555251, -122.502082001527)
137994 196067 2 84 2338 Lane St 2 7 1 1     2 Width 5ft   6013920.54146 2092873.2671400001 37.727414427818395 -122.394090896496 (37.7274144278184, -122.394090896496)
152517 196065 2 84 602 Arthur Ave 28 7 1 1     3     6015745.278940001 2099859.59173 37.7466987082831 -122.388270101098 (37.7466987082831, -122.388270101098)
155630 196373 2 84 1900 19th St 2 7 1 1     1     6012066.64129 2105141.25616 37.760996487210996 -122.40136164543101 (37.760996487211, -122.401361645431)
183588 196335 2 84 1900 19th St 10 7 1 1     1     6012008.47004 2105145.92381 37.761006057794 -122.401563163706 (37.761006057794, -122.401563163706)
Powered by Datasette · Query took 11.292ms · Data source: data.sfgov.org