Skip to content

Instantly share code, notes, and snippets.

@gledsoncruz

gledsoncruz/st_touches.sql

Created March 27, 2017 19:05
Show Gist options
  • Save gledsoncruz/0f1cd9b76b75b0440790e40ec52cc272 to your computer and use it in GitHub Desktop.
Save gledsoncruz/0f1cd9b76b75b0440790e40ec52cc272 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
st_touches.sql
--Qual ou quais ruas tocam no limite do bairro SANTO AGOSTINHO?
SELECT lot.nome FROM trecho_logradouros lot, bairros b
WHERE st_touches(lot.the_geom, b.the_geom) AND b.nome = 'SANTO AGOSTINHO'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment