back to first page [..] [[BR]]
back to ["Corine Land Cover"] [[BR]]
back to ["CLC download and load"] [[BR]]

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

{{{
select * from clc.clc00_v2_europe where  the_geom IS NULL;
}}}