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

Timestamp:

Jan 7, 2011 2:58:41 PM (14 years ago)

Author:

celine

Comment:

--

Correspondance wso_id Bassin versant

@@ -6 +6 @@
 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
@@ -15 +16 @@
 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'