Changes between Version 9 and Version 10 of European WISE layers Download and load

Timestamp:

Jul 26, 2010 4:24:48 PM (15 years ago)

Author:

cedric

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 -I Coastal_waters.shp costal_waters > costal_waters.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -W LATIN1 -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 -I RBD_F1v3.shp rbd_f1v3 > rbd_f1v3.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -W LATIN1 -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 -I Transitional_waters.shp transitional_waters > transitional_waters.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -W LATIN1 -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]]
+  * 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]]
+  * jsut change the first line of the script SET CLIENT_ENCODING TO LATIN1;
 {{{
 Encodage>convertir en utf8