Changes between Initial Version and Version 1 of European WISE layers Download and load

Timestamp:

Jul 26, 2010 3:00:41 PM (15 years ago)

Author:

celine

Comment:

--

European WISE layers Download and load

@@ +1 @@
+back to first page [..][[BR]]
+back to ["UGA][[BR]]
+
+Data in ETRS1989 LAEA  srid=3035[[BR]]
+
+{{{
+d:
+cd D:\Celine Jouanin\European WISE\wise_coastal_waters_shp
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -I Coastal_waters.shp costal_waters > costal_waters.sql
+cd D:\Celine Jouanin\European WISE\wise_rdbs_f1v3_shp
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -I RDB_F1v3.shp RDB_F1v3 > RDB_F1v3.sql
+cd D:\Celine Jouanin\European WISE\wise_transitional_waters_shp
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -I Transitional_waters.shp transitional_waters > transitional_waters.sql
+}}}
+
+  * We have to convert it into utf8 (as the database is posgis), in notepad, open the uga.sql file and convert it to utf8[[BR]]
+{{{
+Encodage>convertir en utf8
+}}}
+And save the file as : transitional_watersutf8
+
+{{{
+--Céline
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f transitional_watersutf8.sql 
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f transitional_watersutf8.sql 
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f transitional_watersutf8.sql 
+--Cédric
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f ugautf8.sql 
+}}}
+
+    * Create schema uga2010 et changement de schéma de la table uga (qui est sous public)
+{{{
+--- In sql editor 
+CREATE SCHEMA uga2010;
+ALTER TABLE uga SET SCHEMA uga2010;
+}}}
+
+    * 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);
+}}}