back to first page..

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

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