back to first page [..] [[BR]]
back to ["CookBook Eda"] [[BR]]
back to ["Tidal limit"] [[BR]]

== 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:\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);
}}}