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:\Celine Jouanin\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;