Changes between Version 4 and Version 5 of River width Anglian

Timestamp:

Aug 2, 2011 3:55:04 PM (14 years ago)

Author:

celine

Comment:

--

River width Anglian

@@ -12 +12 @@
 Alter table ccm_width set schema anglian
 }}}
+
+{{{
+select count(*) from anglian.ccm_width ---1558 lines
+select count(*) from anglian.anglian_station_ccm_500 ---6059 lines
+select count(wso1_id) from anglian.anglian_station_ccm_500 group by wso1_id ---2968 lines
+
+select * from anglian.anglian_station_ccm_500 s join anglian.ccm_width c on c.wso1_id=s.wso1_id ---1438 lines donc 6059-1438=4621 lines sans width
+select * from ccm21.riversegments s join anglian.ccm_width c on c.wso1_id=s.wso1_id where s.wso1_id in (select wso1_id from europe.wso1 where area='Anglian')  ---1091
+select * from ccm21.riversegments s where s.wso1_id in (select wso1_id from europe.wso1 where area='Anglian')  ---1171
+select count(s.wso1_id), min(mean_width) from anglian.anglian_station_ccm_500 s left join anglian.ccm_width c on c.wso1_id=s.wso1_id group by s.wso1_id order by min(mean_width) ---2453 sans river width
+}}}
+
+Il manque des river width pour 4621 opérations (soit 2453 wso1_id) donc un modèle reste à calibrer
+Il manque des river width pour 80 wso1_id sur la ccm pour Anglian.