back to first page ..

Download and load the data

54 european countries as :

gid	name
2	Andorra
4	Belgium
8	Denmark
10	Finland
11	France
12	Germany
14	Greece
17	Ireland
19	Italy (Sardaigne, Sicile)
27	Monaco
30	Norway
32	Portugal
37	Spain
38	Sweden
40	United Kingdom
47	Iceland

Projection : WGS84 (pas la projection ETRS1989-LAEA) --> srid=4326

d:
cd D:\CelineJouanin\Limites administratives Europe
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -I european_countries_WGS84.shp limiteeurope > limiteeurope.sql

--Céline
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f limiteeurope.sql 
--Cédric
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f limiteeurope.sql 

• Create schema europe et changement de schéma de la table limiteeurope (qui est sous public)

  --- In sql editor 
  CREATE SCHEMA europe;
  ALTER TABLE limiteeurope SET SCHEMA europe;
  

• Changement du type de projection : WGS84 (srid 4326) --> ETRS1989-LAEA (srid 3035)

  ALTER TABLE europe.limiteeurope DROP CONSTRAINT enforce_srid_the_geom;
  UPDATE europe.limiteeurope SET the_geom = ST_transform(the_geom, 3035); 
  ALTER TABLE europe.limiteeurope ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
  

Now we will only use europe instead of France

delete from europe.wso where area='France';
insert into europe.wso (wso_id, area) (select wso_id, area from france.wso );
ALTER TABLE europe.wso ALTER COLUMN area TYPE character varying(25);
insert into europe.wso (wso_id, area) (select wso_id, area from france.wso1 except (select  wso_id, area from france.wso1 where area='France'));

Europe.wso

Récupérer l'ensemble du réseau hydrographique pour chaque pays européens comme dans : Cookbook CCM21_France
Cookbook CCM21_Europe