back to first page [..]

= Download and load the data =

54 european countries as :
||gid||name||
||4||Belgium||
||8||Denmark||
||10||Finland||
||11||France||
||12||Germany||
||14||Greece||
||17||Ireland||
||19||Italy (Sardaigne, Sicile)||
||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:\Celine Jouanin\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);
}}}