Changes between Version 28 and Version 29 of Cookbook CCM21_France

Timestamp:

Jul 27, 2010 3:24:03 PM (15 years ago)

Author:

cedric

Comment:

--

Cookbook CCM21_France

@@ -112 +112 @@
 CREATE INDEX index_riversegments_france ON ccm21.riversegments_france
   USING GIST ( the_geom GIST_GEOMETRY_OPS ); 
+}}}
 
+{{{
+-- creating a table for catchments france
+DROP TABLE IF EXISTS ccm21.catchments_france;   
+CREATE TABLE  ccm21.catchments_france AS
+SELECT * FROM ccm21.catchments
+WHERE wso_id IN (SELECT wso_id FROM france.wso WHERE area='france'); 
+               
+ALTER TABLE ccm21.catchments_france ADD CONSTRAINT c_pk_gid_catchments_france PRIMARY KEY  (gid);
+INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
+SELECT '', 'ccm21', 'catchments_france', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
+FROM ccm21.catchments_france LIMIT 1;
+
+alter table ccm21.catchments_france add CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2);
+alter table ccm21.catchments_france add    CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTIPOLYGON'::text OR the_geom IS NULL);
+alter table ccm21.catchments_france add  CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 3035);
+CREATE INDEX index_catchments_france ON ccm21.catchments_france
+  USING GIST ( the_geom GIST_GEOMETRY_OPS ); 
+CREATE INDEX indexcatchmentsfrance_wso1_id
+  ON ccm21.catchments
+  USING btree
+  (wso1_id);
 }}}