Skip to content

Instantly share code, notes, and snippets.

@gledsoncruz

gledsoncruz/st_dwithin.sql

Created March 28, 2017 14:06
Show Gist options
  • Save gledsoncruz/a7c2eba4b01382f85a9470c23028f70e to your computer and use it in GitHub Desktop.
Save gledsoncruz/a7c2eba4b01382f85a9470c23028f70e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
st_dwithin.sql
--Relacione todos os lotes que estão à 300 metros da Escola Municipal Espírito Santo.
SELECT l.insc_base FROM lotes l, educacao e
WHERE st_dwithin(e.the_geom, l.the_geom, 300) AND e.nome = 'E.M. Espirito Santo'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment