Changes between Version 39 and Version 40 of Cookbook CCM21_France

Timestamp:

Jun 22, 2011 2:40:46 PM (14 years ago)

Author:

celine

Comment:

--

Cookbook CCM21_France

@@ -315 +315 @@
   USING GIST ( the_geom GIST_GEOMETRY_OPS );  
 }}}
+
+'''POSE EMU EXTRACTION'''
+{{{
+---Anglian River basin
+DROP TABLE IF EXISTS ccm21.riversegments_Anglian;   
+CREATE TABLE  ccm21.riversegments_Anglian AS
+    SELECT * FROM ccm21.riversegments
+        WHERE wso1_id IN (SELECT wso1_id FROM europe.wso1 WHERE area='Anglian');
+ALTER TABLE ccm21.riversegments_Anglian ADD CONSTRAINT c_pk_gid_riversegments_Anglian 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', 'riversegments_Anglian ', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
+FROM ccm21.riversegments_Anglian LIMIT 1;
+alter table ccm21.riversegments_Anglian add CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2);
+alter table ccm21.riversegments_Anglian add    CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTILINESTRING'::text OR the_geom IS NULL);
+alter table ccm21.riversegments_Anglian add  CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 3035);
+CREATE INDEX index_riversegments_Anglian ON ccm21.riversegments_Anglian  USING GIST ( the_geom GIST_GEOMETRY_OPS ); 
+
+---Western River Basin
+DROP TABLE IF EXISTS ccm21.riversegments_Western;   
+CREATE TABLE  ccm21.riversegments_Western AS
+    SELECT * FROM ccm21.riversegments
+        WHERE wso1_id IN (SELECT wso1_id FROM europe.wso1 WHERE area='Western');
+ALTER TABLE ccm21.riversegments_Western ADD CONSTRAINT c_pk_gid_riversegments_Western 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', 'riversegments_Western ', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
+FROM ccm21.riversegments_Western LIMIT 1;
+alter table ccm21.riversegments_Western add CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2);
+alter table ccm21.riversegments_Western add    CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTILINESTRING'::text OR the_geom IS NULL);
+alter table ccm21.riversegments_Western add  CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 3035);
+CREATE INDEX index_riversegments_Western ON ccm21.riversegments_Western  USING GIST ( the_geom GIST_GEOMETRY_OPS ); 
+}}}