Changes between Version 37 and Version 38 of Cookbook CCM21_France

Timestamp:

Mar 9, 2011 2:36:42 PM (14 years ago)

Author:

celine

Comment:

--

Cookbook CCM21_France

@@ -282 +282 @@
 CREATE INDEX index_riversegments_Meuse ON ccm21.riversegments_Meuse
   USING GIST ( the_geom GIST_GEOMETRY_OPS );  
-}}}
+
+---SeineNormandie
+DROP TABLE IF EXISTS ccm21.riversegments_SeineNormandie;   
+CREATE TABLE  ccm21.riversegments_SeineNormandie AS
+    SELECT * FROM ccm21.riversegments
+        WHERE wso_id IN (SELECT wso_id FROM europe.wso WHERE area='SeineNormandie');
+ALTER TABLE ccm21.riversegments_SeineNormandie ADD CONSTRAINT c_pk_gid_riversegments_SeineNormandie 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_SeineNormandie', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
+FROM ccm21.riversegments_SeineNormandie LIMIT 1;
+alter table ccm21.riversegments_SeineNormandie add CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2);
+alter table ccm21.riversegments_SeineNormandie add    CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTILINESTRING'::text OR the_geom IS NULL);
+alter table ccm21.riversegments_SeineNormandie add  CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 3035);
+CREATE INDEX index_riversegments_SeineNormandie ON ccm21.riversegments_SeineNormandie
+  USING GIST ( the_geom GIST_GEOMETRY_OPS );  
+}}}