back to the first page ..
back to Ecological regions

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)GCS Sphere ARC INFO srid=???? --> transformed into ETRS LAEA srid=3035
The projection is wrong PROJCS["Sphere_ARC_INFO_Lambert_Azimuthal_Equal_Area",GEOGCS["GCS_Sphere_ARC_INFO",DATUM["D_Sphere_ARC_INFO",SPHEROID["Sphere_ARC_INFO",6370997.0,0.0]], PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]], PROJECTIONLambert_Azimuthal_Equal_Area?,PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",9.0],PARAMETER["Latitude_Of_Origin",48.0],UNIT["Meter",1.0]]

select srid, srtext, proj4text from spatial_ref_sys where srtext ILIKE '%Lambert_Azimuthal_Equal_Area%';

Il semble que 3035 soit projeté à 52 (latitude) et ici on a un 48.... Le SRID n'est pas dans la liste fournie avec postgis, et je ne suis pas sûr de certains paramètres dans la liste, il faut faire la conversion dans Argis

D:
CD D:\Celine Jouanin\Ecological regions
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4052 -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 4326 -W LATIN1 dmeereea4074i_polygon ecologicalregion_polygon > ecologicalregion_polygon.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -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);
  

INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
SELECT '', 'dmeer2003', 'ecologicalregion_label', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
FROM dmeer2003.ecologicalregion_label LIMIT 1;

INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
SELECT '', 'dmeer2003', 'ecologicalregion_polygon', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
FROM dmeer2003.ecologicalregion_polygon LIMIT 1;

INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
SELECT '', 'dmeer2003', 'ecologicalregion_tic', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
FROM dmeer2003.ecologicalregion_tic LIMIT 1;