Changes between Version 34 and Version 35 of CookBook join ROE_RHT

Timestamp:

Jan 2, 2012 5:17:01 PM (13 years ago)

Author:

celine

Comment:

--

CookBook join ROE_RHT

@@ -239 +239 @@
 where t.id_drain=sub.id_drain
 }}}
+
+
+-- Vérification --
+{{{
+#!sql
+drop table if exists rht.rht_roe_test;
+create table rht.rht_roe_test as (
+select distinct on (id_drain) id_drain, iddrain, id_roe, idroe from (
+select bd.id_drain, ro.id_drain as iddrain, bd.id_roe, ro.id_roe as idroe from rht.rht_bdcarthage_roev2 bd join rht.rht_roev2 ro on bd.id_roe=ro.id_roe) as sub where iddrain!=id_drain);
+
+alter table rht.rht_roe_test add column the_geom geometry;
+update rht.rht_roe_test set the_geom=roe_v2.the_geom from roe_v2.roe_v2
+ where roe_v2.id_roe=rht_roe_test.idroe; 
+}}}
+Il y a 5695 barrages qui sont potentiellement mal ou pas projetés.  Hum ; difficile de les vérifier à la main un par un.