| Version 21 (modified by cedric, 15 years ago) (diff) |
|---|
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 3035 -c -g the_geom -I clc00_v2_code_111.shp 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
- Create the schema CLC
--- 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
NO USE ! IT's ALREADY 3035
ALTER TABLE clc.clc00_v2_europe DROP CONSTRAINT enforce_srid_the_geom;
UPDATE clc.clc00_v2_europe SET the_geom = ST_transform(the_geom, 3035);
ALTER TABLE clc.clc00_v2_europe ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
- CLC Analysis
- CLC join
