back to first page [..] [[BR]] [[PageOutline]] = Cook Book EDA = In this section we will report "how to" procedures to do the differents tasks in EDA == Using Posgres == ------------- Where are stored the databases ? ["Database physical storage"][[BR]] Saving and restoring database ["CookBook postgres"][[BR]] How to create a ''' postgres ''' database from a ''' shape file ''' ["CookBook shptopostgres"][[BR]] Exporting from ''' postgres ''' database to a ''' shape file ''' ["CookBook pgsql2shp"][[BR]] Help on Postgis ["CookBook Postgis"][[BR]] Listing tables in a database ["CookBook Postgres Advanced Use"][[BR]] How to connect to postgres with a non-local connection ["Cookbook Postgres Non-local Connection"][[BR]] How to now the ["srid"] in the spatial_ref_sys == Using GIS == ------------- * ["French boundaries"][[BR]][[BR]] * ArcGIS Help on ''' Argis ''' ["CookBook Argis"][[BR]] How to ''' Import layers in Argis ''' ["Cookbook Import layers"][[BR]] How to ''' Select features by locations ''' ["Cookbook Select features by locations"][[BR]] How to ''' Couple points to ligne ''' ["Cookbook Couple points to ligne"][[BR]] * Quantum Gis Help on '''Quantum Gis ''' ["CookBook Quantum Gis"][[BR]] How to change the symbology and classified the data ["CookBook Symbol and Class"][[BR]][[BR]] How to use ''' gdal ''' and ''' rgdal ''' (cedric : partially solved but fails in the end) ["Cookbook gdal"][[BR]] == FTP use == ----------------- Using cemagref FtpServer == EDA == ----------------- === CCM === R main program ["Cookbook Main_CCM"][[BR]] Download and load to postgres the CCM2 layer ["CCM2 download and load"][[BR]] Select only those basins where the eel is present ["CCM2 select"][[BR]] Joining CCM with the french layer ["Cookbook CCM21_France"][[BR]] === BDMAP === Tracing what is done with the BDMAP database [wiki:"BDMAP Changes"] [[BR]] Joining BDMAP and the CCM layer ["CookBook join BDMAP_CCM"][[BR]] Adding additional data from brittany[wiki:"CookBook EpA"] === ROE === Load to postgres the ROE database ["ROE download and load"][[BR]] Joining ROE and the CCM layer ["CookBook join ROE_CCM"] === Temperatures === Load to postgres database ["Temperature download and load"][[BR]] Joining Temperature and the CCM layer (or BDMAP ?) ["CookBook join Temperature_CCM"][[BR]] === RNABE === Load to postgres database ["RNABE download and load"][[BR]] Joining RNABE and the CCM layer ["CookBook join RNABE_CCM"][[BR]] === MODEL BUILDING === Additional data treatment on electrofishing data ["model building"][[BR]] === Corine Land Cover CLC === Load to postgres database ["CLC download and load"][[BR]] CLC Analysis ["CLC Analysis"][[BR]] CLC join ["CLC Join"][[BR]] === Tidal range === Load to postgres database ["Tidal range"][[BR]] === Other variables related to area === Creating a new variable and variables according to the distance from the point where glass eel density is maximum ["River basins"] [[BR]]