back to first page..

wso_id	Bassin versant
291111	Loire

Nombre de bassin versant

select up_area, wso_id from ccm21.riversegments where up_area is not null and nextdownid=-9999
select up_area, wso_id from ccm21.riversegments where nextdownid=-9999 order by up_area

select sum(up_area) from ccm21.riversegments_france where up_area is not null and nextdownid=-9999 and wso_id=291111
select wso_id as id_bassin, up_area as surface from ccm21.riversegments_france where up_area is not null and nextdownid=-9999 order by wso_id

select up_area, wso_id from ccm21.riversegments_france where nextdownid=-9999 order by up_area
select up_area, wso_id, wso1_id from ccm21.riversegments where nextdownid=-9999 order by wso_id

select r.wso_id as id_bassin, up_area as surface, c.wso_id, c.emu from ccm21.riversegments as r inner join rbd_f1v3.bassin_pose as c on c.wso_id=r.wso_id  where up_area is not null and nextdownid=-9999 and c.emu='Western' order by wso_id
select sum(up_area) as surface from ccm21.riversegments as r inner join rbd_f1v3.bassin_pose as c on c.wso_id=r.wso_id  where up_area is not null and nextdownid=-9999 and c.emu='Western'

select r.wso_id as id_bassin, up_area as surface, c.wso_id, c.emu from ccm21.riversegments as r inner join rbd_f1v3.bassin_pose as c on c.wso_id=r.wso_id  where up_area is not null and nextdownid=-9999 and c.emu='Basque' order by wso_id
select sum(up_area) as surface from ccm21.riversegments as r inner join rbd_f1v3.bassin_pose as c on c.wso_id=r.wso_id  where up_area is not null and nextdownid=-9999 and c.emu='Basque'