wiki:RNABE download and load

Version 3 (modified by celine, 15 years ago) (diff)

--

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

D:
cd D:\Celine Jouanin\RNABE\France
C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 27572 RWBody_Merge.shp RWBody > RWBody.sql