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

Timestamp:

May 25, 2010 9:42:27 AM (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_RW
+cd D:\Celine Jouanin\RNABE\France_RNABE
 }}}
 {{{
 C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4258 -I Fr_RWBody_Merge.shp Fr_RWBody > Fr_RWBody.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4258 -I Fr_CWBody_Merge.shp Fr_CWBody > Fr_CWBody.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4258 -I Fr_GWBody_Merge.shp Fr_GWBody > Fr_GWBody.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4258 -I Fr_LWBody_Merge.shp Fr_LWBody > Fr_LWBody.sql
+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
 Encodage> Convertir en UTF-8
 
-And save the file as : Fr_RWBodyutf8
+And save the file as : Fr_RWBodyutf8, Fr_CWBodyutf8,...
 
 
     * 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 
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f Fr_RWBodyutf8.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f Fr_CWBodyutf8.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f Fr_GWBodyutf8.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f Fr_LWBodyutf8.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f Fr_TWBodyutf8.sql
 }}}
 
@@ -38 +46 @@
 CREATE SCHEMA RNABE;
 ALTER TABLE fr_rwbody SET SCHEMA rnabe;
+ALTER TABLE fr_cwbody SET SCHEMA rnabe;
+ALTER TABLE fr_gwbody SET SCHEMA rnabe;
+ALTER TABLE fr_lwbody SET SCHEMA rnabe;
+ALTER TABLE fr_twbody SET SCHEMA rnabe;
 }}}
 
-Problème les couches de RNABE et CCM ne se superposent pas --> pas la bonne projection!![[BR]]
+== Changement de la projection ==
 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);
+ALTER TABLE rnabe.fr_rwbody DROP CONSTRAINT enforce_srid_the_geom;
+UPDATE rnabe.fr_rwbody SET the_geom = ST_transform(the_geom, 3035); 
+ALTER TABLE rnabe.fr_rwbody ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
+
+ALTER TABLE rnabe.fr_cwbody DROP CONSTRAINT enforce_srid_the_geom;
+UPDATE rnabe.fr_cwbody SET the_geom = ST_transform(the_geom, 3035); 
+ALTER TABLE rnabe.fr_cwbody ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
+
+ALTER TABLE rnabe.fr_gwbody DROP CONSTRAINT enforce_srid_the_geom;
+UPDATE rnabe.fr_gwbody SET the_geom = ST_transform(the_geom, 3035); 
+ALTER TABLE rnabe.fr_gwbody ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
+
+ALTER TABLE rnabe.fr_lwbody DROP CONSTRAINT enforce_srid_the_geom;
+UPDATE rnabe.fr_lwbody SET the_geom = ST_transform(the_geom, 3035); 
+ALTER TABLE rnabe.fr_lwbody ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
+
+ALTER TABLE rnabe.fr_twbody DROP CONSTRAINT enforce_srid_the_geom;
+UPDATE rnabe.fr_twbody SET the_geom = ST_transform(the_geom, 3035); 
+ALTER TABLE rnabe.fr_twbody ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
 }}}
 
-== Autre façon d'importer les données ==
-{{{
-REM se placer dans le répertoire ou sont les données
-D:
-cd D:\Celine Jouanin\RNABE\France_GW
-}}}
-{{{
-C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -I A_GWBody.shp GWBody > GWBody.sql
-C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -I -a B1_GWBody.shp GWBody > GWBody.sql
-C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -I B2_GWBody.shp GWBody > GWBody.sql
-C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -I C_GWBody.shp GWBody > GWBody.sql
-C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -I D_GWBody.shp GWBody > GWBody.sql
-C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -I E_GWBody.shp GWBody > GWBody.sql
-C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -I F_GWBody.shp GWBody > GWBody.sql
-C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -I G_GWBody.shp GWBody > GWBody.sql
-C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -a -I H_GWBody.shp GWBody > GWBody.sql
-}}}
-
-{{{
-C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5432 -f GWBodyutf8.sql 
-}}}