Changes between Version 42 and Version 43 of Noeud - parcours RHT

Timestamp:

Jan 5, 2012 5:44:21 PM (13 years ago)

Author:

celine

Comment:

--

Noeud - parcours RHT

@@ -241 +241 @@
 alter table rht.noeudmervs2 add column wso1_id integer;
 
-
 update rht.noeudmervs2 set (cumnbbar,dmer,wso1_id)= (jointure.cs_nbdams,jointure.cum_len_sea,jointure.wso1_id) from
-        -- resultat final de la jointure spatiale entre ccm et noeudfrontiere
-        (select distinct on (id_drain) id_drain, min(distance) as distance, wso1_id,cs_nbdams, cum_len_sea from (
-                -- requete intermédiaire dont on prend le min (sub)
-                select id_drain, ST_distance(noeudfrontiere.the_geom,ccmrs.the_geom) as distance,ccmrs.*
-                FROM ccm.riversegments_france ccmrs join
-                (select id_drain, the_geom from rht.noeudmervs2 where noeudmer and zonegeo in ('Est','pyrénées')) as noeudfrontiere
-                on ST_DWithin(noeudfrontiere.the_geom,ccmrs.the_geom, 500)) as sub
-        group by id_drain, distance, wso1_id,cs_nbdams, cum_len_sea) as jointure
-where noeudmer.id_drain=jointure.id_drain; --100 lignes modifiées
+        -- resultat final de la jointure spatiale entre ccm et noeudfrontiere
+        (select distinct on (id_drain) id_drain, min(distance) as distance, wso1_id,cs_nbdams, cum_len_sea from (
+                -- requete intermédiaire dont on prend le min (sub)
+                select id_drain, ST_distance(noeudfrontiere.the_geom,ccmrs.the_geom) as distance,ccmrs.*
+                FROM ccm.riversegments_france ccmrs join
+                (select id_drain, the_geom from rht.noeudmervs2 where noeudmer and zonegeo in ('Est','pyrénées')) as noeudfrontiere
+                on ST_DWithin(noeudfrontiere.the_geom,ccmrs.the_geom, 500)) as sub
+        group by id_drain, distance, wso1_id,cs_nbdams, cum_len_sea) as jointure
+where noeudmervs2.id_drain=jointure.id_drain; --100 lignes modifiées
 }}}