back to first page..

"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')

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

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';

---Intégration des barrages non disponibles dans la version publique d'avril 2011 - voir mail Laurent
insert into rht.pate(id_roe,id_drain) values ('ROE64290','122703'),('ROE64330','121476'),('ROE65180','100382'),('ROE66096','104526'),('ROE67681','20379');
---Projection des barrages sur le bon id_drain
insert into rht.pate(id_roe,id_drain) values ('ROE47373','122946'),('ROE47412','123005'),('ROE47382','122667');

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