Skip to content

Instantly share code, notes, and snippets.

@jhass

jhass/map.geojson Secret

Created April 26, 2014 14:54
Show Gist options
  • Save jhass/cd7b1ba31b38c6826beb to your computer and use it in GitHub Desktop.
Save jhass/cd7b1ba31b38c6826beb to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
map.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@jhass
Copy link
Author

jhass commented Apr 26, 2014

SELECT ST_AsGeoJSON(linestring) FROM atomic_ways JOIN polygons ON ST_DWITHIN(polygon::geography, linestring::geography, 10) WHERE polygons.id = 5386

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment