wiki:Meuse clc upstream
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= 'Meuse') 
        and strahler=1
        and up_catchment_area is NULL;--1022 a relancer sur le nouveau serveur, je n'ai pas accès
-- to check
select * from ccm21.riversegments where wso_id in (select wso_id from europe.wso where area= 'Meuse')
and "up_catchment_area" is null
Last modified 11 years ago Last modified on Jun 9, 2014 11:39:37 AM