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);
}}}