Back to wiki .. Back to CookBook Eda

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

#!html <h1 style="color: green">Model building electrofishing data</h1>

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....

#!html <h1 style="color: green">Some variables related to recruitment</h1> #!html <h2 style="color: #66FFCC">variables coming from the ccm21.catchments</h2>

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

#!html <h2 style="color: #66FFCC">variables coming from another calculation</h2>

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

#!html <h3 style="color: #868A08">the regional sea</h3>

• 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;

Now that sounds much better