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

In ArcGis merge the different layers

Add the differents layers on ArcGis : clc00_v2_code_111, clc00_v2_code_112,...

In Data Management Tools > General > Merge

• Input Datasets : clc00_v2_code_111, clc00_v2_code_112,...
• Output Dataset : change the directory if it's necessary and change the name of the shape file : clc00_v2_Europe_Merge.shp

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

--- In sql editor 
CREATE SCHEMA CLC;
ALTER TABLE clc00_v2_europe SET SCHEMA CLC;
select SRID (the_geom) FROM CLC.clc00_v2_europe;