Changes between Version 24 and Version 25 of Cookbook CCM21_France

Timestamp:

Jul 27, 2010 2:49:58 PM (15 years ago)

Author:

cedric

Comment:

--

Cookbook CCM21_France

@@ -107 +107 @@
 SELECT '', 'ccm21', 'riversegments_Bretagne', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
 FROM ccm21.riversegments_France LIMIT 1;
+alter table ccm21.riversegments_France add CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2);
+alter table ccm21.riversegments_France add    CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTILINESTRING'::text OR the_geom IS NULL);
+alter table clc.ccm21.riversegments_France add  CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 3035);
+CREATE INDEX index_riversegments_France ON ccm21.riversegments_France
+  USING GIST ( the_geom GIST_GEOMETRY_OPS ); 
+
 }}}