sf-trees

Data source: data.sfgov.org

Custom SQL query returning 9 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4 207368 2 4 920 Kirkham St 1 1 1 1     6 Width 1ft   5992009.48044 2105269.9271 37.760210314285004 -122.47073935813 (37.760210314285, -122.47073935813)
31087 119029 2 4 767 44th Ave 2 1 1 1     6 Width 1ft   5982273.77271 2110527.62617 37.7740786267097 -122.504799591882 (37.7740786267097, -122.504799591882)
42762 226645 2 4 3626 24th St 1 10 1 1     8 Width 1ft   6005580.70423 2101999.04422 37.752004698476206 -122.42357029633301 (37.7520046984762, -122.423570296333)
45441 119030 2 4 767 44th Ave 1 1 1 1     10 Width 1ft   5982272.9223 2110539.10892 37.774110104964706 -122.50480338457301 (37.7741101049647, -122.504803384573)
48699 129547 2 4 13 Miller Pl 2 1 1 1     4 Width 1ft   6010075.14286 2116919.1763 37.7932245849005 -122.40908048339399 (37.7932245849005, -122.409080483394)
49684 129501 2 4 2857 Union St 1 9 1 1     3 Width 1ft   5999309.06977 2118008.46724 37.795606494203604 -122.446410054597 (37.7956064942036, -122.446410054597)
52675 191422 2 4 518 Rhode Island St 1 4 1 1     6 Width 1ft   6011739.544919999 2105950.9895099998 37.763201579013796 -122.402549877375 (37.7632015790138, -122.402549877375)
55659 129546 2 4 13 Miller Pl 1 1 1 1     3 Width 1ft   6010072.19276 2116933.78445 37.7932645300763 -122.40909172222099 (37.7932645300763, -122.409091722221)
161992 129502 2 4 2857 Union St 2 9 1 1     3 Width 1ft   5999324.2861 2118011.40576 37.7956154316639 -122.44635761511499 (37.7956154316639, -122.446357615115)
Powered by Datasette · Query took 2.699ms · Data source: data.sfgov.org