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\CLC00_v2_Europe_mai_2010\
--cedric
cd C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\CLC\CLC00_v2_Europe_mai_2010

C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -c -g the_geom -I clc00_v2_code_521.shp clc00_v2_europe> clc00_v2_europe_521.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_522.shp clc00_v2_europe> clc00_v2_europe_522.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_111.shp clc00_v2_europe> clc00_v2_europe_111.sql

C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_112.shp clc00_v2_europe> clc00_v2_europe_112.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_121.shp clc00_v2_europe> clc00_v2_europe_121.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_131.shp clc00_v2_europe> clc00_v2_europe_131.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_142.shp clc00_v2_europe> clc00_v2_europe_142.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_211.shp clc00_v2_europe> clc00_v2_europe_211.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_212.shp clc00_v2_europe> clc00_v2_europe_212.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_213.shp clc00_v2_europe> clc00_v2_europe_213.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_221.shp clc00_v2_europe> clc00_v2_europe_221.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_223.shp clc00_v2_europe> clc00_v2_europe_223.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_231.shp clc00_v2_europe> clc00_v2_europe_231.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_241.shp clc00_v2_europe> clc00_v2_europe_241.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_244.shp clc00_v2_europe> clc00_v2_europe_244.sql

C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_521.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_522.sql  
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_111.sql  

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

• Change the srid

  ALTER TABLE clc.clc06_fr_l2e DROP CONSTRAINT enforce_srid_the_geom;
  UPDATE clc.clc06_fr_l2e SET the_geom = ST_transform(the_geom, 3035); 
  ALTER TABLE clc.clc06_fr_l2e ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);