Changes between Version 14 and Version 15 of CookBook RHT_UGA

Timestamp:

Feb 2, 2012 3:17:39 PM (13 years ago)

Author:

celine

Comment:

--

CookBook RHT_UGA

@@ -149 +149 @@
 delete from uga2010.id_drain_uga where id_drain in ('402982') and uga='Artois-Picardie';
 delete from uga2010.id_drain_uga where id_drain in ('503639') and uga='Rhin';
-}}}
+
+UPDATE uga2010.id_drain_uga set uga='Adour' where id_drain in ('108801','108802');
+UPDATE uga2010.id_drain_uga set uga='Garonne' where id_drain in ('100194','100151','100147','100123','100124','100102','109173','109156','109157');
+}}}
+
+== RHT par UGA ==
+{{{
+#!sql
+drop table if exists rht.rhtvs2_Adour;
+create table rht.rhtvs2_Adour as (
+select * from rht.rhtvs2 where id_drain in (select id_drain from uga2010.id_drain_uga where uga='Adour')); ---lines
+CREATE INDEX indexid_drainAdour
+ON rht.rhtvs2_Adour
+USING btree (id_drain);
+
+drop table if exists rht.rhtvs2_Bretagne;
+create table rht.rhtvs2_Bretagne as (
+select * from rht.rhtvs2 where id_drain in (select id_drain from uga2010.id_drain_uga where uga='Bretagne')); ---6466lines
+CREATE INDEX indexid_drainBretagne
+ON rht.rhtvs2_Bretagne
+USING btree (id_drain);
+
+drop table if exists rht.rhtvs2_Garonne;
+create table rht.rhtvs2_Garonne as (
+select * from rht.rhtvs2 where id_drain in (select id_drain from uga2010.id_drain_uga where uga='Garonne')); ---lines
+CREATE INDEX indexid_drainGaronne
+ON rht.rhtvs2_Garonne
+USING btree (id_drain);
+
+drop table if exists rht.rhtvs2_Rhin;
+create table rht.rhtvs2_Rhin as (
+select * from rht.rhtvs2 where id_drain in (select id_drain from uga2010.id_drain_uga where uga='Rhin')); ---lines
+CREATE INDEX indexid_drainRhin
+ON rht.rhtvs2_Rhin
+USING btree (id_drain);
+
+drop table if exists rht.rhtvs2_Meuse;
+create table rht.rhtvs2_Meuse as (
+select * from rht.rhtvs2 where id_drain in (select id_drain from uga2010.id_drain_uga where uga='Meuse')); ---lines
+CREATE INDEX indexid_drainMeuse
+ON rht.rhtvs2_Meuse
+USING btree (id_drain);
+
+drop table if exists rht.rhtvs2_Loire;
+create table rht.rhtvs2_Loire as (
+select * from rht.rhtvs2 where id_drain in (select id_drain from uga2010.id_drain_uga where uga='Loire')); ---lines
+CREATE INDEX indexid_drainLoire
+ON rht.rhtvs2_Loire
+USING btree (id_drain);
+
+drop table if exists rht.rhtvs2_SeineNormandie;
+create table rht.rhtvs2_SeineNormandie as (
+select * from rht.rhtvs2 where id_drain in (select id_drain from uga2010.id_drain_uga where uga='Seine-Normandie')); ---lines
+CREATE INDEX indexid_drainSeineNormandie
+ON rht.rhtvs2_SeineNormandie
+USING btree (id_drain);
+
+drop table if exists rht.rhtvs2_Corse;
+create table rht.rhtvs2_Corse as (
+select * from rht.rhtvs2 where id_drain in (select id_drain from uga2010.id_drain_uga where uga='Corse')); ---lines
+CREATE INDEX indexid_drainCorse
+ON rht.rhtvs2_Corse
+USING btree (id_drain);
+
+drop table if exists rht.rhtvs2_ArtoisPicardie;
+create table rht.rhtvs2_ArtoisPicardie as (
+select * from rht.rhtvs2 where id_drain in (select id_drain from uga2010.id_drain_uga where uga='Artois-Picardie')); ---lines
+CREATE INDEX indexid_drainArtoisPicardie
+ON rht.rhtvs2_ArtoisPicardie
+USING btree (id_drain);
+
+drop table if exists rht.rhtvs2_RhoneMediterranee;
+create table rht.rhtvs2_RhoneMediterranee as (
+select * from rht.rhtvs2 where id_drain in (select id_drain from uga2010.id_drain_uga where uga='Rhone-Mediterranee')); ---lines
+CREATE INDEX indexid_drainRhoneMediterranee
+ON rht.rhtvs2_RhoneMediterranee
+USING btree (id_drain);
+}}}