Changes between Version 87 and Version 88 of CookBook join ROE_CCM

Timestamp:

May 6, 2010 5:36:10 PM (15 years ago)

Author:

cedric

Comment:

--

CookBook join ROE_CCM

@@ -225 +225 @@
 With geobs2010.roe_ccm_300, there are two dams (in violet in the East) which are projected in the CCM layer but aren't in France :[[BR]]
 ref_id =21164  an ref_id=49967
+
+the table is used in the loaddb method of BaseEdaCCMriversegmentsROE
+{{{
+SELECT sum(height) AS c_height,sum(score) AS c_score,sum(nbdams) AS nbdams,r.gid AS gid 
+FROM geobs2010.roe_ccm_300 j RIGHT JOIN ccm21.riversegments r 
+ON r.gid=j.gid where wso_id in (select wso_id from france.wso where area='France') 
+  GROUP BY r.gid ORDER BY r.gid ;
+}}}