Changes between Version 14 and Version 15 of CLC download and load

Timestamp:

May 27, 2010 3:40:45 PM (15 years ago)

Author:

celine

Comment:

--

CLC download and load

@@ -156 +156 @@
 CREATE SCHEMA CLC;
 ALTER TABLE clc00_v2_europe SET SCHEMA CLC;
-select SRID (the_geom) FROM CLC.clc00_v2_europe;
+select SRID (the_geom) FROM clc.clc00_v2_europe;
 }}}
 
    * Change the srid
 {{{
-ALTER TABLE CLC.clc00_v2_europe DROP CONSTRAINT enforce_srid_the_geom;
-UPDATE CLC.clc00_v2_europe SET the_geom = ST_transform(the_geom, 3035); 
-ALTER TABLE CLC.clc00_v2_europe ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
+ALTER TABLE clc.clc00_v2_europe DROP CONSTRAINT enforce_srid_the_geom;
+UPDATE clc.clc00_v2_europe SET the_geom = ST_transform(the_geom, 3035); 
+ALTER TABLE clc.clc00_v2_europe ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
 }}}