back to first page [..]
back to ["CookBook Eda"]
back to 

Download and load the dataset at : [[BR]]
http://www.eea.europa.eu/data-and-maps/data/hydrodynamics-and-sea-level-rise [[BR]]

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