Changes between Version 4 and Version 5 of European WISE layers Download and load

Timestamp:

Jul 26, 2010 4:20:15 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 RDB_F1v3 > RBD_F1v3.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -W LATIN1 -I RBD_F1v3.shp RDB_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]]
+  * using -W LATIN1, just change the first line to SET CLIENT_ENCODING TO LATIN1;
 {{{
 Encodage>convertir en utf8