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]], PROJECTION[!"Lambert_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

In ArcGis change the coordinate system (follow this Cookbook Change the coordinate system)

D:
CD D:\Celine Jouanin\Ecological regions
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4052 -W LATIN1 dmeereea4074i_arc_Project ecologicalregion_arc > ecologicalregion_arc.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 2163 -W LATIN1 dmeereea4074i_label_Project ecologicalregion_label > ecologicalregion_label.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -W LATIN1 dmeereea4074i_polygon_Project ecologicalregion_polygon > ecologicalregion_polygon.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -W LATIN1 dmeereea4074i_tic_Project 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;