Changes between Version 5 and Version 6 of Correspondance wso_id Bassin versant

Timestamp:

Jan 16, 2011 6:48:10 PM (14 years ago)

Author:

celine

Comment:

--

Correspondance wso_id Bassin versant

@@ -23 +23 @@
 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'
+
 }}}