Changes between Version 84 and Version 85 of CLC Join

Timestamp:

Jun 5, 2010 12:17:21 PM (15 years ago)

Author:

cedric

Comment:

--

CLC Join

@@ -962 +962 @@
 }}}
   [[Image(source:data/Docs/trac/clc/remaining_catchment_france.png,600px)]] [[BR]]
+Calculating for France and outside from France
+{{{
+#!sql
+BEGIN;
+INSERT INTO clc.clipped 
+        SELECT clc.gid as clcgid, sub1.gid,code_00, ST_Multi(ST_Intersection(clc.the_geom, sub1.the_geom)) the_geom
+                FROM  clc.clc00_v2_europe clc 
+                INNER JOIN 
+                (SELECT gid, c.the_geom FROM ccm21.catchments c where wso1_id IN (
+                        SELECT wso1_id FROM clc.remaining_catchment_france)  ) AS sub1
+                        
+                ON  ST_Intersects (sub1.the_geom,clc.the_geom);
+COMMIT;  
+
+BEGIN;
+INSERT INTO clc.clipped 
+        SELECT clc.gid as clcgid, sub1.gid,code_00, ST_Multi(ST_Intersection(clc.the_geom, sub1.the_geom)) the_geom
+                FROM  clc.clc00_v2_europe clc 
+                INNER JOIN 
+                (SELECT gid, c.the_geom FROM ccm21.catchments c where wso1_id IN (
+                        SELECT wso1_id FROM clc.remaining_catchment
+                        EXCEPT (SELECT wso1_id FROM clc.remaining_catchment_france ))) AS sub1
+                        
+                ON  ST_Intersects (sub1.the_geom,clc.the_geom);
+COMMIT;                 
+}}}
 {{{
 #!html