| Version 25 (modified by celine, 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
--- 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
- Create the schema CLC
--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 join
