Skip to content

Instantly share code, notes, and snippets.

@pigreco

pigreco/query_mm_2.sql

Created November 15, 2017 10:26
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/bfe71adfbbf709e3a53daa43293084f7 to your computer and use it in GitHub Desktop.
Save pigreco/bfe71adfbbf709e3a53daa43293084f7 to your computer and use it in GitHub Desktop.
Download ZIP
articolo su gfoss.it seconda query
Raw
query_mm_2.sql
SELECT t.pk_uid AS rowid, t.cod_reg AS cod_reg, t.cod_istat AS cod_istat,
       t.pro_com AS pro_com, t.sez2011 AS sez201, t.sez AS sez,
       t.loc2011 AS loc2011, t.cod_loc AS cod_loc, t.geometry AS geom
FROM test_celle AS t,
     (SELECT ST_Buffer(geom, 250) AS geom FROM input) AS b
WHERE ST_Intersects (t.geometry, b.geom) = 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment