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')