Changes between Version 3 and Version 4 of Problems with CLC percentages

Timestamp:

Mar 8, 2011 6:25:30 PM (14 years ago)

Author:

celine

Comment:

--

Problems with CLC percentages

@@ -5 +5 @@
 Some problems with the percentage on each river segment, the sum(p) is not equal to 1 for some of them.
 [[Image(source:data/Docs/trac/clc/erreur.png,600px)]] 
+
+{{{
+select artificial_surfaces_11_13+artificial_vegetated_14+ as S from ccm21.riversegments where wso1_id='346354'
+select forest_31+natural_32_33+wetlands_4+inland_waterbodies_51 as S, catchment_area, (forest_31+natural_32_33+wetlands_4+inland_waterbodies_51)/catchment_area as pS from ccm21.riversegments where wso1_id='346354'
+select * from ccm21.riversegments where wso1_id='346354'
+}}}