Changes between Version 2 and Version 3 of OriaEda

Timestamp:

Nov 22, 2010 6:01:18 PM (14 years ago)

Author:

cedric

Comment:

--

OriaEda

@@ -1 +1 @@
 {{{
-#!sql
+
+  #!sql
 -- Chargement des noeuds mer qui sont en espagne mais n'ont pas été calculés pour la France
 select wso_id from europe.wso where area='Spain'
@@ -22 +23 @@
 intersect (select wso_id from ccm21.seaoutlets where area_cd='A1'); 
 UPDATE europe.wso set area='Spain_Atl' where area IS NULL;
+
+/* 
+creation des tables des stations et des barrages 
+*/
+-- Schema: "oria"
+
+-- DROP SCHEMA oria;
+
+--CREATE SCHEMA oria  AUTHORIZATION postgres;
+
+drop table if exists oria.estaciones_st;
+create table oria.estaciones_st (  
+        st_id character varying(10),
+        st_ecoregion character varying(10),
+        st_river character varying(40),
+        st_name text,
+        st_x numeric,
+        st_y numeric,
+        st_z numeric,
+        st_pk_des numeric,
+        st_date date,
+        st_21fpcomun_num integer,
+        st_nha numeric);
+alter table oria.estaciones_st add constraint  pk_st_id primary key (st_id);
+set client_encoding to 'latin1';
+copy oria.estaciones_st  from 'c:/base/estaciones.csv' with csv delimiter as ';' header; 
+
+drop table if exists oria.operation_op;
+create table oria.operation_op (
+        op_date date,
+        op_st_id character varying(10),
+        op_op_id character varying(10) primary key,
+        st_x numeric,
+        st_y numeric,
+        st_z numeric,
+        st_pk_des numeric,
+        op_surf numeric,
+        op_methodest character varying(30),
+        op_fishingobj character varying(30),
+        op_nbpas integer,
+        op_effort numeric,
+        op_densite numeric,
+        op_nbtot numeric,
+        op_nbp1 numeric,
+        op_nbp2 numeric,
+        op_nbp3 numeric,
+        op_nb150 numeric,
+        op_nb150_300 numeric,
+        op_nb300_450 numeric,
+        op_nb_450_600 numeric,
+        op_nb_600 numeric,
+        op_glass_eel_transport boolean);
+alter table oria.operation_op add constraint  fk_op_st_id foreign key (op_st_id) references oria.estaciones_st(st_id);
 }}}