Changes between Version 16 and Version 17 of RNABE download and load

Timestamp:

May 21, 2010 2:32:04 PM (15 years ago)

Author:

celine

Comment:

--

RNABE download and load

@@ -17 +17 @@
 REM se placer dans le répertoire ou sont les données
 D:
-cd D:\Celine Jouanin\RNABE\France
+cd D:\Celine Jouanin\RNABE\France_RW
 }}}
 {{{
-C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4258 -I RWBody_Merge.shp RWBody > RWBody.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4258 -I Fr_RWBody_Merge.shp Fr_RWBody > Fr_RWBody.sql
 }}}
     * Convert it into utf8  (as the database is posgis), in notepad, open the stationsp.sql file and convert it to utf8
 Encodage> Convertir en UTF-8
 
-And save the file as : RWBodyutf8
+And save the file as : Fr_RWBodyutf8
 
 
     * 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 RWBodyutf8.sql 
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f Fr_RWBodyutf8.sql 
 }}}
 
@@ -37 +37 @@
 --- In sql editor 
 CREATE SCHEMA RNABE;
-ALTER TABLE rwbody SET SCHEMA rnabe;
-select SRID (the_geom) FROM rnabe.rwbody;
+ALTER TABLE fr_rwbody SET SCHEMA rnabe;
 }}}
 
@@ -44 +43 @@
 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]]
-
-
+{{{
+-- Problème de script ne fonctionne pas
+select SRID (the_geom) FROM rnabe.fr_rwbody;
+SELECT addGeometryColunm('fr_rwbody','the_geom',3035,'MULTILINESTRING',2);
+UPDATE rnabe.fr_rwbody SET the_geom = ST_tranform(the_geom,3035);
+}}}
 
 == Autre façon d'importer les données ==