Changes between Version 5 and Version 6 of CookBook taux_etagement

Timestamp:

Nov 29, 2010 1:36:18 PM (14 years ago)

Author:

cedric

Comment:

--

CookBook taux_etagement

@@ -83 +83 @@
  alter table ccm21.taux_etagement add CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTIPOLYGON'::text OR the_geom IS NULL);
  alter table ccm21.taux_etagement add CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
+
+-- par bv
+ drop table if exists ccm21.bretagne_test;
+create table ccm21.bretagne_test as (
+        select te.*,c0.the_geom from ccm21.catchments_bretagne c0 join (
+                select c.wso1_id,
+                cs_height as ddh,
+                 fromnode.elev -tonode.elev as dnh,
+                 CASE WHEN (fromnode.elev -tonode.elev)=0 then NULL
+                 ELSE  cs_height /(fromnode.elev -tonode.elev)
+                 END as te
+                 from ccm21.catchments_bretagne c
+                join ccm21.riversegments_bretagne r on r.wso1_id=c.wso1_id
+                join ccm21.rivernodes fromnode on r.fromnode=fromnode.id
+                join ccm21.rivernodes tonode on r.tonode=tonode.id
+                ) as te
+        on te.wso1_id=c0.wso1_id);
+alter table ccm21.bretagne_test add column id serial;
+ alter table ccm21.bretagne_test add CONSTRAINT bretagne_test_pkey PRIMARY KEY (id);
+ alter table ccm21.bretagne_test add CONSTRAINT enforce_dims_the_geom CHECK (st_ndims(the_geom) = 2);
+
+
+
  
 }}}