Back to wiki [..]
Back to [wiki:"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">Getting other variables from the ccm</h1>
}}} 
{{{
#!sql
select r.gid,
r.wso1_id,
r.wso_id,
rvr_id,
fromnode,
tonode,
r.strahler,
pfafstette,
length,
cum_len,
drain_km2,
alt_gradie,
cum_len_sea,
c_height,
c_score,
nbdams,
cs_height,
cs_nbdams,
cs_score,
winter,
summer,
c.strahler as strahlermax,
c.area_km2,
elev_mean,
slope_mean,
rain_mean,
temp_mean,
name,
area_cd
FROM ccm21.riversegments r
LEFT JOIN ccm21.catchments c ON r.wso1_id=c.wso1_id
LEFT JOIN ccm21.seaoutlets s ON s.wso_id=r.wso_id
WHERE r.wso_id in (SELECT wso_id FROM france.wso WHERE area='France')
-- temps d'exécution ~ 3 minutes
-- 170703 lines récupérées.
}}}
This request is integrated into the method loadadditional in main_CCM.R
 * source:trunk/EDACCM/main_CCM.R