back to first page ..
back to Corine Land Cover
back to CookBook Eda

Download and Load the CLC (Corine Land Cover) layer

Download the files in the EEA website

at ​http://www.eea.europa.eu/data-and-maps/data/corine-land-cover-2000-clc2000-seamless-vector-database-1
The layer in these files are in shape format
unzip the files

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;