back to first page[..][[BR]] back to ["Work program - Spain"][[BR]] Some Help see in ["CookBook Eda"] 1. Installing all the tools to use the results of EDA model [[BR]] = Software required = - PostgresSQL, QGIS, PostGIS [[BR]] '''PostgreSQL 8.4''': http://www.postgresql.org/ [[BR]] '''QGIS''' http://www.qgis.org/ [[BR]] http://qgis.org/en/documentation/manuals.html [[BR]] '''PostGIS for 8.4''' http://postgis.refractions.net/download/windows/ [[BR]][[BR]] More help see : ["Help on Postgres"], ["CookBook Postgis"], ["CookBook Quantum Gis"][[BR]][[BR]] - Eclipse (StatET perspective), SVN and R [[BR]] '''Eclipse''' http://www.eclipse.org/downloads/ [[BR]] '''StatET''' perspective: We need to install a new software in Eclipse: StatET (repository: http://www.walware.de/goto/statet) [[BR]] Go to Help --> Install New Software and there click on Add: [[BR]] Name: StatET [[BR]] Site: http://download.walware.de/Eclipse3.7 (because we have this version of Eclipse intalled in the server. Otherwise, download the corresponding file) [[BR]] Next step is to chose all the type filter text and click Next. It takes a while installing all these things [[BR]] '''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 [[BR]] 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 [[BR]] '''R''': http://cran.r-project.org/bin/windows/base/ --> last version installed R 2.14.1 [[BR]] Installation of the R Packages of RJ and rJava (the last one directly by using the install packages on R) [[BR]] It is important to pick the RJ package version/repository compatible to the used StatET version! [[BR]] To install the package from the repository, use the following command in a common R Term console: [[BR]] For RJ 1.0 (StatET 2.0): install.packages(c("rj", "rj.gd"), repos="http://download.walware.de/rj-1.0") [[BR]] Once everything is installed, we need to import the files (EDA/trunk and EDAData) from the repository (svn://svn.eptb-vilaine.fr) [[BR]] 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 [[BR]] 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: [[BR]] [[Image(source:data/Docs/trac/EDASpain/Image1a_RunConfig.jpg,600px)]] [[BR]] NOTE: the working directory in this picture is the gemac folder, but we need to choose the right one in each case [[BR]] We need to go to the R Config slide and Add a new configuration with the details shown in the next figure: [[BR]] [[Image(source:data/Docs/trac/EDASpain/Image2_RunConfig.jpg,600px)]] [[BR]][[BR]] - Access to the '''trac/wiki''' for EDA –a password is required and has been created for each partners [[BR]][[BR]] - '''Teamviewer6''' to make easier exchanges between partners http://www.teamviewer.com/es/download/currentversion.aspx [[BR]][[BR]] = Library = - '''Stacomirtools''' http://trac.eptb-vilaine.fr:8066/tracstacomi/browser/trunk/sources/0.4/R2.14.1/stacomirtools_0.2.zip [[BR]][[BR]] - '''FSA''' http://www.rforge.net/FSA/files/ = Create database into Postgres: = ["Saving and loading the database with Eider"][[BR]] = Join Qgis with postgres = - Inicio windows- panel de control- herramientas administrativas- orígenes de datos ODBC- agregar [[BR]] - postgreSQL ODBC Driver (UNICODE)- Finalizar [[BR]] - data source: nombre de la base de datos eda2.0 [[BR]] - database: eda2.0 [[BR]] - server: localhost [[BR]] - username: postgres [[BR]] - descript: eda2.0 [[BR]] - SSL Mode: disable [[BR]] - port: 5436 [[BR]] - pasword: postgres - Test - conexion succesful - Inicio windows- panel de control- herramientas administrativas- orígenes de datos ODBC- agregar [[BR]] - postgreSQL ODBC Driver (UNICODE)- FInalizar [[BR]] - data source: dbeel [[BR]] - database: dbeel [[BR]] - server: localhost [[BR]] - username: postgres [[BR]] - descript: dbeel [[BR]] - SSL Mode: disable [[BR]] - port: 5436 - pasword: postgres - Test - conexion succesful = Restore the database (ejecutar en la consola de windows; cmd) = {{{ #!sql 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 [[BR]] - new [[BR]] - name: eda2.0 [[BR]] - service: [[BR]] - Host: localhost [[BR]] - Port: 5436 [[BR]] - Database: eda2.0 [[BR]] - SSL mode: prefer [[BR]] - Username: postgres [[BR]] - Password: postgres [[BR]] - Marck: save username; save pasword; also list tables with no geometry [[BR]] - OK, connect [[BR]] = Create the conexion Qgis-dbeel database = - add postgis tables [[BR]] - new [[BR]] - name: dbeel [[BR]] - service: [[BR]] - Host: localhost [[BR]] - Port: 5436 [[BR]] - Database: dbeel [[BR]] - SSL mode: prefer [[BR]] - Username: postgres [[BR]] - Password: postgres [[BR]] - Marck: save username; save pasword; also list tables with no geometry [[BR]] - OK, connect [[BR]]