Changes between Version 5 and Version 6 of CLC Join

Timestamp:

May 27, 2010 6:06:47 PM (15 years ago)

Author:

cedric

Comment:

--

CLC Join

@@ -27 +27 @@
 ALTER TABLE clc.clipped_bretagne add column id serial PRIMARY KEY;
 
+-- la requete globale
+SELECT intersected.clcgid, intersected.gid, clipped_geom
+FROM (SELECT clc.gid as clcgid, c.gid, ST_Intersection(clc.the_geom, c.the_geom) AS clipped_geom
+        FROM  clc.clc00_v2_europe clc INNER JOIN ccm21.catchments c
+        ON  ST_Intersects (c.the_geom,clc.the_geom)
+        where substring(code_00 from 1 for 1)='1' )  AS intersected;            
+
+
 }}}