back to first page[..][[BR]]

{{{
"id_roe" in ('ROE50534','ROE65180','ROE66096','ROE47382','ROE47384','ROE64290','ROE47361','ROE47363','ROE47352','ROE46580','ROE47341','ROE47362','ROE49696','ROE47348','ROE47353','ROE47342','ROE47350','ROE47358','ROE47359','ROE47373','ROE47374','ROE47409','ROE47412','ROE64330','ROE47356','ROE47357','ROE47360','ROE46281','ROE52263','ROE67681')
}}}

== Integration des données brutes ==
Access puis :
{{{
alter table "ROE-BV" set schema rht
alter table rht."ROE-BV" rename to roe_pate_bv11axes
alter table rht.roe_pate_bv11axes rename column "Id_ROE" to Id_ROE

select count(*) from rht.roe_pate_bv11axes limit 7

== Ajout des variables du RHT ==
{{{
---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');

--Ajout d'une colonne id_drain
alter table rht.roe_pate_bv11axes add column id_drain integer;
update rht.roe_pate_bv11axes set id_drain=sub.id_drain from 
(select id_drain, id_roe from rht.rhtvs2_roev2) as sub
where sub.id_roe=roe_pate_bv11axes.id_roe;

---Intégration des barrages non disponibles dans la version publique d'avril 2011 - voir mail Laurent
update rht.roe_pate_bv11axes set id_drain='122703' where id_roe='ROE64290';
update rht.roe_pate_bv11axes set id_drain='121476' where id_roe='ROE64330';
update rht.roe_pate_bv11axes set id_drain='100382' where id_roe='ROE65180';
update rht.roe_pate_bv11axes set id_drain='104526' where id_roe='ROE66096';
update rht.roe_pate_bv11axes set id_drain='20379' where id_roe='ROE67681';
---Projection des barrages sur le bon id_drain
update rht.roe_pate_bv11axes set id_drain='122946' where id_roe='ROE47373';
update rht.roe_pate_bv11axes set id_drain='123005' where id_roe='ROE47412';
update rht.roe_pate_bv11axes set id_drain='122667' where id_roe='ROE47382';



drop table if exists rht.rhtvs2_roe_pate_bv11axes;
create table rht.rhtvs2_roe_pate_bv11axes as (
select r.id_drain,t.dmer, module, module_icinf, module_icsup, minqmx, minqmxicinf, minqmxicsup, b.* from rht.rhtvs2_roev2 r	
	join  rht.roe_pate_bv11axes b on r.id_roe=b.Id_ROE 
	join rht.rhtvs2 t on t.id_drain=r.id_drain
	join rht.attributs_rht_fev_2011_vs2 a on r.id_drain=a.id_drain);
}}}


Problèmes d'intégration de la table via (par access ok):
{{{
DROP TABLE IF EXISTS rht.roe_pate_bv11axes;
CREATE TABLE rht.roe_pate_bv11axes
(
  BV character varying(255),
  Numero double precision,
  Id_ROE character varying(255),
  Q_equipement character varying(255),
  XL93 character varying(255),
  YL93 character varying(255),
  Nom character varying(255),
  typeNom character varying(255),
  stypeNom character varying(255),
  staNom character varying(255),
  dateModif character varying(255),
  source character varying(255),
  nomCart character varying(255),
  nomTopo character varying(255),
  commNom character varying(255),
  deptNom character varying(255),
  bassin character varying(255),
  CHCart character varying(255),
  hauteur_ch character varying(255),
  usage1 character varying(255),
  usage2 character varying(255),
  usage3 character varying(255),
  usage4 character varying(255),
  fpi1 character varying(255),
  fpi2 character varying(255),
  fpi3 character varying(255),
  fpi4 character varying(255),
  fpi5 character varying(255),
  note_fr_An character varying(255),
  ouvrage_gr character varying(255),
  ouv_lies character varying(255)
);

---Celine
copy rht.roe_pate_bv11axes from 'D:/CelineJouanin/EDA20RHT/ROE_PATE_BV11axes.csv' with csv header delimiter as ';' NULL AS 'NA'; -- lines
set client_encoding to 'UTF8';
}}}

||id_roe|||| id_drain||
||ROE64290		||pas dans la version ROE publique d'avril 2011||	122703||
||ROE64330		||pas dans la version ROE publique d'avril 2011||	121476||
||ROE65180		||pas dans la version ROE publique d'avril 2011||	100382||
||ROE66096		||pas dans la version ROE publique d'avril 2011||	104526||
||ROE67681		||pas dans la version ROE publique d'avril 2011||	20379||


#A FINIR !!
Ajout un barrage[[BR]]
id_drain in ('122703','122946','123005','122667')[[BR]]

Ajout d'un barrage à tous les segments amont et id_drain correspondant[[BR]]
id_drain in ('121476','100382','104526','20379')[[BR]]