back to the first page [..][[BR]]
back to ["Ecological regions"][[BR]]

= Download and load =
Digital map of European ecological regions (DMEER) : http://www.eea.europa.eu/data-and-maps/data/digital-map-of-european-ecological-regions
version 2003

Projection in Lambert Azimuthal Equal Area (LAEA) srid=2163 --> transformed into ETRS LAEA srid=3035[[BR]]

{{{
D:
CD D:\Celine Jouanin\Ecological regions
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 2163 -W LATIN1 dmeereea4074i_arc ecologicalregion_arc > ecologicalregion_arc.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 2163 -W LATIN1 dmeereea4074i_label ecologicalregion_label > ecologicalregion_label.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 2163 -W LATIN1 dmeereea4074i_polygon ecologicalregion_polygon > ecologicalregion_polygon.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 2163 -W LATIN1 dmeereea4074i_tic ecologicalregion_tic > ecologicalregion_tic.sql
}}}

{{{
--Céline
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f ecologicalregion_arc.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f ecologicalregion_label.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f ecologicalregion_polygon.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f ecologicalregion_tic.sql
--Cédric
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f ecologicalregion_arc.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f ecologicalregion_label.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f ecologicalregion_polygon.sql
C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f ecologicalregion_tic.sql
}}}

    * Create schema dmeer2003 et changement de schéma des tables (qui sont sous public)
{{{
--- In sql editor 
CREATE SCHEMA dmeer2003;
ALTER TABLE ecologicalregion_arc SET SCHEMA dmeer2003;
ALTER TABLE ecologicalregion_label SET SCHEMA dmeer2003;
ALTER TABLE ecologicalregion_polygon SET SCHEMA dmeer2003;
ALTER TABLE ecologicalregion_tic SET SCHEMA dmeer2003;
}}}

    * Changement du type de projection : LAEA (srid 2163) --> ETRS1989-LAEA (srid 3035)
{{{
ALTER TABLE dmeer2003.ecologicalregion_arc DROP CONSTRAINT enforce_srid_the_geom;
UPDATE dmeer2003.ecologicalregion_arc SET the_geom = ST_transform(the_geom, 3035); 
ALTER TABLE dmeer2003.ecologicalregion_arc ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
ALTER TABLE dmeer2003.ecologicalregion_label DROP CONSTRAINT enforce_srid_the_geom;
UPDATE dmeer2003.ecologicalregion_label SET the_geom = ST_transform(the_geom, 3035); 
ALTER TABLE dmeer2003.ecologicalregion_label ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
ALTER TABLE dmeer2003.ecologicalregion_polygon DROP CONSTRAINT enforce_srid_the_geom;
UPDATE dmeer2003.ecologicalregion_polygon SET the_geom = ST_transform(the_geom, 3035); 
ALTER TABLE dmeer2003.ecologicalregion_tic ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
ALTER TABLE dmeer2003.ecologicalregion_tic DROP CONSTRAINT enforce_srid_the_geom;
UPDATE dmeer2003.ecologicalregion_polygon SET the_geom = ST_transform(the_geom, 3035); 
ALTER TABLE dmeer2003.ecologicalregion_tic ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
}}}