wiki:CookBook Eda

Version 142 (modified by cedric, 13 years ago) (diff)

--

back to first page ..

  1. Cook Book EDA
    1. Using Postgres
    2. Using GIS
    3. FTP use
    4. EDA
      1. CCM
      2. BDCarthage
      3. RHT
      4. BDMAP
      5. ROE
      6. Temperatures
      7. RNABE
      8. MODEL BUILDING
      9. Corine Land Cover CLC
      10. Tidal range
      11. UGA
      12. Other variables related to area

Cook Book EDA

In this section we will report "how to" procedures to do the differents tasks in EDA

Using Postgres

Help on Postgres Help on Postgres
Where are stored the databases ? Database physical storage
Saving and restoring database abd other stuffCookBook postgres
How to create a postgres database from a shape file CookBook shptopostgres
Exporting from postgres database to a shape file CookBook pgsql2shp
Help on Postgis CookBook Postgis
Listing tables in a database CookBook Postgres Advanced Use
How to connect to postgres with a non-local connection Cookbook Postgres Non-local Connection
How to now the srid in the spatial_ref_sys
How to export from access to postgres CookBook export access
How to access linux server in IAV CookBook samba
How to connect postgre with ArcGis CookBook Postgre ArcGis connection
How to have the function ST_HausdorffDistance
How to use a graphical database schema metadata browser SchemaDatabase
How to have the new version of Postgre Postgre new version
How to use Geometry functions (st_contains, st_within...)
How to install the new version of Postgre Installing new version of Postgre
How to install PL/R Installing PL/R

R with Postgre

Using GIS

Help on Argis CookBook Argis
How to Import layers in Argis Cookbook Import layers
How to Change the coordinate system Cookbook Change the coordinate system
How to Select features by locations Cookbook Select features by locations
How to Couple points to ligne Cookbook Couple points to ligne
How to Convert labels to annotation Cookbook Convert labels to annotations
How to Extract value to point with a rasterCookboook Extract value to point
How to Add XY Coordinates Add XY Coordinate
How to Access ArcGis from outside
ARCGIS and Postgre ARCGIS and Postgre

  • Quantum Gis

Help on Quantum Gis CookBook Quantum Gis
How to change the symbology and classified the data CookBook Symbol and Class

How to create a new layer with a polygon to select data CookBook Quantum Gis Create polygon
How to use gdal and rgdal (cedric : partially solved but fails in the end) Cookbook gdal
How to use gdal to translate between raster formats Cookbook gdalraster
How to add google layer Cookbook google

QGIS and R QGIS and R

  • Coordinate converter

The world coordinate converter ​http://twcc.free.fr/
French converter - Circe ​http://geodesie.ign.fr/index.php?page=circe

FTP use

Using Cemagref, IAV, ONEMA FtpServer

EDA

CCM

R main program Cookbook Main_CCM
Download and load to postgres the CCM2 layer CCM2 download and load
Select only those basins where the eel is present CCM2 select
Joining CCM with the french layer Cookbook CCM21_France
Joining CCM with the UGA layer Cookbook CCM21_UGA
Joining CCM with the European countries layer Cookbook CCM21_Europe

BDCarthage

RHT

Download and load BDMAP Download and load RHT
Joining BDMAP and the RHT layer CookBook join RHT-BDMAP
Joining UGA and the RHT layer CookBook RHT_UGA
Joining ROE and the RHT layer CookBook join ROE_RHT

BDMAP

Tracing what is done with the BDMAP database BDMAP Changes
Download and load BDMAP Download and load BDMAP
Joining BDMAP and the CCM layer CookBook join BDMAP_CCM and Joining station BDMAP on CCM
The problem of conversion between bdcarthage and EDA CookBook join BDMAP_CCM v2
Adding additional data from brittanyCookBook EpA

ROE

Load to postgres the ROE database ROE download and load
Joining ROE and the CCM layer CookBook join ROE_CCM
Joining ROE and the CCM layer CookBook join ROE_CCMv2
Calculating scaling rate CookBook taux_etagement
Joining ROE and the RHT layer CookBook join ROE_RHT

Temperatures

Load to postgres database Temperature download and load
Joining Temperature and the CCM layer (or BDMAP ?) CookBook join Temperature_CCM

RNABE

Load to postgres database RNABE download and load
Joining RNABE and the CCM layer CookBook join RNABE_CCM

MODEL BUILDING

Additional data treatment on electrofishing data model building

Corine Land Cover CLC

Load to postgres database CLC download and load
CLC Analysis CLC Analysis
CLC join CLC Join
CLC upstream basin calculation CLC upstream

Tidal range

Load to postgres database Tidal range

UGA

Load to postgres database UGA Download and load
Joining UGA and the CCM layer Cookbook CCM21_UGA
Joining UGA and the RHT layer CookBook RHT_UGA

Other variables related to area

River basins Creating a new variable and variables according to the distance from the point where glass eel density is maximum