Changes between Initial Version and Version 1 of Limites administratives Europe

Timestamp:

Jun 3, 2010 5:35:49 PM (15 years ago)

Author:

celine

Comment:

--

Limites administratives Europe

@@ +1 @@
+back to first page [..]
+
+= Download and load the data =
+
+
+Projection : WGS84  (pas la projection ETRS1989-LAEA) --> srid=4326
+{{{
+d:
+cd D:\Celine Jouanin\Limites administratives Europe
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -I european_countries_WGS84.shp limiteeurope > limiteeurope.sql
+}}}
+
+{{{
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f limiteeurope.sql 
+}}}
+
+    * Create schema europe et changement de schéma de la table limiteeurope (qui est sous public)
+{{{
+--- In sql editor 
+CREATE SCHEMA europe;
+ALTER TABLE limiteeurope SET SCHEMA europe;
+}}}
+
+    * Changement du type de projection : WGS84 (srid 4326) --> ETRS1989-LAEA (srid 3035)
+{{{
+ALTER TABLE europe.limiteeurope DROP CONSTRAINT enforce_srid_the_geom;
+UPDATE europe.limiteeurope SET the_geom = ST_transform(the_geom, 3035); 
+ALTER TABLE europe.limiteeurope ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
+}}}