back to first page .. back to Corine Land Cover back to CLC download and load

• select the first character in code_00 with substring(code_00 from 1 for 1)

select * from CLC.clc00_v2_europe where substring(code_00 from 1 for 1)='1';

select substring(code_00 from 1 for 1) as code, sum(ST_Area(the_geom)) from clc.clc00_v2_europe group by substring(code_00 from 1 for 1);