Changes between Version 3 and Version 4 of CLC download and load

Timestamp:

May 20, 2010 2:16:46 PM (15 years ago)

Author:

celine

Comment:

--

CLC download and load

@@ -21 +21 @@
 D:
 cd D:\Celine Jouanin\CLC\CLC06_FR_L2E_SHP
-C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -c -g the_geom -I -W UTF-8 -N skip CLC00_v2_Merge.shp CLC00_FR_L2E > CLC06_FR_L2E.sql
-C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f CLC06_FR_L2E.sql 
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -c -g the_geom -I -W UTF-8 -N skip CLC00_v2_Europe_Merge.shp CLC00_v2_Europe > CLC00_v2_Europe.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f CLC00_v2_Europe.sql 
 }}}
 
@@ -28 +28 @@
 --- In sql editor 
 CREATE SCHEMA CLC;
-ALTER TABLE clc06_fr_l2e SET SCHEMA CLC;
-select SRID (the_geom) FROM CLC.clc06_fr_l2e;
+ALTER TABLE clc00_v2_europe SET SCHEMA CLC;
+select SRID (the_geom) FROM CLC.clc00_v2_europe;
 }}}