Changes between Version 1 and Version 2 of Correspondance wso_id Bassin versant

Timestamp:

Jan 7, 2011 2:43:26 PM (14 years ago)

Author:

celine

Comment:

--

Correspondance wso_id Bassin versant

@@ -3 +3 @@
 ||wso_id||Bassin versant||
 ||291111||Loire||
+
+
+{{{
+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
+}}}