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