Skip to content

Instantly share code, notes, and snippets.

@ramiroaznar

ramiroaznar/dwithin.sql Secret

Created May 24, 2016 10:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ramiroaznar/95c7491cfc187dab362dc608eeb9c3a4 to your computer and use it in GitHub Desktop.
Save ramiroaznar/95c7491cfc187dab362dc608eeb9c3a4 to your computer and use it in GitHub Desktop.
Download ZIP
Selecting stations within a minimun distance of 100m from the L1 metro line
Raw
dwithin.sql
SELECT
a.*
FROM
estaciones a,
lineas b
WHERE
ST_DWithin(
a.the_geom_webmercator,
b.the_geom_webmercator,
100
)
AND
b.name ilike 'L1';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment