Skip to content

Instantly share code, notes, and snippets.

@davo

davo/Merge.sql

Last active August 29, 2015 14:01
Show Gist options
  • Save davo/67e98c40b26a0466eaa9 to your computer and use it in GitHub Desktop.
Save davo/67e98c40b26a0466eaa9 to your computer and use it in GitHub Desktop.
Download ZIP
Merge polygons via PostGIS Query on CartoDB
Raw
Readme.md

I'm trying to merge on the fly the polygons of several neighborhoods but I can't make it.

I used this question on gis.stackexchange as reference.

I tried to merge it using QuantumGIS but the results, based on the same data, are different.

Raw
Merge.sql
SELECT ST_Union(ST_makeValid( ST_SnapToGrid(the_geom_webmercator ,0.0001))) FROM barrios GROUP BY barrios.the_geom_webmercator
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment