wiki:model building

Version 27 (modified by cedric, 15 years ago) (diff)

--

Back to wiki .. Back to CookBook Eda

I have to check that this does not suppress any lines....

Model building electrofishing data

First some inclusion of prospection method, ....

source ("aggreg_donnees.R") 

Réintegrating methodeprospection, moyenprospection, ... This is now done in traitement oracle.R I have to check that this does not suppress any lines....

Some variables related to recruitment

  • strahler
  • area_km2
  • elev_mean
  • slope_mean
  • rain_mean
  • temp_mean

[[BR]Variables coming from another calculation

  • The idea here is to have some variables describing the variation in recruitment

The regional sea

  • The sea_cd => this one is obvious, and will describe varying recruitments into the Baltic, the Mediterranean, North sea, unfortunately sea_cd is repeated and probably needs grouping with other variable
    source:data/Docs/trac/CCM21/seaoutlets_sea_cd.jpg

This will create a new column in ccm21.seoutlets

ALTER TABLE ccm21.seaoutlets ADD COLUMN area_cd character varying(3);
UPDATE ccm21.seaoutlets set area_cd= system_cd||sea_cd;

Now that sounds much better :
source:data/Docs/trac/CCM21/seaoutlets_area_cd.jpg

Latidunal distance to the maximum density area

The largest densities are found in the vendée région (source wgeel 2009)
source:data/Docs/trac/cpue_glass_eel.jpg
source:data/Docs/trac/ctot_glass_eel.jpg