sf-trees

Data source: data.sfgov.org

Custom SQL query returning 8 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
83588 6719 3 43 1200X Fairfax Ave 16 1 1 2     12 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191)
92066 49276 1 43 2X Spear St 16 1 1 1   02/07/2003 12:00:00 AM     Permit Number 46305 6014371.0 2116872.0 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763)
106524 111799 2 43 55X SHERMAN ST 16 1 1 3       3x3   6010857.0 2110997.0 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357)
108574 49238 1 43 500 Howard St 16 1 1 1   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.39615519799999 (37.7885414925604, -122.396155198)
110157 15162 1 43 895X Mission St 16 1 1 5     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907)
122808 23541 3 43 2750 Van Ness Ave 16 1 1 2     30 3x3   6005750.94301 2119762.60418 37.800788728704504 -122.42424483346001 (37.8007887287045, -122.42424483346)
127253 110710 2 43 2999X Turk St 16 1 1 1       3x3   5996638.0 2111487.0 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531)
140077 110997 1 43 245x North Point St 16 1 1 1           6009556.06624176 2121873.83782792 37.806799769840296 -122.41122668881 (37.8067997698403, -122.41122668881)
Powered by Datasette · Query took 12.869ms · Data source: data.sfgov.org