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

variables coming from the ccm21.catchments

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

  variables coming from another calculation

• The idea here is to have some variables describing the variation in recruitment
• 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
  

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;