Changes between Version 40 and Version 41 of OriaEda

Timestamp:

Nov 26, 2010 12:01:04 PM (14 years ago)

Author:

celine

Comment:

--

OriaEda

@@ -233 +233 @@
 -- capture des obstacles de biskaya
 DROP TABLE IF EXISTS oria.obstacles_biskaia_ccm_500;
-CREATE TABLE oria.obstacles_biskaia_ccm_500 as (
+INSERT into oria.obstacles_ccm_500 as (
         SELECT distinct on (COD_Impacto) COD_Impacto , gid, wso1_id, min(distance) as distance, the_geom,height,score,nbdams FROM (
                SELECT COD_Impacto, gid , wso1_id, CAST(distance(r.the_geom, s.the_geom) as  decimal(15,1)) as distance,s.the_geom, 
-                s.ob_height as height,
+                s.Altura as height,
                 s.ob_score_expert As score,
                 1 AS nbdams -- pour jointure ultérieure