Changes between Version 7 and Version 8 of European WISE layers Download and load

Timestamp:

Jul 26, 2010 4:22:21 PM (15 years ago)

Author:

celine

Comment:

--

European WISE layers Download and load

@@ -7 +7 @@
 d:
 cd D:\CelineJouanin\European WISE\wise_coastal_waters_shp
-C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -W LATIN1 -I Coastal_waters.shp costal_waters > costal_waters.sql 
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -I Coastal_waters.shp costal_waters > costal_waters.sql
 cd D:\CelineJouanin\European WISE\wise_rbds_f1v3_shp
-C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -W LATIN1 -I RBD_F1v3.shp RDB_F1v3 > RBD_F1v3.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -I RBD_F1v3.shp rbd_f1v3 > rbd_f1v3.sql
 cd D:\CelineJouanin\European WISE\wise_transitional_waters_shp
-C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -W LATIN1 -I Transitional_waters.shp transitional_waters > transitional_waters.sql
+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 OR[[BR]]
-  * using -W LATIN1, just change the first line to SET CLIENT_ENCODING TO LATIN1;
+  * 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
@@ -26 +25 @@
 cd D:\CelineJouanin\European WISE
 C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f costal_watersutf8.sql 
-C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f RBD_F1v3utf8.sql 
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f rbd_f1v3utf8.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 costal_waters.sql 
-C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f RBD_F1v3.sql 
-C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f transitional_waters.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f costal_watersutf8.sql 
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f RBD_F1v3utf8.sql 
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f transitional_watersutf8.sql
 }}}
 
@@ -39 +38 @@
 --- In sql editor 
 CREATE SCHEMA european_wise2008;
-ALTER TABLE costal_waters SET SCHEMA european_wise;
-ALTER TABLE RBD_F1v3 SET SCHEMA european_wise;
-ALTER TABLE transitional_waters SET SCHEMA european_wise;
+ALTER TABLE costal_waters SET SCHEMA european_wise2008;
+ALTER TABLE rbd_f1v3 SET SCHEMA european_wise2008;
+ALTER TABLE transitional_waters SET SCHEMA european_wise2008;
 }}}