back to first page..
back to Anglian

create schema anglian;

D:
cd D:\CelineJouanin\RiverWidthWesternAnglian
C:\"Program Files"\PostgreSQL\8.4\bin\psql  -U postgres --dbname "eda2.0" -f "ccm_width.sql"
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.