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 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 RNABE ... change the port if necessary (cedric : 5433)

        C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0.rnabe -h localhost -U postgres -p 5432 -f RWBodyutf8.sql