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

• Convert it into utf8 in notepad

Encodage> Convertir en UTF-8

And save the file as : tidalutf8

• Use psql to restore the file while connecting to eda2.0 ... change the port if necessary (cedric : 5433)

  C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f tidalutf8.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;