created 24/03/2014 objectif= remove missing values from upstream catchments clc

update ccm21.riversegments set  (up_catchment_area,
 up_art_11_13, 
 up_art_14 ,
 up_arable_21 ,
 up_permcrop_22 ,
 up_pasture_23 ,
 up_hetagr_24 ,
 up_forest_31 ,
 up_natural_32_33 ,
 up_wetlands_4 ,
 up_inwat_51 ,
 up_marwat_52 )=(0,0,0,0,0,0,0,0,0,0,0,0) where 
        wso_id in (select wso_id from europe.wso where area= 'Ireland') 
        and strahler=1
        and up_catchment_area is NULL;--4587
-- to check
select * from ccm21.riversegments where wso_id in (select wso_id from europe.wso where area= 'Ireland')
and "up_catchment_area" is null