wiki:Ecological region Download and load

Version 25 (modified by celine, 15 years ago) (diff)

--

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_Projec 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;
    
--- In sql editor 
INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
SELECT '', 'dmeer2003', 'ecologicalregion_arc', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
FROM dmeer2003.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 '', '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;

source:data/Docs/trac/Ecological regions/ecological regions.png In blue : CCM, In red : Ecological regions