Changes between Version 14 and Version 15 of Meuse_dams

Timestamp:

Jun 5, 2014 3:52:25 PM (11 years ago)

Author:

cedric

Comment:

--

Meuse_dams

@@ -103 +103 @@
 CREATE TABLE belge.obstaclescourt as 
   select  site_num, obst_num, code_ori, sousbassin, basin_inf, categorie, noma, province, symbolisat, dat_m_jour, type_obst, revetement, longueur, larg_diam, 
-  hauteur, prof_amont, prof_aval, lame_eau, dif_niveau, import_bio, echelle, obs_id, role_obst FROM belge.obstacles;
-  
+  hauteur, prof_amont, prof_aval, lame_eau, dif_niveau_ouvrage, import_bio, echelle, obs_id, role_obst FROM belge.obstacles;
+
+
 DROP TABLE if exists belge.physical_obstruction CASCADE;
 CREATE TABLE belge.physical_obstruction(
@@ -120 +121 @@
 INSERT INTO belge.physical_obstruction (ob_id,ob_no_origin,ob_no_type,ob_no_period,ob_starting_date, ob_ending_date,ob_op_id,ob_dp_id,ot_no_obstruction_type,
   ot_obstruction_number,ot_no_mortality_type, ot_no_mortality , po_no_obstruction_passability, po_obstruction_height, po_turbine_number, site_num, obst_num, code_ori, sousbassin, basin_inf, categorie, noma, province, symbolisat, dat_m_jour, type_obst, revetement, longueur, larg_diam, 
-  hauteur, prof_amont, prof_aval, lame_eau, dif_niveau, import_bio, echelle, obs_id, role_obst
+  hauteur, prof_amont, prof_aval, lame_eau, dif_niveau_ouvrage, import_bio, echelle, obs_id, role_obst
   )
   SELECT 
@@ -148 +149 @@
   when o.symbolisat is null then 208
   end as po_no_obstruction_passability,
-  o.dif_niveau as po_obstruction_height,
+  o.dif_niveau_ouvrage as po_obstruction_height,
   NULL AS po_turbine_number,o.*
-  FROM                  
+  FROM                  
   belge.obstaclescourt o JOIN  belge.ouvragedbeel d ON o.obs_id=d.obs_id;