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)

{{{
#!sql
select * from CLC.clc00_v2_europe where substring(code_00 from 1 for 1)='1';
}}}

{{{
#!sql
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);
}}}

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

{{{
#!sql
select count(*) from clc.clc00_v2_europe;  ---2098832
}}}

{{{
#!sql
select count(*) as count, code_00  from clc.clc00_v2_europe group by code_00 order by code_00;
}}}