Skip to content

Instantly share code, notes, and snippets.

@gledsoncruz

gledsoncruz/soma_areas_ocupadas_por_zonas.sql

Last active August 29, 2015 14:03
Show Gist options
  • Save gledsoncruz/f8a9ea13e141850a48b2 to your computer and use it in GitHub Desktop.
Save gledsoncruz/f8a9ea13e141850a48b2 to your computer and use it in GitHub Desktop.
Download ZIP
soma_areas_ocupadas_por_zonas
Raw
soma_areas_ocupadas_por_zonas.sql
SELECT b.id, ROUND(SUM(ST_AREA(e.the_geom)/1000)::numeric,2) as area_ocupada,
ROUND(ST_AREA(b.the_geom)::numeric/1000,2) as area_zona
FROM areas_ocupadas e, gis.zoneamentos b
WHERE ST_INTERSECTS(e.the_geom, b.the_geom)
GROUP BY b.id, b.the_geom
ORDER BY b.id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment