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;
}}}