Changes between Version 81 and Version 82 of CLC Join

Timestamp:

Jun 4, 2010 5:08:06 PM (15 years ago)

Author:

cedric

Comment:

--

CLC Join

@@ -928 +928 @@
   [[Image(source:data/Docs/trac/clc/clipped.png,600px)]] [[BR]]
 {{{
+#!sql
 CREATE TABLE clc.remaining_catchment AS(        
         SELECT * FROM ccm21.catchments where gid in(
@@ -934 +935 @@
         
 );
-}}}
-
-
-
+ALTER TABLE clc.remaining_catchment add CONSTRAINT c_pk_id_remaining_catchment  PRIMARY KEY (gid);
+alter table clc.remaining_catchment add CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2);
+alter table clc.remaining_catchment add  CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTIPOLYGON'::text OR the_geom IS NULL);
+alter table clc.remaining_catchment add  CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 3035);
+}}}
+
+
+Using ST_intersection has suppressed the polygons outside catchment
   [[Image(source:data/Docs/trac/clc/clipped_and_catchment.png,600px)]] [[BR]]
+Remaining catchmentsis the table of the catchment not already processed
   [[Image(source:data/Docs/trac/clc/remaining_catchment.png,600px)]] [[BR]]
+It is a little bit too large to process as one unit
   [[Image(source:data/Docs/trac/clc/remaining_catchment2.png,600px)]] [[BR]]
+{{{
+#!sql
+-- remaining catchments intersecting with france in a table for Qgis
+CREATE TABLE clc.remaining_catchment_france AS( 
+        SELECT * FROM clc.remaining_catchment  WHERE wso1_id IN (
+                SELECT wso1_id FROM clc.remaining_catchment crc JOIN france.departement fd
+                ON ST_Intersects(crc.the_geom,fd.the_geom))     
+);
+ALTER TABLE clc.remaining_catchment_france add CONSTRAINT c_pk_id_remaining_catchment_france  PRIMARY KEY (gid);
+alter table clc.remaining_catchment_france add CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2);
+alter table clc.remaining_catchment_france add  CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTIPOLYGON'::text OR the_geom IS NULL);
+alter table clc.remaining_catchment_france add  CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 3035);
+}}}
+
 {{{
 #!html