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

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