back to first page..
back to Work program - Spain

Some Help see in CookBook Eda

1. Installing all the tools to use the results of EDA model
   

Software required

• PostgresSQL, QGIS, PostGIS
  PostgreSQL 8.4: ​http://www.postgresql.org/
  QGIS ​http://www.qgis.org/
  

​http://qgis.org/en/documentation/manuals.html

PostGIS for 8.4 ​http://postgis.refractions.net/download/windows/

More help see : Help on Postgres, CookBook Postgis, CookBook Quantum Gis

• Eclipse (StatET perspective), SVN and R
  Eclipse ​http://www.eclipse.org/downloads/
  StatET perspective: We need to install a new software in Eclipse: StatET (repository: ​http://www.walware.de/goto/statet)
  

Go to Help --> Install New Software and there click on Add:
Name: StatET
Site: ​http://download.walware.de/Eclipse3.7 (because we have this version of Eclipse intalled in the server. Otherwise, download the corresponding file)
Next step is to chose all the type filter text and click Next. It takes a while installing all these things

SVN Then we need to open a new project, called EDA as an StatET perspective and then we will need to install SVN in Eclipse in order to restore this folder directly from Céline's directory

To do so, we need to install new software again, following the same steps of the previous installation, but now using the name:SVN and the location: ​http://subclipse.tigris.org/update_1.6.x

R: ​http://cran.r-project.org/bin/windows/base/ --> last version installed R 2.14.1

Installation of the R Packages of RJ and rJava (the last one directly by using the install packages on R)
It is important to pick the RJ package version/repository compatible to the used StatET version!
To install the package from the repository, use the following command in a common R Term console:
For RJ 1.0 (StatET 2.0): install.packages(c("rj", "rj.gd"), repos="​http://download.walware.de/rj-1.0")

Once everything is installed, we need to import the files (EDA/trunk and EDAData) from the repository (​svn://svn.eptb-vilaine.fr)
To do so: we need to right click on the project and select import from SVN (Checkout Projects from SVN) by using the repository given above
Finally, we need to configure the run in an R console. To do so we need to click on the run button, select 'Run configuration' and the following window will be opened and should be completed as it is in the next image:

NOTE: the working directory in this picture is the gemac folder, but we need to choose the right one in each case

We need to go to the R Config slide and Add a new configuration with the details shown in the next figure:

• Access to the trac/wiki for EDA –a password is required and has been created for each partners
  
  
• Teamviewer6 to make easier exchanges between partners ​http://www.teamviewer.com/es/download/currentversion.aspx
  
  

Library

• Stacomirtools ​http://trac.eptb-vilaine.fr:8066/tracstacomi/browser/trunk/sources/0.4/R2.14.1/stacomirtools_0.2.zip
  
  
• FSA ​http://www.rforge.net/FSA/files/

Create database into Postgres:

Saving and loading the database with Eider

Join Postgis with postgres

• Inicio windows- panel de control- herramientas administrativas- orígenes de datos ODBC- agregar
  
• postgreSQL ODBC Driver (UNICODE)- Finalizar
  
  • data source: nombre de la base de datos eda2.0
    
  • database: eda2.0
    
  • server: localhost
    
  • username: postgres
    
  • descript: eda2.0
    
  • SSL Mode: disable
    
  • port: 5436
    
  • pasword: postgres
  • Test
  • conexion succesful
• Inicio windows- panel de control- herramientas administrativas- orígenes de datos ODBC- agregar
  
• postgreSQL ODBC Driver (UNICODE)- FInalizar
  
  • data source: dbeel
    
  • database: dbeel
    
  • server: localhost
    
  • username: postgres
    
  • descript: dbeel
    
  • SSL Mode: disable
    
  • port: 5436
  • pasword: postgres
  • Test
  • conexion succesful

Restore the database (ejecutar en la consola de windows; cmd)

cd ..
cd C:\EDA_Spain\export_table
C:\"Archivos de programa"\PostgreSQL\8.4\bin\psql -U postgres -h localhost --dbname "eda2.0" --file "oria.sql"
C:\"Archivos de programa"\PostgreSQL\8.4\bin\psql -U postgres -h localhost --dbname "eda2.0" --file "ccm21.sql"
C:\"Archivos de programa"\PostgreSQL\8.4\bin\psql -U postgres -h localhost --dbname "eda2.0" --file "clc.sql"
C:\"Archivos de programa"\PostgreSQL\8.4\bin\psql -U postgres -h localhost --dbname "eda2.0" --file "europe.sql"
C:\"Archivos de programa"\PostgreSQL\8.4\bin\psql -U postgres -h localhost --dbname "eda2.0" --file "rbd_f1v3.sql"
C:\"Archivos de programa"\PostgreSQL\8.4\bin\psql -U postgres -h localhost --dbname "eda2.0" --file ecoregion2003.sql
C:\"Archivos de programa"\PostgreSQL\8.4\bin\psql -U postgres -d dbeel -p 5432 -f dbeel_12032010.sql

Create the conexion Qgis-eda2.0 database

• add postgis tables
  
• new
  
  • name: eda2.0
    
  • service:
    
  • Host: localhost
    
  • Port: 5436
    
  • Database: eda2.0
    
  • SSL mode: prefer
    
  • Username: postgres
    
  • Password: postgres
    
  • Marck: save username; save pasword; also list tables with no geometry
    
  • OK, connect
    

Create the conexion Qgis-dbeel database

• add postgis tables
  
• new
  
  • name: dbeel
    
  • service:
    
  • Host: localhost
    
  • Port: 5436
    
  • Database: dbeel
    
  • SSL mode: prefer
    
  • Username: postgres
    
  • Password: postgres
    
  • Marck: save username; save pasword; also list tables with no geometry
    
  • OK, connect