back to first page..
back to Corine Land Cover
see CLC Join

Some problems with the percentage on each river segment, the sum(p) is not equal to 1 for some of them.

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'