Changes between Version 21 and Version 22 of Joining dams ROE on CCM

Timestamp:

Mar 21, 2011 3:45:03 PM (14 years ago)

Author:

celine

Comment:

--

Joining dams ROE on CCM

@@ -25 +25 @@
 update geobs2010.roe_ccm_500_final_gid SET gid='324115' where ref_id='20881';
 update geobs2010.roe_ccm_500_final_gid SET gid='322893' where ref_id='19021';
-
-
---Supression des doublons
---gid 298703
-delete from geobs2010.roe_ccm_500_final_gid where ref_id in (select r.ref_id from geobs2010.roe_ccm_500_final r inner join geobs2010.obstacle_referentiel o on o.ref_id=r.ref_id where gid='298703' and ref_sta_id is null)
---gid 293773
-delete from geobs2010.roe_ccm_500_final_gid where ref_id in (
-
 }}}
 
@@ -102 +94 @@
 
 On conserve les obstacles où il y a le plus de données disponibles et avec le ref_id le plus élevé.[[BR]]
-#6646 à garder 6647 à supprimer [[BR]]
-#21610 à garder 21611 à supprimer [[BR]]
 #A voir 27676, 27677, 27678  27676 à conserver ? Peut-être est-ce deux obstacles différents (pas le même nom) mais ont des localisation identiques [[BR]]
 {{{
+
+--Supression des doublons
+--gid 298703
+delete from geobs2010.roe_ccm_500_final_gid where ref_id in (select r.ref_id from geobs2010.roe_ccm_500_final r inner join geobs2010.obstacle_referentiel o on o.ref_id=r.ref_id where gid='298703' and ref_sta_id is null)
+
 delete from geobs2010.roe_ccm_500_final_gid where ref_id in (50516,6186,6647,21611,22199,24332,24425,27676,27677,28517,48653,5560,5561,24211)  ---14 lignes