Changes between Initial Version and Version 1 of CLC Analysis

Timestamp:

May 27, 2010 3:50:58 PM (15 years ago)

Author:

celine

Comment:

--

CLC Analysis

@@ +1 @@
+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);
+}}}