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

Getting other variables from the ccm

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