Changes between Version 20 and Version 21 of RNABE download and load

Timestamp:

May 25, 2010 9:44:31 AM (15 years ago)

Author:

celine

Comment:

--

RNABE download and load

@@ -26 +26 @@
 C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4258 -I Fr_TWBody_Merge.shp Fr_TWBody > Fr_TWBody.sql
 }}}
-    * Convert it into utf8  (as the database is posgis), in notepad, open the Fr_RWBody.sql file and convert it to utf8
+    * '''Convert it into utf8'''  (as the database is posgis), in notepad, open the Fr_RWBody.sql file and convert it to utf8
 Encodage> Convertir en UTF-8
 
@@ -32 +32 @@
 
 
-    * Use psql to restore the file while connecting to eda2.0 ... change the port if necessary (cedric : 5433)
+    * '''Use psql to restore the file''' while connecting to eda2.0 ... change the port if necessary (cedric : 5433)
 {{{
 C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f Fr_RWBodyutf8.sql
@@ -41 +41 @@
 }}}
 
-    * Create schema RNABE et changement de schéma de la table Fr_RWBody (qui est sous public)
+    * '''Create schema RNABE'' et changement de schéma de la table Fr_RWBody (qui est sous public)
 {{{
 --- In sql editor 
@@ -52 +52 @@
 }}}
 
-== Changement de la projection ==
+   * '''Change the srid'''
 La projection du RNABE est en fait l'ETRS89 et non pas l'ETRS89-LAEA [[BR]]
-Il faut donc changer le srid 4258 (ETRS89) en 3035 ( ) [[BR]]
+Il faut donc changer le srid 4258 (ETRS89) en 3035 (ETRS89-LAEA) [[BR]]
 {{{
--- Problème de script ne fonctionne pas
 ALTER TABLE rnabe.fr_rwbody DROP CONSTRAINT enforce_srid_the_geom;
 UPDATE rnabe.fr_rwbody SET the_geom = ST_transform(the_geom, 3035);