sf-trees

Data source: data.sfgov.org

Custom SQL query returning 17 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
158856 177486 2 315 601 La Grande Ave 1 23 1 1     6     6004368.23495 2089081.7920799998 37.7164683196427 -122.42684334834999 (37.7164683196427, -122.42684334835)
130707 190965 2 47 1 24th St 17 23 1 1     6     6017293.94065 2102634.4333599997 37.754403540203796 -122.38310803210899 (37.7544035402038, -122.383108032109)
188821 192368 2 10 1310 Indiana St 7 23 1 1     6     6014962.221059999 2102496.55555 37.753895835135104 -122.39116214813801 (37.7538958351351, -122.391162148138)
33649 196072 2 16 1 25th St 4 23 1 1     6     6014990.91174 2102121.65719 37.7528680359305 -122.391036726872 (37.7528680359305, -122.391036726872)
130498 196075 2 16 1 25th St 17 23 1 1     6     6014963.469190001 2102214.24517 37.753120740043705 -122.391138100256 (37.7531207400437, -122.391138100256)
133863 196076 2 16 1 25th St 18 23 1 1     6     6014971.87416 2102223.03647 37.753145345506795 -122.39110964840401 (37.7531453455068, -122.391109648404)
151585 196077 2 16 1 25th St 19 23 1 1     6     6014960.28506 2102234.79181 37.7531769800583 -122.391150547759 (37.7531769800583, -122.391150547759)
44764 205937 2 270 50 Circular Ave 1 23 1 1     6     6000127.5419 2093913.2935099998 37.7294938303644 -122.44184779835501 (37.7294938303644, -122.441847798355)
156226 223318 2 197 4404 20th St 3 23 1 1     6 Width 3ft   6003637.291809999 2104227.88023 37.75801466716629 -122.43044991126101 (37.7580146671663, -122.430449911261)
24928 223320 2 197 4404 20th St 5 23 1 1     6 Width 3ft   6003607.3788 2104219.57182 37.7579901597246 -122.430552770305 (37.7579901597246, -122.430552770305)
38165 223321 2 197 4404 20th St 6 23 1 1     6 Width 3ft   6003607.59341 2104210.2360400003 37.757964538052796 -122.430551361954 (37.7579645380528, -122.430551361954)
68242 223322 2 197 4404 20th St 7 23 1 1     6 Width 3ft   6003609.4958 2104203.70513 37.757946713498704 -122.430544316686 (37.7579467134987, -122.430544316686)
169576 233228 2 41 199 Franconia St 1 23 1 1     6 Width 3ft   6010113.61596 2099694.13241 37.7459307367175 -122.407732247644 (37.7459307367175, -122.407732247644)
25729 233231 2 41 199 Franconia St 4 23 1 1     6 Width 3ft   6010116.17645 2099679.88413 37.7458917573937 -122.407722389299 (37.7458917573937, -122.407722389299)
134356 233602 2 41 199 Franconia St 8 23 1 1     6 Width 3ft   6010143.5997 2099646.47131 37.7458015482156 -122.40762520763701 (37.7458015482156, -122.407625207637)
154537 233603 2 41 199 Franconia St 9 23 1 1     6 Width 3ft   6010152.72418 2099634.5230799997 37.7457692517475 -122.40759281407101 (37.7457692517475, -122.407592814071)
150305 234860 2 168 160 Carnelian Way 2 23 1 1     6     6000574.359 2100517.55086 37.7476530184698 -122.44077666170799 (37.7476530184698, -122.440776661708)
Powered by Datasette · Query took 3.392ms · Data source: data.sfgov.org