back to first page ..
back to CookBook Eda

In ArcGis merge the different layers

To find : if it's possible to do it in Postgre (not in Qgis) ?

Add the differents layers on ArcGis : A_RWBody, B1_RWBody, B2_RWBody, C_RWBody, D_RWBody, E_RWBody, F_RWBody, G_RWBody, H_RWBody.

In Data Management Tools > General > Merge

• Input Datasets : A_RWBody, B1_RWBody, B2_RWBody, C_RWBody, D_RWBody, E_RWBody, F_RWBody, G_RWBody, H_RWBody.
• Output Dataset : change the directory if it's necessary and change the name of the shape file : RWBody_Merge.shp

Download the file RWBody_Merge.shp into Postgre

REM se placer dans le répertoire ou sont les données
D:
cd D:\Celine Jouanin\RNABE\France

C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -I RWBody_Merge.shp RWBody > 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

• 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 
  

• Create schema RNABE et changement du schéma de la table RWBody (qui est sous public)

  --- In sql editor 
  CREATE SCHEMA RNABE;
  ALTER TABLE rwbody SET SCHEMA rnabe;
  select SRID (the_geom) FROM rnabe.rwbody;
  

Problème les couches de RNABE et CCM ne se superposent pas --> pas la bonne projection!!

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