back to first page ..
back to CookBook Eda
back to Tidal limit

Download and load the dataset at : ==

​http://www.eea.europa.eu/data-and-maps/data/hydrodynamics-and-sea-level-rise

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

d:
cd D:\CelineJouanin\Hydrodynamics\hydrodynamics_sealevelrise\Hydrodynamics_SeaLevelRise
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4258 -I HDEURK100kV1.shp tidal > tidal.sql

C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f tidal.sql 

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

  --- In sql editor 
  CREATE SCHEMA tidal;
  ALTER TABLE tidal SET SCHEMA tidal;
  

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

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