Changes between Version 6 and Version 7 of BDCarthage2011 into eda2.0_RHT

Timestamp:

Sep 27, 2011 5:29:04 PM (14 years ago)

Author:

celine

Comment:

--

BDCarthage2011 into eda2.0_RHT

@@ -44 +44 @@
 create table rht.rht_bdcarthage_200 as select r.*, id_bdcarth as gidbdc from rht.rht_200 r join bd_carthage2011.troncon_hydrographique bdc on ST_contains(r.the_geom,bdc.the_geom) order by id_drain;
 }}}
+
+=== Bretagne ===
+{{{
+drop table if exist uga2010.wso;
+
+drop table  if exists uga2010.id_drain;
+     CREATE TABLE uga2010.id_drain (
+     id serial PRIMARY KEY,
+     id_drain integer,
+     uga varchar(25)
+     );
+
+ --Bretagne
+    insert into uga2010.id_drain(id_drain) 
+    select distinct on (id_drain) id_drain from rht.rht r
+    join (SELECT ST_Union(f.the_geom) as singlegeom
+        FROM uga2010.uga As f where libelle='Bretagne') as sub
+    ON ST_Intersects(sub.singlegeom,r.the_geom);
+
+    UPDATE uga2010.id_drain set uga='Bretagne' where uga IS NULL -- 6468 lignes
+}}}