Changes between Version 9 and Version 10 of Meuse clc

Timestamp:

Jun 12, 2014 5:02:38 PM (11 years ago)

Author:

cedric

Comment:

--

Meuse clc

@@ -223 +223 @@
 );
 }}}
+
+{{{
+-- recopie les données depuis la France (données manquantes)
+select count(*) from clc.surf_area_final where wso1_id in (select wso1_id from europe.wso1 where area='Meuse');--2975
+select count(*) from europe.wso1 where area='Meuse';--3022
+select count(*) from clc.surf_area_meuse;--2011
+
+insert into clc.surf_area_meuse_final 
+select * from clc.surf_area_final where wso1_id in (
+select wso1_id from  clc.surf_area_final where wso1_id in (select wso1_id from europe.wso1 where area='Meuse')
+and wso1_id not in (select wso1_id from clc.surf_area_meuse_final));--1011
+}}}