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 =

== 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  [[BR]]
The layer in these files are in shape format [[BR]]
unzip the files [[BR]]

== 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
{{{
#!sql
--- In sql editor 
CREATE SCHEMA CLC;
}}}
{{{
-- REM se placer dans le répertoire ou sont les données
D:
cd D:\CelineJouanin\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 3035 -c -g the_geom -I clc00_v2_code_111.shp clc.clc00_v2_europe> clc00_v2_europe_111.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_112.shp clc.clc00_v2_europe> clc00_v2_europe_112.sql

C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_121.shp clc.clc00_v2_europe> clc00_v2_europe_121.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_122.shp clc.clc00_v2_europe> clc00_v2_europe_122.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_123.shp clc.clc00_v2_europe> clc00_v2_europe_123.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_124.shp clc.clc00_v2_europe> clc00_v2_europe_124.sql

C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_131.shp clc.clc00_v2_europe> clc00_v2_europe_131.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_132.shp clc.clc00_v2_europe> clc00_v2_europe_132.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_133.shp clc.clc00_v2_europe> clc00_v2_europe_133.sql

C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_141.shp clc.clc00_v2_europe> clc00_v2_europe_141.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_142.shp clc.clc00_v2_europe> clc00_v2_europe_142.sql

C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_211.shp clc.clc00_v2_europe> clc00_v2_europe_211.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_212.shp clc.clc00_v2_europe> clc00_v2_europe_212.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_213.shp clc.clc00_v2_europe> clc00_v2_europe_213.sql

C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_221.shp clc.clc00_v2_europe> clc00_v2_europe_221.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_222.shp clc.clc00_v2_europe> clc00_v2_europe_222.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_223.shp clc.clc00_v2_europe> clc00_v2_europe_223.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_231.shp clc.clc00_v2_europe> clc00_v2_europe_231.sql

C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_241.shp clc.clc00_v2_europe> clc00_v2_europe_241.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_242.shp clc.clc00_v2_europe> clc00_v2_europe_242.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_243.shp clc.clc00_v2_europe> clc00_v2_europe_243.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_244.shp clc.clc00_v2_europe> clc00_v2_europe_244.sql

C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_311.shp clc.clc00_v2_europe> clc00_v2_europe_311.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_312.shp clc.clc00_v2_europe> clc00_v2_europe_312.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_313.shp clc.clc00_v2_europe> clc00_v2_europe_313.sql

C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_321.shp clc.clc00_v2_europe> clc00_v2_europe_321.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_322.shp clc.clc00_v2_europe> clc00_v2_europe_322.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_323.shp clc.clc00_v2_europe> clc00_v2_europe_323.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_324.shp clc.clc00_v2_europe> clc00_v2_europe_324.sql

C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_331.shp clc.clc00_v2_europe> clc00_v2_europe_331.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_332.shp clc.clc00_v2_europe> clc00_v2_europe_332.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_333.shp clc.clc00_v2_europe> clc00_v2_europe_333.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_334.shp clc.clc00_v2_europe> clc00_v2_europe_334.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_335.shp clc.clc00_v2_europe> clc00_v2_europe_335.sql

C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_411.shp clc.clc00_v2_europe> clc00_v2_europe_411.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_412.shp clc.clc00_v2_europe> clc00_v2_europe_412.sql

C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_411.shp clc.clc00_v2_europe> clc00_v2_europe_421.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_412.shp clc.clc00_v2_europe> clc00_v2_europe_422.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_423.shp clc.clc00_v2_europe> clc00_v2_europe_423.sql

C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_511.shp clc.clc00_v2_europe> clc00_v2_europe_511.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_512.shp clc.clc00_v2_europe> clc00_v2_europe_512.sql

C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_521.shp clc.clc00_v2_europe> clc00_v2_europe_521.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_522.shp clc.clc00_v2_europe> clc00_v2_europe_522.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -g the_geom clc00_v2_code_523.shp clc.clc00_v2_europe> clc00_v2_europe_523.sql
}}}


{{{
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_111.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_112.sql 
 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_121.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_122.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_123.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_124.sql 

C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_131.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_132.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_133.sql 
 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_141.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_142.sql 

C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_211.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_212.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_213.sql 

C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_221.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_222.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_223.sql 

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

C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_241.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_242.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_243.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f 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_311.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_312.sql 
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_313.sql

C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_321.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_322.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_323.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_324.sql

C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_331.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_332.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_333.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_334.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_335.sql

C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_411.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_412.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_421.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_422.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_423.sql

C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_511.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_512.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_523.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  

}}}
["psql pour Céline"]

   * Create the schema CLC
{{{
#!sql
--select SRID (the_geom) FROM clc.clc.clc00_v2_europe; --3035
select count (*) from clc.clc.clc00_v2_europe-- 2 070 962
}}}

   * ~~ Change the srid ~~
NO USE ! IT's ALREADY 3035
~~
ALTER TABLE clc.clc.clc00_v2_europe DROP CONSTRAINT enforce_srid_the_geom;
UPDATE clc.clc.clc00_v2_europe SET the_geom = ST_transform(the_geom, 3035); 
ALTER TABLE clc.clc.clc00_v2_europe ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
~~

   * CLC Analysis
["CLC Analysis"]
   * CLC join
["CLC Join"]