Changes between Version 67 and Version 68 of CookBook join BDMAP_CCM

Timestamp:

Mar 1, 2010 3:36:14 PM (15 years ago)

Author:

cedric

Comment:

--

CookBook join BDMAP_CCM

@@ -183 +183 @@
 }}}
 
+{{{
+alter table stationsp2 add CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2);
+alter table stationsp2 add  CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'POINT'::text OR the_geom IS NULL);
+alter table stationsp2 add  CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 3035);
+}}}
+
 == 6. Joining the riversegments layer with the stationsp2 layer ==