Changes between Version 8 and Version 9 of Lakes


Ignore:
Timestamp:
Oct 19, 2010 11:44:02 AM (15 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Lakes

    v8 v9  
    1212Same wso_id for the lakes 1, 2, 3 and same wso_id for the five riversegment (they are in the same bassin)[[BR]] 
    1313 
     14{{{ 
     15select r.wso_id, r.wso1_id, cont_pixel, upstream_a, l.wso_id from ccm21.riversegments as r inner join ccm21.lakes as l on r.cont_pixel=l.upstream_a and r.wso_id=l.wso_id where r.wso_id=291112 order by cont_pixel 
     16}}} 
     17 
    1418 * Some are on the same river segement --> one cont_pixel in riversegments = one upstream_a 
    1519 * Some cross different river segements --> severals cont_pixel = one upstream_a