back to the first page ..
back to Ecological regions
Go to Cookbook CCM21_EcologicalRegion

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:\CelineJouanin\Ecological regions
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -W LATIN1 dmeereea4074i_arc_Project ecologicalregion_arc > ecologicalregion_arc.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -W LATIN1 dmeereea4074i_label_Project ecologicalregion_label > ecologicalregion_label.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -W LATIN1 dmeereea4074i_polygon_Projec ecologicalregion_polygon > ecologicalregion_polygon.sql
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -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 ecoregion2003 (dmeer2003) et changement de schéma des tables (qui sont sous public)

  --- In sql editor 
  CREATE SCHEMA ecoregion2003;
  ALTER TABLE ecologicalregion_arc SET SCHEMA ecoregion2003;
  ALTER TABLE ecologicalregion_label SET SCHEMA ecoregion2003;
  ALTER TABLE ecologicalregion_polygon SET SCHEMA ecoregion2003;
  ALTER TABLE ecologicalregion_tic SET SCHEMA ecoregion2003;
  

--- In sql editor 
INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
SELECT '', 'ecoregion2003', 'ecologicalregion_arc', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
FROM ecoregion2003.ecologicalregion_arc LIMIT 1;

INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
SELECT '', 'ecoregion2003', 'ecologicalregion_label', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
FROM ecoregion2003.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 '', 'ecoregion2003', 'ecologicalregion_polygon', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
FROM ecoregion2003.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 '', 'ecoregion2003', 'ecologicalregion_tic', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
FROM ecoregion2003.ecologicalregion_tic LIMIT 1;

In blue : CCM, In red : Ecological regions