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

select * from clc.clc00_v2_europe where  the_geom IS NULL;

select count(*) from clc.clc00_v2_europe;  ---2098832

select count(*) as count, code_00  from clc.clc00_v2_europe group by code_00 order by code_00;