back to first page[..][[BR]]

||wso_id||Bassin versant||
||291194||Adour||
||291223||Artois Picardie||
||85647||Artois Picardie||
||291268||Bretagne||
||291146||Bretagne||
||302127||Bretagne||
||129746||Corse||
||129537||Corse||
||135632||Corse||
||291125||Garonne||
||291126||Garonne||
||291111||Loire||
||291130||Meuse||
||291110||Rhin||
||291112||Rhone||
||291513||Rhone||
||291241||Seine Normandie||
||291115||Seine Normandie||


Nombre de bassin versant 
{{{
#!sql
---France
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

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

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

---Rhone
select r.wso_id as id_bassin, up_area as surface, c.wso_id, c.uga from ccm21.riversegments as r inner join uga2010.wso as c on c.wso_id=r.wso_id  where up_area is not null and nextdownid=-9999 and c.uga='RhoneMediterranee' order by wso_id
select sum(up_area) as surface from ccm21.riversegments as r inner join uga2010.wso as c on c.wso_id=r.wso_id  where up_area is not null and nextdownid=-9999 and c.uga='RhoneMediterranee'

--- Brittany
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='Britanny' 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='Britanny'
---surface différente de :
select sum(area_km2) as surface from ccm21.catchments as r inner join rbd_f1v3.bassin_pose as c on c.wso_id=r.wso_id  where area_km2 is not null and c.emu='Britanny'

---Elbe
select sum(area_km2) as surface from ccm21.catchments as r inner join rbd_f1v3.bassin_pose as c on c.wso_id=r.wso_id  where area_km2 is not null and c.emu='Elbe'

---Anglian
select sum(area_km2) as surface from ccm21.catchments as r inner join rbd_f1v3.bassin_pose as c on c.wso_id=r.wso_id  where area_km2 is not null and c.emu='Anglian'

---Sardinia
select sum(area_km2) as surface from ccm21.catchments as r inner join rbd_f1v3.bassin_pose as c on c.wso_id=r.wso_id  where area_km2 is not null and c.emu='Sardinia'

---Swedish West Coast
select sum(area_km2) as surface from ccm21.catchments as r inner join rbd_f1v3.bassin_pose as c on c.wso_id=r.wso_id  where area_km2 is not null and c.emu='Swedish West Coast'
}}}