Changes between Version 17 and Version 18 of Joining dams ROE on CCM

Timestamp:

Mar 21, 2011 2:29:37 PM (14 years ago)

Author:

celine

Comment:

--

Joining dams ROE on CCM

@@ -96 +96 @@
 join geobs2010.roe_ccm_500_final f2 on (f1.gid1,f1.distproj_ccm1,f1.dist_sea_ccm1)=(f2.gid,f2.distproj_ccm,f2.dist_sea_ccm) 
  where num>1 
-order by num, distproj_ccm, gid   --22 lignes
+order by num, distproj_ccm, gid   --26 lignes
 }}}
 
+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]]
 {{{
-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)
+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
+
+delete from geobs2010.roe_ccm_500_final_gid where ref_id in (19490,46319,44656,28268,1351,41222,18132,45254,32113,50953,27194,27205,46223,16814,        2148,37320,3299,44105,43933,44660,31523,11516,23932,7925,18277,35738,26295,16968,36528,41456,35815,27980,26988,21748,17325,34879,25841,51625,46010,37184,43448,32398,30628,44841,27309,27328,10369,10371,10372) --- 49 lignes
+
+delete from geobs2010.roe_ccm_500_final_gid where ref_id in (7626,14304,40231,27466,36825,46539,40169,39608,40184,25754,312213,47109,37138,4414,24538,46938,38159,24291,
+28183,7326,11077,10648,25010,24323,46929,41628,25940,17967,11795,51218,24295,11721,5307,33793,26832,13537,46936,6181,30536,41009,22193,28903,4318,46930,46915,46919,8502,15448,46939,46946,46931,49979,46932,4716,46927,8500,6579,17766,23955,41011,41012,20282)  ---61 lignes
 }}}