Changes between Version 4 and Version 5 of Ecological regions

Timestamp:

Jul 8, 2010 4:35:13 PM (15 years ago)

Author:

celine

Comment:

--

Ecological regions

@@ -4 +4 @@
 Digital map of European ecological regions : http://www.eea.europa.eu/data-and-maps/data/digital-map-of-european-ecological-regions
 
-Projection in Lambert II ? --> ETRS LAEA
-#A voir
+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 3035 -W LATIN1 dmeereea4074i_arc dmeereea4074i_arc > ecologicalregion_arc.sql
-C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -W LATIN1 dmeereea4074i_label dmeereea4074i_label > ecologicalregion_arc.sql
-C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -W LATIN1 dmeereea4074i_polygon dmeereea4074i_polygon > ecologicalregion_arc.sql
-C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -W LATIN1 dmeereea4074i_tic dmeereea4074i_tic > ecologicalregion_arc.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 2163 -W LATIN1 dmeereea4074i_arc dmeereea4074i_arc > ecologicalregion_arc.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 2163 -W LATIN1 dmeereea4074i_label dmeereea4074i_label > ecologicalregion_label.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 2163 -W LATIN1 dmeereea4074i_polygon dmeereea4074i_polygon > ecologicalregion_polygon.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 2163 -W LATIN1 dmeereea4074i_tic dmeereea4074i_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 ecologicalregion et changement de schéma des tables (qui sont sous public)
+{{{
+--- In sql editor 
+CREATE SCHEMA ecologicalregion;
+ALTER TABLE uga SET SCHEMA ecologicalregion;
 
 }}}
+
+    * Changement du type de projection : RGF93_Lambert_93 (srid 2154) --> ETRS1989-LAEA (srid 3035)
+{{{
+ALTER TABLE uga2010.uga DROP CONSTRAINT enforce_srid_the_geom;
+UPDATE uga2010.uga SET the_geom = ST_transform(the_geom, 3035); 
+ALTER TABLE uga2010.uga ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
+}}} 
+
+