Skip to content

Instantly share code, notes, and snippets.

@pigreco

pigreco/poligonize.sql

Created September 6, 2018 14:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pigreco/65d52f3b64a8b2b1b9bce2344ab28d9b to your computer and use it in GitHub Desktop.
Save pigreco/65d52f3b64a8b2b1b9bce2344ab28d9b to your computer and use it in GitHub Desktop.
Download ZIP
poligonizza un vettore di linee
Raw
poligonize.sql
CREATE TABLE aggr_polyg (id INTEGER PRIMARY KEY);
SELECT AddGeometryColumn('aggr_polyg', 'geom', 3004, 'MULTIPOLYGON', 'XY');
INSERT INTO aggr_polyg
SELECT NULL, ST_Polygonize(geometry) FROM ambiti_reg;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment