Skip to content

Instantly share code, notes, and snippets.

@gledsoncruz

gledsoncruz/st_disjoint.sql

Created March 27, 2017 13:41
Show Gist options
  • Save gledsoncruz/2ff603449405617a8068ae2cdf422acb to your computer and use it in GitHub Desktop.
Save gledsoncruz/2ff603449405617a8068ae2cdf422acb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
st_disjoint.sql
SELECT sum(st_area(e.the_geom)) AS total_ed FROM edificacao e, loteamentos l
WHERE st_disjoint(e.the_geom, l.the_geom) AND l.nome = 'LOTEAMENTO JARDIM IMPERIAL'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment