Changes between Version 25 and Version 26 of CookBook join ROE_CCMv2

Timestamp:

Nov 27, 2010 10:30:48 PM (14 years ago)

Author:

cedric

Comment:

--

CookBook join ROE_CCMv2

@@ -389 +389 @@
 Manual addition of some dams. When checking the map. Some problems linked with ccm to bd_carthage correspondance appear....
 */
-alter table geobs2010.roe_ccm_500_final add column manual_insert integer;
-update geobs2010.roe_ccm_500_final set manual_insert=0;
 -- pour ressupprimer les id déjà rentrées si on ralonge la liste
 -- delete from geobs2010.roe_ccm_500_final where ref_id in (11498);
-insert into geobs2010.roe_ccm_500_final(
-select distinct on(ref_id) ref_id,
+-- ATTENTION LES COLONNES DOIVENT ETRE REINTEGREES AVEC LEUR NOM DONNEE INSERT INTO (A,B,C...) !
+insert into geobs2010.roe_ccm_500_final (ref_id,
+        gid,
+        id_trhyd,
+        dist_source_bdcar,
+        dist_source_ccm,
+        dist_sea_bdcar,
+        dist_sea_ccm,
+        strahler_bdcar,
+        strahler_ccm,
+        distproj_bdcar,
+        distproj_ccm,
+        height,
+        score,
+        nbdams,
+        the_geom,
+       manual_insert )    (
+        select distinct on(ref_id) ref_id,
         gid,
         id_trhyd,
@@ -406 +420 @@
         min(distproj_ccm) as distproj_ccm,
         height,
-        score,
-        nbdams,
+        score,
+        nbdams,
         the_geom,
         1 as manual_insert        
@@ -415 +429 @@
         group by ref_id, gid,id_trhyd,dist_source_bdcar,dist_source_ccm,dist_sea_bdcar,dist_sea_ccm,strahler_bdcar,strahler_ccm,distproj_bdcar,distproj_ccm,
         the_geom,manual_insert,height,score,nbdams);
+
+
+delete from geobs2010.roe_ccm_500_final where ref_id in (3652,23335,11879,23343,23351,23360,18820,23388,23365,18816,17954,18810,17958,18810,18810,18813,23368,3650,18809,3650,3650,23326,23332,3656);
 
 }}}