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

Timestamp:

May 27, 2010 2:01:57 PM (15 years ago)

Author:

celine

Comment:

--

CLC download and load

@@ -47 +47 @@
 C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_222.shp clc00_v2_europe> clc00_v2_europe_222.sql
 C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_223.shp clc00_v2_europe> clc00_v2_europe_223.sql
-
 C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_231.shp clc00_v2_europe> clc00_v2_europe_231.sql
 
@@ -149 +148 @@
 
 }}}
+["psql pour Céline"]
 
+   * Create the schema CLC
 {{{
 #!sql
@@ -160 +161 @@
    * Change the srid
 {{{
-ALTER TABLE clc.clc06_fr_l2e DROP CONSTRAINT enforce_srid_the_geom;
-UPDATE clc.clc06_fr_l2e SET the_geom = ST_transform(the_geom, 3035); 
-ALTER TABLE clc.clc06_fr_l2e 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);
 }}}