Changes between Initial Version and Version 1 of Download and load CLC

Timestamp:

May 19, 2010 11:19:29 AM (15 years ago)

Author:

celine

Comment:

--

Download and load CLC

@@ +1 @@
+back to first page [..][[BR]]
+back to ["Corine Land Cover"][[BR]]
+back to ["CookBook Eda"][[BR]]
+
+= Download and Load the CLC (Corine Land Cover) layer =
+
+{{{
+REM se placer dans le répertoire ou sont les données
+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 CLC06_FR_L2E.shp CLC06_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 
+}}}
+
+{{{
+--- In sql editor 
+CREATE SCHEMA CLC;
+ALTER TABLE clc06_fr_l2e SET SCHEMA CLC;
+select SRID (the_geom) FROM CLC.clc06_fr_l2e;
+}}}