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

[[Image(source:data/Docs/trac/European countries/european countries.jpg,750px)]]

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
{{{
#!sql
delete from europe.wso where area='France';
insert into europe.wso (wso_id, area) (select wso_id, area from france.wso );
insert into europe.wso (wso_id, area) (select wso_id, area from france.wso1 where 
}}}

= A FAIRE =
Récupérer l'ensemble du réseau hydrographique pour chaque pays européens comme dans : ["Cookbook CCM21_France"][[BR]]
["Cookbook CCM21_Europe"]