Changes between Version 57 and Version 58 of Noeud - parcours RHT

Timestamp:

Jan 19, 2012 6:14:59 PM (13 years ago)

Author:

celine

Comment:

--

Noeud - parcours RHT

@@ -245 +245 @@
 create table rht.rhtvs2_roev2_nbdams as
 select id_drain, count(nbdams) as nbdams from rht.rhtvs2_roev2 as r group by id_drain;
+
+
+select * from roe_v2.roe_geo_v2 where idtrcart is null  ---2625 lignes   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é
+select * from roe_v2.roe_geo_v2 where id_roe in ('ROE3595','ROE35957','ROE58285','ROE5828','ROE58284','ROE35653','ROE3566','ROE35699','ROE35705','ROE35714','ROE35682')
+select * from rht.rhtvs2_roev2 where id_roe in (select id_roe from roe_v2.roe_geo_v2 where idtrcart is null)  ---1710 obstacles
+
+alter table rht.rhtvs2_roev2 add column bdc boolean default FALSE;
+update rht.rhtvs2_roev2 set bdc=TRUE where id_roe in (select id_roe from roe_v2.roe_geo_v2 where idtrcart is null)
+
 }}}