Changes between Version 6 and Version 7 of PATE Anguille

Timestamp:

Feb 1, 2012 5:29:13 PM (13 years ago)

Author:

celine

Comment:

--

PATE Anguille

@@ -12 +12 @@
 
 select count(*) from rht.roe_pate_bv11axes limit 7
+
+---Ajout d'une colonne a_conserver pour ne conserver que les obstacles non aqueduc et bien projetés
+alter table rht.roe_pate_bv11axes add column a_conserver boolean default TRUE;
+update rht.roe_pate_bv11axes set a_conserver=FALSE where id_roe in ('ROE46281','ROE46580','ROE47341','ROE47342',
+'ROE47348','ROE47350','ROE47352','ROE47353','ROE47356','ROE47357','ROE47358','ROE47359','ROE47360','ROE47361','ROE47362',
+'ROE47363','ROE47374','ROE47384','ROE47409','ROE49696','ROE52263','ROE50534');
 
 drop table if exists rht.rhtvs2_roe_pate_bv11axes;