Changes between Version 33 and Version 34 of model building

Timestamp:

May 21, 2010 10:04:22 PM (15 years ago)

Author:

cedric

Comment:

--

model building

@@ -17 +17 @@
 I have to check that this does not suppress any lines....
 
-
+#!html
+<h1 style="color: green">Getting other variables from the ccm</h1>
+}}} 
+{{{
+#!sql
+select r.gid,
+r.wso1_id,
+r.wso_id,
+rvr_id,
+fromnode,
+tonode,
+r.strahler,
+pfafstette,
+length,
+cum_len,
+drain_km2,
+alt_gradie,
+cum_len_sea,
+c_height,
+c_score,
+nbdams,
+cs_height,
+cs_nbdams,
+cs_score,
+winter,
+summer,
+c.strahler as strahlermax,
+c.area_km2,
+elev_mean,
+slope_mean,
+rain_mean,
+temp_mean,
+name,
+area_cd
+ from ccm21.riversegments r
+left join ccm21.catchments c on r.wso1_id=c.wso1_id
+left join ccm21.seaoutlets s on s.wso_id=r.wso_id
+where r.wso_id in (select wso_id from france.wso where area='France')
+}}}