Changes between Version 8 and Version 9 of CLC download and load

Timestamp:

May 25, 2010 10:58:05 AM (15 years ago)

Author:

celine

Comment:

--

CLC download and load

@@ -18 +18 @@
 
 {{{
-#!sql
 -- REM se placer dans le répertoire ou sont les données
 D:
 cd D:\Celine Jouanin\CLC\CLC00_v2_Europe_mai_2010\
-C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -c -g the_geom -I clc00_v2_Europe_Merge.shp clc00_v2_Europe > clc00_v2_Europe.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -c -g the_geom -I clc00_v2_europe.shp clc00_v2_europe > clc00_v2_europe.sql
+}}}
+Problem : 0 ko into the sql file
+
+{{{
 C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f clc00_v2_Europe.sql 
 }}}
@@ -33 +36 @@
 select SRID (the_geom) FROM CLC.clc00_v2_europe;
 }}}
+
+   * 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);
+}}}