Changes between Initial Version and Version 1 of Ireland clc upstream

Timestamp:

Mar 24, 2014 11:42:39 AM (11 years ago)

Author:

cedric

Comment:

--

Ireland clc upstream

@@ +1 @@
+
+created 24/03/2014 objectif= remove missing values from upstream catchments clc
+
+{{{
+#!sql
+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
+}}}