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

{{{
-- 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\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  
}}}

{{{
#!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);
}}}