Changes between Version 63 and Version 64 of Noeud - parcours RHT

Timestamp:

Oct 3, 2012 4:56:56 PM (13 years ago)

Author:

celine

Comment:

--

Noeud - parcours RHT

@@ -93 +93 @@
 update rht.rhtvs2 SET nextdownid=id_drainaval from rht.fromnodetonodevs2 ft where id_drain=ft.id_drainamont;
 
-select  * from rht.rhtvs2 where id_drain=nextdownid --0lignes
-update rht.rhtvs2 set nextdownid=-9999 where id_drain=nextdownid --0 lignes
+select  * from rht.rhtvs2 where id_drain=nextdownid --0 lines
+update rht.rhtvs2 set nextdownid=-9999 where id_drain=nextdownid --0 lines
 
 select * from rht.rhtvs2 where noeudmer='t' ---nextdownid null
-update rht.rhtvs2 set nextdownid=-9999 where noeudmer='t' --1082 lignes
+update rht.rhtvs2 set nextdownid=-9999 where noeudmer='t' --1082 lines
 }}}
 
@@ -108 +108 @@
 select id_drain from rht.rhtvs2 except (
 select rt2.id_drain from rht.rhtvs2 rt1 join rht.rhtvs2 rt2 on rt1.nextdownid=rt2.id_drain)
-);-- 57493 lignes
+);-- 57493 lines
 }}}
 
@@ -142 +142 @@
 select distance,id_drain from rht.temp_ltree_distance) as sub
 where t.id_drain=sub.id_drain
-and dmer is null;  --114564 lignes
+and dmer is null;  --114564 lines
 }}}
 [[Image(source:data/Docs/trac/rht/dmervs2.jpg,400px)]] 
@@ -154 +154 @@
 join  rht.noeudmervs2 n on st_intersects(p.the_geom,n.the_geom)) s
 where s.id_drain=n.id_drain; -- 1082
-update rht.noeudmervs2 set zonegeo='Golfe de Gascogne' where zonegeo='Biscaye';  --188 lignes
-select * from rht.noeudmervs2 where zonegeo is null; -- zero lignes
+update rht.noeudmervs2 set zonegeo='Golfe de Gascogne' where zonegeo='Biscaye';  --188 lines
+select * from rht.noeudmervs2 where zonegeo is null; -- zero lines
 }}}
 
@@ -250 +250 @@
 update rht.rhtvs2_roev2_nbdams set score=1;
 
-select * from roe_v2.roe_geo_v2 where idtrcart is null  ---2625 lignes   etanom validé
+select * from roe_v2.roe_geo_v2 where idtrcart is null  ---2625 lines   etanom validé
 select count(etatnom), etatnom from roe_v2.roe_geo_v2 group by etatnom   ---54057 obstacles marqués comme validé.
 select count(etatnom), etatnom from roe_v2.roe_v2 group by etatnom   ---54057 validé
@@ -299 +299 @@
                 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
+where noeudmervs2.id_drain=jointure.id_drain; --100 lines modifiées
 }}}
 
@@ -324 +324 @@
 update rht.rhtvs2 set (dmer, cumnbbar)=(sub.dmer, sub.cumnbbar)
 from (select id_drain,dmer,cumnbbar from rht.noeudmervs2 where dmer is not null and noeudmer) sub
-where sub.id_drain=rhtvs2.id_drain;  ---100 lignes
+where sub.id_drain=rhtvs2.id_drain;  ---100 lines
 
 -- calcul du nb de barrages cumulé sous R et réimport 
@@ -519 +519 @@
   annee numeric
  );
-copy bdmap2009.ers_full_france from 'D:/CelineJouanin/workspace/EDAData/dataEDArht/ers_full_France.csv' with csv header delimiter as ';'  ---23312 lignes
+copy bdmap2009.ers_full_france from 'D:/CelineJouanin/workspace/EDAData/dataEDArht/ers_full_France.csv' with csv header delimiter as ';'  ---23312 lines
 
 SELECT AddGeometryColumn ( 'bdmap2009','ers_full_france','the_geom',3035,'POINT',2);
 update bdmap2009.ers_full_france set the_geom=sub.the_geom from (
 select st_codecsp, id_drain, the_geom from bdmap2009.bdmap_rhtvs2 ) as sub
-where sub.id_drain=ers_full_france.id_drain;   ---23312 lignes modifiées
-}}}
+where sub.id_drain=ers_full_france.id_drain;   ---23312 lines modifiées
+}}}